_COSTS

21 Fields

_COSTS is an SAP database table in S/4HANA. It contains 21 fields.

Fields (21)

KeyField CDS FieldsUsed in Views
KEY ChartOfAccounts ChartOfAccounts 1
KEY CompanyCode CompanyCode 10
KEY ControllingArea ControllingArea 4
KEY ControllingKeySubNumber ControllingKeySubNumber 1
KEY CostElement CostElement 2
KEY CostOriginGroup CostOriginGroup 2
KEY GLAccount GLAccount 1
KEY Material Material 2
KEY OrderID OrderID 3
KEY OrderItem OrderItem 2
KEY OrderOperation OrderOperation 1
KEY PartnerCostCenter PartnerCostCenter 1
KEY PartnerCostCtrActivityType PartnerCostCtrActivityType 1
KEY PlanningCategory PlanningCategory 1
KEY Plant Plant 5
KEY Product Product 1
KEY UnitOfMeasure UnitOfMeasure 2
KEY WorkCenterInternalID WorkCenterInternalID 1
CompanyCodeCurrency CompanyCodeCurrency 1
ControllingObject ControllingObject 1
DisplayCurrency DisplayCurrency 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 _COSTS (
    CHARTOFACCOUNTS,
    COMPANYCODE,
    CONTROLLINGAREA,
    CONTROLLINGKEYSUBNUMBER,
    COSTELEMENT,
    COSTORIGINGROUP,
    GLACCOUNT,
    MATERIAL,
    ORDERID,
    ORDERITEM,
    ORDEROPERATION,
    PARTNERCOSTCENTER,
    PARTNERCOSTCTRACTIVITYTYPE,
    PLANNINGCATEGORY,
    PLANT,
    PRODUCT,
    UNITOFMEASURE,
    WORKCENTERINTERNALID,
    COMPANYCODECURRENCY,
    CONTROLLINGOBJECT,
    DISPLAYCURRENCY,
    PRIMARY KEY (CHARTOFACCOUNTS, COMPANYCODE, CONTROLLINGAREA, CONTROLLINGKEYSUBNUMBER, COSTELEMENT, COSTORIGINGROUP, GLACCOUNT, MATERIAL, ORDERID, ORDERITEM, ORDEROPERATION, PARTNERCOSTCENTER, PARTNERCOSTCTRACTIVITYTYPE, PLANNINGCATEGORY, PLANT, PRODUCT, UNITOFMEASURE, WORKCENTERINTERNALID)
);

Learn More