ABAP Select data from SAP table CEBORDRTPRODCCG 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 CEBORDRTPRODCCG 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 CEBORDRTPRODCCG. 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 CEBORDRTPRODCCG 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_CEBORDRTPRODCCG TYPE STANDARD TABLE OF CEBORDRTPRODCCG, WA_CEBORDRTPRODCCG TYPE CEBORDRTPRODCCG, 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: <CEBORDRTPRODCCG> TYPE CEBORDRTPRODCCG. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_CEBORDRTPRODCCG. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM CEBORDRTPRODCCG INTO TABLE IT_CEBORDRTPRODCCG. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM CEBORDRTPRODCCG * INTO TABLE @DATA(IT_CEBORDRTPRODCCG2). *--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_CEBORDRTPRODCCG INDEX 1 INTO DATA(WA_CEBORDRTPRODCCG2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_CEBORDRTPRODCCG ASSIGNING <CEBORDRTPRODCCG>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<CEBORDRTPRODCCG>-MANDT = 1.
<CEBORDRTPRODCCG>-LEDGER = 1.
<CEBORDRTPRODCCG>-COMPANYCODE = 1.
<CEBORDRTPRODCCG>-ORDERID = 1.
<CEBORDRTPRODCCG>-CONTROLLINGAREA = 1.
ENDLOOP. LOOP AT IT_CEBORDRTPRODCCG INTO WA_CEBORDRTPRODCCG. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_CEBORDRTPRODCCG-ORDERDESCRIPTION, sy-vline,
WA_CEBORDRTPRODCCG-OBJECTINTERNALID, sy-vline,
WA_CEBORDRTPRODCCG-PROFITCENTER, sy-vline,
WA_CEBORDRTPRODCCG-BUSINESSAREA, sy-vline,
WA_CEBORDRTPRODCCG-RESPONSIBLECOSTCENTER, sy-vline,
WA_CEBORDRTPRODCCG-ACTUALCOSTSCOSTINGVARIANT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_CEBORDRTPRODCCG 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_CEBORDRTPRODCCG 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_CEBORDRTPRODCCG INTO WA_CEBORDRTPRODCCG. *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 LEDGER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-LEDGER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-LEDGER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field ORDERID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-ORDERID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-ORDERID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PROFITCENTER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-PROFITCENTER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-PROFITCENTER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field RESPONSIBLECOSTCENTER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-RESPONSIBLECOSTCENTER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-RESPONSIBLECOSTCENTER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field EXTERNALORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-EXTERNALORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-EXTERNALORDER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SALESORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-SALESORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-SALESORDER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field MATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-MATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-MATERIAL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field BASEUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-BASEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-BASEUNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field RATIOUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-RATIOUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-RATIOUNIT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field PLANNINGCATEGORY CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_CEBORDRTPRODCCG-PLANNINGCATEGORY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_CEBORDRTPRODCCG-PLANNINGCATEGORY.
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_CEBORDRTPRODCCG_STR,
MANDT TYPE STRING,
LEDGER TYPE STRING,
COMPANYCODE TYPE STRING,
ORDERID TYPE STRING,
CONTROLLINGAREA TYPE STRING,
ORDERDESCRIPTION TYPE STRING,
OBJECTINTERNALID TYPE STRING,
PROFITCENTER TYPE STRING,
BUSINESSAREA TYPE STRING,
RESPONSIBLECOSTCENTER TYPE STRING,
ACTUALCOSTSCOSTINGVARIANT TYPE STRING,
PLANNEDCOSTSCOSTINGVARIANT TYPE STRING,
EXTERNALORDER TYPE STRING,
SCHEDULEDBASICENDDATE TYPE STRING,
SCHEDULEDRELEASEDATE TYPE STRING,
ACTUALSTARTDATE TYPE STRING,
CONFIRMEDENDDATE TYPE STRING,
ACTUALRELEASEDDATE TYPE STRING,
TECHNICALCOMPLETIONDATE TYPE STRING,
MRPPLANT TYPE STRING,
STORAGELOCATION TYPE STRING,
PRODUCTIONVERSION TYPE STRING,
SALESORDER TYPE STRING,
SALESORDERITEM TYPE STRING,
MATERIAL TYPE STRING,
MATERIALGROUP TYPE STRING,
PLANT TYPE STRING,
CONTROLLINGOBJECTSTATUS TYPE STRING,
ORDERKEYSTATUS TYPE STRING,
SYSTEMSTATUSNAME TYPE STRING,
ORDERSTATUSSHORTTEXT TYPE STRING,
ORDERCATEGORY TYPE STRING,
ORDERTYPE TYPE STRING,
CREATEDBYUSER TYPE STRING,
CREATIONDATE TYPE STRING,
LASTCHANGEDBYUSER TYPE STRING,
LASTCHANGEDATE TYPE STRING,
DISPLAYCURRENCY TYPE STRING,
MFGORDERHASMULTIPLEITEMS TYPE STRING,
MFGORDERWITHMULTIPLEITEMSTEXT TYPE STRING,
COMPANYCODENAME TYPE STRING,
CONTROLLINGAREANAME TYPE STRING,
LEDGERNAME TYPE STRING,
PLANTNAME TYPE STRING,
MRPPLANTNAME TYPE STRING,
MATERIALGROUPNAME TYPE STRING,
MATERIALNAME TYPE STRING,
ORDERTYPENAME TYPE STRING,
ORDERCATEGORYNAME TYPE STRING,
STORAGELOCATIONNAME TYPE STRING,
PRODUCTIONVERSIONTEXT TYPE STRING,
PROFITCENTERNAME TYPE STRING,
RESPONSIBLECOSTCENTERNAME TYPE STRING,
ACTLCOSTSCOSTINGVARIANTNAME TYPE STRING,
PLNDCOSTSCOSTINGVARIANTNAME TYPE STRING,
BUSINESSAREANAME TYPE STRING,
ACTUALOUTPUTQUANTITY TYPE STRING,
BASEUNIT TYPE STRING,
RATIOUNIT TYPE STRING,
TOTALAMOUNTINDISPLAYCRCY TYPE STRING,
COSTCOMPGRP1AMOUNTINDC TYPE STRING,
COSTCOMPGRP2AMOUNTINDC TYPE STRING,
COSTCOMPGRP3AMOUNTINDC TYPE STRING,
COSTCOMPGRP4AMOUNTINDC TYPE STRING,
COSTCOMPGRP5AMOUNTINDC TYPE STRING,
COSTCOMPGRP6AMOUNTINDC TYPE STRING,
COSTCOMPGRP7AMOUNTINDC TYPE STRING,
COSTCOMPGRP8AMOUNTINDC TYPE STRING,
COSTCOMPGRP9AMOUNTINDC TYPE STRING,
COSTCOMPGRP10AMOUNTINDC TYPE STRING,
COSTCOMPGRP11AMOUNTINDC TYPE STRING,
COSTCOMPGRP12AMOUNTINDC TYPE STRING,
COSTCOMPGRP13AMOUNTINDC TYPE STRING,
COSTCOMPGRP14AMOUNTINDC TYPE STRING,
COSTCOMPGRP15AMOUNTINDC TYPE STRING,
COSTCOMPGRP16AMOUNTINDC TYPE STRING,
COSTCOMPGRP17AMOUNTINDC TYPE STRING,
COSTCOMPGRP18AMOUNTINDC TYPE STRING,
COSTCOMPGRP19AMOUNTINDC TYPE STRING,
COSTCOMPGRP20AMOUNTINDC TYPE STRING,
COSTCOMPGRP21AMOUNTINDC TYPE STRING,
COSTCOMPGRP22AMOUNTINDC TYPE STRING,
COSTCOMPGRP23AMOUNTINDC TYPE STRING,
COSTCOMPGRP24AMOUNTINDC TYPE STRING,
COSTCOMPGRP25AMOUNTINDC TYPE STRING,
COSTCOMPGRP26AMOUNTINDC TYPE STRING,
COSTCOMPGRP27AMOUNTINDC TYPE STRING,
COSTCOMPGRP28AMOUNTINDC TYPE STRING,
COSTCOMPGRP29AMOUNTINDC TYPE STRING,
COSTCOMPGRP30AMOUNTINDC TYPE STRING,
COSTCOMPGRP31AMOUNTINDC TYPE STRING,
COSTCOMPGRP32AMOUNTINDC TYPE STRING,
COSTCOMPGRP33AMOUNTINDC TYPE STRING,
COSTCOMPGRP34AMOUNTINDC TYPE STRING,
COSTCOMPGRP35AMOUNTINDC TYPE STRING,
COSTCOMPGRP36AMOUNTINDC TYPE STRING,
COSTCOMPGRP37AMOUNTINDC TYPE STRING,
COSTCOMPGRP38AMOUNTINDC TYPE STRING,
COSTCOMPGRP39AMOUNTINDC TYPE STRING,
COSTCOMPGRP40AMOUNTINDC TYPE STRING,
FROMFISCALYEARPERIOD TYPE STRING,
TOFISCALYEARPERIOD TYPE STRING,
PLANNINGCATEGORY TYPE STRING,END OF T_EKKO_STR. DATA: WA_CEBORDRTPRODCCG_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_CEBORDRTPRODCCG_STR-MANDT sy-vline
WA_CEBORDRTPRODCCG_STR-LEDGER sy-vline
WA_CEBORDRTPRODCCG_STR-COMPANYCODE sy-vline
WA_CEBORDRTPRODCCG_STR-ORDERID sy-vline
WA_CEBORDRTPRODCCG_STR-CONTROLLINGAREA sy-vline
WA_CEBORDRTPRODCCG_STR-ORDERDESCRIPTION sy-vline
WA_CEBORDRTPRODCCG_STR-OBJECTINTERNALID sy-vline
WA_CEBORDRTPRODCCG_STR-PROFITCENTER sy-vline
WA_CEBORDRTPRODCCG_STR-BUSINESSAREA sy-vline
WA_CEBORDRTPRODCCG_STR-RESPONSIBLECOSTCENTER sy-vline
WA_CEBORDRTPRODCCG_STR-ACTUALCOSTSCOSTINGVARIANT sy-vline
WA_CEBORDRTPRODCCG_STR-PLANNEDCOSTSCOSTINGVARIANT sy-vline
WA_CEBORDRTPRODCCG_STR-EXTERNALORDER sy-vline
WA_CEBORDRTPRODCCG_STR-SCHEDULEDBASICENDDATE sy-vline
WA_CEBORDRTPRODCCG_STR-SCHEDULEDRELEASEDATE sy-vline
WA_CEBORDRTPRODCCG_STR-ACTUALSTARTDATE sy-vline
WA_CEBORDRTPRODCCG_STR-CONFIRMEDENDDATE sy-vline
WA_CEBORDRTPRODCCG_STR-ACTUALRELEASEDDATE sy-vline
WA_CEBORDRTPRODCCG_STR-TECHNICALCOMPLETIONDATE sy-vline
WA_CEBORDRTPRODCCG_STR-MRPPLANT sy-vline
WA_CEBORDRTPRODCCG_STR-STORAGELOCATION sy-vline
WA_CEBORDRTPRODCCG_STR-PRODUCTIONVERSION sy-vline
WA_CEBORDRTPRODCCG_STR-SALESORDER sy-vline
WA_CEBORDRTPRODCCG_STR-SALESORDERITEM sy-vline
WA_CEBORDRTPRODCCG_STR-MATERIAL sy-vline
WA_CEBORDRTPRODCCG_STR-MATERIALGROUP sy-vline
WA_CEBORDRTPRODCCG_STR-PLANT sy-vline
WA_CEBORDRTPRODCCG_STR-CONTROLLINGOBJECTSTATUS sy-vline
WA_CEBORDRTPRODCCG_STR-ORDERKEYSTATUS sy-vline
WA_CEBORDRTPRODCCG_STR-SYSTEMSTATUSNAME sy-vline
WA_CEBORDRTPRODCCG_STR-ORDERSTATUSSHORTTEXT sy-vline
WA_CEBORDRTPRODCCG_STR-ORDERCATEGORY sy-vline
WA_CEBORDRTPRODCCG_STR-ORDERTYPE sy-vline
WA_CEBORDRTPRODCCG_STR-CREATEDBYUSER sy-vline
WA_CEBORDRTPRODCCG_STR-CREATIONDATE sy-vline
WA_CEBORDRTPRODCCG_STR-LASTCHANGEDBYUSER sy-vline
WA_CEBORDRTPRODCCG_STR-LASTCHANGEDATE sy-vline
WA_CEBORDRTPRODCCG_STR-DISPLAYCURRENCY sy-vline
WA_CEBORDRTPRODCCG_STR-MFGORDERHASMULTIPLEITEMS sy-vline
WA_CEBORDRTPRODCCG_STR-MFGORDERWITHMULTIPLEITEMSTEXT sy-vline
WA_CEBORDRTPRODCCG_STR-COMPANYCODENAME sy-vline
WA_CEBORDRTPRODCCG_STR-CONTROLLINGAREANAME sy-vline
WA_CEBORDRTPRODCCG_STR-LEDGERNAME sy-vline
WA_CEBORDRTPRODCCG_STR-PLANTNAME sy-vline
WA_CEBORDRTPRODCCG_STR-MRPPLANTNAME sy-vline
WA_CEBORDRTPRODCCG_STR-MATERIALGROUPNAME sy-vline
WA_CEBORDRTPRODCCG_STR-MATERIALNAME sy-vline
WA_CEBORDRTPRODCCG_STR-ORDERTYPENAME sy-vline
WA_CEBORDRTPRODCCG_STR-ORDERCATEGORYNAME sy-vline
WA_CEBORDRTPRODCCG_STR-STORAGELOCATIONNAME sy-vline
WA_CEBORDRTPRODCCG_STR-PRODUCTIONVERSIONTEXT sy-vline
WA_CEBORDRTPRODCCG_STR-PROFITCENTERNAME sy-vline
WA_CEBORDRTPRODCCG_STR-RESPONSIBLECOSTCENTERNAME sy-vline
WA_CEBORDRTPRODCCG_STR-ACTLCOSTSCOSTINGVARIANTNAME sy-vline
WA_CEBORDRTPRODCCG_STR-PLNDCOSTSCOSTINGVARIANTNAME sy-vline
WA_CEBORDRTPRODCCG_STR-BUSINESSAREANAME sy-vline
WA_CEBORDRTPRODCCG_STR-ACTUALOUTPUTQUANTITY sy-vline
WA_CEBORDRTPRODCCG_STR-BASEUNIT sy-vline
WA_CEBORDRTPRODCCG_STR-RATIOUNIT sy-vline
WA_CEBORDRTPRODCCG_STR-TOTALAMOUNTINDISPLAYCRCY sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP1AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP2AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP3AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP4AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP5AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP6AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP7AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP8AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP9AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP10AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP11AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP12AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP13AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP14AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP15AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP16AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP17AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP18AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP19AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP20AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP21AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP22AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP23AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP24AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP25AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP26AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP27AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP28AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP29AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP30AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP31AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP32AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP33AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP34AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP35AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP36AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP37AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP38AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP39AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-COSTCOMPGRP40AMOUNTINDC sy-vline
WA_CEBORDRTPRODCCG_STR-FROMFISCALYEARPERIOD sy-vline
WA_CEBORDRTPRODCCG_STR-TOFISCALYEARPERIOD sy-vline
WA_CEBORDRTPRODCCG_STR-PLANNINGCATEGORY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.