C_PRATstProdnRslts

DDL: C_PRATSTPRODNRSLTS SQL: CPRATPR Type: view CONSUMPTION Package: OIU_TV
40 Fields 1 Data Sources 1 Associations

Detail of Production Regression

C_PRATstProdnRslts is a Consumption CDS View that provides data about "Detail of Production Regression" in SAP S/4HANA. It reads from 1 data source (I_PRATstProdnCompareUI) and exposes 40 fields with key fields PRATstAllocVersion, WellCompltnVolDoc, WellCompltnVolDocYr. It has 1 association to related views. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
I_PRATstProdnCompareUI detail from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_PRATstProdnRsltsHdr _PRATstProdnRsltsHdr detail.DeliveryNetwork = _PRATstProdnRsltsHdr.DeliveryNetwork and detail.ProductionDate = _PRATstProdnRsltsHdr.ProductionDate and detail.MajorProduct = _PRATstProdnRsltsHdr.MajorProduct and detail.AllocationFrequency = _PRATstProdnRsltsHdr.AllocationFrequency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPRATPR view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
EndUserText.label Detail of Production Regression view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (40)

KeyFieldSource TableSource FieldDescription
KEY PRATstAllocVersion I_PRATstProdnCompareUI PRATstAllocVersion
KEY WellCompltnVolDoc I_PRATstProdnCompareUI WellCompltnVolDoc
KEY WellCompltnVolDocYr I_PRATstProdnCompareUI WellCompltnVolDocYr
DeliveryNetwork I_PRATstProdnCompareUI DeliveryNetwork Delivery network ID
DeliveryNetworkName _PRATstProdnRsltsHdr DeliveryNetworkName
ProductionDate I_PRATstProdnCompareUI ProductionDate Production Date
AllocationFrequency I_PRATstProdnCompareUI AllocationFrequency
MajorProduct I_PRATstProdnCompareUI MajorProduct Major Product
PRAProductionHdrStsCritlty _PRATstProdnRsltsHdr PRAProductionHdrStsCritlty Prod Header Status Criticality
ProductionHeaderStatusText _PRATstProdnRsltsHdr ProductionHeaderStatusText Status
Well I_PRATstProdnCompareUI Well Well
WellCompletion I_PRATstProdnCompareUI WellCompletion Well Completion
VolumeType I_PRATstProdnCompareUI VolumeType Volume Type
TicketNumber I_PRATstProdnCompareUI TicketNumber
Transporter I_PRATstProdnCompareUI Transporter Partner
EffectiveValidityStartDate I_PRATstProdnCompareUI EffectiveValidityStartDate
InventoryDate I_PRATstProdnCompareUI InventoryDate
OriginatingMeasurementPt I_PRATstProdnCompareUI OriginatingMeasurementPt
ActualVolumeStsCritlty ActualVolumeStsCritlty
BaselineStandardVolume I_PRATstProdnCompareUI BaselineStandardVolume
StandardVolUnit I_PRATstProdnCompareUI StandardVolUnit
StandardVolume I_PRATstProdnCompareUI StandardVolume
ActualEnergyStsCritlty ActualEnergyStsCritlty
BaselineEnergy I_PRATstProdnCompareUI BaselineEnergy
EnergyUnit I_PRATstProdnCompareUI EnergyUnit
Energy I_PRATstProdnCompareUI Energy Energy Qty.
ActualHeatingValueStsCritlty ActualHeatingValueStsCritlty
BaselineHeatingValue I_PRATstProdnCompareUI BaselineHeatingValue
HeatingValUnit I_PRATstProdnCompareUI HeatingValUnit
HeatingValue I_PRATstProdnCompareUI HeatingValue
BslnNmbrOfDaysProduced I_PRATstProdnCompareUI BslnNmbrOfDaysProduced
NmbrOfDaysProduced I_PRATstProdnCompareUI NmbrOfDaysProduced
BaselineMaterial I_PRATstProdnCompareUI BaselineMaterial
Material I_PRATstProdnCompareUI Material Vehicle Model
StdDensStsCritlty StdDensStsCritlty
BaselineStandardDensity I_PRATstProdnCompareUI BaselineStandardDensity
StandardDensityUnit I_PRATstProdnCompareUI StandardDensityUnit
StandardDensity I_PRATstProdnCompareUI StandardDensity
DelivNtwkProcgDateTime _PRATstProdnRsltsHdr DelivNtwkProcgDateTime
_PRATstProdnRsltsHdr _PRATstProdnRsltsHdr

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_PRATstProdnRslts.
-- 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: CPRATPR

CREATE VIEW C_PRATstProdnRslts AS
SELECT
  detail.PRATstAllocVersion AS PRATstAllocVersion,
  detail.WellCompltnVolDoc AS WellCompltnVolDoc,
  detail.WellCompltnVolDocYr AS WellCompltnVolDocYr,
  detail.DeliveryNetwork AS DeliveryNetwork,
  _PRATstProdnRsltsHdr.DeliveryNetworkName AS DeliveryNetworkName,
  detail.ProductionDate AS ProductionDate,
  detail.AllocationFrequency AS AllocationFrequency,
  detail.MajorProduct AS MajorProduct,
  _PRATstProdnRsltsHdr.PRAProductionHdrStsCritlty AS PRAProductionHdrStsCritlty,
  _PRATstProdnRsltsHdr.ProductionHeaderStatusText AS ProductionHeaderStatusText,
  detail.Well AS Well,
  detail.WellCompletion AS WellCompletion,
  detail.VolumeType AS VolumeType,
  detail.TicketNumber AS TicketNumber,
  detail.Transporter AS Transporter,
  detail.EffectiveValidityStartDate AS EffectiveValidityStartDate,
  detail.InventoryDate AS InventoryDate,
  detail.OriginatingMeasurementPt AS OriginatingMeasurementPt,
  ActualVolumeStsCritlty,
  detail.BaselineStandardVolume AS BaselineStandardVolume,
  detail.StandardVolUnit AS StandardVolUnit,
  detail.StandardVolume AS StandardVolume,
  ActualEnergyStsCritlty,
  detail.BaselineEnergy AS BaselineEnergy,
  detail.EnergyUnit AS EnergyUnit,
  detail.Energy AS Energy,
  ActualHeatingValueStsCritlty,
  detail.BaselineHeatingValue AS BaselineHeatingValue,
  detail.HeatingValUnit AS HeatingValUnit,
  detail.HeatingValue AS HeatingValue,
  detail.BslnNmbrOfDaysProduced AS BslnNmbrOfDaysProduced,
  detail.NmbrOfDaysProduced AS NmbrOfDaysProduced,
  detail.BaselineMaterial AS BaselineMaterial,
  detail.Material AS Material,
  StdDensStsCritlty,
  detail.BaselineStandardDensity AS BaselineStandardDensity,
  detail.StandardDensityUnit AS StandardDensityUnit,
  detail.StandardDensity AS StandardDensity,
  _PRATstProdnRsltsHdr.DelivNtwkProcgDateTime AS DelivNtwkProcgDateTime
FROM I_PRATstProdnCompareUI AS detail
LEFT OUTER JOIN I_PRATstProdnRsltsHdr AS _PRATstProdnRsltsHdr ON detail.DeliveryNetwork = _PRATstProdnRsltsHdr.DeliveryNetwork AND detail.ProductionDate = _PRATstProdnRsltsHdr.ProductionDate AND detail.MajorProduct = _PRATstProdnRsltsHdr.MajorProduct AND detail.AllocationFrequency = _PRATstProdnRsltsHdr.AllocationFrequency  -- association [1..1]
;

Learn More