TRVS4_DEST

Transparent Table Application Table
48 Fields 2 CDS Views

Travel Destination

TRVS4_DEST is an SAP database table in S/4HANA. Travel Destination. It contains 48 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelAddlDestData view_entity from EXTENSION Travel Additional Dest - Extension
I_TravelAddlDestData view_entity from BASIC Travel Destination

Fields (48)

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 schem RSCHE Trip Schema
KEY key_stop KEYZI Dest.Assignment
KEY stop_type STOP_TYPE Destin.
datedep FITV_REBED Start Date
timedep REBEU Trip Begins At
adrnradr AD_ADDRNUM Address Number
cityadr AD_CITY1 City
city_districtadr AD_CITY2 District
post_codeadr AD_PSTCD1 Postal Code
city_codeadr PTRV_CITY_CODE Community Code No.
streetadr AD_STREET Street
house_numadr AD_HSNM1 House Number
countryadr LAND1 Country/Reg.
regionadr REGIO Region
tax_per_diemtax PTRV_TAX_PER_DIEM Meals PD Taxation
tax_pd_mantax PTRV_TAX_PD_MAN Man.Tax.MealPDs
tax_ov_mantax PTRV_TAX_OV_MAN Man.Tax.Acc.PDs
stop_type_text STOP_TYPE_TEXT Activity
country_region_name TEXT_RGION Name Ctry/Region
tt_statu_name TEXT_KZREA Name
tt_comsp_name TEXT_BEREI Name
t_actype_name TEXT_KZTKT Name
absence_type_name LTEXT Long Text
allowance_type_name LTEXT Long Text
spouse_sep_allw_name LTEXT Long Text
sleep_at_home_name LTEXT Long Text
attr_trip_break_name LTEXT Long Text
customer_long RKUNDE Reason
location_long RZIELORT Destination
tt_statu KZREA Trip Type S
tt_comsp BEREI Trip Type E
t_actype KZTKT Activity
plan_activity_type PLAN_ACTIVITY Activity Type
region RGION Trip Region
sleep_at_home PTRV_SLEEP_AT_HOME Night at Home
attr_trip_break PTRVPS_ATTR_TRIP_BREAK Priv. Trip Break
no_night ANUEP PD Nights
absence_type PTRVPS_ABWH_ART Abs. Type
allowance_type PTRVPS_ZUSCH_ART Allowance Type
spouse_sep_allw PTRVPS_PARTNER Spouse
charg_accomm PTRVPS_ENTG_UNT Chargeable Accommod
location RZIELORT Destination
req_itinerary_number ITINERARY_NUMBER Trip segmentNo.
dummy_trvdest_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.

-- Travel Destination
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_DEST (
    MANDT,                      -- Client [MANDT]
    PERNR,                      -- Personnel No. [PERNR_D]
    REINR,                      -- Trip Number [REINR]
    HDVRS,                      -- Sequential no. [PTRV_HDVRS]
    SCHEM,                      -- Trip Schema [RSCHE]
    KEY_STOP,                   -- Dest.Assignment [KEYZI]
    STOP_TYPE,                  -- Destin. [STOP_TYPE]
    DATEDEP,                    -- Start Date [FITV_REBED]
    TIMEDEP,                    -- Trip Begins At [REBEU]
    ADRNRADR,                   -- Address Number [AD_ADDRNUM]
    CITYADR,                    -- City [AD_CITY1]
    CITY_DISTRICTADR,           -- District [AD_CITY2]
    POST_CODEADR,               -- Postal Code [AD_PSTCD1]
    CITY_CODEADR,               -- Community Code No. [PTRV_CITY_CODE]
    STREETADR,                  -- Street [AD_STREET]
    HOUSE_NUMADR,               -- House Number [AD_HSNM1]
    COUNTRYADR,                 -- Country/Reg. [LAND1]
    REGIONADR,                  -- Region [REGIO]
    TAX_PER_DIEMTAX,            -- Meals PD Taxation [PTRV_TAX_PER_DIEM]
    TAX_PD_MANTAX,              -- Man.Tax.MealPDs [PTRV_TAX_PD_MAN]
    TAX_OV_MANTAX,              -- Man.Tax.Acc.PDs [PTRV_TAX_OV_MAN]
    STOP_TYPE_TEXT,             -- Activity [STOP_TYPE_TEXT]
    COUNTRY_REGION_NAME,        -- Name Ctry/Region [TEXT_RGION]
    TT_STATU_NAME,              -- Name [TEXT_KZREA]
    TT_COMSP_NAME,              -- Name [TEXT_BEREI]
    T_ACTYPE_NAME,              -- Name [TEXT_KZTKT]
    ABSENCE_TYPE_NAME,          -- Long Text [LTEXT]
    ALLOWANCE_TYPE_NAME,        -- Long Text [LTEXT]
    SPOUSE_SEP_ALLW_NAME,       -- Long Text [LTEXT]
    SLEEP_AT_HOME_NAME,         -- Long Text [LTEXT]
    ATTR_TRIP_BREAK_NAME,       -- Long Text [LTEXT]
    CUSTOMER_LONG,              -- Reason [RKUNDE]
    LOCATION_LONG,              -- Destination [RZIELORT]
    TT_STATU,                   -- Trip Type S [KZREA]
    TT_COMSP,                   -- Trip Type E [BEREI]
    T_ACTYPE,                   -- Activity [KZTKT]
    PLAN_ACTIVITY_TYPE,         -- Activity Type [PLAN_ACTIVITY]
    REGION,                     -- Trip Region [RGION]
    SLEEP_AT_HOME,              -- Night at Home [PTRV_SLEEP_AT_HOME]
    ATTR_TRIP_BREAK,            -- Priv. Trip Break [PTRVPS_ATTR_TRIP_BREAK]
    NO_NIGHT,                   -- PD Nights [ANUEP]
    ABSENCE_TYPE,               -- Abs. Type [PTRVPS_ABWH_ART]
    ALLOWANCE_TYPE,             -- Allowance Type [PTRVPS_ZUSCH_ART]
    SPOUSE_SEP_ALLW,            -- Spouse [PTRVPS_PARTNER]
    CHARG_ACCOMM,               -- Chargeable Accommod [PTRVPS_ENTG_UNT]
    LOCATION,                   -- Destination [RZIELORT]
    REQ_ITINERARY_NUMBER,       -- Trip segmentNo. [ITINERARY_NUMBER]
    DUMMY_TRVDEST_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, SCHEM, KEY_STOP, STOP_TYPE)
);

Learn More