I_ARunAnlytsPurgContrCube

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_ARunAnlytsPurgContrCube.
-- 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.

CREATE VIEW I_ARunAnlytsPurgContrCube AS
SELECT
  Material AS Product,
  Plant,
  Batch,
  StorageLocation,
  SupplyNumber,
  SupplyItem,
  SupplyScheduleLine,
  ProductAvailabilityDate,
  AssignedSupplyType,
  RequestedDeliveryDate,
  TotalQuantity,
  OpenSupplyQuantity,
  AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  ARunTmpAssignedQuantityInBsUnt,
  ReleasedQuantity,
  OpenSupplyQuantity AS OpenReleasedQuantity,
  BaseUnit,
  CalendarYear,
  CalendarMonth,
  CalendarMonthName,
  CalendarWeek,
  CalendarDay,
  MaterialGroup AS ProductGroup,
  MaterialType AS ProductType,
  SupAssgmtSource,
  CrossPlantConfigurableProduct,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesDistrict,
  Customer,
  CompanyCode,
  PurchasingOrganization,
  PurchasingGroup,
  cast( ' ' as meins ) AS SupAssgmtAggrgQtyUnit,
  NetPriceAmount,
  DocumentCurrency
FROM I_SupDmndAllDocPurgContrC
LEFT OUTER JOIN I_Product AS _Product ON Product = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON ProductGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Producttype AS _ProductType ON ProductType = _ProductType.ProductType  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrg ON SalesOrganization = _SalesOrg.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannel AS _DistrChnl ON DistributionChannel = _DistrChnl.DistributionChannel  -- association [0..1]
LEFT OUTER JOIN I_Division AS _Divn ON Division = _Divn.Division  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrict AS _SalesDist ON SalesDistrict = _SalesDist.SalesDistrict  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _Plant ON Plant = _Plant.Plant  -- association [0..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_PurchasingOrganization AS _PurchasingOrganization ON PurchasingOrganization = _PurchasingOrganization.PurchasingOrganization  -- association [0..1]
LEFT OUTER JOIN I_PurchasingGroup AS _PurchasingGroup ON PurchasingGroup = _PurchasingGroup.PurchasingGroup  -- association [0..1]
LEFT OUTER JOIN I_SupDmndAllDocSupType AS _SupType ON AssignedSupplyType = _SupType.AssignedSupplyType  -- association [0..1]
LEFT OUTER JOIN I_SupDmndAllDocSupSource AS _SupSrce ON SupAssgmtSource = _SupSrce.SupAssgmtSource  -- association [0..1]
;