SAP ABAP Table PTRV_UTIL_BELEG_FORM (Travel Expense Spec. Based on Individual Receipt for Form)

Hierarchy

☛ EA-HRGXX (Software Component) Sub component EA-HRGXX of EA-HR
   ⤷ FI-TV-COS (Application Component) Travel Expenses
     ⤷ PTRA_WEB_INTERFACE (Package) RFC Modules for Web User Interface: Travel Expenses

Basic Data

Table Category	INTTAB	Structure
Structure	PTRV_UTIL_BELEG_FORM	Table Relationship Diagram
Short Description	Travel Expense Spec. Based on Individual Receipt for Form

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 Specifications According to Indiv. Receipt
2	.INCLUDE	☐				0	0	Travel Expense Specifications According to Indiv. Receipt
3	BELNR	☐	NRBEL	NRBEL	CHAR	3	0	Document Number
4	SPKZL	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	T706B1
5	BEART	☐	BELAR	BELAR	CHAR	1	0	Travel Expense Category
6	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
7	BETRG	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
8	BLDAT	☐	BELDT	REDAT	DATS	8	0	Receipt Date
9	BTEXT	☐	TXBEL	TXBEL	CHAR	10	0	Short Receipt Information
10	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
11	KURSB	☐	UKURS_CURR	UKURS	DEC	9	5	Exchange Rate
12	FFACT	☐	FFACT_CURR	DEC9	DEC	9	0	Ratio for the "from" currency units
13	TFACT	☐	TFACT_CURR	DEC9	DEC	9	0	Ratio for the "to" currency units
14	ANZFR	☐	FRANZ	FRANZ	DEC	2	0	Number of Breakfasts
15	LNDFR	☐	LNDFR	LNDGR	CHAR	3	0	Country of Receipt	T702O
16	BERFR	☐	BEREI	BEREI	CHAR	1	0	Trip Type: Enterprise-Specific	T702X
17	RGION	☐	RGION	RGION	CHAR	5	0	Trip Country/Trip Country Group/Trip Region	T702O
18	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
19	PAYOT	☐	PAYOT	PAYOT	CHAR	2	0	Service Provider	T706B4
20	PAYCURR	☐	PTRV_PAYCURR	WAERS	CUKY	5	0	Accounting Currency of Expense Receipt or Advance	*
21	ABOVE_LIMIT	☐	PTRV_ABOVE_LIMIT	P_ATYPE	CHAR	1	0	Customizing Limit for Travel Expense Type Exceeded
22	PROTECT	☐	PROTECT	PRTV_PROTECT	CHAR	1	0	Protection Indicator of Entry
23	.INCLU--AP	☐				0	0	Enhancement For PTK03 in Extension System
24	REFNR	☐	NOBEL	NRBEL	CHAR	3	0	Reference Document Number
25	PAPER_RECEIPT	☐	PAPER_RECEIPT	XFELD	CHAR	1	0	Paper Receipt Exists
26	RECEIPT_VALIDATED	☐	RECEIPT_VALIDATED	XFELD	CHAR	1	0	Expense Receipt Checked
27	GENEHM_U_BELEG	☐	PTRV_GENEHM_U_BELEG	CHAR1	CHAR	1	0	Reimbursement of Accommodations Receipt in Full
28	PAPER_MISSING	☐	PAPER_MISSING	P_ATYPE	CHAR	1	0	Required Paper Receipt Is Missing
29	RECEIPT_NO	☐	PTRV_RECEIPT_NO		CHAR	16	0	Invoice Number of Original Receipt
30	RECEIPT_ITEM	☐	PTRV_RECEIPT_ITEM		NUMC	3	0	Number of Invoice Item
31	FWSTE	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
32	VAT_POSTING_TYPE	☐	PTRV_VAT_POSTING_TYPE	PTRV_VAT_POSTING_TYPE	CHAR	1	0	Reporting and Posting of VAT Amount
33	VAT_SERVICE_CODE	☐	PTRV_VAT_SERVICE_CODE	PTRV_VAT_SERVICE_CODE	CHAR	3	0	Type of Goods and Services	*
34	VAT_SERVICE_DESC	☐	PTRV_VAT_SERVICE_DESC	TEXT100	CHAR	100	0	Description of Goods and Services
35	VAT_STATUS	☐	PTRV_VAT_STATUS	PTRV_VAT_STATUS	CHAR	1	0	Status of Data for VAT Refund
36	VAT_CHANGED_MAN	☐	PTRV_VAT_CHANGED_MAN		CHAR	1	0	VAT Amount Changed Manually
37	DIFF_VIOLATION	☐	DIFF_VIOLATION	P_ATYPE	CHAR	1	0	Maximum Difference Exceeded
38	VAT_SUB_SRV_CODE	☐	PTRV_VAT_SUB_SRV_CODE	PTRV_VAT_SUB_SRV_CODE	CHAR	15	0	Subcodes for Goods and Services
39	VAT_SRV_DESC_LANGU	☐	PTRV_VAT_SRV_DESC_LANGU	SYLANGU	LANG	1	0	Language of Description of Goods and Services
40	DATV1	☐	FRDAT	DATUM	DATS	8	0	From Date
41	DATB1	☐	TODAT	DATUM	DATS	8	0	To Date
42	ANZAL	☐	ERANZ	DEC3	DEC	3	0	Number
43	DESCR	☐	ERDES	TEXT50	CHAR	50	0	Description
44	PLACE	☐	ERPLC	TEXT50	CHAR	50	0	Location
45	BUSPU	☐	BUSPU	TEXT50	CHAR	50	0	Business Purpose
46	BUSRE	☐	BUSRE	TEXT50	CHAR	50	0	Business Partners
47	CCOMP	☐	CCOMP	CCOMP	CHAR	2	0	Code of Payment Card Company	*
48	C_DOC	☐	C_DOC	TEXT20	CHAR	20	0	Document Number of Credit Card Receipt
49	C_TXT	☐	C_TXT	TEXT50	CHAR	50	0	Delivered Description of a Credit Card Transaction
50	P_CTG	☐	PROVIDER_CATEGORY	FTPD_PROVIDER_CATEGORY	CHAR	1	0	Provider Category
51	P_PRV	☐	PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Provider Code	*
52	P_DOC	☐	P_DOC	TEXT20	CHAR	20	0	Document Number of a (Paper) Document
53	CCARD	☐	C_NUM	TEXT19	CHAR	19	0	Credit Card Number
54	CEKEY	☐	CEKEY	CEKEY	CHAR	10	0	Transaction Key (Supplied by Credit Card Company)
55	CFIRMA	☐	BEZFA	XFELD	CHAR	1	0	Paid by Company
56	N_STF	☐	CH_NO_STAFF	CHAR3	CHAR	3	0	Number of Employees
57	N_PTN	☐	CH_NO_PARTNERS	CHAR3	CHAR	3	0	Number of Employees of Business Partners
58	N_GST	☐	CH_NO_GUESTS	CHAR3	CHAR	3	0	Number of Additional Guests
59	GUID_CCC	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
60	PAY_AMOUNT	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
61	ANZLU	☐	PTRV_ANZLU	CHAR3	CHAR	3	0	Number of Lunches in Hotel Receipt
62	ANZDI	☐	PTRV_ANZDI	CHAR3	CHAR	3	0	Number of Dinners in Hotel Receipt
63	ANZFR_CHAR	☐	NUBRF	CHAR2	CHAR	2	0	Number of Breakfasts
64	ANZFR_LINE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
65	ANZLU_LINE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
66	ANZDI_LINE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
67	AUSZAHLEN	☐	AUSZAHLEN	XFELD	CHAR	1	0	Reimburse to Employee
68	GBTFA	☐	BETFA	GESBE	CURR	10	2	Reimbursement Amount (Enterprise-Specific)
69	GBTHI	☐	BETHI	GESBE	CURR	10	2	Taxable Amount (Additional Amount)
70	GBTWE	☐	BETWE	GESBE	CURR	10	2	Income-Related Expenses

Foreign Keys

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

History

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