ACCOSTRATE

Transparent Table Application Table
37 Fields 3 CDS Views

Cost Rate

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

CDS Views using this table (3)

ViewTypeJoinVDMDescription
E_AccountingCostRate view from EXTENSION Include View for Cost Rate
I_PlnCostRateCompBreakdown view_entity from BASIC Plan Cost Rate Component Breakdown
P_ACCOSTRATERawData view from BASIC

Fields (37)

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
ico_rate FCO_INTER_COMPANY_RATE ICO Rate
comp_receiving FCO_RECEIVING_COMPANY_CODE Receiving Company
srv_cost_level FCO_SERVICE_COST_LEVEL Service Cost Level
pernr PERNR_D Personnel No.
ps_posid PS_POSID WBS Element
work_item_id /CPD/PFP_WORKITEM_ID Work Item ID
overtimecat CATS_OVERTIME_CATEGORY Overtime Category
ps_psp_pnr PS_PSP_PNR WBS Element
dummy_accostrate_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.

-- 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]
    ICO_RATE,                      -- ICO Rate [FCO_INTER_COMPANY_RATE]
    COMP_RECEIVING,                -- Receiving Company [FCO_RECEIVING_COMPANY_CODE]
    SRV_COST_LEVEL,                -- Service Cost Level [FCO_SERVICE_COST_LEVEL]
    PERNR,                         -- Personnel No. [PERNR_D]
    PS_POSID,                      -- WBS Element [PS_POSID]
    WORK_ITEM_ID,                  -- Work Item ID [/CPD/PFP_WORKITEM_ID]
    OVERTIMECAT,                   -- Overtime Category [CATS_OVERTIME_CATEGORY]
    PS_PSP_PNR,                    -- WBS Element [PS_PSP_PNR]
    DUMMY_ACCOSTRATE_INCL_EEW_PS,  -- Dummy [CFD_DUMMY]
    PRIMARY KEY (CLIENT, RATEUUID)
);

Learn More