ABAP Select data from SAP table MCJHTFPB 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 MCJHTFPB 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 MCJHTFPB. 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 MCJHTFPB 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_MCJHTFPB TYPE STANDARD TABLE OF MCJHTFPB,
      WA_MCJHTFPB TYPE MCJHTFPB,
      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: <MCJHTFPB> TYPE MCJHTFPB.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM MCJHTFPB
*  INTO TABLE @DATA(IT_MCJHTFPB2).
*--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_MCJHTFPB INDEX 1 INTO DATA(WA_MCJHTFPB2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<MCJHTFPB>-SUPKZ = 1.
<MCJHTFPB>-MANDT = 1.
<MCJHTFPB>-VBELN = 1.
<MCJHTFPB>-POSNR = 1.
<MCJHTFPB>-VTWEG = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_MCJHTFPB-SPART, sy-vline,
  WA_MCJHTFPB-KDGRP, sy-vline,
  WA_MCJHTFPB-KONDA, sy-vline,
  WA_MCJHTFPB-KAPPL, sy-vline,
  WA_MCJHTFPB-KALSM, sy-vline,
  WA_MCJHTFPB-ARKTX, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_MCJHTFPB 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_MCJHTFPB 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_MCJHTFPB INTO WA_MCJHTFPB.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit EXCRT, internal->external for field KURSK
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_MCJHTFPB-KURSK
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCJHTFPB-KURSK.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit MCAMP, internal->external for field CAMPAIGN
CALL FUNCTION 'CONVERSION_EXIT_MCAMP_OUTPUT'
  EXPORTING
    input =                      WA_MCJHTFPB-CAMPAIGN
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCJHTFPB-CAMPAIGN.
WRITE:/ 'New Value:', ld_input.

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

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

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

*Conversion exit EXCRT, internal->external for field STCUR
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_MCJHTFPB-STCUR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCJHTFPB-STCUR.
WRITE:/ 'New Value:', ld_input.

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

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

*Conversion exit CUNIT, internal->external for field J_VRKME
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_MCJHTFPB-J_VRKME
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_MCJHTFPB-J_VRKME.
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_MCJHTFPB_STR, 
SUPKZ TYPE STRING,
MANDT TYPE STRING,
VBELN TYPE STRING,
POSNR TYPE STRING,
VTWEG TYPE STRING,
SPART TYPE STRING,
KDGRP TYPE STRING,
KONDA TYPE STRING,
KAPPL TYPE STRING,
KALSM TYPE STRING,
ARKTX TYPE STRING,
AUBEL TYPE STRING,
AUPOS TYPE STRING,
AUGRP TYPE STRING,
AUETE TYPE STRING,
AVMAUART TYPE STRING,
AUREF TYPE STRING,
BEINH TYPE STRING,
BEINH_BAS TYPE STRING,
DRERZ TYPE STRING,
PVA TYPE STRING,
IHKOMP TYPE STRING,
INHK_KFM TYPE STRING,
INHK_TECH2 TYPE STRING,
AZAFOV TYPE STRING,
AZAFO TYPE STRING,
AZAFA TYPE STRING,
AZAGST TYPE STRING,
TERMINSPEZ TYPE STRING,
VAVTYP TYPE STRING,
CHIFFRE TYPE STRING,
ABSRB TYPE STRING,
ABSBO TYPE STRING,
ABSFMPR TYPE STRING,
GO_PREIS TYPE STRING,
INSERENT TYPE STRING,
STICHW TYPE STRING,
DIENSTL TYPE STRING,
DITYP TYPE STRING,
MATNR TYPE STRING,
EAN11 TYPE STRING,
FBUDA TYPE STRING,
FSART TYPE STRING,
KTGRM TYPE STRING,
KTGRB TYPE STRING,
PRSFD TYPE STRING,
KURSK TYPE STRING,
PRSDT TYPE STRING,
SHKZG TYPE STRING,
SMENG TYPE STRING,
FKIMG TYPE STRING,
MEINS TYPE STRING,
BRGEW TYPE STRING,
NTGEW TYPE STRING,
GEWEI TYPE STRING,
VGBEL TYPE STRING,
VGPOS TYPE STRING,
VGETE TYPE STRING,
VGTYP TYPE STRING,
VGOBJ TYPE STRING,
VGFKTYP TYPE STRING,
VBELV TYPE STRING,
POSNV TYPE STRING,
VKBUR TYPE STRING,
VKGRP TYPE STRING,
VRKME TYPE STRING,
WERKS TYPE STRING,
POSAR TYPE STRING,
PRODH TYPE STRING,
PSTYV TYPE STRING,
TAXM1 TYPE STRING,
TAXM2 TYPE STRING,
TAXM3 TYPE STRING,
TAXM4 TYPE STRING,
TAXM5 TYPE STRING,
TAXM6 TYPE STRING,
TAXM7 TYPE STRING,
TAXM8 TYPE STRING,
TAXM9 TYPE STRING,
GSBER TYPE STRING,
AUFNR TYPE STRING,
KOSTL TYPE STRING,
PRCTR TYPE STRING,
RK_AUFNR TYPE STRING,
RK_POSNR TYPE STRING,
KOSTL_R2 TYPE STRING,
STGRB TYPE STRING,
STAFO TYPE STRING,
SKTOF TYPE STRING,
RRREL TYPE STRING,
RRSTA TYPE STRING,
CAMPAIGN TYPE STRING,
PACKAGE_ID TYPE STRING,
PK_REF_AVM_NR TYPE STRING,
PK_REF_POS_NR TYPE STRING,
ERFUSER TYPE STRING,
ERFDATE TYPE STRING,
ERFTIME TYPE STRING,
AENUSER TYPE STRING,
AENDATE TYPE STRING,
AENTIME TYPE STRING,
KUNAG TYPE STRING,
ELAND TYPE STRING,
POSPA TYPE STRING,
PLTYP_AUFT TYPE STRING,
MPROK TYPE STRING,
KOWRR TYPE STRING,
BONBA TYPE STRING,
KZWI1 TYPE STRING,
KZWI2 TYPE STRING,
KZWI3 TYPE STRING,
KZWI4 TYPE STRING,
KZWI5 TYPE STRING,
KZWI6 TYPE STRING,
WAVWR TYPE STRING,
SKFBP TYPE STRING,
BRTWP TYPE STRING,
NETWP TYPE STRING,
MWSBP TYPE STRING,
CMPRE TYPE STRING,
CMPRE_FLT TYPE STRING,
UVPRS TYPE STRING,
UVALL TYPE STRING,
XERLV TYPE STRING,
XPEAB TYPE STRING,
TXJCD TYPE STRING,
UMVKZ TYPE STRING,
UMVKN TYPE STRING,
STCUR TYPE STRING,
PAOBJNR TYPE STRING,
KOKRS TYPE STRING,
ZUONR TYPE STRING,
KOUPD TYPE STRING,
XCNCL TYPE STRING,
BEDNR TYPE STRING,
PROVTYP TYPE STRING,
VZUONR TYPE STRING,
BERART TYPE STRING,
PBSCHL TYPE STRING,
SCBAS TYPE STRING,
VERMART TYPE STRING,
PR_BETRAG TYPE STRING,
PBBASIS TYPE STRING,
ISPBEDART TYPE STRING,
ALAND TYPE STRING,
XSTEIG TYPE STRING,
VKORG_AUFT TYPE STRING,
EPROZ TYPE STRING,
NETWPV TYPE STRING,
KTGRP TYPE STRING,
J_FKIMG TYPE STRING,
J_VRKME TYPE STRING,
STGKUP TYPE STRING,END OF T_EKKO_STR.
DATA: WA_MCJHTFPB_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_MCJHTFPB_STR-SUPKZ sy-vline 
WA_MCJHTFPB_STR-MANDT sy-vline 
WA_MCJHTFPB_STR-VBELN sy-vline 
WA_MCJHTFPB_STR-POSNR sy-vline 
WA_MCJHTFPB_STR-VTWEG sy-vline 
WA_MCJHTFPB_STR-SPART sy-vline 
WA_MCJHTFPB_STR-KDGRP sy-vline 
WA_MCJHTFPB_STR-KONDA sy-vline 
WA_MCJHTFPB_STR-KAPPL sy-vline 
WA_MCJHTFPB_STR-KALSM sy-vline 
WA_MCJHTFPB_STR-ARKTX sy-vline 
WA_MCJHTFPB_STR-AUBEL sy-vline 
WA_MCJHTFPB_STR-AUPOS sy-vline 
WA_MCJHTFPB_STR-AUGRP sy-vline 
WA_MCJHTFPB_STR-AUETE sy-vline 
WA_MCJHTFPB_STR-AVMAUART sy-vline 
WA_MCJHTFPB_STR-AUREF sy-vline 
WA_MCJHTFPB_STR-BEINH sy-vline 
WA_MCJHTFPB_STR-BEINH_BAS sy-vline 
WA_MCJHTFPB_STR-DRERZ sy-vline 
WA_MCJHTFPB_STR-PVA sy-vline 
WA_MCJHTFPB_STR-IHKOMP sy-vline 
WA_MCJHTFPB_STR-INHK_KFM sy-vline 
WA_MCJHTFPB_STR-INHK_TECH2 sy-vline 
WA_MCJHTFPB_STR-AZAFOV sy-vline 
WA_MCJHTFPB_STR-AZAFO sy-vline 
WA_MCJHTFPB_STR-AZAFA sy-vline 
WA_MCJHTFPB_STR-AZAGST sy-vline 
WA_MCJHTFPB_STR-TERMINSPEZ sy-vline 
WA_MCJHTFPB_STR-VAVTYP sy-vline 
WA_MCJHTFPB_STR-CHIFFRE sy-vline 
WA_MCJHTFPB_STR-ABSRB sy-vline 
WA_MCJHTFPB_STR-ABSBO sy-vline 
WA_MCJHTFPB_STR-ABSFMPR sy-vline 
WA_MCJHTFPB_STR-GO_PREIS sy-vline 
WA_MCJHTFPB_STR-INSERENT sy-vline 
WA_MCJHTFPB_STR-STICHW sy-vline 
WA_MCJHTFPB_STR-DIENSTL sy-vline 
WA_MCJHTFPB_STR-DITYP sy-vline 
WA_MCJHTFPB_STR-MATNR sy-vline 
WA_MCJHTFPB_STR-EAN11 sy-vline 
WA_MCJHTFPB_STR-FBUDA sy-vline 
WA_MCJHTFPB_STR-FSART sy-vline 
WA_MCJHTFPB_STR-KTGRM sy-vline 
WA_MCJHTFPB_STR-KTGRB sy-vline 
WA_MCJHTFPB_STR-PRSFD sy-vline 
WA_MCJHTFPB_STR-KURSK sy-vline 
WA_MCJHTFPB_STR-PRSDT sy-vline 
WA_MCJHTFPB_STR-SHKZG sy-vline 
WA_MCJHTFPB_STR-SMENG sy-vline 
WA_MCJHTFPB_STR-FKIMG sy-vline 
WA_MCJHTFPB_STR-MEINS sy-vline 
WA_MCJHTFPB_STR-BRGEW sy-vline 
WA_MCJHTFPB_STR-NTGEW sy-vline 
WA_MCJHTFPB_STR-GEWEI sy-vline 
WA_MCJHTFPB_STR-VGBEL sy-vline 
WA_MCJHTFPB_STR-VGPOS sy-vline 
WA_MCJHTFPB_STR-VGETE sy-vline 
WA_MCJHTFPB_STR-VGTYP sy-vline 
WA_MCJHTFPB_STR-VGOBJ sy-vline 
WA_MCJHTFPB_STR-VGFKTYP sy-vline 
WA_MCJHTFPB_STR-VBELV sy-vline 
WA_MCJHTFPB_STR-POSNV sy-vline 
WA_MCJHTFPB_STR-VKBUR sy-vline 
WA_MCJHTFPB_STR-VKGRP sy-vline 
WA_MCJHTFPB_STR-VRKME sy-vline 
WA_MCJHTFPB_STR-WERKS sy-vline 
WA_MCJHTFPB_STR-POSAR sy-vline 
WA_MCJHTFPB_STR-PRODH sy-vline 
WA_MCJHTFPB_STR-PSTYV sy-vline 
WA_MCJHTFPB_STR-TAXM1 sy-vline 
WA_MCJHTFPB_STR-TAXM2 sy-vline 
WA_MCJHTFPB_STR-TAXM3 sy-vline 
WA_MCJHTFPB_STR-TAXM4 sy-vline 
WA_MCJHTFPB_STR-TAXM5 sy-vline 
WA_MCJHTFPB_STR-TAXM6 sy-vline 
WA_MCJHTFPB_STR-TAXM7 sy-vline 
WA_MCJHTFPB_STR-TAXM8 sy-vline 
WA_MCJHTFPB_STR-TAXM9 sy-vline 
WA_MCJHTFPB_STR-GSBER sy-vline 
WA_MCJHTFPB_STR-AUFNR sy-vline 
WA_MCJHTFPB_STR-KOSTL sy-vline 
WA_MCJHTFPB_STR-PRCTR sy-vline 
WA_MCJHTFPB_STR-RK_AUFNR sy-vline 
WA_MCJHTFPB_STR-RK_POSNR sy-vline 
WA_MCJHTFPB_STR-KOSTL_R2 sy-vline 
WA_MCJHTFPB_STR-STGRB sy-vline 
WA_MCJHTFPB_STR-STAFO sy-vline 
WA_MCJHTFPB_STR-SKTOF sy-vline 
WA_MCJHTFPB_STR-RRREL sy-vline 
WA_MCJHTFPB_STR-RRSTA sy-vline 
WA_MCJHTFPB_STR-CAMPAIGN sy-vline 
WA_MCJHTFPB_STR-PACKAGE_ID sy-vline 
WA_MCJHTFPB_STR-PK_REF_AVM_NR sy-vline 
WA_MCJHTFPB_STR-PK_REF_POS_NR sy-vline 
WA_MCJHTFPB_STR-ERFUSER sy-vline 
WA_MCJHTFPB_STR-ERFDATE sy-vline 
WA_MCJHTFPB_STR-ERFTIME sy-vline 
WA_MCJHTFPB_STR-AENUSER sy-vline 
WA_MCJHTFPB_STR-AENDATE sy-vline 
WA_MCJHTFPB_STR-AENTIME sy-vline 
WA_MCJHTFPB_STR-KUNAG sy-vline 
WA_MCJHTFPB_STR-ELAND sy-vline 
WA_MCJHTFPB_STR-POSPA sy-vline 
WA_MCJHTFPB_STR-PLTYP_AUFT sy-vline 
WA_MCJHTFPB_STR-MPROK sy-vline 
WA_MCJHTFPB_STR-KOWRR sy-vline 
WA_MCJHTFPB_STR-BONBA sy-vline 
WA_MCJHTFPB_STR-KZWI1 sy-vline 
WA_MCJHTFPB_STR-KZWI2 sy-vline 
WA_MCJHTFPB_STR-KZWI3 sy-vline 
WA_MCJHTFPB_STR-KZWI4 sy-vline 
WA_MCJHTFPB_STR-KZWI5 sy-vline 
WA_MCJHTFPB_STR-KZWI6 sy-vline 
WA_MCJHTFPB_STR-WAVWR sy-vline 
WA_MCJHTFPB_STR-SKFBP sy-vline 
WA_MCJHTFPB_STR-BRTWP sy-vline 
WA_MCJHTFPB_STR-NETWP sy-vline 
WA_MCJHTFPB_STR-MWSBP sy-vline 
WA_MCJHTFPB_STR-CMPRE sy-vline 
WA_MCJHTFPB_STR-CMPRE_FLT sy-vline 
WA_MCJHTFPB_STR-UVPRS sy-vline 
WA_MCJHTFPB_STR-UVALL sy-vline 
WA_MCJHTFPB_STR-XERLV sy-vline 
WA_MCJHTFPB_STR-XPEAB sy-vline 
WA_MCJHTFPB_STR-TXJCD sy-vline 
WA_MCJHTFPB_STR-UMVKZ sy-vline 
WA_MCJHTFPB_STR-UMVKN sy-vline 
WA_MCJHTFPB_STR-STCUR sy-vline 
WA_MCJHTFPB_STR-PAOBJNR sy-vline 
WA_MCJHTFPB_STR-KOKRS sy-vline 
WA_MCJHTFPB_STR-ZUONR sy-vline 
WA_MCJHTFPB_STR-KOUPD sy-vline 
WA_MCJHTFPB_STR-XCNCL sy-vline 
WA_MCJHTFPB_STR-BEDNR sy-vline 
WA_MCJHTFPB_STR-PROVTYP sy-vline 
WA_MCJHTFPB_STR-VZUONR sy-vline 
WA_MCJHTFPB_STR-BERART sy-vline 
WA_MCJHTFPB_STR-PBSCHL sy-vline 
WA_MCJHTFPB_STR-SCBAS sy-vline 
WA_MCJHTFPB_STR-VERMART sy-vline 
WA_MCJHTFPB_STR-PR_BETRAG sy-vline 
WA_MCJHTFPB_STR-PBBASIS sy-vline 
WA_MCJHTFPB_STR-ISPBEDART sy-vline 
WA_MCJHTFPB_STR-ALAND sy-vline 
WA_MCJHTFPB_STR-XSTEIG sy-vline 
WA_MCJHTFPB_STR-VKORG_AUFT sy-vline 
WA_MCJHTFPB_STR-EPROZ sy-vline 
WA_MCJHTFPB_STR-NETWPV sy-vline 
WA_MCJHTFPB_STR-KTGRP sy-vline 
WA_MCJHTFPB_STR-J_FKIMG sy-vline 
WA_MCJHTFPB_STR-J_VRKME sy-vline 
WA_MCJHTFPB_STR-STGKUP sy-vline      INTO ld_text SEPARATED BY SPACE.

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