ABAP Select data from SAP table FC06SSCR 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 FC06SSCR 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 FC06SSCR. 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 FC06SSCR 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_FC06SSCR TYPE STANDARD TABLE OF FC06SSCR,
      WA_FC06SSCR TYPE FC06SSCR,
      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: <FC06SSCR> TYPE FC06SSCR.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM FC06SSCR
*  INTO TABLE @DATA(IT_FC06SSCR2).
*--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_FC06SSCR INDEX 1 INTO DATA(WA_FC06SSCR2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<FC06SSCR>-MANDT = 1.
<FC06SSCR>-DIMEN = 1.
<FC06SSCR>-ITCLG = 1.
<FC06SSCR>-ROLE_ID_GOODWILL_ACQ = 1.
<FC06SSCR>-ROLE_VAL_ID_GOODWILL_ACQ = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_FC06SSCR-GWAAQDI, sy-vline,
  WA_FC06SSCR-ROLE_ID_GOODWILL_OFA, sy-vline,
  WA_FC06SSCR-ROLE_VAL_ID_GOODWILL_OFA, sy-vline,
  WA_FC06SSCR-GWAOFFSDI, sy-vline,
  WA_FC06SSCR-GWASTATOFFS, sy-vline,
  WA_FC06SSCR-ROLE_ID_GOODWILL_DEP, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_FC06SSCR 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_FC06SSCR 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_FC06SSCR INTO WA_FC06SSCR.


*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 BFIMC, internal->external for field GWAAQDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWAAQDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWAAQDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWAOFFSDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWAOFFSDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWAOFFSDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWASTATOFFS
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWASTATOFFS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWASTATOFFS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWAAQCI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWAAQCI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWAAQCI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWAAMDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWAAMDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWAAMDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWAAMCI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWAAMCI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWAAMCI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWRAQDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWRAQDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWRAQDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWROFFSDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWROFFSDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWROFFSDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWRSTATOFFS
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWRSTATOFFS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWRSTATOFFS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWRAMDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWRAMDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWRAMDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWRAMCI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWRAMCI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWRAMCI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWRSTAT
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWRSTAT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWRSTAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWDAQDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWDAQDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWDAQDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWDOFFSDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWDOFFSDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWDOFFSDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWDSTATOFFS
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWDSTATOFFS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWDSTATOFFS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWDSTAT
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWDSTAT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWDSTAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGAAQDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGAAQDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGAAQDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGAOFFSDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGAOFFSDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGAOFFSDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGASTATOFFS
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGASTATOFFS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGASTATOFFS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGAAQCI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGAAQCI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGAAQCI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGAAMDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGAAMDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGAAMDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGAAMCI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGAAMCI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGAAMCI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGRAQDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGRAQDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGRAQDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGROFFSDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGROFFSDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGROFFSDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGRSTATOFFS
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGRSTATOFFS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGRSTATOFFS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGRAMDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGRAMDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGRAMDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGRAMCI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGRAMCI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGRAMCI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGRSTAT
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGRSTAT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGRSTAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGDAQCI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGDAQCI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGDAQCI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGDOFFSDI
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGDOFFSDI
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGDOFFSDI.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGDSTATOFFS
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGDSTATOFFS
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGDSTATOFFS.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGDSTAT
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGDSTAT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGDSTAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field GWALVAL
CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWALVAL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWALVAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field GWRLVAL
CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWRLVAL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWRLVAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field NGALVAL
CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGALVAL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGALVAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit AC172, internal->external for field NGRLVAL
CALL FUNCTION 'CONVERSION_EXIT_AC172_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGRLVAL
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGRLVAL.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWASTAT
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWASTAT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWASTAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field GWASTATCT
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-GWASTATCT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-GWASTATCT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGASTAT
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGASTAT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGASTAT.
WRITE:/ 'New Value:', ld_input.

*Conversion exit BFIMC, internal->external for field NGASTATCT
CALL FUNCTION 'CONVERSION_EXIT_BFIMC_OUTPUT'
  EXPORTING
    input =                      WA_FC06SSCR-NGASTATCT
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_FC06SSCR-NGASTATCT.
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_FC06SSCR_STR, 
MANDT TYPE STRING,
DIMEN TYPE STRING,
ITCLG TYPE STRING,
ROLE_ID_GOODWILL_ACQ TYPE STRING,
ROLE_VAL_ID_GOODWILL_ACQ TYPE STRING,
GWAAQDI TYPE STRING,
ROLE_ID_GOODWILL_OFA TYPE STRING,
ROLE_VAL_ID_GOODWILL_OFA TYPE STRING,
GWAOFFSDI TYPE STRING,
GWASTATOFFS TYPE STRING,
ROLE_ID_GOODWILL_DEP TYPE STRING,
ROLE_VAL_ID_GOODWILL_DEP TYPE STRING,
GWAAQCI TYPE STRING,
ROLE_ID_GOODWILL_PL TYPE STRING,
ROLE_VAL_ID_GOODWILL_PL TYPE STRING,
GWAAMDI TYPE STRING,
ROLE_ID_GOODWILL_WU TYPE STRING,
ROLE_VAL_ID_GOODWILL_WU TYPE STRING,
GWAAMCI TYPE STRING,
GWRAQDI TYPE STRING,
GWROFFSDI TYPE STRING,
GWRSTATOFFS TYPE STRING,
GWRAMDI TYPE STRING,
GWRAMCI TYPE STRING,
GWRSTAT TYPE STRING,
ROLE_ID_GOODWILL_ELI TYPE STRING,
ROLE_VAL_ID_GOODWILL_ELI TYPE STRING,
GWDAQDI TYPE STRING,
ROLE_ID_GOODWILL_OFE TYPE STRING,
ROLE_VAL_ID_GOODWILL_OFE TYPE STRING,
GWDOFFSDI TYPE STRING,
GWDSTATOFFS TYPE STRING,
GWDSTAT TYPE STRING,
ROLE_ID_BADWILL_ACQ TYPE STRING,
ROLE_VAL_ID_BADWILL_ACQ TYPE STRING,
NGAAQDI TYPE STRING,
ROLE_ID_BADWILL_OFA TYPE STRING,
ROLE_VAL_ID_BADWILL_OFA TYPE STRING,
NGAOFFSDI TYPE STRING,
NGASTATOFFS TYPE STRING,
ROLE_ID_BADWILL_DEP TYPE STRING,
ROLE_VAL_ID_BADWILL_DEP TYPE STRING,
NGAAQCI TYPE STRING,
ROLE_ID_BADWILL_PL TYPE STRING,
ROLE_VAL_ID_BADWILL_PL TYPE STRING,
NGAAMDI TYPE STRING,
ROLE_ID_BADWILL_WU TYPE STRING,
ROLE_VAL_ID_BADWILL_WU TYPE STRING,
NGAAMCI TYPE STRING,
NGRAQDI TYPE STRING,
NGROFFSDI TYPE STRING,
NGRSTATOFFS TYPE STRING,
NGRAMDI TYPE STRING,
NGRAMCI TYPE STRING,
NGRSTAT TYPE STRING,
ROLE_ID_BADWILL_ELI TYPE STRING,
ROLE_VAL_ID_BADWILL_ELI TYPE STRING,
NGDAQCI TYPE STRING,
ROLE_ID_BADWILL_OFE TYPE STRING,
ROLE_VAL_ID_BADWILL_OFE TYPE STRING,
NGDOFFSDI TYPE STRING,
NGDSTATOFFS TYPE STRING,
NGDSTAT TYPE STRING,
NINVFLG TYPE STRING,
NMINFLG TYPE STRING,
HRREV TYPE STRING,
HRSHA TYPE STRING,
HRSITYP TYPE STRING,
HRAQDSI TYPE STRING,
HRDPCSI TYPE STRING,
HRDPDSI TYPE STRING,
NHSITYP TYPE STRING,
NHAQCSI TYPE STRING,
NHDPDSI TYPE STRING,
NHDPCSI TYPE STRING,
GWAYR TYPE STRING,
GWAPE TYPE STRING,
GWABG TYPE STRING,
GWARFLG TYPE STRING,
GWALFLG TYPE STRING,
GWALVAL TYPE STRING,
GWALCUR TYPE STRING,
GWAMETH TYPE STRING,
GWRYR TYPE STRING,
GWRPE TYPE STRING,
GWRBG TYPE STRING,
GWRRFLG TYPE STRING,
GWRLFLG TYPE STRING,
GWRLVAL TYPE STRING,
GWRLCUR TYPE STRING,
GWRMETH TYPE STRING,
NGAYR TYPE STRING,
NGAPE TYPE STRING,
NGABG TYPE STRING,
NGARFLG TYPE STRING,
NGALFLG TYPE STRING,
NGALVAL TYPE STRING,
NGALCUR TYPE STRING,
NGAMETH TYPE STRING,
NGRYR TYPE STRING,
NGRPE TYPE STRING,
NGRBG TYPE STRING,
NGRRFLG TYPE STRING,
NGRLFLG TYPE STRING,
NGRLVAL TYPE STRING,
NGRLCUR TYPE STRING,
NGRMETH TYPE STRING,
GWAAQDT TYPE STRING,
GWAAQDS TYPE STRING,
GWAAQCTPYS TYPE STRING,
GWAAQCTCYS TYPE STRING,
GWAOFFSDT TYPE STRING,
GWAOFFSDS TYPE STRING,
GWAOFFSCS TYPE STRING,
GWAAQCT TYPE STRING,
GWADPCS TYPE STRING,
GWADPDS TYPE STRING,
GWADPCTPYS TYPE STRING,
GWADPCTCYS TYPE STRING,
GWAAMDT TYPE STRING,
GWAAMDS TYPE STRING,
GWAAMCT TYPE STRING,
GWAAMCS TYPE STRING,
GWASTAT TYPE STRING,
GWASTATCT TYPE STRING,
GWRAQDT TYPE STRING,
GWRAQDS TYPE STRING,
GWRAQCS TYPE STRING,
GWROFFSDT TYPE STRING,
GWROFFSDS TYPE STRING,
GWROFFSCS TYPE STRING,
GWRAMDT TYPE STRING,
GWRAMDS TYPE STRING,
GWRAMCT TYPE STRING,
GWRAMCS TYPE STRING,
GWDAQDT TYPE STRING,
GWDAQDS TYPE STRING,
GWDOFFSDT TYPE STRING,
GWDOFFSDS TYPE STRING,
GWDOFFSCS TYPE STRING,
NGAAQDT TYPE STRING,
NGAAQDS TYPE STRING,
NGAAMCTPYS TYPE STRING,
NGAAMCTCYS TYPE STRING,
NGAOFFSDT TYPE STRING,
NGAOFFSDS TYPE STRING,
NGAOFFSCS TYPE STRING,
NGAAQCT TYPE STRING,
NGADPCS TYPE STRING,
NGADPDS TYPE STRING,
NGADPCTPYS TYPE STRING,
NGADPCTCYS TYPE STRING,
NGAAMDT TYPE STRING,
NGAAMDS TYPE STRING,
NGAAMCT TYPE STRING,
NGAAMCS TYPE STRING,
NGASTAT TYPE STRING,
NGASTATCT TYPE STRING,
NGRAQDT TYPE STRING,
NGRAQDS TYPE STRING,
NGRAQCS TYPE STRING,
NGROFFSDT TYPE STRING,
NGROFFSDS TYPE STRING,
NGROFFSCS TYPE STRING,
NGRAMDT TYPE STRING,
NGRAMDS TYPE STRING,
NGRAMCT TYPE STRING,
NGRAMCS TYPE STRING,
NGDAQCT TYPE STRING,
NGDAQCS TYPE STRING,
NGDOFFSDT TYPE STRING,
NGDOFFSDS TYPE STRING,
NGDOFFSCS TYPE STRING,END OF T_EKKO_STR.
DATA: WA_FC06SSCR_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_FC06SSCR_STR-MANDT sy-vline 
WA_FC06SSCR_STR-DIMEN sy-vline 
WA_FC06SSCR_STR-ITCLG sy-vline 
WA_FC06SSCR_STR-ROLE_ID_GOODWILL_ACQ sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_GOODWILL_ACQ sy-vline 
WA_FC06SSCR_STR-GWAAQDI sy-vline 
WA_FC06SSCR_STR-ROLE_ID_GOODWILL_OFA sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_GOODWILL_OFA sy-vline 
WA_FC06SSCR_STR-GWAOFFSDI sy-vline 
WA_FC06SSCR_STR-GWASTATOFFS sy-vline 
WA_FC06SSCR_STR-ROLE_ID_GOODWILL_DEP sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_GOODWILL_DEP sy-vline 
WA_FC06SSCR_STR-GWAAQCI sy-vline 
WA_FC06SSCR_STR-ROLE_ID_GOODWILL_PL sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_GOODWILL_PL sy-vline 
WA_FC06SSCR_STR-GWAAMDI sy-vline 
WA_FC06SSCR_STR-ROLE_ID_GOODWILL_WU sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_GOODWILL_WU sy-vline 
WA_FC06SSCR_STR-GWAAMCI sy-vline 
WA_FC06SSCR_STR-GWRAQDI sy-vline 
WA_FC06SSCR_STR-GWROFFSDI sy-vline 
WA_FC06SSCR_STR-GWRSTATOFFS sy-vline 
WA_FC06SSCR_STR-GWRAMDI sy-vline 
WA_FC06SSCR_STR-GWRAMCI sy-vline 
WA_FC06SSCR_STR-GWRSTAT sy-vline 
WA_FC06SSCR_STR-ROLE_ID_GOODWILL_ELI sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_GOODWILL_ELI sy-vline 
WA_FC06SSCR_STR-GWDAQDI sy-vline 
WA_FC06SSCR_STR-ROLE_ID_GOODWILL_OFE sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_GOODWILL_OFE sy-vline 
WA_FC06SSCR_STR-GWDOFFSDI sy-vline 
WA_FC06SSCR_STR-GWDSTATOFFS sy-vline 
WA_FC06SSCR_STR-GWDSTAT sy-vline 
WA_FC06SSCR_STR-ROLE_ID_BADWILL_ACQ sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_BADWILL_ACQ sy-vline 
WA_FC06SSCR_STR-NGAAQDI sy-vline 
WA_FC06SSCR_STR-ROLE_ID_BADWILL_OFA sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_BADWILL_OFA sy-vline 
WA_FC06SSCR_STR-NGAOFFSDI sy-vline 
WA_FC06SSCR_STR-NGASTATOFFS sy-vline 
WA_FC06SSCR_STR-ROLE_ID_BADWILL_DEP sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_BADWILL_DEP sy-vline 
WA_FC06SSCR_STR-NGAAQCI sy-vline 
WA_FC06SSCR_STR-ROLE_ID_BADWILL_PL sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_BADWILL_PL sy-vline 
WA_FC06SSCR_STR-NGAAMDI sy-vline 
WA_FC06SSCR_STR-ROLE_ID_BADWILL_WU sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_BADWILL_WU sy-vline 
WA_FC06SSCR_STR-NGAAMCI sy-vline 
WA_FC06SSCR_STR-NGRAQDI sy-vline 
WA_FC06SSCR_STR-NGROFFSDI sy-vline 
WA_FC06SSCR_STR-NGRSTATOFFS sy-vline 
WA_FC06SSCR_STR-NGRAMDI sy-vline 
WA_FC06SSCR_STR-NGRAMCI sy-vline 
WA_FC06SSCR_STR-NGRSTAT sy-vline 
WA_FC06SSCR_STR-ROLE_ID_BADWILL_ELI sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_BADWILL_ELI sy-vline 
WA_FC06SSCR_STR-NGDAQCI sy-vline 
WA_FC06SSCR_STR-ROLE_ID_BADWILL_OFE sy-vline 
WA_FC06SSCR_STR-ROLE_VAL_ID_BADWILL_OFE sy-vline 
WA_FC06SSCR_STR-NGDOFFSDI sy-vline 
WA_FC06SSCR_STR-NGDSTATOFFS sy-vline 
WA_FC06SSCR_STR-NGDSTAT sy-vline 
WA_FC06SSCR_STR-NINVFLG sy-vline 
WA_FC06SSCR_STR-NMINFLG sy-vline 
WA_FC06SSCR_STR-HRREV sy-vline 
WA_FC06SSCR_STR-HRSHA sy-vline 
WA_FC06SSCR_STR-HRSITYP sy-vline 
WA_FC06SSCR_STR-HRAQDSI sy-vline 
WA_FC06SSCR_STR-HRDPCSI sy-vline 
WA_FC06SSCR_STR-HRDPDSI sy-vline 
WA_FC06SSCR_STR-NHSITYP sy-vline 
WA_FC06SSCR_STR-NHAQCSI sy-vline 
WA_FC06SSCR_STR-NHDPDSI sy-vline 
WA_FC06SSCR_STR-NHDPCSI sy-vline 
WA_FC06SSCR_STR-GWAYR sy-vline 
WA_FC06SSCR_STR-GWAPE sy-vline 
WA_FC06SSCR_STR-GWABG sy-vline 
WA_FC06SSCR_STR-GWARFLG sy-vline 
WA_FC06SSCR_STR-GWALFLG sy-vline 
WA_FC06SSCR_STR-GWALVAL sy-vline 
WA_FC06SSCR_STR-GWALCUR sy-vline 
WA_FC06SSCR_STR-GWAMETH sy-vline 
WA_FC06SSCR_STR-GWRYR sy-vline 
WA_FC06SSCR_STR-GWRPE sy-vline 
WA_FC06SSCR_STR-GWRBG sy-vline 
WA_FC06SSCR_STR-GWRRFLG sy-vline 
WA_FC06SSCR_STR-GWRLFLG sy-vline 
WA_FC06SSCR_STR-GWRLVAL sy-vline 
WA_FC06SSCR_STR-GWRLCUR sy-vline 
WA_FC06SSCR_STR-GWRMETH sy-vline 
WA_FC06SSCR_STR-NGAYR sy-vline 
WA_FC06SSCR_STR-NGAPE sy-vline 
WA_FC06SSCR_STR-NGABG sy-vline 
WA_FC06SSCR_STR-NGARFLG sy-vline 
WA_FC06SSCR_STR-NGALFLG sy-vline 
WA_FC06SSCR_STR-NGALVAL sy-vline 
WA_FC06SSCR_STR-NGALCUR sy-vline 
WA_FC06SSCR_STR-NGAMETH sy-vline 
WA_FC06SSCR_STR-NGRYR sy-vline 
WA_FC06SSCR_STR-NGRPE sy-vline 
WA_FC06SSCR_STR-NGRBG sy-vline 
WA_FC06SSCR_STR-NGRRFLG sy-vline 
WA_FC06SSCR_STR-NGRLFLG sy-vline 
WA_FC06SSCR_STR-NGRLVAL sy-vline 
WA_FC06SSCR_STR-NGRLCUR sy-vline 
WA_FC06SSCR_STR-NGRMETH sy-vline 
WA_FC06SSCR_STR-GWAAQDT sy-vline 
WA_FC06SSCR_STR-GWAAQDS sy-vline 
WA_FC06SSCR_STR-GWAAQCTPYS sy-vline 
WA_FC06SSCR_STR-GWAAQCTCYS sy-vline 
WA_FC06SSCR_STR-GWAOFFSDT sy-vline 
WA_FC06SSCR_STR-GWAOFFSDS sy-vline 
WA_FC06SSCR_STR-GWAOFFSCS sy-vline 
WA_FC06SSCR_STR-GWAAQCT sy-vline 
WA_FC06SSCR_STR-GWADPCS sy-vline 
WA_FC06SSCR_STR-GWADPDS sy-vline 
WA_FC06SSCR_STR-GWADPCTPYS sy-vline 
WA_FC06SSCR_STR-GWADPCTCYS sy-vline 
WA_FC06SSCR_STR-GWAAMDT sy-vline 
WA_FC06SSCR_STR-GWAAMDS sy-vline 
WA_FC06SSCR_STR-GWAAMCT sy-vline 
WA_FC06SSCR_STR-GWAAMCS sy-vline 
WA_FC06SSCR_STR-GWASTAT sy-vline 
WA_FC06SSCR_STR-GWASTATCT sy-vline 
WA_FC06SSCR_STR-GWRAQDT sy-vline 
WA_FC06SSCR_STR-GWRAQDS sy-vline 
WA_FC06SSCR_STR-GWRAQCS sy-vline 
WA_FC06SSCR_STR-GWROFFSDT sy-vline 
WA_FC06SSCR_STR-GWROFFSDS sy-vline 
WA_FC06SSCR_STR-GWROFFSCS sy-vline 
WA_FC06SSCR_STR-GWRAMDT sy-vline 
WA_FC06SSCR_STR-GWRAMDS sy-vline 
WA_FC06SSCR_STR-GWRAMCT sy-vline 
WA_FC06SSCR_STR-GWRAMCS sy-vline 
WA_FC06SSCR_STR-GWDAQDT sy-vline 
WA_FC06SSCR_STR-GWDAQDS sy-vline 
WA_FC06SSCR_STR-GWDOFFSDT sy-vline 
WA_FC06SSCR_STR-GWDOFFSDS sy-vline 
WA_FC06SSCR_STR-GWDOFFSCS sy-vline 
WA_FC06SSCR_STR-NGAAQDT sy-vline 
WA_FC06SSCR_STR-NGAAQDS sy-vline 
WA_FC06SSCR_STR-NGAAMCTPYS sy-vline 
WA_FC06SSCR_STR-NGAAMCTCYS sy-vline 
WA_FC06SSCR_STR-NGAOFFSDT sy-vline 
WA_FC06SSCR_STR-NGAOFFSDS sy-vline 
WA_FC06SSCR_STR-NGAOFFSCS sy-vline 
WA_FC06SSCR_STR-NGAAQCT sy-vline 
WA_FC06SSCR_STR-NGADPCS sy-vline 
WA_FC06SSCR_STR-NGADPDS sy-vline 
WA_FC06SSCR_STR-NGADPCTPYS sy-vline 
WA_FC06SSCR_STR-NGADPCTCYS sy-vline 
WA_FC06SSCR_STR-NGAAMDT sy-vline 
WA_FC06SSCR_STR-NGAAMDS sy-vline 
WA_FC06SSCR_STR-NGAAMCT sy-vline 
WA_FC06SSCR_STR-NGAAMCS sy-vline 
WA_FC06SSCR_STR-NGASTAT sy-vline 
WA_FC06SSCR_STR-NGASTATCT sy-vline 
WA_FC06SSCR_STR-NGRAQDT sy-vline 
WA_FC06SSCR_STR-NGRAQDS sy-vline 
WA_FC06SSCR_STR-NGRAQCS sy-vline 
WA_FC06SSCR_STR-NGROFFSDT sy-vline 
WA_FC06SSCR_STR-NGROFFSDS sy-vline 
WA_FC06SSCR_STR-NGROFFSCS sy-vline 
WA_FC06SSCR_STR-NGRAMDT sy-vline 
WA_FC06SSCR_STR-NGRAMDS sy-vline 
WA_FC06SSCR_STR-NGRAMCT sy-vline 
WA_FC06SSCR_STR-NGRAMCS sy-vline 
WA_FC06SSCR_STR-NGDAQCT sy-vline 
WA_FC06SSCR_STR-NGDAQCS sy-vline 
WA_FC06SSCR_STR-NGDOFFSDT sy-vline 
WA_FC06SSCR_STR-NGDOFFSDS sy-vline 
WA_FC06SSCR_STR-NGDOFFSCS sy-vline      INTO ld_text SEPARATED BY SPACE.

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