ABAP Select data from SAP table MTR_S_TRAVEL_REQUEST 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 MTR_S_TRAVEL_REQUEST 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 MTR_S_TRAVEL_REQUEST. 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 MTR_S_TRAVEL_REQUEST 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_MTR_S_TRAVEL_REQUEST TYPE STANDARD TABLE OF MTR_S_TRAVEL_REQUEST,
WA_MTR_S_TRAVEL_REQUEST TYPE MTR_S_TRAVEL_REQUEST,
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: <MTR_S_TRAVEL_REQUEST> TYPE MTR_S_TRAVEL_REQUEST.
*Process all fields in table header/work area as string values
PERFORM process_as_string_field_values CHANGING wa_MTR_S_TRAVEL_REQUEST.
SELECT *
*restrict ABAP select to first 10 rows
UP TO 10 ROWS
FROM MTR_S_TRAVEL_REQUEST
INTO TABLE IT_MTR_S_TRAVEL_REQUEST.
*Select data and declare internal table using in-line method @DATA
*SELECT *
* FROM MTR_S_TRAVEL_REQUEST
* INTO TABLE @DATA(IT_MTR_S_TRAVEL_REQUEST2).
*--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_MTR_S_TRAVEL_REQUEST INDEX 1 INTO DATA(WA_MTR_S_TRAVEL_REQUEST2).
*Demonstrate how to loop at an internal table and update values using a FIELD-SYMBOL
LOOP AT IT_MTR_S_TRAVEL_REQUEST ASSIGNING <MTR_S_TRAVEL_REQUEST>.
*To update a field value using a field symbol simply change the value via the field symbol pointer<MTR_S_TRAVEL_REQUEST>-PERNR = 1.
<MTR_S_TRAVEL_REQUEST>-TRIPNO = 1.
<MTR_S_TRAVEL_REQUEST>-STATUS_CRITICALITY = 1.
<MTR_S_TRAVEL_REQUEST>-PERSISTENCESTATUS = 1.
<MTR_S_TRAVEL_REQUEST>-APPROVERNAME = 1.
ENDLOOP. LOOP AT IT_MTR_S_TRAVEL_REQUEST INTO WA_MTR_S_TRAVEL_REQUEST. *Write horizonal line to screen report. WRITE:/ sy-uline. *Write selected data to screen/report before conversion. WRITE:/ sy-vline, WA_MTR_S_TRAVEL_REQUEST-APPROVERID, sy-vline,
WA_MTR_S_TRAVEL_REQUEST-TRAVELERNAME, sy-vline,
WA_MTR_S_TRAVEL_REQUEST-MAINDESTINATIONFULLNAME, sy-vline,
WA_MTR_S_TRAVEL_REQUEST-ATTACHMENTEDITABLE, sy-vline,
WA_MTR_S_TRAVEL_REQUEST-EDITABLE, sy-vline,
WA_MTR_S_TRAVEL_REQUEST-DELETABLE, sy-vline.
ENDLOOP. *Add any further fields from structure WA_MTR_S_TRAVEL_REQUEST 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_MTR_S_TRAVEL_REQUEST 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_MTR_S_TRAVEL_REQUEST INTO WA_MTR_S_TRAVEL_REQUEST. *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 ADRNRADR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_MTR_S_TRAVEL_REQUEST-ADRNRADR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MTR_S_TRAVEL_REQUEST-ADRNRADR.
WRITE:/ 'New Value:', ld_input.
*Conversion exit ALPHA, internal->external for field CITY_CODEADR CALL FUNCTION 'CONVERSION_EXIT_ALPHA_OUTPUT' EXPORTING input = WA_MTR_S_TRAVEL_REQUEST-CITY_CODEADR IMPORTING output = ld_input.
WRITE:/ 'Org Value:', WA_MTR_S_TRAVEL_REQUEST-CITY_CODEADR.
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_MTR_S_TRAVEL_REQUEST_STR,
PERNR TYPE STRING,
TRIPNO TYPE STRING,
STATUS_CRITICALITY TYPE STRING,
PERSISTENCESTATUS TYPE STRING,
APPROVERNAME TYPE STRING,
APPROVERID TYPE STRING,
TRAVELERNAME TYPE STRING,
MAINDESTINATIONFULLNAME TYPE STRING,
ATTACHMENTEDITABLE TYPE STRING,
EDITABLE TYPE STRING,
DELETABLE TYPE STRING,
DISPLAY_MODE TYPE STRING,
EDIT_VISIBLE TYPE STRING,
SAVE_DRAFT TYPE STRING,
DRAFT_LINK_TYPE TYPE STRING,
DRAFT_LINK_VISIBLE TYPE STRING,
DRAFT_USER_ID TYPE STRING,
TRIP_START TYPE STRING,
TRIP_END TYPE STRING,
TRIP_CHANGE TYPE STRING,
FM_POSTING_DATE TYPE STRING,
PLANNING_ENABLE TYPE STRING,
STATUS TYPE STRING,
STATUS_NAME TYPE STRING,
TOTAL_COST TYPE STRING,
TOTAL_COST_CURR TYPE STRING,
PLAN_ACTIVITY_TYPE_NAME TYPE STRING,
DATEDEP TYPE STRING,
TIMEDEP TYPE STRING,
DATEARR TYPE STRING,
TIMEARR TYPE STRING,
CUSTOMER TYPE STRING,
LOCATION TYPE STRING,
COUNTRY TYPE STRING,
REGION TYPE STRING,
DATEOUT TYPE STRING,
TIMEOUT TYPE STRING,
DATEFAR TYPE STRING,
TIMEFAR TYPE STRING,
DATEFDP TYPE STRING,
TIMEFDP TYPE STRING,
DATERET TYPE STRING,
TIMERET TYPE STRING,
RET_COUN TYPE STRING,
RET_RGIO TYPE STRING,
RET_TTCS TYPE STRING,
T_SCHEMA TYPE STRING,
TT_COMSP TYPE STRING,
TT_STATU TYPE STRING,
T_ACTYPE TYPE STRING,
PD_MEALS TYPE STRING,
PD_ACCOM TYPE STRING,
NO_NIGHT TYPE STRING,
ACT_NIGHTS TYPE STRING,
MAX_NIGHTS TYPE STRING,
MILES TYPE STRING,
VEH_TYPE TYPE STRING,
VEH_CLAS TYPE STRING,
PLAN_ACTIVITY_TYPE TYPE STRING,
ESTIMATED_COST TYPE STRING,
ESTIMATED_COST_CURR TYPE STRING,
PAY_CURR TYPE STRING,
REQUEST TYPE STRING,
TRAVEL_PLAN TYPE STRING,
EXPENSES TYPE STRING,
PRINT_STATUS TYPE STRING,
APPVL_STATUS TYPE STRING,
SETTL_STATUS TYPE STRING,
FIN_STATUS TYPE STRING,
PAY_STATUS TYPE STRING,
DME_STATUS TYPE STRING,
COUNTRY_GRP TYPE STRING,
TP_VARIANT TYPE STRING,
DATESET TYPE STRING,
TIMESET TYPE STRING,
RUNID TYPE STRING,
NO_MILES TYPE STRING,
TLOCK TYPE STRING,
DATECHA TYPE STRING,
TIMECHA TYPE STRING,
UNAME TYPE STRING,
REPID TYPE STRING,
REMOVAL_COSTS TYPE STRING,
DEPT_OF_REIMB TYPE STRING,
DIFF_END_ALLW TYPE STRING,
DEPARTURE_WORK TYPE STRING,
ARRIVAL_WORK TYPE STRING,
RETURN_TO TYPE STRING,
NO_COMMENCEMENT_TRIP TYPE STRING,
NO_RETURN_TRIP TYPE STRING,
DATEDPE TYPE STRING,
TIMEDPE TYPE STRING,
DATEAPE TYPE STRING,
TIMEAPE TYPE STRING,
ST_TAX_PD TYPE STRING,
ST_TAX_ALL TYPE STRING,
DAT_REDUC1 TYPE STRING,
DAT_REDUC2 TYPE STRING,
DATECOW TYPE STRING,
TIMECOW TYPE STRING,
DATEEOW TYPE STRING,
TIMEEOW TYPE STRING,
ASSO_SU_SEP_ALLO TYPE STRING,
SA_TAX_TYP TYPE STRING,
SA_TAX_HOUSING TYPE STRING,
DR_NO_O_A_R_TRIP TYPE STRING,
DR_NO_O_O_R_TRIP TYPE STRING,
DR_DIST_TO_WORKP TYPE STRING,
OC_NO_O_A_R_TRIP_B_MOVE TYPE STRING,
OC_NO_O_O_R_TRIP_B_MOVE TYPE STRING,
OC_DIST_TO_WORKP_B_MOVE TYPE STRING,
OC_KM_RATE_WORKP_B_MOVE TYPE STRING,
OC_NO_O_A_R_TRIP_A_MOVE TYPE STRING,
OC_NO_O_O_R_TRIP_A_MOVE TYPE STRING,
OC_DIST_TO_WORKP_A_MOVE TYPE STRING,
OC_KM_RATE_WORKP_A_MOVE TYPE STRING,
GRAT_MEALS_PER_MONTH TYPE STRING,
GRAT_ACCMM_PER_MONTH TYPE STRING,
REIMB_GRP_DEDUCTN_PD TYPE STRING,
PERM_TRIP_APPR TYPE STRING,
GWE TYPE STRING,
EDI TYPE STRING,
CARRY_OTH TYPE STRING,
CARRIED_BY_OTH TYPE STRING,
INCR_MAX_TRIPSEG_REIMB TYPE STRING,
NO_REIMB TYPE STRING,
PER_DIEM_DEDUC_INTL TYPE STRING,
SHORT_DIST TYPE STRING,
THIRD_PARTY_PAYM TYPE STRING,
SEP_ALLO_ANTR_RUECK TYPE STRING,
PER_DIEM_DEDUC_ACC TYPE STRING,
EXCL_PERIOD_EXC TYPE STRING,
DURATION_TRIP_BREAKS TYPE STRING,
ADRNRADR TYPE STRING,
CITYADR TYPE STRING,
CITY_DISTRICTADR TYPE STRING,
POST_CODEADR TYPE STRING,
CITY_CODEADR TYPE STRING,
STREETADR TYPE STRING,
HOUSE_NUMADR TYPE STRING,
COUNTRYADR TYPE STRING,
REGIONADR TYPE STRING,
EDITOR TYPE STRING,
TAX_PER_DIEMTAX TYPE STRING,
TAX_PD_MANTAX TYPE STRING,
TAX_OV_MANTAX TYPE STRING,
EXCHANGE_DATE TYPE STRING,
ROUNDING TYPE STRING,
EST_COST_PLAN TYPE STRING,
EST_COST_REQ TYPE STRING,
REASON TYPE STRING,
TRIP_TOTAL TYPE STRING,
DIFF_EXP_PLAN TYPE STRING,
DIFF_EXP_REQ TYPE STRING,
DZ_LIMIT_180 TYPE STRING,
TAX_TRIP TYPE STRING,
PERIOD_NUMBER TYPE STRING,
PERIOD_TYPE TYPE STRING,
NEW_OFFICE TYPE STRING,
MIL_EDITOR TYPE STRING,
ADDR_DEPAR TYPE STRING,
ADDR_ARRVL TYPE STRING,
COUNTRY_REGION_NAME TYPE STRING,
RET_COUN_RGIO_NAME TYPE STRING,
RET_TTS_NAME TYPE STRING,
T_SCHEMA_NAME TYPE STRING,
TT_COMSP_NAME TYPE STRING,
TT_STATU_NAME TYPE STRING,
T_ACTYPE_NAME TYPE STRING,
PAY_CURR_NAME TYPE STRING,
REQUEST_NAME TYPE STRING,
TRAVEL_PLAN_NAME TYPE STRING,
EXPENSES_NAME TYPE STRING,
PRINT_STATUS_NAME TYPE STRING,
APPVL_STATUS_NAME TYPE STRING,
SETTL_STATUS_NAME TYPE STRING,
FIN_STATUS_NAME TYPE STRING,
PAY_STATUS_NAME TYPE STRING,
DME_STATUS_NAME TYPE STRING,
COUNTRY_GRP_NAME TYPE STRING,
TP_VARIANT_NAME TYPE STRING,
DEPARTURE_WORK_NAME TYPE STRING,
MULTIDAYTRIP TYPE STRING,
BORDERCROSSING TYPE STRING,
MILEAGECOSTASSIGNMENT TYPE STRING,
HIDDEN_TRIPCOST_ASSIGNMENT TYPE STRING,
DETAILED_ADDRESSES TYPE STRING,
MILEAGEADDRESS TYPE STRING,
DETAILEDMILEAGEADDRESS TYPE STRING,
HIDDEN_ADDITIONAL_DESTINATIONS TYPE STRING,
TRIP_BREAK TYPE STRING,
TRIP_BREAK_COUNTRY TYPE STRING,
HIDDEN_MILEAGES TYPE STRING,
DOMESTIC_INTERNATIONAL TYPE STRING,
TRIPSTOPOVER TYPE STRING,
HIDDEN_ADVANCES TYPE STRING,
HIDDEN_ESTIMATED_COSTS TYPE STRING,
HIDDEN_TRAVEL_SERVICES TYPE STRING,
HIDDEN_PD_DEDUCTIONS TYPE STRING,
HIDDEN_ATTACHMENTS TYPE STRING,
HIDDEN_TRAVEL_PLANNING TYPE STRING,
HIDDEN_MILEAGE_COSTASSIGNMENT TYPE STRING,
HIDDEN_RECEIPT_COSTASSIGNMENT TYPE STRING,
HIDDEN_STOPOVER_COSTASSIGNMENT TYPE STRING,
DATEDEP_FC TYPE STRING,
TIMEDEP_FC TYPE STRING,
DATEARR_FC TYPE STRING,
TIMEARR_FC TYPE STRING,
CUSTOMER_FC TYPE STRING,
LOCATION_FC TYPE STRING,
COUNTRY_FC TYPE STRING,
REGION_FC TYPE STRING,
TT_COMSP_FC TYPE STRING,
TT_STATU_FC TYPE STRING,
T_ACTYPE_FC TYPE STRING,
PLAN_ACTIVITY_TYPE_FC TYPE STRING,
ESTIMATED_COST_FC TYPE STRING,
ESTIMATED_COST_CURR_FC TYPE STRING,
FM_POSTING_DATE_FC TYPE STRING,
DEPARTURE_WORK_FC TYPE STRING,
ARRIVAL_WORK_FC TYPE STRING,
DATECOW_FC TYPE STRING,
TIMECOW_FC TYPE STRING,
DATEEOW_FC TYPE STRING,
TIMEEOW_FC TYPE STRING,
CITYADR_FC TYPE STRING,
CITY_DISTRICTADR_FC TYPE STRING,
POST_CODEADR_FC TYPE STRING,
CITY_CODEADR_FC TYPE STRING,
STREETADR_FC TYPE STRING,
HOUSE_NUMADR_FC TYPE STRING,
COUNTRYADR_FC TYPE STRING,
REGIONADR_FC TYPE STRING,
EDITOR_FC TYPE STRING,
CARRY_OTH_FC TYPE STRING,
CARRIED_BY_OTH_FC TYPE STRING,
EXCHANGE_DATE_FC TYPE STRING,
ROUNDING_FC TYPE STRING,
PLAN_ACTIVITY_TYPE_NAME_FC TYPE STRING,
APPROVERNAME_FC TYPE STRING,
TT_COMSP_NAME_FC TYPE STRING,
TT_STATU_NAME_FC TYPE STRING,
T_ACTYPE_NAME_FC TYPE STRING,
DUMMY_REQUEST TYPE STRING,END OF T_EKKO_STR. DATA: WA_MTR_S_TRAVEL_REQUEST_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_MTR_S_TRAVEL_REQUEST_STR-PERNR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRIPNO sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-STATUS_CRITICALITY sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PERSISTENCESTATUS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-APPROVERNAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-APPROVERID sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRAVELERNAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-MAINDESTINATIONFULLNAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ATTACHMENTEDITABLE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EDITABLE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DELETABLE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DISPLAY_MODE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EDIT_VISIBLE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-SAVE_DRAFT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DRAFT_LINK_TYPE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DRAFT_LINK_VISIBLE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DRAFT_USER_ID sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRIP_START sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRIP_END sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRIP_CHANGE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-FM_POSTING_DATE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PLANNING_ENABLE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-STATUS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-STATUS_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TOTAL_COST sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TOTAL_COST_CURR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PLAN_ACTIVITY_TYPE_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEDEP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEDEP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEARR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEARR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CUSTOMER sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-LOCATION sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-COUNTRY sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REGION sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEOUT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEOUT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEFAR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEFAR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEFDP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEFDP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATERET sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMERET sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-RET_COUN sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-RET_RGIO sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-RET_TTCS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-T_SCHEMA sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TT_COMSP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TT_STATU sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-T_ACTYPE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PD_MEALS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PD_ACCOM sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-NO_NIGHT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ACT_NIGHTS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-MAX_NIGHTS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-MILES sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-VEH_TYPE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-VEH_CLAS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PLAN_ACTIVITY_TYPE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ESTIMATED_COST sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ESTIMATED_COST_CURR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PAY_CURR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REQUEST sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRAVEL_PLAN sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EXPENSES sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PRINT_STATUS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-APPVL_STATUS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-SETTL_STATUS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-FIN_STATUS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PAY_STATUS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DME_STATUS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-COUNTRY_GRP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TP_VARIANT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATESET sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMESET sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-RUNID sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-NO_MILES sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TLOCK sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATECHA sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMECHA sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-UNAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REPID sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REMOVAL_COSTS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DEPT_OF_REIMB sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DIFF_END_ALLW sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DEPARTURE_WORK sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ARRIVAL_WORK sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-RETURN_TO sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-NO_COMMENCEMENT_TRIP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-NO_RETURN_TRIP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEDPE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEDPE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEAPE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEAPE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ST_TAX_PD sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ST_TAX_ALL sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DAT_REDUC1 sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DAT_REDUC2 sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATECOW sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMECOW sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEEOW sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEEOW sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ASSO_SU_SEP_ALLO sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-SA_TAX_TYP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-SA_TAX_HOUSING sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DR_NO_O_A_R_TRIP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DR_NO_O_O_R_TRIP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DR_DIST_TO_WORKP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-OC_NO_O_A_R_TRIP_B_MOVE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-OC_NO_O_O_R_TRIP_B_MOVE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-OC_DIST_TO_WORKP_B_MOVE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-OC_KM_RATE_WORKP_B_MOVE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-OC_NO_O_A_R_TRIP_A_MOVE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-OC_NO_O_O_R_TRIP_A_MOVE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-OC_DIST_TO_WORKP_A_MOVE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-OC_KM_RATE_WORKP_A_MOVE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-GRAT_MEALS_PER_MONTH sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-GRAT_ACCMM_PER_MONTH sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REIMB_GRP_DEDUCTN_PD sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PERM_TRIP_APPR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-GWE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EDI sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CARRY_OTH sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CARRIED_BY_OTH sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-INCR_MAX_TRIPSEG_REIMB sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-NO_REIMB sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PER_DIEM_DEDUC_INTL sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-SHORT_DIST sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-THIRD_PARTY_PAYM sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-SEP_ALLO_ANTR_RUECK sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PER_DIEM_DEDUC_ACC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EXCL_PERIOD_EXC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DURATION_TRIP_BREAKS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ADRNRADR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CITYADR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CITY_DISTRICTADR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-POST_CODEADR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CITY_CODEADR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-STREETADR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HOUSE_NUMADR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-COUNTRYADR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REGIONADR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EDITOR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TAX_PER_DIEMTAX sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TAX_PD_MANTAX sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TAX_OV_MANTAX sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EXCHANGE_DATE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ROUNDING sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EST_COST_PLAN sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EST_COST_REQ sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REASON sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRIP_TOTAL sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DIFF_EXP_PLAN sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DIFF_EXP_REQ sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DZ_LIMIT_180 sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TAX_TRIP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PERIOD_NUMBER sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PERIOD_TYPE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-NEW_OFFICE sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-MIL_EDITOR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ADDR_DEPAR sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ADDR_ARRVL sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-COUNTRY_REGION_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-RET_COUN_RGIO_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-RET_TTS_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-T_SCHEMA_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TT_COMSP_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TT_STATU_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-T_ACTYPE_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PAY_CURR_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REQUEST_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRAVEL_PLAN_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EXPENSES_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PRINT_STATUS_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-APPVL_STATUS_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-SETTL_STATUS_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-FIN_STATUS_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PAY_STATUS_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DME_STATUS_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-COUNTRY_GRP_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TP_VARIANT_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DEPARTURE_WORK_NAME sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-MULTIDAYTRIP sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-BORDERCROSSING sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-MILEAGECOSTASSIGNMENT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_TRIPCOST_ASSIGNMENT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DETAILED_ADDRESSES sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-MILEAGEADDRESS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DETAILEDMILEAGEADDRESS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_ADDITIONAL_DESTINATIONS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRIP_BREAK sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRIP_BREAK_COUNTRY sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_MILEAGES sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DOMESTIC_INTERNATIONAL sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TRIPSTOPOVER sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_ADVANCES sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_ESTIMATED_COSTS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_TRAVEL_SERVICES sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_PD_DEDUCTIONS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_ATTACHMENTS sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_TRAVEL_PLANNING sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_MILEAGE_COSTASSIGNMENT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_RECEIPT_COSTASSIGNMENT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HIDDEN_STOPOVER_COSTASSIGNMENT sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEDEP_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEDEP_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEARR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEARR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CUSTOMER_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-LOCATION_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-COUNTRY_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REGION_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TT_COMSP_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TT_STATU_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-T_ACTYPE_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PLAN_ACTIVITY_TYPE_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ESTIMATED_COST_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ESTIMATED_COST_CURR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-FM_POSTING_DATE_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DEPARTURE_WORK_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ARRIVAL_WORK_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATECOW_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMECOW_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DATEEOW_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TIMEEOW_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CITYADR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CITY_DISTRICTADR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-POST_CODEADR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CITY_CODEADR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-STREETADR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-HOUSE_NUMADR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-COUNTRYADR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-REGIONADR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EDITOR_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CARRY_OTH_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-CARRIED_BY_OTH_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-EXCHANGE_DATE_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-ROUNDING_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-PLAN_ACTIVITY_TYPE_NAME_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-APPROVERNAME_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TT_COMSP_NAME_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-TT_STATU_NAME_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-T_ACTYPE_NAME_FC sy-vline
WA_MTR_S_TRAVEL_REQUEST_STR-DUMMY_REQUEST sy-vline INTO ld_text SEPARATED BY SPACE. *Add any further fields from structure WA_EKKO_STR you want to CONCATENATE... ENDLOOP. ENDFORM.
