SAP Table PTP02
Structure of Travel Expenses Table PTRV_HEAD
PTP02 (Structure of Travel Expenses Table PTRV_HEAD) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link PTP02 to other SAP tables.
PTP02 table fields
Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||
PERNR | Personnel Number | PERNR_D | NUMC | 8 | 0 | |||||||
REINR | Trip Number | REINR | NUMC | 10 | 0 | |||||||
HDVRS | Sequential Number of Travel Expenses Table THEADER | PTRV_HDVRS | NUMC | 2 | 0 | |||||||
MOLGA | Country Grouping | MOLGA | T500L | CHAR | 2 | 0 | ||||||
MOREI | Trip Provision Variant | MOREI | T702N | CHAR | 2 | 0 | ||||||
SCHEM | Trip schema | RSCHE | T706S | CHAR | 2 | 0 | ||||||
KZREA | Trip Type: Statutory | KZREA | T702G | CHAR | 1 | 0 | ||||||
BEREI | Trip Type: Enterprise-Specific | BEREI | T702X | CHAR | 1 | 0 | ||||||
KZTKT | Trip Activity Type | KZTKT | T702R | CHAR | 1 | 0 | ||||||
ZORT1 | Location | RZIELORT | CHAR | 59 | 0 | |||||||
ZLAND | Trip Country / Trip Country Group | LNDGR | T702O | CHAR | 3 | 0 | ||||||
HRGIO | Region of Main Destination | HRGIO | T702O | CHAR | 5 | 0 | ||||||
NDNST | Name of new administrative office (P.S.) | PTRV_NDNST | CHAR | 25 | 0 | |||||||
KUNDE | Reason for Trip (for example, customer/requisitioner) | RKUNDE | CHAR | 59 | 0 | |||||||
DATV1 | Beginning Date of Trip Segment | REBED | DATS | 8 | 0 | |||||||
UHRV1 | Beginning Time of Trip Segment | REBEU | TIMS | 6 | 0 | |||||||
DATB1 | End Date of Trip Segment | REEND | DATS | 8 | 0 | |||||||
UHRB1 | End Time of Trip Segment | REENU | TIMS | 6 | 0 | |||||||
DATH1 | Border Crossing (Trip Out): Date | DATGH | DATS | 8 | 0 | |||||||
UHRH1 | Time: Border crossing(trip out) | UHRGH | TIMS | 6 | 0 | |||||||
DATR1 | Border Crossing (Return Trip): Date | DATGZ | DATS | 8 | 0 | |||||||
UHRR1 | Time: Border crossing(return trip) | UHRGZ | TIMS | 6 | 0 | |||||||
AGRZ1 | Trip Country / Trip Country Group | LNDGR | T702O | CHAR | 3 | 0 | ||||||
GRGIO | Region of Border Crossing: Return Trip | GRGIO | T702O | CHAR | 5 | 0 | ||||||
GRBER | Border crossing: Trip type enterprise-specific | PTRV_GRBER | T702X | CHAR | 1 | 0 | ||||||
UZKVG | Confirmation of Moving Costs Refund | PTRV_UZKVG | CHAR | 1 | 0 | |||||||
ZUSAG | Admin. Office That Confirmed Moving Costs Compensation (PS) | PTRV_ZUSAG | CHAR | 25 | 0 | |||||||
ENDRG | Different End of Travel Allowance (in Separation Allowance) | PTRV_ENDRG | DATS | 8 | 0 | |||||||
DEPAR | Departure from Residence or Place of Work | PTRV_DEPAR | CHAR | 1 | 0 | |||||||
ARRVL | Return Trip: Arrival at Place of Residence or Work | PTRV_ARRVL | CHAR | 1 | 0 | |||||||
RETRN | Arrival at Accommodations or New Workplace | PTRV_RETRN | CHAR | 1 | 0 | |||||||
DATES | Changed On | AEDAT | DATS | 8 | 0 | |||||||
TIMES | Time of Last Change | AEUHR | TIMS | 6 | 0 | |||||||
UNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | 0 | |||||||
REPID | Change Report | AEREP | CHAR | 40 | 0 | |||||||
DANTN | Trip Number of Corresponding Trip to Start Work | PTRV_DANTN | NUMC | 10 | 0 | |||||||
FINTN | Trip Number of Associated Business Trip Return | PTRV_FINTN | NUMC | 10 | 0 | |||||||
REQUEST | Indicator for objects request, plan and expense report | PTRV_OBJEKT | CHAR | 1 | 0 | |||||||
TRAVEL_PLAN | Indicator for objects request, plan and expense report | PTRV_OBJEKT | CHAR | 1 | 0 | |||||||
EXPENSES | Indicator for objects request, plan and expense report | PTRV_OBJEKT | CHAR | 1 | 0 | |||||||
ST_TRGTG | Start of Taxation for Per Diem Separation Allowance | PTRV_PS_ST_TRGTG | DATS | 8 | 0 | |||||||
ST_TRGALL | Start of Taxation for Complete Separation Allowance | PTRV_PS_ST_TRGALL | DATS | 8 | 0 | |||||||
PERIODENART | Associated Trip Period Types | PTRV_PS_PERIODENART | CHAR | 1 | 0 |
Possible values
|
||||||
DAT_REDUC1 | Reduction of Entire Separation or Travel Allowance Level 1 | PTRV_PS_DAT_REDUC1 | DATS | 8 | 0 | |||||||
DAT_REDUC2 | Reduction of Separation or Travel Allowance Level 2 | PTRV_PS_DAT_REDUC2 | DATS | 8 | 0 | |||||||
DATV1_DIENST | Date of Commencement of Work | PTRV_PS_DATV1_DIENST | DATS | 8 | 0 | |||||||
UHRV1_DIENST | Time at Which Work Commences | PTRV_PS_UHRV1_DIENST | TIMS | 6 | 0 | |||||||
DATB1_DIENST | Date on Which Work Ends | PTRV_PS_DATB1_DIENST | DATS | 8 | 0 | |||||||
UHRB1_DIENST | Time at Which Work Ends | PTRV_PS_UHRB1_DIENST | TIMS | 6 | 0 | |||||||
ABORDNUNG | Associated Superior Separation Allowance | PTRV_PS_ABORD | NUMC | 10 | 0 | |||||||
ST_TRG_TYP | Temporary Assignment (Indicator) | PTRV_PS_ST_TYP | CHAR | 1 | 0 | |||||||
ST_WOHN_TYP | Home for Separation Allowance Taxation | PTRV_ST_WOHN_TYP | CHAR | 1 | 0 | |||||||
KEIN_REISEGELD | No Separation Allowance for Travel Is Paid (Indicator) | PTRV_KEIN_REISEGELD | CHAR | 1 | 0 | |||||||
TAX_PER_DIEM | Automatic Taxation of Meals and Accommodations Per Diems | PTRV_TAX_PER_DIEM | CHAR | 1 | 0 |
Possible values
|
||||||
TAX_PD_MAN | Manually Triggered Taxation of Meals Per Diems | PTRV_TAX_PD_MAN | CHAR | 1 | 0 |
Possible values
|
||||||
TAX_OV_MAN | Manually Triggered Taxation of Accommodations Per Diems | PTRV_TAX_OV_MAN | CHAR | 1 | 0 |
Possible values
|
||||||
EXCHANGE_DATE | Reference Date of Trip | PTRV_DATTN | DATS | 8 | 0 | |||||||
ROUNDING | Travel Amounts Are Rounded (Indicator) | PTRV_ROUNDING | CHAR | 1 | 0 |
Possible values
|
||||||
DZ_LIMIT_180 | Limitation of DA Fee to 180 Days | PTRV_PS_DZ_LIMIT_180 | CHAR | 1 | 0 |
Possible values
|
PTP02 foreign key relationships
Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
---|---|---|---|---|---|---|
PTP02 | AGRZ1 | SYST | MANDT | T702O | Trip country/Trip region/Trip country group | MANDT |
PTP02 | AGRZ1 | PTP02 | MOREI | T702O | Trip country/Trip region/Trip country group | MOREI |
PTP02 | AGRZ1 | PTP02 | AGRZ1 | T702O | Trip country/Trip region/Trip country group | LAND1 |
PTP02 | AGRZ1 | * | T702O | Trip country/Trip region/Trip country group | RGION | |
PTP02 | BEREI | PTP02 | MOREI | T702X | Enterprise-specific Trip Types | MOREI |
PTP02 | BEREI | PTP02 | BEREI | T702X | Enterprise-specific Trip Types | BEREI |
PTP02 | BEREI | SYST | MANDT | T702X | Enterprise-specific Trip Types | MANDT |
PTP02 | GRBER | SYST | MANDT | T702X | Enterprise-specific Trip Types | MANDT |
PTP02 | GRBER | PTP02 | MOREI | T702X | Enterprise-specific Trip Types | MOREI |
PTP02 | GRBER | PTP02 | GRBER | T702X | Enterprise-specific Trip Types | BEREI |
PTP02 | GRGIO | SYST | MANDT | T702O | Trip country/Trip region/Trip country group | MANDT |
PTP02 | GRGIO | PTP02 | MOREI | T702O | Trip country/Trip region/Trip country group | MOREI |
PTP02 | GRGIO | PTP02 | AGRZ1 | T702O | Trip country/Trip region/Trip country group | LAND1 |
PTP02 | GRGIO | PTP02 | GRGIO | T702O | Trip country/Trip region/Trip country group | RGION |
PTP02 | HRGIO | PTP02 | MOREI | T702O | Trip country/Trip region/Trip country group | MOREI |
PTP02 | HRGIO | PTP02 | ZLAND | T702O | Trip country/Trip region/Trip country group | LAND1 |
PTP02 | HRGIO | PTP02 | HRGIO | T702O | Trip country/Trip region/Trip country group | RGION |
PTP02 | HRGIO | SYST | MANDT | T702O | Trip country/Trip region/Trip country group | MANDT |
PTP02 | KZREA | SYST | MANDT | T702G | Statutory trip types | MANDT |
PTP02 | KZREA | PTP02 | MOREI | T702G | Statutory trip types | MOREI |
PTP02 | KZREA | PTP02 | KZREA | T702G | Statutory trip types | KZREA |
PTP02 | KZTKT | SYST | MANDT | T702R | Trip Activity Types | MANDT |
PTP02 | KZTKT | PTP02 | MOREI | T702R | Trip Activity Types | MOREI |
PTP02 | KZTKT | PTP02 | KZTKT | T702R | Trip Activity Types | KZTKT |
PTP02 | MOLGA | PTP02 | MOLGA | T500L | Personnel Country Grouping | MOLGA |
PTP02 | MOREI | SYST | MANDT | T702N | Trip Provision Variants | MANDT |
PTP02 | MOREI | PTP02 | MOREI | T702N | Trip Provision Variants | MOREI |
PTP02 | SCHEM | SYST | MANDT | T706S | Trip Schema | MANDT |
PTP02 | SCHEM | PTP02 | MOREI | T706S | Trip Schema | MOREI |
PTP02 | SCHEM | PTP02 | SCHEM | T706S | Trip Schema | SCHEM |
PTP02 | ZLAND | PTP02 | ZLAND | T702O | Trip country/Trip region/Trip country group | LAND1 |
PTP02 | ZLAND | PTP02 | HRGIO | T702O | Trip country/Trip region/Trip country group | RGION |
PTP02 | ZLAND | SYST | MANDT | T702O | Trip country/Trip region/Trip country group | MANDT |
PTP02 | ZLAND | PTP02 | MOREI | T702O | Trip country/Trip region/Trip country group | MOREI |