TRVS4_ESTCOST

Transparent Table Application Table
15 Fields 2 CDS Views

Travel Estimated Cost

TRVS4_ESTCOST is an SAP database table in S/4HANA. Travel Estimated Cost. It contains 15 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TravelEstimatedCostData view_entity from EXTENSION Travel Req Estimated costs - Extension
I_TravelEstimatedCostData view_entity from BASIC Travel Estimated Cost

Fields (15)

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 category PTRV_REQ_CAT Travel Mediums
classification PTRV_REQ_CAT_CLASSIFICATION Category
read_only XFELD Checkbox
ind_trans_accom PTRV_IND_TRANS_ACCOM Type
estimated_cost PTRV_ESTIMATED_COST Total Cost
currency TRVWAERS Currency
sum_line XFELD Checkbox
category_name TEXT30 Text
ind_requested PTRV_IND_REQUESTED To Be Approved
sort_ind PTRV_SORT_IND Sorting
dummy_trvestcost_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 Estimated Cost
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_ESTCOST (
    MANDT,                         -- Client [MANDT]
    PERNR,                         -- Personnel No. [PERNR_D]
    REINR,                         -- Trip Number [REINR]
    HDVRS,                         -- Sequential no. [PTRV_HDVRS]
    CATEGORY,                      -- Travel Mediums [PTRV_REQ_CAT]
    CLASSIFICATION,                -- Category [PTRV_REQ_CAT_CLASSIFICATION]
    READ_ONLY,                     -- Checkbox [XFELD]
    IND_TRANS_ACCOM,               -- Type [PTRV_IND_TRANS_ACCOM]
    ESTIMATED_COST,                -- Total Cost [PTRV_ESTIMATED_COST]
    CURRENCY,                      -- Currency [TRVWAERS]
    SUM_LINE,                      -- Checkbox [XFELD]
    CATEGORY_NAME,                 -- Text [TEXT30]
    IND_REQUESTED,                 -- To Be Approved [PTRV_IND_REQUESTED]
    SORT_IND,                      -- Sorting [PTRV_SORT_IND]
    DUMMY_TRVESTCOST_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERNR, REINR, HDVRS, CATEGORY)
);

Learn More