I_ContrAllocVolPrimProd

DDL: I_CONTRALLOCVOLPRIMPROD SQL: IPVCAVOLPRIM Type: view COMPOSITE
39 Fields 1 Data Sources 13 Associations

CA Volume for Primary Products

I_ContrAllocVolPrimProd (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Production Revenue Accounting Contract Allocation Volume Primary Product · Cross Applications

I_ContrAllocVolPrimProd is a Composite CDS View (Cube) that provides data about "CA Volume for Primary Products" in SAP S/4HANA. It reads from 1 data source (P_ContrAllocVolPrimProd) and exposes 39 fields with key fields DeliveryNetwork, MeasurementPoint, Well, WellCompletion, Material. It has 13 associations to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source in SQL Select, Data Provider for Analytical Queries, Data Source for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
P_ContrAllocVolPrimProd P_ContrAllocVolPrimProd from

Associations (13)

CardinalityTargetAliasCondition
[0..1] I_DeliveryNetwork _DeliveryNetwork $projection.DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork
[0..1] I_MeasurementPoint _MeasurementPoint $projection.MeasurementPoint = _MeasurementPoint.MeasurementPoint
[0..1] I_Well _Well $projection.Well = _Well.Well
[0..1] I_WellCompletion _WellCompletion $projection.Well = _WellCompletion.Well and $projection.WellCompletion = _WellCompletion.WellCompletion
[0..1] I_Material _Material $projection.Material = _Material.Material
[0..1] I_PRAContract _PRAContract $projection.PRAContract = _PRAContract.PRAContract
[0..1] I_PRAOwner _PRAOwner $projection.PRAOwner = _PRAOwner.PRAOwner
[0..1] I_OwnerInterestType _OwnerInterestType $projection.OwnerInterestType = _OwnerInterestType.OwnerInterestType
[0..1] I_MeasurementPoint _OriginatingMeasurementPt $projection.OriginatingMeasurementPt = _OriginatingMeasurementPt.MeasurementPoint
[0..1] I_Customer _Transporter $projection.Transporter = _Transporter.Customer
[0..1] I_UnitOfMeasure _VolumeUnit $projection.VolumeUnit = _VolumeUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _HeatingValUnit $projection.HeatingValUnit = _HeatingValUnit.UnitOfMeasure
[0..1] I_UnitOfMeasure _EnergyUnit $projection.EnergyUnit = _EnergyUnit.UnitOfMeasure

Annotations (14)

NameValueLevelField
EndUserText.label CA Volume for Primary Products view
Analytics.dataCategory #CUBE view
Metadata.allowExtensions true view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
AbapCatalog.sqlViewName IPVCAVOLPRIM view
AccessControl.authorizationCheck #CHECK view
ObjectModel.modelingPattern #ANALYTICAL_CUBE view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name PRAContrAllocVolPrimProd view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY DeliveryNetwork DeliveryNetwork Delivery network number
KEY MeasurementPoint MeasurementPoint Measurement point number
KEY Well Well Well ID number
KEY WellCompletion WellCompletion Well Completion Number
KEY Material Material Material Number
KEY PRAContract PRAContract Contract Number
KEY SalesDate SalesDate Sales Date
KEY PRAOwner PRAOwner PRA owner
KEY OwnerInterestType OwnerInterestType Participant Interest Type
KEY OwnerInterestSequence OwnerInterestSequence Owner Interest Sequence Number
KEY OriginatingMeasurementPt OriginatingMeasurementPt Original measurement point number
KEY Transporter Transporter Transporter number
OriginTransaction OriginTransaction Source Transaction ID
CreatedByUser CreatedByUser Created By
CreationDateTime CreationDateTime Created On Timestamp
VolumeUnit VolumeUnit Actual Volume Units
HeatingValUnit HeatingValUnit Heating Value Unit
EnergyUnit EnergyUnit Actual Energy Unit
WetGasOverridePct WetGasOverridePct Wet Gas Override Percent
ActualVolume ActualVolume Actual Volume
HeatingValue HeatingValue Heating value
ActualEnergy ActualEnergy Actual Energy
EntitledVolume EntitledVolume Entitled Contract Volume
EntitledEnergy EntitledEnergy Entitled Contract Energy
AdjustedEntitledVol AdjustedEntitledVol Adjusted Entitled Contract Volume
AdjustedEntitledEngy AdjustedEntitledEngy Adjusted Entitled Contract Energy
_DeliveryNetwork _DeliveryNetwork
_MeasurementPoint _MeasurementPoint
_Well _Well
_WellCompletion _WellCompletion
_Material _Material
_PRAContract _PRAContract
_PRAOwner _PRAOwner
_OwnerInterestType _OwnerInterestType
_OriginatingMeasurementPt _OriginatingMeasurementPt
_Transporter _Transporter
_VolumeUnit _VolumeUnit
_HeatingValUnit _HeatingValUnit
_EnergyUnit _EnergyUnit

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_ContrAllocVolPrimProd.
-- 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: IPVCAVOLPRIM

CREATE VIEW I_ContrAllocVolPrimProd AS
SELECT
  DeliveryNetwork,
  MeasurementPoint,
  Well,
  WellCompletion,
  Material,
  PRAContract,
  SalesDate,
  PRAOwner,
  OwnerInterestType,
  OwnerInterestSequence,
  OriginatingMeasurementPt,
  Transporter,
  OriginTransaction,
  CreatedByUser,
  CreationDateTime,
  VolumeUnit,
  HeatingValUnit,
  EnergyUnit,
  WetGasOverridePct,
  ActualVolume,
  HeatingValue,
  ActualEnergy,
  EntitledVolume,
  EntitledEnergy,
  AdjustedEntitledVol,
  AdjustedEntitledEngy
FROM P_ContrAllocVolPrimProd
LEFT OUTER JOIN I_DeliveryNetwork AS _DeliveryNetwork ON DeliveryNetwork = _DeliveryNetwork.DeliveryNetwork  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _MeasurementPoint ON MeasurementPoint = _MeasurementPoint.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_Well AS _Well ON Well = _Well.Well  -- association [0..1]
LEFT OUTER JOIN I_WellCompletion AS _WellCompletion ON Well = _WellCompletion.Well AND WellCompletion = _WellCompletion.WellCompletion  -- association [0..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_PRAContract AS _PRAContract ON PRAContract = _PRAContract.PRAContract  -- association [0..1]
LEFT OUTER JOIN I_PRAOwner AS _PRAOwner ON PRAOwner = _PRAOwner.PRAOwner  -- association [0..1]
LEFT OUTER JOIN I_OwnerInterestType AS _OwnerInterestType ON OwnerInterestType = _OwnerInterestType.OwnerInterestType  -- association [0..1]
LEFT OUTER JOIN I_MeasurementPoint AS _OriginatingMeasurementPt ON OriginatingMeasurementPt = _OriginatingMeasurementPt.MeasurementPoint  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Transporter ON Transporter = _Transporter.Customer  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _VolumeUnit ON VolumeUnit = _VolumeUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _HeatingValUnit ON HeatingValUnit = _HeatingValUnit.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _EnergyUnit ON EnergyUnit = _EnergyUnit.UnitOfMeasure  -- association [0..1]
;

Learn More