TRVS4_DEST_D

Transparent Table Application Table
55 Fields 2 CDS Views

Draft table for entity I_TRAVELADDLDESTINATION

TRVS4_DEST_D is an SAP database table in S/4HANA. Draft table for entity I_TRAVELADDLDESTINATION. It contains 55 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TrvlReqAddlDestDraft view_entity from EXTENSION Travel Request Additional Dest - Extn
R_TrvlReqAddlDestDraft view_entity from BASIC Travel Request Additional Dest Draft

Fields (55)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY personnelnumber pernr_d Personnel No.
KEY traveltripnumber reinr Trip Number
KEY destinationassignment vdm_destinationassignment Destination Assignment
KEY destinationtype vdm_tripdestinationtype Destination type
KEY travelrequuid sysuuid_x16 UUID
KEY seqrequuid sysuuid_x16 UUID
travelexpnsequentialnumber ptrv_hdvrs Sequential no.
tripbeginsondate fitv_rebed Start Date
tripbeginsattime rebeu Trip Begins At
addressnumber ad_addrnum Address Number
cityname ad_city1 City
districtname ad_city2 District
postalcode ad_pstcd1 Postal Code
travelcommunitycityname ad_city1 City
travelcommunitypostcode ad_pstcd1 Postal Code
travelcommunitydistrictname ad_city2 District
citycodename ad_citynum City Code
streetname ad_street Street
housenumber ad_hsnm1 House Number
country land1 Country/Reg.
region regio Region
mealsperdiemhastxn vdm_mealsperdiemhastxn Auto Acmd Meals Tax
mealsperdiemhasmnltxn vdm_mealsperdiemhasmnltxn Manual Meals Taxation
acmdtnperdiemhasmnltxn vdm_acmdtnperdiemhasmnltxn Manual Acmd Taxation
tripdesttypename vdm_dstnassignment Event in Itinerary
countryregionname vdm_ctryreg_name Country / Region
triptypestatutory vdm_statutorytype Trip Type, Statutory
triptypestatutoryname vdm_tt_statu_name Trip Type Statutory Name
triptypeenterprise vdm_enterprisetype Trip Type, Company-Specific
triptypeenterprisename vdm_tt_comsp_name Trip Type Enterprise Name
typeoftripactivityvalue vdm_act_expense Activity (Expenses)
addldesttypeoftripactyname vdm_t_actype_name Trip Activity Type Name
absencetypename vdm_absence_type_name Absence Type Name
allowancetypename vdm_allowance_type_name Allowance Type Name
trvlreqsprtnallwncname vdm_spouse_sep_allw_name Spouse Separation Allowance Name
sleepathomename vdm_sleep_at_home_name Sleep at Home Name
durnofprvttripbreakname vdm_attr_trip_break_name Duration of Private Trip Break Name
tripreasontext vdm_reason Reason
tripdestination vdm_destination Destination
tripactivitytype vdm_plan_activity Activity (Planning)
tripactivitytypename vdm_plan_activity_name Activity Name
tripregion vdm_tripregion Country / Group / Region
addldestsleepathome ptrv_sleep_at_home Night at Home
addldestdurnofprvttripbreak vdm_durnofprivatetripbreak Private Trip Break
nrofperdiemnights anuep PD Nights
addldestabsencetype ptrvps_abwh_art Abs. Type
addldestallowancetype ptrvps_zusch_art Allowance Type
trvlreqsprtnallwnc ptrvps_partner Spouse
acmdtnischargeable vdm_acmdtnischargeable Chargeable Accommodations
tripdestinationlong rzielort Destination
tripitinerarynumber vdm_tripsegmentnumber Trip Segment Number
lastchangedatetime vdm_lastchangedon Last Changed On
addldestlocllastchgddtetme abp_lastchange_tstmpl Changed On
travelcountryregion vdm_reg_ctry Country / Region

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.

-- Draft table for entity I_TRAVELADDLDESTINATION
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_DEST_D (
    MANDT,                        -- Client [mandt]
    PERSONNELNUMBER,              -- Personnel No. [pernr_d]
    TRAVELTRIPNUMBER,             -- Trip Number [reinr]
    DESTINATIONASSIGNMENT,        -- Destination Assignment [vdm_destinationassignment]
    DESTINATIONTYPE,              -- Destination type [vdm_tripdestinationtype]
    TRAVELREQUUID,                -- UUID [sysuuid_x16]
    SEQREQUUID,                   -- UUID [sysuuid_x16]
    TRAVELEXPNSEQUENTIALNUMBER,   -- Sequential no. [ptrv_hdvrs]
    TRIPBEGINSONDATE,             -- Start Date [fitv_rebed]
    TRIPBEGINSATTIME,             -- Trip Begins At [rebeu]
    ADDRESSNUMBER,                -- Address Number [ad_addrnum]
    CITYNAME,                     -- City [ad_city1]
    DISTRICTNAME,                 -- District [ad_city2]
    POSTALCODE,                   -- Postal Code [ad_pstcd1]
    TRAVELCOMMUNITYCITYNAME,      -- City [ad_city1]
    TRAVELCOMMUNITYPOSTCODE,      -- Postal Code [ad_pstcd1]
    TRAVELCOMMUNITYDISTRICTNAME,  -- District [ad_city2]
    CITYCODENAME,                 -- City Code [ad_citynum]
    STREETNAME,                   -- Street [ad_street]
    HOUSENUMBER,                  -- House Number [ad_hsnm1]
    COUNTRY,                      -- Country/Reg. [land1]
    REGION,                       -- Region [regio]
    MEALSPERDIEMHASTXN,           -- Auto Acmd Meals Tax [vdm_mealsperdiemhastxn]
    MEALSPERDIEMHASMNLTXN,        -- Manual Meals Taxation [vdm_mealsperdiemhasmnltxn]
    ACMDTNPERDIEMHASMNLTXN,       -- Manual Acmd Taxation [vdm_acmdtnperdiemhasmnltxn]
    TRIPDESTTYPENAME,             -- Event in Itinerary [vdm_dstnassignment]
    COUNTRYREGIONNAME,            -- Country / Region [vdm_ctryreg_name]
    TRIPTYPESTATUTORY,            -- Trip Type, Statutory [vdm_statutorytype]
    TRIPTYPESTATUTORYNAME,        -- Trip Type Statutory Name [vdm_tt_statu_name]
    TRIPTYPEENTERPRISE,           -- Trip Type, Company-Specific [vdm_enterprisetype]
    TRIPTYPEENTERPRISENAME,       -- Trip Type Enterprise Name [vdm_tt_comsp_name]
    TYPEOFTRIPACTIVITYVALUE,      -- Activity (Expenses) [vdm_act_expense]
    ADDLDESTTYPEOFTRIPACTYNAME,   -- Trip Activity Type Name [vdm_t_actype_name]
    ABSENCETYPENAME,              -- Absence Type Name [vdm_absence_type_name]
    ALLOWANCETYPENAME,            -- Allowance Type Name [vdm_allowance_type_name]
    TRVLREQSPRTNALLWNCNAME,       -- Spouse Separation Allowance Name [vdm_spouse_sep_allw_name]
    SLEEPATHOMENAME,              -- Sleep at Home Name [vdm_sleep_at_home_name]
    DURNOFPRVTTRIPBREAKNAME,      -- Duration of Private Trip Break Name [vdm_attr_trip_break_name]
    TRIPREASONTEXT,               -- Reason [vdm_reason]
    TRIPDESTINATION,              -- Destination [vdm_destination]
    TRIPACTIVITYTYPE,             -- Activity (Planning) [vdm_plan_activity]
    TRIPACTIVITYTYPENAME,         -- Activity Name [vdm_plan_activity_name]
    TRIPREGION,                   -- Country / Group / Region [vdm_tripregion]
    ADDLDESTSLEEPATHOME,          -- Night at Home [ptrv_sleep_at_home]
    ADDLDESTDURNOFPRVTTRIPBREAK,  -- Private Trip Break [vdm_durnofprivatetripbreak]
    NROFPERDIEMNIGHTS,            -- PD Nights [anuep]
    ADDLDESTABSENCETYPE,          -- Abs. Type [ptrvps_abwh_art]
    ADDLDESTALLOWANCETYPE,        -- Allowance Type [ptrvps_zusch_art]
    TRVLREQSPRTNALLWNC,           -- Spouse [ptrvps_partner]
    ACMDTNISCHARGEABLE,           -- Chargeable Accommodations [vdm_acmdtnischargeable]
    TRIPDESTINATIONLONG,          -- Destination [rzielort]
    TRIPITINERARYNUMBER,          -- Trip Segment Number [vdm_tripsegmentnumber]
    LASTCHANGEDATETIME,           -- Last Changed On [vdm_lastchangedon]
    ADDLDESTLOCLLASTCHGDDTETME,   -- Changed On [abp_lastchange_tstmpl]
    TRAVELCOUNTRYREGION,          -- Country / Region [vdm_reg_ctry]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, DESTINATIONASSIGNMENT, DESTINATIONTYPE, TRAVELREQUUID, SEQREQUUID)
);

Learn More