Select single and Select up to 1 rows

Select single and Select up to 1 rows

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.

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.

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

Select single and Select up to 1 rows

Select single and Select up to 1 rows

Presentation Transcript

RE4008 - “SELECT”

DVB SELECT

1. Select “Option”

(1) Select

Select Team Offense: Single and Classic Inverts

Select and Stumble:

SELECT Statement

OrgSpan Select

…..Select

Select Bronco

SELECT-OPTIONS

MSEA and Select

Select Logic

Go to classzone Select High School Math Select TX Select Go

SELECT

1. Select scenario

Loans and Mortgage Tools – Select 1

SELECT

Select

1. Select Study Sites

Up to 28% off select fragrances

Up to 50% Off Select Gowns