SAP ABAP Table TXI_T706B1 (Trip Expense Types)

Hierarchy

☛ SAP_APPL (Software Component) Logistics and Accounting
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FA_ILM (Package) Information Lifecycle Management

Basic Data

Table Category	INTTAB	Structure
Structure	TXI_T706B1	Table Relationship Diagram
Short Description	Trip Expense Types

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	.INCLUDE	☐				0	0	Travel Expense Types
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	MOREI	☐	MOREI	MOREI	CHAR	2	0	Trip Provision Variant	T702N
4	SPKZL	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
5	ENDDA	☐	ENDDA	DATUM	DATS	8	0	End Date
6	BEGDA	☐	BEGDA	DATUM	DATS	8	0	Start Date
7	BEART	☐	BELAR	BELAR	CHAR	1	0	Travel Expense Category
8	PAUSH	☐	PAUSH	PAUSH	CHAR	1	0	Travel Expense Type Individual or Per Diem/Flat Rate
9	NBKKL	☐	NBKKL	NBKKL	CHAR	9	0	Travel Expense Type - Permissibility
10	FIRMA	☐	BEZFA	XFELD	CHAR	1	0	Paid by Company
11	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
12	PR04O	☐	PR04O	PR04O	CHAR	1	0	Use of Expense Type in Weekly Report/Business Trip
13	PR04X	☐	PR04X	PR04X	CHAR	1	0	Sequence of Expense Types in Weekly Report
14	SCDV1	☐	SCDV1	AUSWL	CHAR	1	0	From date field control
15	SCDB1	☐	SCDB1	AUSWL	CHAR	1	0	To date field control
16	SCANZ	☐	SCANZ	AUSWL	CHAR	1	0	Number field control
17	ANZCA	☐	ANZCA	ANZCA	CHAR	1	0	Calculation of Default Value for Number Field
18	SCLND	☐	SCLND	AUSWL	CHAR	1	0	Country/Region field control
19	SCRAU	☐	SCRAU	AUSWL	CHAR	1	0	Field control for enterprise-specific trip type
20	SCFRF	☐	SCFRF	AUSWL	CHAR	1	0	Field control for number of breakfasts
21	SCDEC	☐	SCDEC	AUSWL	CHAR	1	0	Description field control
22	SCPLA	☐	SCPLA	AUSWL	CHAR	1	0	Field control: Place
23	SCBPU	☐	SCBPU	AUSWL	CHAR	1	0	Field control for business purpose on receipt
24	SCBRE	☐	SCBRE	AUSWL	CHAR	1	0	Field control for business partner
25	SCEDT	☐	SCEDT	AUSWL	CHAR	1	0	Editor field control
26	GRUPN	☐	P_GRUPN	CHAR1	CHAR	1	0	Travel Expense Type Grouping	T706B3
27	SCMER	☐	SCMER	AUSWL	CHAR	1	0	Field control for service provider
28	USEFL	☐	PTRV_USEFL	PTRV_USEFL	CHAR	1	0	Usage indicator of travel expense type
29	TAXBENEFIT	☐	PTRV_TAXBENEFIT	PTRV_TAXBENEFIT	CHAR	1	0	Travel expense type for taxation only (additional amount)
30	SCDOC	☐	SCDOC	AUSWL	CHAR	1	0	Field Control for (Paper) Document Number
31	SCPRV	☐	SCPRV	AUSWL	CHAR	1	0	Field Control for Provider (Airline, Hotel Chain, ...)
32	P_CTG	☐	PROVIDER_CATEGORY	FTPD_PROVIDER_CATEGORY	CHAR	1	0	Provider Category
33	REWIZ	☐	RECWIZ	RECWIZ	CHAR	1	0	Receipt Wizard
34	PREXP	☐	PRVEXP	SPKZL	CHAR	4	0	Expense Type Pay Back Private Share	*
35	PREXC	☐	PRVEXC	SPKZL	CHAR	4	0	Expense Type Private Share Paid by Company	*
36	SCSTF	☐	SC_NO_STAFF	AUSWL	CHAR	1	0	Field Control Number of Employees
37	SCPTN	☐	SC_NO_PARTNERS	AUSWL	CHAR	1	0	Field Control Number of Employees of Business Partners
38	SCGST	☐	SC_NO_GUESTS	AUSWL	CHAR	1	0	Field Control Number of Additional Guests
39	EST_C	☐	PTRV_ESTC	XFELD	CHAR	1	0	Indicator for Expense Type Containing Estimated Costs
40	PRIVC	☐	PTRV_PRIV	XFELD	CHAR	1	0	Expense Type that Includes Private Costs (Indicator)
41	PRIEXP	☐	PRIEXP	SPKZL	CHAR	4	0	Expense Type for Private Shares	*
42	SCENT	☐	SCENT	AUSWL	CHAR	1	0	Field Control for Participants in Entertainment Receipt
43	SCFRA	☐	SCFRA	AUSWL	CHAR	1	0	Field Control for Number of Dinners
44	SCFRL	☐	SCFRL	AUSWL	CHAR	1	0	Field Control for Number of Lunches
45	BUSPA	☐	PTRV_BUSPA	PTRV_BUSPA	CHAR	1	0	Options for Entering Business Partners
46	RNDR	☐	PTRV_RNDR	XFELD	CHAR	1	0	Expense Type Contains Rounded Amount (Indicator)
47	REV_CHARGE_MWSKZ	☐	PTRV_REVCHARGE_MWSKZ	MWSKZ	CHAR	2	0	VAT Code Reverse Charge	*
48	VAT_IRRELEVANT	☐	PTRV_VATIRRELEVANT	PTRV_VATIRRELEVANT	CHAR	1	0	Expense Type Not Relevant for VAT Refund

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	TXI_T706B1	GRUPN	T706B3	GRUPN	KEY	1	CN
2	TXI_T706B1	MANDT	T000	MANDT	KEY	1	CN
3	TXI_T706B1	MOREI	T702N	MOREI	KEY	1	CN
4	TXI_T706B1	MWSKZ	T007A	MWSKZ	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in