ABAP Select data from SAP table TCJ_POSITIONS 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 TCJ_POSITIONS 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 TCJ_POSITIONS. 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 TCJ_POSITIONS 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_TCJ_POSITIONS TYPE STANDARD TABLE OF TCJ_POSITIONS,
      WA_TCJ_POSITIONS TYPE TCJ_POSITIONS,
      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: <TCJ_POSITIONS> TYPE TCJ_POSITIONS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM TCJ_POSITIONS
*  INTO TABLE @DATA(IT_TCJ_POSITIONS2).
*--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_TCJ_POSITIONS INDEX 1 INTO DATA(WA_TCJ_POSITIONS2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<TCJ_POSITIONS>-MANDT = 1.
<TCJ_POSITIONS>-COMP_CODE = 1.
<TCJ_POSITIONS>-CAJO_NUMBER = 1.
<TCJ_POSITIONS>-FISC_YEAR = 1.
<TCJ_POSITIONS>-POSTING_NUMBER = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_TCJ_POSITIONS-POSITION_NUMBER, sy-vline,
  WA_TCJ_POSITIONS-POSITION_TYPE, sy-vline,
  WA_TCJ_POSITIONS-TRANSACT_NUMBER, sy-vline,
  WA_TCJ_POSITIONS-TRANSACT_TYPE, sy-vline,
  WA_TCJ_POSITIONS-POSTING_DATE, sy-vline,
  WA_TCJ_POSITIONS-CURRENCY, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_TCJ_POSITIONS 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_TCJ_POSITIONS 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_TCJ_POSITIONS INTO WA_TCJ_POSITIONS.


*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 GJAHR, internal->external for field FISC_YEAR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-FISC_YEAR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-FISC_YEAR.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPHC, internal->external for field TRANSACT_NUMBER
CALL FUNCTION 'CONVERSION_EXIT_ALPHC_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-TRANSACT_NUMBER
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-TRANSACT_NUMBER.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field P_RECEIPTS
CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-P_RECEIPTS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-P_RECEIPTS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field P_PAYMENTS
CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-P_PAYMENTS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-P_PAYMENTS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC132, internal->external for field P_NET_AMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AC132_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-P_NET_AMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-P_NET_AMOUNT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC152, internal->external for field P_NET_PAYMENT_WT
CALL FUNCTION 'CONVERSION_EXIT_AC152_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-P_NET_PAYMENT_WT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-P_NET_PAYMENT_WT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AU132, internal->external for field P_TAX_AMOUNT
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-P_TAX_AMOUNT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-P_TAX_AMOUNT.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

*Conversion exit ABPSP, internal->external for field PS_PSP_PNR
CALL FUNCTION 'CONVERSION_EXIT_ABPSP_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-PS_PSP_PNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-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_TCJ_POSITIONS-NPLNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-NPLNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit FMCIL, internal->external for field FIPEX
CALL FUNCTION 'CONVERSION_EXIT_FMCIL_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-FIPEX
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-FIPEX.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

*Conversion exit AU132, internal->external for field P_FWBAS
CALL FUNCTION 'CONVERSION_EXIT_AU132_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-P_FWBAS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-P_FWBAS.
WRITE:/ 'New Value:', ld_input.

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

*Conversion exit ALPHA, internal->external for field PSEGMENT
CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT'
  EXPORTING
    input =                      WA_TCJ_POSITIONS-PSEGMENT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_TCJ_POSITIONS-PSEGMENT.
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_TCJ_POSITIONS_STR, 
MANDT TYPE STRING,
COMP_CODE TYPE STRING,
CAJO_NUMBER TYPE STRING,
FISC_YEAR TYPE STRING,
POSTING_NUMBER TYPE STRING,
POSITION_NUMBER TYPE STRING,
POSITION_TYPE TYPE STRING,
TRANSACT_NUMBER TYPE STRING,
TRANSACT_TYPE TYPE STRING,
POSTING_DATE TYPE STRING,
CURRENCY TYPE STRING,
P_RECEIPTS TYPE STRING,
P_PAYMENTS TYPE STRING,
P_NET_AMOUNT TYPE STRING,
P_NET_PAYMENT_WT TYPE STRING,
P_TAX_AMOUNT TYPE STRING,
TAX_CODE TYPE STRING,
TAXCALCDATE TYPE STRING,
GL_ACCOUNT TYPE STRING,
TAX_PERCENT TYPE STRING,
POSITION_TEXT TYPE STRING,
VENDOR_NO TYPE STRING,
CUSTOMER TYPE STRING,
GSBER TYPE STRING,
PARGB TYPE STRING,
VBUND TYPE STRING,
RMVCT TYPE STRING,
FKBER TYPE STRING,
KOKRS TYPE STRING,
KOSTL TYPE STRING,
LSTAR TYPE STRING,
AUFNR TYPE STRING,
AFPOS TYPE STRING,
BEMOT TYPE STRING,
KSTRG TYPE STRING,
PRZNR TYPE STRING,
PRCTR TYPE STRING,
PPRCTR TYPE STRING,
PS_PSP_PNR TYPE STRING,
NPLNR TYPE STRING,
VORNR TYPE STRING,
ANLN1 TYPE STRING,
ANLN2 TYPE STRING,
BZDAT TYPE STRING,
ANBWA TYPE STRING,
WERKS TYPE STRING,
BWTAR TYPE STRING,
BWKEY TYPE STRING,
MATNR TYPE STRING,
HRKFT TYPE STRING,
HKMAT TYPE STRING,
KDAUF TYPE STRING,
KDEIN TYPE STRING,
KDPOS TYPE STRING,
VNAME TYPE STRING,
RECID TYPE STRING,
RECID_MAN TYPE STRING,
EGRUP TYPE STRING,
ETYPE TYPE STRING,
VPTNR TYPE STRING,
CONDI TYPE STRING,
CRPCAL TYPE STRING,
FIKRS TYPE STRING,
FISTL TYPE STRING,
FIPOS TYPE STRING,
FIPEX TYPE STRING,
GEBER TYPE STRING,
KBLNR TYPE STRING,
KBLPOS TYPE STRING,
ERLKZ TYPE STRING,
PERNR TYPE STRING,
PAOBJNR TYPE STRING,
IMKEY TYPE STRING,
KONTT TYPE STRING,
KONTL TYPE STRING,
DUMMY_INCL_EEW_COBL TYPE STRING,
SMIVE TYPE STRING,
GRANT_NBR TYPE STRING,
DABRZ TYPE STRING,
BUDGET_PD TYPE STRING,
MONAT TYPE STRING,
LOGSYS_KDAUF TYPE STRING,
TAXJURCODE TYPE STRING,
ALLOC_NMBR TYPE STRING,
BRANCH TYPE STRING,
P_FWBAS TYPE STRING,
SEGMENT TYPE STRING,
PSEGMENT TYPE STRING,
STCEG TYPE STRING,
UMSKZ TYPE STRING,
HBKID TYPE STRING,
HKTID TYPE STRING,
BVTYP TYPE STRING,
TAX_COUNTRY TYPE STRING,END OF T_EKKO_STR.
DATA: WA_TCJ_POSITIONS_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_TCJ_POSITIONS_STR-MANDT sy-vline 
WA_TCJ_POSITIONS_STR-COMP_CODE sy-vline 
WA_TCJ_POSITIONS_STR-CAJO_NUMBER sy-vline 
WA_TCJ_POSITIONS_STR-FISC_YEAR sy-vline 
WA_TCJ_POSITIONS_STR-POSTING_NUMBER sy-vline 
WA_TCJ_POSITIONS_STR-POSITION_NUMBER sy-vline 
WA_TCJ_POSITIONS_STR-POSITION_TYPE sy-vline 
WA_TCJ_POSITIONS_STR-TRANSACT_NUMBER sy-vline 
WA_TCJ_POSITIONS_STR-TRANSACT_TYPE sy-vline 
WA_TCJ_POSITIONS_STR-POSTING_DATE sy-vline 
WA_TCJ_POSITIONS_STR-CURRENCY sy-vline 
WA_TCJ_POSITIONS_STR-P_RECEIPTS sy-vline 
WA_TCJ_POSITIONS_STR-P_PAYMENTS sy-vline 
WA_TCJ_POSITIONS_STR-P_NET_AMOUNT sy-vline 
WA_TCJ_POSITIONS_STR-P_NET_PAYMENT_WT sy-vline 
WA_TCJ_POSITIONS_STR-P_TAX_AMOUNT sy-vline 
WA_TCJ_POSITIONS_STR-TAX_CODE sy-vline 
WA_TCJ_POSITIONS_STR-TAXCALCDATE sy-vline 
WA_TCJ_POSITIONS_STR-GL_ACCOUNT sy-vline 
WA_TCJ_POSITIONS_STR-TAX_PERCENT sy-vline 
WA_TCJ_POSITIONS_STR-POSITION_TEXT sy-vline 
WA_TCJ_POSITIONS_STR-VENDOR_NO sy-vline 
WA_TCJ_POSITIONS_STR-CUSTOMER sy-vline 
WA_TCJ_POSITIONS_STR-GSBER sy-vline 
WA_TCJ_POSITIONS_STR-PARGB sy-vline 
WA_TCJ_POSITIONS_STR-VBUND sy-vline 
WA_TCJ_POSITIONS_STR-RMVCT sy-vline 
WA_TCJ_POSITIONS_STR-FKBER sy-vline 
WA_TCJ_POSITIONS_STR-KOKRS sy-vline 
WA_TCJ_POSITIONS_STR-KOSTL sy-vline 
WA_TCJ_POSITIONS_STR-LSTAR sy-vline 
WA_TCJ_POSITIONS_STR-AUFNR sy-vline 
WA_TCJ_POSITIONS_STR-AFPOS sy-vline 
WA_TCJ_POSITIONS_STR-BEMOT sy-vline 
WA_TCJ_POSITIONS_STR-KSTRG sy-vline 
WA_TCJ_POSITIONS_STR-PRZNR sy-vline 
WA_TCJ_POSITIONS_STR-PRCTR sy-vline 
WA_TCJ_POSITIONS_STR-PPRCTR sy-vline 
WA_TCJ_POSITIONS_STR-PS_PSP_PNR sy-vline 
WA_TCJ_POSITIONS_STR-NPLNR sy-vline 
WA_TCJ_POSITIONS_STR-VORNR sy-vline 
WA_TCJ_POSITIONS_STR-ANLN1 sy-vline 
WA_TCJ_POSITIONS_STR-ANLN2 sy-vline 
WA_TCJ_POSITIONS_STR-BZDAT sy-vline 
WA_TCJ_POSITIONS_STR-ANBWA sy-vline 
WA_TCJ_POSITIONS_STR-WERKS sy-vline 
WA_TCJ_POSITIONS_STR-BWTAR sy-vline 
WA_TCJ_POSITIONS_STR-BWKEY sy-vline 
WA_TCJ_POSITIONS_STR-MATNR sy-vline 
WA_TCJ_POSITIONS_STR-HRKFT sy-vline 
WA_TCJ_POSITIONS_STR-HKMAT sy-vline 
WA_TCJ_POSITIONS_STR-KDAUF sy-vline 
WA_TCJ_POSITIONS_STR-KDEIN sy-vline 
WA_TCJ_POSITIONS_STR-KDPOS sy-vline 
WA_TCJ_POSITIONS_STR-VNAME sy-vline 
WA_TCJ_POSITIONS_STR-RECID sy-vline 
WA_TCJ_POSITIONS_STR-RECID_MAN sy-vline 
WA_TCJ_POSITIONS_STR-EGRUP sy-vline 
WA_TCJ_POSITIONS_STR-ETYPE sy-vline 
WA_TCJ_POSITIONS_STR-VPTNR sy-vline 
WA_TCJ_POSITIONS_STR-CONDI sy-vline 
WA_TCJ_POSITIONS_STR-CRPCAL sy-vline 
WA_TCJ_POSITIONS_STR-FIKRS sy-vline 
WA_TCJ_POSITIONS_STR-FISTL sy-vline 
WA_TCJ_POSITIONS_STR-FIPOS sy-vline 
WA_TCJ_POSITIONS_STR-FIPEX sy-vline 
WA_TCJ_POSITIONS_STR-GEBER sy-vline 
WA_TCJ_POSITIONS_STR-KBLNR sy-vline 
WA_TCJ_POSITIONS_STR-KBLPOS sy-vline 
WA_TCJ_POSITIONS_STR-ERLKZ sy-vline 
WA_TCJ_POSITIONS_STR-PERNR sy-vline 
WA_TCJ_POSITIONS_STR-PAOBJNR sy-vline 
WA_TCJ_POSITIONS_STR-IMKEY sy-vline 
WA_TCJ_POSITIONS_STR-KONTT sy-vline 
WA_TCJ_POSITIONS_STR-KONTL sy-vline 
WA_TCJ_POSITIONS_STR-DUMMY_INCL_EEW_COBL sy-vline 
WA_TCJ_POSITIONS_STR-SMIVE sy-vline 
WA_TCJ_POSITIONS_STR-GRANT_NBR sy-vline 
WA_TCJ_POSITIONS_STR-DABRZ sy-vline 
WA_TCJ_POSITIONS_STR-BUDGET_PD sy-vline 
WA_TCJ_POSITIONS_STR-MONAT sy-vline 
WA_TCJ_POSITIONS_STR-LOGSYS_KDAUF sy-vline 
WA_TCJ_POSITIONS_STR-TAXJURCODE sy-vline 
WA_TCJ_POSITIONS_STR-ALLOC_NMBR sy-vline 
WA_TCJ_POSITIONS_STR-BRANCH sy-vline 
WA_TCJ_POSITIONS_STR-P_FWBAS sy-vline 
WA_TCJ_POSITIONS_STR-SEGMENT sy-vline 
WA_TCJ_POSITIONS_STR-PSEGMENT sy-vline 
WA_TCJ_POSITIONS_STR-STCEG sy-vline 
WA_TCJ_POSITIONS_STR-UMSKZ sy-vline 
WA_TCJ_POSITIONS_STR-HBKID sy-vline 
WA_TCJ_POSITIONS_STR-HKTID sy-vline 
WA_TCJ_POSITIONS_STR-BVTYP sy-vline 
WA_TCJ_POSITIONS_STR-TAX_COUNTRY sy-vline      INTO ld_text SEPARATED BY SPACE.

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