ABAP Select data from SAP table SCIF_S4_MATLSPP 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 SCIF_S4_MATLSPP 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 SCIF_S4_MATLSPP. 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 SCIF_S4_MATLSPP 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_SCIF_S4_MATLSPP TYPE STANDARD TABLE OF SCIF_S4_MATLSPP,
      WA_SCIF_S4_MATLSPP TYPE SCIF_S4_MATLSPP,
      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: <SCIF_S4_MATLSPP> TYPE SCIF_S4_MATLSPP.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM SCIF_S4_MATLSPP
*  INTO TABLE @DATA(IT_SCIF_S4_MATLSPP2).
*--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_SCIF_S4_MATLSPP INDEX 1 INTO DATA(WA_SCIF_S4_MATLSPP2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<SCIF_S4_MATLSPP>-MATNR = 1.
<SCIF_S4_MATLSPP>-WERKS = 1.
<SCIF_S4_MATLSPP>-EOQTY = 1.
<SCIF_S4_MATLSPP>-EOQDURA = 1.
<SCIF_S4_MATLSPP>-EOQCAL_MTHD = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_SCIF_S4_MATLSPP-EOQPOD_FIX, sy-vline,
  WA_SCIF_S4_MATLSPP-EOQRESCODE, sy-vline,
  WA_SCIF_S4_MATLSPP-EOQSFT_FLG, sy-vline,
  WA_SCIF_S4_MATLSPP-MAXEOQ_POD, sy-vline,
  WA_SCIF_S4_MATLSPP-MAXPARENT_POD, sy-vline,
  WA_SCIF_S4_MATLSPP-MAXREORD_POD, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_SCIF_S4_MATLSPP 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_SCIF_S4_MATLSPP 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_SCIF_S4_MATLSPP INTO WA_SCIF_S4_MATLSPP.


*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_SCIF_S4_MATLSPP-MATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-MATNR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRG, internal->external for field REVIEWTIME
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-REVIEWTIME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-REVIEWTIME.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRG, internal->external for field REVIEWTIME_DL
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-REVIEWTIME_DL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-REVIEWTIME_DL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRG, internal->external for field PLANRUN_DL
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-PLANRUN_DL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-PLANRUN_DL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRG, internal->external for field PLANRUN
CALL FUNCTION 'CONVERSION_EXIT_TSTRG_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-PLANRUN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-PLANRUN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field REPLDUR_STK
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-REPLDUR_STK
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-REPLDUR_STK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field REPLDUR_DSTK
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-REPLDUR_DSTK
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-REPLDUR_DSTK.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field DEPL_INDICH
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-DEPL_INDICH
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-DEPL_INDICH.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field MNLREVDEX_EN
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-MNLREVDEX_EN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-MNLREVDEX_EN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field MNLREVDEX_ST
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-MNLREVDEX_ST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-MNLREVDEX_ST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field MNLREVFRM_EN
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-MNLREVFRM_EN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-MNLREVFRM_EN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field MNLREVFRM_ST
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-MNLREVFRM_ST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-MNLREVFRM_ST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field PLRSTDRP_EN
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-PLRSTDRP_EN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-PLRSTDRP_EN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field PLRSTDRP_ST
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-PLRSTDRP_ST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-PLRSTDRP_ST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field PLRST_EN
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-PLRST_EN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-PLRST_EN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field PLRST_ST
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-PLRST_ST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-PLRST_ST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field PLRSTLOC_EN
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-PLRSTLOC_EN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-PLRSTLOC_EN.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field PLRSTLOC_ST
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-PLRSTLOC_ST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-PLRSTLOC_ST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTLC, internal->external for field MANFRHOR_ST
CALL FUNCTION 'CONVERSION_EXIT_TSTLC_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-MANFRHOR_ST
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-MANFRHOR_ST.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field REP_TIME_INT
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-REP_TIME_INT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-REP_TIME_INT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit TSTRN, internal->external for field REP_TIME_BUF
CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT'
  EXPORTING
    input =                      WA_SCIF_S4_MATLSPP-REP_TIME_BUF
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_SCIF_S4_MATLSPP-REP_TIME_BUF.
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_SCIF_S4_MATLSPP_STR, 
MATNR TYPE STRING,
WERKS TYPE STRING,
EOQTY TYPE STRING,
EOQDURA TYPE STRING,
EOQCAL_MTHD TYPE STRING,
EOQPOD_FIX TYPE STRING,
EOQRESCODE TYPE STRING,
EOQSFT_FLG TYPE STRING,
MAXEOQ_POD TYPE STRING,
MAXPARENT_POD TYPE STRING,
MAXREORD_POD TYPE STRING,
MINEOQ_POD TYPE STRING,
POLICY_LOCK TYPE STRING,
RUSHORD TYPE STRING,
REVIEWTIME TYPE STRING,
REVIEWTIME_DL TYPE STRING,
PLANRUN_DL TYPE STRING,
PLANRUN TYPE STRING,
ORDCOSTPULL TYPE STRING,
ORDCOSTPUSH TYPE STRING,
MINORD_QTY TYPE STRING,
REPLINDI TYPE STRING,
REPLDUR_STK TYPE STRING,
REPLDUR_DSTK TYPE STRING,
RGSTK_INDI TYPE STRING,
PLOCK_REASON TYPE STRING,
SSD_PRF_ID TYPE STRING,
POD_FIXDMD TYPE STRING,
POD_FIXDMDHOR TYPE STRING,
EOQCALC_L_MTHD TYPE STRING,
SS_CAL_MTHD TYPE STRING,
EOQ_L_REAS TYPE STRING,
PLRSTEOQ_SDAT TYPE STRING,
PLRSTEOQ_EDAT TYPE STRING,
DEPL_INDI TYPE STRING,
DEPL_INDICH TYPE STRING,
EXPSHP_MULT TYPE STRING,
MNLREVDEX_EN TYPE STRING,
MNLREVDEX_ST TYPE STRING,
MNLREVFRM_EN TYPE STRING,
MNLREVFRM_ST TYPE STRING,
PLRSTDRP_EN TYPE STRING,
PLRSTDRP_ST TYPE STRING,
PLRST_EN TYPE STRING,
PLRST_ST TYPE STRING,
PLRSTLOC_EN TYPE STRING,
PLRSTLOC_ST TYPE STRING,
RET_RESIDUAL TYPE STRING,
TSL_SHIFT TYPE STRING,
COMMFRZ_INDI TYPE STRING,
LOWTHRESHOLD TYPE STRING,
EXPRESESBUY TYPE STRING,
MINCOST TYPE STRING,
MAXCOST TYPE STRING,
NUM_PERIOD TYPE STRING,
VP_SWITCH TYPE STRING,
PROM_STARTDT TYPE STRING,
PROM_ENDDT TYPE STRING,
SRID TYPE STRING,
MAX_TSL TYPE STRING,
BODDEPLLP TYPE STRING,
SEASPULLPRF_ID TYPE STRING,
AVGPROD_PERBIN TYPE STRING,
WSSSTR_TYPE TYPE STRING,
SRVBEN TYPE STRING,
RELPROFID TYPE STRING,
INVACU_INDI TYPE STRING,
MANFRHOR_ST TYPE STRING,
DEPL_INDI_V TYPE STRING,
EOQTY_V TYPE STRING,
EOQDURA_V TYPE STRING,
EOQSFT_FLG_V TYPE STRING,
LOWTHRESHOLD_V TYPE STRING,
EXPRESESBUY_V TYPE STRING,
EOQCAL_MTHD_V TYPE STRING,
MINORD_QTY_V TYPE STRING,
VP_SWITCH_V TYPE STRING,
SEASPULLPRF_ID_V TYPE STRING,
EOQCALC_L_MTHD_V TYPE STRING,
SS_CAL_MTHD_V TYPE STRING,
EOQ_L_REAS_V TYPE STRING,
PLRSTEOQ_SDAT_V TYPE STRING,
PLRSTEOQ_EDAT_V TYPE STRING,
REP_RET_PRCT TYPE STRING,
REP_TIME_INT TYPE STRING,
REP_TIME_BUF TYPE STRING,
REP_LC_COST TYPE STRING,
REP_SWITCH TYPE STRING,
REP_PROC_TYP TYPE STRING,
REP_RF_IND TYPE STRING,
TRG_DET_DRP_PM TYPE STRING,
DRP_PLAN_MODE TYPE STRING,
MAXSTKLVL_FLG TYPE STRING,
PRF_RRF_TS TYPE STRING,
PRD_FOR_KIT TYPE STRING,
PROC_TO_ORD TYPE STRING,
NO_INV_BAL TYPE STRING,
PROH_SU_ORD TYPE STRING,
PROH_SU_DEM TYPE STRING,
APPR_DEP_STO TYPE STRING,
KIT_SHDN_PRF TYPE STRING,
KIT_HORIZON TYPE STRING,
DRP_L_REAS TYPE STRING,
DEP_L_REAS TYPE STRING,
LOC_L_REAS TYPE STRING,
SCA_PLNR TYPE STRING,
DRP_PLNR TYPE STRING,
IPL_PLNR TYPE STRING,
FCS_PLNR TYPE STRING,
BUY_PLNR TYPE STRING,
SCA_LOCK TYPE STRING,END OF T_EKKO_STR.
DATA: WA_SCIF_S4_MATLSPP_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_SCIF_S4_MATLSPP_STR-MATNR sy-vline 
WA_SCIF_S4_MATLSPP_STR-WERKS sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQTY sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQDURA sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQCAL_MTHD sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQPOD_FIX sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQRESCODE sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQSFT_FLG sy-vline 
WA_SCIF_S4_MATLSPP_STR-MAXEOQ_POD sy-vline 
WA_SCIF_S4_MATLSPP_STR-MAXPARENT_POD sy-vline 
WA_SCIF_S4_MATLSPP_STR-MAXREORD_POD sy-vline 
WA_SCIF_S4_MATLSPP_STR-MINEOQ_POD sy-vline 
WA_SCIF_S4_MATLSPP_STR-POLICY_LOCK sy-vline 
WA_SCIF_S4_MATLSPP_STR-RUSHORD sy-vline 
WA_SCIF_S4_MATLSPP_STR-REVIEWTIME sy-vline 
WA_SCIF_S4_MATLSPP_STR-REVIEWTIME_DL sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLANRUN_DL sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLANRUN sy-vline 
WA_SCIF_S4_MATLSPP_STR-ORDCOSTPULL sy-vline 
WA_SCIF_S4_MATLSPP_STR-ORDCOSTPUSH sy-vline 
WA_SCIF_S4_MATLSPP_STR-MINORD_QTY sy-vline 
WA_SCIF_S4_MATLSPP_STR-REPLINDI sy-vline 
WA_SCIF_S4_MATLSPP_STR-REPLDUR_STK sy-vline 
WA_SCIF_S4_MATLSPP_STR-REPLDUR_DSTK sy-vline 
WA_SCIF_S4_MATLSPP_STR-RGSTK_INDI sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLOCK_REASON sy-vline 
WA_SCIF_S4_MATLSPP_STR-SSD_PRF_ID sy-vline 
WA_SCIF_S4_MATLSPP_STR-POD_FIXDMD sy-vline 
WA_SCIF_S4_MATLSPP_STR-POD_FIXDMDHOR sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQCALC_L_MTHD sy-vline 
WA_SCIF_S4_MATLSPP_STR-SS_CAL_MTHD sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQ_L_REAS sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRSTEOQ_SDAT sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRSTEOQ_EDAT sy-vline 
WA_SCIF_S4_MATLSPP_STR-DEPL_INDI sy-vline 
WA_SCIF_S4_MATLSPP_STR-DEPL_INDICH sy-vline 
WA_SCIF_S4_MATLSPP_STR-EXPSHP_MULT sy-vline 
WA_SCIF_S4_MATLSPP_STR-MNLREVDEX_EN sy-vline 
WA_SCIF_S4_MATLSPP_STR-MNLREVDEX_ST sy-vline 
WA_SCIF_S4_MATLSPP_STR-MNLREVFRM_EN sy-vline 
WA_SCIF_S4_MATLSPP_STR-MNLREVFRM_ST sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRSTDRP_EN sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRSTDRP_ST sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRST_EN sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRST_ST sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRSTLOC_EN sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRSTLOC_ST sy-vline 
WA_SCIF_S4_MATLSPP_STR-RET_RESIDUAL sy-vline 
WA_SCIF_S4_MATLSPP_STR-TSL_SHIFT sy-vline 
WA_SCIF_S4_MATLSPP_STR-COMMFRZ_INDI sy-vline 
WA_SCIF_S4_MATLSPP_STR-LOWTHRESHOLD sy-vline 
WA_SCIF_S4_MATLSPP_STR-EXPRESESBUY sy-vline 
WA_SCIF_S4_MATLSPP_STR-MINCOST sy-vline 
WA_SCIF_S4_MATLSPP_STR-MAXCOST sy-vline 
WA_SCIF_S4_MATLSPP_STR-NUM_PERIOD sy-vline 
WA_SCIF_S4_MATLSPP_STR-VP_SWITCH sy-vline 
WA_SCIF_S4_MATLSPP_STR-PROM_STARTDT sy-vline 
WA_SCIF_S4_MATLSPP_STR-PROM_ENDDT sy-vline 
WA_SCIF_S4_MATLSPP_STR-SRID sy-vline 
WA_SCIF_S4_MATLSPP_STR-MAX_TSL sy-vline 
WA_SCIF_S4_MATLSPP_STR-BODDEPLLP sy-vline 
WA_SCIF_S4_MATLSPP_STR-SEASPULLPRF_ID sy-vline 
WA_SCIF_S4_MATLSPP_STR-AVGPROD_PERBIN sy-vline 
WA_SCIF_S4_MATLSPP_STR-WSSSTR_TYPE sy-vline 
WA_SCIF_S4_MATLSPP_STR-SRVBEN sy-vline 
WA_SCIF_S4_MATLSPP_STR-RELPROFID sy-vline 
WA_SCIF_S4_MATLSPP_STR-INVACU_INDI sy-vline 
WA_SCIF_S4_MATLSPP_STR-MANFRHOR_ST sy-vline 
WA_SCIF_S4_MATLSPP_STR-DEPL_INDI_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQTY_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQDURA_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQSFT_FLG_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-LOWTHRESHOLD_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-EXPRESESBUY_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQCAL_MTHD_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-MINORD_QTY_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-VP_SWITCH_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-SEASPULLPRF_ID_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQCALC_L_MTHD_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-SS_CAL_MTHD_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-EOQ_L_REAS_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRSTEOQ_SDAT_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-PLRSTEOQ_EDAT_V sy-vline 
WA_SCIF_S4_MATLSPP_STR-REP_RET_PRCT sy-vline 
WA_SCIF_S4_MATLSPP_STR-REP_TIME_INT sy-vline 
WA_SCIF_S4_MATLSPP_STR-REP_TIME_BUF sy-vline 
WA_SCIF_S4_MATLSPP_STR-REP_LC_COST sy-vline 
WA_SCIF_S4_MATLSPP_STR-REP_SWITCH sy-vline 
WA_SCIF_S4_MATLSPP_STR-REP_PROC_TYP sy-vline 
WA_SCIF_S4_MATLSPP_STR-REP_RF_IND sy-vline 
WA_SCIF_S4_MATLSPP_STR-TRG_DET_DRP_PM sy-vline 
WA_SCIF_S4_MATLSPP_STR-DRP_PLAN_MODE sy-vline 
WA_SCIF_S4_MATLSPP_STR-MAXSTKLVL_FLG sy-vline 
WA_SCIF_S4_MATLSPP_STR-PRF_RRF_TS sy-vline 
WA_SCIF_S4_MATLSPP_STR-PRD_FOR_KIT sy-vline 
WA_SCIF_S4_MATLSPP_STR-PROC_TO_ORD sy-vline 
WA_SCIF_S4_MATLSPP_STR-NO_INV_BAL sy-vline 
WA_SCIF_S4_MATLSPP_STR-PROH_SU_ORD sy-vline 
WA_SCIF_S4_MATLSPP_STR-PROH_SU_DEM sy-vline 
WA_SCIF_S4_MATLSPP_STR-APPR_DEP_STO sy-vline 
WA_SCIF_S4_MATLSPP_STR-KIT_SHDN_PRF sy-vline 
WA_SCIF_S4_MATLSPP_STR-KIT_HORIZON sy-vline 
WA_SCIF_S4_MATLSPP_STR-DRP_L_REAS sy-vline 
WA_SCIF_S4_MATLSPP_STR-DEP_L_REAS sy-vline 
WA_SCIF_S4_MATLSPP_STR-LOC_L_REAS sy-vline 
WA_SCIF_S4_MATLSPP_STR-SCA_PLNR sy-vline 
WA_SCIF_S4_MATLSPP_STR-DRP_PLNR sy-vline 
WA_SCIF_S4_MATLSPP_STR-IPL_PLNR sy-vline 
WA_SCIF_S4_MATLSPP_STR-FCS_PLNR sy-vline 
WA_SCIF_S4_MATLSPP_STR-BUY_PLNR sy-vline 
WA_SCIF_S4_MATLSPP_STR-SCA_LOCK sy-vline      INTO ld_text SEPARATED BY SPACE.

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