C_PRATstActlPrimProdDets

DDL: C_PRATSTACTLPRIMPRODDETS SQL: CPRATSTAPPD Type: view CONSUMPTION Package: OIU_TV
40 Fields 1 Data Sources 3 Associations

CA - Actual Primary Product Details tab

C_PRATstActlPrimProdDets is a Consumption CDS View that provides data about "CA - Actual Primary Product Details tab" in SAP S/4HANA. It reads from 1 data source (I_PRATstActlPrimProdCompareUI) and exposes 40 fields with key fields DeliveryNetwork, Well, WellCompletion, Material, PRAContract. It has 3 associations to related views. Part of development package OIU_TV.

Data Sources (1)

SourceAliasJoin Type
I_PRATstActlPrimProdCompareUI I_PRATstActlPrimProdCompareUI from

Associations (3)

CardinalityTargetAliasCondition
[0..1] I_PRADeliveryNetworkVH _DeliveryNetworkVH $projection.DeliveryNetwork = _DeliveryNetworkVH.DeliveryNetwork
[0..1] I_PRAMajorProductCodeVH _MajorProductVH $projection.MajorProduct = _MajorProductVH.MajorProduct
[1..1] I_PRATstContrAllocRsltsHdr _hdr $projection.DeliveryNetwork = _hdr.DeliveryNetwork and $projection.SalesDate = _hdr.SalesDate and $projection.MajorProduct = _hdr.MajorProduct

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CPRATSTAPPD view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.preserveKey true view
EndUserText.label CA - Actual Primary Product Details tab 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 DeliveryNetwork DeliveryNetwork Delivery network ID
KEY Well Well Well
KEY WellCompletion WellCompletion Well Completion
KEY Material Material Vehicle Model
KEY PRAContract PRAContract Contract
KEY SalesDate SalesDate Sales Date
KEY PRAOwner PRAOwner
KEY OwnerInterestType OwnerInterestType
KEY OwnerInterestSequence OwnerInterestSequence
KEY OriginatingMeasurementPt OriginatingMeasurementPt
KEY Transporter Transporter Partner
KEY AllocationFrequency AllocationFrequency
DeliveryNetworkName _hdr DeliveryNetworkName
MajorProduct MajorProduct Major Product
ActlPrimStatusCritlty _hdr ActlPrimStatusCritlty
ActlPrimStatusText _hdr ActlPrimStatusText Primary Products Status
ActualVolumeStsCritlty ActualVolumeStsCritlty
BaselineActualVolume BaselineActualVolume
ActualVolume ActualVolume
VolumeUnit VolumeUnit Volume Unit
ActualHeatingValueStsCritlty ActualHeatingValueStsCritlty
BaselineActualHeatingValue BaselineActualHeatingValue
ActualHeatingValue ActualHeatingValue
HeatingValUnit HeatingValUnit
ActualEnergyStsCritlty ActualEnergyStsCritlty
BaselineActualEnergy BaselineActualEnergy
ActualEnergy ActualEnergy
EnergyUnit EnergyUnit
EntitledVolumeStsCritlty EntitledVolumeStsCritlty
BaselineEntitledVolume BaselineEntitledVolume
EntitledVolume EntitledVolume
AdjustedEntitledVolStsCritlty AdjustedEntitledVolStsCritlty
BaselineAdjustedEntitledVol BaselineAdjustedEntitledVol
AdjustedEntitledVol AdjustedEntitledVol
EntitledEnergyStsCritlty EntitledEnergyStsCritlty
BaselineEntitledEnergy BaselineEntitledEnergy
EntitledEnergy EntitledEnergy
AdjustedEntitledEngyStsCritlty AdjustedEntitledEngyStsCritlty
BaselineAdjustedEntitledEngy BaselineAdjustedEntitledEngy
AdjustedEntitledEngy AdjustedEntitledEngy

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_PRATstActlPrimProdDets.
-- 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: CPRATSTAPPD

CREATE VIEW C_PRATstActlPrimProdDets AS
SELECT
  DeliveryNetwork,
  Well,
  WellCompletion,
  Material,
  PRAContract,
  SalesDate,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  OriginatingMeasurementPt,
  Transporter,
  AllocationFrequency,
  _hdr.DeliveryNetworkName AS DeliveryNetworkName,
  MajorProduct,
  _hdr.ActlPrimStatusCritlty AS ActlPrimStatusCritlty,
  _hdr.ActlPrimStatusText AS ActlPrimStatusText,
  ActualVolumeStsCritlty,
  BaselineActualVolume,
  ActualVolume,
  VolumeUnit,
  ActualHeatingValueStsCritlty,
  BaselineActualHeatingValue,
  ActualHeatingValue,
  HeatingValUnit,
  ActualEnergyStsCritlty,
  BaselineActualEnergy,
  ActualEnergy,
  EnergyUnit,
  EntitledVolumeStsCritlty,
  BaselineEntitledVolume,
  EntitledVolume,
  AdjustedEntitledVolStsCritlty,
  BaselineAdjustedEntitledVol,
  AdjustedEntitledVol,
  EntitledEnergyStsCritlty,
  BaselineEntitledEnergy,
  EntitledEnergy,
  AdjustedEntitledEngyStsCritlty,
  BaselineAdjustedEntitledEngy,
  AdjustedEntitledEngy
FROM I_PRATstActlPrimProdCompareUI
LEFT OUTER JOIN I_PRADeliveryNetworkVH AS _DeliveryNetworkVH ON DeliveryNetwork = _DeliveryNetworkVH.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_PRAMajorProductCodeVH AS _MajorProductVH ON MajorProduct = _MajorProductVH.MajorProduct  -- association [0..1]
LEFT OUTER JOIN I_PRATstContrAllocRsltsHdr AS _hdr ON DeliveryNetwork = _hdr.DeliveryNetwork AND SalesDate = _hdr.SalesDate AND MajorProduct = _hdr.MajorProduct  -- association [1..1]
;

Learn More