ACCOSTRATE

Transparent Table Application Table
28 Fields 6 CDS Views

Cost Rate

ACCOSTRATE is an SAP database table in S/4HANA. Cost Rate. It contains 28 fields. 6 CDS views read from this table.

CDS Views using this table (6)

ViewTypeJoinVDMDescription
E_AccountingCostRate view from EXTENSION Include View for Cost Rate
P_AcccostrateRawData_2 view_entity from BASIC Accounting Cost Rate Raw Data
P_ACCOSTRATERawData view from BASIC ACCOSTRATE Table Data
P_ActualCostRateDEX view_entity from BASIC Data Extraction for Actual Cost Rate - Private
P_PlanCostRateDEX view_entity from BASIC Data Extraction for Plan Cost Rate - Private
P_ServiceCostRateDEX view_entity from BASIC Data Extraction for Service Cost Rate - Private

Fields (28)

KeyField Data ElementDescription DomainTypeLength
KEY client mandt Client
KEY rateuuid fco_rate_uuid Cost Rate UUID
ledger fins_ledger Ledger
bukrs bukrs Company Code
cvtyp cvtyp Crcy/Valuation
bttype fins_bttype Bus. Trans. Category
category fcom_category Plan Category
gjahrfrom fco_gjahr_from From Year
periodfrom fco_period_from From Period
datefrom fco_valid_from Valid From
gjahrto fco_gjahr_to Year To
periodto fco_period_to To Period
dateto fco_valid_to Valid To
currency waers Currency
totalamount fco_rate_total_amount Total Rate
fixedamount fco_rate_fixed_amount Fixed Rate
scalefactor fco_rate_scale_factor Per
activity_unit fco_activity_unit Activity Unit
usnam fco_created_by Created By
timestamp fco_created_time Creation Time
deleted fco_rate_deleted Cost Rate Deleted
deleted_by fco_deleted_by Deleted By User
deleted_time fco_deleted_time Deletion Time
ref_rateuuid fco_rate_uuid Cost Rate UUID
kokrs kokrs CO Area
kostl kostl Cost Center
activity_type lstar Activity Type
ucb_id fucb_id Breakdown ID

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.

-- Cost Rate
-- Category TRANSPARENT · Delivery class A
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACCOSTRATE (
    CLIENT,         -- Client [mandt]
    RATEUUID,       -- Cost Rate UUID [fco_rate_uuid]
    LEDGER,         -- Ledger [fins_ledger]
    BUKRS,          -- Company Code [bukrs]
    CVTYP,          -- Crcy/Valuation [cvtyp]
    BTTYPE,         -- Bus. Trans. Category [fins_bttype]
    CATEGORY,       -- Plan Category [fcom_category]
    GJAHRFROM,      -- From Year [fco_gjahr_from]
    PERIODFROM,     -- From Period [fco_period_from]
    DATEFROM,       -- Valid From [fco_valid_from]
    GJAHRTO,        -- Year To [fco_gjahr_to]
    PERIODTO,       -- To Period [fco_period_to]
    DATETO,         -- Valid To [fco_valid_to]
    CURRENCY,       -- Currency [waers]
    TOTALAMOUNT,    -- Total Rate [fco_rate_total_amount]
    FIXEDAMOUNT,    -- Fixed Rate [fco_rate_fixed_amount]
    SCALEFACTOR,    -- Per [fco_rate_scale_factor]
    ACTIVITY_UNIT,  -- Activity Unit [fco_activity_unit]
    USNAM,          -- Created By [fco_created_by]
    TIMESTAMP,      -- Creation Time [fco_created_time]
    DELETED,        -- Cost Rate Deleted [fco_rate_deleted]
    DELETED_BY,     -- Deleted By User [fco_deleted_by]
    DELETED_TIME,   -- Deletion Time [fco_deleted_time]
    REF_RATEUUID,   -- Cost Rate UUID [fco_rate_uuid]
    KOKRS,          -- CO Area [kokrs]
    KOSTL,          -- Cost Center [kostl]
    ACTIVITY_TYPE,  -- Activity Type [lstar]
    UCB_ID,         -- Breakdown ID [fucb_id]
    PRIMARY KEY (CLIENT, RATEUUID)
);

Learn More