ABAP Select data from SAP table REIS_SCADV_L 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 REIS_SCADV_L 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 REIS_SCADV_L. 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 REIS_SCADV_L 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_REIS_SCADV_L TYPE STANDARD TABLE OF REIS_SCADV_L, WA_REIS_SCADV_L TYPE REIS_SCADV_L, 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: <REIS_SCADV_L> TYPE REIS_SCADV_L. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_REIS_SCADV_L. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM REIS_SCADV_L INTO TABLE IT_REIS_SCADV_L. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM REIS_SCADV_L * INTO TABLE @DATA(IT_REIS_SCADV_L2). *--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_REIS_SCADV_L INDEX 1 INTO DATA(WA_REIS_SCADV_L2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_REIS_SCADV_L ASSIGNING <REIS_SCADV_L>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<REIS_SCADV_L>-GEN_OBJTYPE = 1.
<REIS_SCADV_L>-GEN_OBJNR = 1.
<REIS_SCADV_L>-GEN_CONTRACT = 1.
<REIS_SCADV_L>-GEN_PARTNER1 = 1.
<REIS_SCADV_L>-GEN_PARTNER2 = 1.
ENDLOOP. LOOP AT IT_REIS_SCADV_L INTO WA_REIS_SCADV_L. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_REIS_SCADV_L-ALVROWS, sy-vline,
WA_REIS_SCADV_L-RECISVALIDFROM, sy-vline,
WA_REIS_SCADV_L-RECISVALIDTO, sy-vline,
WA_REIS_SCADV_L-ROLE_BP1, sy-vline,
WA_REIS_SCADV_L-XROLE_BP1, sy-vline,
WA_REIS_SCADV_L-PARTNER_BP1, sy-vline.
ENDLOOP. *Add any further fields from structure WA_REIS_SCADV_L 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_REIS_SCADV_L 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_REIS_SCADV_L INTO WA_REIS_SCADV_L. *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 GEN_PARTNER1 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-GEN_PARTNER1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-GEN_PARTNER1.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field GEN_PARTNER2 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-GEN_PARTNER2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-GEN_PARTNER2.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PARTNER_BP1 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-PARTNER_BP1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-PARTNER_BP1.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SXIDN, internal->external for field SMTP_ADDR_BP1 CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-SMTP_ADDR_BP1 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-SMTP_ADDR_BP1.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PARTNER_BP2 CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-PARTNER_BP2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-PARTNER_BP2.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SXIDN, internal->external for field SMTP_ADDR_BP2 CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-SMTP_ADDR_BP2 IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-SMTP_ADDR_BP2.
WRITE:/ 'New Value:', ld_input.
*Conversion exit REDAT, internal->external for field SETTL_PTO CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-SETTL_PTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-SETTL_PTO.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field RECNNR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-RECNNR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-RECNNR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit SWENR, internal->external for field BENOCN CALL FUNCTION 'CONVERSION_EXIT_SWENR_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-BENOCN IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-BENOCN.
WRITE:/ 'New Value:', ld_input.
*Conversion exit GJAHR, internal->external for field FISC_YEAR CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-FISC_YEAR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-FISC_YEAR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field CONDTYPE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-CONDTYPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-CONDTYPE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field FLOWTYPE CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-FLOWTYPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-FLOWTYPE.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field CUSTOMER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-CUSTOMER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-CUSTOMER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PARTNER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-PARTNER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-PARTNER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit REDAT, internal->external for field USEDTO CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-USEDTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-USEDTO.
WRITE:/ 'New Value:', ld_input.
*Conversion exit REDAT, internal->external for field RESTTO CALL FUNCTION 'CONVERSION_EXIT_REDAT_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-RESTTO IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-RESTTO.
WRITE:/ 'New Value:', ld_input.
*Conversion exit EXCRT, internal->external for field CTRATE CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT' EXPORTING input = WA_REIS_SCADV_L-CTRATE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_REIS_SCADV_L-CTRATE.
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_REIS_SCADV_L_STR,
GEN_OBJTYPE TYPE STRING,
GEN_OBJNR TYPE STRING,
GEN_CONTRACT TYPE STRING,
GEN_PARTNER1 TYPE STRING,
GEN_PARTNER2 TYPE STRING,
ALVROWS TYPE STRING,
RECISVALIDFROM TYPE STRING,
RECISVALIDTO TYPE STRING,
ROLE_BP1 TYPE STRING,
XROLE_BP1 TYPE STRING,
PARTNER_BP1 TYPE STRING,
XPARTNER_BP1 TYPE STRING,
TEL_NUMBER_LONG_BP1 TYPE STRING,
FAX_NUMBER_LONG_BP1 TYPE STRING,
SMTP_ADDR_BP1 TYPE STRING,
XNAME_BP1 TYPE STRING,
STREET_BP1 TYPE STRING,
HOUSE_NUM1_BP1 TYPE STRING,
POST_CODE1_BP1 TYPE STRING,
CITY1_BP1 TYPE STRING,
CITY2_BP1 TYPE STRING,
REGION_BP1 TYPE STRING,
PO_BOX_BP1 TYPE STRING,
POST_CODE2_BP1 TYPE STRING,
ROLECAT_BP1 TYPE STRING,
ADDRTYPE_BP1 TYPE STRING,
HOUSE_NUM2_BP1 TYPE STRING,
ROLE_BP2 TYPE STRING,
XROLE_BP2 TYPE STRING,
PARTNER_BP2 TYPE STRING,
XPARTNER_BP2 TYPE STRING,
TEL_NUMBER_LONG_BP2 TYPE STRING,
FAX_NUMBER_LONG_BP2 TYPE STRING,
SMTP_ADDR_BP2 TYPE STRING,
XNAME_BP2 TYPE STRING,
STREET_BP2 TYPE STRING,
HOUSE_NUM1_BP2 TYPE STRING,
POST_CODE1_BP2 TYPE STRING,
CITY1_BP2 TYPE STRING,
CITY2_BP2 TYPE STRING,
REGION_BP2 TYPE STRING,
PO_BOX_BP2 TYPE STRING,
POST_CODE2_BP2 TYPE STRING,
ROLECAT_BP2 TYPE STRING,
ADDRTYPE_BP2 TYPE STRING,
HOUSE_NUM2_BP2 TYPE STRING,
STATUSICON TYPE STRING,
LISTSTATUS TYPE STRING,
XLISTSTATUS TYPE STRING,
CLEARINGICON TYPE STRING,
CLEARINGSTATUS TYPE STRING,
PARTTYPE TYPE STRING,
XPARTTYPE TYPE STRING,
PROCESS TYPE STRING,
PROCESSID TYPE STRING,
PROCESSEXTID TYPE STRING,
PROCCOMPLETE TYPE STRING,
SETTLMODE TYPE STRING,
SETTLTYPE TYPE STRING,
SETTL_PFROM TYPE STRING,
SETTL_PTO TYPE STRING,
OBJNR TYPE STRING,
OBJIDENTCALC TYPE STRING,
BUKRS TYPE STRING,
RECNNR TYPE STRING,
RECNTXT TYPE STRING,
BENOCN TYPE STRING,
RECNTYPE TYPE STRING,
FISC_YEAR TYPE STRING,
PSTNGPERIOD TYPE STRING,
PSTNGDATE TYPE STRING,
DOCDATE TYPE STRING,
REFDOCTYPE TYPE STRING,
REFDOCID TYPE STRING,
DOCGUID TYPE STRING,
CF_PFROM TYPE STRING,
CF_PTO TYPE STRING,
BLINEDATE TYPE STRING,
ORIGDUEDATE TYPE STRING,
CONDTYPE TYPE STRING,
XCONDITION TYPE STRING,
FLOWTYPE TYPE STRING,
XFLOWTYPE TYPE STRING,
UNIQUECOND TYPE STRING,
CUSTOMER TYPE STRING,
PARTNER TYPE STRING,
XPARTNER TYPE STRING,
CURRENCY TYPE STRING,
NET_AMOUNT TYPE STRING,
TAX_AMOUNT TYPE STRING,
NET_AMOUNT_PAY TYPE STRING,
TAX_AMOUNT_PAY TYPE STRING,
NET_AMOUNT_EXT TYPE STRING,
TAX_AMOUNT_EXT TYPE STRING,
CTFCCURRKEY TYPE STRING,
CTFCNETAMOUNT TYPE STRING,
CTFCTAXAMOUNT TYPE STRING,
CTFCNETAMOUNTPAY TYPE STRING,
CTFCTAXAMOUNTPAY TYPE STRING,
CTFCNETAMOUNTEXT TYPE STRING,
CTFCTAXAMOUNTEXT TYPE STRING,
CONDCURR TYPE STRING,
CF_NETAMOUNT TYPE STRING,
CF_TAXAMOUNT TYPE STRING,
CF_GROSSAMOUNT TYPE STRING,
CF_CTLCNETAMOUNT TYPE STRING,
CF_CTLCTAXAMOUNT TYPE STRING,
CF_CTLCGROSSAMOUNT TYPE STRING,
TAXTYPE TYPE STRING,
TAXGROUP TYPE STRING,
USEDFROM TYPE STRING,
USEDTO TYPE STRING,
RESTFROM TYPE STRING,
RESTTO TYPE STRING,
USEDNETAMOUNT TYPE STRING,
USEDTAXAMOUNT TYPE STRING,
RESTNETAMOUNT TYPE STRING,
RESTTAXAMOUNT TYPE STRING,
USEDCTFCNETAMT TYPE STRING,
USEDCTFCTAXAMT TYPE STRING,
RESTCTFCNETAMT TYPE STRING,
RESTCTFCTAXAMT TYPE STRING,
HASLEGACYDATA TYPE STRING,
CTRULE TYPE STRING,
CTRATE TYPE STRING,
CTFCPOST TYPE STRING,END OF T_EKKO_STR. DATA: WA_REIS_SCADV_L_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_REIS_SCADV_L_STR-GEN_OBJTYPE sy-vline
WA_REIS_SCADV_L_STR-GEN_OBJNR sy-vline
WA_REIS_SCADV_L_STR-GEN_CONTRACT sy-vline
WA_REIS_SCADV_L_STR-GEN_PARTNER1 sy-vline
WA_REIS_SCADV_L_STR-GEN_PARTNER2 sy-vline
WA_REIS_SCADV_L_STR-ALVROWS sy-vline
WA_REIS_SCADV_L_STR-RECISVALIDFROM sy-vline
WA_REIS_SCADV_L_STR-RECISVALIDTO sy-vline
WA_REIS_SCADV_L_STR-ROLE_BP1 sy-vline
WA_REIS_SCADV_L_STR-XROLE_BP1 sy-vline
WA_REIS_SCADV_L_STR-PARTNER_BP1 sy-vline
WA_REIS_SCADV_L_STR-XPARTNER_BP1 sy-vline
WA_REIS_SCADV_L_STR-TEL_NUMBER_LONG_BP1 sy-vline
WA_REIS_SCADV_L_STR-FAX_NUMBER_LONG_BP1 sy-vline
WA_REIS_SCADV_L_STR-SMTP_ADDR_BP1 sy-vline
WA_REIS_SCADV_L_STR-XNAME_BP1 sy-vline
WA_REIS_SCADV_L_STR-STREET_BP1 sy-vline
WA_REIS_SCADV_L_STR-HOUSE_NUM1_BP1 sy-vline
WA_REIS_SCADV_L_STR-POST_CODE1_BP1 sy-vline
WA_REIS_SCADV_L_STR-CITY1_BP1 sy-vline
WA_REIS_SCADV_L_STR-CITY2_BP1 sy-vline
WA_REIS_SCADV_L_STR-REGION_BP1 sy-vline
WA_REIS_SCADV_L_STR-PO_BOX_BP1 sy-vline
WA_REIS_SCADV_L_STR-POST_CODE2_BP1 sy-vline
WA_REIS_SCADV_L_STR-ROLECAT_BP1 sy-vline
WA_REIS_SCADV_L_STR-ADDRTYPE_BP1 sy-vline
WA_REIS_SCADV_L_STR-HOUSE_NUM2_BP1 sy-vline
WA_REIS_SCADV_L_STR-ROLE_BP2 sy-vline
WA_REIS_SCADV_L_STR-XROLE_BP2 sy-vline
WA_REIS_SCADV_L_STR-PARTNER_BP2 sy-vline
WA_REIS_SCADV_L_STR-XPARTNER_BP2 sy-vline
WA_REIS_SCADV_L_STR-TEL_NUMBER_LONG_BP2 sy-vline
WA_REIS_SCADV_L_STR-FAX_NUMBER_LONG_BP2 sy-vline
WA_REIS_SCADV_L_STR-SMTP_ADDR_BP2 sy-vline
WA_REIS_SCADV_L_STR-XNAME_BP2 sy-vline
WA_REIS_SCADV_L_STR-STREET_BP2 sy-vline
WA_REIS_SCADV_L_STR-HOUSE_NUM1_BP2 sy-vline
WA_REIS_SCADV_L_STR-POST_CODE1_BP2 sy-vline
WA_REIS_SCADV_L_STR-CITY1_BP2 sy-vline
WA_REIS_SCADV_L_STR-CITY2_BP2 sy-vline
WA_REIS_SCADV_L_STR-REGION_BP2 sy-vline
WA_REIS_SCADV_L_STR-PO_BOX_BP2 sy-vline
WA_REIS_SCADV_L_STR-POST_CODE2_BP2 sy-vline
WA_REIS_SCADV_L_STR-ROLECAT_BP2 sy-vline
WA_REIS_SCADV_L_STR-ADDRTYPE_BP2 sy-vline
WA_REIS_SCADV_L_STR-HOUSE_NUM2_BP2 sy-vline
WA_REIS_SCADV_L_STR-STATUSICON sy-vline
WA_REIS_SCADV_L_STR-LISTSTATUS sy-vline
WA_REIS_SCADV_L_STR-XLISTSTATUS sy-vline
WA_REIS_SCADV_L_STR-CLEARINGICON sy-vline
WA_REIS_SCADV_L_STR-CLEARINGSTATUS sy-vline
WA_REIS_SCADV_L_STR-PARTTYPE sy-vline
WA_REIS_SCADV_L_STR-XPARTTYPE sy-vline
WA_REIS_SCADV_L_STR-PROCESS sy-vline
WA_REIS_SCADV_L_STR-PROCESSID sy-vline
WA_REIS_SCADV_L_STR-PROCESSEXTID sy-vline
WA_REIS_SCADV_L_STR-PROCCOMPLETE sy-vline
WA_REIS_SCADV_L_STR-SETTLMODE sy-vline
WA_REIS_SCADV_L_STR-SETTLTYPE sy-vline
WA_REIS_SCADV_L_STR-SETTL_PFROM sy-vline
WA_REIS_SCADV_L_STR-SETTL_PTO sy-vline
WA_REIS_SCADV_L_STR-OBJNR sy-vline
WA_REIS_SCADV_L_STR-OBJIDENTCALC sy-vline
WA_REIS_SCADV_L_STR-BUKRS sy-vline
WA_REIS_SCADV_L_STR-RECNNR sy-vline
WA_REIS_SCADV_L_STR-RECNTXT sy-vline
WA_REIS_SCADV_L_STR-BENOCN sy-vline
WA_REIS_SCADV_L_STR-RECNTYPE sy-vline
WA_REIS_SCADV_L_STR-FISC_YEAR sy-vline
WA_REIS_SCADV_L_STR-PSTNGPERIOD sy-vline
WA_REIS_SCADV_L_STR-PSTNGDATE sy-vline
WA_REIS_SCADV_L_STR-DOCDATE sy-vline
WA_REIS_SCADV_L_STR-REFDOCTYPE sy-vline
WA_REIS_SCADV_L_STR-REFDOCID sy-vline
WA_REIS_SCADV_L_STR-DOCGUID sy-vline
WA_REIS_SCADV_L_STR-CF_PFROM sy-vline
WA_REIS_SCADV_L_STR-CF_PTO sy-vline
WA_REIS_SCADV_L_STR-BLINEDATE sy-vline
WA_REIS_SCADV_L_STR-ORIGDUEDATE sy-vline
WA_REIS_SCADV_L_STR-CONDTYPE sy-vline
WA_REIS_SCADV_L_STR-XCONDITION sy-vline
WA_REIS_SCADV_L_STR-FLOWTYPE sy-vline
WA_REIS_SCADV_L_STR-XFLOWTYPE sy-vline
WA_REIS_SCADV_L_STR-UNIQUECOND sy-vline
WA_REIS_SCADV_L_STR-CUSTOMER sy-vline
WA_REIS_SCADV_L_STR-PARTNER sy-vline
WA_REIS_SCADV_L_STR-XPARTNER sy-vline
WA_REIS_SCADV_L_STR-CURRENCY sy-vline
WA_REIS_SCADV_L_STR-NET_AMOUNT sy-vline
WA_REIS_SCADV_L_STR-TAX_AMOUNT sy-vline
WA_REIS_SCADV_L_STR-NET_AMOUNT_PAY sy-vline
WA_REIS_SCADV_L_STR-TAX_AMOUNT_PAY sy-vline
WA_REIS_SCADV_L_STR-NET_AMOUNT_EXT sy-vline
WA_REIS_SCADV_L_STR-TAX_AMOUNT_EXT sy-vline
WA_REIS_SCADV_L_STR-CTFCCURRKEY sy-vline
WA_REIS_SCADV_L_STR-CTFCNETAMOUNT sy-vline
WA_REIS_SCADV_L_STR-CTFCTAXAMOUNT sy-vline
WA_REIS_SCADV_L_STR-CTFCNETAMOUNTPAY sy-vline
WA_REIS_SCADV_L_STR-CTFCTAXAMOUNTPAY sy-vline
WA_REIS_SCADV_L_STR-CTFCNETAMOUNTEXT sy-vline
WA_REIS_SCADV_L_STR-CTFCTAXAMOUNTEXT sy-vline
WA_REIS_SCADV_L_STR-CONDCURR sy-vline
WA_REIS_SCADV_L_STR-CF_NETAMOUNT sy-vline
WA_REIS_SCADV_L_STR-CF_TAXAMOUNT sy-vline
WA_REIS_SCADV_L_STR-CF_GROSSAMOUNT sy-vline
WA_REIS_SCADV_L_STR-CF_CTLCNETAMOUNT sy-vline
WA_REIS_SCADV_L_STR-CF_CTLCTAXAMOUNT sy-vline
WA_REIS_SCADV_L_STR-CF_CTLCGROSSAMOUNT sy-vline
WA_REIS_SCADV_L_STR-TAXTYPE sy-vline
WA_REIS_SCADV_L_STR-TAXGROUP sy-vline
WA_REIS_SCADV_L_STR-USEDFROM sy-vline
WA_REIS_SCADV_L_STR-USEDTO sy-vline
WA_REIS_SCADV_L_STR-RESTFROM sy-vline
WA_REIS_SCADV_L_STR-RESTTO sy-vline
WA_REIS_SCADV_L_STR-USEDNETAMOUNT sy-vline
WA_REIS_SCADV_L_STR-USEDTAXAMOUNT sy-vline
WA_REIS_SCADV_L_STR-RESTNETAMOUNT sy-vline
WA_REIS_SCADV_L_STR-RESTTAXAMOUNT sy-vline
WA_REIS_SCADV_L_STR-USEDCTFCNETAMT sy-vline
WA_REIS_SCADV_L_STR-USEDCTFCTAXAMT sy-vline
WA_REIS_SCADV_L_STR-RESTCTFCNETAMT sy-vline
WA_REIS_SCADV_L_STR-RESTCTFCTAXAMT sy-vline
WA_REIS_SCADV_L_STR-HASLEGACYDATA sy-vline
WA_REIS_SCADV_L_STR-CTRULE sy-vline
WA_REIS_SCADV_L_STR-CTRATE sy-vline
WA_REIS_SCADV_L_STR-CTFCPOST sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.