SAP ABAP Table PTRV_UTIL_BELEG_TO_SPLIT (Documents to be Itemized)

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_TO_SPLIT	Table Relationship Diagram
Short Description	Documents to be Itemized

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 Defaults Based on Indiv. Receipt for Dialog
2	.INCLUDE	☐				0	0	Travel Expense Specifications According to Indiv. Receipt
3	.INCLUDE	☐				0	0	Travel Expense Specifications According to Indiv. Receipt
4	BELNR	☐	NRBEL	NRBEL	CHAR	3	0	Document Number
5	SPKZL	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	T706B1
6	BEART	☐	BELAR	BELAR	CHAR	1	0	Travel Expense Category
7	MWSKZ	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
8	BETRG	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
9	BLDAT	☐	BELDT	REDAT	DATS	8	0	Receipt Date
10	BTEXT	☐	TXBEL	TXBEL	CHAR	10	0	Short Receipt Information
11	WAERS	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
12	KURSB	☐	UKURS_CURR	UKURS	DEC	9	5	Exchange Rate
13	FFACT	☐	FFACT_CURR	DEC9	DEC	9	0	Ratio for the "from" currency units
14	TFACT	☐	TFACT_CURR	DEC9	DEC	9	0	Ratio for the "to" currency units
15	ANZFR	☐	FRANZ	FRANZ	DEC	2	0	Number of Breakfasts
16	LNDFR	☐	LNDFR	LNDGR	CHAR	3	0	Country of Receipt	T702O
17	BERFR	☐	BEREI	BEREI	CHAR	1	0	Trip Type: Enterprise-Specific	T702X
18	RGION	☐	RGION	RGION	CHAR	5	0	Trip Country/Trip Country Group/Trip Region	T702O
19	TXJCD	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
20	PAYOT	☐	PAYOT	PAYOT	CHAR	2	0	Service Provider	T706B4
21	PAYCURR	☐	PTRV_PAYCURR	WAERS	CUKY	5	0	Accounting Currency of Expense Receipt or Advance	*
22	ABOVE_LIMIT	☐	PTRV_ABOVE_LIMIT	P_ATYPE	CHAR	1	0	Customizing Limit for Travel Expense Type Exceeded
23	PROTECT	☐	PROTECT	PRTV_PROTECT	CHAR	1	0	Protection Indicator of Entry
24	.INCLU--AP	☐				0	0	Enhancement For PTK03 in Extension System
25	REFNR	☐	NOBEL	NRBEL	CHAR	3	0	Reference Document Number
26	PAPER_RECEIPT	☐	PAPER_RECEIPT	XFELD	CHAR	1	0	Paper Receipt Exists
27	RECEIPT_VALIDATED	☐	RECEIPT_VALIDATED	XFELD	CHAR	1	0	Expense Receipt Checked
28	GENEHM_U_BELEG	☐	PTRV_GENEHM_U_BELEG	CHAR1	CHAR	1	0	Reimbursement of Accommodations Receipt in Full
29	PAPER_MISSING	☐	PAPER_MISSING	P_ATYPE	CHAR	1	0	Required Paper Receipt Is Missing
30	RECEIPT_NO	☐	PTRV_RECEIPT_NO		CHAR	16	0	Invoice Number of Original Receipt
31	RECEIPT_ITEM	☐	PTRV_RECEIPT_ITEM		NUMC	3	0	Number of Invoice Item
32	FWSTE	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
33	VAT_POSTING_TYPE	☐	PTRV_VAT_POSTING_TYPE	PTRV_VAT_POSTING_TYPE	CHAR	1	0	Reporting and Posting of VAT Amount
34	VAT_SERVICE_CODE	☐	PTRV_VAT_SERVICE_CODE	PTRV_VAT_SERVICE_CODE	CHAR	3	0	Type of Goods and Services	*
35	VAT_SERVICE_DESC	☐	PTRV_VAT_SERVICE_DESC	TEXT100	CHAR	100	0	Description of Goods and Services
36	VAT_STATUS	☐	PTRV_VAT_STATUS	PTRV_VAT_STATUS	CHAR	1	0	Status of Data for VAT Refund
37	VAT_CHANGED_MAN	☐	PTRV_VAT_CHANGED_MAN		CHAR	1	0	VAT Amount Changed Manually
38	DIFF_VIOLATION	☐	DIFF_VIOLATION	P_ATYPE	CHAR	1	0	Maximum Difference Exceeded
39	VAT_SUB_SRV_CODE	☐	PTRV_VAT_SUB_SRV_CODE	PTRV_VAT_SUB_SRV_CODE	CHAR	15	0	Subcodes for Goods and Services
40	VAT_SRV_DESC_LANGU	☐	PTRV_VAT_SRV_DESC_LANGU	SYLANGU	LANG	1	0	Language of Description of Goods and Services
41	DATV1	☐	FRDAT	DATUM	DATS	8	0	From Date
42	DATB1	☐	TODAT	DATUM	DATS	8	0	To Date
43	ANZAL	☐	ERANZ	DEC3	DEC	3	0	Number
44	DESCR	☐	ERDES	TEXT50	CHAR	50	0	Description
45	PLACE	☐	ERPLC	TEXT50	CHAR	50	0	Location
46	BUSPU	☐	BUSPU	TEXT50	CHAR	50	0	Business Purpose
47	BUSRE	☐	BUSRE	TEXT50	CHAR	50	0	Business Partners
48	CCOMP	☐	CCOMP	CCOMP	CHAR	2	0	Code of Payment Card Company	*
49	C_DOC	☐	C_DOC	TEXT20	CHAR	20	0	Document Number of Credit Card Receipt
50	C_TXT	☐	C_TXT	TEXT50	CHAR	50	0	Delivered Description of a Credit Card Transaction
51	P_CTG	☐	PROVIDER_CATEGORY	FTPD_PROVIDER_CATEGORY	CHAR	1	0	Provider Category
52	P_PRV	☐	PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Provider Code	*
53	P_DOC	☐	P_DOC	TEXT20	CHAR	20	0	Document Number of a (Paper) Document
54	CCARD	☐	C_NUM	TEXT19	CHAR	19	0	Credit Card Number
55	CEKEY	☐	CEKEY	CEKEY	CHAR	10	0	Transaction Key (Supplied by Credit Card Company)
56	CFIRMA	☐	BEZFA	XFELD	CHAR	1	0	Paid by Company
57	N_STF	☐	CH_NO_STAFF	CHAR3	CHAR	3	0	Number of Employees
58	N_PTN	☐	CH_NO_PARTNERS	CHAR3	CHAR	3	0	Number of Employees of Business Partners
59	N_GST	☐	CH_NO_GUESTS	CHAR3	CHAR	3	0	Number of Additional Guests
60	GUID_CCC	☐	GUID_32	SYSUUID_C	CHAR	32	0	GUID in 'CHAR' Format in Uppercase
61	PAY_AMOUNT	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
62	ANZLU	☐	PTRV_ANZLU	CHAR3	CHAR	3	0	Number of Lunches in Hotel Receipt
63	ANZDI	☐	PTRV_ANZDI	CHAR3	CHAR	3	0	Number of Dinners in Hotel Receipt
64	.INCLU-SPK	☐				0	0	Field Control for Travel Expense Type
65	VISIBLESPK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
66	INPUTSPK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
67	REQUIREDSPK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
68	.INCLU-AMN	☐				0	0	Field Control for Amount of Individual Receipt
69	VISIBLEAMN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
70	INPUTAMN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
71	REQUIREDAMN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
72	.INCLU-CUR	☐				0	0	Field Control for Currency of Individual Receipt
73	VISIBLECUR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
74	INPUTCUR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
75	REQUIREDCUR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
76	.INCLU-RAT	☐				0	0	Field Control for Exchange Rate of Individual Receipt
77	VISIBLERAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
78	INPUTRAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
79	REQUIREDRAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
80	.INCLU-PAM	☐				0	0	Field Control for Payment Amount of Individual Receipt
81	VISIBLEPAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
82	INPUTPAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
83	REQUIREDPAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
84	.INCLU-PCU	☐				0	0	Field Control for Payment Currency of Individual Receipt
85	VISIBLEPCU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
86	INPUTPCU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
87	REQUIREDPCU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
88	.INCLU-BPP	☐				0	0	Field Control for Individual Receipt Reason
89	VISIBLEBPP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
90	INPUTBPP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
91	REQUIREDBPP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
92	.INCLU-CCP	☐				0	0	Field Control for Credit Card Company of Individual Receipt
93	VISIBLECCP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
94	INPUTCCP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
95	REQUIREDCCP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
96	.INCLU-CDC	☐				0	0	Field Control for Document Number of Individual Receipt
97	VISIBLECDC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
98	INPUTCDC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
99	REQUIREDCDC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
100	.INCLU-CTX	☐				0	0	Field Control for Document Description of Individual Receipt
101	VISIBLECTX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
102	INPUTCTX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
103	REQUIREDCTX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
104	.INCLU-DAT	☐				0	0	Field Control for Date of Individual Receipt
105	VISIBLEDAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
106	INPUTDAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
107	REQUIREDDAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
108	.INCLU-RNO	☐				0	0	Field Control for Invoice Number of Original Receipt
109	VISIBLERNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
110	INPUTRNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
111	REQUIREDRNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
112	.INCLU-RIT	☐				0	0	Field Control for Number of Invoice Item
113	VISIBLERIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
114	INPUTRIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
115	REQUIREDRIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
116	.INCLU-VAM	☐				0	0	Field Control for Tax Amount in Receipt Currency
117	VISIBLEVAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
118	INPUTVAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
119	REQUIREDVAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
120	.INCLU-VSC	☐				0	0	Field Control for Type of Goods and Services
121	VISIBLEVSC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
122	INPUTVSC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
123	REQUIREDVSC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
124	.INCLU-VSD	☐				0	0	Field Control for Description of Goods and Services
125	VISIBLEVSD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
126	INPUTVSD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
127	REQUIREDVSD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
128	CHECK_RESULT	☐	RECEIPT_CHECK_RESULT	CHECK_RESULT	CHAR	1	0	Result of Receipt Check
129	DISPLAY_ONLY	☐	RECEIPT_DISPLAY_ONLY	XFELD	CHAR	1	0	Individual Receipt Can Only Be Displayed
130	ANZFR_CHAR	☐	NUBRF	CHAR2	CHAR	2	0	Number of Breakfasts
131	SPKZL_ORIGINAL	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
132	SPKZL1	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
133	SPKZL2	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
134	SPKZL3	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
135	SPKZL4	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
136	SPKZL5	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
137	SPKZL6	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
138	STCEG	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
139	.INCLU-VRN	☐				0	0	Field Control for VAT Registration Number
140	VISIBLEVRN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
141	INPUTVRN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
142	REQUIREDVRN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
143	STCD1	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
144	.INCLU-VNN	☐				0	0	Field Control for Tax Number 1
145	VISIBLEVNN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
146	INPUTVNN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
147	REQUIREDVNN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
148	NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
149	.INCLU-NAM	☐				0	0	Field Control for Name 1
150	VISIBLENAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
151	INPUTNAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
152	REQUIREDNAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
153	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
154	.INCLU-STR	☐				0	0	Field Control for Street
155	VISIBLESTR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
156	INPUTSTR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
157	REQUIREDSTR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
158	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
159	.INCLU-HNU	☐				0	0	Field Control for House Number
160	VISIBLEHNU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
161	INPUTHNU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
162	REQUIREDHNU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
163	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
164	.INCLU-PCD	☐				0	0	Field Control for Postal Code of City
165	VISIBLEPCD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
166	INPUTPCD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
167	REQUIREDPCD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
168	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
169	.INCLU-CTY	☐				0	0	Field Control for City
170	VISIBLECTY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
171	INPUTCTY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
172	REQUIREDCTY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
173	NUMBER_FOR_SPLITTING	☐	ERANZ	DEC3	DEC	3	0	Number
174	AMOUNT_FOR_ALL_ITEMS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
175	ADAPT_RECEIPT_DATE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
176	ADAPT_FROM_DATE_TO_DATE	☐	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_TO_SPLIT	BERFR	T702X	BEREI	KEY	1	CN
2	PTRV_UTIL_BELEG_TO_SPLIT	LNDFR	T702O	LAND1	KEY
3	PTRV_UTIL_BELEG_TO_SPLIT	MWSKZ	T007A	MWSKZ
4	PTRV_UTIL_BELEG_TO_SPLIT	PAYOT	T706B4	PAYOT	KEY	1	CN
5	PTRV_UTIL_BELEG_TO_SPLIT	RGION	T702O	RGION		1	CN
6	PTRV_UTIL_BELEG_TO_SPLIT	SPKZL	T706B1	SPKZL	KEY	1	CN
7	PTRV_UTIL_BELEG_TO_SPLIT	WAERS	TCURC	WAERS	KEY	1	CN

History

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