I_ARunAnlytsSupAssgmtCube

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_ARunAnlytsSupAssgmtCube.
-- 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_ARunAnlytsSupAssgmtCube AS
SELECT
  Assgmt.Plant AS Plant,
  Assgmt.Material AS Material,
  Assgmt.StorageLocation AS StorageLocation,
  Assgmt.Batch AS Batch,
  Assgmt.RequirementType AS RequirementType,
  Assgmt.RequirementDocumentNumber AS RequirementDocumentNumber,
  Assgmt.RequirementDocumentItem AS RequirementDocumentItem,
  Assgmt.SupProtTimeBucketUUID AS SupProtTimeBucketUUID,
  Assgmt.AssignedSupplyType AS AssignedSupplyType,
  Assgmt.SupplyNumber AS SupplyNumber,
  Assgmt.SupplyItem AS SupplyItem,
  Assgmt.SupplyScheduleLine AS SupplyScheduleLine,
  Assgmt.RequestedDate AS RequestedDate,
  Assgmt.ProductAvailabilityDate AS ProductAvailabilityDate,
  Assgmt.SupplyDeliveryDate AS SupplyDeliveryDate,
  Assgmt.RequestedDeliveryDate AS RequestedDeliveryDate,
  ARunSupDlyHrznInWeeks,
  SupAssgmtSource,
  Assgmt.CalendarYear AS CalendarYear,
  Assgmt.CalendarMonth AS CalendarMonth,
  Assgmt.CalendarMonthName AS CalendarMonthName,
  Assgmt.CalendarWeek AS CalendarWeek,
  Assgmt.CalendarDay AS CalendarDay,
  Assgmt.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  Assgmt.NormalAssignedQuantityInBsUnt AS NormalAssignedQuantityInBsUnt,
  Assgmt.PreviewAssignedQuantityInBsUnt AS PreviewAssignedQuantityInBsUnt,
  Assgmt.ARunTmpAssignedQuantityInBsUnt AS ARunTmpAssignedQuantityInBsUnt,
  Assgmt.BaseUnit AS BaseUnit,
  Assgmt.MaterialGroup AS MaterialGroup,
  Assgmt.MaterialType AS MaterialType,
  Assgmt.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  Assgmt.SupplyProtectionName AS SupplyProtectionName,
  Assgmt.SalesOrganization AS SalesOrganization,
  Assgmt.DistributionChannel AS DistributionChannel,
  Assgmt.Division AS Division,
  Assgmt.SalesDistrict AS SalesDistrict,
  Assgmt.Customer AS Customer,
  Assgmt.CompanyCode AS CompanyCode,
  cast( ' ' as meins ) AS SupAssgmtAggrgQtyUnit,
  Assgmt.NetPriceAmount AS NetPriceAmount,
  Assgmt.DocumentCurrency AS DocumentCurrency,
  Assgmt.RequirementSegment AS RequirementSegment
FROM I_SupDmndAllDocAssgmt AS Assgmt
LEFT OUTER JOIN I_Product AS _Product ON Material = _Product.Product  -- association [0..1]
LEFT OUTER JOIN I_ProductGroup AS _ProductGroup ON MaterialGroup = _ProductGroup.MaterialGroup  -- association [0..1]
LEFT OUTER JOIN I_Producttype AS _ProductType ON MaterialType = _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_Customer AS _Customer ON Customer = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_SupDmndAllDocRqmtType AS _Rqmt ON RequirementType = _Rqmt.RequirementType  -- 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]
LEFT OUTER JOIN I_ARunSupDlyHrznText AS _SupDlyHrzn ON ARunSupDlyHrznInWeeks = _SupDlyHrzn.ARunSupDlyHrznInWeeks  -- association [0..1]
;