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