TRVS4_ESTCOST_D

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

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
criticality EVE_TV_CRITICALITY Criticality
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
estdcostlocllastchgddtetme 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_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.

-- 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]
    CRITICALITY,                    -- Criticality [EVE_TV_CRITICALITY]
    LASTCHANGEDATETIME,             -- Last Changed On [VDM_LASTCHANGEDON]
    ESTDCOSTLOCLLASTCHGDDTETME,     -- 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_TRVESTCOST_INCL_EEW_PS,   -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, TRAVELMEDIUM)
);

Learn More