SAP ABAP Table PTRV_T706B1 (Travel Expense Types)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-COS (Application Component) Travel Expenses
     ⤷ PTRA_ADDON (Package) Travel Management Add-On

Basic Data

Table Category	INTTAB	Structure
Structure	PTRV_T706B1	Table Relationship Diagram
Short Description	Travel 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	Table T706B; Structure for BAPI interface
2	PR04_SORT	☐	PR04X	PR04X	CHAR	1	0	Sequence of Expense Types in Weekly Report
3	EXP_TYPE	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	T706B1
4	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
5	EXP_CATE	☐	BELAR	BELAR	CHAR	1	0	Travel Expense Category
6	PAID_COM	☐	BEZFA	XFELD	CHAR	1	0	Paid by Company
7	MAX_AMOUNT	☐	MAX_AMOUNT	BAPICURR	DEC	23	4	Maximum Receipt Amount
8	CURRENCY	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
9	MESS_FLAG	☐	MESSA_D	XFELD	CHAR	1	0	Error Message When Maximum Value Exceeded
10	SCDV1	☐	SCDV1	AUSWL	CHAR	1	0	From date field control
11	SCDB1	☐	SCDB1	AUSWL	CHAR	1	0	To date field control
12	SCANZ	☐	SCANZ	AUSWL	CHAR	1	0	Number field control
13	ANZCA	☐	ANZCA	ANZCA	CHAR	1	0	Calculation of Default Value for Number Field
14	SCLND	☐	SCLND	AUSWL	CHAR	1	0	Country/Region field control
15	SCRAU	☐	SCRAU	AUSWL	CHAR	1	0	Field control for enterprise-specific trip type
16	SCFRF	☐	SCFRF	AUSWL	CHAR	1	0	Field control for number of breakfasts
17	SCDEC	☐	SCDEC	AUSWL	CHAR	1	0	Description field control
18	SCPLA	☐	SCPLA	AUSWL	CHAR	1	0	Field control: Place
19	SCBPU	☐	SCBPU	AUSWL	CHAR	1	0	Field control for business purpose on receipt
20	SCBRE	☐	SCBRE	AUSWL	CHAR	1	0	Field control for business partner
21	SCEDT	☐	SCEDT	AUSWL	CHAR	1	0	Editor field control
22	EXP_TEXT	☐	TEXT_SPKZL	REITX	CHAR	30	0	Name of Travel Expense Type
23	SCPRV	☐	SCPRV	AUSWL	CHAR	1	0	Field Control for Provider (Airline, Hotel Chain, ...)
24	SCMER	☐	SCMER	AUSWL	CHAR	1	0	Field control for service provider
25	SCDOC	☐	SCDOC	AUSWL	CHAR	1	0	Field Control for (Paper) Document Number
26	CATEGORY	☐	PROVIDER_CATEGORY	FTPD_PROVIDER_CATEGORY	CHAR	1	0	Provider Category
27	SCSTF	☐	SC_NO_STAFF	AUSWL	CHAR	1	0	Field Control Number of Employees
28	SCPTN	☐	SC_NO_PARTNERS	AUSWL	CHAR	1	0	Field Control Number of Employees of Business Partners
29	SCGST	☐	SC_NO_GUESTS	AUSWL	CHAR	1	0	Field Control Number of Additional Guests
30	REWIZ	☐	RECWIZ	RECWIZ	CHAR	1	0	Receipt Wizard
31	PREXP	☐	PRVEXP	SPKZL	CHAR	4	0	Expense Type Pay Back Private Share	*
32	PREXC	☐	PRVEXC	SPKZL	CHAR	4	0	Expense Type Private Share Paid by Company	*
33	SCFRA	☐	SCFRA	AUSWL	CHAR	1	0	Field Control for Number of Dinners
34	SCFRL	☐	SCFRL	AUSWL	CHAR	1	0	Field Control for Number of Lunches
35	REV_CHARGE_MWSKZ	☐	PTRV_REVCHARGE_MWSKZ	MWSKZ	CHAR	2	0	VAT Code Reverse Charge	*
36	VAT_IRRELEVANT	☐	PTRV_VATIRRELEVANT	PTRV_VATIRRELEVANT	CHAR	1	0	Expense Type Not Relevant for VAT Refund
37	TRIP_OR_WEEKLY_REPORT	☐	PR04O	PR04O	CHAR	1	0	Use of Expense Type in Weekly Report/Business Trip
38	GROUPING	☐	P_GRUPN	CHAR1	CHAR	1	0	Travel Expense Type Grouping
39	EST_C	☐	PTRV_ESTC	XFELD	CHAR	1	0	Indicator for Expense Type Containing Estimated Costs

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PTRV_T706B1	CURRENCY	TCURC	WAERS	KEY	1	CN
2	PTRV_T706B1	EXP_TYPE	T706B1	SPKZL	KEY	1	CN
3	PTRV_T706B1	TAX_CODE	T007A	MWSKZ	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in	110