SAP ABAP Table PTRV_WEB_RECEIPTS_FORM (Receipts of a Trip for the Travel Expense Statement)
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
⤷ 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_FORM | Table Relationship Diagram |
Short Description | Receipts of a Trip for the Travel Expense Statement |
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 | * | |
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 | REIMBURSABLE | AUSZAHLEN | XFELD | CHAR | 1 | 0 | Reimburse to Employee | ||
173 | AMOUNT_ENTERP_SPEC | BETFA | GESBE | CURR | 10 | 2 | Reimbursement Amount (Enterprise-Specific) | ||
174 | AMOUNT_ADDL_AMOUNT | BETHI | GESBE | CURR | 10 | 2 | Taxable Amount (Additional Amount) | ||
175 | AMOUNT_INC_REL_EXPENSES | BETWE | GESBE | CURR | 10 | 2 | Income-Related Expenses | ||
176 | REC_RATE_CHAR | CHAR10 | CHAR10 | CHAR | 10 | 0 | Character Field Length = 10 | ||
177 | SUM_LINE | XFELD | XFELD | CHAR | 1 | 0 | Checkbox | ||
178 | .INCLUDE | 0 | 0 | Designations of Trip Receipts | |||||
179 | EXP_TYPE_NAME | TEXT_SPKZL | REITX | CHAR | 30 | 0 | Name of Travel Expense Type | ||
180 | EXP_CATE_NAME | LTEXT | TEXT40 | CHAR | 40 | 0 | Long Text | ||
181 | REC_CURR_NAME | LTEXT | TEXT40 | CHAR | 40 | 0 | Long Text | ||
182 | PAY_CURR_NAME | LTEXT | TEXT40 | CHAR | 40 | 0 | Long Text | ||
183 | TAX_CODE_NAME | TEXT1_007S | TEXT50 | CHAR | 50 | 0 | Name for value-added tax | ||
184 | TAXJURCODE_NAME | TM_TEXT1_TXJCD | TEXT50 | CHAR | 50 | 0 | Description of the tax jurisdiction code structure | ||
185 | COUNTRY_REGION_NAME | TEXT_RGION | TRV25 | CHAR | 25 | 0 | Name of Trip Country/Country Group/Region | ||
186 | CCOMP_NAME | TEXT_CCARD | TEXT50 | CHAR | 50 | 0 | Name of Credit Card Company | ||
187 | P_CTG_NAME | LTEXT | TEXT40 | CHAR | 40 | 0 | Long Text | ||
188 | P_PRV_NAME | PROVIDER_NAME | TEXT30 | CHAR | 30 | 0 | Provider Name | ||
189 | PAYOUT_NAME | TEXT_CCOMP | TEXT50 | CHAR | 50 | 0 | Name of service provider | ||
190 | TT_COMSP_NAME | TEXT_BEREI | TRV25 | CHAR | 25 | 0 | Name for enterprise-specific trip type |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PTRV_WEB_RECEIPTS_FORM | EXP_TYPE | T706B1 | SPKZL | |||
2 | PTRV_WEB_RECEIPTS_FORM | PAY_CURR | TCURC | WAERS | |||
3 | PTRV_WEB_RECEIPTS_FORM | REC_CURR | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 600 |