C_ARunSimlnDmndQuery

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 C_ARunSimlnDmndQuery.
-- 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 C_ARunSimlnDmndQuery AS
SELECT
  ATPCheckUUID,
  RequirementDocumentNumber,
  RequirementDocumentItem,
  RequestedDate,
  ProductAvailabilityDate,
  RequirementType,
  DeliveredQuantityInBaseUnit,
  RequestedRqmtQtyInBaseUnit,
  ConfirmedRqmtQtyInBaseUnit,
  OpenDemandQuantity,
  cast ( 0 as arun_alloc_qty ) AS ARunReqdRqmtQtyFlfmtPercent,
  cast ( 0 as arun_alloc_qty ) AS ARunConfdReqdRqmtQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunDlvrdReqdRqmtQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunOpnReqdRqmtQtyRatioPct,
  ARunTotSupProtQty,
  ARunActualSupProtQty,
  CalendarMonth,
  CalendarWeek,
  CalendarYear,
  CalendarDay,
  CalendarMonthName,
  AssignedQuantityInBaseUnit,
  FixedQuantityInBaseUnit,
  SupAssgmtReservedQtyInBaseUnit,
  ReadyForReleaseQtyInBaseUnit,
  OnHoldQuantityInBaseUnit,
  InboundAssignedQuantityInBsUnt,
  cast ( 0 as arun_alloc_qty ) AS ARunFixedConfdRqmtQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunOpnForRelConfdQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunOnResvnConfdQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunOnHoldConfdQtyRatioPct,
  cast ( 0 as arun_alloc_qty ) AS ARunInbAssgdConfdQtyRatioPct,
  ABOPVariantUUID,
  _ARunABOPText.ABOPVariantName AS ABOPVariantName,
  StartedByUser,
  ATPCheckStatus,
  ABOPExecutionMode,
  ATPRlvtDocItmIsSupAssgmtRlvt,
  ABOPAssignmentPreviewIsActive,
  Demand.Material AS Material,
  Demand.Plant AS Plant,
  RequirementSegment,
  BaseUnit,
  Demand.SalesOrganization AS SalesOrganization,
  Demand.DistributionChannel AS DistributionChannel,
  Demand.Division AS Division,
  Demand.SalesDistrict AS SalesDistrict,
  CustomerGroup,
  Demand.CompanyCode AS CompanyCode,
  Demand.MaterialGroup AS MaterialGroup,
  OrderType,
  OrderTypeName,
  SoldToParty,
  ShipToParty,
  CrossPlantConfigurableProduct,
  DeliveryGroup,
  ProductSeasonYear,
  ProductSeason,
  ProductCollection,
  ProductTheme,
  NetAmount,
  DocumentCurrency,
  NetPriceAmount,
  NetPriceQuantity
FROM I_ARunSimlnDmndCube AS Demand
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_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_CustomerGroupText AS _CustomerGroup ON CustomerGroup = _CustomerGroup.CustomerGroup AND _CustomerGroup.Language = $session.system_language  -- 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_SupDmndRqmtTypeText AS _RqmtText ON RequirementType = _RqmtText.RequirementType AND _RqmtText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_ARunABOPText AS _ARunABOPText ON ATPCheckUUID = _ARunABOPText.ATPCheckUUID  -- association [0..1]
;