ABAP Select data from SAP table NSDM_S_ITEM 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 NSDM_S_ITEM 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 NSDM_S_ITEM. 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 NSDM_S_ITEM 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_NSDM_S_ITEM TYPE STANDARD TABLE OF NSDM_S_ITEM,
      WA_NSDM_S_ITEM TYPE NSDM_S_ITEM,
      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: <NSDM_S_ITEM> TYPE NSDM_S_ITEM.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM NSDM_S_ITEM
*  INTO TABLE @DATA(IT_NSDM_S_ITEM2).
*--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_NSDM_S_ITEM INDEX 1 INTO DATA(WA_NSDM_S_ITEM2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<NSDM_S_ITEM>-BWART = 1.
<NSDM_S_ITEM>-XAUTO = 1.
<NSDM_S_ITEM>-MATNR = 1.
<NSDM_S_ITEM>-LGORT = 1.
<NSDM_S_ITEM>-CHARG = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_NSDM_S_ITEM-BWTAR, sy-vline,
  WA_NSDM_S_ITEM-INSMK, sy-vline,
  WA_NSDM_S_ITEM-ZUSCH, sy-vline,
  WA_NSDM_S_ITEM-ZUSTD, sy-vline,
  WA_NSDM_S_ITEM-LIFNR, sy-vline,
  WA_NSDM_S_ITEM-KUNNR, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_NSDM_S_ITEM 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_NSDM_S_ITEM 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_NSDM_S_ITEM INTO WA_NSDM_S_ITEM.


*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 MATN1, internal->external for field MATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_NSDM_S_ITEM-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_NSDM_S_ITEM-MATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

*Conversion exit IMKEY, internal->external for field IMKEY
CALL FUNCTION 'CONVERSION_EXIT_IMKEY_OUTPUT'
  EXPORTING
    input =                      WA_NSDM_S_ITEM-IMKEY
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_NSDM_S_ITEM-IMKEY.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ABPSP, internal->external for field PS_PSP_PNR
CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT'
  EXPORTING
    input =                      WA_NSDM_S_ITEM-PS_PSP_PNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_NSDM_S_ITEM-PS_PSP_PNR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit FMCIS, internal->external for field FIPOS
CALL FUNCTION 'CONVERSION_EXIT_FMCIS_OUTPUT'
  EXPORTING
    input =                      WA_NSDM_S_ITEM-FIPOS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_NSDM_S_ITEM-FIPOS.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ABPSP, internal->external for field ASS_PSPNR
CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT'
  EXPORTING
    input =                      WA_NSDM_S_ITEM-ASS_PSPNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_NSDM_S_ITEM-ASS_PSPNR.
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_NSDM_S_ITEM_STR, 
BWART TYPE STRING,
XAUTO TYPE STRING,
MATNR TYPE STRING,
LGORT TYPE STRING,
CHARG TYPE STRING,
BWTAR TYPE STRING,
INSMK TYPE STRING,
ZUSCH TYPE STRING,
ZUSTD TYPE STRING,
LIFNR TYPE STRING,
KUNNR TYPE STRING,
PLPLA TYPE STRING,
SHKZG TYPE STRING,
SHKUM TYPE STRING,
ELIKZ TYPE STRING,
SGTXT TYPE STRING,
EQUNR TYPE STRING,
WEMPF TYPE STRING,
ABLAD TYPE STRING,
GSBER TYPE STRING,
KOKRS TYPE STRING,
PARGB TYPE STRING,
PARBU TYPE STRING,
KOSTL TYPE STRING,
PROJN TYPE STRING,
XSKST TYPE STRING,
XSAUF TYPE STRING,
XSPRO TYPE STRING,
XSERG TYPE STRING,
XRUEM TYPE STRING,
XRUEJ TYPE STRING,
KZEAR TYPE STRING,
KZSTR TYPE STRING,
UMMAT TYPE STRING,
UMCHA TYPE STRING,
UMLGO TYPE STRING,
UMZST TYPE STRING,
UMZUS TYPE STRING,
KZBEW TYPE STRING,
KZVBR TYPE STRING,
KZZUG TYPE STRING,
WEUNB TYPE STRING,
PALAN TYPE STRING,
LGNUM TYPE STRING,
LGTYP TYPE STRING,
LGPLA TYPE STRING,
BESTQ TYPE STRING,
BWLVS TYPE STRING,
XBLVS TYPE STRING,
VSCHN TYPE STRING,
NSCHN TYPE STRING,
DYPLA TYPE STRING,
TBPRI TYPE STRING,
WEANZ TYPE STRING,
GRUND TYPE STRING,
EVERS TYPE STRING,
EVERE TYPE STRING,
IMKEY TYPE STRING,
KSTRG TYPE STRING,
PAOBJNR TYPE STRING,
PRCTR TYPE STRING,
PS_PSP_PNR TYPE STRING,
NPLNR TYPE STRING,
AUFPL TYPE STRING,
APLZL TYPE STRING,
AUFPS TYPE STRING,
VPTNR TYPE STRING,
FIPOS TYPE STRING,
SAKTO TYPE STRING,
XWSBR TYPE STRING,
EMLIF TYPE STRING,
AKTNR TYPE STRING,
ZEKKN TYPE STRING,
CUOBJ_CH TYPE STRING,
PPRCTR TYPE STRING,
RSART TYPE STRING,
GEBER TYPE STRING,
FISTL TYPE STRING,
BUSTM TYPE STRING,
BUSTW TYPE STRING,
VPRSV TYPE STRING,
FKBER TYPE STRING,
XBEAU TYPE STRING,
QINSPST TYPE STRING,
MWSKZ TYPE STRING,
TXJCD TYPE STRING,
EMATN TYPE STRING,
J_1AGIRUPD TYPE STRING,
VKMWS TYPE STRING,
BERKZ TYPE STRING,
XWOFF TYPE STRING,
BEMOT TYPE STRING,
PRZNR TYPE STRING,
LLIEF TYPE STRING,
LSTAR TYPE STRING,
XOBEW TYPE STRING,
GRANT_NBR TYPE STRING,
ZUSTD_T156M TYPE STRING,
SPE_GTS_STOCK_TY TYPE STRING,
KBLNR TYPE STRING,
KBLPOS TYPE STRING,
XMACC TYPE STRING,
UMMAB TYPE STRING,
UMBAR TYPE STRING,
UMWRK TYPE STRING,
UMSOK TYPE STRING,
SGT_SCAT TYPE STRING,
SGT_UMSCAT TYPE STRING,
SGT_RCAT TYPE STRING,
DISUB_OWNER TYPE STRING,
COMPL_MARK TYPE STRING,
FZGLS_MARK TYPE STRING,
ETANP_MARK TYPE STRING,
POPUP_MARK TYPE STRING,
XSAUT TYPE STRING,
SERVICEPERFORMER TYPE STRING,
PERNR TYPE STRING,
KNTTP_GR TYPE STRING,
WORK_ITEM_ID TYPE STRING,
FBUDA TYPE STRING,
DUMMY_INCL_EEW_COBL TYPE STRING,
FSH_SEASON_YEAR TYPE STRING,
FSH_SEASON TYPE STRING,
FSH_COLLECTION TYPE STRING,
FSH_THEME TYPE STRING,
WRF_CHARSTC1 TYPE STRING,
WRF_CHARSTC2 TYPE STRING,
WRF_CHARSTC3 TYPE STRING,
DUMMY_MATDOC_INCL_EEW_PS TYPE STRING,
OINAVNW TYPE STRING,
OICONDCOD TYPE STRING,
CONDI TYPE STRING,
ASS_PSPNR TYPE STRING,END OF T_EKKO_STR.
DATA: WA_NSDM_S_ITEM_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_NSDM_S_ITEM_STR-BWART sy-vline 
WA_NSDM_S_ITEM_STR-XAUTO sy-vline 
WA_NSDM_S_ITEM_STR-MATNR sy-vline 
WA_NSDM_S_ITEM_STR-LGORT sy-vline 
WA_NSDM_S_ITEM_STR-CHARG sy-vline 
WA_NSDM_S_ITEM_STR-BWTAR sy-vline 
WA_NSDM_S_ITEM_STR-INSMK sy-vline 
WA_NSDM_S_ITEM_STR-ZUSCH sy-vline 
WA_NSDM_S_ITEM_STR-ZUSTD sy-vline 
WA_NSDM_S_ITEM_STR-LIFNR sy-vline 
WA_NSDM_S_ITEM_STR-KUNNR sy-vline 
WA_NSDM_S_ITEM_STR-PLPLA sy-vline 
WA_NSDM_S_ITEM_STR-SHKZG sy-vline 
WA_NSDM_S_ITEM_STR-SHKUM sy-vline 
WA_NSDM_S_ITEM_STR-ELIKZ sy-vline 
WA_NSDM_S_ITEM_STR-SGTXT sy-vline 
WA_NSDM_S_ITEM_STR-EQUNR sy-vline 
WA_NSDM_S_ITEM_STR-WEMPF sy-vline 
WA_NSDM_S_ITEM_STR-ABLAD sy-vline 
WA_NSDM_S_ITEM_STR-GSBER sy-vline 
WA_NSDM_S_ITEM_STR-KOKRS sy-vline 
WA_NSDM_S_ITEM_STR-PARGB sy-vline 
WA_NSDM_S_ITEM_STR-PARBU sy-vline 
WA_NSDM_S_ITEM_STR-KOSTL sy-vline 
WA_NSDM_S_ITEM_STR-PROJN sy-vline 
WA_NSDM_S_ITEM_STR-XSKST sy-vline 
WA_NSDM_S_ITEM_STR-XSAUF sy-vline 
WA_NSDM_S_ITEM_STR-XSPRO sy-vline 
WA_NSDM_S_ITEM_STR-XSERG sy-vline 
WA_NSDM_S_ITEM_STR-XRUEM sy-vline 
WA_NSDM_S_ITEM_STR-XRUEJ sy-vline 
WA_NSDM_S_ITEM_STR-KZEAR sy-vline 
WA_NSDM_S_ITEM_STR-KZSTR sy-vline 
WA_NSDM_S_ITEM_STR-UMMAT sy-vline 
WA_NSDM_S_ITEM_STR-UMCHA sy-vline 
WA_NSDM_S_ITEM_STR-UMLGO sy-vline 
WA_NSDM_S_ITEM_STR-UMZST sy-vline 
WA_NSDM_S_ITEM_STR-UMZUS sy-vline 
WA_NSDM_S_ITEM_STR-KZBEW sy-vline 
WA_NSDM_S_ITEM_STR-KZVBR sy-vline 
WA_NSDM_S_ITEM_STR-KZZUG sy-vline 
WA_NSDM_S_ITEM_STR-WEUNB sy-vline 
WA_NSDM_S_ITEM_STR-PALAN sy-vline 
WA_NSDM_S_ITEM_STR-LGNUM sy-vline 
WA_NSDM_S_ITEM_STR-LGTYP sy-vline 
WA_NSDM_S_ITEM_STR-LGPLA sy-vline 
WA_NSDM_S_ITEM_STR-BESTQ sy-vline 
WA_NSDM_S_ITEM_STR-BWLVS sy-vline 
WA_NSDM_S_ITEM_STR-XBLVS sy-vline 
WA_NSDM_S_ITEM_STR-VSCHN sy-vline 
WA_NSDM_S_ITEM_STR-NSCHN sy-vline 
WA_NSDM_S_ITEM_STR-DYPLA sy-vline 
WA_NSDM_S_ITEM_STR-TBPRI sy-vline 
WA_NSDM_S_ITEM_STR-WEANZ sy-vline 
WA_NSDM_S_ITEM_STR-GRUND sy-vline 
WA_NSDM_S_ITEM_STR-EVERS sy-vline 
WA_NSDM_S_ITEM_STR-EVERE sy-vline 
WA_NSDM_S_ITEM_STR-IMKEY sy-vline 
WA_NSDM_S_ITEM_STR-KSTRG sy-vline 
WA_NSDM_S_ITEM_STR-PAOBJNR sy-vline 
WA_NSDM_S_ITEM_STR-PRCTR sy-vline 
WA_NSDM_S_ITEM_STR-PS_PSP_PNR sy-vline 
WA_NSDM_S_ITEM_STR-NPLNR sy-vline 
WA_NSDM_S_ITEM_STR-AUFPL sy-vline 
WA_NSDM_S_ITEM_STR-APLZL sy-vline 
WA_NSDM_S_ITEM_STR-AUFPS sy-vline 
WA_NSDM_S_ITEM_STR-VPTNR sy-vline 
WA_NSDM_S_ITEM_STR-FIPOS sy-vline 
WA_NSDM_S_ITEM_STR-SAKTO sy-vline 
WA_NSDM_S_ITEM_STR-XWSBR sy-vline 
WA_NSDM_S_ITEM_STR-EMLIF sy-vline 
WA_NSDM_S_ITEM_STR-AKTNR sy-vline 
WA_NSDM_S_ITEM_STR-ZEKKN sy-vline 
WA_NSDM_S_ITEM_STR-CUOBJ_CH sy-vline 
WA_NSDM_S_ITEM_STR-PPRCTR sy-vline 
WA_NSDM_S_ITEM_STR-RSART sy-vline 
WA_NSDM_S_ITEM_STR-GEBER sy-vline 
WA_NSDM_S_ITEM_STR-FISTL sy-vline 
WA_NSDM_S_ITEM_STR-BUSTM sy-vline 
WA_NSDM_S_ITEM_STR-BUSTW sy-vline 
WA_NSDM_S_ITEM_STR-VPRSV sy-vline 
WA_NSDM_S_ITEM_STR-FKBER sy-vline 
WA_NSDM_S_ITEM_STR-XBEAU sy-vline 
WA_NSDM_S_ITEM_STR-QINSPST sy-vline 
WA_NSDM_S_ITEM_STR-MWSKZ sy-vline 
WA_NSDM_S_ITEM_STR-TXJCD sy-vline 
WA_NSDM_S_ITEM_STR-EMATN sy-vline 
WA_NSDM_S_ITEM_STR-J_1AGIRUPD sy-vline 
WA_NSDM_S_ITEM_STR-VKMWS sy-vline 
WA_NSDM_S_ITEM_STR-BERKZ sy-vline 
WA_NSDM_S_ITEM_STR-XWOFF sy-vline 
WA_NSDM_S_ITEM_STR-BEMOT sy-vline 
WA_NSDM_S_ITEM_STR-PRZNR sy-vline 
WA_NSDM_S_ITEM_STR-LLIEF sy-vline 
WA_NSDM_S_ITEM_STR-LSTAR sy-vline 
WA_NSDM_S_ITEM_STR-XOBEW sy-vline 
WA_NSDM_S_ITEM_STR-GRANT_NBR sy-vline 
WA_NSDM_S_ITEM_STR-ZUSTD_T156M sy-vline 
WA_NSDM_S_ITEM_STR-SPE_GTS_STOCK_TY sy-vline 
WA_NSDM_S_ITEM_STR-KBLNR sy-vline 
WA_NSDM_S_ITEM_STR-KBLPOS sy-vline 
WA_NSDM_S_ITEM_STR-XMACC sy-vline 
WA_NSDM_S_ITEM_STR-UMMAB sy-vline 
WA_NSDM_S_ITEM_STR-UMBAR sy-vline 
WA_NSDM_S_ITEM_STR-UMWRK sy-vline 
WA_NSDM_S_ITEM_STR-UMSOK sy-vline 
WA_NSDM_S_ITEM_STR-SGT_SCAT sy-vline 
WA_NSDM_S_ITEM_STR-SGT_UMSCAT sy-vline 
WA_NSDM_S_ITEM_STR-SGT_RCAT sy-vline 
WA_NSDM_S_ITEM_STR-DISUB_OWNER sy-vline 
WA_NSDM_S_ITEM_STR-COMPL_MARK sy-vline 
WA_NSDM_S_ITEM_STR-FZGLS_MARK sy-vline 
WA_NSDM_S_ITEM_STR-ETANP_MARK sy-vline 
WA_NSDM_S_ITEM_STR-POPUP_MARK sy-vline 
WA_NSDM_S_ITEM_STR-XSAUT sy-vline 
WA_NSDM_S_ITEM_STR-SERVICEPERFORMER sy-vline 
WA_NSDM_S_ITEM_STR-PERNR sy-vline 
WA_NSDM_S_ITEM_STR-KNTTP_GR sy-vline 
WA_NSDM_S_ITEM_STR-WORK_ITEM_ID sy-vline 
WA_NSDM_S_ITEM_STR-FBUDA sy-vline 
WA_NSDM_S_ITEM_STR-DUMMY_INCL_EEW_COBL sy-vline 
WA_NSDM_S_ITEM_STR-FSH_SEASON_YEAR sy-vline 
WA_NSDM_S_ITEM_STR-FSH_SEASON sy-vline 
WA_NSDM_S_ITEM_STR-FSH_COLLECTION sy-vline 
WA_NSDM_S_ITEM_STR-FSH_THEME sy-vline 
WA_NSDM_S_ITEM_STR-WRF_CHARSTC1 sy-vline 
WA_NSDM_S_ITEM_STR-WRF_CHARSTC2 sy-vline 
WA_NSDM_S_ITEM_STR-WRF_CHARSTC3 sy-vline 
WA_NSDM_S_ITEM_STR-DUMMY_MATDOC_INCL_EEW_PS sy-vline 
WA_NSDM_S_ITEM_STR-OINAVNW sy-vline 
WA_NSDM_S_ITEM_STR-OICONDCOD sy-vline 
WA_NSDM_S_ITEM_STR-CONDI sy-vline 
WA_NSDM_S_ITEM_STR-ASS_PSPNR sy-vline      INTO ld_text SEPARATED BY SPACE.

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