TRVS4_SRVREQ

Transparent Table Application Table
18 Fields 2 CDS Views

Travel Service

TRVS4_SRVREQ is an SAP database table in S/4HANA. Travel Service. It contains 18 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelServiceRequestData view_entity from EXTENSION Travel Req Travel Services - Extension
I_TravelServiceRequestData view_entity from BASIC Travel Service Request Data

Fields (18)

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 request request_nr Request number
request_type request_type Travel item
date_beg request_datebeg Begins On
time_beg request_timebeg Start Time
date_end request_dateend Ends On
time_end request_timeend Ends At
location_beg request_loc_beg Starting loc.
country_beg land1 Country/Reg.
country_beg_name landx Country/Region
location_end request_loc_end End loc.
country_end land1 Country/Reg.
country_end_name landx Country/Region
dep_arr dep_arr Arrival/Depart.
request_type_name other_service_name Name

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 Service
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_SRVREQ (
    MANDT,              -- Client [mandt]
    PERNR,              -- Personnel No. [pernr_d]
    REINR,              -- Trip Number [reinr]
    HDVRS,              -- Sequential no. [ptrv_hdvrs]
    REQUEST,            -- Request number [request_nr]
    REQUEST_TYPE,       -- Travel item [request_type]
    DATE_BEG,           -- Begins On [request_datebeg]
    TIME_BEG,           -- Start Time [request_timebeg]
    DATE_END,           -- Ends On [request_dateend]
    TIME_END,           -- Ends At [request_timeend]
    LOCATION_BEG,       -- Starting loc. [request_loc_beg]
    COUNTRY_BEG,        -- Country/Reg. [land1]
    COUNTRY_BEG_NAME,   -- Country/Region [landx]
    LOCATION_END,       -- End loc. [request_loc_end]
    COUNTRY_END,        -- Country/Reg. [land1]
    COUNTRY_END_NAME,   -- Country/Region [landx]
    DEP_ARR,            -- Arrival/Depart. [dep_arr]
    REQUEST_TYPE_NAME,  -- Name [other_service_name]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, REQUEST)
);

Learn More