_COSTESTIMATE

21 Fields

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

Fields (21)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 7
KEY ControllingArea ControllingArea 1
KEY CostOriginGroup CostOriginGroup 4
KEY Material Material 2
KEY OrderID OrderID 1
KEY OrderItem OrderItem 2
KEY PlanningCategory PlanningCategory 3
KEY Plant Plant 4
CostEstimateValidityEndDate CostEstimateValidityEndDate 1
CostEstimateValidityStartDate CostEstimateValidityStartDate 1
OrderAlternativeBillOfMaterial AlternativeBillOfMaterial 1
OrderBillOfMaterial BillOfMaterial 1
OrderBillOfMaterialVarUsage BillOfMaterialVariantUsage 1
OrderInternalID OrderInternalID 1
OrderProcessOfCoProduct ProcessOfCoProduct 1
OrderProductionVersion ProductionVersion 1
OrderTaskListGroup TaskListGroup 1
OrderTaskListGroupCounter TaskListGroupCounter 1
OrderTaskListType TaskListType 1
ProducedProduct ProducedProduct 1
ValuationType ValuationType 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 _COSTESTIMATE (
    COMPANYCODE,
    CONTROLLINGAREA,
    COSTORIGINGROUP,
    MATERIAL,
    ORDERID,
    ORDERITEM,
    PLANNINGCATEGORY,
    PLANT,
    COSTESTIMATEVALIDITYENDDATE,
    COSTESTIMATEVALIDITYSTARTDATE,
    ORDERALTERNATIVEBILLOFMATERIAL,
    ORDERBILLOFMATERIAL,
    ORDERBILLOFMATERIALVARUSAGE,
    ORDERINTERNALID,
    ORDERPROCESSOFCOPRODUCT,
    ORDERPRODUCTIONVERSION,
    ORDERTASKLISTGROUP,
    ORDERTASKLISTGROUPCOUNTER,
    ORDERTASKLISTTYPE,
    PRODUCEDPRODUCT,
    VALUATIONTYPE,
    PRIMARY KEY (COMPANYCODE, CONTROLLINGAREA, COSTORIGINGROUP, MATERIAL, ORDERID, ORDERITEM, PLANNINGCATEGORY, PLANT)
);

Learn More