SAP ABAP Table PTK03 (Travel Expense Specifications According to Indiv. Receipt)

Hierarchy

☛ SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
   ⤷ FI-TV-COS (Application Component) Travel Expenses
     ⤷ PTRA (Package) Travel Expenses Application Dev. (R/3 Enterprise Core)

Basic Data

Table Category	INTTAB	Structure
Structure	PTK03	Table Relationship Diagram
Short Description	Travel Expense Specifications According to Indiv. Receipt

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	BELNR	☐	NRBEL	NRBEL	CHAR	3	0	Document Number
2	SPKZL	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	T706B1
3	BEART	☐	BELAR	BELAR	CHAR	1	0	Travel Expense Category
4	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
5	BETRG	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
6	BLDAT	☐	BELDT	REDAT	DATS	8	0	Receipt Date
7	BTEXT	☐	TXBEL	TXBEL	CHAR	10	0	Short Receipt Information
8	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
9	KURSB	☐	UKURS_CURR	UKURS	DEC	9	5	Exchange Rate
10	FFACT	☐	FFACT_CURR	DEC9	DEC	9	0	Ratio for the "from" currency units
11	TFACT	☐	TFACT_CURR	DEC9	DEC	9	0	Ratio for the "to" currency units
12	ANZFR	☐	FRANZ	FRANZ	DEC	2	0	Number of Breakfasts
13	LNDFR	☐	LNDFR	LNDGR	CHAR	3	0	Country of Receipt	T702O
14	BERFR	☐	BEREI	BEREI	CHAR	1	0	Trip Type: Enterprise-Specific	T702X
15	RGION	☐	RGION	RGION	CHAR	5	0	Trip Country/Trip Country Group/Trip Region	T702O
16	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
17	PAYOT	☐	PAYOT	PAYOT	CHAR	2	0	Service Provider	T706B4
18	PAYCURR	☐	PTRV_PAYCURR	WAERS	CUKY	5	0	Accounting Currency of Expense Receipt or Advance	*
19	ABOVE_LIMIT	☐	PTRV_ABOVE_LIMIT	P_ATYPE	CHAR	1	0	Customizing Limit for Travel Expense Type Exceeded
20	PROTECT	☐	PROTECT	PRTV_PROTECT	CHAR	1	0	Protection Indicator of Entry
21	.INCLU--AP	☐				0	0	Enhancement For PTK03 in Extension System
22	REFNR	☐	NOBEL	NRBEL	CHAR	3	0	Reference Document Number
23	PAPER_RECEIPT	☐	PAPER_RECEIPT	XFELD	CHAR	1	0	Paper Receipt Exists
24	RECEIPT_VALIDATED	☐	RECEIPT_VALIDATED	XFELD	CHAR	1	0	Expense Receipt Checked
25	GENEHM_U_BELEG	☐	PTRV_GENEHM_U_BELEG	CHAR1	CHAR	1	0	Reimbursement of Accommodations Receipt in Full
26	PAPER_MISSING	☐	PAPER_MISSING	P_ATYPE	CHAR	1	0	Required Paper Receipt Is Missing
27	RECEIPT_NO	☐	PTRV_RECEIPT_NO		CHAR	16	0	Invoice Number of Original Receipt
28	RECEIPT_ITEM	☐	PTRV_RECEIPT_ITEM		NUMC	3	0	Number of Invoice Item
29	FWSTE	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
30	VAT_POSTING_TYPE	☐	PTRV_VAT_POSTING_TYPE	PTRV_VAT_POSTING_TYPE	CHAR	1	0	Reporting and Posting of VAT Amount
31	VAT_SERVICE_CODE	☐	PTRV_VAT_SERVICE_CODE	PTRV_VAT_SERVICE_CODE	CHAR	3	0	Type of Goods and Services	*
32	VAT_SERVICE_DESC	☐	PTRV_VAT_SERVICE_DESC	TEXT100	CHAR	100	0	Description of Goods and Services
33	VAT_STATUS	☐	PTRV_VAT_STATUS	PTRV_VAT_STATUS	CHAR	1	0	Status of Data for VAT Refund
34	VAT_CHANGED_MAN	☐	PTRV_VAT_CHANGED_MAN		CHAR	1	0	VAT Amount Changed Manually
35	DIFF_VIOLATION	☐	DIFF_VIOLATION	P_ATYPE	CHAR	1	0	Maximum Difference Exceeded
36	VAT_SUB_SRV_CODE	☐	PTRV_VAT_SUB_SRV_CODE	PTRV_VAT_SUB_SRV_CODE	CHAR	15	0	Subcodes for Goods and Services
37	VAT_SRV_DESC_LANGU	☐	PTRV_VAT_SRV_DESC_LANGU	SYLANGU	LANG	1	0	Language of Description of Goods and Services

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PTK03	BERFR	T702X	BEREI	KEY	1	CN
2	PTK03	LNDFR	T702O	LAND1	KEY
3	PTK03	MWSKZ	T007A	MWSKZ
4	PTK03	PAYOT	T706B4	PAYOT	KEY	1	CN
5	PTK03	RGION	T702O	RGION		1	CN
6	PTK03	SPKZL	T706B1	SPKZL	KEY	1	CN
7	PTK03	WAERS	TCURC	WAERS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in