I_ARunOvwTotDmndCube

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_ARunOvwTotDmndCube.
-- 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.
-- SQL view name: IARUNTOTDMNDCUBE

CREATE VIEW I_ARunOvwTotDmndCube AS
SELECT
  ATPCheckUUID,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequestedDate,
  ProductAvailabilityDate,
  Demand.RequirementType AS RequirementType,
  DeliveredQuantityInBaseUnit,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  cast(' ' as meins) AS SupAssgmtAggrgQtyUnit,
  ARunTotSupProtQty,
  ARunActualSupProtQty,
  ABOPVariantUUID,
  ABOPVariantName,
  StartedByUser,
  ATPCheckStartUTCDateTime,
  ATPCheckEndUTCDateTime,
  ATPCheckStatus,
  ABOPExecutionMode,
  ATPRlvtDocItmIsSupAssgmtRlvt,
  ABOPAssignmentPreviewIsActive,
  Material,
  Plant,
  RequirementSegment,
  BaseUnit,
  SalesOrganization,
  DistributionChannel,
  Division,
  SalesDistrict,
  CustomerGroup,
  CompanyCode,
  MaterialGroup,
  OrderType,
  OrderTypeName,
  SoldToParty,
  ShipToParty,
  CrossPlantConfigurableProduct,
  DeliveryGroup,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  NetPriceAmount,
  NetPriceQuantity,
  NetAmount,
  cast ( NetPriceAmount * AssignedQuantityInBaseUnit as netwr ) AS ActlAmt,
  DocumentCurrency,
  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,
  AssignedQuantityInBaseUnit,
  NormalAssignedQuantityInBsUnt,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  OnHoldQuantityInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  PurchaseOrderByCustomer,
  DeliveryBlockReason,
  ProductCharacteristic1,
  ProductCharacteristic2,
  ProductCharacteristic3,
  OrganizationDivision,
  SalesOffice,
  FashionCancelDate,
  _Material.ProdCharc1InternalNumber AS ProdCharc1InternalNumber,
  _Material.ProdCharc2InternalNumber AS ProdCharc2InternalNumber,
  _Material.ProdCharc3InternalNumber AS ProdCharc3InternalNumber
FROM I_ARunOvwTotDmnd AS Demand
LEFT OUTER JOIN I_CalendarDate 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_Currency AS _DocCurrency ON DocumentCurrency = _DocCurrency.Currency  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [1..1]
;