ABAP Select data from SAP table /SAPSLL/CUSWLD 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 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. 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 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 TYPE STANDARD TABLE OF /SAPSLL/CUSWLD,
      WA_/SAPSLL/CUSWLD TYPE /SAPSLL/CUSWLD,
      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> TYPE /SAPSLL/CUSWLD.

*Process all fields in table header/work area as string values
  PERFORM process_as_string_field_values CHANGING wa_/SAPSLL/CUSWLD.

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /SAPSLL/CUSWLD
  INTO TABLE IT_/SAPSLL/CUSWLD.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /SAPSLL/CUSWLD
*  INTO TABLE @DATA(IT_/SAPSLL/CUSWLD2).
*--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 INDEX 1 INTO DATA(WA_/SAPSLL/CUSWLD2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SAPSLL/CUSWLD ASSIGNING </SAPSLL/CUSWLD>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
</SAPSLL/CUSWLD>-MANDT = 1.
</SAPSLL/CUSWLD>-GUID_CUSWLD = 1.
</SAPSLL/CUSWLD>-MDDNO = 1.
</SAPSLL/CUSWLD>-MDDYR = 1.
</SAPSLL/CUSWLD>-MDDIN = 1.
ENDLOOP.

LOOP AT IT_/SAPSLL/CUSWLD INTO WA_/SAPSLL/CUSWLD.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SAPSLL/CUSWLD-MDDSY, sy-vline,
WA_/SAPSLL/CUSWLD-MDDAP, sy-vline,
WA_/SAPSLL/CUSWLD-MDOBJ, sy-vline,
WA_/SAPSLL/CUSWLD-LGREG, sy-vline,
WA_/SAPSLL/CUSWLD-GUID_FTORG, sy-vline,
WA_/SAPSLL/CUSWLD-GUID_FTVBS, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SAPSLL/CUSWLD 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 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 INTO WA_/SAPSLL/CUSWLD. *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 MDDNO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDDNO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDDNO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MDDYR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDDYR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDDYR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field MDDIN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDDIN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDDIN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field MDDSY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDDSY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDDSY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PARID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-PARID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-PARID.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SLLPR, internal->external for field PRVSY CALL FUNCTION 'CONVERSION_EXIT_SLLPR_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-PRVSY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-PRVSY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field BAUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-BAUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-BAUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field MDWEI CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDWEI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDWEI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SLLTS, internal->external for field MDCDT CALL FUNCTION 'CONVERSION_EXIT_SLLTS_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDCDT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDCDT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field DLDNO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-DLDNO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-DLDNO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field DLDIN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-DLDIN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-DLDIN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field DLDSY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-DLDSY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-DLDSY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PODNO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-PODNO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-PODNO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PODIN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-PODIN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-PODIN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PODSY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-PODSY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-PODSY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PARVD CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-PARVD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-PARVD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PARGS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-PARGS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-PARGS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PAFVD CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-PAFVD IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-PAFVD.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field PAFGS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-PAFGS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-PAFGS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field ENUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-ENUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-ENUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field OPUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-OPUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-OPUOM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field MDRNO CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDRNO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDRNO.
WRITE:/ 'New Value:', ld_input.

*Conversion exit GJAHR, internal->external for field MDRYR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDRYR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDRYR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field MDRIN CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDRIN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDRIN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field MDRSY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-MDRSY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-MDRSY.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ALPHA, internal->external for field LOCID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SAPSLL/CUSWLD-LOCID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SAPSLL/CUSWLD-LOCID.
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_STR,
MANDT TYPE STRING,
GUID_CUSWLD 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,
IBLIS TYPE STRING,
PARID 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,
POVAL_FLT TYPE STRING,
OPPVA_FLT TYPE STRING,
POPRC_FLT TYPE STRING,
PRCUP TYPE STRING,
POCUR TYPE STRING,
CVRTF TYPE STRING,
CVRAT TYPE STRING,
ADDDA1 TYPE STRING,
ADDDA2 TYPE STRING,
ADDDA3 TYPE STRING,
MDRNO TYPE STRING,
MDRYR TYPE STRING,
MDRIN TYPE STRING,
MDRSY TYPE STRING,
MDRAP TYPE STRING,
CRTSP TYPE STRING,
ERNAM TYPE STRING,
MANNI TYPE STRING,
IDGDS TYPE STRING,
ENDUSE TYPE STRING,
LOCID TYPE STRING,
ECPID_OP TYPE STRING,
IDGDSP TYPE STRING,
GUID_DOC_DUP_RES TYPE STRING,
POSID_DUP_RES TYPE STRING,
VIDNO TYPE STRING,
GUID_DOC TYPE STRING,
POSID TYPE STRING,
ADDDA0 TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SAPSLL/CUSWLD_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_STR-MANDT sy-vline
WA_/SAPSLL/CUSWLD_STR-GUID_CUSWLD sy-vline
WA_/SAPSLL/CUSWLD_STR-MDDNO sy-vline
WA_/SAPSLL/CUSWLD_STR-MDDYR sy-vline
WA_/SAPSLL/CUSWLD_STR-MDDIN sy-vline
WA_/SAPSLL/CUSWLD_STR-MDDSY sy-vline
WA_/SAPSLL/CUSWLD_STR-MDDAP sy-vline
WA_/SAPSLL/CUSWLD_STR-MDOBJ sy-vline
WA_/SAPSLL/CUSWLD_STR-LGREG sy-vline
WA_/SAPSLL/CUSWLD_STR-GUID_FTORG sy-vline
WA_/SAPSLL/CUSWLD_STR-GUID_FTVBS sy-vline
WA_/SAPSLL/CUSWLD_STR-MOVTY sy-vline
WA_/SAPSLL/CUSWLD_STR-MDDPM sy-vline
WA_/SAPSLL/CUSWLD_STR-MDCCL sy-vline
WA_/SAPSLL/CUSWLD_STR-TEMST sy-vline
WA_/SAPSLL/CUSWLD_STR-ECPID sy-vline
WA_/SAPSLL/CUSWLD_STR-CSTAT sy-vline
WA_/SAPSLL/CUSWLD_STR-IBLIS sy-vline
WA_/SAPSLL/CUSWLD_STR-PARID sy-vline
WA_/SAPSLL/CUSWLD_STR-PRVSY sy-vline
WA_/SAPSLL/CUSWLD_STR-GUID_PR sy-vline
WA_/SAPSLL/CUSWLD_STR-OPQUA_FLT sy-vline
WA_/SAPSLL/CUSWLD_STR-MDBUQ_FLT sy-vline
WA_/SAPSLL/CUSWLD_STR-BAUOM sy-vline
WA_/SAPSLL/CUSWLD_STR-MDWGR_FLT sy-vline
WA_/SAPSLL/CUSWLD_STR-MDWNT_FLT sy-vline
WA_/SAPSLL/CUSWLD_STR-MDWEI sy-vline
WA_/SAPSLL/CUSWLD_STR-MDDDT sy-vline
WA_/SAPSLL/CUSWLD_STR-MDPDT sy-vline
WA_/SAPSLL/CUSWLD_STR-MDCDT sy-vline
WA_/SAPSLL/CUSWLD_STR-DLDNO sy-vline
WA_/SAPSLL/CUSWLD_STR-DLDIN sy-vline
WA_/SAPSLL/CUSWLD_STR-DLDSY sy-vline
WA_/SAPSLL/CUSWLD_STR-DLDAP sy-vline
WA_/SAPSLL/CUSWLD_STR-DLOBJ sy-vline
WA_/SAPSLL/CUSWLD_STR-PODNO sy-vline
WA_/SAPSLL/CUSWLD_STR-PODIN sy-vline
WA_/SAPSLL/CUSWLD_STR-PODSY sy-vline
WA_/SAPSLL/CUSWLD_STR-PODAP sy-vline
WA_/SAPSLL/CUSWLD_STR-POOBJ sy-vline
WA_/SAPSLL/CUSWLD_STR-CREFT sy-vline
WA_/SAPSLL/CUSWLD_STR-CREFN sy-vline
WA_/SAPSLL/CUSWLD_STR-PARVD sy-vline
WA_/SAPSLL/CUSWLD_STR-PARGS sy-vline
WA_/SAPSLL/CUSWLD_STR-PAFVD sy-vline
WA_/SAPSLL/CUSWLD_STR-PAFGS sy-vline
WA_/SAPSLL/CUSWLD_STR-INCOT sy-vline
WA_/SAPSLL/CUSWLD_STR-INCOLO sy-vline
WA_/SAPSLL/CUSWLD_STR-CUPRO sy-vline
WA_/SAPSLL/CUSWLD_STR-CUCOO sy-vline
WA_/SAPSLL/CUSWLD_STR-MDENQ_FLT sy-vline
WA_/SAPSLL/CUSWLD_STR-ENUOM sy-vline
WA_/SAPSLL/CUSWLD_STR-MDOPQ_FLT sy-vline
WA_/SAPSLL/CUSWLD_STR-OPUOM sy-vline
WA_/SAPSLL/CUSWLD_STR-NCPRP sy-vline
WA_/SAPSLL/CUSWLD_STR-DCPRP sy-vline
WA_/SAPSLL/CUSWLD_STR-POVAL_FLT sy-vline
WA_/SAPSLL/CUSWLD_STR-OPPVA_FLT sy-vline
WA_/SAPSLL/CUSWLD_STR-POPRC_FLT sy-vline
WA_/SAPSLL/CUSWLD_STR-PRCUP sy-vline
WA_/SAPSLL/CUSWLD_STR-POCUR sy-vline
WA_/SAPSLL/CUSWLD_STR-CVRTF sy-vline
WA_/SAPSLL/CUSWLD_STR-CVRAT sy-vline
WA_/SAPSLL/CUSWLD_STR-ADDDA1 sy-vline
WA_/SAPSLL/CUSWLD_STR-ADDDA2 sy-vline
WA_/SAPSLL/CUSWLD_STR-ADDDA3 sy-vline
WA_/SAPSLL/CUSWLD_STR-MDRNO sy-vline
WA_/SAPSLL/CUSWLD_STR-MDRYR sy-vline
WA_/SAPSLL/CUSWLD_STR-MDRIN sy-vline
WA_/SAPSLL/CUSWLD_STR-MDRSY sy-vline
WA_/SAPSLL/CUSWLD_STR-MDRAP sy-vline
WA_/SAPSLL/CUSWLD_STR-CRTSP sy-vline
WA_/SAPSLL/CUSWLD_STR-ERNAM sy-vline
WA_/SAPSLL/CUSWLD_STR-MANNI sy-vline
WA_/SAPSLL/CUSWLD_STR-IDGDS sy-vline
WA_/SAPSLL/CUSWLD_STR-ENDUSE sy-vline
WA_/SAPSLL/CUSWLD_STR-LOCID sy-vline
WA_/SAPSLL/CUSWLD_STR-ECPID_OP sy-vline
WA_/SAPSLL/CUSWLD_STR-IDGDSP sy-vline
WA_/SAPSLL/CUSWLD_STR-GUID_DOC_DUP_RES sy-vline
WA_/SAPSLL/CUSWLD_STR-POSID_DUP_RES sy-vline
WA_/SAPSLL/CUSWLD_STR-VIDNO sy-vline
WA_/SAPSLL/CUSWLD_STR-GUID_DOC sy-vline
WA_/SAPSLL/CUSWLD_STR-POSID sy-vline
WA_/SAPSLL/CUSWLD_STR-ADDDA0 sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.