ABAP Select data from SAP table RFM_TS_IALIGNAASLPURITM 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 RFM_TS_IALIGNAASLPURITM 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 RFM_TS_IALIGNAASLPURITM. 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 RFM_TS_IALIGNAASLPURITM 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_RFM_TS_IALIGNAASLPURITM TYPE STANDARD TABLE OF RFM_TS_IALIGNAASLPURITM,
      WA_RFM_TS_IALIGNAASLPURITM TYPE RFM_TS_IALIGNAASLPURITM,
      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: <RFM_TS_IALIGNAASLPURITM> TYPE RFM_TS_IALIGNAASLPURITM.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM RFM_TS_IALIGNAASLPURITM
  INTO TABLE IT_RFM_TS_IALIGNAASLPURITM.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM RFM_TS_IALIGNAASLPURITM
*  INTO TABLE @DATA(IT_RFM_TS_IALIGNAASLPURITM2).
*--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_RFM_TS_IALIGNAASLPURITM INDEX 1 INTO DATA(WA_RFM_TS_IALIGNAASLPURITM2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_RFM_TS_IALIGNAASLPURITM ASSIGNING <RFM_TS_IALIGNAASLPURITM>.
*To update a field value using a field symbol simply change the value via the field symbol pointer
<RFM_TS_IALIGNAASLPURITM>-MANDT = 1.
<RFM_TS_IALIGNAASLPURITM>-PURCHASEREQUISITION = 1.
<RFM_TS_IALIGNAASLPURITM>-PURCHASEREQUISITIONITEM = 1.
<RFM_TS_IALIGNAASLPURITM>-COMPANYCODE = 1.
<RFM_TS_IALIGNAASLPURITM>-PURCHASEREQITEMSUPPLIER = 1.
ENDLOOP.

LOOP AT IT_RFM_TS_IALIGNAASLPURITM INTO WA_RFM_TS_IALIGNAASLPURITM.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_RFM_TS_IALIGNAASLPURITM-FIXEDSUPPLIER, sy-vline,
WA_RFM_TS_IALIGNAASLPURITM-PURREQNITEMPURCHASINGORG, sy-vline,
WA_RFM_TS_IALIGNAASLPURITM-PURREQNITEMPURCHASINGGROUP, sy-vline,
WA_RFM_TS_IALIGNAASLPURITM-PURCHASEREQUISITIONTYPE, sy-vline,
WA_RFM_TS_IALIGNAASLPURITM-PRODUCTCATEGORY, sy-vline,
WA_RFM_TS_IALIGNAASLPURITM-PRODUCTCATEGORYNAME, sy-vline.
ENDLOOP. *Add any further fields from structure WA_RFM_TS_IALIGNAASLPURITM 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_RFM_TS_IALIGNAASLPURITM 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_RFM_TS_IALIGNAASLPURITM INTO WA_RFM_TS_IALIGNAASLPURITM. *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 PURCHASEREQUISITION CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_RFM_TS_IALIGNAASLPURITM-PURCHASEREQUISITION IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RFM_TS_IALIGNAASLPURITM-PURCHASEREQUISITION.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

*Conversion exit AUART, internal->external for field SALESDOCUMENTTYPE CALL FUNCTION 'CONVERSION_EXIT_AUART_OUTPUT' EXPORTING input = WA_RFM_TS_IALIGNAASLPURITM-SALESDOCUMENTTYPE IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RFM_TS_IALIGNAASLPURITM-SALESDOCUMENTTYPE.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit MATN1, internal->external for field PRODUCT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_RFM_TS_IALIGNAASLPURITM-PRODUCT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RFM_TS_IALIGNAASLPURITM-PRODUCT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit NUMCV, internal->external for field BILLOFMATERIAL CALL FUNCTION 'CONVERSION_EXIT_NUMCV_OUTPUT' EXPORTING input = WA_RFM_TS_IALIGNAASLPURITM-BILLOFMATERIAL IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RFM_TS_IALIGNAASLPURITM-BILLOFMATERIAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field PRODUCTOFHIGHERLEVELITEM CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_RFM_TS_IALIGNAASLPURITM-PRODUCTOFHIGHERLEVELITEM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RFM_TS_IALIGNAASLPURITM-PRODUCTOFHIGHERLEVELITEM.
WRITE:/ 'New Value:', ld_input.

*Conversion exit MATN1, internal->external for field CROSSPLANTCONFIGURABLEPRODUCT CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT' EXPORTING input = WA_RFM_TS_IALIGNAASLPURITM-CROSSPLANTCONFIGURABLEPRODUCT IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RFM_TS_IALIGNAASLPURITM-CROSSPLANTCONFIGURABLEPRODUCT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field PURREQNITEMALIGNMENTQTYUOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_RFM_TS_IALIGNAASLPURITM-PURREQNITEMALIGNMENTQTYUOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_RFM_TS_IALIGNAASLPURITM-PURREQNITEMALIGNMENTQTYUOM.
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_RFM_TS_IALIGNAASLPURITM_STR,
MANDT TYPE STRING,
PURCHASEREQUISITION TYPE STRING,
PURCHASEREQUISITIONITEM TYPE STRING,
COMPANYCODE TYPE STRING,
PURCHASEREQITEMSUPPLIER TYPE STRING,
FIXEDSUPPLIER TYPE STRING,
PURREQNITEMPURCHASINGORG TYPE STRING,
PURREQNITEMPURCHASINGGROUP TYPE STRING,
PURCHASEREQUISITIONTYPE TYPE STRING,
PRODUCTCATEGORY TYPE STRING,
PRODUCTCATEGORYNAME TYPE STRING,
MATERIALGROUP TYPE STRING,
REQUESTEDQUANTITY TYPE STRING,
PURREQNITEMPURCHASECONTRACT TYPE STRING,
PURREQNITEMPURCONTRACTITEM TYPE STRING,
PURCHASEREQUISITIONUNIT TYPE STRING,
BASEUNIT TYPE STRING,
PURCHASEREQUISITIONITEMPLANT TYPE STRING,
PURCHASEREQNITEMSEASONYEAR TYPE STRING,
PURCHASEREQNITEMSEASON TYPE STRING,
PURCHASEREQNITEMCOLLECTION TYPE STRING,
PURCHASEREQNITEMTHEME TYPE STRING,
PURCHASEREQNITEMSTOCKSEGMENT TYPE STRING,
DELIVERYDATE TYPE STRING,
PURCHASINGINFORECORD TYPE STRING,
PURREQNITMPLNTCOCODECRCY TYPE STRING,
SALESORDER TYPE STRING,
SALESORDERITEM TYPE STRING,
SALESORDERSCHEDULELINE TYPE STRING,
PURCHASECONTRACTQUANTITYUNIT TYPE STRING,
CONTRACTITEMQTYTOBASEQTYNMRTR TYPE STRING,
CONTRACTITEMQTYTOBASEQTYDNMNTR TYPE STRING,
REQNITMCONTRITMOPNQTYINBASEUOM TYPE STRING,
SALESDOCUMENTTYPE TYPE STRING,
SALESORGANIZATION TYPE STRING,
DISTRIBUTIONCHANNEL TYPE STRING,
ORGANIZATIONDIVISION TYPE STRING,
SOLDTOPARTY TYPE STRING,
SHIPTOPARTY TYPE STRING,
PRODUCT TYPE STRING,
BILLOFMATERIAL TYPE STRING,
PRODUCTNAME TYPE STRING,
HIGHERLEVELITEM TYPE STRING,
PRODUCTOFHIGHERLEVELITEM TYPE STRING,
CROSSPLANTCONFIGURABLEPRODUCT TYPE STRING,
SCHEDULELINECATEGORY TYPE STRING,
SALESACCOUNTASSIGNMENTTYPE TYPE STRING,
PRODUCTCHARACTERISTIC1 TYPE STRING,
PRODUCTCHARACTERISTIC1DESC TYPE STRING,
PRODUCTCHARACTERISTIC2 TYPE STRING,
PRODUCTCHARACTERISTIC2DESC TYPE STRING,
PRODUCTCHARACTERISTIC3 TYPE STRING,
PRODUCTCHARACTERISTIC3DESC TYPE STRING,
SALESOFFICE TYPE STRING,
SDDOCUMENTREASON TYPE STRING,
CREATIONDATE TYPE STRING,
FASHIONCANCELDATE TYPE STRING,
DELIVERYPRIORITY TYPE STRING,
ORGANIZATIONBPNAME1 TYPE STRING,
DELIVERYDATE_FROM TYPE STRING,
DELIVERYDATE_TO TYPE STRING,
PURREQNITEMALIGNMENTREQDQTY TYPE STRING,
PURREQNITEMALIGNMENTQTYUOM TYPE STRING,
PURREQNITEMALGNMTQTYTOLTYPE TYPE STRING,END OF T_EKKO_STR. DATA: WA_RFM_TS_IALIGNAASLPURITM_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_RFM_TS_IALIGNAASLPURITM_STR-MANDT sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQUISITION sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQUISITIONITEM sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-COMPANYCODE sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQITEMSUPPLIER sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-FIXEDSUPPLIER sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURREQNITEMPURCHASINGORG sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURREQNITEMPURCHASINGGROUP sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQUISITIONTYPE sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTCATEGORY sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTCATEGORYNAME sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-MATERIALGROUP sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-REQUESTEDQUANTITY sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURREQNITEMPURCHASECONTRACT sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURREQNITEMPURCONTRACTITEM sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQUISITIONUNIT sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-BASEUNIT sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQUISITIONITEMPLANT sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQNITEMSEASONYEAR sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQNITEMSEASON sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQNITEMCOLLECTION sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQNITEMTHEME sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASEREQNITEMSTOCKSEGMENT sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-DELIVERYDATE sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASINGINFORECORD sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURREQNITMPLNTCOCODECRCY sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SALESORDER sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SALESORDERITEM sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SALESORDERSCHEDULELINE sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURCHASECONTRACTQUANTITYUNIT sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-CONTRACTITEMQTYTOBASEQTYNMRTR sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-CONTRACTITEMQTYTOBASEQTYDNMNTR sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-REQNITMCONTRITMOPNQTYINBASEUOM sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SALESDOCUMENTTYPE sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SALESORGANIZATION sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-DISTRIBUTIONCHANNEL sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-ORGANIZATIONDIVISION sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SOLDTOPARTY sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SHIPTOPARTY sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCT sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-BILLOFMATERIAL sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTNAME sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-HIGHERLEVELITEM sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTOFHIGHERLEVELITEM sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-CROSSPLANTCONFIGURABLEPRODUCT sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SCHEDULELINECATEGORY sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SALESACCOUNTASSIGNMENTTYPE sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTCHARACTERISTIC1 sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTCHARACTERISTIC1DESC sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTCHARACTERISTIC2 sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTCHARACTERISTIC2DESC sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTCHARACTERISTIC3 sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PRODUCTCHARACTERISTIC3DESC sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SALESOFFICE sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-SDDOCUMENTREASON sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-CREATIONDATE sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-FASHIONCANCELDATE sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-DELIVERYPRIORITY sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-ORGANIZATIONBPNAME1 sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-DELIVERYDATE_FROM sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-DELIVERYDATE_TO sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURREQNITEMALIGNMENTREQDQTY sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURREQNITEMALIGNMENTQTYUOM sy-vline
WA_RFM_TS_IALIGNAASLPURITM_STR-PURREQNITEMALGNMTQTYTOLTYPE sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.