I_SupAssgmtDmndDetsCube

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_SupAssgmtDmndDetsCube.
-- 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_SupAssgmtDmndDetsCube AS
SELECT
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequirementType,
  RequestedDeliveryDate,
  ARunDocumentItemUniqueID,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  DeliveredQuantityInBaseUnit,
  OpenDemandQuantity,
  AssignedQuantityInBaseUnit,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  OnHoldQuantityInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  BaseUnit,
  cast(' ' as meins) AS SupAssgmtAggrgQtyUnit,
  SupAssgmtSupAvailySts,
  SupAssgmtSource,
  _SitnInstceIndicator.SitnNumberOfInstances AS SitnNumberOfInstances,
  ActlAmt,
  NetPriceAmount,
  DocumentCurrency,
  cast(:P_DisplayCurrency as vdm_v_display_currency) AS DisplayCurrency,
  Material,
  MaterialGroup,
  CrossPlantConfigurableProduct,
  Plant,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesDistrict,
  CompanyCode,
  Customer,
  ShippingPoint,
  ShipToParty,
  FashionCancelDateHorizon,
  SupAssgmtOrdStatus,
  CustomerGroup,
  FashionCancelDate,
  RequirementSegment,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  OrderType,
  OrderTypeName,
  StorageLocation,
  ShippingCondition,
  ShippingGroupRule,
  ShippingGroupNumber,
  ARunSupplyAssgmtReleaseRule,
  PartnerFunction,
  SalesDocumentItemCategory,
  DeliveryGroup,
  ItemBillingBlockReason,
  cast('' as issue_sof) AS Issue,
  PurchasingDocument,
  Supplier
FROM I_SupAssgmtDmndDets AS Demand
LEFT OUTER JOIN C_SupAssgmtDmndSitn AS _Situation ON ARunDocumentItemUniqueID = _Situation.ARunDocumentItemUniqueID  -- association [0..*]
LEFT OUTER JOIN I_SitnInstceIndicator AS _SitnInstceIndicator ON ARunDocumentItemUniqueID = _SitnInstceIndicator.SitnInstceAnchorObjectKey AND _SitnInstceIndicator.SitnDefAnchorObject = 'ARunDocumentItemUniqueID'  -- association [0..1]
LEFT OUTER JOIN C_BlockedSalesOrder AS _BlockedSalesOrder ON RequirementDocumentNumber = _BlockedSalesOrder.SalesOrder  -- association [0..*]
LEFT OUTER JOIN I_SupAssgmtDetailsCube AS _AssgmtDetailsCube ON RequirementDocumentNumber = _AssgmtDetailsCube.RequirementDocumentNumber AND RequirementDocumentItem = _AssgmtDetailsCube.RequirementDocumentItem AND RequirementType = _AssgmtDetailsCube.RequirementType  -- association [0..*]
LEFT OUTER JOIN I_UnitOfMeasure AS _BaseUnit ON BaseUnit = _BaseUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DisplayCurrency ON DisplayCurrency = _DisplayCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Currency AS _DocCurrency ON DocumentCurrency = _DocCurrency.Currency  -- association [0..1]
;