ABAP Select data from SAP table /SCMB/TMSRES_D6001_STRU 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 /SCMB/TMSRES_D6001_STRU 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 /SCMB/TMSRES_D6001_STRU. 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 /SCMB/TMSRES_D6001_STRU 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_/SCMB/TMSRES_D6001_STRU TYPE STANDARD TABLE OF /SCMB/TMSRES_D6001_STRU,
      WA_/SCMB/TMSRES_D6001_STRU TYPE /SCMB/TMSRES_D6001_STRU,
      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: </SCMB/TMSRES_D6001_STRU> TYPE /SCMB/TMSRES_D6001_STRU.

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

SELECT *
*restrict ABAP select to first 10 rows
 UP TO 10 ROWS      
  FROM /SCMB/TMSRES_D6001_STRU
  INTO TABLE IT_/SCMB/TMSRES_D6001_STRU.

*Select data and declare internal table using in-line method @DATA
*SELECT *
*  FROM /SCMB/TMSRES_D6001_STRU
*  INTO TABLE @DATA(IT_/SCMB/TMSRES_D6001_STRU2).
*--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_/SCMB/TMSRES_D6001_STRU INDEX 1 INTO DATA(WA_/SCMB/TMSRES_D6001_STRU2).


*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_/SCMB/TMSRES_D6001_STRU ASSIGNING </SCMB/TMSRES_D6001_STRU>.

*To update a field value using a field symbol simply change the value via the field symbol pointer
</SCMB/TMSRES_D6001_STRU>-VALIDDFROM = 1.
</SCMB/TMSRES_D6001_STRU>-VALIDTFROM = 1.
</SCMB/TMSRES_D6001_STRU>-VALIDDTO = 1.
</SCMB/TMSRES_D6001_STRU>-VALIDTTO = 1.
</SCMB/TMSRES_D6001_STRU>-BUILDDATE = 1.

ENDLOOP.

LOOP AT IT_/SCMB/TMSRES_D6001_STRU INTO WA_/SCMB/TMSRES_D6001_STRU.
*Write horizonal line to screen report.
  WRITE:/ sy-uline.

*Write selected data to screen/report before conversion.
  WRITE:/ sy-vline,   WA_/SCMB/TMSRES_D6001_STRU-INSERVICEDATE, sy-vline,
  WA_/SCMB/TMSRES_D6001_STRU-OWNERNAME, sy-vline,
  WA_/SCMB/TMSRES_D6001_STRU-OWNERGUID, sy-vline,
  WA_/SCMB/TMSRES_D6001_STRU-ENTITLEDNAME, sy-vline,
  WA_/SCMB/TMSRES_D6001_STRU-ENTITLEDGUID, sy-vline,
  WA_/SCMB/TMSRES_D6001_STRU-PLATENUMBER, sy-vline.
ENDLOOP.
   
*Add any further fields from structure WA_/SCMB/TMSRES_D6001_STRU 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_/SCMB/TMSRES_D6001_STRU 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_/SCMB/TMSRES_D6001_STRU INTO WA_/SCMB/TMSRES_D6001_STRU.


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

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

*Conversion exit MATN1, internal->external for field REFPMATNR
CALL FUNCTION 'CONVERSION_EXIT_MATN1_OUTPUT'
  EXPORTING
    input =                      WA_/SCMB/TMSRES_D6001_STRU-REFPMATNR
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SCMB/TMSRES_D6001_STRU-REFPMATNR.
WRITE:/ 'New Value:', ld_input.

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

*Conversion exit CUNIT, internal->external for field AXGRP_WEIGHT_UOM_03
CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT'
  EXPORTING
    input =                      WA_/SCMB/TMSRES_D6001_STRU-AXGRP_WEIGHT_UOM_03
  IMPORTING
    output =                     ld_input.
WRITE:/ 'Org Value:', WA_/SCMB/TMSRES_D6001_STRU-AXGRP_WEIGHT_UOM_03.
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_/SCMB/TMSRES_D6001_STRU_STR, 
VALIDDFROM TYPE STRING,
VALIDTFROM TYPE STRING,
VALIDDTO TYPE STRING,
VALIDTTO TYPE STRING,
BUILDDATE TYPE STRING,
INSERVICEDATE TYPE STRING,
OWNERNAME TYPE STRING,
OWNERGUID TYPE STRING,
ENTITLEDNAME TYPE STRING,
ENTITLEDGUID TYPE STRING,
PLATENUMBER TYPE STRING,
PLATECOUNTRY TYPE STRING,
COUNTRYTXT TYPE STRING,
MINREQSEALNR TYPE STRING,
BSG TYPE STRING,
REFPMATNR TYPE STRING,
CAPRQINDIV TYPE STRING,
EQUITYPE TYPE STRING,
EQUISZTP TYPE STRING,
EQUITYPE_HDL TYPE STRING,
EQUISZTP_HDL TYPE STRING,
EQUITYPE_VEH TYPE STRING,
EQUISZTP_VEH TYPE STRING,
EQUISUPPL TYPE STRING,
TEMPLATE TYPE STRING,
HRESTYPE TYPE STRING,
HRESTYPETXT TYPE STRING,
VR_MTR TYPE STRING,
VR_MTRTXT TYPE STRING,
ORGCENTRE TYPE STRING,
ORGCENTRETXT TYPE STRING,
EXT_ORG_ID TYPE STRING,
EXT_ORG_ROLE TYPE STRING,
EXT_ORG_FUNC TYPE STRING,
EXT_ORG_FUNC_ROLE TYPE STRING,
EXT_ORG_TXT TYPE STRING,
UNLTD_NO_INDV_RES TYPE STRING,
RES_CLASS_HDL TYPE STRING,
RES_CLASS_TU TYPE STRING,
RES_CLASS_VEH TYPE STRING,
EM_RELEVANCE TYPE STRING,
SHIPPER_OWNED TYPE STRING,
TYPE_CLASS TYPE STRING,
ADR_LIMIT_REL TYPE STRING,
PLN_BLOCK TYPE STRING,
EXT_TTYPE_FLG TYPE STRING,
EXT_TTYPE_NUM TYPE STRING,
OWNERSHIP_CODE TYPE STRING,
LEASE_CONTRACT_REF TYPE STRING,
RESOURCE_CONDITION TYPE STRING,
RESOURCE_CONDITION_TXT TYPE STRING,
SPECIAL_INSTRUCTION TYPE STRING,
SPECIAL_INSTRUCTION_TXT TYPE STRING,
DFLT_DRIVER TYPE STRING,
DFLT_DRIVER_UID TYPE STRING,
DFLT_TRAILER TYPE STRING,
DFLT_TRAILER_UID TYPE STRING,
PAYLOAD_WEIGHT TYPE STRING,
PAYLOAD_WGHT_UOM TYPE STRING,
CUBIC_CAPACITY TYPE STRING,
CUBIC_CAPA_UOM TYPE STRING,
INTERNAL_LENGTH TYPE STRING,
INTERNAL_WIDTH TYPE STRING,
INTERNAL_HEIGHT TYPE STRING,
INTERNAL_LWH_UOM TYPE STRING,
QUAN_UNITS TYPE STRING,
QUAN_UNITS_UOM TYPE STRING,
ALT_QUAN_UNITS TYPE STRING,
ALT_QUAN_UNITS_UOM TYPE STRING,
MAX_GROSS_WEIGHT TYPE STRING,
MAX_GROSS_WEIGHT_UOM TYPE STRING,
TARE_WEIGHT TYPE STRING,
TARE_WEIGHT_UOM TYPE STRING,
TARE_VOLUME TYPE STRING,
TARE_VOLUME_UOM TYPE STRING,
TEU_COUNT TYPE STRING,
TEMP_CONTROL TYPE STRING,
TEMP_CTRL_MIN TYPE STRING,
TEMP_CTRL_MAX TYPE STRING,
TEMP_UOM TYPE STRING,
VENTILATED TYPE STRING,
ULD_CLASS TYPE STRING,
IATA_COMPLIANT TYPE STRING,
VALDIATE_ULD_NUMBER TYPE STRING,
ULD_LOADING_INSTRUCTIONS TYPE STRING,
MAX_LENGTH TYPE STRING,
MAX_WIDTH TYPE STRING,
MAX_HEIGHT TYPE STRING,
MAX_LWH_UOM TYPE STRING,
PLATFORM_HEIGHT TYPE STRING,
PLATFORM_HEIGHT_UOM TYPE STRING,
TOPDECK_HEIGHT TYPE STRING,
TOPDECK_HEIGHT_UOM TYPE STRING,
WHEEL_DIAMETER TYPE STRING,
WHEEL_DIAMETER_UOM TYPE STRING,
DOOR_WIDTH TYPE STRING,
DOOR_HEIGHT TYPE STRING,
DOOR_WH_UOM TYPE STRING,
LOAD_OPENING_LENGTH TYPE STRING,
LOAD_OPENING_WIDTH TYPE STRING,
LOAD_OPENING_LW_UOM TYPE STRING,
AXLE_COUNT TYPE STRING,
AXLE_SPACNG_DIST TYPE STRING,
AXLE_SPACNG_DIST_UOM TYPE STRING,
MAX_AXLE_WEIGHT TYPE STRING,
MAX_AXLE_WEIGHT_UOM TYPE STRING,
COUPLERSTYLE TYPE STRING,
WHEEL_BEARNG_TYPE TYPE STRING,
DRAFT_GEAR_TYPE TYPE STRING,
CARGO_BODY_DIST TYPE STRING,
CONNECTOR_DIST TYPE STRING,
CONNECTOR_MAX_WGHT TYPE STRING,
KINGPIN_DIST TYPE STRING,
KINGPIN_MAX_WGHT TYPE STRING,
SPLITDECK_POSN TYPE STRING,
SPLITDECK_MAX_WGHT TYPE STRING,
TECHN_DIST_UOM TYPE STRING,
WGHT_LOADING_UOM TYPE STRING,
MAX_TRAILING_LOAD TYPE STRING,
MAX_TRAIL_LOAD_UOM TYPE STRING,
FOOD_GRADE_IND TYPE STRING,
VEHLOADPROFILE TYPE STRING,
ATTEQUIPROFILE TYPE STRING,
AXLE_TYPE_01 TYPE STRING,
AXLE_SPACE_DIST_01 TYPE STRING,
AXGRP_POSN_01 TYPE STRING,
AXGRP_DIST_UOM_01 TYPE STRING,
AXGRP_MAX_WEIGHT_01 TYPE STRING,
AXGRP_EMPTY_WEIGHT_01 TYPE STRING,
AXGRP_WEIGHT_UOM_01 TYPE STRING,
AXLE_DRIVING_IND_01 TYPE STRING,
AXLE_STEERING_IND_01 TYPE STRING,
AXLE_TYPE_02 TYPE STRING,
AXLE_SPACE_DIST_02 TYPE STRING,
AXGRP_POSN_02 TYPE STRING,
AXGRP_DIST_UOM_02 TYPE STRING,
AXGRP_MAX_WEIGHT_02 TYPE STRING,
AXGRP_EMPTY_WEIGHT_02 TYPE STRING,
AXGRP_WEIGHT_UOM_02 TYPE STRING,
AXLE_DRIVING_IND_02 TYPE STRING,
AXLE_STEERING_IND_02 TYPE STRING,
AXLE_TYPE_03 TYPE STRING,
AXLE_SPACE_DIST_03 TYPE STRING,
AXGRP_POSN_03 TYPE STRING,
AXGRP_DIST_UOM_03 TYPE STRING,
AXGRP_MAX_WEIGHT_03 TYPE STRING,
AXGRP_EMPTY_WEIGHT_03 TYPE STRING,
AXGRP_WEIGHT_UOM_03 TYPE STRING,
AXLE_DRIVING_IND_03 TYPE STRING,
AXLE_STEERING_IND_03 TYPE STRING,
EEW_TRP_TMSRES TYPE STRING,
EEW_TMSRES_AATR TYPE STRING,
COUNTRY_VEHIC_ID TYPE STRING,
CMPROFILE TYPE STRING,
RES_SPEC_CMPROFILE TYPE STRING,
COMB_RES TYPE STRING,END OF T_EKKO_STR.
DATA: WA_/SCMB/TMSRES_D6001_STRU_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_/SCMB/TMSRES_D6001_STRU_STR-VALIDDFROM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-VALIDTFROM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-VALIDDTO sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-VALIDTTO sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-BUILDDATE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-INSERVICEDATE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-OWNERNAME sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-OWNERGUID sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ENTITLEDNAME sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ENTITLEDGUID sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-PLATENUMBER sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-PLATECOUNTRY sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-COUNTRYTXT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MINREQSEALNR sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-BSG sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-REFPMATNR sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-CAPRQINDIV sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EQUITYPE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EQUISZTP sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EQUITYPE_HDL sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EQUISZTP_HDL sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EQUITYPE_VEH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EQUISZTP_VEH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EQUISUPPL sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TEMPLATE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-HRESTYPE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-HRESTYPETXT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-VR_MTR sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-VR_MTRTXT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ORGCENTRE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ORGCENTRETXT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EXT_ORG_ID sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EXT_ORG_ROLE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EXT_ORG_FUNC sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EXT_ORG_FUNC_ROLE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EXT_ORG_TXT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-UNLTD_NO_INDV_RES sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-RES_CLASS_HDL sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-RES_CLASS_TU sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-RES_CLASS_VEH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EM_RELEVANCE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-SHIPPER_OWNED sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TYPE_CLASS sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ADR_LIMIT_REL sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-PLN_BLOCK sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EXT_TTYPE_FLG sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EXT_TTYPE_NUM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-OWNERSHIP_CODE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-LEASE_CONTRACT_REF sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-RESOURCE_CONDITION sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-RESOURCE_CONDITION_TXT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-SPECIAL_INSTRUCTION sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-SPECIAL_INSTRUCTION_TXT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-DFLT_DRIVER sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-DFLT_DRIVER_UID sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-DFLT_TRAILER sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-DFLT_TRAILER_UID sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-PAYLOAD_WEIGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-PAYLOAD_WGHT_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-CUBIC_CAPACITY sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-CUBIC_CAPA_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-INTERNAL_LENGTH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-INTERNAL_WIDTH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-INTERNAL_HEIGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-INTERNAL_LWH_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-QUAN_UNITS sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-QUAN_UNITS_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ALT_QUAN_UNITS sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ALT_QUAN_UNITS_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_GROSS_WEIGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_GROSS_WEIGHT_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TARE_WEIGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TARE_WEIGHT_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TARE_VOLUME sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TARE_VOLUME_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TEU_COUNT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TEMP_CONTROL sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TEMP_CTRL_MIN sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TEMP_CTRL_MAX sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TEMP_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-VENTILATED sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ULD_CLASS sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-IATA_COMPLIANT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-VALDIATE_ULD_NUMBER sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ULD_LOADING_INSTRUCTIONS sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_LENGTH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_WIDTH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_HEIGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_LWH_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-PLATFORM_HEIGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-PLATFORM_HEIGHT_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TOPDECK_HEIGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TOPDECK_HEIGHT_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-WHEEL_DIAMETER sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-WHEEL_DIAMETER_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-DOOR_WIDTH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-DOOR_HEIGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-DOOR_WH_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-LOAD_OPENING_LENGTH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-LOAD_OPENING_WIDTH sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-LOAD_OPENING_LW_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_COUNT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_SPACNG_DIST sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_SPACNG_DIST_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_AXLE_WEIGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_AXLE_WEIGHT_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-COUPLERSTYLE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-WHEEL_BEARNG_TYPE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-DRAFT_GEAR_TYPE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-CARGO_BODY_DIST sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-CONNECTOR_DIST sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-CONNECTOR_MAX_WGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-KINGPIN_DIST sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-KINGPIN_MAX_WGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-SPLITDECK_POSN sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-SPLITDECK_MAX_WGHT sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-TECHN_DIST_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-WGHT_LOADING_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_TRAILING_LOAD sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-MAX_TRAIL_LOAD_UOM sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-FOOD_GRADE_IND sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-VEHLOADPROFILE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-ATTEQUIPROFILE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_TYPE_01 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_SPACE_DIST_01 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_POSN_01 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_DIST_UOM_01 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_MAX_WEIGHT_01 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_EMPTY_WEIGHT_01 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_WEIGHT_UOM_01 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_DRIVING_IND_01 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_STEERING_IND_01 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_TYPE_02 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_SPACE_DIST_02 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_POSN_02 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_DIST_UOM_02 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_MAX_WEIGHT_02 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_EMPTY_WEIGHT_02 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_WEIGHT_UOM_02 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_DRIVING_IND_02 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_STEERING_IND_02 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_TYPE_03 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_SPACE_DIST_03 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_POSN_03 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_DIST_UOM_03 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_MAX_WEIGHT_03 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_EMPTY_WEIGHT_03 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXGRP_WEIGHT_UOM_03 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_DRIVING_IND_03 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-AXLE_STEERING_IND_03 sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EEW_TRP_TMSRES sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-EEW_TMSRES_AATR sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-COUNTRY_VEHIC_ID sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-CMPROFILE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-RES_SPEC_CMPROFILE sy-vline 
WA_/SCMB/TMSRES_D6001_STRU_STR-COMB_RES sy-vline      INTO ld_text SEPARATED BY SPACE.

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