SAP ABAP Table PTRV_WEB_RECEIPTS_INT (Trip Receipts)

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_INT	Table Relationship Diagram
Short Description	Trip Receipts

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	PTRV_WEB_RECEIPTS_INT	EXP_TYPE	T706B1	SPKZL	KEY	1	CN
2	PTRV_WEB_RECEIPTS_INT	PAY_CURR	TCURC	WAERS
3	PTRV_WEB_RECEIPTS_INT	REC_CURR	TCURC	WAERS	KEY	1	CN
4	PTRV_WEB_RECEIPTS_INT	TAX_CODE	T007A	MWSKZ	KEY	1	CN

History

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