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

History

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