I_CmmdtyPhysPosQtyCube

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_CmmdtyPhysPosQtyCube.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: ICMDTYPOSREPCUBE
-- Parameters: P_MTMDataSelectionType : cmm_vlogp_consumptiontype, P_DisplayUnitOfMeasure : cds_view_uom, P_EndOfDaySnapshotFromDate : cds_evaluation_date, P_EndOfDaySnapshotToDate : cds_evaluation_date_comp

CREATE VIEW I_CmmdtyPhysPosQtyCube AS
SELECT
  vlogp.PricingKey AS PricingKey,
  vlogp.Version AS Version,
  vlogp.PricingDocumentItem AS PricingDocumentItem,
  vlogp.ConditionType AS ConditionType,
  vlogp.SubConditionType AS SubConditionType,
  VersStockRecordUUID,
  vlogp.EvaluationDate AS EvaluationDate,
  vlogp.PriceQuotationDate AS PriceQuotationDate,
  vlogp.EndOfDaySnapshotFromDate AS EndOfDaySnapshotFromDate,
  vlogp.EndOfDaySnapshotToDate AS EndOfDaySnapshotToDate,
  vlogp.MTMDataSelectionType AS MTMDataSelectionType,
  vlogp.MTMDataSourceType AS MTMDataSourceType,
  vlogp.ValidityStartDate AS ValidityStartDate,
  vlogp.ValidityStartDateTime AS ValidityStartDateTime,
  vlogp.ValidityEndDate AS ValidityEndDate,
  vlogp.ValidityEndDateTime AS ValidityEndDateTime,
  vlogp.SourceTransactionEventDateTime AS SourceTransactionEventDateTime,
  vlogp.SourceTransacEventEndDateTime AS SourceTransacEventEndDateTime,
  vlogp.EndOfDaySnapshotDateTimeFrom AS EndOfDaySnapshotDateTimeFrom,
  vlogp.EndOfDaySnapshotDateTimeTo AS EndOfDaySnapshotDateTimeTo,
  vlogp.EndOfDaySnapshotDate AS EndOfDaySnapshotDate,
  vlogp.MaximumVersion AS MaximumVersion,
  vlogp.PreviousVersion AS PreviousVersion,
  vlogp.SalesOrganization AS SalesOrganization,
  vlogp.DistributionChannel AS DistributionChannel,
  vlogp.Division AS Division,
  vlogp.Creditor AS Creditor,
  vlogp.SoldToParty AS SoldToParty,
  vlogp.Material AS Material,
  vlogp.PhysicalCommodity AS PhysicalCommodity,
  vlogp.Plant AS Plant,
  vlogp.StorageLocation AS StorageLocation,
  vlogp.Batch AS Batch,
  vlogp.IncotermsClassification AS IncotermsClassification,
  vlogp.IncotermsTransferLocation AS IncotermsTransferLocation,
  vlogp.ConditionApplication AS ConditionApplication,
  vlogp.SourceDocument AS SourceDocument,
  vlogp.SourceDocumentBusObjType AS SourceDocumentBusObjType,
  vlogp.OriginReferenceDocument AS OriginReferenceDocument,
  vlogp.OriginReferenceDocumentItem AS OriginReferenceDocumentItem,
  vlogp.OriginReferenceDocBusObjType AS OriginReferenceDocBusObjType,
  vlogp.ReferenceDocument AS ReferenceDocument,
  vlogp.ReferenceDocumentItem AS ReferenceDocumentItem,
  vlogp.ReferenceDocBusObjType AS ReferenceDocBusObjType,
  vlogp.DeliveryDate AS DeliveryDate,
  vlogp.ExpectedPaymentDate AS ExpectedPaymentDate,
  vlogp.StatisticsCurrency AS StatisticsCurrency,
  vlogp.DocumentCurrency AS DocumentCurrency,
  vlogp.ProfitCenter AS ProfitCenter,
  vlogp.BusinessArea AS BusinessArea,
  vlogp.PurchasingOrganization AS PurchasingOrganization,
  vlogp.MaterialGroup AS MaterialGroup,
  vlogp.IsIntercompanyTransfer AS IsIntercompanyTransfer,
  vlogp.ConditionTermRateCurrency AS ConditionTermRateCurrency,
  vlogp.ConditionTermRateQuantity AS ConditionTermRateQuantity,
  vlogp.ConditionTermRateQuantityUnit AS ConditionTermRateQuantityUnit,
  vlogp.ConditionTermValue AS ConditionTermValue,
  vlogp.ConditionTermValueCurrency AS ConditionTermValueCurrency,
  vlogp.ConditionTermRateMktCurrency AS ConditionTermRateMktCurrency,
  vlogp.ConditionTermName AS ConditionTermName,
  vlogp.ConditionTermStatus AS ConditionTermStatus,
  vlogp.RoundingDecimalPlaces AS RoundingDecimalPlaces,
  vlogp.ConditionTermRateIsRounded AS ConditionTermRateIsRounded,
  vlogp.ConditionTermRateNmrtr AS ConditionTermRateNmrtr,
  vlogp.ConditionTermRateDnmntr AS ConditionTermRateDnmntr,
  vlogp.ConditionTermExtensionUsage AS ConditionTermExtensionUsage,
  vlogp.MaturitySelectionType AS MaturitySelectionType,
  vlogp.QuotationPeriodReferenceDate AS QuotationPeriodReferenceDate,
  vlogp.QuotationDateList AS QuotationDateList,
  vlogp.QuotationPeriodStartDate AS QuotationPeriodStartDate,
  vlogp.QuotationPeriodEndDate AS QuotationPeriodEndDate,
  vlogp.DerivativeContrSpecification AS DerivativeContrSpecification,
  vlogp.MarketIdentifierCode AS MarketIdentifierCode,
  vlogp.MaturityKeyDate AS MaturityKeyDate,
  vlogp.BasisType AS BasisType,
  vlogp.BasisID AS BasisID,
  vlogp.QuotationGroup AS QuotationGroup,
  vlogp.QuotationGroupCalculationRule AS QuotationGroupCalculationRule,
  vlogp.PricingStatus AS PricingStatus,
  vlogp.ConditionTermRateFixation AS ConditionTermRateFixation,
  vlogp.CndnTermRateFixationDate AS CndnTermRateFixationDate,
  vlogp.CndnTermRateFixationTime AS CndnTermRateFixationTime,
  vlogp.MinimumConditionTermLimitRate AS MinimumConditionTermLimitRate,
  vlogp.MaximumConditionTermLimitRate AS MaximumConditionTermLimitRate,
  vlogp.ConditionTermLimitRateCurrency AS ConditionTermLimitRateCurrency,
  vlogp.ConditionTermLimitRateQuantity AS ConditionTermLimitRateQuantity,
  vlogp.CndnTermLimitRateQuantityUnit AS CndnTermLimitRateQuantityUnit,
  vlogp.ConditionTermLimitRateStatus AS ConditionTermLimitRateStatus,
  vlogp.CommodityQuantityInTermUnit AS CommodityQuantityInTermUnit,
  vlogp.MTMConditionGroupCategory AS MTMConditionGroupCategory,
  vlogp.MTMConditionGroup AS MTMConditionGroup,
  vlogp.MTMCalculationGroup AS MTMCalculationGroup,
  vlogp.MTMAdjustmentType AS MTMAdjustmentType,
  vlogp.MTMCalcGrpMarketPriceCondition AS MTMCalcGrpMarketPriceCondition,
  vlogp.DisplayUnitOfMeasure AS DisplayUnitOfMeasure,
  CommodityPriceExposureQuantity,
  CommodityUnit,
  vlogp.PriceIsRealized AS PriceIsRealized,
  vlogp.ContrPriceExposureIsExecuted AS ContrPriceExposureIsExecuted,
  vlogp.CommodityPriceFixationStatus AS CommodityPriceFixationStatus,
  vlogp.ImplicitFixationIsRelevant AS ImplicitFixationIsRelevant,
  vlogp.ConditionTermRateIsFixed AS ConditionTermRateIsFixed,
  vlogp.ReportingDate AS ReportingDate,
  vlogp.ReportingYear AS ReportingYear,
  vlogp.ReportingMonth AS ReportingMonth,
  vlogp.AdjustedReportingDate AS AdjustedReportingDate,
  vlogp.AdjustedReportingYear AS AdjustedReportingYear,
  vlogp.AdjustedReportingMonth AS AdjustedReportingMonth,
  UnrealizedPriceExposureQty,
  MaterialStockPriceExposureUnit,
  UnpricedUndeliveredCtrExpsrQty,
  UnpricedDeliveredCtrExpsrQty,
  PricedUndeliveredContrExpsrQty,
  PricedDeliveredContrExpsrQty,
  UndeliveredMarketPrExposureQty,
  DeliveredMarketPrExposureQty,
  ReducnNoPrcEstablishedExpsrQty,
  NoFutureEstabPurchaseContrQty,
  NoFutureEstabSalesContrQty,
  FlatPricedContractsQty,
  NoFutrEstablishedContrExpsrQty,
  NoBsEstablishedContrExpsrQty,
  NoPrcEstablishedContrExpsrQty,
  FixPricedDelivsPriceExpsrQty,
  UndeliveredFixPrCtrPrExpsrQty,
  UnpricedUnrlzdGdsIssExpsrQty,
  UnpricedUnrlzdGdsRcptExpsrQty,
  TodayPricedUndeliveredExpsrQty,
  FixPricedContrPriceExpsrQty,
  TodayPricedContractsExpsrQty,
  GoodsReceiptQuantity,
  RealizedMaterialStkPrcExpsrQty,
  InventoryAndContractsQty,
  TotalPhysicalPositionQty,
  ImpliedFuturesPositionQty,
  BasisPositionQty,
  OutrightPriceExposureQty
FROM I_CmmdtyPhysicalPosQty
LEFT OUTER JOIN I_BusinessObjType AS _SourceDocumentBusObjType ON SourceDocumentBusObjType = _SourceDocumentBusObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _CommodityUnit ON CommodityUnit = _CommodityUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _MaterialStockUnit ON MaterialStockPriceExposureUnit = _MaterialStockUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PricingStatus AS _PricingStatus ON PricingStatus = _PricingStatus.PricingStatus  -- association [0..1]
LEFT OUTER JOIN I_DerivativeContrSpec AS _DerivativeContrSpecification ON DerivativeContrSpecification = _DerivativeContrSpecification.DerivativeContrSpecification  -- association [0..1]
LEFT OUTER JOIN I_MarketIdentCode AS _MarketIdentifierCode ON MarketIdentifierCode = _MarketIdentifierCode.MarketIdentifierCode  -- association [0..1]
LEFT OUTER JOIN I_Cmmdty AS _PhysicalCommodity ON PhysicalCommodity = _PhysicalCommodity.Commodity  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_MtmDataSourceType AS _MTMDataSourceType ON MTMDataSourceType = _MTMDataSourceType.MTMDataSourceType  -- association [0..1]
LEFT OUTER JOIN I_MtmConditionGroup AS _MTMConditionGroup ON MTMConditionGroup = _MTMConditionGroup.MTMConditionGroup  -- association [0..1]
LEFT OUTER JOIN I_Mtmconditiongroupcategory AS _MTMConditionGroupCategory ON MTMConditionGroupCategory = _MTMConditionGroupCategory.MTMConditionGroupCategory  -- association [0..1]
LEFT OUTER JOIN I_MtmAdjustmentType AS _MTMAdjustmentType ON MTMAdjustmentType = _MTMAdjustmentType.MTMAdjustmentType  -- association [0..1]
LEFT OUTER JOIN I_MtmCalculationGroup AS _MTMCalculationGroup ON MTMCalculationGroup = _MTMCalculationGroup.MTMCalculationGroup  -- association [0..1]
LEFT OUTER JOIN I_BasisID AS _BasisID ON BasisID = _BasisID.BasisID  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _ReferenceDocBusObjType ON ReferenceDocBusObjType = _ReferenceDocBusObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_BusinessObjType AS _OriginReferenceDocBusObjType ON OriginReferenceDocBusObjType = _OriginReferenceDocBusObjType.BusinessObjectType  -- association [0..1]
LEFT OUTER JOIN I_Supplier AS _Creditor ON Creditor = _Creditor.Supplier  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_IncotermsClassification AS _IncotermsClassification ON IncotermsClassification = _IncotermsClassification.IncotermsClassification  -- association [0..1]
;