ABAP Select data from SAP table P0706 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 P0706 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 P0706. 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 P0706 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_P0706 TYPE STANDARD TABLE OF P0706,
      WA_P0706 TYPE P0706,
      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: <P0706> TYPE P0706.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM P0706
*  INTO TABLE @DATA(IT_P07062).
*--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_P0706 INDEX 1 INTO DATA(WA_P07062).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<P0706>-PERNR = 1.
<P0706>-INFTY = 1.
<P0706>-SUBTY = 1.
<P0706>-OBJPS = 1.
<P0706>-SPRPS = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_P0706-ENDDA, sy-vline,
  WA_P0706-BEGDA, sy-vline,
  WA_P0706-SEQNR, sy-vline,
  WA_P0706-AEDTM, sy-vline,
  WA_P0706-UNAME, sy-vline,
  WA_P0706-HISTO, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_P0706 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_P0706 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_P0706 INTO WA_P0706.


*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 EXCRT, internal->external for field EXCHANGE_RATE
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_P0706-EXCHANGE_RATE
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_P0706-EXCHANGE_RATE.
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_P0706_STR, 
PERNR TYPE STRING,
INFTY TYPE STRING,
SUBTY TYPE STRING,
OBJPS TYPE STRING,
SPRPS TYPE STRING,
ENDDA TYPE STRING,
BEGDA TYPE STRING,
SEQNR TYPE STRING,
AEDTM TYPE STRING,
UNAME TYPE STRING,
HISTO TYPE STRING,
ITXEX TYPE STRING,
REFEX TYPE STRING,
ORDEX TYPE STRING,
ITBLD TYPE STRING,
PREAS TYPE STRING,
FLAG1 TYPE STRING,
FLAG2 TYPE STRING,
FLAG3 TYPE STRING,
FLAG4 TYPE STRING,
RESE1 TYPE STRING,
RESE2 TYPE STRING,
GRPVL TYPE STRING,
COMP_PACK_PART TYPE STRING,
CURRENCY TYPE STRING,
EXCHANGE_RATE TYPE STRING,
EXCHANGE_DATE TYPE STRING,
COL_INDEX TYPE STRING,
COLI_DATE TYPE STRING,
CPI01 TYPE STRING,
AMOUNT01 TYPE STRING,
CURRENCY01 TYPE STRING,
FREQ01 TYPE STRING,
PAY_TYPE01 TYPE STRING,
CPI_TYPE01 TYPE STRING,
BCPI01 TYPE STRING,
PRCNT01 TYPE STRING,
TAXBLE01 TYPE STRING,
OVRTFL01 TYPE STRING,
OVRTMET01 TYPE STRING,
CPI02 TYPE STRING,
AMOUNT02 TYPE STRING,
CURRENCY02 TYPE STRING,
FREQ02 TYPE STRING,
PAY_TYPE02 TYPE STRING,
CPI_TYPE02 TYPE STRING,
BCPI02 TYPE STRING,
PRCNT02 TYPE STRING,
TAXBLE02 TYPE STRING,
OVRTFL02 TYPE STRING,
OVRTMET02 TYPE STRING,
CPI03 TYPE STRING,
AMOUNT03 TYPE STRING,
CURRENCY03 TYPE STRING,
FREQ03 TYPE STRING,
PAY_TYPE03 TYPE STRING,
CPI_TYPE03 TYPE STRING,
BCPI03 TYPE STRING,
PRCNT03 TYPE STRING,
TAXBLE03 TYPE STRING,
OVRTFL03 TYPE STRING,
OVRTMET03 TYPE STRING,
CPI04 TYPE STRING,
AMOUNT04 TYPE STRING,
CURRENCY04 TYPE STRING,
FREQ04 TYPE STRING,
PAY_TYPE04 TYPE STRING,
CPI_TYPE04 TYPE STRING,
BCPI04 TYPE STRING,
PRCNT04 TYPE STRING,
TAXBLE04 TYPE STRING,
OVRTFL04 TYPE STRING,
OVRTMET04 TYPE STRING,
CPI05 TYPE STRING,
AMOUNT05 TYPE STRING,
CURRENCY05 TYPE STRING,
FREQ05 TYPE STRING,
PAY_TYPE05 TYPE STRING,
CPI_TYPE05 TYPE STRING,
BCPI05 TYPE STRING,
PRCNT05 TYPE STRING,
TAXBLE05 TYPE STRING,
OVRTFL05 TYPE STRING,
OVRTMET05 TYPE STRING,
CPI06 TYPE STRING,
AMOUNT06 TYPE STRING,
CURRENCY06 TYPE STRING,
FREQ06 TYPE STRING,
PAY_TYPE06 TYPE STRING,
CPI_TYPE06 TYPE STRING,
BCPI06 TYPE STRING,
PRCNT06 TYPE STRING,
TAXBLE06 TYPE STRING,
OVRTFL06 TYPE STRING,
OVRTMET06 TYPE STRING,
CPI07 TYPE STRING,
AMOUNT07 TYPE STRING,
CURRENCY07 TYPE STRING,
FREQ07 TYPE STRING,
PAY_TYPE07 TYPE STRING,
CPI_TYPE07 TYPE STRING,
BCPI07 TYPE STRING,
PRCNT07 TYPE STRING,
TAXBLE07 TYPE STRING,
OVRTFL07 TYPE STRING,
OVRTMET07 TYPE STRING,
CPI08 TYPE STRING,
AMOUNT08 TYPE STRING,
CURRENCY08 TYPE STRING,
FREQ08 TYPE STRING,
PAY_TYPE08 TYPE STRING,
CPI_TYPE08 TYPE STRING,
BCPI08 TYPE STRING,
PRCNT08 TYPE STRING,
TAXBLE08 TYPE STRING,
OVRTFL08 TYPE STRING,
OVRTMET08 TYPE STRING,
CPI09 TYPE STRING,
AMOUNT09 TYPE STRING,
CURRENCY09 TYPE STRING,
FREQ09 TYPE STRING,
PAY_TYPE09 TYPE STRING,
CPI_TYPE09 TYPE STRING,
BCPI09 TYPE STRING,
PRCNT09 TYPE STRING,
TAXBLE09 TYPE STRING,
OVRTFL09 TYPE STRING,
OVRTMET09 TYPE STRING,
CPI10 TYPE STRING,
AMOUNT10 TYPE STRING,
CURRENCY10 TYPE STRING,
FREQ10 TYPE STRING,
PAY_TYPE10 TYPE STRING,
CPI_TYPE10 TYPE STRING,
BCPI10 TYPE STRING,
PRCNT10 TYPE STRING,
TAXBLE10 TYPE STRING,
OVRTFL10 TYPE STRING,
OVRTMET10 TYPE STRING,
CPI11 TYPE STRING,
AMOUNT11 TYPE STRING,
CURRENCY11 TYPE STRING,
FREQ11 TYPE STRING,
PAY_TYPE11 TYPE STRING,
CPI_TYPE11 TYPE STRING,
BCPI11 TYPE STRING,
PRCNT11 TYPE STRING,
TAXBLE11 TYPE STRING,
OVRTFL11 TYPE STRING,
OVRTMET11 TYPE STRING,
CPI12 TYPE STRING,
AMOUNT12 TYPE STRING,
CURRENCY12 TYPE STRING,
FREQ12 TYPE STRING,
PAY_TYPE12 TYPE STRING,
CPI_TYPE12 TYPE STRING,
BCPI12 TYPE STRING,
PRCNT12 TYPE STRING,
TAXBLE12 TYPE STRING,
OVRTFL12 TYPE STRING,
OVRTMET12 TYPE STRING,
CPI13 TYPE STRING,
AMOUNT13 TYPE STRING,
CURRENCY13 TYPE STRING,
FREQ13 TYPE STRING,
PAY_TYPE13 TYPE STRING,
CPI_TYPE13 TYPE STRING,
BCPI13 TYPE STRING,
PRCNT13 TYPE STRING,
TAXBLE13 TYPE STRING,
OVRTFL13 TYPE STRING,
OVRTMET13 TYPE STRING,
CPI14 TYPE STRING,
AMOUNT14 TYPE STRING,
CURRENCY14 TYPE STRING,
FREQ14 TYPE STRING,
PAY_TYPE14 TYPE STRING,
CPI_TYPE14 TYPE STRING,
BCPI14 TYPE STRING,
PRCNT14 TYPE STRING,
TAXBLE14 TYPE STRING,
OVRTFL14 TYPE STRING,
OVRTMET14 TYPE STRING,
CPI15 TYPE STRING,
AMOUNT15 TYPE STRING,
CURRENCY15 TYPE STRING,
FREQ15 TYPE STRING,
PAY_TYPE15 TYPE STRING,
CPI_TYPE15 TYPE STRING,
BCPI15 TYPE STRING,
PRCNT15 TYPE STRING,
TAXBLE15 TYPE STRING,
OVRTFL15 TYPE STRING,
OVRTMET15 TYPE STRING,
CPI16 TYPE STRING,
AMOUNT16 TYPE STRING,
CURRENCY16 TYPE STRING,
FREQ16 TYPE STRING,
PAY_TYPE16 TYPE STRING,
CPI_TYPE16 TYPE STRING,
BCPI16 TYPE STRING,
PRCNT16 TYPE STRING,
TAXBLE16 TYPE STRING,
OVRTFL16 TYPE STRING,
OVRTMET16 TYPE STRING,
CPI17 TYPE STRING,
AMOUNT17 TYPE STRING,
CURRENCY17 TYPE STRING,
FREQ17 TYPE STRING,
PAY_TYPE17 TYPE STRING,
CPI_TYPE17 TYPE STRING,
BCPI17 TYPE STRING,
PRCNT17 TYPE STRING,
TAXBLE17 TYPE STRING,
OVRTFL17 TYPE STRING,
OVRTMET17 TYPE STRING,
CPI18 TYPE STRING,
AMOUNT18 TYPE STRING,
CURRENCY18 TYPE STRING,
FREQ18 TYPE STRING,
PAY_TYPE18 TYPE STRING,
CPI_TYPE18 TYPE STRING,
BCPI18 TYPE STRING,
PRCNT18 TYPE STRING,
TAXBLE18 TYPE STRING,
OVRTFL18 TYPE STRING,
OVRTMET18 TYPE STRING,
CPI19 TYPE STRING,
AMOUNT19 TYPE STRING,
CURRENCY19 TYPE STRING,
FREQ19 TYPE STRING,
PAY_TYPE19 TYPE STRING,
CPI_TYPE19 TYPE STRING,
BCPI19 TYPE STRING,
PRCNT19 TYPE STRING,
TAXBLE19 TYPE STRING,
OVRTFL19 TYPE STRING,
OVRTMET19 TYPE STRING,
CPI20 TYPE STRING,
AMOUNT20 TYPE STRING,
CURRENCY20 TYPE STRING,
FREQ20 TYPE STRING,
PAY_TYPE20 TYPE STRING,
CPI_TYPE20 TYPE STRING,
BCPI20 TYPE STRING,
PRCNT20 TYPE STRING,
TAXBLE20 TYPE STRING,
OVRTFL20 TYPE STRING,
OVRTMET20 TYPE STRING,
SYSTEM_DATE TYPE STRING,
SYSTEM_TIME TYPE STRING,
USER_DATE TYPE STRING,
USER_TIME TYPE STRING,
OVR_COLI TYPE STRING,
OVR_COLDA TYPE STRING,
OVR_EXCRA TYPE STRING,
OVR_EXCDA TYPE STRING,
ACTIVATION_DATE TYPE STRING,
STATUS TYPE STRING,
FACTOR01 TYPE STRING,
FACTOR02 TYPE STRING,
FACTOR03 TYPE STRING,
FACTOR04 TYPE STRING,
FACTOR05 TYPE STRING,
FACTOR06 TYPE STRING,
FACTOR07 TYPE STRING,
FACTOR08 TYPE STRING,
FACTOR09 TYPE STRING,
FACTOR10 TYPE STRING,
FACTOR11 TYPE STRING,
FACTOR12 TYPE STRING,
FACTOR13 TYPE STRING,
FACTOR14 TYPE STRING,
FACTOR15 TYPE STRING,
FACTOR16 TYPE STRING,
FACTOR17 TYPE STRING,
FACTOR18 TYPE STRING,
FACTOR19 TYPE STRING,
FACTOR20 TYPE STRING,END OF T_EKKO_STR.
DATA: WA_P0706_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_P0706_STR-PERNR sy-vline 
WA_P0706_STR-INFTY sy-vline 
WA_P0706_STR-SUBTY sy-vline 
WA_P0706_STR-OBJPS sy-vline 
WA_P0706_STR-SPRPS sy-vline 
WA_P0706_STR-ENDDA sy-vline 
WA_P0706_STR-BEGDA sy-vline 
WA_P0706_STR-SEQNR sy-vline 
WA_P0706_STR-AEDTM sy-vline 
WA_P0706_STR-UNAME sy-vline 
WA_P0706_STR-HISTO sy-vline 
WA_P0706_STR-ITXEX sy-vline 
WA_P0706_STR-REFEX sy-vline 
WA_P0706_STR-ORDEX sy-vline 
WA_P0706_STR-ITBLD sy-vline 
WA_P0706_STR-PREAS sy-vline 
WA_P0706_STR-FLAG1 sy-vline 
WA_P0706_STR-FLAG2 sy-vline 
WA_P0706_STR-FLAG3 sy-vline 
WA_P0706_STR-FLAG4 sy-vline 
WA_P0706_STR-RESE1 sy-vline 
WA_P0706_STR-RESE2 sy-vline 
WA_P0706_STR-GRPVL sy-vline 
WA_P0706_STR-COMP_PACK_PART sy-vline 
WA_P0706_STR-CURRENCY sy-vline 
WA_P0706_STR-EXCHANGE_RATE sy-vline 
WA_P0706_STR-EXCHANGE_DATE sy-vline 
WA_P0706_STR-COL_INDEX sy-vline 
WA_P0706_STR-COLI_DATE sy-vline 
WA_P0706_STR-CPI01 sy-vline 
WA_P0706_STR-AMOUNT01 sy-vline 
WA_P0706_STR-CURRENCY01 sy-vline 
WA_P0706_STR-FREQ01 sy-vline 
WA_P0706_STR-PAY_TYPE01 sy-vline 
WA_P0706_STR-CPI_TYPE01 sy-vline 
WA_P0706_STR-BCPI01 sy-vline 
WA_P0706_STR-PRCNT01 sy-vline 
WA_P0706_STR-TAXBLE01 sy-vline 
WA_P0706_STR-OVRTFL01 sy-vline 
WA_P0706_STR-OVRTMET01 sy-vline 
WA_P0706_STR-CPI02 sy-vline 
WA_P0706_STR-AMOUNT02 sy-vline 
WA_P0706_STR-CURRENCY02 sy-vline 
WA_P0706_STR-FREQ02 sy-vline 
WA_P0706_STR-PAY_TYPE02 sy-vline 
WA_P0706_STR-CPI_TYPE02 sy-vline 
WA_P0706_STR-BCPI02 sy-vline 
WA_P0706_STR-PRCNT02 sy-vline 
WA_P0706_STR-TAXBLE02 sy-vline 
WA_P0706_STR-OVRTFL02 sy-vline 
WA_P0706_STR-OVRTMET02 sy-vline 
WA_P0706_STR-CPI03 sy-vline 
WA_P0706_STR-AMOUNT03 sy-vline 
WA_P0706_STR-CURRENCY03 sy-vline 
WA_P0706_STR-FREQ03 sy-vline 
WA_P0706_STR-PAY_TYPE03 sy-vline 
WA_P0706_STR-CPI_TYPE03 sy-vline 
WA_P0706_STR-BCPI03 sy-vline 
WA_P0706_STR-PRCNT03 sy-vline 
WA_P0706_STR-TAXBLE03 sy-vline 
WA_P0706_STR-OVRTFL03 sy-vline 
WA_P0706_STR-OVRTMET03 sy-vline 
WA_P0706_STR-CPI04 sy-vline 
WA_P0706_STR-AMOUNT04 sy-vline 
WA_P0706_STR-CURRENCY04 sy-vline 
WA_P0706_STR-FREQ04 sy-vline 
WA_P0706_STR-PAY_TYPE04 sy-vline 
WA_P0706_STR-CPI_TYPE04 sy-vline 
WA_P0706_STR-BCPI04 sy-vline 
WA_P0706_STR-PRCNT04 sy-vline 
WA_P0706_STR-TAXBLE04 sy-vline 
WA_P0706_STR-OVRTFL04 sy-vline 
WA_P0706_STR-OVRTMET04 sy-vline 
WA_P0706_STR-CPI05 sy-vline 
WA_P0706_STR-AMOUNT05 sy-vline 
WA_P0706_STR-CURRENCY05 sy-vline 
WA_P0706_STR-FREQ05 sy-vline 
WA_P0706_STR-PAY_TYPE05 sy-vline 
WA_P0706_STR-CPI_TYPE05 sy-vline 
WA_P0706_STR-BCPI05 sy-vline 
WA_P0706_STR-PRCNT05 sy-vline 
WA_P0706_STR-TAXBLE05 sy-vline 
WA_P0706_STR-OVRTFL05 sy-vline 
WA_P0706_STR-OVRTMET05 sy-vline 
WA_P0706_STR-CPI06 sy-vline 
WA_P0706_STR-AMOUNT06 sy-vline 
WA_P0706_STR-CURRENCY06 sy-vline 
WA_P0706_STR-FREQ06 sy-vline 
WA_P0706_STR-PAY_TYPE06 sy-vline 
WA_P0706_STR-CPI_TYPE06 sy-vline 
WA_P0706_STR-BCPI06 sy-vline 
WA_P0706_STR-PRCNT06 sy-vline 
WA_P0706_STR-TAXBLE06 sy-vline 
WA_P0706_STR-OVRTFL06 sy-vline 
WA_P0706_STR-OVRTMET06 sy-vline 
WA_P0706_STR-CPI07 sy-vline 
WA_P0706_STR-AMOUNT07 sy-vline 
WA_P0706_STR-CURRENCY07 sy-vline 
WA_P0706_STR-FREQ07 sy-vline 
WA_P0706_STR-PAY_TYPE07 sy-vline 
WA_P0706_STR-CPI_TYPE07 sy-vline 
WA_P0706_STR-BCPI07 sy-vline 
WA_P0706_STR-PRCNT07 sy-vline 
WA_P0706_STR-TAXBLE07 sy-vline 
WA_P0706_STR-OVRTFL07 sy-vline 
WA_P0706_STR-OVRTMET07 sy-vline 
WA_P0706_STR-CPI08 sy-vline 
WA_P0706_STR-AMOUNT08 sy-vline 
WA_P0706_STR-CURRENCY08 sy-vline 
WA_P0706_STR-FREQ08 sy-vline 
WA_P0706_STR-PAY_TYPE08 sy-vline 
WA_P0706_STR-CPI_TYPE08 sy-vline 
WA_P0706_STR-BCPI08 sy-vline 
WA_P0706_STR-PRCNT08 sy-vline 
WA_P0706_STR-TAXBLE08 sy-vline 
WA_P0706_STR-OVRTFL08 sy-vline 
WA_P0706_STR-OVRTMET08 sy-vline 
WA_P0706_STR-CPI09 sy-vline 
WA_P0706_STR-AMOUNT09 sy-vline 
WA_P0706_STR-CURRENCY09 sy-vline 
WA_P0706_STR-FREQ09 sy-vline 
WA_P0706_STR-PAY_TYPE09 sy-vline 
WA_P0706_STR-CPI_TYPE09 sy-vline 
WA_P0706_STR-BCPI09 sy-vline 
WA_P0706_STR-PRCNT09 sy-vline 
WA_P0706_STR-TAXBLE09 sy-vline 
WA_P0706_STR-OVRTFL09 sy-vline 
WA_P0706_STR-OVRTMET09 sy-vline 
WA_P0706_STR-CPI10 sy-vline 
WA_P0706_STR-AMOUNT10 sy-vline 
WA_P0706_STR-CURRENCY10 sy-vline 
WA_P0706_STR-FREQ10 sy-vline 
WA_P0706_STR-PAY_TYPE10 sy-vline 
WA_P0706_STR-CPI_TYPE10 sy-vline 
WA_P0706_STR-BCPI10 sy-vline 
WA_P0706_STR-PRCNT10 sy-vline 
WA_P0706_STR-TAXBLE10 sy-vline 
WA_P0706_STR-OVRTFL10 sy-vline 
WA_P0706_STR-OVRTMET10 sy-vline 
WA_P0706_STR-CPI11 sy-vline 
WA_P0706_STR-AMOUNT11 sy-vline 
WA_P0706_STR-CURRENCY11 sy-vline 
WA_P0706_STR-FREQ11 sy-vline 
WA_P0706_STR-PAY_TYPE11 sy-vline 
WA_P0706_STR-CPI_TYPE11 sy-vline 
WA_P0706_STR-BCPI11 sy-vline 
WA_P0706_STR-PRCNT11 sy-vline 
WA_P0706_STR-TAXBLE11 sy-vline 
WA_P0706_STR-OVRTFL11 sy-vline 
WA_P0706_STR-OVRTMET11 sy-vline 
WA_P0706_STR-CPI12 sy-vline 
WA_P0706_STR-AMOUNT12 sy-vline 
WA_P0706_STR-CURRENCY12 sy-vline 
WA_P0706_STR-FREQ12 sy-vline 
WA_P0706_STR-PAY_TYPE12 sy-vline 
WA_P0706_STR-CPI_TYPE12 sy-vline 
WA_P0706_STR-BCPI12 sy-vline 
WA_P0706_STR-PRCNT12 sy-vline 
WA_P0706_STR-TAXBLE12 sy-vline 
WA_P0706_STR-OVRTFL12 sy-vline 
WA_P0706_STR-OVRTMET12 sy-vline 
WA_P0706_STR-CPI13 sy-vline 
WA_P0706_STR-AMOUNT13 sy-vline 
WA_P0706_STR-CURRENCY13 sy-vline 
WA_P0706_STR-FREQ13 sy-vline 
WA_P0706_STR-PAY_TYPE13 sy-vline 
WA_P0706_STR-CPI_TYPE13 sy-vline 
WA_P0706_STR-BCPI13 sy-vline 
WA_P0706_STR-PRCNT13 sy-vline 
WA_P0706_STR-TAXBLE13 sy-vline 
WA_P0706_STR-OVRTFL13 sy-vline 
WA_P0706_STR-OVRTMET13 sy-vline 
WA_P0706_STR-CPI14 sy-vline 
WA_P0706_STR-AMOUNT14 sy-vline 
WA_P0706_STR-CURRENCY14 sy-vline 
WA_P0706_STR-FREQ14 sy-vline 
WA_P0706_STR-PAY_TYPE14 sy-vline 
WA_P0706_STR-CPI_TYPE14 sy-vline 
WA_P0706_STR-BCPI14 sy-vline 
WA_P0706_STR-PRCNT14 sy-vline 
WA_P0706_STR-TAXBLE14 sy-vline 
WA_P0706_STR-OVRTFL14 sy-vline 
WA_P0706_STR-OVRTMET14 sy-vline 
WA_P0706_STR-CPI15 sy-vline 
WA_P0706_STR-AMOUNT15 sy-vline 
WA_P0706_STR-CURRENCY15 sy-vline 
WA_P0706_STR-FREQ15 sy-vline 
WA_P0706_STR-PAY_TYPE15 sy-vline 
WA_P0706_STR-CPI_TYPE15 sy-vline 
WA_P0706_STR-BCPI15 sy-vline 
WA_P0706_STR-PRCNT15 sy-vline 
WA_P0706_STR-TAXBLE15 sy-vline 
WA_P0706_STR-OVRTFL15 sy-vline 
WA_P0706_STR-OVRTMET15 sy-vline 
WA_P0706_STR-CPI16 sy-vline 
WA_P0706_STR-AMOUNT16 sy-vline 
WA_P0706_STR-CURRENCY16 sy-vline 
WA_P0706_STR-FREQ16 sy-vline 
WA_P0706_STR-PAY_TYPE16 sy-vline 
WA_P0706_STR-CPI_TYPE16 sy-vline 
WA_P0706_STR-BCPI16 sy-vline 
WA_P0706_STR-PRCNT16 sy-vline 
WA_P0706_STR-TAXBLE16 sy-vline 
WA_P0706_STR-OVRTFL16 sy-vline 
WA_P0706_STR-OVRTMET16 sy-vline 
WA_P0706_STR-CPI17 sy-vline 
WA_P0706_STR-AMOUNT17 sy-vline 
WA_P0706_STR-CURRENCY17 sy-vline 
WA_P0706_STR-FREQ17 sy-vline 
WA_P0706_STR-PAY_TYPE17 sy-vline 
WA_P0706_STR-CPI_TYPE17 sy-vline 
WA_P0706_STR-BCPI17 sy-vline 
WA_P0706_STR-PRCNT17 sy-vline 
WA_P0706_STR-TAXBLE17 sy-vline 
WA_P0706_STR-OVRTFL17 sy-vline 
WA_P0706_STR-OVRTMET17 sy-vline 
WA_P0706_STR-CPI18 sy-vline 
WA_P0706_STR-AMOUNT18 sy-vline 
WA_P0706_STR-CURRENCY18 sy-vline 
WA_P0706_STR-FREQ18 sy-vline 
WA_P0706_STR-PAY_TYPE18 sy-vline 
WA_P0706_STR-CPI_TYPE18 sy-vline 
WA_P0706_STR-BCPI18 sy-vline 
WA_P0706_STR-PRCNT18 sy-vline 
WA_P0706_STR-TAXBLE18 sy-vline 
WA_P0706_STR-OVRTFL18 sy-vline 
WA_P0706_STR-OVRTMET18 sy-vline 
WA_P0706_STR-CPI19 sy-vline 
WA_P0706_STR-AMOUNT19 sy-vline 
WA_P0706_STR-CURRENCY19 sy-vline 
WA_P0706_STR-FREQ19 sy-vline 
WA_P0706_STR-PAY_TYPE19 sy-vline 
WA_P0706_STR-CPI_TYPE19 sy-vline 
WA_P0706_STR-BCPI19 sy-vline 
WA_P0706_STR-PRCNT19 sy-vline 
WA_P0706_STR-TAXBLE19 sy-vline 
WA_P0706_STR-OVRTFL19 sy-vline 
WA_P0706_STR-OVRTMET19 sy-vline 
WA_P0706_STR-CPI20 sy-vline 
WA_P0706_STR-AMOUNT20 sy-vline 
WA_P0706_STR-CURRENCY20 sy-vline 
WA_P0706_STR-FREQ20 sy-vline 
WA_P0706_STR-PAY_TYPE20 sy-vline 
WA_P0706_STR-CPI_TYPE20 sy-vline 
WA_P0706_STR-BCPI20 sy-vline 
WA_P0706_STR-PRCNT20 sy-vline 
WA_P0706_STR-TAXBLE20 sy-vline 
WA_P0706_STR-OVRTFL20 sy-vline 
WA_P0706_STR-OVRTMET20 sy-vline 
WA_P0706_STR-SYSTEM_DATE sy-vline 
WA_P0706_STR-SYSTEM_TIME sy-vline 
WA_P0706_STR-USER_DATE sy-vline 
WA_P0706_STR-USER_TIME sy-vline 
WA_P0706_STR-OVR_COLI sy-vline 
WA_P0706_STR-OVR_COLDA sy-vline 
WA_P0706_STR-OVR_EXCRA sy-vline 
WA_P0706_STR-OVR_EXCDA sy-vline 
WA_P0706_STR-ACTIVATION_DATE sy-vline 
WA_P0706_STR-STATUS sy-vline 
WA_P0706_STR-FACTOR01 sy-vline 
WA_P0706_STR-FACTOR02 sy-vline 
WA_P0706_STR-FACTOR03 sy-vline 
WA_P0706_STR-FACTOR04 sy-vline 
WA_P0706_STR-FACTOR05 sy-vline 
WA_P0706_STR-FACTOR06 sy-vline 
WA_P0706_STR-FACTOR07 sy-vline 
WA_P0706_STR-FACTOR08 sy-vline 
WA_P0706_STR-FACTOR09 sy-vline 
WA_P0706_STR-FACTOR10 sy-vline 
WA_P0706_STR-FACTOR11 sy-vline 
WA_P0706_STR-FACTOR12 sy-vline 
WA_P0706_STR-FACTOR13 sy-vline 
WA_P0706_STR-FACTOR14 sy-vline 
WA_P0706_STR-FACTOR15 sy-vline 
WA_P0706_STR-FACTOR16 sy-vline 
WA_P0706_STR-FACTOR17 sy-vline 
WA_P0706_STR-FACTOR18 sy-vline 
WA_P0706_STR-FACTOR19 sy-vline 
WA_P0706_STR-FACTOR20 sy-vline      INTO ld_text SEPARATED BY SPACE.

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