ABAP Select data from SAP table /SCMTMS/S_UI_PLN_FO_RAIL_TREE into internal table
Get Example source ABAP code based on a different SAP table
Below is a number of ABAP code snippets to demonstrate how to select data from SAP /SCMTMS/S_UI_PLN_FO_RAIL_TREE 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 /SCMTMS/S_UI_PLN_FO_RAIL_TREE. 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 /SCMTMS/S_UI_PLN_FO_RAIL_TREE 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_/SCMTMS/S_UI_PLN_FO_RAIL_TREE TYPE STANDARD TABLE OF /SCMTMS/S_UI_PLN_FO_RAIL_TREE, WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE TYPE /SCMTMS/S_UI_PLN_FO_RAIL_TREE, 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: </SCMTMS/S_UI_PLN_FO_RAIL_TREE> TYPE /SCMTMS/S_UI_PLN_FO_RAIL_TREE. *Process all fields in table header/work area as string values PERFORM process_as_string_field_values CHANGING wa_/SCMTMS/S_UI_PLN_FO_RAIL_TREE. SELECT * *restrict ABAP select to first 10 rows UP TO 10 ROWS FROM /SCMTMS/S_UI_PLN_FO_RAIL_TREE INTO TABLE IT_/SCMTMS/S_UI_PLN_FO_RAIL_TREE. *Select data and declare internal table using in-line method @DATA *SELECT * * FROM /SCMTMS/S_UI_PLN_FO_RAIL_TREE * INTO TABLE @DATA(IT_/SCMTMS/S_UI_PLN_FO_RAIL_TREE2). *--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_/SCMTMS/S_UI_PLN_FO_RAIL_TREE INDEX 1 INTO DATA(WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE2). *Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL LOOP AT IT_/SCMTMS/S_UI_PLN_FO_RAIL_TREE ASSIGNING </SCMTMS/S_UI_PLN_FO_RAIL_TREE>.*To update a field value using a field symbol simply change the value via the field symbol pointer
</SCMTMS/S_UI_PLN_FO_RAIL_TREE>-KEY = 1.
</SCMTMS/S_UI_PLN_FO_RAIL_TREE>-TREE_PARENT_KEY = 1.
</SCMTMS/S_UI_PLN_FO_RAIL_TREE>-IS_LEAF = 1.
</SCMTMS/S_UI_PLN_FO_RAIL_TREE>-EXPANDED = 1.
</SCMTMS/S_UI_PLN_FO_RAIL_TREE>-IMAGE_SRC = 1.
ENDLOOP. LOOP AT IT_/SCMTMS/S_UI_PLN_FO_RAIL_TREE INTO WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-CHILDREN_LOADED, sy-vline,
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-TEXT, sy-vline,
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OVERVIEW_KEY, sy-vline,
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OVERVIEW_ELEMENT_CAT, sy-vline,
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OVERVIEW_TOR_CAT, sy-vline,
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OVERVIEW_TU_CAT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE 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_/SCMTMS/S_UI_PLN_FO_RAIL_TREE 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_/SCMTMS/S_UI_PLN_FO_RAIL_TREE INTO WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE. *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 OVERVIEW_ITEM_ID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OVERVIEW_ITEM_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OVERVIEW_ITEM_ID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field STAGE_ID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-STAGE_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-STAGE_ID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ID004, internal->external for field SOURCE_LOC_UUID CALL FUNCTION 'CONVERSION_EXIT_ID004_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-SOURCE_LOC_UUID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-SOURCE_LOC_UUID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ID004, internal->external for field DEST_LOC_UUID CALL FUNCTION 'CONVERSION_EXIT_ID004_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-DEST_LOC_UUID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-DEST_LOC_UUID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ID012, internal->external for field VEH_KEY CALL FUNCTION 'CONVERSION_EXIT_ID012_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-VEH_KEY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-VEH_KEY.
WRITE:/ 'New Value:', ld_input.
*Conversion exit TSTRN, internal->external for field DURATION CALL FUNCTION 'CONVERSION_EXIT_TSTRN_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-DURATION IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-DURATION.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field CARRIER CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-CARRIER IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-CARRIER.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field NET_WEI_UNIREQ CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-NET_WEI_UNIREQ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-NET_WEI_UNIREQ.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field QUA_PCS2_UNIREQ CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-QUA_PCS2_UNIREQ IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-QUA_PCS2_UNIREQ.
WRITE:/ 'New Value:', ld_input.
*Conversion exit QTYRN, internal->external for field OPEN_CAPA CALL FUNCTION 'CONVERSION_EXIT_QTYRN_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OPEN_CAPA IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OPEN_CAPA.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field OPEN_CAPA_UOM CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OPEN_CAPA_UOM IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-OPEN_CAPA_UOM.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field SCHEDULE_ID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-SCHEDULE_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-SCHEDULE_ID.
WRITE:/ 'New Value:', ld_input.
*Conversion exit CUNIT, internal->external for field DISTANCE_UOM_UI CALL FUNCTION 'CONVERSION_EXIT_CUNIT_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-DISTANCE_UOM_UI IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-DISTANCE_UOM_UI.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field ROUTE_ID CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-ROUTE_ID IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE-ROUTE_ID.
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_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR,
KEY TYPE STRING,
TREE_PARENT_KEY TYPE STRING,
IS_LEAF TYPE STRING,
EXPANDED TYPE STRING,
IMAGE_SRC TYPE STRING,
CHILDREN_LOADED TYPE STRING,
TEXT TYPE STRING,
OVERVIEW_KEY TYPE STRING,
OVERVIEW_ELEMENT_CAT TYPE STRING,
OVERVIEW_TOR_CAT TYPE STRING,
OVERVIEW_TU_CAT TYPE STRING,
OVERVIEW_TRMO TYPE STRING,
OVERVIEW_ITEM_CAT TYPE STRING,
OVERVIEW_ITEM_ID TYPE STRING,
OVERVIEW_ELEMENT_DIRECTION TYPE STRING,
OVERVIEW_PARENT_KEY TYPE STRING,
OVERVIEW_ELEMENT_KEY TYPE STRING,
OVERVIEW_PERSISTENT_ROOT_KEY TYPE STRING,
OVERVIEW_PERSISTENT_ITEM_KEY TYPE STRING,
OVERVIEW_ORIG_REF_ROOT_KEY TYPE STRING,
OVERVIEW_ORIG_REF_ITEM_KEY TYPE STRING,
OVERVIEW_STOP_ROLE TYPE STRING,
OVERVIEW_STOP_IDX TYPE STRING,
OVERVIEW_SUCC_KEY TYPE STRING,
OVERVIEW_ELEMENT_ORIGIN_BO TYPE STRING,
OVERVIEW_ITEM_LOAD_RELEVANT TYPE STRING,
OVERVIEW_SEMANTIC_KEY TYPE STRING,
OVERVIEW_ITEM_DESCR TYPE STRING,
OVERVIEW_SORT_ID TYPE STRING,
OBJECT TYPE STRING,
OH_SEQUENCE TYPE STRING,
BO_CATEGORY TYPE STRING,
BO_KEY TYPE STRING,
TRQ_ROOT_KEY TYPE STRING,
STAGE_KEY TYPE STRING,
STAGE_ID TYPE STRING,
ITEM_IS_LOCAL TYPE STRING,
CELL_DESIGN TYPE STRING,
SOURCE_LOC_UUID TYPE STRING,
SOURCE_LOC_ID TYPE STRING,
SOURCE_LOC_DESCRIPTION TYPE STRING,
SOURCE_CITY_NAME TYPE STRING,
SOURCE_STREET_POSTAL_CODE TYPE STRING,
SOURCE_COUNTRY_CODE TYPE STRING,
SOURCE_REGION TYPE STRING,
DEST_LOC_UUID TYPE STRING,
DEST_LOC_ID TYPE STRING,
DEST_LOC_DESCRIPTION TYPE STRING,
DEST_CITY_NAME TYPE STRING,
DEST_STREET_POSTAL_CODE TYPE STRING,
DEST_COUNTRY_CODE TYPE STRING,
DEST_REGION TYPE STRING,
LOAD_START TYPE STRING,
LOAD_END TYPE STRING,
TRANSP_START TYPE STRING,
TRANSP_END TYPE STRING,
UNLOAD_START TYPE STRING,
UNLOAD_END TYPE STRING,
ACTIVITY_START TYPE STRING,
ACTIVITY_END TYPE STRING,
TOR_TYPE TYPE STRING,
MTR TYPE STRING,
TRMODCODE TYPE STRING,
TRMODCAT TYPE STRING,
VEH_KEY TYPE STRING,
VEH_DESCRIPTION TYPE STRING,
SCHEDULE_DESCRIPTION TYPE STRING,
SCHEDULE_KEY TYPE STRING,
SCHEDULE_DEP_KEY TYPE STRING,
VOYAGE TYPE STRING,
DISTANCE TYPE STRING,
DURATION TYPE STRING,
CARRIER TYPE STRING,
CARRIER_SCAC TYPE STRING,
DGO_INDICATOR TYPE STRING,
DGO_CHECK_ERROR TYPE STRING,
NET_WEI_VALREQ TYPE STRING,
NET_WEI_UNIREQ TYPE STRING,
QUA_PCS2_VALREQ TYPE STRING,
QUA_PCS2_UNIREQ TYPE STRING,
OPEN_CAPA TYPE STRING,
OPEN_CAPA_UOM TYPE STRING,
MAX_UTIL TYPE STRING,
BLK_PLAN TYPE STRING,
BLK_EXEC TYPE STRING,
BRC_PLAN TYPE STRING,
BRC_EXEC TYPE STRING,
LIFECYCLE TYPE STRING,
EXECUTION TYPE STRING,
IMAGE_SRC_TOOLTIP TYPE STRING,
SOURCE_LOGLOC_ADDRESS TYPE STRING,
DEST_LOGLOC_ADDRESS TYPE STRING,
DGO_CHECK_ERROR_TXT TYPE STRING,
SCHEDULE_ID TYPE STRING,
VEH_ID TYPE STRING,
DISTANCE_UI TYPE STRING,
DISTANCE_UOM_UI TYPE STRING,
MAX_UTIL_PI TYPE STRING,
MAX_UTIL_TOOLTIP TYPE STRING,
LOAD_START_TTT TYPE STRING,
LOAD_END_TTT TYPE STRING,
TRANSP_START_TTT TYPE STRING,
TRANSP_END_TTT TYPE STRING,
UNLOAD_START_TTT TYPE STRING,
UNLOAD_END_TTT TYPE STRING,
ACTIVITY_START_TTT TYPE STRING,
ACTIVITY_END_TTT TYPE STRING,
TOR_TYPE_TXT TYPE STRING,
BRC_PLAN_TXT TYPE STRING,
BRC_EXEC_TXT TYPE STRING,
LIFECYCLE_TXT TYPE STRING,
EXECUTION_TXT TYPE STRING,
TOR_STATUS_ICON TYPE STRING,
TOR_STATUS_TOOLTIP TYPE STRING,
PYMT_IND TYPE STRING,
PYMT_IND_TXT TYPE STRING,
MULTI_EXE_PTY TYPE STRING,
ROUTE_DESCRIPTION TYPE STRING,
ROUTE_ROOT_KEY TYPE STRING,
ROUTE_ID TYPE STRING,
FIXATION TYPE STRING,
FIXATION_ICON TYPE STRING,
FIXATION_TXT TYPE STRING,
DOCUMENT_ID TYPE STRING,END OF T_EKKO_STR. DATA: WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_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_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TREE_PARENT_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-IS_LEAF sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-EXPANDED sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-IMAGE_SRC sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-CHILDREN_LOADED sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TEXT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ELEMENT_CAT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_TOR_CAT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_TU_CAT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_TRMO sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ITEM_CAT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ITEM_ID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ELEMENT_DIRECTION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_PARENT_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ELEMENT_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_PERSISTENT_ROOT_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_PERSISTENT_ITEM_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ORIG_REF_ROOT_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ORIG_REF_ITEM_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_STOP_ROLE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_STOP_IDX sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_SUCC_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ELEMENT_ORIGIN_BO sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ITEM_LOAD_RELEVANT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_SEMANTIC_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_ITEM_DESCR sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OVERVIEW_SORT_ID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OBJECT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OH_SEQUENCE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-BO_CATEGORY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-BO_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TRQ_ROOT_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-STAGE_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-STAGE_ID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-ITEM_IS_LOCAL sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-CELL_DESIGN sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SOURCE_LOC_UUID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SOURCE_LOC_ID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SOURCE_LOC_DESCRIPTION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SOURCE_CITY_NAME sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SOURCE_STREET_POSTAL_CODE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SOURCE_COUNTRY_CODE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SOURCE_REGION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DEST_LOC_UUID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DEST_LOC_ID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DEST_LOC_DESCRIPTION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DEST_CITY_NAME sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DEST_STREET_POSTAL_CODE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DEST_COUNTRY_CODE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DEST_REGION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-LOAD_START sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-LOAD_END sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TRANSP_START sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TRANSP_END sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-UNLOAD_START sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-UNLOAD_END sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-ACTIVITY_START sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-ACTIVITY_END sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TOR_TYPE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-MTR sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TRMODCODE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TRMODCAT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-VEH_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-VEH_DESCRIPTION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SCHEDULE_DESCRIPTION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SCHEDULE_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SCHEDULE_DEP_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-VOYAGE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DISTANCE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DURATION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-CARRIER sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-CARRIER_SCAC sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DGO_INDICATOR sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DGO_CHECK_ERROR sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-NET_WEI_VALREQ sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-NET_WEI_UNIREQ sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-QUA_PCS2_VALREQ sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-QUA_PCS2_UNIREQ sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OPEN_CAPA sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-OPEN_CAPA_UOM sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-MAX_UTIL sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-BLK_PLAN sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-BLK_EXEC sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-BRC_PLAN sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-BRC_EXEC sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-LIFECYCLE sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-EXECUTION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-IMAGE_SRC_TOOLTIP sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SOURCE_LOGLOC_ADDRESS sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DEST_LOGLOC_ADDRESS sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DGO_CHECK_ERROR_TXT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-SCHEDULE_ID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-VEH_ID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DISTANCE_UI sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DISTANCE_UOM_UI sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-MAX_UTIL_PI sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-MAX_UTIL_TOOLTIP sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-LOAD_START_TTT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-LOAD_END_TTT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TRANSP_START_TTT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TRANSP_END_TTT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-UNLOAD_START_TTT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-UNLOAD_END_TTT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-ACTIVITY_START_TTT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-ACTIVITY_END_TTT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TOR_TYPE_TXT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-BRC_PLAN_TXT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-BRC_EXEC_TXT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-LIFECYCLE_TXT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-EXECUTION_TXT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TOR_STATUS_ICON sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-TOR_STATUS_TOOLTIP sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-PYMT_IND sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-PYMT_IND_TXT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-MULTI_EXE_PTY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-ROUTE_DESCRIPTION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-ROUTE_ROOT_KEY sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-ROUTE_ID sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-FIXATION sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-FIXATION_ICON sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-FIXATION_TXT sy-vline
WA_/SCMTMS/S_UI_PLN_FO_RAIL_TREE_STR-DOCUMENT_ID sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.