I_PRATstContrAllocRsltsHdr

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_PRATstContrAllocRsltsHdr.
-- 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: IPRATSTCARH

CREATE VIEW I_PRATstContrAllocRsltsHdr AS
SELECT
  DeliveryNetwork,
  SalesDate,
  MajorProduct,
  'M' AS AllocationFrequency,
  _DeliveryNetwork.DeliveryNetworkName AS DeliveryNetworkName
FROM I_PRATstContrAllocScen AS base
LEFT OUTER JOIN I_PRATstFailedActlPrimScen AS _PRATstFailedActlPrimScen ON base.DeliveryNetwork = _PRATstFailedActlPrimScen.DeliveryNetwork AND base.SalesDate = _PRATstFailedActlPrimScen.SalesDate AND base.MajorProduct = _PRATstFailedActlPrimScen.MajorProduct AND _PRATstFailedActlPrimScen.AllocationFrequency = 'M'  -- association [1..1]
LEFT OUTER JOIN I_PRATstFailedActlSecdryScen AS _PRATstFailedActlSecdryScen ON base.DeliveryNetwork = _PRATstFailedActlSecdryScen.DeliveryNetwork AND base.SalesDate = _PRATstFailedActlSecdryScen.SalesDate AND base.MajorProduct = _PRATstFailedActlSecdryScen.MajorProduct AND _PRATstFailedActlSecdryScen.AllocationFrequency = 'M'  -- association [1..1]
LEFT OUTER JOIN I_PRATstFailedEntldPrimScen AS _PRATstFailedEntldPrimScen ON base.DeliveryNetwork = _PRATstFailedEntldPrimScen.DeliveryNetwork AND base.SalesDate = _PRATstFailedEntldPrimScen.SalesDate AND base.MajorProduct = _PRATstFailedEntldPrimScen.MajorProduct AND _PRATstFailedEntldPrimScen.AllocationFrequency = 'M'  -- association [1..1]
LEFT OUTER JOIN I_PRATstFailedEntldSecdryScen AS _PRATstFailedEntldSecdryScen ON base.DeliveryNetwork = _PRATstFailedEntldSecdryScen.DeliveryNetwork AND base.SalesDate = _PRATstFailedEntldSecdryScen.SalesDate AND base.MajorProduct = _PRATstFailedEntldSecdryScen.MajorProduct  -- association [1..1]
LEFT OUTER JOIN C_PRATstActlPrimProdCompareUI AS _PRATstActlPrimProdCompareUI ON base.DeliveryNetwork = _PRATstActlPrimProdCompareUI.DeliveryNetwork AND base.SalesDate = _PRATstActlPrimProdCompareUI.SalesDate AND base.MajorProduct = _PRATstActlPrimProdCompareUI.MajorProduct  -- association [1..*]
LEFT OUTER JOIN C_PRATstActlSecdryCompareUI AS _PRATstActlSecdryCompareUI ON base.DeliveryNetwork = _PRATstActlSecdryCompareUI.DeliveryNetwork AND base.SalesDate = _PRATstActlSecdryCompareUI.SalesDate AND base.MajorProduct = _PRATstActlSecdryCompareUI.MajorProduct  -- association [1..*]
LEFT OUTER JOIN C_PRATstEntlPrimProdCompareUI AS _PRATstEntlPrimProdCompareUI ON base.DeliveryNetwork = _PRATstEntlPrimProdCompareUI.DeliveryNetwork AND base.SalesDate = _PRATstEntlPrimProdCompareUI.SalesDate AND base.MajorProduct = _PRATstEntlPrimProdCompareUI.MajorProduct  -- association [1..*]
LEFT OUTER JOIN C_PRATstEntldSecdryCompareUI AS _PRATstEntldSecdryCompareUI ON base.DeliveryNetwork = _PRATstEntldSecdryCompareUI.DeliveryNetwork AND base.SalesDate = _PRATstEntldSecdryCompareUI.SalesDate AND base.MajorProduct = _PRATstEntldSecdryCompareUI.MajorProduct  -- association [1..*]
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON base.DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- association [1..1]
LEFT OUTER JOIN I_PRADeliveryNetworkStatus AS _PRADeliveryNetworkStatus ON base.DeliveryNetwork = _PRADeliveryNetworkStatus.DeliveryNetwork AND base.SalesDate = _PRADeliveryNetworkStatus.ProductionDate AND base.MajorProduct = _PRADeliveryNetworkStatus.MajorProduct AND _PRADeliveryNetworkStatus.PRAApplicationCode = 'CA'  -- association [1..1]
;