TRVS4_COSTASS_D

Transparent Table Application Table
70 Fields 2 CDS Views

Draft table for entity I_TRAVELCOSTASSIGNMENT

TRVS4_COSTASS_D is an SAP database table in S/4HANA. Draft table for entity I_TRAVELCOSTASSIGNMENT. It contains 70 fields. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
E_TrvlReqCostAssignmentDraft view_entity from EXTENSION Trvl Req Cost Assgmt - Extn
R_TrvlReqCostAssignmentDraft view_entity from BASIC Trvl Req Cost Assgmt Draft

Fields (70)

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
lastchangedatetime vdm_lastchangedon Last Changed On
costassgmtlocllastchgddtetme abp_lastchange_tstmpl Changed On
trvlcostassgmtpercentageunit unit Unit
trvlcostassgmtamtorpctg betpr Amt/Percent
destinationassignment keyzi Dest.Assignment

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_TRAVELCOSTASSIGNMENT
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE TRVS4_COSTASS_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]
    LASTCHANGEDATETIME,              -- Last Changed On [vdm_lastchangedon]
    COSTASSGMTLOCLLASTCHGDDTETME,    -- Changed On [abp_lastchange_tstmpl]
    TRVLCOSTASSGMTPERCENTAGEUNIT,    -- Unit [unit]
    TRVLCOSTASSGMTAMTORPCTG,         -- Amt/Percent [betpr]
    DESTINATIONASSIGNMENT,           -- Dest.Assignment [keyzi]
    PRIMARY KEY (MANDT, PERSONNELNUMBER, TRAVELTRIPNUMBER, TRAVELREQUUID, SEQREQUUID, TRAVELREQUESTSEQUENCENUMBER, COSTASSIGNMENTREFERENCEKEY, TRAVELCOSTASSIGNMENTTYPE)
);

Learn More