What is I_PRADelivNtwkNodeWellCompltn in SAP S/4HANA?

I_PRADelivNtwkNodeWellCompltn is a basic CDS view in SAP S/4HANA. WellCompletion node Delivery Network It contains 5 fields.

Which tables does I_PRADelivNtwkNodeWellCompltn read from?

I_PRADelivNtwkNodeWellCompltn reads data from: oiu_pr_node_wc.

What VDM layer is I_PRADelivNtwkNodeWellCompltn?

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

I_PRADelivNtwkNodeWellCompltn

DDL: I_PRADELIVNTWKNODEWELLCOMPLTN Type: view_entity BASIC

5 Fields 1 Data Sources 2 Associations

WellCompletion node Delivery Network

I_PRADelivNtwkNodeWellCompltn (Basic)

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

PRADelivNtwkNodeWellCompltn · Cross Applications

I_PRADelivNtwkNodeWellCompltn is a Basic CDS View that provides data about "WellCompletion node Delivery Network" in SAP S/4HANA. It reads from 1 data source (oiu_pr_node_wc) and exposes 5 fields with key field PRADeliveryNetworkNodeNumber. It has 2 associations to related views.

SAP Help Documentation

Category	CDS Views for Production and Revenue Accounting (PRA)

Purpose
This CDS view is a well completion node. It is an identifier number in the Delivery Network Downstream node structure.

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_DNND3 (Mapping role for I_PRADelivNtwkNodeWellCompltn )

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 is a well completion node. It is an identifier number in the Delivery Network Downstream node structure. </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_pr_node_wc	oiu_pr_node_wc	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..1]	I_Well	_Well	`$projection.Well = _Well.Well`
[0..1]	I_WellCompletion	_WellCompletion	`$projection.Well = _WellCompletion.Well and $projection.WellCompletion = _WellCompletion.WellCompletion`

Annotations (9)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
EndUserText.label	WellCompletion node Delivery Network	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#S	view
ObjectModel.usageType.dataClass	#MASTER	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#BASIC	view
ObjectModel.sapObjectNodeType.name	PRADelivNtwkNodeWellCompltn	view

Fields (5)

Key	Field	Source Field	Description
KEY	PRADeliveryNetworkNodeNumber	node_no	Delivery Network Node Number
	Well	wl_no	Well ID number
	WellCompletion	wc_no	Well Completion Number
	_Well	_Well
	_WellCompletion	_WellCompletion

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_PRADelivNtwkNodeWellCompltn.
-- 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_PRADelivNtwkNodeWellCompltn AS
SELECT
  node_no AS PRADeliveryNetworkNodeNumber,
  wl_no AS Well,
  wc_no AS WellCompletion
FROM oiu_pr_node_wc
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]
;

Depth:

I_PRADelivNtwkNodeWellCompltn view_entity

oiu_pr_node_wc