PTRV_HEAD

30 Fields 6 CDS Views

PTRV_HEAD is an SAP database table in S/4HANA. It contains 30 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 (30)

KeyField CDS FieldsUsed in Views
KEY hdvrs TravelExpnSequentialNumber 3
KEY pernr PersonnelNumber 4
KEY reinr TravelTripNumber 4
addr_arrvl AddressArrivalName 2
addr_depar AddressDepartureName 2
calid TrvlExpnFactoryCalendarID,TrvlReqFactoryCalendarID 2
curr_duty_region CurrentDutyRegion 2
dantn TrvlExpnNmbrForCorrespgWrk,TrvlReqNmbrForCorrespgWrk 2
dates LastChangeDate 2
dz_limit_180 DailyAllwncIsLmtdTo180 2
exchange_date ReferenceDate 2
expenses TripHasExpenses 1
kein_reisegeld TrvlExpnHasPaidPerDiem,TrvlReqHasPaidPerDiem 2
kztkt TripActivityType 2
molga CountryGroup 2
periodenart PeriodType 2
repid ChangeReportName 2
request TravelRequestIsExists 1
retrn ReturnWorkplaceValue 2
rounding TravelExpenseAmountIsRounded,TravelRequestAmountIsRounded 2
schem TripSchema 2
st_trg_typ TrvlExpnHasTmpSprtnAllwnc,TrvlReqHasTmpSprtnAllwnc 2
times LastChangedAtTime 2
uhrb1 ArrivalEndTime 2
uhrb1_dienst WorkEndsTime 2
uhrh1 TravelExpenseOutBoundTime,TravelRequestOutBoundTime 2
uhrv1 DepartureBeginTime 2
uhrv1_dienst WorkCommencesTime 2
uname ChangedByName 2
zusag AdminOfficeMoveLabel 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTRV_HEAD (
    HDVRS,
    PERNR,
    REINR,
    ADDR_ARRVL,
    ADDR_DEPAR,
    CALID,
    CURR_DUTY_REGION,
    DANTN,
    DATES,
    DZ_LIMIT_180,
    EXCHANGE_DATE,
    EXPENSES,
    KEIN_REISEGELD,
    KZTKT,
    MOLGA,
    PERIODENART,
    REPID,
    REQUEST,
    RETRN,
    ROUNDING,
    SCHEM,
    ST_TRG_TYP,
    TIMES,
    UHRB1,
    UHRB1_DIENST,
    UHRH1,
    UHRV1,
    UHRV1_DIENST,
    UNAME,
    ZUSAG,
    PRIMARY KEY (HDVRS, PERNR, REINR)
);

Learn More