TRVS4_SRVREQ_D

Transparent Table Application Table
39 Fields 2 CDS Views

Draft table for entity I_TRAVELSERVICEREQUEST

TRVS4_SRVREQ_D is an SAP database table in S/4HANA. Draft table for entity I_TRAVELSERVICEREQUEST. It contains 39 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelRequestServicesDraft view_entity from EXTENSION Travel Request Services - Extn
R_TravelRequestServicesDraft view_entity from BASIC Travel Request Services Draft

Fields (39)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY personnelnumber PERNR_D Personnel No.
KEY traveltripnumber REINR Trip Number
KEY travelrequuid SYSUUID_X16 UUID
KEY seqrequuid SYSUUID_X16 UUID
KEY travelservicerequestnumber REQUEST_NR Request number
travelexpnsequentialnumber PTRV_HDVRS Sequential no.
travelitemtype REQUEST_TYPE Travel item
tripservicetypename OTHER_SERVICE_NAME Name
travelitemtypefordisplay REQUEST_TYPE Travel item
tripsegmentbegindate REQUEST_DATEBEG Begins On
tripsegmentstarttime REQUEST_TIMEBEG Start Time
tripsegmentenddate REQUEST_DATEEND Ends On
tripsegmentendtime REQUEST_TIMEEND Ends At
tripstartinglocationname VDM_LOCATION_BEG From
departurecountry VDM_DEPTCTRY_REG Departure Country / Region
departurecountryname VDM_CTRY_REG_NAME Departure Country / Region
tripendlocationname VDM_LOCATION_END To
destinationcountry VDM_DESTCTRY_REG Arrival Country / Region
destinationcountryname VDM_DESTCOUNTRYNAME Arrival Country / Region
trvlreqhasarrivalordeptr DEP_ARR Arrival/Depart.
salesoffcdetn OFFICE_FIND Sales Office Det.
othertravelservicecode OTHER_SERVICE_CODE Code
iatadeparturelocation REQUEST_LOC_BEG_IATA Start Location
iatadestinationlocation REQUEST_LOC_END_IATA End Location
otherservicestatus VDM_OTHERSERVICESTATUS Other Service Status
trvlreqothsrvcconfnmbr OS_CONF_NUMBER Confirm. Code
tripreqpriceintravelcurrency REQUEST_PRICE Price
triprequestcurrency REQUEST_CURRENCY Currency
travelrequestcomment REQUEST_COMMENT Comment
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
trvlsrvcslocllastchgddtetme ABP_LASTCHANGE_TSTMPL Changed On
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_trvservice_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_TRAVELSERVICEREQUEST
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_SRVREQ_D (
    MANDT,                          -- Client [MANDT]
    PERSONNELNUMBER,                -- Personnel No. [PERNR_D]
    TRAVELTRIPNUMBER,               -- Trip Number [REINR]
    TRAVELREQUUID,                  -- UUID [SYSUUID_X16]
    SEQREQUUID,                     -- UUID [SYSUUID_X16]
    TRAVELSERVICEREQUESTNUMBER,     -- Request number [REQUEST_NR]
    TRAVELEXPNSEQUENTIALNUMBER,     -- Sequential no. [PTRV_HDVRS]
    TRAVELITEMTYPE,                 -- Travel item [REQUEST_TYPE]
    TRIPSERVICETYPENAME,            -- Name [OTHER_SERVICE_NAME]
    TRAVELITEMTYPEFORDISPLAY,       -- Travel item [REQUEST_TYPE]
    TRIPSEGMENTBEGINDATE,           -- Begins On [REQUEST_DATEBEG]
    TRIPSEGMENTSTARTTIME,           -- Start Time [REQUEST_TIMEBEG]
    TRIPSEGMENTENDDATE,             -- Ends On [REQUEST_DATEEND]
    TRIPSEGMENTENDTIME,             -- Ends At [REQUEST_TIMEEND]
    TRIPSTARTINGLOCATIONNAME,       -- From [VDM_LOCATION_BEG]
    DEPARTURECOUNTRY,               -- Departure Country / Region [VDM_DEPTCTRY_REG]
    DEPARTURECOUNTRYNAME,           -- Departure Country / Region [VDM_CTRY_REG_NAME]
    TRIPENDLOCATIONNAME,            -- To [VDM_LOCATION_END]
    DESTINATIONCOUNTRY,             -- Arrival Country / Region [VDM_DESTCTRY_REG]
    DESTINATIONCOUNTRYNAME,         -- Arrival Country / Region [VDM_DESTCOUNTRYNAME]
    TRVLREQHASARRIVALORDEPTR,       -- Arrival/Depart. [DEP_ARR]
    SALESOFFCDETN,                  -- Sales Office Det. [OFFICE_FIND]
    OTHERTRAVELSERVICECODE,         -- Code [OTHER_SERVICE_CODE]
    IATADEPARTURELOCATION,          -- Start Location [REQUEST_LOC_BEG_IATA]
    IATADESTINATIONLOCATION,        -- End Location [REQUEST_LOC_END_IATA]
    OTHERSERVICESTATUS,             -- Other Service Status [VDM_OTHERSERVICESTATUS]
    TRVLREQOTHSRVCCONFNMBR,         -- Confirm. Code [OS_CONF_NUMBER]
    TRIPREQPRICEINTRAVELCURRENCY,   -- Price [REQUEST_PRICE]
    TRIPREQUESTCURRENCY,            -- Currency [REQUEST_CURRENCY]
    TRAVELREQUESTCOMMENT,           -- Comment [REQUEST_COMMENT]
    LASTCHANGEDATETIME,             -- Last Changed On [VDM_LASTCHANGEDON]
    TRVLSRVCSLOCLLASTCHGDDTETME,    -- Changed On [ABP_LASTCHANGE_TSTMPL]
    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_TRVSERVICE_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, TRAVELSERVICEREQUESTNUMBER)
);

Learn More