ABAP Select data from SAP table UCD_SX_ROLE 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 UCD_SX_ROLE 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 UCD_SX_ROLE. 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 UCD_SX_ROLE 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_UCD_SX_ROLE TYPE STANDARD TABLE OF UCD_SX_ROLE,
      WA_UCD_SX_ROLE TYPE UCD_SX_ROLE,
      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: <UCD_SX_ROLE> TYPE UCD_SX_ROLE.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM UCD_SX_ROLE
*  INTO TABLE @DATA(IT_UCD_SX_ROLE2).
*--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_UCD_SX_ROLE INDEX 1 INTO DATA(WA_UCD_SX_ROLE2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<UCD_SX_ROLE>-TOTALS = 1.
<UCD_SX_ROLE>-TIME = 1.
<UCD_SX_ROLE>-SUBACCNT = 1.
<UCD_SX_ROLE>-VERSION = 1.
<UCD_SX_ROLE>-FISCYEAR = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_UCD_SX_ROLE-FISCPERIOD, sy-vline,
  WA_UCD_SX_ROLE-RESTAT, sy-vline,
  WA_UCD_SX_ROLE-REPUNIT, sy-vline,
  WA_UCD_SX_ROLE-REPGROUP, sy-vline,
  WA_UCD_SX_ROLE-DOCTYPE, sy-vline,
  WA_UCD_SX_ROLE-PLEVEL, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_UCD_SX_ROLE 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_UCD_SX_ROLE 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_UCD_SX_ROLE INTO WA_UCD_SX_ROLE.


*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.
ENDFORM. 

*&---------------------------------------------------------------------*
*& Form process_as_string_field_values
*&---------------------------------------------------------------------*
FORM process_as_string_field_values CHANGING p_EKKO LIKE wa_EKKO.

TYPES: BEGIN OF T_UCD_SX_ROLE_STR, 
TOTALS TYPE STRING,
TIME TYPE STRING,
SUBACCNT TYPE STRING,
VERSION TYPE STRING,
FISCYEAR TYPE STRING,
FISCPERIOD TYPE STRING,
RESTAT TYPE STRING,
REPUNIT TYPE STRING,
REPGROUP TYPE STRING,
DOCTYPE TYPE STRING,
PLEVEL TYPE STRING,
DIDIVINCEL TYPE STRING,
CTFLG TYPE STRING,
ITEM TYPE STRING,
G_SUBACCNT TYPE STRING,
PARTNER TYPE STRING,
TX_TYPE_SO TYPE STRING,
TX_TYPE TYPE STRING,
TX_TYPEBCF TYPE STRING,
TX_TYPEACQ TYPE STRING,
TX_TYPEAOC TYPE STRING,
TX_TYPEDIV TYPE STRING,
TX_TYPEDOC TYPE STRING,
TX_TYPEMER TYPE STRING,
ACQYEAR TYPE STRING,
ACQPERIOD TYPE STRING,
QUKEY TYPE STRING,
TCKEY TYPE STRING,
LCKEY TYPE STRING,
ALLOC_CHAR TYPE STRING,
INVESTEE TYPE STRING,
INVESTOR TYPE STRING,
PRODGROUP TYPE STRING,
ASSETLIAB TYPE STRING,
ASSETRET TYPE STRING,
ASSETACQ TYPE STRING,
ASSETDOC TYPE STRING,
ASSET_CVA TYPE STRING,
ASSET_IPA TYPE STRING,
ALMU TYPE STRING,
IPAAC TYPE STRING,
REFYEAR TYPE STRING,
REFPERIOD TYPE STRING,
REPMODE TYPE STRING,
TIMEMODE TYPE STRING,
GCKEY TYPE STRING,
GCVAL TYPE STRING,
LCVAL TYPE STRING,
TCVAL TYPE STRING,
QUVAL TYPE STRING,
HRY TYPE STRING,
NODENAME TYPE STRING,
HRYNAME TYPE STRING,
HRYVERSION TYPE STRING,
SEQUENCE TYPE STRING,
DOCNR TYPE STRING,
DOCLN TYPE STRING,
RVSDOCNR TYPE STRING,
RVSYEAR TYPE STRING,
RVSPERIOD TYPE STRING,
ORNDOCNR TYPE STRING,
ORNYEAR TYPE STRING,
ORNPERIOD TYPE STRING,
INVDOCNR TYPE STRING,
INVYEAR TYPE STRING,
INVPERIOD TYPE STRING,
ORIDOCNR TYPE STRING,
ORIYEAR TYPE STRING,
ORIPERIOD TYPE STRING,
REFDOCNR TYPE STRING,
DOCAUTO TYPE STRING,
DOCDTAXSUP TYPE STRING,
DOCDCINV TYPE STRING,
DOCTEXT TYPE STRING,
DOCDATE TYPE STRING,
DOCTIME TYPE STRING,
DOCUSER TYPE STRING,
LCVALK0 TYPE STRING,
LCVALK1 TYPE STRING,
LCVALAF TYPE STRING,
LCVALAP TYPE STRING,
LCVALDP TYPE STRING,
LCVALRP TYPE STRING,
LCVALBY TYPE STRING,
LCVALBG TYPE STRING,
LCVALDN TYPE STRING,
LCVALDE TYPE STRING,
LCVALWU TYPE STRING,
LCVALRA TYPE STRING,
LCVALRD TYPE STRING,
LCVALDA TYPE STRING,
LCVALN1 TYPE STRING,
LCVALV1 TYPE STRING,
LCVALDD TYPE STRING,
LCVALD0 TYPE STRING,
LCVALD1 TYPE STRING,
LCVALD2 TYPE STRING,
LCVALDI TYPE STRING,
LCVALDJ TYPE STRING,
LCVALEN TYPE STRING,
LCVAP TYPE STRING,
LCVBG TYPE STRING,
LCVDN TYPE STRING,
LCVDE TYPE STRING,
LCVWU TYPE STRING,
LCVEN TYPE STRING,
GCVALK0 TYPE STRING,
GCVALK1 TYPE STRING,
GCVALK2 TYPE STRING,
GCVALK3 TYPE STRING,
GCVALK4 TYPE STRING,
GCVALAF TYPE STRING,
GCVALAP TYPE STRING,
GCVALL3 TYPE STRING,
GCVALL4 TYPE STRING,
GCVALM1 TYPE STRING,
GCVALM2 TYPE STRING,
GCVALM3 TYPE STRING,
GCVALM4 TYPE STRING,
GCVALDP TYPE STRING,
GCVALRP TYPE STRING,
GCVALBY TYPE STRING,
GCVALBG TYPE STRING,
GCVALDN TYPE STRING,
GCVALDE TYPE STRING,
GCVALWU TYPE STRING,
GCVALRA TYPE STRING,
GCVALRD TYPE STRING,
GCVALDA TYPE STRING,
GCVALN1 TYPE STRING,
GCVALN2 TYPE STRING,
GCVALN3 TYPE STRING,
GCVALN4 TYPE STRING,
GCVALV1 TYPE STRING,
GCVALV2 TYPE STRING,
GCVALV3 TYPE STRING,
GCVALV4 TYPE STRING,
GCVALDD TYPE STRING,
GCVALD0 TYPE STRING,
GCVALD1 TYPE STRING,
GCVALD2 TYPE STRING,
GCVALD3 TYPE STRING,
GCVALD4 TYPE STRING,
GCVALEN TYPE STRING,
GCVALNP TYPE STRING,
GCVALDI TYPE STRING,
GCVALDJ TYPE STRING,
GCVALCP TYPE STRING,
GCVALCI TYPE STRING,
GCVALCJ TYPE STRING,
GCVALCA TYPE STRING,
LCVANORMAL TYPE STRING,
LCVANOLOSS TYPE STRING,
LCINCCOST TYPE STRING,
GCVANORMAL TYPE STRING,
GCVANOLOSS TYPE STRING,
GCINCCOST TYPE STRING,
PCNTINCCST TYPE STRING,
PCNTMARKUP TYPE STRING,
PCNTMARGIN TYPE STRING,
PCNTDSTCST TYPE STRING,
LCCOGMUNIT TYPE STRING,
PCNTCOGM TYPE STRING,
PCNTSHARE TYPE STRING,
GCINCCSTRU TYPE STRING,
GCINCCSTAU TYPE STRING,
GCRVN TYPE STRING,
GCCOGS TYPE STRING,
COIAC TYPE STRING,
COINR TYPE STRING,
DTEQI TYPE STRING,
COIAC_TRIG TYPE STRING,
COINR_TRIG TYPE STRING,
COINR_REF TYPE STRING,
COITOTOACT TYPE STRING,
COIINTPACT TYPE STRING,
COIPRESGW TYPE STRING,
COIMEMGW TYPE STRING,
COIREDGW TYPE STRING,
COIFUT TYPE STRING,
COIACSORT TYPE STRING,
BEGYEAR TYPE STRING,
BEGPERIOD TYPE STRING,
DURYEAR TYPE STRING,
DURPERIOD TYPE STRING,
COINEGGW TYPE STRING,
COIMANGW TYPE STRING,
COIPUGW TYPE STRING,
COIPROCGW TYPE STRING,
COIOFFSGW TYPE STRING,
COILCGW TYPE STRING,
PCNTINV1 TYPE STRING,
PCNTINV2 TYPE STRING,
PCNTINV3 TYPE STRING,
PCNTINV4 TYPE STRING,
PCNTINV5 TYPE STRING,
LCKEYIE TYPE STRING,
LCVALIE TYPE STRING,
ORGCHANGE TYPE STRING,
ORGCHANGE2 TYPE STRING,
ORGCHLOGIC TYPE STRING,
RETBG TYPE STRING,
IPATRTYPE TYPE STRING,
IPADAU TYPE STRING,
IPALVP TYPE STRING,
INVENTITEM TYPE STRING,
DECUM TYPE STRING,
QUERY TYPE STRING,
LOGSYS TYPE STRING,
STATUS TYPE STRING,
STATERROR TYPE STRING,
STATWARN TYPE STRING,
STATCOUNT TYPE STRING,
STATWEIGHT TYPE STRING,
DOCCAT TYPE STRING,
DOCNAME TYPE STRING,
WFWORKITEM TYPE STRING,
WFSTATUS TYPE STRING,
WFAGENTAPP TYPE STRING,
REFYRDTAX TYPE STRING,
REFPERDTAX TYPE STRING,
CTLCHANGE TYPE STRING,
COIDECPGW TYPE STRING,
COIFULLGW TYPE STRING,
GCVALDB TYPE STRING,
GCVALDR TYPE STRING,
GCVALAR TYPE STRING,
LCVALDR TYPE STRING,
LCVALDB TYPE STRING,
LCVALAR TYPE STRING,
COIAC_GWGN TYPE STRING,
COINR_GWGN TYPE STRING,
INVEE_GWGN TYPE STRING,
GCVALK5 TYPE STRING,
GCVALK6 TYPE STRING,
GCVALK7 TYPE STRING,
GCVALK8 TYPE STRING,
GCVALKX TYPE STRING,
GCVALL7 TYPE STRING,
GCVALL8 TYPE STRING,
GCVALM5 TYPE STRING,
GCVALM6 TYPE STRING,
GCVALM7 TYPE STRING,
GCVALM8 TYPE STRING,
LCVALKX TYPE STRING,
LCVALK5 TYPE STRING,
GCVALN6 TYPE STRING,
GCVALN7 TYPE STRING,
GCVALN8 TYPE STRING,
GCVALV7 TYPE STRING,
GCVALV8 TYPE STRING,
GCVALD7 TYPE STRING,
GCVALD8 TYPE STRING,
GCVALDL TYPE STRING,
GCVALDK TYPE STRING,
LCVALDL TYPE STRING,
LCVALDK TYPE STRING,END OF T_EKKO_STR.
DATA: WA_UCD_SX_ROLE_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_UCD_SX_ROLE_STR-TOTALS sy-vline 
WA_UCD_SX_ROLE_STR-TIME sy-vline 
WA_UCD_SX_ROLE_STR-SUBACCNT sy-vline 
WA_UCD_SX_ROLE_STR-VERSION sy-vline 
WA_UCD_SX_ROLE_STR-FISCYEAR sy-vline 
WA_UCD_SX_ROLE_STR-FISCPERIOD sy-vline 
WA_UCD_SX_ROLE_STR-RESTAT sy-vline 
WA_UCD_SX_ROLE_STR-REPUNIT sy-vline 
WA_UCD_SX_ROLE_STR-REPGROUP sy-vline 
WA_UCD_SX_ROLE_STR-DOCTYPE sy-vline 
WA_UCD_SX_ROLE_STR-PLEVEL sy-vline 
WA_UCD_SX_ROLE_STR-DIDIVINCEL sy-vline 
WA_UCD_SX_ROLE_STR-CTFLG sy-vline 
WA_UCD_SX_ROLE_STR-ITEM sy-vline 
WA_UCD_SX_ROLE_STR-G_SUBACCNT sy-vline 
WA_UCD_SX_ROLE_STR-PARTNER sy-vline 
WA_UCD_SX_ROLE_STR-TX_TYPE_SO sy-vline 
WA_UCD_SX_ROLE_STR-TX_TYPE sy-vline 
WA_UCD_SX_ROLE_STR-TX_TYPEBCF sy-vline 
WA_UCD_SX_ROLE_STR-TX_TYPEACQ sy-vline 
WA_UCD_SX_ROLE_STR-TX_TYPEAOC sy-vline 
WA_UCD_SX_ROLE_STR-TX_TYPEDIV sy-vline 
WA_UCD_SX_ROLE_STR-TX_TYPEDOC sy-vline 
WA_UCD_SX_ROLE_STR-TX_TYPEMER sy-vline 
WA_UCD_SX_ROLE_STR-ACQYEAR sy-vline 
WA_UCD_SX_ROLE_STR-ACQPERIOD sy-vline 
WA_UCD_SX_ROLE_STR-QUKEY sy-vline 
WA_UCD_SX_ROLE_STR-TCKEY sy-vline 
WA_UCD_SX_ROLE_STR-LCKEY sy-vline 
WA_UCD_SX_ROLE_STR-ALLOC_CHAR sy-vline 
WA_UCD_SX_ROLE_STR-INVESTEE sy-vline 
WA_UCD_SX_ROLE_STR-INVESTOR sy-vline 
WA_UCD_SX_ROLE_STR-PRODGROUP sy-vline 
WA_UCD_SX_ROLE_STR-ASSETLIAB sy-vline 
WA_UCD_SX_ROLE_STR-ASSETRET sy-vline 
WA_UCD_SX_ROLE_STR-ASSETACQ sy-vline 
WA_UCD_SX_ROLE_STR-ASSETDOC sy-vline 
WA_UCD_SX_ROLE_STR-ASSET_CVA sy-vline 
WA_UCD_SX_ROLE_STR-ASSET_IPA sy-vline 
WA_UCD_SX_ROLE_STR-ALMU sy-vline 
WA_UCD_SX_ROLE_STR-IPAAC sy-vline 
WA_UCD_SX_ROLE_STR-REFYEAR sy-vline 
WA_UCD_SX_ROLE_STR-REFPERIOD sy-vline 
WA_UCD_SX_ROLE_STR-REPMODE sy-vline 
WA_UCD_SX_ROLE_STR-TIMEMODE sy-vline 
WA_UCD_SX_ROLE_STR-GCKEY sy-vline 
WA_UCD_SX_ROLE_STR-GCVAL sy-vline 
WA_UCD_SX_ROLE_STR-LCVAL sy-vline 
WA_UCD_SX_ROLE_STR-TCVAL sy-vline 
WA_UCD_SX_ROLE_STR-QUVAL sy-vline 
WA_UCD_SX_ROLE_STR-HRY sy-vline 
WA_UCD_SX_ROLE_STR-NODENAME sy-vline 
WA_UCD_SX_ROLE_STR-HRYNAME sy-vline 
WA_UCD_SX_ROLE_STR-HRYVERSION sy-vline 
WA_UCD_SX_ROLE_STR-SEQUENCE sy-vline 
WA_UCD_SX_ROLE_STR-DOCNR sy-vline 
WA_UCD_SX_ROLE_STR-DOCLN sy-vline 
WA_UCD_SX_ROLE_STR-RVSDOCNR sy-vline 
WA_UCD_SX_ROLE_STR-RVSYEAR sy-vline 
WA_UCD_SX_ROLE_STR-RVSPERIOD sy-vline 
WA_UCD_SX_ROLE_STR-ORNDOCNR sy-vline 
WA_UCD_SX_ROLE_STR-ORNYEAR sy-vline 
WA_UCD_SX_ROLE_STR-ORNPERIOD sy-vline 
WA_UCD_SX_ROLE_STR-INVDOCNR sy-vline 
WA_UCD_SX_ROLE_STR-INVYEAR sy-vline 
WA_UCD_SX_ROLE_STR-INVPERIOD sy-vline 
WA_UCD_SX_ROLE_STR-ORIDOCNR sy-vline 
WA_UCD_SX_ROLE_STR-ORIYEAR sy-vline 
WA_UCD_SX_ROLE_STR-ORIPERIOD sy-vline 
WA_UCD_SX_ROLE_STR-REFDOCNR sy-vline 
WA_UCD_SX_ROLE_STR-DOCAUTO sy-vline 
WA_UCD_SX_ROLE_STR-DOCDTAXSUP sy-vline 
WA_UCD_SX_ROLE_STR-DOCDCINV sy-vline 
WA_UCD_SX_ROLE_STR-DOCTEXT sy-vline 
WA_UCD_SX_ROLE_STR-DOCDATE sy-vline 
WA_UCD_SX_ROLE_STR-DOCTIME sy-vline 
WA_UCD_SX_ROLE_STR-DOCUSER sy-vline 
WA_UCD_SX_ROLE_STR-LCVALK0 sy-vline 
WA_UCD_SX_ROLE_STR-LCVALK1 sy-vline 
WA_UCD_SX_ROLE_STR-LCVALAF sy-vline 
WA_UCD_SX_ROLE_STR-LCVALAP sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDP sy-vline 
WA_UCD_SX_ROLE_STR-LCVALRP sy-vline 
WA_UCD_SX_ROLE_STR-LCVALBY sy-vline 
WA_UCD_SX_ROLE_STR-LCVALBG sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDN sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDE sy-vline 
WA_UCD_SX_ROLE_STR-LCVALWU sy-vline 
WA_UCD_SX_ROLE_STR-LCVALRA sy-vline 
WA_UCD_SX_ROLE_STR-LCVALRD sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDA sy-vline 
WA_UCD_SX_ROLE_STR-LCVALN1 sy-vline 
WA_UCD_SX_ROLE_STR-LCVALV1 sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDD sy-vline 
WA_UCD_SX_ROLE_STR-LCVALD0 sy-vline 
WA_UCD_SX_ROLE_STR-LCVALD1 sy-vline 
WA_UCD_SX_ROLE_STR-LCVALD2 sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDI sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDJ sy-vline 
WA_UCD_SX_ROLE_STR-LCVALEN sy-vline 
WA_UCD_SX_ROLE_STR-LCVAP sy-vline 
WA_UCD_SX_ROLE_STR-LCVBG sy-vline 
WA_UCD_SX_ROLE_STR-LCVDN sy-vline 
WA_UCD_SX_ROLE_STR-LCVDE sy-vline 
WA_UCD_SX_ROLE_STR-LCVWU sy-vline 
WA_UCD_SX_ROLE_STR-LCVEN sy-vline 
WA_UCD_SX_ROLE_STR-GCVALK0 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALK1 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALK2 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALK3 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALK4 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALAF sy-vline 
WA_UCD_SX_ROLE_STR-GCVALAP sy-vline 
WA_UCD_SX_ROLE_STR-GCVALL3 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALL4 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALM1 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALM2 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALM3 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALM4 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDP sy-vline 
WA_UCD_SX_ROLE_STR-GCVALRP sy-vline 
WA_UCD_SX_ROLE_STR-GCVALBY sy-vline 
WA_UCD_SX_ROLE_STR-GCVALBG sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDN sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDE sy-vline 
WA_UCD_SX_ROLE_STR-GCVALWU sy-vline 
WA_UCD_SX_ROLE_STR-GCVALRA sy-vline 
WA_UCD_SX_ROLE_STR-GCVALRD sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDA sy-vline 
WA_UCD_SX_ROLE_STR-GCVALN1 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALN2 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALN3 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALN4 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALV1 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALV2 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALV3 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALV4 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDD sy-vline 
WA_UCD_SX_ROLE_STR-GCVALD0 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALD1 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALD2 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALD3 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALD4 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALEN sy-vline 
WA_UCD_SX_ROLE_STR-GCVALNP sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDI sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDJ sy-vline 
WA_UCD_SX_ROLE_STR-GCVALCP sy-vline 
WA_UCD_SX_ROLE_STR-GCVALCI sy-vline 
WA_UCD_SX_ROLE_STR-GCVALCJ sy-vline 
WA_UCD_SX_ROLE_STR-GCVALCA sy-vline 
WA_UCD_SX_ROLE_STR-LCVANORMAL sy-vline 
WA_UCD_SX_ROLE_STR-LCVANOLOSS sy-vline 
WA_UCD_SX_ROLE_STR-LCINCCOST sy-vline 
WA_UCD_SX_ROLE_STR-GCVANORMAL sy-vline 
WA_UCD_SX_ROLE_STR-GCVANOLOSS sy-vline 
WA_UCD_SX_ROLE_STR-GCINCCOST sy-vline 
WA_UCD_SX_ROLE_STR-PCNTINCCST sy-vline 
WA_UCD_SX_ROLE_STR-PCNTMARKUP sy-vline 
WA_UCD_SX_ROLE_STR-PCNTMARGIN sy-vline 
WA_UCD_SX_ROLE_STR-PCNTDSTCST sy-vline 
WA_UCD_SX_ROLE_STR-LCCOGMUNIT sy-vline 
WA_UCD_SX_ROLE_STR-PCNTCOGM sy-vline 
WA_UCD_SX_ROLE_STR-PCNTSHARE sy-vline 
WA_UCD_SX_ROLE_STR-GCINCCSTRU sy-vline 
WA_UCD_SX_ROLE_STR-GCINCCSTAU sy-vline 
WA_UCD_SX_ROLE_STR-GCRVN sy-vline 
WA_UCD_SX_ROLE_STR-GCCOGS sy-vline 
WA_UCD_SX_ROLE_STR-COIAC sy-vline 
WA_UCD_SX_ROLE_STR-COINR sy-vline 
WA_UCD_SX_ROLE_STR-DTEQI sy-vline 
WA_UCD_SX_ROLE_STR-COIAC_TRIG sy-vline 
WA_UCD_SX_ROLE_STR-COINR_TRIG sy-vline 
WA_UCD_SX_ROLE_STR-COINR_REF sy-vline 
WA_UCD_SX_ROLE_STR-COITOTOACT sy-vline 
WA_UCD_SX_ROLE_STR-COIINTPACT sy-vline 
WA_UCD_SX_ROLE_STR-COIPRESGW sy-vline 
WA_UCD_SX_ROLE_STR-COIMEMGW sy-vline 
WA_UCD_SX_ROLE_STR-COIREDGW sy-vline 
WA_UCD_SX_ROLE_STR-COIFUT sy-vline 
WA_UCD_SX_ROLE_STR-COIACSORT sy-vline 
WA_UCD_SX_ROLE_STR-BEGYEAR sy-vline 
WA_UCD_SX_ROLE_STR-BEGPERIOD sy-vline 
WA_UCD_SX_ROLE_STR-DURYEAR sy-vline 
WA_UCD_SX_ROLE_STR-DURPERIOD sy-vline 
WA_UCD_SX_ROLE_STR-COINEGGW sy-vline 
WA_UCD_SX_ROLE_STR-COIMANGW sy-vline 
WA_UCD_SX_ROLE_STR-COIPUGW sy-vline 
WA_UCD_SX_ROLE_STR-COIPROCGW sy-vline 
WA_UCD_SX_ROLE_STR-COIOFFSGW sy-vline 
WA_UCD_SX_ROLE_STR-COILCGW sy-vline 
WA_UCD_SX_ROLE_STR-PCNTINV1 sy-vline 
WA_UCD_SX_ROLE_STR-PCNTINV2 sy-vline 
WA_UCD_SX_ROLE_STR-PCNTINV3 sy-vline 
WA_UCD_SX_ROLE_STR-PCNTINV4 sy-vline 
WA_UCD_SX_ROLE_STR-PCNTINV5 sy-vline 
WA_UCD_SX_ROLE_STR-LCKEYIE sy-vline 
WA_UCD_SX_ROLE_STR-LCVALIE sy-vline 
WA_UCD_SX_ROLE_STR-ORGCHANGE sy-vline 
WA_UCD_SX_ROLE_STR-ORGCHANGE2 sy-vline 
WA_UCD_SX_ROLE_STR-ORGCHLOGIC sy-vline 
WA_UCD_SX_ROLE_STR-RETBG sy-vline 
WA_UCD_SX_ROLE_STR-IPATRTYPE sy-vline 
WA_UCD_SX_ROLE_STR-IPADAU sy-vline 
WA_UCD_SX_ROLE_STR-IPALVP sy-vline 
WA_UCD_SX_ROLE_STR-INVENTITEM sy-vline 
WA_UCD_SX_ROLE_STR-DECUM sy-vline 
WA_UCD_SX_ROLE_STR-QUERY sy-vline 
WA_UCD_SX_ROLE_STR-LOGSYS sy-vline 
WA_UCD_SX_ROLE_STR-STATUS sy-vline 
WA_UCD_SX_ROLE_STR-STATERROR sy-vline 
WA_UCD_SX_ROLE_STR-STATWARN sy-vline 
WA_UCD_SX_ROLE_STR-STATCOUNT sy-vline 
WA_UCD_SX_ROLE_STR-STATWEIGHT sy-vline 
WA_UCD_SX_ROLE_STR-DOCCAT sy-vline 
WA_UCD_SX_ROLE_STR-DOCNAME sy-vline 
WA_UCD_SX_ROLE_STR-WFWORKITEM sy-vline 
WA_UCD_SX_ROLE_STR-WFSTATUS sy-vline 
WA_UCD_SX_ROLE_STR-WFAGENTAPP sy-vline 
WA_UCD_SX_ROLE_STR-REFYRDTAX sy-vline 
WA_UCD_SX_ROLE_STR-REFPERDTAX sy-vline 
WA_UCD_SX_ROLE_STR-CTLCHANGE sy-vline 
WA_UCD_SX_ROLE_STR-COIDECPGW sy-vline 
WA_UCD_SX_ROLE_STR-COIFULLGW sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDB sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDR sy-vline 
WA_UCD_SX_ROLE_STR-GCVALAR sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDR sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDB sy-vline 
WA_UCD_SX_ROLE_STR-LCVALAR sy-vline 
WA_UCD_SX_ROLE_STR-COIAC_GWGN sy-vline 
WA_UCD_SX_ROLE_STR-COINR_GWGN sy-vline 
WA_UCD_SX_ROLE_STR-INVEE_GWGN sy-vline 
WA_UCD_SX_ROLE_STR-GCVALK5 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALK6 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALK7 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALK8 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALKX sy-vline 
WA_UCD_SX_ROLE_STR-GCVALL7 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALL8 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALM5 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALM6 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALM7 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALM8 sy-vline 
WA_UCD_SX_ROLE_STR-LCVALKX sy-vline 
WA_UCD_SX_ROLE_STR-LCVALK5 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALN6 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALN7 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALN8 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALV7 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALV8 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALD7 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALD8 sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDL sy-vline 
WA_UCD_SX_ROLE_STR-GCVALDK sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDL sy-vline 
WA_UCD_SX_ROLE_STR-LCVALDK sy-vline      INTO ld_text SEPARATED BY SPACE.

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