ABAP Select data from SAP table CRATEDIMN 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 CRATEDIMN 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 CRATEDIMN. 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 CRATEDIMN 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_CRATEDIMN TYPE STANDARD TABLE OF CRATEDIMN,
      WA_CRATEDIMN TYPE CRATEDIMN,
      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: <CRATEDIMN> TYPE CRATEDIMN.

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

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

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM CRATEDIMN
*  INTO TABLE @DATA(IT_CRATEDIMN2).
*--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_CRATEDIMN INDEX 1 INTO DATA(WA_CRATEDIMN2).


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

*To update a field value using a field symbol simply change the value via the field symbol pointer
<CRATEDIMN>-MANDT = 1.
<CRATEDIMN>-TRANSPRATEDIMENSIONUUID = 1.
<CRATEDIMN>-TRANSPORTATIONRATEUUID = 1.
<CRATEDIMN>-TRANSPCALCSHEETITEMUUID = 1.
<CRATEDIMN>-TRANSPRATEDIMNSCALEITEM01UUID = 1.

ENDLOOP.

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

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_CRATEDIMN-TRANSPRATEDIMNSCALEITEM02UUID, sy-vline,
  WA_CRATEDIMN-TRANSPRATEDIMNSCALEITEM03UUID, sy-vline,
  WA_CRATEDIMN-TRANSPRATEDIMNSCALEITEM04UUID, sy-vline,
  WA_CRATEDIMN-TRANSPRATEDIMNSCALEITEM05UUID, sy-vline,
  WA_CRATEDIMN-TRANSPRATEDIMNSCALEITEM06UUID, sy-vline,
  WA_CRATEDIMN-TRANSPRATEDIMNSCALEITEM07UUID, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_CRATEDIMN 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_CRATEDIMN 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_CRATEDIMN INTO WA_CRATEDIMN.


*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 CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT01
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT01
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT01.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT02
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT02
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT02.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT03
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT03
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT03.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT04
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT04
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT04.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT05
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT05
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT05.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT06
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT06
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT06.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT07
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT07
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT07.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT08
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT08
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT08.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT09
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT09
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT09.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT10
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT10
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT10.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT11
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT11
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT11.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT12
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT12
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT12.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT13
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT13
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT13.
WRITE:/ 'New Value:', ld_input.

*Conversion exit CUNIT, internal->external for field TRANSPSCALEITEMQUANTITYUNIT14
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT14
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_CRATEDIMN-TRANSPSCALEITEMQUANTITYUNIT14.
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_CRATEDIMN_STR, 
MANDT TYPE STRING,
TRANSPRATEDIMENSIONUUID TYPE STRING,
TRANSPORTATIONRATEUUID TYPE STRING,
TRANSPCALCSHEETITEMUUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM01UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM02UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM03UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM04UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM05UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM06UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM07UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM08UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM09UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM10UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM11UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM12UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM13UUID TYPE STRING,
TRANSPRATEDIMNSCALEITEM14UUID TYPE STRING,
TRANSPORTATIONRATECURRENCY TYPE STRING,
TRANSPRATEAMOUNTINRATECRCY TYPE STRING,
TRANSPRATEDIMENSIONINDEX TYPE STRING,
TRANSPORTATIONCALCBASE01 TYPE STRING,
TRANSPCALCULATIONBASETEXT01 TYPE STRING,
TRANSPORTATIONCALCBASE02 TYPE STRING,
TRANSPCALCULATIONBASETEXT02 TYPE STRING,
TRANSPORTATIONCALCBASE03 TYPE STRING,
TRANSPCALCULATIONBASETEXT03 TYPE STRING,
TRANSPORTATIONCALCBASE04 TYPE STRING,
TRANSPCALCULATIONBASETEXT04 TYPE STRING,
TRANSPORTATIONCALCBASE05 TYPE STRING,
TRANSPCALCULATIONBASETEXT05 TYPE STRING,
TRANSPORTATIONCALCBASE06 TYPE STRING,
TRANSPCALCULATIONBASETEXT06 TYPE STRING,
TRANSPORTATIONCALCBASE07 TYPE STRING,
TRANSPCALCULATIONBASETEXT07 TYPE STRING,
TRANSPORTATIONCALCBASE08 TYPE STRING,
TRANSPCALCULATIONBASETEXT08 TYPE STRING,
TRANSPORTATIONCALCBASE09 TYPE STRING,
TRANSPCALCULATIONBASETEXT09 TYPE STRING,
TRANSPORTATIONCALCBASE10 TYPE STRING,
TRANSPCALCULATIONBASETEXT10 TYPE STRING,
TRANSPORTATIONCALCBASE11 TYPE STRING,
TRANSPCALCULATIONBASETEXT11 TYPE STRING,
TRANSPORTATIONCALCBASE12 TYPE STRING,
TRANSPCALCULATIONBASETEXT12 TYPE STRING,
TRANSPORTATIONCALCBASE13 TYPE STRING,
TRANSPCALCULATIONBASETEXT13 TYPE STRING,
TRANSPORTATIONCALCBASE14 TYPE STRING,
TRANSPCALCULATIONBASETEXT14 TYPE STRING,
TRANSPSCALEITEMAMOUNT01 TYPE STRING,
TRANSPSCALEITEMCURRENCY01 TYPE STRING,
TRANSPSCALEITEMQUANTITY01 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT01 TYPE STRING,
TRANSPSCALEITEMVALUECHAR01 TYPE STRING,
TRANSPSCALEITEMVALUERAW01 TYPE STRING,
TRANSPSCALEITEMVALUEDATE01 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN01 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE01 TYPE STRING,
TRANSPSCALEITEMAMOUNT02 TYPE STRING,
TRANSPSCALEITEMCURRENCY02 TYPE STRING,
TRANSPSCALEITEMQUANTITY02 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT02 TYPE STRING,
TRANSPSCALEITEMVALUECHAR02 TYPE STRING,
TRANSPSCALEITEMVALUEDATE02 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN02 TYPE STRING,
TRANSPSCALEITEMVALUERAW02 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE02 TYPE STRING,
TRANSPSCALEITEMAMOUNT03 TYPE STRING,
TRANSPSCALEITEMCURRENCY03 TYPE STRING,
TRANSPSCALEITEMQUANTITY03 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT03 TYPE STRING,
TRANSPSCALEITEMVALUECHAR03 TYPE STRING,
TRANSPSCALEITEMVALUERAW03 TYPE STRING,
TRANSPSCALEITEMVALUEDATE03 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN03 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE03 TYPE STRING,
TRANSPSCALEITEMAMOUNT04 TYPE STRING,
TRANSPSCALEITEMCURRENCY04 TYPE STRING,
TRANSPSCALEITEMQUANTITY04 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT04 TYPE STRING,
TRANSPSCALEITEMVALUECHAR04 TYPE STRING,
TRANSPSCALEITEMVALUERAW04 TYPE STRING,
TRANSPSCALEITEMVALUEDATE04 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN04 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE04 TYPE STRING,
TRANSPSCALEITEMAMOUNT05 TYPE STRING,
TRANSPSCALEITEMCURRENCY05 TYPE STRING,
TRANSPSCALEITEMQUANTITY05 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT05 TYPE STRING,
TRANSPSCALEITEMVALUECHAR05 TYPE STRING,
TRANSPSCALEITEMVALUERAW05 TYPE STRING,
TRANSPSCALEITEMVALUEDATE05 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN05 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE05 TYPE STRING,
TRANSPSCALEITEMAMOUNT06 TYPE STRING,
TRANSPSCALEITEMCURRENCY06 TYPE STRING,
TRANSPSCALEITEMQUANTITY06 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT06 TYPE STRING,
TRANSPSCALEITEMVALUECHAR06 TYPE STRING,
TRANSPSCALEITEMVALUERAW06 TYPE STRING,
TRANSPSCALEITEMVALUEDATE06 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN06 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE06 TYPE STRING,
TRANSPSCALEITEMAMOUNT07 TYPE STRING,
TRANSPSCALEITEMCURRENCY07 TYPE STRING,
TRANSPSCALEITEMQUANTITY07 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT07 TYPE STRING,
TRANSPSCALEITEMVALUECHAR07 TYPE STRING,
TRANSPSCALEITEMVALUERAW07 TYPE STRING,
TRANSPSCALEITEMVALUEDATE07 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN07 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE07 TYPE STRING,
TRANSPSCALEITEMAMOUNT08 TYPE STRING,
TRANSPSCALEITEMCURRENCY08 TYPE STRING,
TRANSPSCALEITEMQUANTITY08 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT08 TYPE STRING,
TRANSPSCALEITEMVALUECHAR08 TYPE STRING,
TRANSPSCALEITEMVALUERAW08 TYPE STRING,
TRANSPSCALEITEMVALUEDATE08 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN08 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE08 TYPE STRING,
TRANSPSCALEITEMAMOUNT09 TYPE STRING,
TRANSPSCALEITEMCURRENCY09 TYPE STRING,
TRANSPSCALEITEMQUANTITY09 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT09 TYPE STRING,
TRANSPSCALEITEMVALUECHAR09 TYPE STRING,
TRANSPSCALEITEMVALUERAW09 TYPE STRING,
TRANSPSCALEITEMVALUEDATE09 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN09 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE09 TYPE STRING,
TRANSPSCALEITEMAMOUNT10 TYPE STRING,
TRANSPSCALEITEMCURRENCY10 TYPE STRING,
TRANSPSCALEITEMQUANTITY10 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT10 TYPE STRING,
TRANSPSCALEITEMVALUECHAR10 TYPE STRING,
TRANSPSCALEITEMVALUERAW10 TYPE STRING,
TRANSPSCALEITEMVALUEDATE10 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN10 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE10 TYPE STRING,
TRANSPSCALEITEMAMOUNT11 TYPE STRING,
TRANSPSCALEITEMCURRENCY11 TYPE STRING,
TRANSPSCALEITEMQUANTITY11 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT11 TYPE STRING,
TRANSPSCALEITEMVALUECHAR11 TYPE STRING,
TRANSPSCALEITEMVALUERAW11 TYPE STRING,
TRANSPSCALEITEMVALUEDATE11 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN11 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE11 TYPE STRING,
TRANSPSCALEITEMAMOUNT12 TYPE STRING,
TRANSPSCALEITEMCURRENCY12 TYPE STRING,
TRANSPSCALEITEMQUANTITY12 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT12 TYPE STRING,
TRANSPSCALEITEMVALUECHAR12 TYPE STRING,
TRANSPSCALEITEMVALUERAW12 TYPE STRING,
TRANSPSCALEITEMVALUEDATE12 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN12 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE12 TYPE STRING,
TRANSPSCALEITEMAMOUNT13 TYPE STRING,
TRANSPSCALEITEMCURRENCY13 TYPE STRING,
TRANSPSCALEITEMQUANTITY13 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT13 TYPE STRING,
TRANSPSCALEITEMVALUECHAR13 TYPE STRING,
TRANSPSCALEITEMVALUERAW13 TYPE STRING,
TRANSPSCALEITEMVALUEDATE13 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN13 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE13 TYPE STRING,
TRANSPSCALEITEMAMOUNT14 TYPE STRING,
TRANSPSCALEITEMCURRENCY14 TYPE STRING,
TRANSPSCALEITEMQUANTITY14 TYPE STRING,
TRANSPSCALEITEMQUANTITYUNIT14 TYPE STRING,
TRANSPSCALEITEMVALUECHAR14 TYPE STRING,
TRANSPSCALEITEMVALUERAW14 TYPE STRING,
TRANSPSCALEITEMVALUEDATE14 TYPE STRING,
TRANSPSCALEITEMISBOOLEAN14 TYPE STRING,
TRANSPORTATIONSCALEITEMTYPE14 TYPE STRING,
TRANSPORTATIONRATEHASMINMAX TYPE STRING,END OF T_EKKO_STR.
DATA: WA_CRATEDIMN_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_CRATEDIMN_STR-MANDT sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMENSIONUUID sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONRATEUUID sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCSHEETITEMUUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM01UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM02UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM03UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM04UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM05UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM06UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM07UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM08UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM09UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM10UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM11UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM12UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM13UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMNSCALEITEM14UUID sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONRATECURRENCY sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEAMOUNTINRATECRCY sy-vline 
WA_CRATEDIMN_STR-TRANSPRATEDIMENSIONINDEX sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE01 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT01 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE02 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT02 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE03 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT03 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE04 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT04 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE05 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT05 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE06 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT06 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE07 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT07 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE08 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT08 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE09 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT09 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE10 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT10 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE11 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT11 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE12 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT12 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE13 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT13 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONCALCBASE14 sy-vline 
WA_CRATEDIMN_STR-TRANSPCALCULATIONBASETEXT14 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT01 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY01 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY01 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT01 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR01 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW01 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE01 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN01 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE01 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT02 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY02 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY02 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT02 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR02 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE02 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN02 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW02 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE02 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT03 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY03 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY03 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT03 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR03 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW03 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE03 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN03 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE03 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT04 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY04 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY04 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT04 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR04 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW04 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE04 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN04 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE04 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT05 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY05 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY05 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT05 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR05 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW05 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE05 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN05 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE05 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT06 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY06 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY06 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT06 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR06 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW06 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE06 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN06 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE06 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT07 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY07 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY07 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT07 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR07 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW07 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE07 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN07 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE07 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT08 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY08 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY08 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT08 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR08 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW08 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE08 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN08 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE08 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT09 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY09 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY09 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT09 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR09 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW09 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE09 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN09 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE09 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT10 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY10 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY10 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT10 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR10 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW10 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE10 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN10 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE10 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT11 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY11 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY11 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT11 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR11 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW11 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE11 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN11 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE11 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT12 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY12 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY12 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT12 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR12 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW12 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE12 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN12 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE12 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT13 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY13 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY13 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT13 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR13 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW13 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE13 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN13 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE13 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMAMOUNT14 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMCURRENCY14 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITY14 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMQUANTITYUNIT14 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUECHAR14 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUERAW14 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMVALUEDATE14 sy-vline 
WA_CRATEDIMN_STR-TRANSPSCALEITEMISBOOLEAN14 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONSCALEITEMTYPE14 sy-vline 
WA_CRATEDIMN_STR-TRANSPORTATIONRATEHASMINMAX sy-vline      INTO ld_text SEPARATED BY SPACE.

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