What is I_PRAMsmtPtContrVolOilDet in SAP S/4HANA?

I_PRAMsmtPtContrVolOilDet is a basic CDS view in SAP S/4HANA. Contract Volumes by Measurement Point It contains 14 fields.

Which tables does I_PRAMsmtPtContrVolOilDet read from?

I_PRAMsmtPtContrVolOilDet reads data from: oiu_sb_campod.

What VDM layer is I_PRAMsmtPtContrVolOilDet?

I_PRAMsmtPtContrVolOilDet is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_PRAMsmtPtContrVolOilDet

DDL: I_PRAMSMTPTCONTRVOLOILDET Type: view_entity BASIC

14 Fields 1 Data Sources 2 Associations

Contract Volumes by Measurement Point

I_PRAMsmtPtContrVolOilDet (Basic)

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

PRAMsmtPtContrVolOilDet · Cross Applications

I_PRAMsmtPtContrVolOilDet is a Basic CDS View that provides data about "Contract Volumes by Measurement Point" in SAP S/4HANA. It reads from 1 data source (oiu_sb_campod) and exposes 14 fields with key fields PRAContrVolByMsmtPointNumber, PRAContract. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Production and Revenue Accounting (PRA)

Purpose
This CDS view represents the oil volumes for primary products that would be allocated by Contractual Allocation (CA) Sales Point Originated (SPO) method.

Prerequisites
Authorizations Users who want to use this CDS view must have the following authorization objects assigned: O_OIU_TXN:ACTVT-03,O_OIU_TXN:OIU_TCODE-O3U_CA053 (Mapping role for I_PRAMsmtPtContrVolOilDet )

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Cross Applications
Application Component	IS-OIL-PRA
Capabilities	Data Source in SQL Select
Package	Cross Applications for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view represents the oil volumes for primary products that would be allocated by Contractual Allocation (CA) Sales Point Originated (SPO) method. </p>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
oiu_sb_campod	oiu_sb_campod	from

Associations (2)

Cardinality	Target	Alias	Condition
[1..1]	I_PRAContract	_PRAContract	`$projection.PRAContract = _PRAContract.PRAContract`
[0..1]	I_UnitOfMeasure	_ContractVolumeUnitOfMeasure	`$projection.PRAQuantityUnitOfMeasure = _ContractVolumeUnitOfMeasure.UnitOfMeasure`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	Contract Volumes by Measurement Point	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#BASIC	view
ObjectModel.sapObjectNodeType.name	PRAMsmtPtContrVolOilDet	view

Fields (14)

Key	Field	Source Field	Description
KEY	PRAContrVolByMsmtPointNumber	camph_no	Contract volumes by measurement point number
KEY	PRAContract	ct_no	Contract Number
	PRAQuantityUnitOfMeasure	qy_u	Unit of Measure
	AllocationPercent	alloc_pc	Allocation Percentage
	PRAMktgRprstvImbalanceValue	mk_rep_imb_vol	Marketing representative imbalance (Volumetric or Energy)
	PRAAllocationVolume	alloc_vol	Allocated volume
	PRAPhseOneAllocVolQuantity	phase_1_vol	Phase One Allocation Energy Quantity
	PRAPhseTwoAllocVolQuantity	phase_2_vol	Phase Two Allocation Energy Quantity
	PRAPhseThreeAllocVolQuantity	phase_3_vol	Phase Three Allocation Energy Quantity
	PRAImbalanceMakeupQuantity	imb_mkup_vol	Imbalance Makeup (Volumetric or Energy)
	CreatedByUser	oiu_cruser	Name of Person Responsible for Creating the Object
	CreationDateTime	oiu_timestamp	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	_ContractVolumeUnitOfMeasure	_ContractVolumeUnitOfMeasure
	_PRAContract	_PRAContract

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_PRAMsmtPtContrVolOilDet.
-- 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.

CREATE VIEW I_PRAMsmtPtContrVolOilDet AS
SELECT
  camph_no AS PRAContrVolByMsmtPointNumber,
  ct_no AS PRAContract,
  qy_u AS PRAQuantityUnitOfMeasure,
  alloc_pc AS AllocationPercent,
  mk_rep_imb_vol AS PRAMktgRprstvImbalanceValue,
  alloc_vol AS PRAAllocationVolume,
  phase_1_vol AS PRAPhseOneAllocVolQuantity,
  phase_2_vol AS PRAPhseTwoAllocVolQuantity,
  phase_3_vol AS PRAPhseThreeAllocVolQuantity,
  imb_mkup_vol AS PRAImbalanceMakeupQuantity,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM oiu_sb_campod
LEFT OUTER JOIN I_PRAContract AS _PRAContract ON PRAContract = _PRAContract.PRAContract  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _ContractVolumeUnitOfMeasure ON PRAQuantityUnitOfMeasure = _ContractVolumeUnitOfMeasure.UnitOfMeasure  -- association [0..1]
;

Depth:

I_PRAMsmtPtContrVolOilDet view_entity

oiu_sb_campod

I_PRAContrVolBySlsPtDetail view_entity