ACTUALCOST

15 Fields

ACTUALCOST is an SAP database table in S/4HANA. It contains 15 fields.

Fields (15)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 14
KEY ControllingArea ControllingArea 12
KEY FiscalYearPeriod FiscalYearPeriod 4
KEY OrderCategory OrderCategory 12
KEY OrderDescription OrderDescription 2
KEY OrderID OrderID 12
KEY OrderType OrderType 12
KEY OriginCtrlgDebitCreditCode OriginCtrlgDebitCreditCode 1
KEY Plant Plant 12
KEY Product Product 12
KEY ProductGroup ProductGroup 12
KEY ProfitCenter ProfitCenter 12
KEY StorageLocation StorageLocation 12
BaseUnit BaseUnit 4
WorkCenterInternalID WorkCenterInternalID 2

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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE ACTUALCOST (
    COMPANYCODE,
    CONTROLLINGAREA,
    FISCALYEARPERIOD,
    ORDERCATEGORY,
    ORDERDESCRIPTION,
    ORDERID,
    ORDERTYPE,
    ORIGINCTRLGDEBITCREDITCODE,
    PLANT,
    PRODUCT,
    PRODUCTGROUP,
    PROFITCENTER,
    STORAGELOCATION,
    BASEUNIT,
    WORKCENTERINTERNALID,
    PRIMARY KEY (COMPANYCODE, CONTROLLINGAREA, FISCALYEARPERIOD, ORDERCATEGORY, ORDERDESCRIPTION, ORDERID, ORDERTYPE, ORIGINCTRLGDEBITCREDITCODE, PLANT, PRODUCT, PRODUCTGROUP, PROFITCENTER, STORAGELOCATION)
);

Learn More