I_ARunAnlytsTotDmndCube

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_ARunAnlytsTotDmndCube.
-- 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.
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW I_ARunAnlytsTotDmndCube AS
SELECT
  RequirementDocumentNumber,
  RequirementDocumentItem,
  Demand.SupProtTimeBucketUUID AS SupProtTimeBucketUUID,
  RequestedDate,
  ProductAvailabilityDate,
  Demand.RequirementType AS RequirementType,
  _Rqmt.RequirementTypeName AS RequirementTypeName,
  Demand.RequestedDeliveryDate AS RequestedDeliveryDate,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  DeliveredQuantityInBaseUnit,
  OpenDemandQuantity,
  UnconfirmedQuantityInBaseUnit,
  AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  PreviewAssignedQuantityInBsUnt,
  ARunTmpAssignedQuantityInBsUnt,
  ARunPhysSupAssgdQtyInBsUnt,
  SupAssgmtReservedQtyInBaseUnit,
  FixedQuantityInBaseUnit,
  OnHoldQuantityInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  ReadyForReleaseQtyInBaseUnit AS SimulationRdyForRelQtyInBsUnt,
  BaseUnit,
  CalendarYear,
  CalendarMonth,
  CalendarMonthName,
  CalendarWeek,
  CalendarDay,
  Material AS Product,
  MaterialGroup AS ProductGroup,
  MaterialType AS ProductType,
  CrossPlantConfigurableProduct,
  Plant,
  PlantCountry,
  PlantRegion,
  SalesOrganization,
  _SalesOrg._Address.Country AS Country,
  _SalesOrg._Address.Region AS Region,
  DistributionChannel,
  Division,
  SalesDistrict,
  _SalesDocumentItem._SalesDocument.SalesOffice AS SalesOffice,
  _SalesDocumentItem._SalesDocument.SalesGroup AS SalesGroup,
  Customer AS SoldToParty,
  _SoldToParty.Country AS SoldToPartyCountry,
  _SoldToParty.Region AS SoldToPartyRegion,
  Customer AS ShipToParty,
  _ShipToParty.Country AS ShipToCountry,
  _ShipToParty.Region AS CustomerRegion,
  CompanyCode,
  StorageLocation,
  SupplyProtectionName,
  cast( ' ' as meins ) AS SupAssgmtAggrgQtyUnit,
  NetPriceAmount,
  DocumentCurrency,
  RequirementSegment,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  _SalesDocumentItem.FashionCancelDate AS FashionCancelDate,
  _SalesDocumentItem.ProductSeasonYear AS ProductSeasonYear,
  _SalesDocumentItem.ProductSeason AS ProductSeason,
  _SalesDocumentItem.ProductCollection AS ProductCollection,
  _SalesDocumentItem.ProductTheme AS ProductTheme,
  _SalesDocumentItem.ProductCharacteristic1 AS ProductCharacteristic1,
  _SalesDocumentItem.ProductCharacteristic2 AS ProductCharacteristic2,
  _SalesDocumentItem.ProductCharacteristic3 AS ProductCharacteristic3,
  ConfirmedDeliveryDate,
  ScheduleLine,
  OrderType
FROM I_SupDmndAllDocTotDmnd AS Demand
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_SalesOffice AS _SalesOffice ON SalesOffice = _SalesOffice.SalesOffice  -- association [0..1]
LEFT OUTER JOIN I_SalesGroup AS _SalesGroup ON SalesGroup = _SalesGroup.SalesGroup  -- 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 _SoldToParty ON SoldToParty = _SoldToParty.Customer  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _ShipToParty ON ShipToParty = _ShipToParty.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_SalesDocumentItem AS _SalesDocumentItem ON RequirementDocumentNumber = _SalesDocumentItem.SalesDocument AND RequirementDocumentItem = _SalesDocumentItem.SalesDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_CountryGeoPoint AS _PlantCountry ON PlantCountry = _PlantCountry.Country  -- association [0..1]
LEFT OUTER JOIN I_CountryGeoPoint AS _ShipToCountry ON ShipToCountry = _ShipToCountry.Country  -- association [0..1]
;