PTRV_HEAD

Transparent Table Application Table
78 Fields 6 CDS Views

General Trip Data

PTRV_HEAD is an SAP database table in S/4HANA. General Trip Data. It contains 78 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_TravelExpense view_entity from EXTENSION Travel Expense General Data - Extension
I_TravelExpenseGeneralData view_entity from BASIC Travel Expense General Data
I_TravelGeneralData view_entity from BASIC Travel Request General Data
I_TravelRequestNumberData view from BASIC Travel Request Number
I_TravelStatisticAmountData view_entity inner BASIC Trvl Expn Trip Statistics and Amounts
I_TrvlAprvdFutureRequest view_entity from BASIC Future Approved Travel Requests

Fields (78)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY pernr PERNR_D Personnel No.
KEY reinr REINR Trip Number
KEY hdvrs PTRV_HDVRS Sequential no.
molga MOLGA HCM Local.
morei MOREI Trip Prov. Variant
schem RSCHE Trip Schema
kzrea KZREA Trip Type S
berei BEREI Trip Type E
kztkt KZTKT Activity
zort1 PTRV_RZIELORT Destin.
zland LNDGR Trip Ctry/Reg
hrgio HRGIO RegionMainDest.
ndnst PTRV_PS_AGENCY_AFTER Workplace A.
kunde RKUNDE Reason
datv1 FITV_REBED Start Date
uhrv1 REBEU Trip Begins At
datb1 FITV_REEND End Date
uhrb1 REENU Trip Ends At
dath1 DATGH Dom. Departure
uhrh1 UHRGH Time
datr1 DATGZ Domest. Arrival
uhrr1 UHRGZ Time
agrz1 LNDGR Trip Ctry/Reg
grgio GRGIO Region RetCross
grber PTRV_GRBER Type enterprise
uzkvg PTRV_UZKVG MovingCost Refund
zusag PTRV_PS_ACCEPTING_DEPARTMENT Accepting Dept
endrg PTRV_ENDRG TravelAllow End
depar PTRV_DEPAR Departure
arrvl PTRV_ARRVL Arrival Work
retrn PTRV_RETRN Return
dates AEDAT Changed On
times AEUHR Changed at
uname AENAM Changed By
repid AEREP Change Report
dantn PTRV_DANTN Trip Start Work
fintn PTRV_FINTN Bus.Trip Return
request PTRV_OBJEKT R/P/E ID
travel_plan PTRV_OBJEKT R/P/E ID
expenses PTRV_OBJEKT R/P/E ID
st_trgtg PTRV_PS_ST_TRGTG Tax Per Diems
st_trgall PTRV_PS_ST_TRGALL Tax. Sep. Allowance
periodenart PTRV_PS_PERIODENART Period type
dat_reduc1 PTRV_PS_DAT_REDUC1 Reduction Level 1
dat_reduc2 PTRV_PS_DAT_REDUC2 Reduction Level 2
datv1_dienst PTRV_PS_DATV1_DIENST Work Start
uhrv1_dienst PTRV_PS_UHRV1_DIENST Time Work Commences
datb1_dienst PTRV_PS_DATB1_DIENST Date Work Ends
uhrb1_dienst PTRV_PS_UHRB1_DIENST Time Work Ends
abordnung PTRV_PS_ABORD Assoc. SepAllowance
st_trg_typ PTRV_PS_ST_TYP Temp.Sep.Allwnc
st_wohn_typ PTRV_ST_WOHN_TYP With Own Home
kein_reisegeld PTRV_KEIN_REISEGELD No Per Diem
tax_per_diem PTRV_TAX_PER_DIEM Meals PD Taxation
tax_pd_man PTRV_TAX_PD_MAN Man.Tax.MealPDs
tax_ov_man PTRV_TAX_OV_MAN Man.Tax.Acc.PDs
exchange_date PTRV_DATTN Reference Date
rounding PTRV_ROUNDING Round
dz_limit_180 PTRV_PS_DZ_LIMIT_180 DA Limit 180
calid PTRV_PS_CALID Fac.Calendar ID
duration_trip_breaks PTRVPS_SUM_ATTR_TRIP_BREAK Priv. Trip Break
addr_depar PTRV_ADDR_DEPAR Departure Point
addr_arrvl PTRV_ADDR_ARRVL Arrival Point
curr_duty_land PTRV_PS_DUTY_LAND Duty Ctry/Reg.
curr_duty_region PTRV_PS_DUTY_REGION Duty Region
relocation_for_abord PTRV_PS_RELOC_ABORD Sep. Allow.
start_abroad PTRV_PS_START_ABROAD Start Abroad
start_country PTRV_PS_START_COUNTRY Deprt.Ctry/Reg.
start_region PTRV_PS_START_REGION Start Region
one_way_trip PTRV_PS_ONE_WAY Ends at Dest.
reloc_trip_ends PTRV_PS_RELOC_TRIP_ENDS End Reloc. Trip
trip_ends_temp_acc PTRV_PS_TRIP_ENDS_TEMP_ACC Not in New Residence
period_division PTRV_PS_PERIODSIZE Splitting
reloc_trip_begins PTRV_PS_RELOC_TRIP_BEGINS Rel. Trip Start
origin_sep_allowance PTRV_PS_ORIGIN_SEP_ALL Orig. SA Event
origin_sep_all_date PTRV_PS_ORIGIN_SEP_ALL_DATE Start Date
dummy_trvexpense_incl_eew_ps CFD_DUMMY Dummy

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- General Trip Data
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTRV_HEAD (
    MANDT,                         -- Client [MANDT]
    PERNR,                         -- Personnel No. [PERNR_D]
    REINR,                         -- Trip Number [REINR]
    HDVRS,                         -- Sequential no. [PTRV_HDVRS]
    MOLGA,                         -- HCM Local. [MOLGA]
    MOREI,                         -- Trip Prov. Variant [MOREI]
    SCHEM,                         -- Trip Schema [RSCHE]
    KZREA,                         -- Trip Type S [KZREA]
    BEREI,                         -- Trip Type E [BEREI]
    KZTKT,                         -- Activity [KZTKT]
    ZORT1,                         -- Destin. [PTRV_RZIELORT]
    ZLAND,                         -- Trip Ctry/Reg [LNDGR]
    HRGIO,                         -- RegionMainDest. [HRGIO]
    NDNST,                         -- Workplace A. [PTRV_PS_AGENCY_AFTER]
    KUNDE,                         -- Reason [RKUNDE]
    DATV1,                         -- Start Date [FITV_REBED]
    UHRV1,                         -- Trip Begins At [REBEU]
    DATB1,                         -- End Date [FITV_REEND]
    UHRB1,                         -- Trip Ends At [REENU]
    DATH1,                         -- Dom. Departure [DATGH]
    UHRH1,                         -- Time [UHRGH]
    DATR1,                         -- Domest. Arrival [DATGZ]
    UHRR1,                         -- Time [UHRGZ]
    AGRZ1,                         -- Trip Ctry/Reg [LNDGR]
    GRGIO,                         -- Region RetCross [GRGIO]
    GRBER,                         -- Type enterprise [PTRV_GRBER]
    UZKVG,                         -- MovingCost Refund [PTRV_UZKVG]
    ZUSAG,                         -- Accepting Dept [PTRV_PS_ACCEPTING_DEPARTMENT]
    ENDRG,                         -- TravelAllow End [PTRV_ENDRG]
    DEPAR,                         -- Departure [PTRV_DEPAR]
    ARRVL,                         -- Arrival Work [PTRV_ARRVL]
    RETRN,                         -- Return [PTRV_RETRN]
    DATES,                         -- Changed On [AEDAT]
    TIMES,                         -- Changed at [AEUHR]
    UNAME,                         -- Changed By [AENAM]
    REPID,                         -- Change Report [AEREP]
    DANTN,                         -- Trip Start Work [PTRV_DANTN]
    FINTN,                         -- Bus.Trip Return [PTRV_FINTN]
    REQUEST,                       -- R/P/E ID [PTRV_OBJEKT]
    TRAVEL_PLAN,                   -- R/P/E ID [PTRV_OBJEKT]
    EXPENSES,                      -- R/P/E ID [PTRV_OBJEKT]
    ST_TRGTG,                      -- Tax Per Diems [PTRV_PS_ST_TRGTG]
    ST_TRGALL,                     -- Tax. Sep. Allowance [PTRV_PS_ST_TRGALL]
    PERIODENART,                   -- Period type [PTRV_PS_PERIODENART]
    DAT_REDUC1,                    -- Reduction Level 1 [PTRV_PS_DAT_REDUC1]
    DAT_REDUC2,                    -- Reduction Level 2 [PTRV_PS_DAT_REDUC2]
    DATV1_DIENST,                  -- Work Start [PTRV_PS_DATV1_DIENST]
    UHRV1_DIENST,                  -- Time Work Commences [PTRV_PS_UHRV1_DIENST]
    DATB1_DIENST,                  -- Date Work Ends [PTRV_PS_DATB1_DIENST]
    UHRB1_DIENST,                  -- Time Work Ends [PTRV_PS_UHRB1_DIENST]
    ABORDNUNG,                     -- Assoc. SepAllowance [PTRV_PS_ABORD]
    ST_TRG_TYP,                    -- Temp.Sep.Allwnc [PTRV_PS_ST_TYP]
    ST_WOHN_TYP,                   -- With Own Home [PTRV_ST_WOHN_TYP]
    KEIN_REISEGELD,                -- No Per Diem [PTRV_KEIN_REISEGELD]
    TAX_PER_DIEM,                  -- Meals PD Taxation [PTRV_TAX_PER_DIEM]
    TAX_PD_MAN,                    -- Man.Tax.MealPDs [PTRV_TAX_PD_MAN]
    TAX_OV_MAN,                    -- Man.Tax.Acc.PDs [PTRV_TAX_OV_MAN]
    EXCHANGE_DATE,                 -- Reference Date [PTRV_DATTN]
    ROUNDING,                      -- Round [PTRV_ROUNDING]
    DZ_LIMIT_180,                  -- DA Limit 180 [PTRV_PS_DZ_LIMIT_180]
    CALID,                         -- Fac.Calendar ID [PTRV_PS_CALID]
    DURATION_TRIP_BREAKS,          -- Priv. Trip Break [PTRVPS_SUM_ATTR_TRIP_BREAK]
    ADDR_DEPAR,                    -- Departure Point [PTRV_ADDR_DEPAR]
    ADDR_ARRVL,                    -- Arrival Point [PTRV_ADDR_ARRVL]
    CURR_DUTY_LAND,                -- Duty Ctry/Reg. [PTRV_PS_DUTY_LAND]
    CURR_DUTY_REGION,              -- Duty Region [PTRV_PS_DUTY_REGION]
    RELOCATION_FOR_ABORD,          -- Sep. Allow. [PTRV_PS_RELOC_ABORD]
    START_ABROAD,                  -- Start Abroad [PTRV_PS_START_ABROAD]
    START_COUNTRY,                 -- Deprt.Ctry/Reg. [PTRV_PS_START_COUNTRY]
    START_REGION,                  -- Start Region [PTRV_PS_START_REGION]
    ONE_WAY_TRIP,                  -- Ends at Dest. [PTRV_PS_ONE_WAY]
    RELOC_TRIP_ENDS,               -- End Reloc. Trip [PTRV_PS_RELOC_TRIP_ENDS]
    TRIP_ENDS_TEMP_ACC,            -- Not in New Residence [PTRV_PS_TRIP_ENDS_TEMP_ACC]
    PERIOD_DIVISION,               -- Splitting [PTRV_PS_PERIODSIZE]
    RELOC_TRIP_BEGINS,             -- Rel. Trip Start [PTRV_PS_RELOC_TRIP_BEGINS]
    ORIGIN_SEP_ALLOWANCE,          -- Orig. SA Event [PTRV_PS_ORIGIN_SEP_ALL]
    ORIGIN_SEP_ALL_DATE,           -- Start Date [PTRV_PS_ORIGIN_SEP_ALL_DATE]
    DUMMY_TRVEXPENSE_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS)
);

Learn More