ABAP Select data from SAP table FTPS_WEB_ITEM_SERVICE 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 FTPS_WEB_ITEM_SERVICE 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 FTPS_WEB_ITEM_SERVICE. 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 FTPS_WEB_ITEM_SERVICE 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_FTPS_WEB_ITEM_SERVICE TYPE STANDARD TABLE OF FTPS_WEB_ITEM_SERVICE,
WA_FTPS_WEB_ITEM_SERVICE TYPE FTPS_WEB_ITEM_SERVICE,
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: <FTPS_WEB_ITEM_SERVICE> TYPE FTPS_WEB_ITEM_SERVICE.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_FTPS_WEB_ITEM_SERVICE.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM FTPS_WEB_ITEM_SERVICE
INTO TABLE IT_FTPS_WEB_ITEM_SERVICE.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM FTPS_WEB_ITEM_SERVICE
* INTO TABLE @DATA(IT_FTPS_WEB_ITEM_SERVICE2).
*--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_FTPS_WEB_ITEM_SERVICE INDEX 1 INTO DATA(WA_FTPS_WEB_ITEM_SERVICE2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_FTPS_WEB_ITEM_SERVICE ASSIGNING <FTPS_WEB_ITEM_SERVICE>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<FTPS_WEB_ITEM_SERVICE>-ITEM = 1.
<FTPS_WEB_ITEM_SERVICE>-SERVICE = 1.
<FTPS_WEB_ITEM_SERVICE>-REAL_CAT = 1.
<FTPS_WEB_ITEM_SERVICE>-REAL_CAT_TEXT = 1.
<FTPS_WEB_ITEM_SERVICE>-CATEGORY = 1.
ENDLOOP. LOOP AT IT_FTPS_WEB_ITEM_SERVICE INTO WA_FTPS_WEB_ITEM_SERVICE. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_FTPS_WEB_ITEM_SERVICE-CATEGORY_TEXT, sy-vline,
WA_FTPS_WEB_ITEM_SERVICE-REASON_CODE, sy-vline,
WA_FTPS_WEB_ITEM_SERVICE-REASON_TEXT, sy-vline,
WA_FTPS_WEB_ITEM_SERVICE-REASON_CODE_TEXT, sy-vline,
WA_FTPS_WEB_ITEM_SERVICE-STATUS, sy-vline,
WA_FTPS_WEB_ITEM_SERVICE-STATUS_TEXT, sy-vline.
ENDLOOP. *Add any further fields from structure WA_FTPS_WEB_ITEM_SERVICE 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_FTPS_WEB_ITEM_SERVICE 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_FTPS_WEB_ITEM_SERVICE INTO WA_FTPS_WEB_ITEM_SERVICE. *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 FMCTP, internal->external for field PROPERTY CALL FUNCTION 'CONVERSION_EXIT_FMCTP_OUTPUT' EXPORTING input = WA_FTPS_WEB_ITEM_SERVICE-PROPERTY IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_FTPS_WEB_ITEM_SERVICE-PROPERTY.
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_FTPS_WEB_ITEM_SERVICE_STR,
ITEM TYPE STRING,
SERVICE TYPE STRING,
REAL_CAT TYPE STRING,
REAL_CAT_TEXT TYPE STRING,
CATEGORY TYPE STRING,
CATEGORY_TEXT TYPE STRING,
REASON_CODE TYPE STRING,
REASON_TEXT TYPE STRING,
REASON_CODE_TEXT TYPE STRING,
STATUS TYPE STRING,
STATUS_TEXT TYPE STRING,
FF_TEXT TYPE STRING,
CONF_NUMBER_TEXT TYPE STRING,
MEMBERSHIP_TEXT TYPE STRING,
CANCELLATION_TEXT TYPE STRING,
PRICE_TEXT TYPE STRING,
ITEM_RATE_LOC TYPE STRING,
ITEM_CURR_LOC TYPE STRING,
REF_ITEM TYPE STRING,
COUNTRY_BEG TYPE STRING,
COUNTRY_END TYPE STRING,
RES_SYSTEM TYPE STRING,
RES_SYSTEM_TEXT TYPE STRING,
EXCEEDING_FARE TYPE STRING,
EXCEEDING_FARE_C TYPE STRING,
AIRLINE TYPE STRING,
FLIGHT_NR TYPE STRING,
OP_AIRLINE TYPE STRING,
FLIGHT_HEADER_TEXT TYPE STRING,
DATE_DEP TYPE STRING,
TIME_DEP TYPE STRING,
LOC_DEP TYPE STRING,
DAY_DEP TYPE STRING,
TERM_DEP TYPE STRING,
GATE_DEP TYPE STRING,
DEP_LONG_TEXT TYPE STRING,
COUNTRY_DEP TYPE STRING,
COUNTRY_DEP_TEXT TYPE STRING,
DATE_DEP_GMT TYPE STRING,
TIME_DEP_GMT TYPE STRING,
DAY_DEP_GMT TYPE STRING,
DATE_ARR TYPE STRING,
TIME_ARR TYPE STRING,
LOC_ARR TYPE STRING,
DAY_ARR TYPE STRING,
TERM_ARR TYPE STRING,
GATE_ARR TYPE STRING,
ARR_LONG_TEXT TYPE STRING,
COUNTRY_ARR TYPE STRING,
COUNTRY_ARR_TEXT TYPE STRING,
DATE_ARR_GMT TYPE STRING,
TIME_ARR_GMT TYPE STRING,
DAY_ARR_GMT TYPE STRING,
CABIN TYPE STRING,
RBD TYPE STRING,
CABIN_TEXT TYPE STRING,
SEAT_TEXT TYPE STRING,
SEAT_STATUS_TEXT TYPE STRING,
SEAT_STATUS TYPE STRING,
ETIX_POSSIBLE TYPE STRING,
HOTEL_RES_SYSTEM TYPE STRING,
HOTEL TYPE STRING,
PROPERTY TYPE STRING,
HOTEL_NUMBER TYPE STRING,
LOC TYPE STRING,
HOTEL_NAME TYPE STRING,
HOTEL_CHAIN TYPE STRING,
HOTEL_LOCATION_TEXT TYPE STRING,
DATE_ARR_H TYPE STRING,
DATE_DEP_H TYPE STRING,
DAY_ARR_H TYPE STRING,
DAY_DEP_H TYPE STRING,
ROOM_LONG_TEXT TYPE STRING,
ADD_INFO_TEXT TYPE STRING,
HOTEL_ADDRESS_L1 TYPE STRING,
HOTEL_ADDRESS_L2 TYPE STRING,
HOTEL_PHONE TYPE STRING,
MEALS_TEXT TYPE STRING,
HOTEL_PRICE TYPE STRING,
HOTEL_RATE TYPE STRING,
HOTEL_CURRENCY TYPE STRING,
PROVIDER TYPE STRING,
PROVIDER_NAME TYPE STRING,
CAR_DESC_TEXT TYPE STRING,
DATE_BEG_C TYPE STRING,
TIME_BEG_C TYPE STRING,
LOC_BEG_C TYPE STRING,
DAY_BEG_C TYPE STRING,
PICKUP_LOCATION_TEXT_C TYPE STRING,
PICKUP_LOC_ADD_INFO_C TYPE STRING,
DATE_END_C TYPE STRING,
TIME_END_C TYPE STRING,
LOC_END_C TYPE STRING,
DAY_END_C TYPE STRING,
DROPOFF_LOCATION_TEXT_C TYPE STRING,
DROPOFF_LOC_ADD_INFO_C TYPE STRING,
CAR_TOTAL_RATE TYPE STRING,
CAR_CURRENCY TYPE STRING,
CAR_PICKUP_LOC TYPE STRING,
CAR_DROPOFF_LOC TYPE STRING,
CAR_CLASS TYPE STRING,
CAR_TYPE TYPE STRING,
CAR_TRANSMISSION TYPE STRING,
CAR_AIR_CONDITION TYPE STRING,
CAR_RATE_CODE TYPE STRING,
CAR_DELIVERY_ADDR TYPE STRING,
CAR_COLLECTION_ADDR TYPE STRING,
TRAIN_RES_SYSTEM_T TYPE STRING,
PROVIDER_T TYPE STRING,
TRAIN_NR_T TYPE STRING,
TRAIN_HEADER_TEXT_T TYPE STRING,
PRICE_T TYPE STRING,
PRICE_CURR_T TYPE STRING,
CLASS_TEXT_T TYPE STRING,
REBATE_TEXT_T TYPE STRING,
BAHNTIX_INFO_T TYPE STRING,
ORDER_NR_T TYPE STRING,
ORDER_PRICE_T TYPE STRING,
ORDER_PRICE_CURR_T TYPE STRING,
TICKET_1_INFO_T TYPE STRING,
TICKET_2_INFO_T TYPE STRING,
DATE_DEP_T TYPE STRING,
TIME_DEP_T TYPE STRING,
DAY_DEP_T TYPE STRING,
LOC_DEP_T TYPE STRING,
GATE_DEP_T TYPE STRING,
TRAIN_DEP_TEXT_T TYPE STRING,
DATE_ARR_T TYPE STRING,
TIME_ARR_T TYPE STRING,
DAY_ARR_T TYPE STRING,
LOC_ARR_T TYPE STRING,
GATE_ARR_T TYPE STRING,
TRAIN_ARR_TEXT_T TYPE STRING,
COACH_NR TYPE STRING,
SEAT_NR TYPE STRING,
SEAT_PRICE TYPE STRING,
SEAT_PRICE_CURR TYPE STRING,
RES_INFO_TEXT TYPE STRING,
SEAT_PRICE_TEXT TYPE STRING,
SUPPLEMENT TYPE STRING,
SUPPLEMENT_CURR TYPE STRING,
PROVIDER_TEXT TYPE STRING,
BASE_FARE_TEXT TYPE STRING,
TOTAL_FARE_TEXT TYPE STRING,
TAXES_FARE_TEXT TYPE STRING,
LOC_DEP_NAME TYPE STRING,
LOC_ARR_NAME TYPE STRING,
BASE_FARE TYPE STRING,
BASE_CURR TYPE STRING,
TOTAL_FARE TYPE STRING,
TOTAL_CURR TYPE STRING,
TAXES TYPE STRING,
TAXES_CURR TYPE STRING,
LOWER_FARE TYPE STRING,
LOWER_CURR TYPE STRING,
TICKET_LAST_DATE TYPE STRING,
CONNECTION_TAG TYPE STRING,
SERVICE_CODE_O TYPE STRING,
SERVICE_NAME_O TYPE STRING,
DATE_BEG_O TYPE STRING,
TIME_BEG_O TYPE STRING,
DAY_BEG_O TYPE STRING,
LOC_BEG_O TYPE STRING,
LOC_BEG_TEXT_O TYPE STRING,
DATE_END_O TYPE STRING,
TIME_END_O TYPE STRING,
DAY_END_O TYPE STRING,
LOC_END_O TYPE STRING,
LOC_END_TEXT_O TYPE STRING,
STATUS_O TYPE STRING,
CONF_NUMBER_O TYPE STRING,
COMMENT1_O TYPE STRING,
COMMENT2_O TYPE STRING,
PRICE_O TYPE STRING,
CURRENCY_O TYPE STRING,END OF T_EKKO_STR. DATA: WA_FTPS_WEB_ITEM_SERVICE_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_FTPS_WEB_ITEM_SERVICE_STR-ITEM sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SERVICE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-REAL_CAT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-REAL_CAT_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CATEGORY sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CATEGORY_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-REASON_CODE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-REASON_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-REASON_CODE_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-STATUS sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-STATUS_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-FF_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CONF_NUMBER_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-MEMBERSHIP_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CANCELLATION_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PRICE_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-ITEM_RATE_LOC sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-ITEM_CURR_LOC sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-REF_ITEM sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-COUNTRY_BEG sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-COUNTRY_END sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-RES_SYSTEM sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-RES_SYSTEM_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-EXCEEDING_FARE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-EXCEEDING_FARE_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-AIRLINE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-FLIGHT_NR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-OP_AIRLINE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-FLIGHT_HEADER_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_DEP sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_DEP sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_DEP sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_DEP sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TERM_DEP sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-GATE_DEP sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DEP_LONG_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-COUNTRY_DEP sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-COUNTRY_DEP_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_DEP_GMT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_DEP_GMT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_DEP_GMT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_ARR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_ARR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_ARR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_ARR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TERM_ARR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-GATE_ARR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-ARR_LONG_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-COUNTRY_ARR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-COUNTRY_ARR_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_ARR_GMT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_ARR_GMT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_ARR_GMT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CABIN sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-RBD sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CABIN_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SEAT_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SEAT_STATUS_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SEAT_STATUS sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-ETIX_POSSIBLE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_RES_SYSTEM sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PROPERTY sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_NUMBER sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_NAME sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_CHAIN sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_LOCATION_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_ARR_H sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_DEP_H sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_ARR_H sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_DEP_H sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-ROOM_LONG_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-ADD_INFO_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_ADDRESS_L1 sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_ADDRESS_L2 sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_PHONE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-MEALS_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_PRICE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_RATE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-HOTEL_CURRENCY sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PROVIDER sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PROVIDER_NAME sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_DESC_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_BEG_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_BEG_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_BEG_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_BEG_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PICKUP_LOCATION_TEXT_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PICKUP_LOC_ADD_INFO_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_END_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_END_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_END_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_END_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DROPOFF_LOCATION_TEXT_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DROPOFF_LOC_ADD_INFO_C sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_TOTAL_RATE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_CURRENCY sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_PICKUP_LOC sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_DROPOFF_LOC sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_CLASS sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_TYPE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_TRANSMISSION sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_AIR_CONDITION sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_RATE_CODE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_DELIVERY_ADDR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CAR_COLLECTION_ADDR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TRAIN_RES_SYSTEM_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PROVIDER_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TRAIN_NR_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TRAIN_HEADER_TEXT_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PRICE_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PRICE_CURR_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CLASS_TEXT_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-REBATE_TEXT_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-BAHNTIX_INFO_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-ORDER_NR_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-ORDER_PRICE_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-ORDER_PRICE_CURR_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TICKET_1_INFO_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TICKET_2_INFO_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_DEP_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_DEP_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_DEP_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_DEP_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-GATE_DEP_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TRAIN_DEP_TEXT_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_ARR_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_ARR_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_ARR_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_ARR_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-GATE_ARR_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TRAIN_ARR_TEXT_T sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-COACH_NR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SEAT_NR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SEAT_PRICE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SEAT_PRICE_CURR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-RES_INFO_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SEAT_PRICE_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SUPPLEMENT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SUPPLEMENT_CURR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PROVIDER_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-BASE_FARE_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TOTAL_FARE_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TAXES_FARE_TEXT sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_DEP_NAME sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_ARR_NAME sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-BASE_FARE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-BASE_CURR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TOTAL_FARE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TOTAL_CURR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TAXES sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TAXES_CURR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOWER_FARE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOWER_CURR sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TICKET_LAST_DATE sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CONNECTION_TAG sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SERVICE_CODE_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-SERVICE_NAME_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_BEG_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_BEG_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_BEG_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_BEG_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_BEG_TEXT_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DATE_END_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-TIME_END_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-DAY_END_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_END_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-LOC_END_TEXT_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-STATUS_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CONF_NUMBER_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-COMMENT1_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-COMMENT2_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-PRICE_O sy-vline
WA_FTPS_WEB_ITEM_SERVICE_STR-CURRENCY_O sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.