TRVS4_DEST_D

Transparent Table Application Table
62 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 62 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 (62)

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
draftentitycreationdatetime SYCH_BDL_DRAFT_CREATED_AT Created
draftentitylastchangedatetime SYCH_BDL_DRAFT_LAST_CHANGED_AT Changed
draftadministrativedatauuid SYCH_BDL_DRAFT_ADMIN_UUID UUID
draftentityoperationcode SYCH_BDL_DRAFT_OPERATION_CODE Draft - Operation Code
hasactiveentity SYCH_BDL_DRAFT_HASACTIVE Has active
draftfieldchanges SYCH_BDL_DRAFT_FIELD_CHANGES Field Changes
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.

-- 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]
    DRAFTENTITYCREATIONDATETIME,    -- Created [SYCH_BDL_DRAFT_CREATED_AT]
    DRAFTENTITYLASTCHANGEDATETIME,  -- Changed [SYCH_BDL_DRAFT_LAST_CHANGED_AT]
    DRAFTADMINISTRATIVEDATAUUID,    -- UUID [SYCH_BDL_DRAFT_ADMIN_UUID]
    DRAFTENTITYOPERATIONCODE,       -- Draft - Operation Code [SYCH_BDL_DRAFT_OPERATION_CODE]
    HASACTIVEENTITY,                -- Has active [SYCH_BDL_DRAFT_HASACTIVE]
    DRAFTFIELDCHANGES,              -- Field Changes [SYCH_BDL_DRAFT_FIELD_CHANGES]
    DUMMY_TRVDEST_INCL_EEW_PS,      -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, DESTINATIONASSIGNMENT, DESTINATIONTYPE, TRAVELREQUUID, SEQREQUUID)
);

Learn More