TRVS4_ESTCOST_D

Transparent Table Application Table
20 Fields 2 CDS Views

Draft table for entity I_TRAVELESTIMATEDCOST

TRVS4_ESTCOST_D is an SAP database table in S/4HANA. Draft table for entity I_TRAVELESTIMATEDCOST. It contains 20 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TrvlReqEstimatedCostDraft view_entity from EXTENSION TrvlReq Estimated Cost - Extn
R_TrvlReqEstimatedCostDraft view_entity from BASIC TrvlReq Estimated Cost Draft

Fields (20)

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 travelmedium ptrv_req_cat Travel Mediums
travelexpnsequentialnumber ptrv_hdvrs Sequential no.
travelmediumcategory ptrv_req_cat_classification Category
isreadonly xfeld Checkbox
travelmediumtype ptrv_ind_trans_accom Type
estimatedcost vdm_estimated_cost Estimated Costs
currency trvwaers Currency
sumlineistotal xfeld Checkbox
estimatedcostcategoryname vdm_categoryname Category
estimatedcostisapproved vdm_approvalreq Approval Required
estdcostsortsequencevalue ptrv_sort_ind Sorting
estdcostsortasintegervalue int1 INT1
criticality eve_tv_criticality Criticality
lastchangedatetime vdm_lastchangedon Last Changed On
estdcostlocllastchgddtetme abp_lastchange_tstmpl Changed On

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_TRAVELESTIMATEDCOST
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_ESTCOST_D (
    MANDT,                       -- Client [mandt]
    PERSONNELNUMBER,             -- Personnel No. [pernr_d]
    TRAVELTRIPNUMBER,            -- Trip Number [reinr]
    TRAVELREQUUID,               -- UUID [sysuuid_x16]
    SEQREQUUID,                  -- UUID [sysuuid_x16]
    TRAVELMEDIUM,                -- Travel Mediums [ptrv_req_cat]
    TRAVELEXPNSEQUENTIALNUMBER,  -- Sequential no. [ptrv_hdvrs]
    TRAVELMEDIUMCATEGORY,        -- Category [ptrv_req_cat_classification]
    ISREADONLY,                  -- Checkbox [xfeld]
    TRAVELMEDIUMTYPE,            -- Type [ptrv_ind_trans_accom]
    ESTIMATEDCOST,               -- Estimated Costs [vdm_estimated_cost]
    CURRENCY,                    -- Currency [trvwaers]
    SUMLINEISTOTAL,              -- Checkbox [xfeld]
    ESTIMATEDCOSTCATEGORYNAME,   -- Category [vdm_categoryname]
    ESTIMATEDCOSTISAPPROVED,     -- Approval Required [vdm_approvalreq]
    ESTDCOSTSORTSEQUENCEVALUE,   -- Sorting [ptrv_sort_ind]
    ESTDCOSTSORTASINTEGERVALUE,  -- INT1 [int1]
    CRITICALITY,                 -- Criticality [eve_tv_criticality]
    LASTCHANGEDATETIME,          -- Last Changed On [vdm_lastchangedon]
    ESTDCOSTLOCLLASTCHGDDTETME,  -- Changed On [abp_lastchange_tstmpl]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, TRAVELMEDIUM)
);

Learn More