QUANTITY

33 Fields

QUANTITY is an SAP database table in S/4HANA. It contains 33 fields.

Fields (33)

KeyField CDS FieldsUsed in Views
KEY CmmdtyHdgConstellationExposure CmmdtyHdgConstellationExposure 2
KEY ControllingArea ControllingArea 1
KEY OrderCategory OrderCategory 2
KEY OrderID OrderID 2
KEY OrderType OrderType 1
KEY Plant Plant 3
KEY Product Product 3
KEY ProfitCenter ProfitCenter 3
BaseUnit BaseUnit,CostCtrActivityTypeQtyUnit 2
CmmdtyHdgDealQtyInExposureUoM CmmdtyHdgDealQtyInExposureUoM 1
CmmdtyHdgIsPrcgInDelivPeriod CmmdtyHdgIsPrcgInDelivPeriod 1
CmmdtyHdgParamDsgntdUtilzn CmmdtyHdgParamDsgntdUtilzn 1
CmmdtyHdgParamFreeStndgUtilzn CmmdtyHdgParamFreeStndgUtilzn 1
CmmdtyHdgPlanExposureDirection CmmdtyHdgPlanExposureDirection 2
CmmdtyHdgPlanExposureHedgeBook CmmdtyHdgPlanExposureHedgeBook 2
CmmdtyHdgPlanExpsrMktIDCode CmmdtyHdgPlanExpsrMktIDCode 2
CmmdtyHdgPlnExpsrCompanyCode CmmdtyHdgPlnExpsrCompanyCode 2
CmmdtyHdgPlnExpsrPerdStartDate CmmdtyHdgPlnExpsrPerdStartDate 2
CmmdtyHdgPlnExpsrPeriodClass CmmdtyHdgPlnExpsrPeriodClass 2
CmmdtyHdgPlnExpsrQuantityUnit CmmdtyHdgPlnExpsrQuantityUnit 2
CmmdtyHedgeConstellationDeal CmmdtyHedgeConstellationDeal 1
CmmdtyHedgePlanExposureDCSID CmmdtyHedgePlanExposureDCSID 2
CmmdtyHedgePlanExposureVersion CmmdtyHedgePlanExposureVersion 1
CmmdtyHedgePlnExposureQuantity CmmdtyHedgePlnExposureQuantity 2
CommodityHedgePlanExposureUUID CommodityHedgePlanExposureUUID 2
CostCtrActivityTypeQtyUnit CostCtrActivityTypeQtyUnit 1
Counterparty Counterparty 1
FinancialInstrProdTypeName FinancialInstrProdTypeName 1
MaterialLedgerPeriodType MaterialLedgerPeriodType 1
PostingDate PostingDate 2
PreviousInventoryQuantity PreviousInventoryQuantity 2
ProducedProduct Product 1
ValuationClass ValuationClass 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 QUANTITY (
    CMMDTYHDGCONSTELLATIONEXPOSURE,
    CONTROLLINGAREA,
    ORDERCATEGORY,
    ORDERID,
    ORDERTYPE,
    PLANT,
    PRODUCT,
    PROFITCENTER,
    BASEUNIT,
    CMMDTYHDGDEALQTYINEXPOSUREUOM,
    CMMDTYHDGISPRCGINDELIVPERIOD,
    CMMDTYHDGPARAMDSGNTDUTILZN,
    CMMDTYHDGPARAMFREESTNDGUTILZN,
    CMMDTYHDGPLANEXPOSUREDIRECTION,
    CMMDTYHDGPLANEXPOSUREHEDGEBOOK,
    CMMDTYHDGPLANEXPSRMKTIDCODE,
    CMMDTYHDGPLNEXPSRCOMPANYCODE,
    CMMDTYHDGPLNEXPSRPERDSTARTDATE,
    CMMDTYHDGPLNEXPSRPERIODCLASS,
    CMMDTYHDGPLNEXPSRQUANTITYUNIT,
    CMMDTYHEDGECONSTELLATIONDEAL,
    CMMDTYHEDGEPLANEXPOSUREDCSID,
    CMMDTYHEDGEPLANEXPOSUREVERSION,
    CMMDTYHEDGEPLNEXPOSUREQUANTITY,
    COMMODITYHEDGEPLANEXPOSUREUUID,
    COSTCTRACTIVITYTYPEQTYUNIT,
    COUNTERPARTY,
    FINANCIALINSTRPRODTYPENAME,
    MATERIALLEDGERPERIODTYPE,
    POSTINGDATE,
    PREVIOUSINVENTORYQUANTITY,
    PRODUCEDPRODUCT,
    VALUATIONCLASS,
    PRIMARY KEY (CMMDTYHDGCONSTELLATIONEXPOSURE, CONTROLLINGAREA, ORDERCATEGORY, ORDERID, ORDERTYPE, PLANT, PRODUCT, PROFITCENTER)
);

Learn More