SAP ABAP Table PTRV_UTIL_BELEG (Travel Expense Defaults Based on Indiv. Receipt for Dialog)

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	Table Relationship Diagram
Short Description	Travel Expense Defaults Based on Indiv. Receipt for Dialog

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	.INCLU-SPK	☐				0	0	Field Control for Travel Expense Type
64	VISIBLESPK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
65	INPUTSPK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
66	REQUIREDSPK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
67	.INCLU-AMN	☐				0	0	Field Control for Amount of Individual Receipt
68	VISIBLEAMN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
69	INPUTAMN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
70	REQUIREDAMN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
71	.INCLU-CUR	☐				0	0	Field Control for Currency of Individual Receipt
72	VISIBLECUR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
73	INPUTCUR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
74	REQUIREDCUR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
75	.INCLU-RAT	☐				0	0	Field Control for Exchange Rate of Individual Receipt
76	VISIBLERAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
77	INPUTRAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
78	REQUIREDRAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
79	.INCLU-PAM	☐				0	0	Field Control for Payment Amount of Individual Receipt
80	VISIBLEPAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
81	INPUTPAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
82	REQUIREDPAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
83	.INCLU-PCU	☐				0	0	Field Control for Payment Currency of Individual Receipt
84	VISIBLEPCU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
85	INPUTPCU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
86	REQUIREDPCU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
87	.INCLU-BPP	☐				0	0	Field Control for Individual Receipt Reason
88	VISIBLEBPP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
89	INPUTBPP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
90	REQUIREDBPP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
91	.INCLU-CCP	☐				0	0	Field Control for Credit Card Company of Individual Receipt
92	VISIBLECCP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
93	INPUTCCP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
94	REQUIREDCCP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
95	.INCLU-CDC	☐				0	0	Field Control for Document Number of Individual Receipt
96	VISIBLECDC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
97	INPUTCDC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
98	REQUIREDCDC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
99	.INCLU-CTX	☐				0	0	Field Control for Document Description of Individual Receipt
100	VISIBLECTX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
101	INPUTCTX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
102	REQUIREDCTX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
103	.INCLU-DAT	☐				0	0	Field Control for Date of Individual Receipt
104	VISIBLEDAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
105	INPUTDAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
106	REQUIREDDAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
107	.INCLU-RNO	☐				0	0	Field Control for Invoice Number of Original Receipt
108	VISIBLERNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
109	INPUTRNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
110	REQUIREDRNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
111	.INCLU-RIT	☐				0	0	Field Control for Number of Invoice Item
112	VISIBLERIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
113	INPUTRIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
114	REQUIREDRIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
115	.INCLU-VAM	☐				0	0	Field Control for Tax Amount in Receipt Currency
116	VISIBLEVAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
117	INPUTVAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
118	REQUIREDVAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
119	.INCLU-VSC	☐				0	0	Field Control for Type of Goods and Services
120	VISIBLEVSC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
121	INPUTVSC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
122	REQUIREDVSC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
123	.INCLU-VSD	☐				0	0	Field Control for Description of Goods and Services
124	VISIBLEVSD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
125	INPUTVSD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
126	REQUIREDVSD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
127	CHECK_RESULT	☐	RECEIPT_CHECK_RESULT	CHECK_RESULT	CHAR	1	0	Result of Receipt Check
128	DISPLAY_ONLY	☐	RECEIPT_DISPLAY_ONLY	XFELD	CHAR	1	0	Individual Receipt Can Only Be Displayed
129	ANZFR_CHAR	☐	NUBRF	CHAR2	CHAR	2	0	Number of Breakfasts
130	SPKZL_ORIGINAL	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
131	SPKZL1	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
132	SPKZL2	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
133	SPKZL3	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
134	SPKZL4	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
135	SPKZL5	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
136	SPKZL6	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
137	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
138	.INCLU-VRN	☐				0	0	Field Control for VAT Registration Number
139	VISIBLEVRN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
140	INPUTVRN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
141	REQUIREDVRN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
142	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
143	.INCLU-VNN	☐				0	0	Field Control for Tax Number 1
144	VISIBLEVNN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
145	INPUTVNN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
146	REQUIREDVNN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
147	NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
148	.INCLU-NAM	☐				0	0	Field Control for Name 1
149	VISIBLENAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
150	INPUTNAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
151	REQUIREDNAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
152	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
153	.INCLU-STR	☐				0	0	Field Control for Street
154	VISIBLESTR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
155	INPUTSTR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
156	REQUIREDSTR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
157	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
158	.INCLU-HNU	☐				0	0	Field Control for House Number
159	VISIBLEHNU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
160	INPUTHNU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
161	REQUIREDHNU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
162	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
163	.INCLU-PCD	☐				0	0	Field Control for Postal Code of City
164	VISIBLEPCD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
165	INPUTPCD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
166	REQUIREDPCD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
167	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
168	.INCLU-CTY	☐				0	0	Field Control for City
169	VISIBLECTY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
170	INPUTCTY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
171	REQUIREDCTY	☐	XFELD	XFELD	CHAR	1	0	Checkbox

Foreign Keys

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

History

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