_COSTESTIMATE

20 Fields

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

Fields (20)

KeyField CDS FieldsUsed in Views
KEY CompanyCode CompanyCode 17
KEY ControllingArea ControllingArea 1
KEY ControllingDebitCreditCode ControllingDebitCreditCode 10
KEY CostEstimateValidityEndDate CostEstimateValidityEndDate 10
KEY CostEstimateValidityStartDate CostEstimateValidityStartDate 10
KEY CostingLotSize CostingLotSize 10
KEY CostOriginGroup CostOriginGroup 4
KEY IsLotSizeIndependent IsLotSizeIndependent 10
KEY LotSizeUnit LotSizeUnit 10
KEY Material Material 2
KEY OrderID OrderID 11
KEY OrderItem OrderItem 11
KEY PlanningCategory PlanningCategory 13
KEY Plant Plant 13
KEY ProducedProduct ProducedProduct 10
KEY SalesOrder SalesOrder 10
KEY SalesOrderItem SalesOrderItem 10
AmountInDisplayCurrency AmountInDisplayCurrency 10
DisplayCurrency DisplayCurrency 10
GlobalCurrency GlobalCurrency 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,
    CONTROLLINGDEBITCREDITCODE,
    COSTESTIMATEVALIDITYENDDATE,
    COSTESTIMATEVALIDITYSTARTDATE,
    COSTINGLOTSIZE,
    COSTORIGINGROUP,
    ISLOTSIZEINDEPENDENT,
    LOTSIZEUNIT,
    MATERIAL,
    ORDERID,
    ORDERITEM,
    PLANNINGCATEGORY,
    PLANT,
    PRODUCEDPRODUCT,
    SALESORDER,
    SALESORDERITEM,
    AMOUNTINDISPLAYCURRENCY,
    DISPLAYCURRENCY,
    GLOBALCURRENCY,
    PRIMARY KEY (COMPANYCODE, CONTROLLINGAREA, CONTROLLINGDEBITCREDITCODE, COSTESTIMATEVALIDITYENDDATE, COSTESTIMATEVALIDITYSTARTDATE, COSTINGLOTSIZE, COSTORIGINGROUP, ISLOTSIZEINDEPENDENT, LOTSIZEUNIT, MATERIAL, ORDERID, ORDERITEM, PLANNINGCATEGORY, PLANT, PRODUCEDPRODUCT, SALESORDER, SALESORDERITEM)
);

Learn More