ABAP Select data from SAP table V_PPH_MAT_CTRLDD 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 V_PPH_MAT_CTRLDD 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 V_PPH_MAT_CTRLDD. 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 V_PPH_MAT_CTRLDD 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_V_PPH_MAT_CTRLDD TYPE STANDARD TABLE OF V_PPH_MAT_CTRLDD,
      WA_V_PPH_MAT_CTRLDD TYPE V_PPH_MAT_CTRLDD,
      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: <V_PPH_MAT_CTRLDD> TYPE V_PPH_MAT_CTRLDD.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM V_PPH_MAT_CTRLDD
*  INTO TABLE @DATA(IT_V_PPH_MAT_CTRLDD2).
*--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_V_PPH_MAT_CTRLDD INDEX 1 INTO DATA(WA_V_PPH_MAT_CTRLDD2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<V_PPH_MAT_CTRLDD>-MANDT = 1.
<V_PPH_MAT_CTRLDD>-MATNR = 1.
<V_PPH_MAT_CTRLDD>-WERKS = 1.
<V_PPH_MAT_CTRLDD>-BERID = 1.
<V_PPH_MAT_CTRLDD>-SGT_CSGR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_V_PPH_MAT_CTRLDD-SGT_COVSA, sy-vline,
  WA_V_PPH_MAT_CTRLDD-SGT_STAT, sy-vline,
  WA_V_PPH_MAT_CTRLDD-SGT_REL, sy-vline,
  WA_V_PPH_MAT_CTRLDD-SGT_COVS, sy-vline,
  WA_V_PPH_MAT_CTRLDD-SGT_STATC, sy-vline,
  WA_V_PPH_MAT_CTRLDD-SGT_SCOPE, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_V_PPH_MAT_CTRLDD 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_V_PPH_MAT_CTRLDD 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_V_PPH_MAT_CTRLDD INTO WA_V_PPH_MAT_CTRLDD.


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

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

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

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

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

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

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

*Conversion exit MATN1, internal->external for field IMATN
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_V_PPH_MAT_CTRLDD-IMATN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_V_PPH_MAT_CTRLDD-IMATN.
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_V_PPH_MAT_CTRLDD_STR, 
MANDT TYPE STRING,
MATNR TYPE STRING,
WERKS TYPE STRING,
BERID TYPE STRING,
SGT_CSGR TYPE STRING,
SGT_COVSA TYPE STRING,
SGT_STAT TYPE STRING,
SGT_REL TYPE STRING,
SGT_COVS TYPE STRING,
SGT_STATC TYPE STRING,
SGT_SCOPE TYPE STRING,
SGT_MRPSI TYPE STRING,
SGT_PRCM TYPE STRING,
SGT_CHINT TYPE STRING,
FSH_MG_ARUN_REQ TYPE STRING,
ARUN_FIX_BATCH TYPE STRING,
FSH_VAR_GROUP TYPE STRING,
FSH_CALENDAR_GROUP TYPE STRING,
FSH_GROUP_PR TYPE STRING,
BERTY TYPE STRING,
MATKL TYPE STRING,
LVORM_MARA TYPE STRING,
LVORM_MARC TYPE STRING,
SATNR TYPE STRING,
MSTAE TYPE STRING,
ATTYP TYPE STRING,
MEINS TYPE STRING,
DISST TYPE STRING,
KZKFG TYPE STRING,
KZEFF TYPE STRING,
CUOBF TYPE STRING,
MPROF TYPE STRING,
MFRPN TYPE STRING,
MFRNR TYPE STRING,
APOKZ TYPE STRING,
PPSKZ TYPE STRING,
MMSTA TYPE STRING,
MMSTD TYPE STRING,
MSTDE TYPE STRING,
MAABC TYPE STRING,
EKGRP TYPE STRING,
ANDEC TYPE STRING,
BESKZ TYPE STRING,
SOBES TYPE STRING,
WRK02 TYPE STRING,
UMLDB TYPE STRING,
LBEAR TYPE STRING,
SBDKZ TYPE STRING,
KZAUS TYPE STRING,
AUSDT TYPE STRING,
MTART TYPE STRING,
DISGR TYPE STRING,
DISPO TYPE STRING,
MISKZ TYPE STRING,
RWPRO TYPE STRING,
FHORI TYPE STRING,
AHDIS TYPE STRING,
VRMOD TYPE STRING,
VINT1 TYPE STRING,
VINT2 TYPE STRING,
STDPD TYPE STRING,
CUOBV TYPE STRING,
BEARZ TYPE STRING,
RUEZT TYPE STRING,
TRANZ TYPE STRING,
WEBAZ TYPE STRING,
PLIFZ TYPE STRING,
DZEIT TYPE STRING,
WZEIT TYPE STRING,
SHFLG TYPE STRING,
SHZET TYPE STRING,
SHPRO TYPE STRING,
QMATV TYPE STRING,
CUOBJ TYPE STRING,
RESVP TYPE STRING,
UMLMC TYPE STRING,
USEQU TYPE STRING,
MINBE TYPE STRING,
EISBE TYPE STRING,
DISLS TYPE STRING,
BSTMI TYPE STRING,
BSTMA TYPE STRING,
BSTFE TYPE STRING,
MABST TYPE STRING,
WAERS TYPE STRING,
LOSFX TYPE STRING,
LAGPR TYPE STRING,
AUSSS TYPE STRING,
TAKZT TYPE STRING,
BSTRF TYPE STRING,
RDPRF TYPE STRING,
STRGR TYPE STRING,
LGFSB TYPE STRING,
PERIV TYPE STRING,
MRPPP TYPE STRING,
SAUFT TYPE STRING,
SFEPR TYPE STRING,
FXHOR TYPE STRING,
DISMM TYPE STRING,
PERKZ TYPE STRING,
SOBSL TYPE STRING,
FEVOR TYPE STRING,
BASMG TYPE STRING,
LGPRO TYPE STRING,
DISVF TYPE STRING,
BBBED TYPE STRING,
FXART TYPE STRING,
PROOS TYPE STRING,
PRRED TYPE STRING,
RYBED TYPE STRING,
KZREG TYPE STRING,
CBPPT TYPE STRING,
ICBED TYPE STRING,
U1BED TYPE STRING,
U2BED TYPE STRING,
U4BED TYPE STRING,
A1BED TYPE STRING,
A2BED TYPE STRING,
GRREL TYPE STRING,
RVPKZ TYPE STRING,
ANDIS TYPE STRING,
BSART TYPE STRING,
BARTL TYPE STRING,
BARTU TYPE STRING,
SBDIS TYPE STRING,
SCFLG TYPE STRING,
PSBAN TYPE STRING,
XFAN1 TYPE STRING,
GTERM TYPE STRING,
REFWK TYPE STRING,
VERTR TYPE STRING,
NFVBC TYPE STRING,
KNTBU TYPE STRING,
KTDBU TYPE STRING,
KZUMB TYPE STRING,
BZTEK TYPE STRING,
UMTHZ TYPE STRING,
VWVOR TYPE STRING,
VWVER TYPE STRING,
PLAHZ TYPE STRING,
KZDRB TYPE STRING,
FIXPA TYPE STRING,
FIXFA TYPE STRING,
FIXBA TYPE STRING,
FIXBE TYPE STRING,
FIXQM TYPE STRING,
FIXLA TYPE STRING,
MXBST TYPE STRING,
BESAL TYPE STRING,
PSRES TYPE STRING,
CSLID TYPE STRING,
KASTL TYPE STRING,
EXSGT TYPE STRING,
LIFNR TYPE STRING,
FABKL TYPE STRING,
KKOWK TYPE STRING,
MENGU TYPE STRING,
WERTU TYPE STRING,
MFXDT TYPE STRING,
MFHKZ TYPE STRING,
DISFG TYPE STRING,
XFAT1 TYPE STRING,
ALTSL TYPE STRING,
PICNUM TYPE STRING,
IMATN TYPE STRING,
LOSVF TYPE STRING,
LOSKZ TYPE STRING,
PERAZ TYPE STRING,
TERBV TYPE STRING,
UELAP TYPE STRING,
KFPKZ TYPE STRING,
KFPAZ TYPE STRING,
LGLVF TYPE STRING,
LGLKZ TYPE STRING,
LGPAZ TYPE STRING,
LGTER TYPE STRING,
LGUEL TYPE STRING,
LGMIN TYPE STRING,
LGMAX TYPE STRING,
KZSPL TYPE STRING,
LGSPL TYPE STRING,
INTKA TYPE STRING,
LGINT TYPE STRING,
LGKND TYPE STRING,
KZHOR TYPE STRING,
HBVAR TYPE STRING,
LASTL TYPE STRING,
UNTKZ TYPE STRING,
AGREQ TYPE STRING,
ERHOR TYPE STRING,
PLAN_IN_ABAP TYPE STRING,
RESDT TYPE STRING,
RESAL TYPE STRING,
MTWZT TYPE STRING,
ADSPC_SPC TYPE STRING,
SFTY_STK_METH TYPE STRING,
SPIKE_HRZ_LS TYPE STRING,
SPIKE_HRZ_LM TYPE STRING,
SPIKE_THLD_FCTR TYPE STRING,
ON_HAND_ALRT_THLD_FCTR TYPE STRING,
ON_HAND_ALRT_THLD TYPE STRING,
SPIKE_HORIZON TYPE STRING,
SPIKE_THRESHOLD TYPE STRING,
SPIKE_HORIZON_DATE TYPE STRING,
DECOUPLED_LEAD_TIME_DATE TYPE STRING,END OF T_EKKO_STR.
DATA: WA_V_PPH_MAT_CTRLDD_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_V_PPH_MAT_CTRLDD_STR-MANDT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MATNR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-WERKS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BERID sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_CSGR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_COVSA sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_STAT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_REL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_COVS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_STATC sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_SCOPE sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_MRPSI sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_PRCM sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SGT_CHINT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FSH_MG_ARUN_REQ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ARUN_FIX_BATCH sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FSH_VAR_GROUP sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FSH_CALENDAR_GROUP sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FSH_GROUP_PR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BERTY sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MATKL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LVORM_MARA sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LVORM_MARC sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SATNR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MSTAE sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ATTYP sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MEINS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-DISST sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KZKFG sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KZEFF sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-CUOBF sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MPROF sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MFRPN sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MFRNR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-APOKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PPSKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MMSTA sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MMSTD sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MSTDE sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MAABC sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-EKGRP sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ANDEC sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BESKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SOBES sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-WRK02 sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-UMLDB sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LBEAR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SBDKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KZAUS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-AUSDT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MTART sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-DISGR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-DISPO sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MISKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-RWPRO sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FHORI sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-AHDIS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-VRMOD sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-VINT1 sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-VINT2 sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-STDPD sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-CUOBV sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BEARZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-RUEZT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-TRANZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-WEBAZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PLIFZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-DZEIT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-WZEIT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SHFLG sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SHZET sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SHPRO sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-QMATV sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-CUOBJ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-RESVP sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-UMLMC sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-USEQU sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MINBE sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-EISBE sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-DISLS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BSTMI sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BSTMA sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BSTFE sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MABST sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-WAERS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LOSFX sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LAGPR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-AUSSS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-TAKZT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BSTRF sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-RDPRF sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-STRGR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGFSB sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PERIV sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MRPPP sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SAUFT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SFEPR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FXHOR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-DISMM sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PERKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SOBSL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FEVOR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BASMG sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGPRO sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-DISVF sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BBBED sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FXART sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PROOS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PRRED sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-RYBED sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KZREG sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-CBPPT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ICBED sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-U1BED sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-U2BED sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-U4BED sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-A1BED sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-A2BED sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-GRREL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-RVPKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ANDIS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BSART sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BARTL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BARTU sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SBDIS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SCFLG sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PSBAN sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-XFAN1 sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-GTERM sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-REFWK sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-VERTR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-NFVBC sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KNTBU sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KTDBU sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KZUMB sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BZTEK sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-UMTHZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-VWVOR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-VWVER sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PLAHZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KZDRB sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FIXPA sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FIXFA sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FIXBA sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FIXBE sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FIXQM sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FIXLA sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MXBST sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-BESAL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PSRES sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-CSLID sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KASTL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-EXSGT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LIFNR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-FABKL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KKOWK sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MENGU sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-WERTU sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MFXDT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MFHKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-DISFG sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-XFAT1 sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ALTSL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PICNUM sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-IMATN sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LOSVF sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LOSKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PERAZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-TERBV sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-UELAP sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KFPKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KFPAZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGLVF sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGLKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGPAZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGTER sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGUEL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGMIN sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGMAX sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KZSPL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGSPL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-INTKA sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGINT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LGKND sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-KZHOR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-HBVAR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-LASTL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-UNTKZ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-AGREQ sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ERHOR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-PLAN_IN_ABAP sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-RESDT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-RESAL sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-MTWZT sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ADSPC_SPC sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SFTY_STK_METH sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SPIKE_HRZ_LS sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SPIKE_HRZ_LM sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SPIKE_THLD_FCTR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ON_HAND_ALRT_THLD_FCTR sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-ON_HAND_ALRT_THLD sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SPIKE_HORIZON sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SPIKE_THRESHOLD sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-SPIKE_HORIZON_DATE sy-vline 
WA_V_PPH_MAT_CTRLDD_STR-DECOUPLED_LEAD_TIME_DATE sy-vline      INTO ld_text SEPARATED BY SPACE.

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