T706S SAP (Trip Schema) Table details
Dictionary Type: Table
Description: Trip Schema
Description: Trip Schema
Table field list including key, data, relationships and ABAP select examples
T706S is a standard SAP Table which is used to store Trip Schema data and is available within R/3 SAP systems depending on the version and release level.
The T706S table consists of various fields, each holding specific information or linking keys about Trip Schema data available in SAP. These include MOREI (Trip Provision Variant), SCHEM (Trip schema), INAUS (Domestic/International/No Distinction), RLAND (Trip Country / Trip Country Group).. 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: C - Customising table, maintenance only by custDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = T706T
SAP T706S table 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
MOREI | Trip Provision Variant | MOREI | CHAR | 2 | T702N | MOREI | MOR | ||
SCHEM | Trip schema | RSCHE | CHAR | 2 | RSCHE | ||||
INAUS | Domestic/International/No Distinction | INAUS | CHAR | 1 | INAUS | ||||
RLAND | Trip Country / Trip Country Group | LNDGR | CHAR | 3 | Assigned to domain | LNDGR | |||
EINME | Multiday Trip | REIME | CHAR | 1 | XFELD | ||||
ANKUN | Border Crossing Entry for Trip Out | ANKUN | CHAR | 1 | PTRV_ANKUN | ||||
FRUEH | Entry of Breakfast Deduction | FRUEH | CHAR | 1 | XFELD | ||||
ESBON | Entry of Meals Coupon | ESBON | CHAR | 1 | XFELD | ||||
KFZVE | Miles/Km Distribution for Trip | KFZVE | CHAR | 1 | XFELD | ||||
SPLIT | Default value: several destinations | REISP | CHAR | 1 | XFELD | ||||
VERPF | Per Diem Settlement for Meals | VERPF_D | CHAR | 1 | XFELD | ||||
BEREI | Trip Type: Enterprise-Specific | BEREI | CHAR | 1 | T702X | BEREI | |||
NUMRV | Number Assignment for Trip Number (Internal/External) | NUMRV | CHAR | 1 | NUMRV | ||||
RGION | Trip Country/Trip Country Group/Trip Region | RGION | CHAR | 5 | T702O | RGION | |||
KZREA | Trip Type: Statutory | KZREA | CHAR | 1 | T702G | KZREA | |||
KZTKT | Trip Activity Type | KZTKT | CHAR | 1 | T702R | KZTKT | |||
D1300 | Trip Receipts | PTRV_D1300 | CHAR | 1 | XFELD | ||||
D1310 | Additional Receipt Information | PTRV_D1310 | CHAR | 1 | XFELD | ||||
D1400 | Trip Meals Deductions | PTRV_D1400 | CHAR | 1 | XFELD | ||||
D1500 | Trip Advances | PTRV_D1500 | CHAR | 1 | XFELD | ||||
D1600 | Trip Stopovers | PTRV_D1600 | CHAR | 1 | XFELD | ||||
D1700 | Cost Assignment for Entire Trip | PTRV_D1700 | CHAR | 1 | XFELD | ||||
D1701 | Receipt Cost Assignment | PTRV_D1701 | CHAR | 1 | XFELD | ||||
D1702 | Stopover Cost Assignment | PTRV_D1702 | CHAR | 1 | XFELD | ||||
D1703 | Miles/Kilometers Cost Assignment | PTRV_D1703 | CHAR | 1 | XFELD | ||||
D1709 | Cost Assignment Overview | PTRV_D1709 | CHAR | 1 | XFELD | ||||
D1950 | Trip History | PTRV_D1950 | CHAR | 1 | XFELD | ||||
D1960 | Additional Trip Information | PTRV_D1960 | CHAR | 1 | XFELD | ||||
D9999 | User Data of Trip | PTRV_D9999 | CHAR | 1 | XFELD | ||||
MSGID | Application Area | ARBGB | CHAR | 20 | T100A | ARBGB | MAG | ||
MSGNO | System Message Number | MSGNO | CHAR | 3 | T100 | MSGNR | |||
FLIGHT | Indicator for Entry of Flight Times in Dialog | FLIGHT_TIMES | CHAR | 1 | XFELD | ||||
MEREI | More Than One Business Trip Per Day | MEREI | CHAR | 1 | XFELD | ||||
D1400_UNTER | Trip Accommodations Deductions | PTRV_D1400_UNTER | CHAR | 1 | XFELD | ||||
ADDINFO_KM | Additional Trip Segment Information | ADDINFO_KM | CHAR | 1 | XFELD | ||||
D9999_CUST_TEXT | Customizable Function Text for Calling User Screen 9999 | PTRV_D9999_CUST_TEXT | CHAR | 30 | REITX | ||||
VALID_TO | End Date | ENDDA | DATS | 8 | DATUM | ||||
UEPKZ | Per Diem Settlement of Accommodations | UEPKZ_D | CHAR | 1 | XFELD | ||||
OTH_EXP | Indicator for Receipt Settlement Without Trip | PTRV_OTHER_EXPENSES | CHAR | 1 | XFELD | ||||
ADDR_DEST | Enter Addresses for Trip Destinations | ADDR_DEST | CHAR | 1 | XFELD | ||||
ADDR_MILEAGE | Enter Addresses for Legs of Trips | ADDR_MILEAGE | CHAR | 1 | XFELD | ||||
COMPUTE_DIST | Calculate Distance | COMPUTE_DIST | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
SCHEM_PS_RE | Trip schema | RSCHE | CHAR | 2 | Assigned to domain | RSCHE | |||
SCHEM_PS_AN | Trip schema | RSCHE | CHAR | 2 | Assigned to domain | RSCHE | |||
SCHEM_PS_VERW | Use of Schema in Public Sector | SCHEM_PS_VERW | CHAR | 1 | SCHEM_PS_VERW | ||||
NO_TAX_CHAIN | Automatic Taxation of Trip Chains | PTRV_NO_TAX_CHAIN | CHAR | 1 | XFELD | ||||
.INCLU--AP | 0 | ||||||||
REQUEST_SERVICES | Travel Services Entered in Travel Request (Indicator) | REQ_SERVICES | CHAR | 1 | XFELD | ||||
TRIP_BREAK | Trip Break | TRIP_BREAK | CHAR | 1 | XFELD | ||||
D2100 | Transport | GLO_PTRV_D2100 | CHAR | 1 | XFELD | ||||
EXCHANGE_DATE | Default Value for Reference Date | GLO_PTRV_REF_DATE_DEFAULT | CHAR | 1 | GLO_PTRV_REF_DATE_DEFAULT | ||||
TRIP_BREAK_CNTRY | Entry of Country for Trip Break | PTRV_TRIP_BREAK_COUNTRY_ENABLE | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table T706S using ABAP code
The following ABAP code Example will allow you to do a basic selection on T706S to SELECT all data from the tableDATA: WA_T706S TYPE T706S.
SELECT SINGLE *
FROM T706S
INTO CORRESPONDING FIELDS OF WA_T706S
WHERE...
How to access SAP table T706S
Within an ECC or HANA version of SAP you can also view further information about T706S and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects