ABAP Select data from SAP table CFS_S_PRT_ITEM_DETAIL into internal table

Get Example source ABAP code based on a different SAP table
  Get ABAP code

Below is a number of ABAP code snippets to demonstrate how to select data from SAP CFS_S_PRT_ITEM_DETAIL 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 CFS_S_PRT_ITEM_DETAIL. 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 CFS_S_PRT_ITEM_DETAIL 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_CFS_S_PRT_ITEM_DETAIL TYPE STANDARD TABLE OF CFS_S_PRT_ITEM_DETAIL,
      WA_CFS_S_PRT_ITEM_DETAIL TYPE CFS_S_PRT_ITEM_DETAIL,
      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: <CFS_S_PRT_ITEM_DETAIL> TYPE CFS_S_PRT_ITEM_DETAIL.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CFS_S_PRT_ITEM_DETAIL
*  INTO TABLE @DATA(IT_CFS_S_PRT_ITEM_DETAIL2).
*--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_CFS_S_PRT_ITEM_DETAIL INDEX 1 INTO DATA(WA_CFS_S_PRT_ITEM_DETAIL2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_CFS_S_PRT_ITEM_DETAIL ASSIGNING <CFS_S_PRT_ITEM_DETAIL>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CFS_S_PRT_ITEM_DETAIL>-KUNNR = 1.
<CFS_S_PRT_ITEM_DETAIL>-ADDRESS_DATA = 1.
<CFS_S_PRT_ITEM_DETAIL>-TITLE = 1.
<CFS_S_PRT_ITEM_DETAIL>-TITLE_TEXT = 1.
<CFS_S_PRT_ITEM_DETAIL>-NAME1 = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CFS_S_PRT_ITEM_DETAIL-NAME2, sy-vline,
  WA_CFS_S_PRT_ITEM_DETAIL-NAME3, sy-vline,
  WA_CFS_S_PRT_ITEM_DETAIL-NAME4, sy-vline,
  WA_CFS_S_PRT_ITEM_DETAIL-NAME_TXT, sy-vline,
  WA_CFS_S_PRT_ITEM_DETAIL-NAME_CO, sy-vline,
  WA_CFS_S_PRT_ITEM_DETAIL-STREET, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CFS_S_PRT_ITEM_DETAIL 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_CFS_S_PRT_ITEM_DETAIL 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_CFS_S_PRT_ITEM_DETAIL INTO WA_CFS_S_PRT_ITEM_DETAIL.


*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 KUNNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CFS_S_PRT_ITEM_DETAIL-KUNNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CFS_S_PRT_ITEM_DETAIL-KUNNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit ISOLA, internal->external for field LANGU
CALL FUNCTION 'CONVERSION_EXIT_ISOLA_OUTPUT'
  EXPORTING
    input =                      WA_CFS_S_PRT_ITEM_DETAIL-LANGU
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CFS_S_PRT_ITEM_DETAIL-LANGU.
WRITE:/ 'New Value:', ld_input.

*Conversion exit SXIDN, internal->external for field EMAIL
CALL FUNCTION 'CONVERSION_EXIT_SXIDN_OUTPUT'
  EXPORTING
    input =                      WA_CFS_S_PRT_ITEM_DETAIL-EMAIL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CFS_S_PRT_ITEM_DETAIL-EMAIL.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field LAST_DELIVERY
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_CFS_S_PRT_ITEM_DETAIL-LAST_DELIVERY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CFS_S_PRT_ITEM_DETAIL-LAST_DELIVERY.
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_CFS_S_PRT_ITEM_DETAIL_STR, 
KUNNR TYPE STRING,
ADDRESS_DATA TYPE STRING,
TITLE TYPE STRING,
TITLE_TEXT TYPE STRING,
NAME1 TYPE STRING,
NAME2 TYPE STRING,
NAME3 TYPE STRING,
NAME4 TYPE STRING,
NAME_TXT TYPE STRING,
NAME_CO TYPE STRING,
STREET TYPE STRING,
HOUSE_NUM1 TYPE STRING,
POST_CODE1 TYPE STRING,
POST_CODE2 TYPE STRING,
POST_CODE3 TYPE STRING,
CITY1 TYPE STRING,
CITY2 TYPE STRING,
PO_BOX TYPE STRING,
PO_BOX_LOC TYPE STRING,
PO_BOX_REG TYPE STRING,
PO_BOX_CTY TYPE STRING,
COUNTRY TYPE STRING,
LANGU TYPE STRING,
REGION TYPE STRING,
TRANSPZONE TYPE STRING,
TELNR_LONG TYPE STRING,
MOBILE_LONG TYPE STRING,
FAXNR_LONG TYPE STRING,
EMAIL TYPE STRING,
HOME_PAGE TYPE STRING,
ADRNR TYPE STRING,
SENDING_COUNTRY TYPE STRING,
CLASSIFICATION TYPE STRING,
NIELS TYPE STRING,
NIELSBEZ TYPE STRING,
RPMKR TYPE STRING,
KUKLA TYPE STRING,
KUKLABEZ TYPE STRING,
BRSCH TYPE STRING,
BRSCHBEZ TYPE STRING,
BRAN1 TYPE STRING,
BRAN1BEZ TYPE STRING,
BRAN2 TYPE STRING,
BRAN2BEZ TYPE STRING,
BRAN3 TYPE STRING,
BRAN3BEZ TYPE STRING,
BRAN4 TYPE STRING,
BRAN4BEZ TYPE STRING,
BRAN5 TYPE STRING,
BRAN5BEZ TYPE STRING,
KEY_FIGURES TYPE STRING,
UMSA1 TYPE STRING,
UWAER TYPE STRING,
UMJAH TYPE STRING,
JMZAH TYPE STRING,
JMJAH TYPE STRING,
PERIV TYPE STRING,
PERIVBEZ TYPE STRING,
GFORM TYPE STRING,
GFORMBEZ TYPE STRING,
CONTACT_PERSON TYPE STRING,
ORDER_INFO_CUST TYPE STRING,
PRICING_CUST TYPE STRING,
SHIPPING_CUST TYPE STRING,
PART_DELIVERIES TYPE STRING,
TRANSP_DATA TYPE STRING,
BBBNR TYPE STRING,
BBSNR TYPE STRING,
BUBKZ TYPE STRING,
BRSCH TYPE STRING,
BRSCHTXT TYPE STRING,
BAHNS TYPE STRING,
BAHNE TYPE STRING,
LZONE TYPE STRING,
LZONETEXT TYPE STRING,
LOCCO TYPE STRING,
BILLING_DATA TYPE STRING,
DELIVERY_TERMS TYPE STRING,
PARTNER_DATA TYPE STRING,
STATISTICS_S001 TYPE STRING,
STATISTICS_MEAS TYPE STRING,
LAST_SD_DOC TYPE STRING,
Q_NOTIFICATIONS TYPE STRING,
ZHLMELD TYPE STRING,
ZHLMOFN TYPE STRING,
ZHLMIAR TYPE STRING,
ZHLMMAB TYPE STRING,
QMELDTAB TYPE STRING,
S_NOTIFICATIONS TYPE STRING,
SMOFN TYPE STRING,
SMMAB TYPE STRING,
SGAUSZT TYPE STRING,
SUNIT TYPE STRING,
QMELDTAB TYPE STRING,
CREDIT_INFO TYPE STRING,
PROMOTIONS TYPE STRING,
PAYMENT_CARDS TYPE STRING,
QUICKINFO TYPE STRING,
KUNNR TYPE STRING,
NUM_DELIVERY_BLOCK TYPE STRING,
NUM_INVOICE_BLOCK TYPE STRING,
NUM_BACKLOG TYPE STRING,
NUM_OPEN_ORDER TYPE STRING,
NUM_OPEN_DELIVERY TYPE STRING,
NUM_OPEN_INVOICE TYPE STRING,
CONSUMPTION_CREDIT_LIMIT TYPE STRING,
FLAG_CUSTOMER_HIERARCHY TYPE STRING,
FLAG_CUSTOMER_MATERIAL_INFO TYPE STRING,
FLAG_CREDIT_INFO TYPE STRING,
FLAG_REMINDER TYPE STRING,
DATE_LAST_REMINDER TYPE STRING,
BUKRS TYPE STRING,
LAST_ORDER TYPE STRING,
LAST_INVOICE TYPE STRING,
NEXT_CONTACT TYPE STRING,
LAST_DELIVERY TYPE STRING,
DATE_LAST_ORDER TYPE STRING,
DATE_LAST_INVOICE TYPE STRING,
DATE_NEXT_CONTACT TYPE STRING,
DATE_LAST_DELIVERY TYPE STRING,
BACKORDERS TYPE STRING,
EX_ADDRESS_DATA TYPE STRING,
EX_CLASSIFICATION TYPE STRING,
EX_KEY_FIGURES TYPE STRING,
EX_CONTACT_PERSON TYPE STRING,
EX_ORDER_INFO_CUST TYPE STRING,
EX_PRICING_CUST TYPE STRING,
EX_SHIPPING_CUST TYPE STRING,
EX_PART_DELIVERIES TYPE STRING,
EX_TRANSP_DATA TYPE STRING,
EX_BILLING_DATA TYPE STRING,
EX_DELIVERY_TERMS TYPE STRING,
EX_PARTNER_DATA TYPE STRING,
EX_STATISTICS_S001 TYPE STRING,
EX_STATISTICS_MEAS TYPE STRING,
EX_LAST_SD_DOC TYPE STRING,
EX_Q_NOTIFICATIONS TYPE STRING,
EX_Q_MELDTAB TYPE STRING,
EX_S_NOTIFICATIONS TYPE STRING,
EX_S_MELDTAB TYPE STRING,
EX_CREDIT_INFO TYPE STRING,
EX_PROMOTIONS TYPE STRING,
EX_PAYMENT_CARDS TYPE STRING,
EX_QUICKINFO TYPE STRING,
EX_BACKORDERS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CFS_S_PRT_ITEM_DETAIL_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_CFS_S_PRT_ITEM_DETAIL_STR-KUNNR sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-ADDRESS_DATA sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-TITLE sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-TITLE_TEXT sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NAME1 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NAME2 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NAME3 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NAME4 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NAME_TXT sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NAME_CO sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-STREET sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-HOUSE_NUM1 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-POST_CODE1 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-POST_CODE2 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-POST_CODE3 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-CITY1 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-CITY2 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PO_BOX sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PO_BOX_LOC sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PO_BOX_REG sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PO_BOX_CTY sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-COUNTRY sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-LANGU sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-REGION sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-TRANSPZONE sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-TELNR_LONG sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-MOBILE_LONG sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-FAXNR_LONG sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EMAIL sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-HOME_PAGE sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-ADRNR sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-SENDING_COUNTRY sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-CLASSIFICATION sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NIELS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NIELSBEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-RPMKR sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-KUKLA sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-KUKLABEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRSCH sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRSCHBEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN1 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN1BEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN2 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN2BEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN3 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN3BEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN4 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN4BEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN5 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRAN5BEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-KEY_FIGURES sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-UMSA1 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-UWAER sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-UMJAH sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-JMZAH sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-JMJAH sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PERIV sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PERIVBEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-GFORM sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-GFORMBEZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-CONTACT_PERSON sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-ORDER_INFO_CUST sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PRICING_CUST sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-SHIPPING_CUST sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PART_DELIVERIES sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-TRANSP_DATA sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BBBNR sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BBSNR sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BUBKZ sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRSCH sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BRSCHTXT sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BAHNS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BAHNE sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-LZONE sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-LZONETEXT sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-LOCCO sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BILLING_DATA sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-DELIVERY_TERMS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PARTNER_DATA sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-STATISTICS_S001 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-STATISTICS_MEAS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-LAST_SD_DOC sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-Q_NOTIFICATIONS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-ZHLMELD sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-ZHLMOFN sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-ZHLMIAR sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-ZHLMMAB sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-QMELDTAB sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-S_NOTIFICATIONS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-SMOFN sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-SMMAB sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-SGAUSZT sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-SUNIT sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-QMELDTAB sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-CREDIT_INFO sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PROMOTIONS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-PAYMENT_CARDS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-QUICKINFO sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-KUNNR sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NUM_DELIVERY_BLOCK sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NUM_INVOICE_BLOCK sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NUM_BACKLOG sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NUM_OPEN_ORDER sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NUM_OPEN_DELIVERY sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NUM_OPEN_INVOICE sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-CONSUMPTION_CREDIT_LIMIT sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-FLAG_CUSTOMER_HIERARCHY sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-FLAG_CUSTOMER_MATERIAL_INFO sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-FLAG_CREDIT_INFO sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-FLAG_REMINDER sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-DATE_LAST_REMINDER sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BUKRS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-LAST_ORDER sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-LAST_INVOICE sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-NEXT_CONTACT sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-LAST_DELIVERY sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-DATE_LAST_ORDER sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-DATE_LAST_INVOICE sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-DATE_NEXT_CONTACT sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-DATE_LAST_DELIVERY sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-BACKORDERS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_ADDRESS_DATA sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_CLASSIFICATION sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_KEY_FIGURES sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_CONTACT_PERSON sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_ORDER_INFO_CUST sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_PRICING_CUST sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_SHIPPING_CUST sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_PART_DELIVERIES sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_TRANSP_DATA sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_BILLING_DATA sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_DELIVERY_TERMS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_PARTNER_DATA sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_STATISTICS_S001 sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_STATISTICS_MEAS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_LAST_SD_DOC sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_Q_NOTIFICATIONS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_Q_MELDTAB sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_S_NOTIFICATIONS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_S_MELDTAB sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_CREDIT_INFO sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_PROMOTIONS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_PAYMENT_CARDS sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_QUICKINFO sy-vline 
WA_CFS_S_PRT_ITEM_DETAIL_STR-EX_BACKORDERS sy-vline      INTO ld_text SEPARATED BY SPACE.

*Add any further fields from structure WA_EKKO_STR you want to CONCATENATE...
ENDLOOP.
ENDFORM.