SAP table PTRV_HEAD (General Trip Data)

SAP table PTRV_HEAD has 4 primary key fields being MANDT,PERNR,REINR,HDVRS.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 * MANDT
PERNR Personnel Number NUMC 8 0 PERNR_D
REINR Trip Number NUMC 10 0 REINR
HDVRS Sequential Number of Travel Expenses Table THEADER NUMC 2 0 PTRV_HDVRS
MOLGA HCM Localization CHAR 2 0 T500L MOLGA
MOREI Trip Provision Variant CHAR 2 0 T702N MOREI
SCHEM Trip Schema CHAR 2 0 T706S RSCHE
KZREA Trip Type: Statutory CHAR 1 0 T702G KZREA
BEREI Trip Type: Enterprise-Specific CHAR 1 0 T702X BEREI
KZTKT Trip Activity Type CHAR 1 0 T702R KZTKT
ZORT1 Location CHAR 59 0 RZIELORT
ZLAND Trip Country / Trip Country Group CHAR 3 0 T702O LNDGR
HRGIO Region of Main Destination CHAR 5 0 T702O HRGIO
NDNST Name of new administrative office (P.S.) CHAR 25 0 PTRV_NDNST
KUNDE Reason for Trip (for example, customer/requisitioner) CHAR 59 0 RKUNDE
DATV1 Beginning Date of Trip Segment DATS 8 0 REBED
UHRV1 Beginning Time of Trip Segment TIMS 6 0 REBEU
DATB1 End Date of Trip Segment DATS 8 0 REEND
UHRB1 End Time of Trip Segment TIMS 6 0 REENU
DATH1 Border Crossing (Trip Out): Date DATS 8 0 DATGH
UHRH1 Time: Border crossing(trip out) TIMS 6 0 UHRGH
DATR1 Border Crossing (Return Trip): Date DATS 8 0 DATGZ
UHRR1 Time: Border crossing(return trip) TIMS 6 0 UHRGZ
AGRZ1 Trip Country / Trip Country Group CHAR 3 0 T702O LNDGR
GRGIO Region of Border Crossing: Return Trip CHAR 5 0 T702O GRGIO
GRBER Border crossing: Trip type enterprise-specific CHAR 1 0 T702X PTRV_GRBER
UZKVG Confirmation of Moving Costs Refund CHAR 1 0 PTRV_UZKVG
ZUSAG Admin. Office That Confirmed Moving Costs Compensation (PS) CHAR 25 0 PTRV_ZUSAG
ENDRG Different End of Travel Allowance (in Separation Allowance) DATS 8 0 PTRV_ENDRG
DEPAR Departure from Residence or Place of Work CHAR 1 0 PTRV_DEPAR
ARRVL Return Trip: Arrival at Place of Residence or Work CHAR 1 0 PTRV_ARRVL
RETRN Arrival at Accommodations or New Workplace CHAR 1 0 PTRV_RETRN
DATES Last Changed On DATS 8 0 AEDAT
TIMES Time of Last Change TIMS 6 0 AEUHR
UNAME Name of Person Who Changed Object CHAR 12 0 AENAM
REPID Change Report CHAR 40 0 AEREP
DANTN Trip Number of Corresponding Trip to Start Work NUMC 10 0 PTRV_DANTN
FINTN Trip Number of Associated Business Trip Return NUMC 10 0 PTRV_FINTN
REQUEST Indicator for objects request, plan and expense report CHAR 1 0 PTRV_OBJEKT
TRAVEL_PLAN Indicator for objects request, plan and expense report CHAR 1 0 PTRV_OBJEKT
EXPENSES Indicator for objects request, plan and expense report CHAR 1 0 PTRV_OBJEKT
ST_TRGTG Start of Taxation for Per Diem Separation Allowance DATS 8 0 PTRV_PS_ST_TRGTG
ST_TRGALL Start of Taxation for Complete Separation Allowance DATS 8 0 PTRV_PS_ST_TRGALL
PERIODENART Associated Trip Period Types CHAR 1 0 PTRV_PS_PERIODENART
Normal Trip
T Separation Allowance Periods
DAT_REDUC1 Reduction of Entire Separation or Travel Allowance Level 1 DATS 8 0 PTRV_PS_DAT_REDUC1
DAT_REDUC2 Reduction of Separation or Travel Allowance Level 2 DATS 8 0 PTRV_PS_DAT_REDUC2
DATV1_DIENST Date of Commencement of Work DATS 8 0 PTRV_PS_DATV1_DIENST
UHRV1_DIENST Time at Which Work Commences TIMS 6 0 PTRV_PS_UHRV1_DIENST
DATB1_DIENST Date on Which Work Ends DATS 8 0 PTRV_PS_DATB1_DIENST
UHRB1_DIENST Time at Which Work Ends TIMS 6 0 PTRV_PS_UHRB1_DIENST
ABORDNUNG Associated Superior Separation Allowance NUMC 10 0 PTRV_PS_ABORD
ST_TRG_TYP Temporary Assignment (Indicator) CHAR 1 0 PTRV_PS_ST_TYP
ST_WOHN_TYP Home for Separation Allowance Taxation CHAR 1 0 PTRV_ST_WOHN_TYP
KEIN_REISEGELD No Separation Allowance for Travel Is Paid (Indicator) CHAR 1 0 PTRV_KEIN_REISEGELD
TAX_PER_DIEM Automatic Taxation of Meals and Accommodations Per Diems CHAR 1 0 PTRV_TAX_PER_DIEM
TAX_PD_MAN Manually Triggered Taxation of Meals Per Diems CHAR 1 0 PTRV_TAX_PD_MAN
TAX_OV_MAN Manually Triggered Taxation of Accommodations Per Diems CHAR 1 0 PTRV_TAX_OV_MAN
EXCHANGE_DATE Reference Date of Trip DATS 8 0 PTRV_DATTN
ROUNDING Travel Amounts Are Rounded (Indicator) CHAR 1 0 PTRV_ROUNDING
DZ_LIMIT_180 Limitation of DA Fee to 180 Days CHAR 1 0 PTRV_PS_DZ_LIMIT_180
CALID Factory Calendar CHAR 2 0 TFACD PTRV_PS_CALID
DURATION_TRIP_BREAKS Details on Duration of Private Trip Breaks (PS) CHAR 1 0 PTRVPS_SUM_ATTR_TRIP_BREAK
No Private Trip Breaks
G At Least One Long Trip Break
K At Least One Short, But No Long Trip Breaks
ADDR_DEPAR Address of Departure Before Business Trip CHAR 59 0 PTRV_ADDR_DEPAR
ADDR_ARRVL Address of Arrival After Business Trip CHAR 59 0 PTRV_ADDR_ARRVL
START_ABROAD Trip Starts Abroad CHAR 1 0 PTRV_PS_START_ABROAD
START_COUNTRY Country in Which Trip Starts CHAR 3 0 T702O PTRV_PS_START_COUNTRY
START_REGION Region in Which Trip Starts CHAR 5 0 T702O PTRV_PS_START_REGION

PTRV_HEAD foreign key relationships

Table Field Check Table Check Field
0 PTRV_HEAD AGRZ1 T702O Trip country/Trip region/Trip country group MOREI
0 PTRV_HEAD AGRZ1 T702O Trip country/Trip region/Trip country group LAND1
0 PTRV_HEAD AGRZ1 T702O Trip country/Trip region/Trip country group RGION
1 PTRV_HEAD BEREI T702X Enterprise-specific Trip Types MOREI
0 PTRV_HEAD GRBER T702X Enterprise-specific Trip Types MOREI
1 PTRV_HEAD GRGIO T702O Trip country/Trip region/Trip country group MOREI
1 PTRV_HEAD GRGIO T702O Trip country/Trip region/Trip country group LAND1
1 PTRV_HEAD GRGIO T702O Trip country/Trip region/Trip country group RGION
0 PTRV_HEAD HRGIO T702O Trip country/Trip region/Trip country group MOREI
0 PTRV_HEAD HRGIO T702O Trip country/Trip region/Trip country group LAND1
0 PTRV_HEAD HRGIO T702O Trip country/Trip region/Trip country group RGION
1 PTRV_HEAD KZREA T702G Statutory trip types MANDT
1 PTRV_HEAD KZREA T702G Statutory trip types MOREI
1 PTRV_HEAD KZREA T702G Statutory trip types KZREA
0 PTRV_HEAD KZTKT T702R Trip Activity Types MANDT
0 PTRV_HEAD KZTKT T702R Trip Activity Types MOREI
0 PTRV_HEAD KZTKT T702R Trip Activity Types KZTKT
1 PTRV_HEAD MOLGA T500L Personnel Country Grouping MOLGA
0 PTRV_HEAD MOREI T702N Trip Provision Variants MOREI
1 PTRV_HEAD SCHEM T706S Trip Schema MOREI
1 PTRV_HEAD SCHEM T706S Trip Schema SCHEM
0 PTRV_HEAD START_COUNTRY T702O Trip country/Trip region/Trip country group MOREI
0 PTRV_HEAD START_COUNTRY T702O Trip country/Trip region/Trip country group LAND1
0 PTRV_HEAD START_COUNTRY T702O Trip country/Trip region/Trip country group RGION
1 PTRV_HEAD START_REGION T702O Trip country/Trip region/Trip country group MOREI
1 PTRV_HEAD START_REGION T702O Trip country/Trip region/Trip country group LAND1
1 PTRV_HEAD START_REGION T702O Trip country/Trip region/Trip country group RGION
0 PTRV_HEAD ZLAND T702O Trip country/Trip region/Trip country group MOREI
0 PTRV_HEAD ZLAND T702O Trip country/Trip region/Trip country group LAND1
0 PTRV_HEAD ZLAND T702O Trip country/Trip region/Trip country group RGION