ABAP Select data from SAP table VVSC_PPLAN_SINGLE_STR_VVSCPOS 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 VVSC_PPLAN_SINGLE_STR_VVSCPOS 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 VVSC_PPLAN_SINGLE_STR_VVSCPOS. 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 VVSC_PPLAN_SINGLE_STR_VVSCPOS 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_VVSC_PPLAN_SINGLE_STR_VVSCPOS TYPE STANDARD TABLE OF VVSC_PPLAN_SINGLE_STR_VVSCPOS,
      WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS TYPE VVSC_PPLAN_SINGLE_STR_VVSCPOS,
      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: <VVSC_PPLAN_SINGLE_STR_VVSCPOS> TYPE VVSC_PPLAN_SINGLE_STR_VVSCPOS.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM VVSC_PPLAN_SINGLE_STR_VVSCPOS
*  INTO TABLE @DATA(IT_VVSC_PPLAN_SINGLE_STR_VVSCPOS2).
*--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_VVSC_PPLAN_SINGLE_STR_VVSCPOS INDEX 1 INTO DATA(WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<VVSC_PPLAN_SINGLE_STR_VVSCPOS>-WA_VVSCPOS = 1.
<VVSC_PPLAN_SINGLE_STR_VVSCPOS>-MANDT = 1.
<VVSC_PPLAN_SINGLE_STR_VVSCPOS>-GPART = 1.
<VVSC_PPLAN_SINGLE_STR_VVSCPOS>-VTREF = 1.
<VVSC_PPLAN_SINGLE_STR_VVSCPOS>-POSNR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-SCPOSNR, sy-vline,
  WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-BLTYP, sy-vline,
  WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-STATPOST, sy-vline,
  WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-ARCHI, sy-vline,
  WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-XLOCK, sy-vline,
  WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-PSNGL, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS 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_VVSC_PPLAN_SINGLE_STR_VVSCPOS 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_VVSC_PPLAN_SINGLE_STR_VVSCPOS INTO WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS.


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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit GJAHR, internal->external for field BUDGETYEAR
CALL FUNCTION 'CONVERSION_EXIT_GJAHR_OUTPUT'
  EXPORTING
    input =                      WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-BUDGETYEAR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-BUDGETYEAR.
WRITE:/ 'New Value:', ld_input.

*Conversion exit EXCRT, internal->external for field KURSF
CALL FUNCTION 'CONVERSION_EXIT_EXCRT_OUTPUT'
  EXPORTING
    input =                      WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-KURSF
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS-KURSF.
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_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR, 
WA_VVSCPOS TYPE STRING,
MANDT TYPE STRING,
GPART TYPE STRING,
VTREF TYPE STRING,
POSNR TYPE STRING,
SCPOSNR TYPE STRING,
BLTYP TYPE STRING,
STATPOST TYPE STRING,
ARCHI TYPE STRING,
XLOCK TYPE STRING,
PSNGL TYPE STRING,
PMTFR TYPE STRING,
PMTTO TYPE STRING,
RISKFR TYPE STRING,
RISKTO TYPE STRING,
PERFR TYPE STRING,
PMEND TYPE STRING,
PMEND_TIME TYPE STRING,
RENEW TYPE STRING,
RNEWX TYPE STRING,
RNEWD TYPE STRING,
RENEW_EXEC TYPE STRING,
CCODE TYPE STRING,
OPCCODE TYPE STRING,
GSBER TYPE STRING,
OPGSBER TYPE STRING,
PRGRP TYPE STRING,
SEGMENT TYPE STRING,
VSARL_VX TYPE STRING,
INSTAXS TYPE STRING,
TXPOS TYPE STRING,
AMOUNT_TOTAL TYPE STRING,
AMOUNT_INST TYPE STRING,
ATFRD TYPE STRING,
ATFRD_TIME TYPE STRING,
AMOUNT_DIFF TYPE STRING,
AMOUNT_TRANS TYPE STRING,
ENDTYPE TYPE STRING,
AMOUNT_NEED TYPE STRING,
AMOUNT_END TYPE STRING,
CHARGE_NEED TYPE STRING,
GLAET_AMT TYPE STRING,
CURR TYPE STRING,
PAYMENTFR TYPE STRING,
PAYMENTTO TYPE STRING,
CRDATE TYPE STRING,
CRTIME TYPE STRING,
CRUSER TYPE STRING,
CHDATE TYPE STRING,
CHTIME TYPE STRING,
CHUSER TYPE STRING,
POKEY TYPE STRING,
PKEY TYPE STRING,
PKEYFD TYPE STRING,
HVORG TYPE STRING,
TVORG TYPE STRING,
OPHVORG TYPE STRING,
OPTVORG TYPE STRING,
S_HKONT TYPE STRING,
H_HKONT TYPE STRING,
PAOBJNR TYPE STRING,
VBUND TYPE STRING,
KONTT TYPE STRING,
KONTL TYPE STRING,
BLART TYPE STRING,
VTRE2 TYPE STRING,
VTRE3 TYPE STRING,
XREVE TYPE STRING,
XDIST TYPE STRING,
BUGRD TYPE STRING,
PNTYP TYPE STRING,
XDERE TYPE STRING,
AMOUNT_DERE TYPE STRING,
VGPART2 TYPE STRING,
VGPART3 TYPE STRING,
GSFNR TYPE STRING,
BELNR TYPE STRING,
PEROFF TYPE STRING,
VALUT TYPE STRING,
PRCTR TYPE STRING,
KOSTL TYPE STRING,
AUFNR TYPE STRING,
LDGRP TYPE STRING,
PYGRP TYPE STRING,
PDTYP TYPE STRING,
GRKEY TYPE STRING,
XBEENDET TYPE STRING,
CFSET TYPE STRING,
CFPPC TYPE STRING,
CFAC TYPE STRING,
CFPE TYPE STRING,
FDDATE TYPE STRING,
FDDATE_FROM TYPE STRING,
FDDATE_TO TYPE STRING,
SCFDGRP TYPE STRING,
SCFDZTG TYPE STRING,
VOPBEL TYPE STRING,
MWSKZ TYPE STRING,
QSSKZ TYPE STRING,
STRKZ TYPE STRING,
OPKONTT TYPE STRING,
OPKONTL TYPE STRING,
STRNETTO TYPE STRING,
KTOSL TYPE STRING,
TXT TYPE STRING,
ORIGIN TYPE STRING,
MPPLAN TYPE STRING,
XEIBH_KO TYPE STRING,
XEIPH_OPK TYPE STRING,
HZUON TYPE STRING,
SGTXT TYPE STRING,
XEIPH_OP TYPE STRING,
FINRE TYPE STRING,
COINS_CODE TYPE STRING,
COINS_CAT TYPE STRING,
AWSYS TYPE STRING,
AWTYP TYPE STRING,
AWKEY TYPE STRING,
VERSION TYPE STRING,
EMGPA TYPE STRING,
EMBVT TYPE STRING,
EMADR TYPE STRING,
EMCCID TYPE STRING,
PYMET TYPE STRING,
PYBUK TYPE STRING,
FDGRP TYPE STRING,
FDZTG TYPE STRING,
FAEDS TYPE STRING,
SKTPZ TYPE STRING,
FAEDN TYPE STRING,
IKEY TYPE STRING,
BUDAT TYPE STRING,
STUDT TYPE STRING,
BLDAT TYPE STRING,
DUN_REASON TYPE STRING,
DUN_REASON_DAYS TYPE STRING,
PAY_REASON TYPE STRING,
PAY_REASON_DAYS TYPE STRING,
CLR_REASON TYPE STRING,
CLR_REASON_DAYS TYPE STRING,
INT_REASON TYPE STRING,
INT_REASON_DAYS TYPE STRING,
REFCLAIM TYPE STRING,
WWERT TYPE STRING,
MNDID TYPE STRING,
FMTYP TYPE STRING,
ORIGFIKRS TYPE STRING,
FIPEX TYPE STRING,
FISTL TYPE STRING,
FONDS TYPE STRING,
FKBER TYPE STRING,
MEASURE TYPE STRING,
GRANT_NBR TYPE STRING,
BUDGETYEAR TYPE STRING,
BUDGET_PD TYPE STRING,
DUN_REASON_FDATE TYPE STRING,
DUN_REASON_TDATE TYPE STRING,
PAY_REASON_FDATE TYPE STRING,
PAY_REASON_TDATE TYPE STRING,
CLR_REASON_FDATE TYPE STRING,
CLR_REASON_TDATE TYPE STRING,
INT_REASON_FDATE TYPE STRING,
INT_REASON_TDATE TYPE STRING,
KSCHL TYPE STRING,
TAXAM TYPE STRING,
STPRZ TYPE STRING,
SBASW TYPE STRING,
XETAX TYPE STRING,
BETRH TYPE STRING,
KURSF TYPE STRING,
KTOSL_TAX TYPE STRING,
BENT1 TYPE STRING,
ISSRB TYPE STRING,
WA_POPVORGTXT TYPE STRING,
HVORG_TXT TYPE STRING,
TVORG_TXT TYPE STRING,
WA_POPKVORGTX TYPE STRING,
HVORG_TXT TYPE STRING,
TVORG_TXT TYPE STRING,END OF T_EKKO_STR.
DATA: WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_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_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-WA_VVSCPOS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-MANDT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-GPART sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VTREF sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-POSNR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-SCPOSNR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BLTYP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-STATPOST sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-ARCHI sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-XLOCK sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PSNGL sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PMTFR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PMTTO sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-RISKFR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-RISKTO sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PERFR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PMEND sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PMEND_TIME sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-RENEW sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-RNEWX sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-RNEWD sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-RENEW_EXEC sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CCODE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-OPCCODE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-GSBER sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-OPGSBER sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PRGRP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-SEGMENT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VSARL_VX sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-INSTAXS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-TXPOS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AMOUNT_TOTAL sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AMOUNT_INST sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-ATFRD sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-ATFRD_TIME sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AMOUNT_DIFF sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AMOUNT_TRANS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-ENDTYPE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AMOUNT_NEED sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AMOUNT_END sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CHARGE_NEED sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-GLAET_AMT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CURR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PAYMENTFR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PAYMENTTO sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CRDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CRTIME sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CRUSER sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CHDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CHTIME sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CHUSER sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-POKEY sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PKEY sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PKEYFD sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-HVORG sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-TVORG sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-OPHVORG sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-OPTVORG sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-S_HKONT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-H_HKONT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PAOBJNR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VBUND sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-KONTT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-KONTL sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BLART sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VTRE2 sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VTRE3 sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-XREVE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-XDIST sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BUGRD sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PNTYP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-XDERE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AMOUNT_DERE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VGPART2 sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VGPART3 sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-GSFNR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BELNR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PEROFF sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VALUT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PRCTR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-KOSTL sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AUFNR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-LDGRP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PYGRP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PDTYP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-GRKEY sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-XBEENDET sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CFSET sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CFPPC sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CFAC sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CFPE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FDDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FDDATE_FROM sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FDDATE_TO sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-SCFDGRP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-SCFDZTG sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VOPBEL sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-MWSKZ sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-QSSKZ sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-STRKZ sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-OPKONTT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-OPKONTL sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-STRNETTO sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-KTOSL sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-TXT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-ORIGIN sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-MPPLAN sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-XEIBH_KO sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-XEIPH_OPK sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-HZUON sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-SGTXT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-XEIPH_OP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FINRE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-COINS_CODE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-COINS_CAT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AWSYS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AWTYP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-AWKEY sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-VERSION sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-EMGPA sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-EMBVT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-EMADR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-EMCCID sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PYMET sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PYBUK sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FDGRP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FDZTG sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FAEDS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-SKTPZ sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FAEDN sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-IKEY sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BUDAT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-STUDT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BLDAT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-DUN_REASON sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-DUN_REASON_DAYS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PAY_REASON sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PAY_REASON_DAYS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CLR_REASON sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CLR_REASON_DAYS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-INT_REASON sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-INT_REASON_DAYS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-REFCLAIM sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-WWERT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-MNDID sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FMTYP sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-ORIGFIKRS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FIPEX sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FISTL sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FONDS sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-FKBER sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-MEASURE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-GRANT_NBR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BUDGETYEAR sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BUDGET_PD sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-DUN_REASON_FDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-DUN_REASON_TDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PAY_REASON_FDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-PAY_REASON_TDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CLR_REASON_FDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-CLR_REASON_TDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-INT_REASON_FDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-INT_REASON_TDATE sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-KSCHL sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-TAXAM sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-STPRZ sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-SBASW sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-XETAX sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BETRH sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-KURSF sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-KTOSL_TAX sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-BENT1 sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-ISSRB sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-WA_POPVORGTXT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-HVORG_TXT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-TVORG_TXT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-WA_POPKVORGTX sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-HVORG_TXT sy-vline 
WA_VVSC_PPLAN_SINGLE_STR_VVSCPOS_STR-TVORG_TXT sy-vline      INTO ld_text SEPARATED BY SPACE.

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