SAP ABAP Table PTRV_APPR (Trip Approval)
Hierarchy
☛
SAP_HRGXX (Software Component) Sub component SAP_HRGXX of SAP_HR
⤷ FI-TV-COS (Application Component) Travel Expenses
⤷ PTRA (Package) Travel Expenses Application Dev. (R/3 Enterprise Core)
⤷ FI-TV-COS (Application Component) Travel Expenses
⤷ PTRA (Package) Travel Expenses Application Dev. (R/3 Enterprise Core)
Basic Data
Table Category | INTTAB | Structure |
Structure | PTRV_APPR | Table Relationship Diagram |
Short Description | Trip Approval |
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 | Generated Table for View | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | PERNR | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
4 | REINR | REINR | REINR | NUMC | 10 | 0 | Trip Number | ||
5 | PERIO | PTRV_PEROD | PTRV_PEROD | NUMC | 3 | 0 | Trip Period Number | ||
6 | PDVRS | PTRV_PDVRS | NUMC2 | NUMC | 2 | 0 | Sequential Number of Period | ||
7 | DRUCK | P_PRINT | P_PRINT | CHAR | 1 | 0 | Trip Print Status | ||
8 | ANTRG | ANTRG | ANTRG | CHAR | 1 | 0 | Travel Request or Trip Approved (Indicator) | ||
9 | ABREC | ABREC | ABREC | CHAR | 1 | 0 | Open / To be Settled / Settled (Indicator) | ||
10 | UEBLG | UEBLG | UEBLG | CHAR | 1 | 0 | HR Payroll Transfer (Indicator) | ||
11 | UEBRF | UEBRF | UEBRF | CHAR | 1 | 0 | FI Transfer (Indicator) | ||
12 | UEBDT | UEBDT | UEBDT | CHAR | 1 | 0 | Data Medium Exchange Transfer (Indicator) | ||
13 | VERPA | VERPA | VERPA | CHAR | 1 | 0 | Per-Diem Accounting for Meals | ||
14 | ABRJ1 | PABRJ | GJAHR | NUMC | 4 | 0 | Payroll Year | ||
15 | ABRP1 | PABRP | PABRP | NUMC | 2 | 0 | Payroll Period | ||
16 | PERM1 | IPERM | CHAR2 | CHAR | 2 | 0 | Period modifier | ||
17 | ABKR1 | ABKRS | ABKRS | CHAR | 2 | 0 | Payroll Area | * | |
18 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
19 | HDVRS | PTRV_HDVRS | PTRVNUMC2 | NUMC | 2 | 0 | Sequential Number of Travel Expenses Table THEADER | ||
20 | MOREI | MOREI | MOREI | CHAR | 2 | 0 | Trip Provision Variant | T702N | |
21 | SCHEM | RSCHE | RSCHE | CHAR | 2 | 0 | Trip schema | T706S | |
22 | ZORT1 | RZIELORT | RZIELORT | CHAR | 59 | 0 | Location | ||
23 | ZLAND | LNDGR | LNDGR | CHAR | 3 | 0 | Trip Country / Trip Country Group | T702O | |
24 | HRGIO | HRGIO | RGION | CHAR | 5 | 0 | Region of Main Destination | T702O | |
25 | KUNDE | RKUNDE | RKUNDE | CHAR | 59 | 0 | Reason for Trip (for example, customer/requisitioner) | ||
26 | DATV1 | REBED | REDAT | DATS | 8 | 0 | Beginning Date of Trip Segment | ||
27 | UHRV1 | REBEU | REUHR | TIMS | 6 | 0 | Beginning Time of Trip Segment | ||
28 | DATB1 | REEND | REDAT | DATS | 8 | 0 | End Date of Trip Segment | ||
29 | UHRB1 | REENU | REUHR | TIMS | 6 | 0 | End Time of Trip Segment | ||
30 | REQUEST | PTRV_OBJEKT | CHAR1 | CHAR | 1 | 0 | Indicator for objects request, plan and expense report | ||
31 | TRAVEL_PLAN | PTRV_OBJEKT | CHAR1 | CHAR | 1 | 0 | Indicator for objects request, plan and expense report | ||
32 | EXPENSES | PTRV_OBJEKT | CHAR1 | CHAR | 1 | 0 | Indicator for objects request, plan and expense report | ||
33 | TRIP_TOTAL | PTRV_TRIP_TOTAL | WERTV7 | CURR | 13 | 2 | Total Cost of Trip | ||
34 | CURRENCY | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
35 | TRIPDUR | PTRV_TRIPDUR | DEC4 | DEC | 4 | 0 | Trip Duration in Days | ||
36 | CORR_ICON | PTRV_CORR_ICON | STRG | 0 | 0 | Correction Indicator | |||
37 | ANTRG_TXT | ANTRG_TXT | TEXT20 | CHAR | 20 | 0 | Travel Request or Trip Approved - Long Text | ||
38 | ABREC_TXT | ABREC_TXT | TEXT20 | CHAR | 20 | 0 | Trip Open/To be Settled/Settled - Long Text | ||
39 | ENAME | EMNAM | TEXT40 | CHAR | 40 | 0 | Formatted Name of Employee or Applicant | ||
40 | SNAME | SMNAM | CHAR30 | CHAR | 30 | 0 | Employee's Name (Sortable by LAST NAME FIRST NAME) | ||
41 | PFLAG_ICON | PTRV_PFLAG_ICON | STRG | 0 | 0 | Trip Status | |||
42 | RACCOBJ | PTRV_RACCOBJ | TEXT25 | CHAR | 25 | 0 | Account Assignment | ||
43 | RACCOBJ_GENREC | PTRV_RACCOBJ_GENREC | CHAR_35 | CHAR | 35 | 0 | Account Assignment Object | ||
44 | RACCOBJ_TEXT | PTRV_RACCOBJ_TEXT | STRG | 0 | 0 | Account Assignment Text | |||
45 | ADDITIONAL_RECEIVERS | PTRV_ADDITIONAL_RECEIVERS | STRG | 0 | 0 | Multiple Account Assignment |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | PTRV_APPR | HRGIO | T702O | RGION | |||
2 | PTRV_APPR | MOREI | T702N | MOREI | KEY | 1 | CN |
3 | PTRV_APPR | SCHEM | T706S | SCHEM | |||
4 | PTRV_APPR | ZLAND | T702O | LAND1 |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 470 |