1 / 5

Select single and Select up to 1 rows

To read exact record from database table we need to provide all key fields.thttps://www.ducatindia.com/Best-sap-erp-training/

ducathub
Télécharger la présentation

Select single and Select up to 1 rows

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. WELCOME TO DUCAT INDIA Language | Industrial Training | Digital Marketing | Web Technology | Testing+ | Database |  Networking | Mobile Application | ERP | Graphic | Big Data | Cloud Computing Select single and Select up to 1 rows 7070905090 info@ducatindia.com

  2. Select single and Select up to 1 rows

  3. Example SELECT SINGLE DATA : WA_MARA TYPE MARA. " Declare work area SELECT SINGLE * FROM MARA INTO WA_MARA WHERE MATNR = '0001'. " Read exact record from MARA table write :wa_mara-matnr, wa_mara-mtart, wa_mara-meins. " Print data to screen Example SELECT UPTO DATA : WA_MARA TYPE MARA. " Declare work area SELECT * FROM MARA INTO WA_MARA UP TO 1 ROWS WHERE MTART = 'FERT'. " Read appropriate record from MARA table here MTART is not a keyfield ENDSELECT.

  4. We can read multiple records using SELECT UPTO DATA : IT_MARA TYPE TABLE OF MARA. " Declare internal table DATA : WA_MARA TYPE MARA. " Declare work area SELECT * FROM MARA INTO WA_MARA UP TO 50 ROWS WHERE MTART = 'FERT'. " Read 50 appropriate records from MARA table here MTART is not a keyfield ENDSELECT. LOOP AT IT_MARA INTO WA_MARA. write :/ wa_mara-matnr, wa_mara-mtart, wa_mara-meins. " Print data to screen ENDLOOP.

  5. THANK YOU Select single and Select up to 1 rows 7070905090 info@ducatindia.com

More Related