TRVS4_E_COSTAS_D

Transparent Table Application Table
109 Fields 2 CDS Views

Draft table for entity I_TRAVELEXPENSECOSTASSIGNMENT

TRVS4_E_COSTAS_D is an SAP database table in S/4HANA. Draft table for entity I_TRAVELEXPENSECOSTASSIGNMENT. It contains 109 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TrvlExpnCostAssignmentDraft view_entity from EXTENSION Trvl Expn Cost Assgmt - Extn
R_TrvlExpnCostAssignmentDraft view_entity from BASIC Trvl Expn Cost Assignment Draft

Fields (109)

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 travelrequestsequencenumber VDM_COSTDISTNO Sequence Number
KEY costassignmentreferencekey VDM_COSTASSIGNMENT_REFKEY Reference Key
KEY travelcostassignmenttype FITV_COST_ASSIGNMENT_TYPE Cost Assignment Type
travelexpnsequentialnumber VDM_SEQUENTIALNUMBER Sequential Number
costassgmtpercentageinqty VDM_PERC_SHARE Percentage
companycode BUKRS Company Code
businessarea GSBER Business Area
controllingarea KOKRS CO Area
costcenter PTRV_WEB_INTERFACE_KOSTL Cost Center
travelorder PTRV_WEB_INTERFACE_AUFNR Order
costobject KSTRG Cost Object
wbselement PTRA_WEB_INTERFACE_PS_POSID WBS Element
accountassignmentnetworknumber PTRV_WEB_INTERFACE_NPLNR Network
activity PTRV_WEB_INTERFACE_VORNR Activity No.
salesorder PTRV_WEB_INTERFACE_KDAUF Sales Order
salesorderitem KDPOS Sales Ord. Item
businessprocess PTRV_WEB_INTERFACE_CO_PRZNR Business Proc.
fundcentertext FISTL Funds Center
fund BP_GEBER Fund
functionalarea FKBER Functional Area
grantid PTRV_WEB_INTERFACE_GM_GRANT_NB Grant
commitmentitem FM_FIPEX Commitment Item
travelrequestprojectuuid VDM_PROJECT_GUID Project GUID
externalprojectnumber PTRV_PROJECT_EXT_ID Project Number
taskroleuuid VDM_TASK_ROLE_GUID Task Role GUID
taskrolenumber VDM_TASKROLENUMBER Task / Role Number
costassignmentobjecttype PTRV_OBJ_TYPE Object Type
budgetperiod FM_BUDGET_PERIOD Budget Period
profitcenter PRCTR Profit Center
segment FB_SEGMENT Segment
travelrequestcostcategory GLO_PTRV_WEB_COST_CAT Cost Category
earmarkedfundsdocument KBLNR_FI Earmarked funds
earmarkedfundsdocumentitem KBLPOS Document Item
fundsmgmtcmtmtitemiscompleted REFSETERLK Set "Completed"
costdistrisdsponly VDM_COSTDISTRISDSPONLY Cost Distr Dsp Only
companycodename VDM_COMP_CODE_NAME Company Code Name
businessareaname VDM_BUS_AREA_NAME Business Area Name
controllingareaname LTEXT Long Text
costcentername VDM_COSTCENTER_NAME Cost Center Name
costassgmtordername LTEXT Long Text
costobjectdesc VDM_COST_OBJ_NAME Cost Object Name
wbselementname LTEXT Long Text
networkname LTEXT Long Text
activityname LTEXT Long Text
salesordername LTEXT Long Text
salesorderitemname LTEXT Long Text
businessprocessname LTEXT Long Text
fundcentername LTEXT Long Text
fundname LTEXT Long Text
functionalareaname LTEXT Long Text
grantextendedname LTEXT Long Text
commitmentitemname LTEXT Long Text
projectname LTEXT Long Text
taskrolename LTEXT Long Text
budgetperiodname LTEXT Long Text
costassignmentcategoryname LTEXT Long Text
earmarkedfundsdocname LTEXT Long Text
earmarkedfundsdocitemname LTEXT Long Text
travelrequestfieldgroup VDM_FIELDGROUP Accounting Object
tripfieldgroupname VDM_TRIPFIELDGROUPNAME Field Group Name
trvlcostassgmtreceiptamount GESBB Amount
paymentcurrency WAERS Currency
trvlcostassgmtamtorpctg BETPR Amt/Percent
lastchangedatetime VDM_LASTCHANGEDON Last Changed On
costassgmtlocllastchgddtetme ABP_LASTCHANGE_TSTMPL Changed On
trvlcostassgmtpercentageunit UNIT Unit
destinationassignment KEYZI Dest.Assignment
accountassgmtntwknmbr_h abap.raw
activity_h abap.raw
budgetperiod_h abap.raw
businessarea_h abap.raw
businessprocess_h abap.raw
commitmentitem_h abap.raw
companycode_h abap.raw
controllingarea_h abap.raw
costassignmentobjecttype_h abap.raw
costcenter_h abap.raw
costobject_h abap.raw
earmarkedfundsdocument_h abap.raw
earmarkedfundsdocumentitem_h abap.raw
externalprojectnumber_h abap.raw
functionalarea_h abap.raw
fund_h abap.raw
fundcentertext_h abap.raw
fndsmgmtcmtmtitmiscmpltd_h abap.raw
grantid_h abap.raw
profitcenter_h abap.raw
salesorder_h abap.raw
salesorderitem_h abap.raw
segment_h abap.raw
taskrolenumber_h abap.raw
taskroleuuid_h abap.raw
travelorder_h abap.raw
travelrequestcostcategory_h abap.raw
travelrequestfieldgroup_h abap.raw
travelrequestprojectuuid_h abap.raw
wbselement_h abap.raw
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_trvcost_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_TRAVELEXPENSECOSTASSIGNMENT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_E_COSTAS_D (
    MANDT,                           -- Client [MANDT]
    PERSONNELNUMBER,                 -- Personnel No. [PERNR_D]
    TRAVELTRIPNUMBER,                -- Trip Number [REINR]
    TRAVELREQUUID,                   -- UUID [SYSUUID_X16]
    SEQREQUUID,                      -- UUID [SYSUUID_X16]
    TRAVELREQUESTSEQUENCENUMBER,     -- Sequence Number [VDM_COSTDISTNO]
    COSTASSIGNMENTREFERENCEKEY,      -- Reference Key [VDM_COSTASSIGNMENT_REFKEY]
    TRAVELCOSTASSIGNMENTTYPE,        -- Cost Assignment Type [FITV_COST_ASSIGNMENT_TYPE]
    TRAVELEXPNSEQUENTIALNUMBER,      -- Sequential Number [VDM_SEQUENTIALNUMBER]
    COSTASSGMTPERCENTAGEINQTY,       -- Percentage [VDM_PERC_SHARE]
    COMPANYCODE,                     -- Company Code [BUKRS]
    BUSINESSAREA,                    -- Business Area [GSBER]
    CONTROLLINGAREA,                 -- CO Area [KOKRS]
    COSTCENTER,                      -- Cost Center [PTRV_WEB_INTERFACE_KOSTL]
    TRAVELORDER,                     -- Order [PTRV_WEB_INTERFACE_AUFNR]
    COSTOBJECT,                      -- Cost Object [KSTRG]
    WBSELEMENT,                      -- WBS Element [PTRA_WEB_INTERFACE_PS_POSID]
    ACCOUNTASSIGNMENTNETWORKNUMBER,  -- Network [PTRV_WEB_INTERFACE_NPLNR]
    ACTIVITY,                        -- Activity No. [PTRV_WEB_INTERFACE_VORNR]
    SALESORDER,                      -- Sales Order [PTRV_WEB_INTERFACE_KDAUF]
    SALESORDERITEM,                  -- Sales Ord. Item [KDPOS]
    BUSINESSPROCESS,                 -- Business Proc. [PTRV_WEB_INTERFACE_CO_PRZNR]
    FUNDCENTERTEXT,                  -- Funds Center [FISTL]
    FUND,                            -- Fund [BP_GEBER]
    FUNCTIONALAREA,                  -- Functional Area [FKBER]
    GRANTID,                         -- Grant [PTRV_WEB_INTERFACE_GM_GRANT_NB]
    COMMITMENTITEM,                  -- Commitment Item [FM_FIPEX]
    TRAVELREQUESTPROJECTUUID,        -- Project GUID [VDM_PROJECT_GUID]
    EXTERNALPROJECTNUMBER,           -- Project Number [PTRV_PROJECT_EXT_ID]
    TASKROLEUUID,                    -- Task Role GUID [VDM_TASK_ROLE_GUID]
    TASKROLENUMBER,                  -- Task / Role Number [VDM_TASKROLENUMBER]
    COSTASSIGNMENTOBJECTTYPE,        -- Object Type [PTRV_OBJ_TYPE]
    BUDGETPERIOD,                    -- Budget Period [FM_BUDGET_PERIOD]
    PROFITCENTER,                    -- Profit Center [PRCTR]
    SEGMENT,                         -- Segment [FB_SEGMENT]
    TRAVELREQUESTCOSTCATEGORY,       -- Cost Category [GLO_PTRV_WEB_COST_CAT]
    EARMARKEDFUNDSDOCUMENT,          -- Earmarked funds [KBLNR_FI]
    EARMARKEDFUNDSDOCUMENTITEM,      -- Document Item [KBLPOS]
    FUNDSMGMTCMTMTITEMISCOMPLETED,   -- Set "Completed" [REFSETERLK]
    COSTDISTRISDSPONLY,              -- Cost Distr Dsp Only [VDM_COSTDISTRISDSPONLY]
    COMPANYCODENAME,                 -- Company Code Name [VDM_COMP_CODE_NAME]
    BUSINESSAREANAME,                -- Business Area Name [VDM_BUS_AREA_NAME]
    CONTROLLINGAREANAME,             -- Long Text [LTEXT]
    COSTCENTERNAME,                  -- Cost Center Name [VDM_COSTCENTER_NAME]
    COSTASSGMTORDERNAME,             -- Long Text [LTEXT]
    COSTOBJECTDESC,                  -- Cost Object Name [VDM_COST_OBJ_NAME]
    WBSELEMENTNAME,                  -- Long Text [LTEXT]
    NETWORKNAME,                     -- Long Text [LTEXT]
    ACTIVITYNAME,                    -- Long Text [LTEXT]
    SALESORDERNAME,                  -- Long Text [LTEXT]
    SALESORDERITEMNAME,              -- Long Text [LTEXT]
    BUSINESSPROCESSNAME,             -- Long Text [LTEXT]
    FUNDCENTERNAME,                  -- Long Text [LTEXT]
    FUNDNAME,                        -- Long Text [LTEXT]
    FUNCTIONALAREANAME,              -- Long Text [LTEXT]
    GRANTEXTENDEDNAME,               -- Long Text [LTEXT]
    COMMITMENTITEMNAME,              -- Long Text [LTEXT]
    PROJECTNAME,                     -- Long Text [LTEXT]
    TASKROLENAME,                    -- Long Text [LTEXT]
    BUDGETPERIODNAME,                -- Long Text [LTEXT]
    COSTASSIGNMENTCATEGORYNAME,      -- Long Text [LTEXT]
    EARMARKEDFUNDSDOCNAME,           -- Long Text [LTEXT]
    EARMARKEDFUNDSDOCITEMNAME,       -- Long Text [LTEXT]
    TRAVELREQUESTFIELDGROUP,         -- Accounting Object [VDM_FIELDGROUP]
    TRIPFIELDGROUPNAME,              -- Field Group Name [VDM_TRIPFIELDGROUPNAME]
    TRVLCOSTASSGMTRECEIPTAMOUNT,     -- Amount [GESBB]
    PAYMENTCURRENCY,                 -- Currency [WAERS]
    TRVLCOSTASSGMTAMTORPCTG,         -- Amt/Percent [BETPR]
    LASTCHANGEDATETIME,              -- Last Changed On [VDM_LASTCHANGEDON]
    COSTASSGMTLOCLLASTCHGDDTETME,    -- Changed On [ABP_LASTCHANGE_TSTMPL]
    TRVLCOSTASSGMTPERCENTAGEUNIT,    -- Unit [UNIT]
    DESTINATIONASSIGNMENT,           -- Dest.Assignment [KEYZI]
    ACCOUNTASSGMTNTWKNMBR_H,         -- abap.raw
    ACTIVITY_H,                      -- abap.raw
    BUDGETPERIOD_H,                  -- abap.raw
    BUSINESSAREA_H,                  -- abap.raw
    BUSINESSPROCESS_H,               -- abap.raw
    COMMITMENTITEM_H,                -- abap.raw
    COMPANYCODE_H,                   -- abap.raw
    CONTROLLINGAREA_H,               -- abap.raw
    COSTASSIGNMENTOBJECTTYPE_H,      -- abap.raw
    COSTCENTER_H,                    -- abap.raw
    COSTOBJECT_H,                    -- abap.raw
    EARMARKEDFUNDSDOCUMENT_H,        -- abap.raw
    EARMARKEDFUNDSDOCUMENTITEM_H,    -- abap.raw
    EXTERNALPROJECTNUMBER_H,         -- abap.raw
    FUNCTIONALAREA_H,                -- abap.raw
    FUND_H,                          -- abap.raw
    FUNDCENTERTEXT_H,                -- abap.raw
    FNDSMGMTCMTMTITMISCMPLTD_H,      -- abap.raw
    GRANTID_H,                       -- abap.raw
    PROFITCENTER_H,                  -- abap.raw
    SALESORDER_H,                    -- abap.raw
    SALESORDERITEM_H,                -- abap.raw
    SEGMENT_H,                       -- abap.raw
    TASKROLENUMBER_H,                -- abap.raw
    TASKROLEUUID_H,                  -- abap.raw
    TRAVELORDER_H,                   -- abap.raw
    TRAVELREQUESTCOSTCATEGORY_H,     -- abap.raw
    TRAVELREQUESTFIELDGROUP_H,       -- abap.raw
    TRAVELREQUESTPROJECTUUID_H,      -- abap.raw
    WBSELEMENT_H,                    -- abap.raw
    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_TRVCOST_INCL_EEW_PS,       -- Dummy [CFD_DUMMY]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, TRAVELREQUESTSEQUENCENUMBER, COSTASSIGNMENTREFERENCEKEY, TRAVELCOSTASSIGNMENTTYPE)
);

Learn More