PTRV_TRIP_CHAIN

Transparent Table Application Table
41 Fields 1 CDS Views

Table of all Trip Destinations f. Processing Recurring Dest.

PTRV_TRIP_CHAIN is an SAP database table in S/4HANA. Table of all Trip Destinations f. Processing Recurring Dest.. It contains 41 fields. 1 CDS views read from this table.

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_TravelExpenseTripChainData view_entity from BASIC Trvl Expn Trip Chain Basic Data

Fields (41)

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.
KEY perio PTRV_PEROD Period Number
KEY pdvrs PTRV_PDVRS Sequence Number
KEY rule_tag PTRV_RULE_TAG Rule Indicator
KEY zikey KEYZI Dest.Assignment
morei MOREI Trip Prov. Variant
kzrea KZREA Trip Type S
berei BEREI Trip Type E
kztkt KZTKT Activity
zland LNDGR Trip Ctry/Reg
rgion RGION Trip Region
pstlz PSTLZ Postal Code
ort01 PAD_ORT01 City
stras PAD_STRAS Street/House
state REGIO Region
addrnumber AD_ADDRNUM Address Number
dest_identifier PTRV_DEST_IDENTIFICATION Destination
kunde RKUNDE Reason
datv1 REBED Trip Begins On
uhrv1 REBEU Trip Begins At
datb1 REEND Trip Ends On
uhrb1 REENU Trip Ends At
action_date_req PTRV_ACTION_DATE_REQUIRED Date of action
action_date_act PTRV_ACTION_DATE_ACTUAL Date of action
house_num AD_HSNM1 House Number
ort02 PAD_ORT02 District
city_code PTRV_CITY_CODE Community Code No.
start_entry PTRV_START_TRIP_CHAIN Start Value
tax_date_pd_req PTRV_TAX_DATE_PD_REQ Meals PD Taxation
tax_time_pd_req PTRV_TAX_TIME_PD_REQ Meals PD Tax
tax_date_pd_act PTRV_TAX_DATE_PD_ACT Meals PD Tax
tax_time_pd_act PTRV_TAX_TIME_PD_ACT Meals PD Tax
tax_date_ov_req PTRV_TAX_DATE_OV_REQ Accom.PD Tax
tax_time_ov_req PTRV_TAX_TIME_OV_REQ Accom.PD Tax
tax_date_ov_act PTRV_TAX_DATE_OV_ACT Accom.PD Tax
tax_time_ov_act PTRV_TAX_TIME_OV_ACT Accom.PD Tax
nr_per_diem PTRV_NR_PER_DIEM No.MealsPDs
nr_overn PTRV_NR_OVERN No.Accom.PDs

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.

-- Table of all Trip Destinations f. Processing Recurring Dest.
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE PTRV_TRIP_CHAIN (
    MANDT,            -- Client [MANDT]
    PERNR,            -- Personnel No. [PERNR_D]
    REINR,            -- Trip Number [REINR]
    HDVRS,            -- Sequential no. [PTRV_HDVRS]
    PERIO,            -- Period Number [PTRV_PEROD]
    PDVRS,            -- Sequence Number [PTRV_PDVRS]
    RULE_TAG,         -- Rule Indicator [PTRV_RULE_TAG]
    ZIKEY,            -- Dest.Assignment [KEYZI]
    MOREI,            -- Trip Prov. Variant [MOREI]
    KZREA,            -- Trip Type S [KZREA]
    BEREI,            -- Trip Type E [BEREI]
    KZTKT,            -- Activity [KZTKT]
    ZLAND,            -- Trip Ctry/Reg [LNDGR]
    RGION,            -- Trip Region [RGION]
    PSTLZ,            -- Postal Code [PSTLZ]
    ORT01,            -- City [PAD_ORT01]
    STRAS,            -- Street/House [PAD_STRAS]
    STATE,            -- Region [REGIO]
    ADDRNUMBER,       -- Address Number [AD_ADDRNUM]
    DEST_IDENTIFIER,  -- Destination [PTRV_DEST_IDENTIFICATION]
    KUNDE,            -- Reason [RKUNDE]
    DATV1,            -- Trip Begins On [REBED]
    UHRV1,            -- Trip Begins At [REBEU]
    DATB1,            -- Trip Ends On [REEND]
    UHRB1,            -- Trip Ends At [REENU]
    ACTION_DATE_REQ,  -- Date of action [PTRV_ACTION_DATE_REQUIRED]
    ACTION_DATE_ACT,  -- Date of action [PTRV_ACTION_DATE_ACTUAL]
    HOUSE_NUM,        -- House Number [AD_HSNM1]
    ORT02,            -- District [PAD_ORT02]
    CITY_CODE,        -- Community Code No. [PTRV_CITY_CODE]
    START_ENTRY,      -- Start Value [PTRV_START_TRIP_CHAIN]
    TAX_DATE_PD_REQ,  -- Meals PD Taxation [PTRV_TAX_DATE_PD_REQ]
    TAX_TIME_PD_REQ,  -- Meals PD Tax [PTRV_TAX_TIME_PD_REQ]
    TAX_DATE_PD_ACT,  -- Meals PD Tax [PTRV_TAX_DATE_PD_ACT]
    TAX_TIME_PD_ACT,  -- Meals PD Tax [PTRV_TAX_TIME_PD_ACT]
    TAX_DATE_OV_REQ,  -- Accom.PD Tax [PTRV_TAX_DATE_OV_REQ]
    TAX_TIME_OV_REQ,  -- Accom.PD Tax [PTRV_TAX_TIME_OV_REQ]
    TAX_DATE_OV_ACT,  -- Accom.PD Tax [PTRV_TAX_DATE_OV_ACT]
    TAX_TIME_OV_ACT,  -- Accom.PD Tax [PTRV_TAX_TIME_OV_ACT]
    NR_PER_DIEM,      -- No.MealsPDs [PTRV_NR_PER_DIEM]
    NR_OVERN,         -- No.Accom.PDs [PTRV_NR_OVERN]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, PERIO, PDVRS, RULE_TAG, ZIKEY)
);

Learn More