I_SupDmndAllDocContrCube

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_SupDmndAllDocContrCube.
-- 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_SupDmndAllDocContrCube AS
SELECT
  Demand.RequirementDocumentNumber AS RequirementDocumentNumber,
  Demand.RequirementDocumentItem AS RequirementDocumentItem,
  Demand.RequestedDate AS RequestedDate,
  Demand.ProductAvailabilityDate AS ProductAvailabilityDate,
  Demand.RequirementType AS RequirementType,
  Demand.RequestedDeliveryDate AS RequestedDeliveryDate,
  RequestedRqmtQtyInBaseUnit,
  ( RequestedRqmtQtyInBaseUnit + SalesContractReleasedQuantity) AS OrderQuantityInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  DeliveredQuantityInBaseUnit,
  ( RequestedRqmtQtyInBaseUnit - AssignedQuantityInBaseUnit ) AS OpenForAssignmentQtyInBsUnt,
  SalesContractReleasedQuantity,
  RequestedRqmtQtyInBaseUnit AS OpenReleasedQuantity,
  Assgmt.AssignedQuantityInBaseUnit AS AssignedQuantityInBaseUnit,
  Assgmt.NormalAssignedQuantityInBsUnt AS NormalAssignedQuantityInBsUnt,
  Assgmt.PreviewAssignedQuantityInBsUnt AS PreviewAssignedQuantityInBsUnt,
  Assgmt.ARunTmpAssignedQuantityInBsUnt AS ARunTmpAssignedQuantityInBsUnt,
  Demand.BaseUnit AS BaseUnit,
  CalDate.CalendarYear AS CalendarYear,
  CalDate.CalendarMonth AS CalendarMonth,
  CalMonth.CalendarMonthName AS CalendarMonthName,
  concat_with_space( ARunDisplayTimeUnitText, CalDate.CalendarWeek, 1) AS CalendarWeek,
  CalDate.CalendarDay AS CalendarDay,
  Demand.Material AS Material,
  Demand.MaterialGroup AS MaterialGroup,
  MaterialType,
  Demand.CrossPlantConfigurableProduct AS CrossPlantConfigurableProduct,
  Demand.Plant AS Plant,
  coalesce( Demand.SalesOrganization, coalesce( Plant.SalesOrganization, '' ) ) AS SalesOrganization,
  coalesce( Demand.DistributionChannel, coalesce( Plant.DistributionChannel, '') ) AS DistributionChannel,
  coalesce( Demand.Division, coalesce( Plant.Division, '') ) AS Division,
  coalesce( Demand.SalesDistrict, coalesce( Plant.SalesDistrict, '') ) AS SalesDistrict,
  cast( coalesce( Demand.SoldToParty, coalesce( Plant.PlantCustomer, '') ) as kunnr ) AS Customer,
  coalesce( Demand.CompanyCode, coalesce( Plant.CompanyCode, '') ) AS CompanyCode,
  Demand.StorageLocation AS StorageLocation,
  cast( ' ' as meins ) AS SupAssgmtAggrgQtyUnit,
  Demand.NetPriceAmount AS NetPriceAmount,
  Demand.DocumentCurrency AS DocumentCurrency,
  _SalesDocument.AgrmtValdtyEndDate AS AgrmtValdtyEndDate,
  Dats_Days_Between( cast($session.system_date as dats), _SalesDocument.AgrmtValdtyEndDate) AS ContractExpiryDateHorizonDays,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  ARunPhysSupAssgdQtyInBsUnt
FROM I_SupDmndAllDocSDItm AS Demand
INNER JOIN I_SupDmndOvwPlant AS Plant ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN P_ARunAssgmtDmnd AS Assgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunCalendarDate AS CalDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CalendarMonthName AS CalMonth ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ARunTimeUnitText AS ARunTimeUnitText ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductText AS _ProductText ON Material = _ProductText.Product AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductGroupText AS _ProductGroupText ON MaterialGroup = _ProductGroupText.MaterialGroup AND _ProductGroupText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ProductTypeText AS _ProductTypeText ON MaterialType = _ProductTypeText.ProductType AND _ProductTypeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganizationText AS _SalesOrgText ON SalesOrganization = _SalesOrgText.SalesOrganization AND _SalesOrgText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DistributionChannelText AS _DistrChnl ON DistributionChannel = _DistrChnl.DistributionChannel AND _DistrChnl.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_DivisionText AS _Divn ON Division = _Divn.Division AND _Divn.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDistrictText AS _SalesDist ON SalesDistrict = _SalesDist.SalesDistrict AND _SalesDist.Language = $session.system_language  -- 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_SupDmndAllDocRqmtTypeT AS _RqmtText ON RequirementType = _RqmtText.RequirementType AND _RqmtText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_SalesDocument AS _SalesDocument ON RequirementDocumentNumber = _SalesDocument.SalesDocument  -- association [1..1]
;