SAP ABAP Table PTRV_WEB_RECEIPTS_TO_SPLIT_INT (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_WEB_RECEIPTS_TO_SPLIT_INT	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	Trip Receipts
2	RECEIPTNO	☐	NRBEL	NRBEL	CHAR	3	0	Document Number
3	EXP_TYPE	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	T706B1
4	.INCLU-SPK	☐				0	0	Field Control for Travel Expense Type
5	VISIBLESPK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
6	INPUTSPK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
7	REQUIREDSPK	☐	XFELD	XFELD	CHAR	1	0	Checkbox
8	EXP_CATE	☐	BELAR	BELAR	CHAR	1	0	Travel Expense Category
9	PAPER_RECEIPT	☐	PAPER_RECEIPT_CORE	XFELD	CHAR	1	0	Paper Receipt Exists
10	REC_AMOUNT	☐	PTRV_WEB_REC_AMOUNT	PTRV_WEB_REC_AMOUNT	CURR	10	2	Amount on Individual Receipt
11	.INCLU-AMN	☐				0	0	Field Control for Amount of Individual Receipt
12	VISIBLEAMN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
13	INPUTAMN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
14	REQUIREDAMN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
15	REC_CURR	☐	WAERS	WAERS	CUKY	5	0	Currency Key	TCURC
16	.INCLU-CUR	☐				0	0	Field Control for Currency of Individual Receipt
17	VISIBLECUR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
18	INPUTCUR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
19	REQUIREDCUR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
20	REC_RATE	☐	UKURS_CURR	UKURS	DEC	9	5	Exchange Rate
21	.INCLU-RAT	☐				0	0	Field Control for Exchange Rate of Individual Receipt
22	VISIBLERAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
23	INPUTRAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
24	REQUIREDRAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
25	S_FACTOR	☐	FFACT_CURR	DEC9	DEC	9	0	Ratio for the "from" currency units
26	T_FACTOR	☐	TFACT_CURR	DEC9	DEC	9	0	Ratio for the "to" currency units
27	.INCLU-DAT	☐				0	0	Field Control for Date of Individual Receipt
28	VISIBLEDAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
29	INPUTDAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
30	REQUIREDDAT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
31	REC_DATE	☐	BELDT	REDAT	DATS	8	0	Receipt Date
32	PAY_AMOUNT	☐	GESBB	GESBE	CURR	10	2	Amount on Individual Receipt
33	.INCLU-PAM	☐				0	0	Field Control for Payment Amount of Individual Receipt
34	VISIBLEPAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
35	INPUTPAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
36	REQUIREDPAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
37	PAY_CURR	☐	PTRV_PAYCURR	WAERS	CUKY	5	0	Accounting Currency of Expense Receipt or Advance	TCURC
38	.INCLU-PCU	☐				0	0	Field Control for Payment Currency of Individual Receipt
39	VISIBLEPCU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
40	INPUTPCU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
41	REQUIREDPCU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
42	TAX_CODE	☐	MWSKZ	MWSKZ	CHAR	2	0	Tax on sales/purchases code	T007A
43	TAXJURCODE	☐	TXJCD	TXJCD	CHAR	15	0	Tax Jurisdiction	*
44	SHORTTXT	☐	TXBEL	TXBEL	CHAR	10	0	Short Receipt Information
45	COUNTRY	☐	LNDGR	LNDGR	CHAR	3	0	Trip Country / Trip Country Group	*
46	REGION	☐	RGION	RGION	CHAR	5	0	Trip Country/Trip Country Group/Trip Region	*
47	FROM_DATE	☐	FRDAT	DATUM	DATS	8	0	From Date
48	TO_DATE	☐	TODAT	DATUM	DATS	8	0	To Date
49	NO_UNIT	☐	ERANZ	DEC3	DEC	3	0	Number
50	NO_BRFT	☐	NUBRF	CHAR2	CHAR	2	0	Number of Breakfasts
51	DESCRIPT	☐	ERDES	TEXT50	CHAR	50	0	Description
52	LOCATION	☐	ERPLC	TEXT50	CHAR	50	0	Location
53	BUS_PURPO	☐	BUSPU	TEXT50	CHAR	50	0	Business Purpose
54	.INCLU-BPP	☐				0	0	Field Control for Individual Receipt Reason
55	VISIBLEBPP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
56	INPUTBPP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
57	REQUIREDBPP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
58	BUS_REASON	☐	BUSRE	TEXT50	CHAR	50	0	Business Partners
59	CCOMP	☐	CCOMP	CCOMP	CHAR	2	0	Code of Payment Card Company	*
60	.INCLU-CCP	☐				0	0	Field Control for Credit Card Company of Individual Receipt
61	VISIBLECCP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
62	INPUTCCP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
63	REQUIREDCCP	☐	XFELD	XFELD	CHAR	1	0	Checkbox
64	C_DOC	☐	C_DOC	TEXT20	CHAR	20	0	Document Number of Credit Card Receipt
65	.INCLU-CDC	☐				0	0	Field Control for Document Number of Individual Receipt
66	VISIBLECDC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
67	INPUTCDC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
68	REQUIREDCDC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
69	C_TXT	☐	C_TXT	TEXT50	CHAR	50	0	Delivered Description of a Credit Card Transaction
70	.INCLU-CTX	☐				0	0	Field Control for Document Description of Individual Receipt
71	VISIBLECTX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
72	INPUTCTX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
73	REQUIREDCTX	☐	XFELD	XFELD	CHAR	1	0	Checkbox
74	CCARD	☐	C_NUM	TEXT19	CHAR	19	0	Credit Card Number
75	CEKEY	☐	CEKEY	CEKEY	CHAR	10	0	Transaction Key (Supplied by Credit Card Company)
76	P_CTG	☐	PROVIDER_CATEGORY	FTPD_PROVIDER_CATEGORY	CHAR	1	0	Provider Category
77	P_PRV	☐	PROVIDER_CODE	FTPD_PROVIDER_CODE	CHAR	3	0	Provider Code	*
78	P_DOC	☐	P_DOC	TEXT20	CHAR	20	0	Document Number of a (Paper) Document
79	N_STF	☐	CH_NO_STAFF	CHAR3	CHAR	3	0	Number of Employees
80	N_PTN	☐	CH_NO_PARTNERS	CHAR3	CHAR	3	0	Number of Employees of Business Partners
81	N_GST	☐	CH_NO_GUESTS	CHAR3	CHAR	3	0	Number of Additional Guests
82	PAID_COM	☐	BEZFA	XFELD	CHAR	1	0	Paid by Company
83	PAYOUT	☐	PAYOT	PAYOT	CHAR	2	0	Service Provider	*
84	ABOVE_LIMIT	☐	PTRV_ABOVE_LIMIT	P_ATYPE	CHAR	1	0	Customizing Limit for Travel Expense Type Exceeded
85	COMING_FROM_PLAN	☐	PROTECT	PRTV_PROTECT	CHAR	1	0	Protection Indicator of Entry
86	REF_NO	☐	NOBEL	NRBEL	CHAR	3	0	Reference Document Number
87	RECEIPT_OK	☐	RECEIPT_VALIDATED_CORE	XFELD	CHAR	1	0	Expense Receipt Checked
88	TT_COMSP	☐	BEREI	BEREI	CHAR	1	0	Trip Type: Enterprise-Specific	*
89	CHECK_RESULT	☐	RECEIPT_CHECK_RESULT	CHECK_RESULT	CHAR	1	0	Result of Receipt Check
90	DISPLAY_ONLY	☐	RECEIPT_DISPLAY_ONLY	XFELD	CHAR	1	0	Individual Receipt Can Only Be Displayed
91	EDITOR	☐	PTRV_WEB_EDITOR		STRG	0	0	Editor in Web Structures
92	EXP_TYPE_ORIGINAL	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
93	EXP_TYPE1	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
94	EXP_TYPE2	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
95	EXP_TYPE3	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
96	EXP_TYPE4	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
97	EXP_TYPE5	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
98	EXP_TYPE6	☐	SPKZL	SPKZL	CHAR	4	0	Travel Expense Type	*
99	NO_LUNCH	☐	PTRV_ANZLU	CHAR3	CHAR	3	0	Number of Lunches in Hotel Receipt
100	NO_DINNER	☐	PTRV_ANZDI	CHAR3	CHAR	3	0	Number of Dinners in Hotel Receipt
101	FULL_AMOUNT_REIMB	☐	PTRV_GENEHM_U_BELEG	CHAR1	CHAR	1	0	Reimbursement of Accommodations Receipt in Full
102	PAPER_MISSING	☐	PAPER_MISSING	P_ATYPE	CHAR	1	0	Required Paper Receipt Is Missing
103	BOOKED_PRICE	☐	BOOKED_PRICE	GESBE	CURR	10	2	Booked Price from Travel Planning
104	BOOKED_CURR	☐	BOOKED_CURR	WAERS	CUKY	5	0	Booked Currency from Planning	*
105	DIFF_AMOUNT	☐	DIFF_AMOUNT	GESBE	CURR	10	2	Difference Amount
106	DIFF_CURR	☐	DIFF_CURR	WAERS	CUKY	5	0	Currency of Difference Amount	*
107	REASON	☐	PTRV_REASON	TEXT50	CHAR	50	0	Reason for Difference
108	DIFF_VIOLATION	☐	DIFF_VIOLATION	P_ATYPE	CHAR	1	0	Maximum Difference Exceeded
109	RECEIPT_NO	☐	PTRV_RECEIPT_NO		CHAR	16	0	Invoice Number of Original Receipt
110	.INCLU-RNO	☐				0	0	Field Control for Invoice Number of Original Receipt
111	VISIBLERNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
112	INPUTRNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
113	REQUIREDRNO	☐	XFELD	XFELD	CHAR	1	0	Checkbox
114	RECEIPT_ITEM	☐	PTRV_RECEIPT_ITEM		NUMC	3	0	Number of Invoice Item
115	.INCLU-RIT	☐				0	0	Field Control for Number of Invoice Item
116	VISIBLERIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
117	INPUTRIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
118	REQUIREDRIT	☐	XFELD	XFELD	CHAR	1	0	Checkbox
119	VAT_AMOUNT	☐	WMWST	WERT7	CURR	13	2	Tax amount in document currency
120	.INCLU-VAM	☐				0	0	Field Control for Tax Amount in Receipt Currency
121	VISIBLEVAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
122	INPUTVAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
123	REQUIREDVAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
124	VAT_SERVICE_CODE	☐	PTRV_VAT_SERVICE_CODE	PTRV_VAT_SERVICE_CODE	CHAR	3	0	Type of Goods and Services	*
125	.INCLU-VSC	☐				0	0	Field Control for Type of Goods and Services
126	VISIBLEVSC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
127	INPUTVSC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
128	REQUIREDVSC	☐	XFELD	XFELD	CHAR	1	0	Checkbox
129	VAT_SERVICE_DESC	☐	PTRV_VAT_SERVICE_DESC	TEXT100	CHAR	100	0	Description of Goods and Services
130	.INCLU-VSD	☐				0	0	Field Control for Description of Goods and Services
131	VISIBLEVSD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
132	INPUTVSD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
133	REQUIREDVSD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
134	VAT_REG_NO	☐	STCEG	STCEG	CHAR	20	0	VAT Registration Number
135	.INCLU-VRN	☐				0	0	Field Control for VAT Registration Number
136	VISIBLEVRN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
137	INPUTVRN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
138	REQUIREDVRN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
139	VAT_REG_NO_NAT	☐	STCD1	STCD1	CHAR	16	0	Tax Number 1
140	.INCLU-VNN	☐				0	0	Field Control for Tax Number 1
141	VISIBLEVNN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
142	INPUTVNN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
143	REQUIREDVNN	☐	XFELD	XFELD	CHAR	1	0	Checkbox
144	NAME	☐	AD_NAME1	TEXT40	CHAR	40	0	Name 1
145	.INCLU-NAM	☐				0	0	Field Control for Name 1
146	VISIBLENAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
147	INPUTNAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
148	REQUIREDNAM	☐	XFELD	XFELD	CHAR	1	0	Checkbox
149	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
150	.INCLU-STR	☐				0	0	Field Control for Street
151	VISIBLESTR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
152	INPUTSTR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
153	REQUIREDSTR	☐	XFELD	XFELD	CHAR	1	0	Checkbox
154	HOUSE_NUM	☐	AD_HSNM1	TEXT10	CHAR	10	0	House Number
155	.INCLU-HNU	☐				0	0	Field Control for House Number
156	VISIBLEHNU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
157	INPUTHNU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
158	REQUIREDHNU	☐	XFELD	XFELD	CHAR	1	0	Checkbox
159	POST_CODE	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
160	.INCLU-PCD	☐				0	0	Field Control for Postal Code of City
161	VISIBLEPCD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
162	INPUTPCD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
163	REQUIREDPCD	☐	XFELD	XFELD	CHAR	1	0	Checkbox
164	CITY	☐	AD_CITY1	TEXT40	CHAR	40	0	City
165	.INCLU-CTY	☐				0	0	Field Control for City
166	VISIBLECTY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
167	INPUTCTY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
168	REQUIREDCTY	☐	XFELD	XFELD	CHAR	1	0	Checkbox
169	VAT_SUB_SRV_CODE	☐	PTRV_VAT_SUB_SRV_CODE	PTRV_VAT_SUB_SRV_CODE	CHAR	15	0	Subcodes for Goods and Services
170	VAT_SRV_DESC_LANGU	☐	PTRV_VAT_SRV_DESC_LANGU	SYLANGU	LANG	1	0	Language of Description of Goods and Services
171	VAT_CHANGED_MAN	☐	PTRV_VAT_CHANGED_MAN		CHAR	1	0	VAT Amount Changed Manually
172	NUMBER_FOR_SPLITTING	☐	ERANZ	DEC3	DEC	3	0	Number
173	AMOUNT_FOR_ALL_ITEMS	☐	XFELD	XFELD	CHAR	1	0	Checkbox
174	ADAPT_RECEIPT_DATE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
175	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_WEB_RECEIPTS_TO_SPLIT_INT	EXP_TYPE	T706B1	SPKZL	KEY	1	CN
2	PTRV_WEB_RECEIPTS_TO_SPLIT_INT	PAY_CURR	TCURC	WAERS
3	PTRV_WEB_RECEIPTS_TO_SPLIT_INT	REC_CURR	TCURC	WAERS	KEY	1	CN
4	PTRV_WEB_RECEIPTS_TO_SPLIT_INT	TAX_CODE	T007A	MWSKZ	KEY	1	CN

History

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