SAP table T706B1 (Travel Expense Types)

SAP table T706B1 has 4 primary key fields being MANDT,MOREI,SPKZL,ENDDA.

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
SPKZL Travel Expense Type CHAR 4 0 SPKZL
ENDDA End Date DATS 8 0 ENDDA
BEGDA Start Date DATS 8 0 BEGDA
BEART Travel Expense Category CHAR 1 0 BELAR
F Expenses for Private Car
K Cash Advance
M Meals
N Private Transportation
O Advance
S Other
T Public Transportation
U Accommodations
V Meals Itemization (Maximum Rate per Day)
PAUSH Travel Expense Type Individual or Per Diem/Flat Rate CHAR 1 0 PAUSH
Receipt
P PD/Flat rates
NBKKL Travel Expense Type - Permissibility CHAR 9 0 NBKKL
FIRMA Paid by Company CHAR 1 0 BEZFA
MWSKZ Tax on sales/purchases code CHAR 2 0 T007A MWSKZ
PR04O Use of Expense Type in Weekly Report/Business Trip CHAR 1 0 PR04O
For Bus. Trip, Weekly Rpt, and Sprtn Allowance/Duty Alloc.
D Only for Business Trip
R Only for Business Trip
T Only for Separation Allowance / Duty Allocation
W Only in weekly report
PR04X Sequence of Expense Types in Weekly Report CHAR 1 0 PR04X
A Line of expense type in weekly report
SCDV1 From date field control CHAR 1 0 SCDV1
SCDB1 To date field control CHAR 1 0 SCDB1
SCANZ Number field control CHAR 1 0 SCANZ
ANZCA Calculation of Default Value for Number Field CHAR 1 0 ANZCA
No calculation of default value
0 Difference in dates, but at least 1 day
1 Difference in dates plus 1 day
2 Difference in dates, but at least 1 day without deduction
3 Difference in dates plus one day, without deduction
SCLND Country/Region field control CHAR 1 0 SCLND
SCRAU Field control for enterprise-specific trip type CHAR 1 0 SCRAU
SCFRF Field control for number of breakfasts CHAR 1 0 SCFRF
SCDEC Description field control CHAR 1 0 SCDEC
SCPLA Field control: Place CHAR 1 0 SCPLA
SCBPU Field control for business purpose on receipt CHAR 1 0 SCBPU
SCBRE Field control for business partner CHAR 1 0 SCBRE
SCEDT Editor field control CHAR 1 0 SCEDT
GRUPN Travel Expense Type Grouping CHAR 1 0 T706B3 P_GRUPN
SCMER Field control for service provider CHAR 1 0 SCMER
USEFL Usage indicator of travel expense type CHAR 1 0 PTRV_USEFL
No Special Meaning of Expense Type
1 Special Expense Type for Capping Accommodations Receipts
2 Special Exp. Type for Allowance for Accommodations Receipts
3 Special Expense Type for Capping Mileage/Travel Costs (CC)
4 Special Expense Type for Own Share
5 Special Expense Type for Capping Subsidies for Trips Home
6 Special Expense Type: Capping Document Comparison Calc DR/ES
7 Special Expense Type for Identifying FSS Documents
8 Special Expense Type for Payment in Kind for Breakfast
9 Special Expense Type for Payment in Kind for Lunch
A Special Expense Type for Payment in Kind for Dinner
B Special Expense Type for Payment in Kind for All Meals
C Special Expense Type for Manually Capping Accomm. Receipts
D Special Expense Type for Capping Partial Mileage Reimbursem.
E Special Expense Type for Manually Capping Mileage Reimburs.
F Special Travel Costs
G Special Expense Type for Shipment Docs Incl. Overnight Stay
H Spec. Expense Type for Increase of Reimburs. for Trip Break
I Special Expense Type for Rental Costs of Accommodation
P Special Expense Type for Parking Receipts
Q Special Expense Type for Capping of Parking Receipts
V Special Expense Type for Capping Meals per Diem
W Special Expense Type for Subsidy to Meals per Diem
TAXBENEFIT Travel expense type for taxation only (additional amount) CHAR 1 0 PTRV_TAXBENEFIT
Reimbursement amount (payment, no taxation)
N Additional Amount (No Taxation, No Payment)
P Additional Amount (Taxation and Payment)
U Additional amount (taxation by employer, no payment)
X Additional amount (taxation, no payment)
SCDOC Field Control for (Paper) Document Number CHAR 1 0 SCDOC
SCPRV Field Control for Provider (Airline, Hotel Chain, ...) CHAR 1 0 SCPRV
P_CTG Provider Category CHAR 1 0 PROVIDER_CATEGORY
REWIZ Receipt Wizard CHAR 1 0 RECWIZ
No
X Yes
PREXP Expense Type Pay Back Private Share CHAR 4 0 PRVEXP
PREXC Expense Type Private Share Paid by Company CHAR 4 0 PRVEXC
SCSTF Field Control Number of Employees CHAR 1 0 SC_NO_STAFF
SCPTN Field Control Number of Employees of Business Partners CHAR 1 0 SC_NO_PARTNERS
SCGST Field Control Number of Additional Guests CHAR 1 0 SC_NO_GUESTS
EST_C Indicator for Expense Type Containing Estimated Costs CHAR 1 0 PTRV_ESTC
PRIVC Expense Type that Includes Private Costs (Indicator) CHAR 1 0 PTRV_PRIV
PRIEXP Expense Type for Private Shares CHAR 4 0 PRIEXP
SCENT Field Control for Participants in Entertainment Receipt CHAR 1 0 SCENT
SCFRA Field Control for Number of Dinners CHAR 1 0 SCFRA
SCFRL Field Control for Number of Lunches CHAR 1 0 SCFRL
BUSPA Possibility for Entering Business Partners CHAR 1 0 PTRV_BUSPA
No Entry of Business Partners
1 Entry of Business Partners Only
2 Entry of One Business Partner Only
3 Entry of Business Partners and Other Participants
RNDR Expense Type Contains Rounded Amount (Indicator) CHAR 1 0 PTRV_RNDR
REV_CHARGE_MWSKZ VAT Code Reverse Charge CHAR 2 0 T007A PTRV_REVCHARGE_MWSKZ
VAT_IRRELEVANT Expense Type Not Relevant for VAT Refund CHAR 1 0 PTRV_VATIRRELEVANT
Expense Type Relevant for VAT Refund
X Expense Type Not Relevant for VAT Refund
SCAIRDEP Field Control IATA - Location of Departure Airport CHAR 1 0 SCAIRDP
SCAIRAIA Field Control IATA - Location of Arrival Airport CHAR 1 0 SCAIRAR
SCAIRL Field Control for Airline CHAR 1 0 SCAIR
SCAIRAIC Field Control for Cabin Class CHAR 1 0 SCAIRAIC
SCAIRAIT Field Control for Ticket Number CHAR 1 0 SCAIRAIT
SCCARODO Field Control for Tachometer Mileage CHAR 1 0 SCCARODO
SCKRDSNA Field Control for Name of Vendor CHAR 1 0 SCKRDSNA
SCKRDSST Field Control for Street of Vendor CHAR 1 0 SCKRDSST
SCKRDSCI Field Control for Vendor Location CHAR 1 0 SCKRDSCI
SCKRDSPR Field Control for District/County of Vendor CHAR 1 0 SCKRDSPR
SCKRDSCO Field Control for Country of Vendor CHAR 1 0 SCKRDSCO
SCKRDSPC Field Control for Postal Code of Vendor CHAR 1 0 SCKRDSPC
SCKRDSPH Field Control for Vendor's Telephone Number CHAR 1 0 SCKRDSPH
SCPRD Product for Spend Tracking CHAR 1 0 SCPRD
PTRV_SPDRELEVANT Spend Tracking Is Active CHAR 1 0 PTRV_SPDRELEVANT
Document Type Not Relevant for Expense Recording
X Document Type Relevant for Expense Recording
PTRV_CALCGUESTS Calculate Number of Participants CHAR 1 0 PTRVCALCGUESTS
No
X Yes

T706B1 foreign key relationships

Table Field Check Table Check Field
0 T706B1 GRUPN T706B3 Travel Expense Type Grouping MANDT
0 T706B1 GRUPN T706B3 Travel Expense Type Grouping MOREI
0 T706B1 GRUPN T706B3 Travel Expense Type Grouping GRUPN
0 T706B1 GRUPN T706B3 Travel Expense Type Grouping ENDDA
1 T706B1 MOREI T702N Trip Provision Variants MOREI
0 T706B1 MWSKZ T007A Tax Keys KALSM
0 T706B1 MWSKZ T007A Tax Keys MWSKZ
1 T706B1 REV_CHARGE_MWSKZ T007A Tax Keys KALSM
1 T706B1 REV_CHARGE_MWSKZ T007A Tax Keys MWSKZ