PLANCOST

12 Fields

PLANCOST is an SAP database table in S/4HANA. It contains 12 fields.

Fields (12)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 4
KEY ControllingArea ControllingArea 5
KEY OrderCategory OrderCategory 5
KEY OrderID OrderID 5
KEY OrderType OrderType 5
KEY Plant Plant 5
KEY Product Product 5
KEY ProductGroup ProductGroup 5
KEY ProfitCenter ProfitCenter 5
KEY StorageLocation StorageLocation 5
BaseUnit BaseUnit 2
WorkCenterInternalID WorkCenterInternalID 1

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 PLANCOST (
    COMPANYCODE,
    CONTROLLINGAREA,
    ORDERCATEGORY,
    ORDERID,
    ORDERTYPE,
    PLANT,
    PRODUCT,
    PRODUCTGROUP,
    PROFITCENTER,
    STORAGELOCATION,
    BASEUNIT,
    WORKCENTERINTERNALID,
    PRIMARY KEY (COMPANYCODE, CONTROLLINGAREA, ORDERCATEGORY, ORDERID, ORDERTYPE, PLANT, PRODUCT, PRODUCTGROUP, PROFITCENTER, STORAGELOCATION)
);

Learn More