ABAP Select data from SAP table ILOGSORDBASIC 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 ILOGSORDBASIC 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 ILOGSORDBASIC. 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 ILOGSORDBASIC 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_ILOGSORDBASIC TYPE STANDARD TABLE OF ILOGSORDBASIC, WA_ILOGSORDBASIC TYPE ILOGSORDBASIC, 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: <ILOGSORDBASIC> TYPE ILOGSORDBASIC. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_ILOGSORDBASIC. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM ILOGSORDBASIC INTO TABLE IT_ILOGSORDBASIC. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM ILOGSORDBASIC * INTO TABLE @DATA(IT_ILOGSORDBASIC2). *--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_ILOGSORDBASIC INDEX 1 INTO DATA(WA_ILOGSORDBASIC2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_ILOGSORDBASIC ASSIGNING <ILOGSORDBASIC>.*To update a field value using a field symbol simply change the value via the field symbol pointer
<ILOGSORDBASIC>-MANDT = 1.
<ILOGSORDBASIC>-ORDERID = 1.
<ILOGSORDBASIC>-ORDERINTERNALID = 1.
<ILOGSORDBASIC>-PRIORITYCODE = 1.
<ILOGSORDBASIC>-MFGORDERISPARTOFCOLLVORDER = 1.
ENDLOOP. LOOP AT IT_ILOGSORDBASIC INTO WA_ILOGSORDBASIC. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_ILOGSORDBASIC-ORDERISNOTCOSTEDAUTOMATICALLY, sy-vline,
WA_ILOGSORDBASIC-ORDISNOTSCHEDLDAUTOMATICALLY, sy-vline,
WA_ILOGSORDBASIC-MFGORDERHIERARCHYLEVEL, sy-vline,
WA_ILOGSORDBASIC-PRODNPROCGISFLEXIBLE, sy-vline,
WA_ILOGSORDBASIC-MFGORDERSUPERIORMFGORDER, sy-vline,
WA_ILOGSORDBASIC-LEADINGORDER, sy-vline.
ENDLOOP. *Add any further fields from structure WA_ILOGSORDBASIC 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_ILOGSORDBASIC 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_ILOGSORDBASIC INTO WA_ILOGSORDBASIC. *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 ORDERID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-ORDERID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-ORDERID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field MFGORDERSUPERIORMFGORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-MFGORDERSUPERIORMFGORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-MFGORDERSUPERIORMFGORDER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field LEADINGORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-LEADINGORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-LEADINGORDER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SUPERIORPROJECTNETWORK CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-SUPERIORPROJECTNETWORK IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-SUPERIORPROJECTNETWORK.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field INSPECTIONLOT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-INSPECTIONLOT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-INSPECTIONLOT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field CHANGENUMBER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-CHANGENUMBER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-CHANGENUMBER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit MATN1, internal->external for field MATERIAL CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-MATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-MATERIAL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BILLOFOPERATIONSGROUP CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-BILLOFOPERATIONSGROUP IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-BILLOFOPERATIONSGROUP.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BILLOFOPERATIONSVARIANT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-BILLOFOPERATIONSVARIANT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-BILLOFOPERATIONSVARIANT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BILLOFOPERATIONSVERSION CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-BILLOFOPERATIONSVERSION IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-BILLOFOPERATIONSVERSION.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BILLOFOPERATIONS CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-BILLOFOPERATIONS IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-BILLOFOPERATIONS.
WRITE:/ 'New Value:', ld_input.
*Conversion exit NUMCV, internal->external for field BILLOFMATERIAL CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-BILLOFMATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-BILLOFMATERIAL.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field BILLOFMATERIALVARIANT CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-BILLOFMATERIALVARIANT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-BILLOFMATERIALVARIANT.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field MASTERPRODUCTIONORDER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-MASTERPRODUCTIONORDER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-MASTERPRODUCTIONORDER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field BASEUNIT CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_ILOGSORDBASIC-BASEUNIT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_ILOGSORDBASIC-BASEUNIT.
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_ILOGSORDBASIC_STR,
MANDT TYPE STRING,
ORDERID TYPE STRING,
ORDERINTERNALID TYPE STRING,
PRIORITYCODE TYPE STRING,
MFGORDERISPARTOFCOLLVORDER TYPE STRING,
ORDERISNOTCOSTEDAUTOMATICALLY TYPE STRING,
ORDISNOTSCHEDLDAUTOMATICALLY TYPE STRING,
MFGORDERHIERARCHYLEVEL TYPE STRING,
PRODNPROCGISFLEXIBLE TYPE STRING,
MFGORDERSUPERIORMFGORDER TYPE STRING,
LEADINGORDER TYPE STRING,
MRPCONTROLLER TYPE STRING,
PRODUCTIONSUPERVISOR TYPE STRING,
PRODUCTIONSCHEDULINGPROFILE TYPE STRING,
RESPONSIBLEPLANNERGROUP TYPE STRING,
PROJECTINTERNALID TYPE STRING,
SUPERIORPROJECTNETWORK TYPE STRING,
RESERVATION TYPE STRING,
SETTLEMENTRESERVATION TYPE STRING,
MFGORDERCONFIRMATION TYPE STRING,
MFGORDERCONFIRMATIONCOUNT TYPE STRING,
CAPACITYREQUIREMENT TYPE STRING,
INSPECTIONLOT TYPE STRING,
CHANGENUMBER TYPE STRING,
BASICSCHEDULINGTYPE TYPE STRING,
FORECASTSCHEDULINGTYPE TYPE STRING,
PRODAVAILYCHECKPLANNINGTYPE TYPE STRING,
NTWKACCOUNTASSIGNMENTCODE TYPE STRING,
NETWORKPROFILE TYPE STRING,
PRODUCTCONFIGURATION TYPE STRING,
MATERIALREVISIONLEVEL TYPE STRING,
CAPACITYACTIVEVERSION TYPE STRING,
CAPACITYRQMTHASNOTTOBECREATED TYPE STRING,
ORDERSEQUENCENUMBER TYPE STRING,
ACTUALCOSTSCOSTINGVARIANT TYPE STRING,
PLANNEDCOSTSCOSTINGVARIANT TYPE STRING,
MATERIAL TYPE STRING,
BILLOFOPERATIONSTYPE TYPE STRING,
BILLOFOPERATIONSGROUP TYPE STRING,
BILLOFOPERATIONSVARIANT TYPE STRING,
BOOINTERNALVERSIONCOUNTER TYPE STRING,
BILLOFOPERATIONSUSAGE TYPE STRING,
BILLOFOPERATIONSVERSION TYPE STRING,
BOOEXPLOSIONDATE TYPE STRING,
BOOVALIDITYSTARTDATE TYPE STRING,
BILLOFOPERATIONS TYPE STRING,
BILLOFMATERIALCATEGORY TYPE STRING,
BILLOFMATERIAL TYPE STRING,
BILLOFMATERIALVARIANT TYPE STRING,
BILLOFMATERIALVARIANTUSAGE TYPE STRING,
BILLOFMATERIALVERSION TYPE STRING,
BOMEXPLOSIONDATE TYPE STRING,
BOMVALIDITYSTARTDATE TYPE STRING,
MASTERPRODUCTIONORDER TYPE STRING,
PLANNEDSTARTDATE TYPE STRING,
PLANNEDSTARTTIME TYPE STRING,
PLANNEDENDDATE TYPE STRING,
PLANNEDENDTIME TYPE STRING,
SCHEDULEDBASICSTARTDATE TYPE STRING,
SCHEDULEDBASICSTARTTIME TYPE STRING,
SCHEDULEDBASICENDDATE TYPE STRING,
SCHEDULEDBASICENDTIME TYPE STRING,
SCHEDULEDRELEASEDATE TYPE STRING,
ACTUALSTARTDATE TYPE STRING,
ACTUALSTARTTIME TYPE STRING,
ACTUALENDDATE TYPE STRING,
ACTUALRELEASEDDATE TYPE STRING,
CONFIRMEDENDDATE TYPE STRING,
CONFIRMEDENDTIME TYPE STRING,
SCHEDULEDFORECASTEDSTARTDATE TYPE STRING,
SCHEDULEDFORECASTEDSTARTTIME TYPE STRING,
SCHEDULEDFORECASTEDENDDATE TYPE STRING,
SCHEDULEDFORECASTEDENDTIME TYPE STRING,
SCHEDULEDFCSTDRELEASEDATE TYPE STRING,
FORECASTEDSTARTDATE TYPE STRING,
FORECASTEDSTARTTIME TYPE STRING,
FORECASTEDENDDATE TYPE STRING,
FORECASTEDENDTIME TYPE STRING,
TOTALCOMMITMENTDATE TYPE STRING,
LASTSCHEDULEDDATE TYPE STRING,
BASEUNIT TYPE STRING,
ORDERPLANNEDTOTALQTY TYPE STRING,
ORDERPLANNEDSCRAPQTY TYPE STRING,
ORDERCONFIRMEDYIELDQTY TYPE STRING,
ORDERCONFIRMEDSCRAPQTY TYPE STRING,
MFGORDERCONFIRMEDREWORKQTY TYPE STRING,
TOTALCONFIRMEDQUANTITY TYPE STRING,
MATERIALFROMLOTSIZEQUANTITY TYPE STRING,
MATERIALTOLOTSIZEQUANTITY TYPE STRING,END OF T_EKKO_STR. DATA: WA_ILOGSORDBASIC_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_ILOGSORDBASIC_STR-MANDT sy-vline
WA_ILOGSORDBASIC_STR-ORDERID sy-vline
WA_ILOGSORDBASIC_STR-ORDERINTERNALID sy-vline
WA_ILOGSORDBASIC_STR-PRIORITYCODE sy-vline
WA_ILOGSORDBASIC_STR-MFGORDERISPARTOFCOLLVORDER sy-vline
WA_ILOGSORDBASIC_STR-ORDERISNOTCOSTEDAUTOMATICALLY sy-vline
WA_ILOGSORDBASIC_STR-ORDISNOTSCHEDLDAUTOMATICALLY sy-vline
WA_ILOGSORDBASIC_STR-MFGORDERHIERARCHYLEVEL sy-vline
WA_ILOGSORDBASIC_STR-PRODNPROCGISFLEXIBLE sy-vline
WA_ILOGSORDBASIC_STR-MFGORDERSUPERIORMFGORDER sy-vline
WA_ILOGSORDBASIC_STR-LEADINGORDER sy-vline
WA_ILOGSORDBASIC_STR-MRPCONTROLLER sy-vline
WA_ILOGSORDBASIC_STR-PRODUCTIONSUPERVISOR sy-vline
WA_ILOGSORDBASIC_STR-PRODUCTIONSCHEDULINGPROFILE sy-vline
WA_ILOGSORDBASIC_STR-RESPONSIBLEPLANNERGROUP sy-vline
WA_ILOGSORDBASIC_STR-PROJECTINTERNALID sy-vline
WA_ILOGSORDBASIC_STR-SUPERIORPROJECTNETWORK sy-vline
WA_ILOGSORDBASIC_STR-RESERVATION sy-vline
WA_ILOGSORDBASIC_STR-SETTLEMENTRESERVATION sy-vline
WA_ILOGSORDBASIC_STR-MFGORDERCONFIRMATION sy-vline
WA_ILOGSORDBASIC_STR-MFGORDERCONFIRMATIONCOUNT sy-vline
WA_ILOGSORDBASIC_STR-CAPACITYREQUIREMENT sy-vline
WA_ILOGSORDBASIC_STR-INSPECTIONLOT sy-vline
WA_ILOGSORDBASIC_STR-CHANGENUMBER sy-vline
WA_ILOGSORDBASIC_STR-BASICSCHEDULINGTYPE sy-vline
WA_ILOGSORDBASIC_STR-FORECASTSCHEDULINGTYPE sy-vline
WA_ILOGSORDBASIC_STR-PRODAVAILYCHECKPLANNINGTYPE sy-vline
WA_ILOGSORDBASIC_STR-NTWKACCOUNTASSIGNMENTCODE sy-vline
WA_ILOGSORDBASIC_STR-NETWORKPROFILE sy-vline
WA_ILOGSORDBASIC_STR-PRODUCTCONFIGURATION sy-vline
WA_ILOGSORDBASIC_STR-MATERIALREVISIONLEVEL sy-vline
WA_ILOGSORDBASIC_STR-CAPACITYACTIVEVERSION sy-vline
WA_ILOGSORDBASIC_STR-CAPACITYRQMTHASNOTTOBECREATED sy-vline
WA_ILOGSORDBASIC_STR-ORDERSEQUENCENUMBER sy-vline
WA_ILOGSORDBASIC_STR-ACTUALCOSTSCOSTINGVARIANT sy-vline
WA_ILOGSORDBASIC_STR-PLANNEDCOSTSCOSTINGVARIANT sy-vline
WA_ILOGSORDBASIC_STR-MATERIAL sy-vline
WA_ILOGSORDBASIC_STR-BILLOFOPERATIONSTYPE sy-vline
WA_ILOGSORDBASIC_STR-BILLOFOPERATIONSGROUP sy-vline
WA_ILOGSORDBASIC_STR-BILLOFOPERATIONSVARIANT sy-vline
WA_ILOGSORDBASIC_STR-BOOINTERNALVERSIONCOUNTER sy-vline
WA_ILOGSORDBASIC_STR-BILLOFOPERATIONSUSAGE sy-vline
WA_ILOGSORDBASIC_STR-BILLOFOPERATIONSVERSION sy-vline
WA_ILOGSORDBASIC_STR-BOOEXPLOSIONDATE sy-vline
WA_ILOGSORDBASIC_STR-BOOVALIDITYSTARTDATE sy-vline
WA_ILOGSORDBASIC_STR-BILLOFOPERATIONS sy-vline
WA_ILOGSORDBASIC_STR-BILLOFMATERIALCATEGORY sy-vline
WA_ILOGSORDBASIC_STR-BILLOFMATERIAL sy-vline
WA_ILOGSORDBASIC_STR-BILLOFMATERIALVARIANT sy-vline
WA_ILOGSORDBASIC_STR-BILLOFMATERIALVARIANTUSAGE sy-vline
WA_ILOGSORDBASIC_STR-BILLOFMATERIALVERSION sy-vline
WA_ILOGSORDBASIC_STR-BOMEXPLOSIONDATE sy-vline
WA_ILOGSORDBASIC_STR-BOMVALIDITYSTARTDATE sy-vline
WA_ILOGSORDBASIC_STR-MASTERPRODUCTIONORDER sy-vline
WA_ILOGSORDBASIC_STR-PLANNEDSTARTDATE sy-vline
WA_ILOGSORDBASIC_STR-PLANNEDSTARTTIME sy-vline
WA_ILOGSORDBASIC_STR-PLANNEDENDDATE sy-vline
WA_ILOGSORDBASIC_STR-PLANNEDENDTIME sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDBASICSTARTDATE sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDBASICSTARTTIME sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDBASICENDDATE sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDBASICENDTIME sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDRELEASEDATE sy-vline
WA_ILOGSORDBASIC_STR-ACTUALSTARTDATE sy-vline
WA_ILOGSORDBASIC_STR-ACTUALSTARTTIME sy-vline
WA_ILOGSORDBASIC_STR-ACTUALENDDATE sy-vline
WA_ILOGSORDBASIC_STR-ACTUALRELEASEDDATE sy-vline
WA_ILOGSORDBASIC_STR-CONFIRMEDENDDATE sy-vline
WA_ILOGSORDBASIC_STR-CONFIRMEDENDTIME sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDFORECASTEDSTARTDATE sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDFORECASTEDSTARTTIME sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDFORECASTEDENDDATE sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDFORECASTEDENDTIME sy-vline
WA_ILOGSORDBASIC_STR-SCHEDULEDFCSTDRELEASEDATE sy-vline
WA_ILOGSORDBASIC_STR-FORECASTEDSTARTDATE sy-vline
WA_ILOGSORDBASIC_STR-FORECASTEDSTARTTIME sy-vline
WA_ILOGSORDBASIC_STR-FORECASTEDENDDATE sy-vline
WA_ILOGSORDBASIC_STR-FORECASTEDENDTIME sy-vline
WA_ILOGSORDBASIC_STR-TOTALCOMMITMENTDATE sy-vline
WA_ILOGSORDBASIC_STR-LASTSCHEDULEDDATE sy-vline
WA_ILOGSORDBASIC_STR-BASEUNIT sy-vline
WA_ILOGSORDBASIC_STR-ORDERPLANNEDTOTALQTY sy-vline
WA_ILOGSORDBASIC_STR-ORDERPLANNEDSCRAPQTY sy-vline
WA_ILOGSORDBASIC_STR-ORDERCONFIRMEDYIELDQTY sy-vline
WA_ILOGSORDBASIC_STR-ORDERCONFIRMEDSCRAPQTY sy-vline
WA_ILOGSORDBASIC_STR-MFGORDERCONFIRMEDREWORKQTY sy-vline
WA_ILOGSORDBASIC_STR-TOTALCONFIRMEDQUANTITY sy-vline
WA_ILOGSORDBASIC_STR-MATERIALFROMLOTSIZEQUANTITY sy-vline
WA_ILOGSORDBASIC_STR-MATERIALTOLOTSIZEQUANTITY sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.