SAP table T706S (Trip Schema)

SAP table T706S has 3 primary key fields being MANDT,MOREI,SCHEM.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MOREI Trip Provision Variant CHAR 2 0 T702N MOREI
SCHEM Trip Schema CHAR 2 0 RSCHE
INAUS Domestic/International/No Distinction CHAR 1 0 INAUS
A Trip Abroad
B No Distinction
I Domestic Trip
RLAND Trip Country / Trip Country Group CHAR 3 0 LNDGR
EINME Multiday Trip CHAR 1 0 REIME
ANKUN Border Crossing Entry for Trip Out CHAR 1 0 ANKUN
FRUEH Entry of Breakfast Deduction CHAR 1 0 FRUEH
ESBON Entry of Meals Coupon CHAR 1 0 ESBON
KFZVE Miles/Km Distribution for Trip CHAR 1 0 KFZVE
SPLIT Default value: several destinations CHAR 1 0 REISP
VERPF Per Diem Settlement for Meals CHAR 1 0 VERPF_D
BEREI Trip Type: Enterprise-Specific CHAR 1 0 T702X BEREI
NUMRV Number Assignment for Trip Number (Internal/External) CHAR 1 0 NUMRV
E External number assignment
I Internal number assignment
RGION Trip Country/Trip Country Group/Trip Region CHAR 5 0 T702O RGION
KZREA Trip Type: Statutory CHAR 1 0 T702G KZREA
KZTKT Trip Activity Type CHAR 1 0 T702R KZTKT
D1300 Trip Receipts CHAR 1 0 PTRV_D1300
D1310 Additional Receipt Information CHAR 1 0 PTRV_D1310
D1400 Trip Meals Deductions CHAR 1 0 PTRV_D1400
D1500 Trip Advances CHAR 1 0 PTRV_D1500
D1600 Trip Stopovers CHAR 1 0 PTRV_D1600
D1700 Cost Assignment for Entire Trip CHAR 1 0 PTRV_D1700
D1701 Receipt Cost Assignment CHAR 1 0 PTRV_D1701
D1702 Stopover Cost Assignment CHAR 1 0 PTRV_D1702
D1703 Miles/Kilometers Cost Assignment CHAR 1 0 PTRV_D1703
D1709 Cost Assignment Overview CHAR 1 0 PTRV_D1709
D1950 Trip History CHAR 1 0 PTRV_D1950
D1960 Additional Trip Information CHAR 1 0 PTRV_D1960
D9999 User Data of Trip CHAR 1 0 PTRV_D9999
MSGID Application Area CHAR 20 0 T100A ARBGB
MSGNO System Message Number CHAR 3 0 T100 MSGNO
FLIGHT Indicator for Entry of Flight Times in Dialog CHAR 1 0 FLIGHT_TIMES
MEREI More Than One Business Trip Per Day CHAR 1 0 MEREI
D1400_UNTER Trip Accommodations Deductions CHAR 1 0 PTRV_D1400_UNTER
ADDINFO_KM Additional Trip Segment Information CHAR 1 0 ADDINFO_KM
D9999_CUST_TEXT Customizable Function Text for Calling User Screen 9999 CHAR 30 0 PTRV_D9999_CUST_TEXT
VALID_TO End Date DATS 8 0 ENDDA
UEPKZ Per Diem Settlement of Accommodations CHAR 1 0 UEPKZ_D
OTH_EXP Indicator for Receipt Settlement Without Trip CHAR 1 0 PTRV_OTHER_EXPENSES
ADDR_DEST Enter Addresses for Trip Destinations CHAR 1 0 ADDR_DEST
ADDR_MILEAGE Enter Addresses for Legs of Trips CHAR 1 0 ADDR_MILEAGE
COMPUTE_DIST Calculate Distance CHAR 1 0 COMPUTE_DIST
SCHEM_PS_RE Trip Schema CHAR 2 0 RSCHE
SCHEM_PS_AN Trip Schema CHAR 2 0 RSCHE
SCHEM_PS_VERW Use of Schema in Public Sector CHAR 1 0 SCHEM_PS_VERW
No Special Meaning
A Temporary Assignment Within Temporary Assignment
I Trips Abroad and Domestic Trips for Austria
NO_TAX_CHAIN Automatic Taxation of Trip Chains CHAR 1 0 PTRV_NO_TAX_CHAIN
REQUEST_SERVICES Travel Services Entered in Travel Request (Indicator) CHAR 1 0 REQ_SERVICES
TRIP_BREAK Trip Break CHAR 1 0 TRIP_BREAK
D2100 Transport CHAR 1 0 GLO_PTRV_D2100
EXCHANGE_DATE Default Value for Reference Date CHAR 1 0 GLO_PTRV_REF_DATE_DEFAULT
0 System Date
1 First Day of Trip
2 Last Day of Trip
3 Border Crossing Out
4 Border Crossing Return
5 First Day of Month (for First Day of Trip)
A Advance/First Day of Trip
B Advance/Last Day of Trip
C Advance/Border Crossing Out
D Advance/Border Crossing Return
TRIP_BREAK_CNTRY Entry of Country for Trip Break CHAR 1 0 PTRV_TRIP_BREAK_COUNTRY_ENABLE
START_ABROAD Trip Starts Abroad CHAR 1 0 PTRV_PS_START_ABROAD

T706S foreign key relationships

Table Field Check Table Check Field
0 T706S BEREI T702X Enterprise-specific Trip Types MOREI
1 T706S KZREA T702G Statutory trip types MANDT
1 T706S KZREA T702G Statutory trip types MOREI
1 T706S KZREA T702G Statutory trip types KZREA
0 T706S KZTKT T702R Trip Activity Types MANDT
0 T706S KZTKT T702R Trip Activity Types MOREI
0 T706S KZTKT T702R Trip Activity Types KZTKT
1 T706S MOREI T702N Trip Provision Variants MOREI
0 T706S MSGID T100A Message IDs for T100 ARBGB
1 T706S MSGNO T100 Messages SPRSL
1 T706S MSGNO T100 Messages ARBGB
1 T706S MSGNO T100 Messages MSGNR
0 T706S RGION T702O Trip country/Trip region/Trip country group MOREI
0 T706S RGION T702O Trip country/Trip region/Trip country group LAND1
0 T706S RGION T702O Trip country/Trip region/Trip country group RGION