ABAP Select data from SAP table /SAPSLL/CUSWLD_IFACE_CONTROL_S into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP /SAPSLL/CUSWLD_IFACE_CONTROL_S table and store it within an internal table, including using the newer @DATA inline declaration methods. It also shows you various ways to process this data using ABAP work area, inline declaration or field symbols including executing all the relevant CONVERSION_EXIT routines specific to /SAPSLL/CUSWLD_IFACE_CONTROL_S. See here for more generic Select statement tips.
Sometimes data within SAP is stored within the database table in a different format to what it is displayed to the user. These input/output conversation FM routines are what translates the data between the two formats.
There is also a full declaration of the /SAPSLL/CUSWLD_IFACE_CONTROL_S table where each field has a char/string type for you to simply copy and paste. This allows you to use processing that is only available to these field types such as the CONCATENATE statement.
DATA: IT_/SAPSLL/CUSWLD_IFACE_CONTROL_S TYPE STANDARD TABLE OF /SAPSLL/CUSWLD_IFACE_CONTROL_S,
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S TYPE /SAPSLL/CUSWLD_IFACE_CONTROL_S,
GD_STR TYPE STRING.
DATA: lo_typedescr type REF TO cl_abap_typedescr.
DATA: lv_fieldname type fieldname.
FIELD-SYMBOLS: <FIELD> TYPE any.
FIELD-SYMBOLS: </SAPSLL/CUSWLD_IFACE_CONTROL_S> TYPE /SAPSLL/CUSWLD_IFACE_CONTROL_S.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_/SAPSLL/CUSWLD_IFACE_CONTROL_S.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM /SAPSLL/CUSWLD_IFACE_CONTROL_S
INTO TABLE IT_/SAPSLL/CUSWLD_IFACE_CONTROL_S.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM /SAPSLL/CUSWLD_IFACE_CONTROL_S
* INTO TABLE @DATA(IT_/SAPSLL/CUSWLD_IFACE_CONTROL_S2).
*--Further methods of using ABAP code to select data from SAP database tables
*You can also declare the header/work area using the in-line DATA declaration method
READ TABLE IT_/SAPSLL/CUSWLD_IFACE_CONTROL_S INDEX 1 INTO DATA(WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SAPSLL/CUSWLD_IFACE_CONTROL_S ASSIGNING </SAPSLL/CUSWLD_IFACE_CONTROL_S>.
*To update a field value using a field symbol simply change the value via the field symbol pointer</SAPSLL/CUSWLD_IFACE_CONTROL_S>-TRTYP = 1.
</SAPSLL/CUSWLD_IFACE_CONTROL_S>-SRVLL = 1.
</SAPSLL/CUSWLD_IFACE_CONTROL_S>-FTORG = 1.
</SAPSLL/CUSWLD_IFACE_CONTROL_S>-FTVBS = 1.
</SAPSLL/CUSWLD_IFACE_CONTROL_S>-LGREG = 1.
ENDLOOP. LOOP AT IT_/SAPSLL/CUSWLD_IFACE_CONTROL_S INTO WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-PROCS, sy-vline,
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-PROSS, sy-vline,
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-PROSA, sy-vline,
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-CUHDA, sy-vline,
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-CUITA, sy-vline,
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-INDEI, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S you want to display... WRITE:/ sy-uline. * Aternatively use generic code to Write field values (and NAME) to screen report DO. ASSIGN COMPONENT sy-index OF STRUCTURE wa_/SAPSLL/CUSWLD_IFACE_CONTROL_S TO <field>. IF sy-subrc <> 0. EXIT. ENDIF. WRITE:/ 'Field Value', <field>, sy-vline. gd_str = <field> . lo_typedescr ?= CL_ABAP_DATADESCR=>DESCRIBE_BY_DATA( <field> ). lv_fieldname = lo_typedescr->GET_RELATIVE_NAME( ). WRITE:/ 'Field Name', lv_fieldname. ENDDO. *Redo loop but convert all fields from internal to out value LOOP AT IT_/SAPSLL/CUSWLD_IFACE_CONTROL_S INTO WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S. *Write horizonal line to screen report. WRITE:/ sy-uline. *Convert all fields to display/output versions using conversion routines PERFORM convert_all_field_values CHANGING wa_EKKO. ENDLOOP. *&---------------------------------------------------------------------* *& Form convert_all_field_values *&---------------------------------------------------------------------* FORM convert_all_field_values CHANGING p_EKKO LIKE wa_EKKO. DATA: ld_input(1000) TYPE c, ld_output(1000) TYPE C.
*Conversion exit ALPHA, internal->external for field FTORG CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-FTORG IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-FTORG.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field FTVBS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-FTVBS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S-FTVBS.
WRITE:/ 'New Value:', ld_input.
ENDFORM. *&---------------------------------------------------------------------* *& Form process_as_string_field_values *&---------------------------------------------------------------------* FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO. TYPES: BEGIN OF T_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR,
TRTYP TYPE STRING,
SRVLL TYPE STRING,
FTORG TYPE STRING,
FTVBS TYPE STRING,
LGREG TYPE STRING,
PROCS TYPE STRING,
PROSS TYPE STRING,
PROSA TYPE STRING,
CUHDA TYPE STRING,
CUITA TYPE STRING,
INDEI TYPE STRING,
LGREG_TXT TYPE STRING,
PROSS_TXT TYPE STRING,
PROSA_TXT TYPE STRING,
FTORG_TXT TYPE STRING,
FTVBS_TXT TYPE STRING,
REPORT TYPE STRING,
DVARIANT_HANDLE TYPE STRING,
DVARIANT TYPE STRING,
OBJ_CUSWLD TYPE STRING,
CRIT_CUSWLD TYPE STRING,
MANDT TYPE STRING,
GUID_CUSWLO TYPE STRING,
MDDNO TYPE STRING,
MDDYR TYPE STRING,
MDDIN TYPE STRING,
MDDSY TYPE STRING,
MDDAP TYPE STRING,
MDOBJ TYPE STRING,
LGREG TYPE STRING,
GUID_FTORG TYPE STRING,
GUID_FTVBS TYPE STRING,
MOVTY TYPE STRING,
MDDPM TYPE STRING,
MDCCL TYPE STRING,
TEMST TYPE STRING,
ECPID TYPE STRING,
CSTAT TYPE STRING,
PRVSY TYPE STRING,
GUID_PR TYPE STRING,
OPQUA_FLT TYPE STRING,
MDBUQ_FLT TYPE STRING,
BAUOM TYPE STRING,
MDWGR_FLT TYPE STRING,
MDWNT_FLT TYPE STRING,
MDWEI TYPE STRING,
MDDDT TYPE STRING,
MDPDT TYPE STRING,
MDCDT TYPE STRING,
DLDNO TYPE STRING,
DLDIN TYPE STRING,
DLDSY TYPE STRING,
DLDAP TYPE STRING,
DLOBJ TYPE STRING,
PODNO TYPE STRING,
PODIN TYPE STRING,
PODSY TYPE STRING,
PODAP TYPE STRING,
POOBJ TYPE STRING,
CREFT TYPE STRING,
CREFN TYPE STRING,
PARVD TYPE STRING,
PARGS TYPE STRING,
PAFVD TYPE STRING,
PAFGS TYPE STRING,
INCOT TYPE STRING,
INCOLO TYPE STRING,
CUPRO TYPE STRING,
CUCOO TYPE STRING,
MDENQ_FLT TYPE STRING,
ENUOM TYPE STRING,
MDOPQ_FLT TYPE STRING,
OPUOM TYPE STRING,
NCPRP TYPE STRING,
DCPRP TYPE STRING,
POPRC_FLT TYPE STRING,
POVAL_FLT TYPE STRING,
PRCUP TYPE STRING,
POCUR TYPE STRING,
CVRTF TYPE STRING,
CVRAT TYPE STRING,
MDRNO TYPE STRING,
MDRYR TYPE STRING,
MDRIN TYPE STRING,
MDRSY TYPE STRING,
MDRAP TYPE STRING,
ADDDA1 TYPE STRING,
ADDDA2 TYPE STRING,
ADDDA3 TYPE STRING,
CRTSP TYPE STRING,
ECBWH TYPE STRING,
ECIPR TYPE STRING,
IBLIS TYPE STRING,
SAKEM TYPE STRING,
PMEMO TYPE STRING,
OPPVA_FLT TYPE STRING,
PRDES TYPE STRING,
OPPRO TYPE STRING,
PUCCO TYPE STRING,
IDGDS TYPE STRING,
ECPID_OP TYPE STRING,
IDGDSP TYPE STRING,
GUID_DOC_DUP_RES TYPE STRING,
POSID_DUP_RES TYPE STRING,
GUID_DOC TYPE STRING,
POSID TYPE STRING,
FLMDE TYPE STRING,
FLRNC TYPE STRING,
VIDNO TYPE STRING,
SEL_WHERE_CLAUSE TYPE STRING,
CWSIM TYPE STRING,
CWD06 TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR type T_EKKO_STR. DATA: ld_text TYPE string. LOOP AT IT_EKKO INTO WA_EKKO. MOVE-CORRESPONDING wa_EKKO TO WA_EKKO_STR. CONCATENATE: sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-TRTYP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-SRVLL sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-FTORG sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-FTVBS sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-LGREG sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PROCS sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PROSS sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PROSA sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CUHDA sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CUITA sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-INDEI sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-LGREG_TXT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PROSS_TXT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PROSA_TXT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-FTORG_TXT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-FTVBS_TXT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-REPORT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-DVARIANT_HANDLE sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-DVARIANT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-OBJ_CUSWLD sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CRIT_CUSWLD sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MANDT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-GUID_CUSWLO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDDNO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDDYR sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDDIN sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDDSY sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDDAP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDOBJ sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-LGREG sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-GUID_FTORG sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-GUID_FTVBS sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MOVTY sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDDPM sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDCCL sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-TEMST sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-ECPID sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CSTAT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PRVSY sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-GUID_PR sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-OPQUA_FLT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDBUQ_FLT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-BAUOM sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDWGR_FLT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDWNT_FLT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDWEI sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDDDT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDPDT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDCDT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-DLDNO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-DLDIN sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-DLDSY sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-DLDAP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-DLOBJ sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PODNO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PODIN sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PODSY sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PODAP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-POOBJ sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CREFT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CREFN sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PARVD sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PARGS sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PAFVD sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PAFGS sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-INCOT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-INCOLO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CUPRO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CUCOO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDENQ_FLT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-ENUOM sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDOPQ_FLT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-OPUOM sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-NCPRP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-DCPRP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-POPRC_FLT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-POVAL_FLT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PRCUP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-POCUR sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CVRTF sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CVRAT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDRNO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDRYR sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDRIN sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDRSY sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-MDRAP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-ADDDA1 sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-ADDDA2 sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-ADDDA3 sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CRTSP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-ECBWH sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-ECIPR sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-IBLIS sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-SAKEM sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PMEMO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-OPPVA_FLT sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PRDES sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-OPPRO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-PUCCO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-IDGDS sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-ECPID_OP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-IDGDSP sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-GUID_DOC_DUP_RES sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-POSID_DUP_RES sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-GUID_DOC sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-POSID sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-FLMDE sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-FLRNC sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-VIDNO sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-SEL_WHERE_CLAUSE sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CWSIM sy-vline
WA_/SAPSLL/CUSWLD_IFACE_CONTROL_S_STR-CWD06 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
