I_PRATstProdnRsltsHdr

DDL: I_PRATSTPRODNRSLTSHDR SQL: IPRATPRH Type: view COMPOSITE Package: OIU_TV
6 Fields 1 Data Sources 4 Associations

Production Results Header

I_PRATstProdnRsltsHdr is a Composite CDS View that provides data about "Production Results Header" in SAP S/4HANA. It reads from 1 data source (I_PRATstProdnScen) and exposes 6 fields with key fields DeliveryNetwork, MajorProduct, ProductionDate, AllocationFrequency. It has 4 associations to related views. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
I_PRATstProdnScen base from

Associations (4)

CardinalityTargetAliasCondition
[1..1] I_PRADeliveryNetworkStatus _dnStatus base.DeliveryNetwork = _dnStatus.DeliveryNetwork and base.ProductionDate = _dnStatus.ProductionDate and base.MajorProduct = _dnStatus.MajorProduct and _dnStatus.PRAApplicationCode = 'PR'
[1..1] I_PRATstFailedProdnScen status base.DeliveryNetwork = status.DeliveryNetwork and base.ProductionDate = status.ProductionDate and base.MajorProduct = status.MajorProduct
[1..1] I_DeliveryNetwork _dn base.DeliveryNetwork = _dn.DeliveryNetwork
[1..*] C_PRATstProdnRsltsDet _ProdnDetails base.DeliveryNetwork = _ProdnDetails.DeliveryNetwork and base.ProductionDate = _ProdnDetails.ProductionDate and base.MajorProduct = _ProdnDetails.MajorProduct

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IPRATPRH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Production Results Header view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
VDM.viewType #COMPOSITE view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY DeliveryNetwork I_PRATstProdnScen DeliveryNetwork Delivery network ID
KEY MajorProduct I_PRATstProdnScen MajorProduct Major Product
KEY ProductionDate I_PRATstProdnScen ProductionDate Production Date
KEY AllocationFrequency
DeliveryNetworkName _dn DeliveryNetworkName
_ProdnDetails _ProdnDetails

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_PRATstProdnRsltsHdr.
-- 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: IPRATPRH

CREATE VIEW I_PRATstProdnRsltsHdr AS
SELECT
  base.DeliveryNetwork AS DeliveryNetwork,
  base.MajorProduct AS MajorProduct,
  base.ProductionDate AS ProductionDate,
  'M' AS AllocationFrequency,
  _dn.DeliveryNetworkName AS DeliveryNetworkName
FROM I_PRATstProdnScen AS base
LEFT OUTER JOIN I_PRADeliveryNetworkStatus AS _dnStatus ON base.DeliveryNetwork = _dnStatus.DeliveryNetwork AND base.ProductionDate = _dnStatus.ProductionDate AND base.MajorProduct = _dnStatus.MajorProduct AND _dnStatus.PRAApplicationCode = 'PR'  -- association [1..1]
LEFT OUTER JOIN I_PRATstFailedProdnScen AS status ON base.DeliveryNetwork = status.DeliveryNetwork AND base.ProductionDate = status.ProductionDate AND base.MajorProduct = status.MajorProduct  -- association [1..1]
LEFT OUTER JOIN I_DeliveryNetwork AS _dn ON base.DeliveryNetwork = _dn.DeliveryNetwork  -- association [1..1]
LEFT OUTER JOIN C_PRATstProdnRsltsDet AS _ProdnDetails ON base.DeliveryNetwork = _ProdnDetails.DeliveryNetwork AND base.ProductionDate = _ProdnDetails.ProductionDate AND base.MajorProduct = _ProdnDetails.MajorProduct  -- association [1..*]
;

Learn More