SAP ABAP Table HEAD_PERIO (General Information and Period Data of a Trip)
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 | HEAD_PERIO | Table Relationship Diagram |
Short Description | General Information and Period Data of a Trip |
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 | Key for Travel Expenses Table PTRV_PERIO | |||||
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 | .INCLUDE | 0 | 0 | Structure of Travel Expenses Table PTRV_HEAD | |||||
8 | MOLGA | MOLGA | MOLGA | CHAR | 2 | 0 | Country Grouping | T500L | |
9 | MOREI | MOREI | MOREI | CHAR | 2 | 0 | Trip Provision Variant | T702N | |
10 | SCHEM | RSCHE | RSCHE | CHAR | 2 | 0 | Trip schema | T706S | |
11 | KZREA | KZREA | KZREA | CHAR | 1 | 0 | Trip Type: Statutory | T702G | |
12 | BEREI | BEREI | BEREI | CHAR | 1 | 0 | Trip Type: Enterprise-Specific | T702X | |
13 | KZTKT | KZTKT | KZTKT | CHAR | 1 | 0 | Trip Activity Type | T702R | |
14 | ZORT1 | RZIELORT | RZIELORT | CHAR | 59 | 0 | Location | ||
15 | ZLAND | LNDGR | LNDGR | CHAR | 3 | 0 | Trip Country / Trip Country Group | T702O | |
16 | HRGIO | HRGIO | RGION | CHAR | 5 | 0 | Region of Main Destination | T702O | |
17 | NDNST | PTRV_NDNST | PTRV_CHAR25 | CHAR | 25 | 0 | Name of new administrative office (P.S.) | ||
18 | KUNDE | RKUNDE | RKUNDE | CHAR | 59 | 0 | Reason for Trip (for example, customer/requisitioner) | ||
19 | DATV1 | REBED | REDAT | DATS | 8 | 0 | Beginning Date of Trip Segment | ||
20 | UHRV1 | REBEU | REUHR | TIMS | 6 | 0 | Beginning Time of Trip Segment | ||
21 | DATB1 | REEND | REDAT | DATS | 8 | 0 | End Date of Trip Segment | ||
22 | UHRB1 | REENU | REUHR | TIMS | 6 | 0 | End Time of Trip Segment | ||
23 | DATH1 | DATGH | REDAT | DATS | 8 | 0 | Border Crossing (Trip Out): Date | ||
24 | UHRH1 | UHRGH | REUHR | TIMS | 6 | 0 | Time: Border crossing(trip out) | ||
25 | DATR1 | DATGZ | REDAT | DATS | 8 | 0 | Border Crossing (Return Trip): Date | ||
26 | UHRR1 | UHRGZ | REUHR | TIMS | 6 | 0 | Time: Border crossing(return trip) | ||
27 | AGRZ1 | LNDGR | LNDGR | CHAR | 3 | 0 | Trip Country / Trip Country Group | T702O | |
28 | GRGIO | GRGIO | RGION | CHAR | 5 | 0 | Region of Border Crossing: Return Trip | T702O | |
29 | GRBER | PTRV_GRBER | BEREI | CHAR | 1 | 0 | Border crossing: Trip type enterprise-specific | T702X | |
30 | UZKVG | PTRV_UZKVG | UMZUGSKVG | CHAR | 1 | 0 | Confirmation of Moving Costs Refund | ||
31 | ZUSAG | PTRV_ZUSAG | PTRV_CHAR25 | CHAR | 25 | 0 | Admin. Office That Confirmed Moving Costs Compensation (PS) | ||
32 | ENDRG | PTRV_ENDRG | REDAT | DATS | 8 | 0 | Different End of Travel Allowance (in Separation Allowance) | ||
33 | DEPAR | PTRV_DEPAR | PTRV_CHAR1 | CHAR | 1 | 0 | Departure from Residence or Place of Work | ||
34 | ARRVL | PTRV_ARRVL | PTRV_CHAR1 | CHAR | 1 | 0 | Arrival Accommodations/New Place of Work | ||
35 | RETRN | PTRV_RETRN | PTRV_CHAR1 | CHAR | 1 | 0 | Return to residence/admin. office | ||
36 | DATES | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
37 | TIMES | AEUHR | ATIME | TIMS | 6 | 0 | Time of Last Change | ||
38 | UNAME | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
39 | REPID | AEREP | AEREP | CHAR | 40 | 0 | Change Report | ||
40 | DANTN | PTRV_DANTN | REINR | NUMC | 10 | 0 | Trip Number of Corresponding Trip to Start Work | ||
41 | FINTN | PTRV_FINTN | REINR | NUMC | 10 | 0 | Trip Number of Associated Business Trip Return | ||
42 | REQUEST | PTRV_OBJEKT | CHAR1 | CHAR | 1 | 0 | Indicator for objects request, plan and expense report | ||
43 | TRAVEL_PLAN | PTRV_OBJEKT | CHAR1 | CHAR | 1 | 0 | Indicator for objects request, plan and expense report | ||
44 | EXPENSES | PTRV_OBJEKT | CHAR1 | CHAR | 1 | 0 | Indicator for objects request, plan and expense report | ||
45 | .INCLU--AP | 0 | 0 | Enhancement of Structure for Travel Expenses Table PTRV_HEAD | |||||
46 | ST_TRGTG | PTRV_PS_ST_TRGTG | REDAT | DATS | 8 | 0 | Start of Taxation for Per Diem Separation Allowance | ||
47 | ST_TRGALL | PTRV_PS_ST_TRGALL | REDAT | DATS | 8 | 0 | Start of Taxation for Complete Separation Allowance | ||
48 | PERIODENART | PTRV_PS_PERIODENART | PTRV_PS_PERIODENART | CHAR | 1 | 0 | Associated Trip Period Types | ||
49 | DAT_REDUC1 | PTRV_PS_DAT_REDUC1 | REDAT | DATS | 8 | 0 | Reduction of Entire Separation or Travel Allowance Level 1 | ||
50 | DAT_REDUC2 | PTRV_PS_DAT_REDUC2 | REDAT | DATS | 8 | 0 | Reduction of Separation or Travel Allowance Level 2 | ||
51 | DATV1_DIENST | PTRV_PS_DATV1_DIENST | REDAT | DATS | 8 | 0 | Date of Commencement of Work | ||
52 | UHRV1_DIENST | PTRV_PS_UHRV1_DIENST | REUHR | TIMS | 6 | 0 | Time at Which Work Commences | ||
53 | DATB1_DIENST | PTRV_PS_DATB1_DIENST | REDAT | DATS | 8 | 0 | Date on Which Work Ends | ||
54 | UHRB1_DIENST | PTRV_PS_UHRB1_DIENST | REUHR | TIMS | 6 | 0 | Time at Which Work Ends | ||
55 | ABORDNUNG | PTRV_PS_ABORD | REINR | NUMC | 10 | 0 | Associated Superior Separation Allowance | ||
56 | ST_TRG_TYP | PTRV_PS_ST_TYP | CHAR1 | CHAR | 1 | 0 | Temporary Assignment (Indicator) | ||
57 | ST_WOHN_TYP | PTRV_ST_WOHN_TYP | CHAR1 | CHAR | 1 | 0 | Home for Separation Allowance Taxation | ||
58 | KEIN_REISEGELD | PTRV_KEIN_REISEGELD | CHAR1 | CHAR | 1 | 0 | No Separation Allowance for Travel Is Paid (Indicator) | ||
59 | TAX_PER_DIEM | PTRV_TAX_PER_DIEM | XFELD | CHAR | 1 | 0 | Automatic Taxation of Meals and Accommodations Per Diems | ||
60 | TAX_PD_MAN | PTRV_TAX_PD_MAN | XFELD | CHAR | 1 | 0 | Manually Triggered Taxation of Meals Per Diems | ||
61 | TAX_OV_MAN | PTRV_TAX_OV_MAN | XFELD | CHAR | 1 | 0 | Manually Triggered Taxation of Accommodations Per Diems | ||
62 | EXCHANGE_DATE | PTRV_DATTN | REDAT | DATS | 8 | 0 | Reference Date of Trip | ||
63 | ROUNDING | PTRV_ROUNDING | XFELD | CHAR | 1 | 0 | Travel Amounts Are Rounded (Indicator) | ||
64 | DZ_LIMIT_180 | PTRV_PS_DZ_LIMIT_180 | XFELD | CHAR | 1 | 0 | Limit DA Fee to 180 Days | ||
65 | .INCLUDE | 0 | 0 | Structure of transp. table PTRV_PERIO | |||||
66 | HDVRS | PTRV_HDVRS | PTRVNUMC2 | NUMC | 2 | 0 | Sequential Number of Travel Expenses Table THEADER | ||
67 | PDATV | REBED | REDAT | DATS | 8 | 0 | Beginning Date of Trip Segment | ||
68 | PUHRV | REBEU | REUHR | TIMS | 6 | 0 | Beginning Time of Trip Segment | ||
69 | PDATB | REEND | REDAT | DATS | 8 | 0 | End Date of Trip Segment | ||
70 | PUHRB | REENU | REUHR | TIMS | 6 | 0 | End Time of Trip Segment | ||
71 | DRUCK | P_PRINT | P_PRINT | CHAR | 1 | 0 | Trip Print Status | ||
72 | ANTRG | ANTRG | ANTRG | CHAR | 1 | 0 | Travel Request or Trip Approved (Indicator) | ||
73 | ABREC | ABREC | ABREC | CHAR | 1 | 0 | Open / To be Settled / Settled (Indicator) | ||
74 | UEBLG | UEBLG | UEBLG | CHAR | 1 | 0 | HR Payroll Transfer (Indicator) | ||
75 | UEBRF | UEBRF | UEBRF | CHAR | 1 | 0 | FI Transfer (Indicator) | ||
76 | UEBDT | UEBDT | UEBDT | CHAR | 1 | 0 | Data Medium Exchange Transfer (Indicator) | ||
77 | TLOCK | PTRV_TLOCK | PTRV_TLOCK | CHAR | 1 | 0 | Indicator: Trip locked | ||
78 | WAERS | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * | |
79 | ABRJ1 | PABRJ | GJAHR | NUMC | 4 | 0 | Payroll Year | ||
80 | ABRP1 | PABRP | PABRP | NUMC | 2 | 0 | Payroll Period | ||
81 | PERM1 | IPERM | CHAR2 | CHAR | 2 | 0 | Period modifier | ||
82 | ABKR1 | ABKRS | ABKRS | CHAR | 2 | 0 | Payroll Area | * | |
83 | BEGP1 | PTRV_BEGP1 | PTRV_BEGP1 | DATS | 8 | 0 | Start of Settlement Period | ||
84 | ENDP1 | PTRV_ENDP1 | PTRV_ENDP1 | DATS | 8 | 0 | End of Settlement Period | ||
85 | ABRJ2 | PABRJ | GJAHR | NUMC | 4 | 0 | Payroll Year | ||
86 | ABRP2 | PABRP | PABRP | NUMC | 2 | 0 | Payroll Period | ||
87 | PERM2 | IPERM | CHAR2 | CHAR | 2 | 0 | Period modifier | ||
88 | ABKR2 | ABKRS | ABKRS | CHAR | 2 | 0 | Payroll Area | * | |
89 | BEGP2 | PTRV_BEGP2 | PTRV_BEGP2 | DATS | 8 | 0 | Start of Settlement Period | ||
90 | ENDP2 | PTRV_ENDP2 | PTRV_ENDP2 | DATS | 8 | 0 | End of Settlement Period | ||
91 | ACCDT | PTRV_ACCDT | PTRV_BEGP1 | DATS | 8 | 0 | Trip Settlement Date | ||
92 | ACCTM | PTRV_ACCTM | REUHR | TIMS | 6 | 0 | Trip Settlement Time | ||
93 | RUNID | TR_EVNUM | NUMC10 | NUMC | 10 | 0 | Sequential number of posting run | ||
94 | VERPA | VERPA | VERPA | CHAR | 1 | 0 | Per-Diem Accounting for Meals | ||
95 | UEBKZ | UEPKZ | UEPKZ | CHAR | 1 | 0 | Per-Diem Accounting for Accommodations | ||
96 | ANUEP | ANUEP | ANUEP | DEC | 2 | 0 | Number of Overnight Stays for Per-Diem Settlement | ||
97 | NO_MILES | PTRV_NO_MILES_ACCOUNTING | CHAR1 | CHAR | 1 | 0 | Indicator: No repeat of travel costs accounting | ||
98 | LSTAY | PTRV_LSTAY | PTRV_CHAR1 | CHAR | 1 | 0 | Meals per diem reduct. for longer stay at same place of work | ||
99 | .INCLU--AP | 0 | 0 | Enhancement of Structure of Travel Expenses Table PTRV_PERIO | |||||
100 | TR_DOPP_ANZAHL | PTRVPS_TR_DOPP_ANZAHL | NUMC3 | NUMC | 3 | 0 | Daily Return: No. of Days with Outb. and Return Trip | ||
101 | TR_EINF_ANZAHL | PTRVPS_TR_EINF_ANZAHL | NUMC3 | NUMC | 3 | 0 | Daily Return: No. of Days only with Outb./ or Return Trip | ||
102 | TR_ENTFERNUNG | PTRVPS_TR_ENTFERNUNG | KMANZ | DEC | 5 | 0 | Daily Return: Distance fr. Residence to New Place of Work | ||
103 | VU_EA_DOPP_ANZ | PTRVPS_VU_EA_DOPP_ANZAHL | NUMC3 | NUMC | 3 | 0 | Own Contribution: No. of Days with Outb./Return Trip b. Move | ||
104 | VU_EA_EINF_ANZ | PTRVPS_VU_EA_EINF_ANZAHL | NUMC3 | NUMC | 3 | 0 | Own Contribution: No. of Days wth Outb./Return Trip b. Move | ||
105 | VU_EA_ENTFERN | PTRVPS_VU_EA_ENTFERNUNG | KMANZ | DEC | 5 | 0 | Own Contribution: Distance to Place of Work before Move | ||
106 | VU_EA_KM_SATZ | PTRVPS_VU_EA_KM_SATZ | GESBE | CURR | 10 | 2 | Own Contribution: KM Rate to Place of Work Before Move | ||
107 | NU_EA_DOPP_ANZ | PTRVPS_NU_EA_DOPP_ANZAHL | NUMC3 | NUMC | 3 | 0 | Own Contrib.: No. of Days wth Outb. and Ret. Trip after Move | ||
108 | NU_EA_EINF_ANZ | PTRVPS_NU_EA_EINF_ANZAHL | NUMC3 | NUMC | 3 | 0 | Own Contrib.: No. of Days with Outb. or Ret. Trip after Move | ||
109 | NU_EA_ENTFERN | PTRVPS_NU_EA_ENTFERNUNG | KMANZ | DEC | 5 | 0 | Own Contribution: Distance to Place of Work after Move | ||
110 | NU_EA_KM_SATZ | PTRVPS_NU_EA_KM_SATZ | GESBE | CURR | 10 | 2 | Own Contribution: KM Rate to Place of Work after Move | ||
111 | V_UNENTGELTLICH | PTRV_V_UNENTGELTLICH | CHAR1 | CHAR | 1 | 0 | Gratuitous Meals for the Entire Month | ||
112 | U_UNENTGELTLICH | PTRV_U_UNENTGELTLICH | CHAR1 | CHAR | 1 | 0 | Gratuitous Accommodations for the Entire Month | ||
113 | REDUC_ERGRU | PTRV_REDUC_ERGRU | CHAR2 | CHAR | 2 | 0 | New Reimbursement Group for Reduction in Meals per Diem | ||
114 | NOT_PAID | PTRV_NOT_PAID | CHAR1 | CHAR | 1 | 0 | No Reimbursement of Trip | ||
115 | WEG_ERH_MAX | PTRV_WEG_ERH_MAX | CHAR1 | CHAR | 1 | 0 | Increased Maximum Trip Segment Reimbursement | ||
116 | ERH_DIENST_INT | PTRV_ERH_DIENST_INT | CHAR1 | CHAR | 1 | 0 | Significant Official Interest | ||
117 | ENTF_WO_DO | PTRV_ENTF_WO_DO | CHAR1 | CHAR | 1 | 0 | Short Distance to Residence/Workplace | ||
118 | DRITTMITTEL | PTRV_DRITTMITTEL | CHAR1 | CHAR | 1 | 0 | Payments and Contributions from Third Parties | ||
119 | ANTRAG_GWE | PTRV_ANTRAG_GWE | CHAR1 | CHAR | 1 | 0 | Request for Full Trip Segment Reimbursement | ||
120 | POLICY_VIOLATION | PTRV_POLICY_VIOLATION | XFELD | CHAR | 1 | 0 | Violation of Travel Policy | ||
121 | EXCEPTION_FLAG | PTRV_EXCEPTION | XFELD | CHAR | 1 | 0 | Exception Indicator | ||
122 | NR_RECEIPTS | PTRV_NR_RECEIPTS | NUMC3 | NUMC | 3 | 0 | Number of Receipts | ||
123 | PERM_TRIP_APPR | PTRV_PERM_TRIP_APPROVAL | XFELD | CHAR | 1 | 0 | Standing Approval of Business Trips | ||
124 | TR_NR_FROM_HOME | PTRVPS_NR_COMMUTES_FROM_HOME | NUMC3 | NUMC | 3 | 0 | Number of Days with Round Trip from Home | ||
125 | VAT_STATUS | PTRV_VAT_STATUS | PTRV_VAT_STATUS | CHAR | 1 | 0 | Status of Data for VAT Refund | ||
126 | .INCLU--AP | 0 | 0 | Second Enhancement to Struct.of Travel Expen. Tab PTRV_PERIO | |||||
127 | TAX_TRIP | PTRVPS_TAX_TRIP | XFELD | CHAR | 1 | 0 | Taxation of Whole Trip | ||
128 | MAX_NIGHTS | ANUEP | ANUEP | DEC | 2 | 0 | Number of Overnight Stays for Per-Diem Settlement | ||
129 | ACT_NIGHTS | ANUEP | ANUEP | DEC | 2 | 0 | Number of Overnight Stays for Per-Diem Settlement | ||
130 | KMGES | KMGES | KMANZ | DEC | 5 | 0 | Total Miles/Kilometers | ||
131 | KZPMF | KZPMF | KZPMF | CHAR | 1 | 0 | Vehicle Type | * | |
132 | PKWKL | PKWKL | PKWKL | CHAR | 3 | 0 | Vehicle Class | * | |
133 | DATFH | PTRV_DATFH | REDAT | DATS | 8 | 0 | Domestic Departure, Landing in Destination Country: Date | ||
134 | UHRFH | PTRV_UHRFH | REUHR | TIMS | 6 | 0 | Trip out, landing at destination: Time | ||
135 | DATFZ | PTRV_DATFZ | REDAT | DATS | 8 | 0 | Return Trip Departure in Foreign Country: Date | ||
136 | UHRFZ | PTRV_UHRFZ | REUHR | TIMS | 6 | 0 | Return trip departure abroad: Time | ||
137 | .INCLU-ADR | 0 | 0 | Travel Web Interface: Addresses | |||||
138 | ADRNRADR | AD_ADDRNUM | AD_ADDRNUM | CHAR | 10 | 0 | Address number | * | |
139 | CITYADR | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
140 | CITY_DISTRICTADR | AD_CITY2 | TEXT40 | CHAR | 40 | 0 | District | ||
141 | POST_CODEADR | AD_PSTCD1 | CHAR10 | CHAR | 10 | 0 | City postal code | ||
142 | CITY_CODEADR | AD_CITYNUM | CITY_CODE | CHAR | 12 | 0 | City code for city/street file | * | |
143 | STREETADR | AD_STREET | TEXT60 | CHAR | 60 | 0 | Street | ||
144 | HOUSE_NUMADR | AD_HSNM1 | TEXT10 | CHAR | 10 | 0 | House Number | ||
145 | COUNTRYADR | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | * | |
146 | REGIONADR | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | * | |
147 | PLAN_ACTIVITY_TYPE | PLAN_ACTIVITY | FTPD_PLAN_ACTIVITY | CHAR | 1 | 0 | Trip Activity Type | * | |
148 | ESTIMATED_COST | PTRV_ESTIMATED_COST | WERTV7 | CURR | 13 | 2 | Estimated Total Cost of Trip | ||
149 | ESTIMATED_COST_CURR | WAERS | WAERS | CUKY | 5 | 0 | Currency Key | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HEAD_PERIO | AGRZ1 | T702O | LAND1 | KEY | 1 | CN |
2 | HEAD_PERIO | BEREI | T702X | BEREI | KEY | 1 | CN |
3 | HEAD_PERIO | GRBER | T702X | BEREI | KEY | 1 | CN |
4 | HEAD_PERIO | GRGIO | T702O | RGION | KEY | 1 | CN |
5 | HEAD_PERIO | HRGIO | T702O | RGION | KEY | 1 | CN |
6 | HEAD_PERIO | KZREA | T702G | KZREA | KEY | 1 | CN |
7 | HEAD_PERIO | KZTKT | T702R | KZTKT | KEY | 1 | CN |
8 | HEAD_PERIO | MOLGA | T500L | MOLGA | |||
9 | HEAD_PERIO | MOREI | T702N | MOREI | KEY | 1 | CN |
10 | HEAD_PERIO | SCHEM | T706S | SCHEM | KEY | 1 | CN |
11 | HEAD_PERIO | ZLAND | T702O | LAND1 | KEY | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in | 100 |