/GBTRV/S_TER_SCHEMA SAP (TER Collection: Customizing - Schema) Structure details

Dictionary Type: Structure
Description: TER Collection: Customizing - Schema




ABAP Code to SELECT data from /GBTRV/S_TER_SCHEMA
Related tables to /GBTRV/S_TER_SCHEMA
Access table /GBTRV/S_TER_SCHEMA




Structure field list including key, data, relationships and ABAP select examples

/GBTRV/S_TER_SCHEMA is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "TER Collection: Customizing - Schema" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_/GBTRV/S_TER_SCHEMA TYPE /GBTRV/S_TER_SCHEMA.

The /GBTRV/S_TER_SCHEMA table consists of various fields, each holding specific information or linking keys about TER Collection: Customizing - Schema data available in SAP. These include FILTERDATE (), TRIP_PROV_VAR (Trip Provision Variant), T_SCHEMA (Trip Schema), DOM_INT_NODIS (Domestic/International/No Distinction).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP /GBTRV/S_TER_SCHEMA structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
EMPLOYEENUMBEREmployee Number /GBTRV/TER_EMPLOYEENUMBERNUMC8PERNR
FILTERDATE 0
TRIP_PROV_VARTrip Provision Variant /GBTRV/TER_C_SCM_TRIP_PROV_VARCHAR2
T_SCHEMATrip Schema /GBTRV/TER_C_SCM_T_SCHEMACHAR2
DOM_INT_NODISDomestic/International/No Distinction /GBTRV/TER_C_SCM_DOM_INT_NODISCHAR1
COUNTRYTrip Country / Trip Country Group /GBTRV/TER_C_SCM_COUNTRYCHAR3
MULT_DAY_TRIPMultiday Trip /GBTRV/TER_C_SCM_MULT_DAY_TRIPCHAR1
BORDER_CROSSBorder Crossing Entry for Trip Out /GBTRV/TER_C_SCM_BORDER_CROSSCHAR1
BREAK_DEEntry of Breakfast Deduction /GBTRV/TER_C_SCM_BREAK_DECHAR1
MEAL_COUPONEntry of Meals Coupon /GBTRV/TER_C_SCM_MEAL_COUPONCHAR1
MILE_DISTMiles/Km Distribution for Trip /GBTRV/TER_C_SCM_MILE_DISTCHAR1
MULT_DESTDefault value: several destinations /GBTRV/TER_C_SCM_MULT_DESTCHAR1
PD_FOODPer Diem Settlement for Meals /GBTRV/TER_C_SCM_PD_FOODCHAR1
TT_COMSPTrip Type: Enterprise-Specific /GBTRV/TER_C_SCM_TT_COMSPCHAR1
TRIP_ASSIGNNumber Assignment for Trip Number (Internal/External) /GBTRV/TER_C_SCM_TRIP_ASSIGNCHAR1
REGIONTrip Country/Trip Country Group/Trip Region /GBTRV/TER_C_SCM_REGIONCHAR5
TT_STATUTrip Type: Statutory /GBTRV/TER_C_SCM_TT_STATUCHAR1
T_ACTYPETrip Activity Type /GBTRV/TER_C_SCM_T_ACTYPECHAR1
RCPT_SCRTrip Receipts /GBTRV/TER_C_SCM_RCPT_SCRCHAR1
R_ADDINFO_SRCAdditional Receipt Information /GBTRV/TER_C_SCM_R_ADDINFO_SRCCHAR1
FOOD_DE_SCRTrip Meals Deductions /GBTRV/TER_C_SCM_FOOD_DE_SCRCHAR1
ADVANCES_SCRTrip Advances /GBTRV/TER_C_SCM_ADVANCES_SCRCHAR1
STOPOVER_SCRTrip Stopovers /GBTRV/TER_C_SCM_STOPOVER_SCRCHAR1
TRIP_CA_SCRCost Assignment for Entire Trip /GBTRV/TER_C_SCM_TRIP_CA_SCRCHAR1
RCPT_CA_SCRReceipt Cost Assignment /GBTRV/TER_C_SCM_RCPT_CA_SCRCHAR1
STPOVR_CA_SCRStopover Cost Assignment /GBTRV/TER_C_SCM_STPOVR_CA_SCRCHAR1
MILE_CA_SCRMiles/Kilometers Cost Assignment /GBTRV/TER_C_SCM_MILE_CA_SCRCHAR1
CA_OVRVIEW_SCCost Assignment Overview /GBTRV/TER_C_SCM_CA_OVRVIEW_SCCHAR1
TRIP_CHNG_SCRTrip History /GBTRV/TER_C_SCM_TRIP_CHNG_SCRCHAR1
ADDINFO_SCRAdditional Trip Information /GBTRV/TER_C_SCM_ADDINFO_SCRCHAR1
CUSTOMER_SCRUser Data of Trip /GBTRV/TER_C_SCM_CUSTOMER_SCRCHAR1
MESSAGE_IDMessage Class /GBTRV/TER_C_SCM_MESSAGE_IDCHAR20
MESSAGE_NOMessage Number /GBTRV/TER_C_SCM_MESSAGE_NONUMC3
FLIGHTIndicator for Entry of Flight Times in Dialog /GBTRV/TER_C_SCM_FLIGHTCHAR1
MULT_TRIP_DAYMore Than One Business Trip Per Day /GBTRV/TER_C_SCM_MULT_TRIP_DAYCHAR1
ACCOM_SCRTrip Accommodations Deductions /GBTRV/TER_C_SCM_ACCOM_SCRCHAR1
ADDINFO_MILEAdditional Trip Segment Information /GBTRV/TER_C_SCM_ADDINFO_MILECHAR1
SHORTTXTName for trip schema /GBTRV/TER_C_SCM_SHORTTXTCHAR30
VALID_TOEnd Date /GBTRV/TER_C_SCM_VALID_TODATS8
OTH_EXPIndicator for Receipt Settlement Without Trip /GBTRV/TER_C_SCM_OTH_EXPCHAR1
ADDR_DESTEnter Addresses for Trip Destinations /GBTRV/TER_C_SCM_ADDR_DESTCHAR1
ADDR_MILEAGEEnter Addresses for Legs of Trips /GBTRV/TER_C_SCM_ADDR_MILEAGECHAR1
COMPUTE_DISTCalculate Distance /GBTRV/TER_C_SCM_COMPUTE_DISTCHAR1
REQ_SERVICESTravel Services Entered in Travel Request (Indicator) /GBTRV/TER_C_SCM_REQ_SERVICESCHAR1

Key field Non-key field



How do I retrieve data from SAP structure /GBTRV/S_TER_SCHEMA using ABAP code?

As /GBTRV/S_TER_SCHEMA is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on /GBTRV/S_TER_SCHEMA as there is no data to select.

How to access SAP table /GBTRV/S_TER_SCHEMA

Within an ECC or HANA version of SAP you can also view further information about /GBTRV/S_TER_SCHEMA and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!