ABAP Select data from SAP table MPES_PHANTOM_FLAT 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 MPES_PHANTOM_FLAT 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 MPES_PHANTOM_FLAT. 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 MPES_PHANTOM_FLAT 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_MPES_PHANTOM_FLAT TYPE STANDARD TABLE OF MPES_PHANTOM_FLAT,
      WA_MPES_PHANTOM_FLAT TYPE MPES_PHANTOM_FLAT,
      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: <MPES_PHANTOM_FLAT> TYPE MPES_PHANTOM_FLAT.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MPES_PHANTOM_FLAT
*  INTO TABLE @DATA(IT_MPES_PHANTOM_FLAT2).
*--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_MPES_PHANTOM_FLAT INDEX 1 INTO DATA(WA_MPES_PHANTOM_FLAT2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MPES_PHANTOM_FLAT>-INT_NODE = 1.
<MPES_PHANTOM_FLAT>-INT_PARENT_NODE = 1.
<MPES_PHANTOM_FLAT>-NOT_FROM_PHANTOM = 1.
<MPES_PHANTOM_FLAT>-PARENT_MATNR = 1.
<MPES_PHANTOM_FLAT>-PHA_MATNR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MPES_PHANTOM_FLAT-COMP_MATNR, sy-vline,
  WA_MPES_PHANTOM_FLAT-PHA_STLTY, sy-vline,
  WA_MPES_PHANTOM_FLAT-PHA_STLNR, sy-vline,
  WA_MPES_PHANTOM_FLAT-PHA_STLAL, sy-vline,
  WA_MPES_PHANTOM_FLAT-PHA_BOM_VERSN, sy-vline,
  WA_MPES_PHANTOM_FLAT-PHA_STVKN, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MPES_PHANTOM_FLAT 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_MPES_PHANTOM_FLAT 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_MPES_PHANTOM_FLAT INTO WA_MPES_PHANTOM_FLAT.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit ALPHA, internal->external for field ABS_AENNR
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_MPES_PHANTOM_FLAT-ABS_AENNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MPES_PHANTOM_FLAT-ABS_AENNR.
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_MPES_PHANTOM_FLAT_STR, 
INT_NODE TYPE STRING,
INT_PARENT_NODE TYPE STRING,
NOT_FROM_PHANTOM TYPE STRING,
PARENT_MATNR TYPE STRING,
PHA_MATNR TYPE STRING,
COMP_MATNR TYPE STRING,
PHA_STLTY TYPE STRING,
PHA_STLNR TYPE STRING,
PHA_STLAL TYPE STRING,
PHA_BOM_VERSN TYPE STRING,
PHA_STVKN TYPE STRING,
PHA_STVKN_VERSN TYPE STRING,
REL_QTY TYPE STRING,
REL_UOM TYPE STRING,
REL_AENNR TYPE STRING,
REL_EFF_TAB TYPE STRING,
ITEM TYPE STRING,
STLAL TYPE STRING,
MANDT TYPE STRING,
STLTY TYPE STRING,
STLNR TYPE STRING,
STLKN TYPE STRING,
STPOZ TYPE STRING,
DATUV TYPE STRING,
TECHV TYPE STRING,
AENNR TYPE STRING,
LKENZ TYPE STRING,
VGKNT TYPE STRING,
VGPZL TYPE STRING,
ANDAT TYPE STRING,
ANNAM TYPE STRING,
AEDAT TYPE STRING,
AENAM TYPE STRING,
IDNRK TYPE STRING,
PSWRK TYPE STRING,
POSTP TYPE STRING,
POSNR TYPE STRING,
SORTF TYPE STRING,
MEINS TYPE STRING,
MENGE TYPE STRING,
FMENG TYPE STRING,
AUSCH TYPE STRING,
AVOAU TYPE STRING,
NETAU TYPE STRING,
SCHGT TYPE STRING,
BEIKZ TYPE STRING,
ERSKZ TYPE STRING,
RVREL TYPE STRING,
SANFE TYPE STRING,
SANIN TYPE STRING,
SANKA TYPE STRING,
SANKO TYPE STRING,
SANVS TYPE STRING,
STKKZ TYPE STRING,
REKRI TYPE STRING,
REKRS TYPE STRING,
CADPO TYPE STRING,
NFMAT TYPE STRING,
NLFZT TYPE STRING,
VERTI TYPE STRING,
ALPOS TYPE STRING,
EWAHR TYPE STRING,
EKGRP TYPE STRING,
LIFZT TYPE STRING,
LIFNR TYPE STRING,
PREIS TYPE STRING,
PEINH TYPE STRING,
WAERS TYPE STRING,
SAKTO TYPE STRING,
ROANZ TYPE STRING,
ROMS1 TYPE STRING,
ROMS2 TYPE STRING,
ROMS3 TYPE STRING,
ROMEI TYPE STRING,
ROMEN TYPE STRING,
RFORM TYPE STRING,
UPSKZ TYPE STRING,
VALKZ TYPE STRING,
LTXSP TYPE STRING,
POTX1 TYPE STRING,
POTX2 TYPE STRING,
OBJTY TYPE STRING,
MATKL TYPE STRING,
WEBAZ TYPE STRING,
DOKAR TYPE STRING,
DOKNR TYPE STRING,
DOKVR TYPE STRING,
DOKTL TYPE STRING,
CSSTR TYPE STRING,
CLASS TYPE STRING,
KLART TYPE STRING,
POTPR TYPE STRING,
AWAKZ TYPE STRING,
INSKZ TYPE STRING,
VCEKZ TYPE STRING,
VSTKZ TYPE STRING,
VACKZ TYPE STRING,
EKORG TYPE STRING,
CLOBK TYPE STRING,
CLMUL TYPE STRING,
CLALT TYPE STRING,
CVIEW TYPE STRING,
KNOBJ TYPE STRING,
LGORT TYPE STRING,
KZKUP TYPE STRING,
INTRM TYPE STRING,
TPEKZ TYPE STRING,
STVKN TYPE STRING,
DVDAT TYPE STRING,
DVNAM TYPE STRING,
DSPST TYPE STRING,
ALPST TYPE STRING,
ALPRF TYPE STRING,
ALPGR TYPE STRING,
KZNFP TYPE STRING,
NFGRP TYPE STRING,
NFEAG TYPE STRING,
KNDVB TYPE STRING,
KNDBZ TYPE STRING,
KSTTY TYPE STRING,
KSTNR TYPE STRING,
KSTKN TYPE STRING,
KSTPZ TYPE STRING,
CLSZU TYPE STRING,
KZCLB TYPE STRING,
AEHLP TYPE STRING,
PRVBE TYPE STRING,
NLFZV TYPE STRING,
NLFMV TYPE STRING,
IDPOS TYPE STRING,
IDHIS TYPE STRING,
IDVAR TYPE STRING,
ALEKZ TYPE STRING,
ITMID TYPE STRING,
GUID TYPE STRING,
ITSOB TYPE STRING,
RFPNT TYPE STRING,
GUIDX TYPE STRING,
SGT_CMKZ TYPE STRING,
SGT_CATV TYPE STRING,
VALID_TO TYPE STRING,
VALID_TO_RKEY TYPE STRING,
ECN_TO TYPE STRING,
ECN_TO_RKEY TYPE STRING,
ABLAD TYPE STRING,
WEMPF TYPE STRING,
STVKN_VERSN TYPE STRING,
LASTCHANGEDATETIME TYPE STRING,
SFWIND TYPE STRING,
DUMMY_STPO_INCL_EEW_PS TYPE STRING,
CUFACTOR TYPE STRING,
/SAPMP/MET_LRCH TYPE STRING,
/SAPMP/MAX_FERTL TYPE STRING,
/SAPMP/FIX_AS_J TYPE STRING,
/SAPMP/FIX_AS_E TYPE STRING,
/SAPMP/FIX_AS_L TYPE STRING,
/SAPMP/ABL_ZAHL TYPE STRING,
/SAPMP/RUND_FAKT TYPE STRING,
FSH_VMKZ TYPE STRING,
FSH_PGQR TYPE STRING,
FSH_PGQRRF TYPE STRING,
FSH_CRITICAL_COMP TYPE STRING,
FSH_CRITICAL_LEVEL TYPE STRING,
FUNCID TYPE STRING,
AENRA TYPE STRING,
BOMOB TYPE STRING,
DATUB TYPE STRING,
DUMPS TYPE STRING,
IDENT TYPE STRING,
KTEXT TYPE STRING,
LTXPO TYPE STRING,
OBTSP TYPE STRING,
OBKTX TYPE STRING,
ROKME TYPE STRING,
ROAME TYPE STRING,
STLKZ TYPE STRING,
KZAUS TYPE STRING,
SCHKZ TYPE STRING,
FLG_INV TYPE STRING,
FLG_LOCK TYPE STRING,
HANDLE TYPE STRING,
BOM_VERSN TYPE STRING,
VERSNST TYPE STRING,
VERSNIND TYPE STRING,
VERSNLASTIND TYPE STRING,
BOM_PREV_VERSN TYPE STRING,
ABS_EFF_TAB TYPE STRING,
ABS_AENNR TYPE STRING,
GEN_ECN TYPE STRING,
CHANGE_TYPE TYPE STRING,
NODE TYPE STRING,
PARENT_NODE TYPE STRING,
CHECKED TYPE STRING,
IGNORE TYPE STRING,
ERDAT TYPE STRING,
ERNAM TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MPES_PHANTOM_FLAT_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_MPES_PHANTOM_FLAT_STR-INT_NODE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-INT_PARENT_NODE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-NOT_FROM_PHANTOM sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PARENT_MATNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PHA_MATNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-COMP_MATNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PHA_STLTY sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PHA_STLNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PHA_STLAL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PHA_BOM_VERSN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PHA_STVKN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PHA_STVKN_VERSN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-REL_QTY sy-vline 
WA_MPES_PHANTOM_FLAT_STR-REL_UOM sy-vline 
WA_MPES_PHANTOM_FLAT_STR-REL_AENNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-REL_EFF_TAB sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ITEM sy-vline 
WA_MPES_PHANTOM_FLAT_STR-STLAL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-MANDT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-STLTY sy-vline 
WA_MPES_PHANTOM_FLAT_STR-STLNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-STLKN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-STPOZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DATUV sy-vline 
WA_MPES_PHANTOM_FLAT_STR-TECHV sy-vline 
WA_MPES_PHANTOM_FLAT_STR-AENNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-LKENZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VGKNT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VGPZL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ANDAT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ANNAM sy-vline 
WA_MPES_PHANTOM_FLAT_STR-AEDAT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-AENAM sy-vline 
WA_MPES_PHANTOM_FLAT_STR-IDNRK sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PSWRK sy-vline 
WA_MPES_PHANTOM_FLAT_STR-POSTP sy-vline 
WA_MPES_PHANTOM_FLAT_STR-POSNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SORTF sy-vline 
WA_MPES_PHANTOM_FLAT_STR-MEINS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-MENGE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-FMENG sy-vline 
WA_MPES_PHANTOM_FLAT_STR-AUSCH sy-vline 
WA_MPES_PHANTOM_FLAT_STR-AVOAU sy-vline 
WA_MPES_PHANTOM_FLAT_STR-NETAU sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SCHGT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-BEIKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ERSKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-RVREL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SANFE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SANIN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SANKA sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SANKO sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SANVS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-STKKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-REKRI sy-vline 
WA_MPES_PHANTOM_FLAT_STR-REKRS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CADPO sy-vline 
WA_MPES_PHANTOM_FLAT_STR-NFMAT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-NLFZT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VERTI sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ALPOS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-EWAHR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-EKGRP sy-vline 
WA_MPES_PHANTOM_FLAT_STR-LIFZT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-LIFNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PREIS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PEINH sy-vline 
WA_MPES_PHANTOM_FLAT_STR-WAERS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SAKTO sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ROANZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ROMS1 sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ROMS2 sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ROMS3 sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ROMEI sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ROMEN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-RFORM sy-vline 
WA_MPES_PHANTOM_FLAT_STR-UPSKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VALKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-LTXSP sy-vline 
WA_MPES_PHANTOM_FLAT_STR-POTX1 sy-vline 
WA_MPES_PHANTOM_FLAT_STR-POTX2 sy-vline 
WA_MPES_PHANTOM_FLAT_STR-OBJTY sy-vline 
WA_MPES_PHANTOM_FLAT_STR-MATKL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-WEBAZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DOKAR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DOKNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DOKVR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DOKTL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CSSTR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CLASS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KLART sy-vline 
WA_MPES_PHANTOM_FLAT_STR-POTPR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-AWAKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-INSKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VCEKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VSTKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VACKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-EKORG sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CLOBK sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CLMUL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CLALT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CVIEW sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KNOBJ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-LGORT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KZKUP sy-vline 
WA_MPES_PHANTOM_FLAT_STR-INTRM sy-vline 
WA_MPES_PHANTOM_FLAT_STR-TPEKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-STVKN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DVDAT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DVNAM sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DSPST sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ALPST sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ALPRF sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ALPGR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KZNFP sy-vline 
WA_MPES_PHANTOM_FLAT_STR-NFGRP sy-vline 
WA_MPES_PHANTOM_FLAT_STR-NFEAG sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KNDVB sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KNDBZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KSTTY sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KSTNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KSTKN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KSTPZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CLSZU sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KZCLB sy-vline 
WA_MPES_PHANTOM_FLAT_STR-AEHLP sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PRVBE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-NLFZV sy-vline 
WA_MPES_PHANTOM_FLAT_STR-NLFMV sy-vline 
WA_MPES_PHANTOM_FLAT_STR-IDPOS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-IDHIS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-IDVAR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ALEKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ITMID sy-vline 
WA_MPES_PHANTOM_FLAT_STR-GUID sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ITSOB sy-vline 
WA_MPES_PHANTOM_FLAT_STR-RFPNT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-GUIDX sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SGT_CMKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SGT_CATV sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VALID_TO sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VALID_TO_RKEY sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ECN_TO sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ECN_TO_RKEY sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ABLAD sy-vline 
WA_MPES_PHANTOM_FLAT_STR-WEMPF sy-vline 
WA_MPES_PHANTOM_FLAT_STR-STVKN_VERSN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-LASTCHANGEDATETIME sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SFWIND sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DUMMY_STPO_INCL_EEW_PS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CUFACTOR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-/SAPMP/MET_LRCH sy-vline 
WA_MPES_PHANTOM_FLAT_STR-/SAPMP/MAX_FERTL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-/SAPMP/FIX_AS_J sy-vline 
WA_MPES_PHANTOM_FLAT_STR-/SAPMP/FIX_AS_E sy-vline 
WA_MPES_PHANTOM_FLAT_STR-/SAPMP/FIX_AS_L sy-vline 
WA_MPES_PHANTOM_FLAT_STR-/SAPMP/ABL_ZAHL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-/SAPMP/RUND_FAKT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-FSH_VMKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-FSH_PGQR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-FSH_PGQRRF sy-vline 
WA_MPES_PHANTOM_FLAT_STR-FSH_CRITICAL_COMP sy-vline 
WA_MPES_PHANTOM_FLAT_STR-FSH_CRITICAL_LEVEL sy-vline 
WA_MPES_PHANTOM_FLAT_STR-FUNCID sy-vline 
WA_MPES_PHANTOM_FLAT_STR-AENRA sy-vline 
WA_MPES_PHANTOM_FLAT_STR-BOMOB sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DATUB sy-vline 
WA_MPES_PHANTOM_FLAT_STR-DUMPS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-IDENT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KTEXT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-LTXPO sy-vline 
WA_MPES_PHANTOM_FLAT_STR-OBTSP sy-vline 
WA_MPES_PHANTOM_FLAT_STR-OBKTX sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ROKME sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ROAME sy-vline 
WA_MPES_PHANTOM_FLAT_STR-STLKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-KZAUS sy-vline 
WA_MPES_PHANTOM_FLAT_STR-SCHKZ sy-vline 
WA_MPES_PHANTOM_FLAT_STR-FLG_INV sy-vline 
WA_MPES_PHANTOM_FLAT_STR-FLG_LOCK sy-vline 
WA_MPES_PHANTOM_FLAT_STR-HANDLE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-BOM_VERSN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VERSNST sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VERSNIND sy-vline 
WA_MPES_PHANTOM_FLAT_STR-VERSNLASTIND sy-vline 
WA_MPES_PHANTOM_FLAT_STR-BOM_PREV_VERSN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ABS_EFF_TAB sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ABS_AENNR sy-vline 
WA_MPES_PHANTOM_FLAT_STR-GEN_ECN sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CHANGE_TYPE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-NODE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-PARENT_NODE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-CHECKED sy-vline 
WA_MPES_PHANTOM_FLAT_STR-IGNORE sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ERDAT sy-vline 
WA_MPES_PHANTOM_FLAT_STR-ERNAM sy-vline      INTO ld_text SEPARATED BY SPACE.

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