TRVS4_E_RECCOS_D

Transparent Table Application Table
79 Fields 2 CDS Views

Draft table for entity I_TRVLEXPNRECEIPTCOSTASSGMT

TRVS4_E_RECCOS_D is an SAP database table in S/4HANA. Draft table for entity I_TRVLEXPNRECEIPTCOSTASSGMT. It contains 79 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TrvlExpnRcptCostAssgmtDrft view_entity from EXTENSION TrvlExpnRcptCostAssgmt - Extension
R_TrvlExpnRcptCostAssgmtDrft view_entity from BASIC TrvlExpnRcptCostAssgmt Draft

Fields (79)

KeyField Data ElementDescription DomainTypeLength
KEY mandt MANDT Client
KEY personnelnumber PERNR_D Personnel No.
KEY traveltripnumber REINR Trip Number
KEY costassignmentreferencekey VDM_COSTASSIGNMENT_REFKEY Reference Key
KEY travelrequestsequencenumber VDM_COSTDISTNO Sequence Number
KEY travelcostassignmenttype FITV_COST_ASSIGNMENT_TYPE Cost Assignment Type
KEY travelrequuid SYSUUID_X16 UUID
KEY seqrequuid SYSUUID_X16 UUID
KEY receiptcostassgmtseqrequuid SYSUUID_X16 UUID
travelexpnsequentialnumber VDM_SEQUENTIALNUMBER Sequential Number
costassgmtpercentageinqty VDM_PERC_SHARE Percentage
trvlcostassgmtpercentageunit UNIT Unit
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
rcptscostlocllastchgddtetme ABP_LASTCHANGE_TSTMPL Changed On
destinationassignment KEYZI Dest.Assignment
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

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_TRVLEXPNRECEIPTCOSTASSGMT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_E_RECCOS_D (
    MANDT,                           -- Client [MANDT]
    PERSONNELNUMBER,                 -- Personnel No. [PERNR_D]
    TRAVELTRIPNUMBER,                -- Trip Number [REINR]
    COSTASSIGNMENTREFERENCEKEY,      -- Reference Key [VDM_COSTASSIGNMENT_REFKEY]
    TRAVELREQUESTSEQUENCENUMBER,     -- Sequence Number [VDM_COSTDISTNO]
    TRAVELCOSTASSIGNMENTTYPE,        -- Cost Assignment Type [FITV_COST_ASSIGNMENT_TYPE]
    TRAVELREQUUID,                   -- UUID [SYSUUID_X16]
    SEQREQUUID,                      -- UUID [SYSUUID_X16]
    RECEIPTCOSTASSGMTSEQREQUUID,     -- UUID [SYSUUID_X16]
    TRAVELEXPNSEQUENTIALNUMBER,      -- Sequential Number [VDM_SEQUENTIALNUMBER]
    COSTASSGMTPERCENTAGEINQTY,       -- Percentage [VDM_PERC_SHARE]
    TRVLCOSTASSGMTPERCENTAGEUNIT,    -- Unit [UNIT]
    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]
    RCPTSCOSTLOCLLASTCHGDDTETME,     -- Changed On [ABP_LASTCHANGE_TSTMPL]
    DESTINATIONASSIGNMENT,           -- Dest.Assignment [KEYZI]
    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]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, COSTASSIGNMENTREFERENCEKEY, TRAVELREQUESTSEQUENCENUMBER, TRAVELCOSTASSIGNMENTTYPE, TRAVELREQUUID, SEQREQUUID, RECEIPTCOSTASSGMTSEQREQUUID)
);

Learn More