R_PRAWellTP

DDL: R_PRAWELLTP Type: view_entity TRANSACTIONAL
39 Fields 1 Data Sources 1 Associations

PRA Well - TP

R_PRAWellTP is a Transactional CDS View that provides data about "PRA Well - TP" in SAP S/4HANA. It reads from 1 data source (I_PRAWell) and exposes 39 fields with key field Well. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_PRAWell I_PRAWell from

Associations (1)

CardinalityTargetAliasCondition
[1..*] R_PRAWellMsmtDocumentItemTP _PRAWellMsmtDocumentItem

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label PRA Well - TP view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #TRANSACTIONAL view
ObjectModel.sapObjectNodeType.name PRAWell view

Fields (39)

KeyFieldSource TableSource FieldDescription
KEY Well Well Well
WellName WellName
APIWellNumber APIWellNumber
PRAWellDescription PRAWellDescription Unit
PRAWellDrilledFlag PRAWellDrilledFlag Well drilled
PRAGroundLevelElevationUnit PRAGroundLevelElevationUnit GLE unit
PRAGroundLvlElevationInQty PRAGroundLvlElevationInQty GL elevation
PRASlotNumber PRASlotNumber Slot Number
LatitudeUnit LatitudeUnit
LongitudeUnit LongitudeUnit
PRAWellLatitudeInQuantity PRAWellLatitudeInQuantity Latitude
WellLatitudeDirection WellLatitudeDirection Latitude Dir.
PRAWellLongitudeInQuantity PRAWellLongitudeInQuantity Longitude
WellLongitudeDirection WellLongitudeDirection Longitude Dir.
PRALegalDescription PRALegalDescription Legal Desc.
PRADrillOutDepthUnit PRADrillOutDepthUnit DO depth unit
PRADrillOutDepthInQuantity PRADrillOutDepthInQuantity Drill-out depth
PRAQuarter1Number PRAQuarter1Number Qtr 1
PRAQuarter2Number PRAQuarter2Number Qtr 2
PRASectionNumber PRASectionNumber Section
PRATownshipNumber PRATownshipNumber Township
PRATownshipDirection PRATownshipDirection Township dir.
PRARangeNumber PRARangeNumber Range
PRARangeDirection PRARangeDirection Range Direction
PRATargetDepthUnit PRATargetDepthUnit TD unit
PRATargetDepthInQuantity PRATargetDepthInQuantity Target depth
ONRROwnership MMS Ownership
PRAWellNumberRangeGroup PRAWellNumberRangeGroup WL Number Group
PRAWellDocumentNumber PRAWellDocumentNumber Well doc.no.
PRAWellDocumentYear PRAWellDocumentYear Year
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp
_DrillOutDepthUnit _DrillOutDepthUnit
_TargetDepthUnit _TargetDepthUnit
_GroundLevelElevationUnit _GroundLevelElevationUnit
_LatitudeUnit _LatitudeUnit
_LongitudeUnit _LongitudeUnit
_PRAWellDeviation _PRAWellDeviation
_PRAWellMsmtDocumentItem _PRAWellMsmtDocumentItem

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 R_PRAWellTP.
-- 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 R_PRAWellTP AS
SELECT
  Well,
  WellName,
  APIWellNumber,
  PRAWellDescription,
  PRAWellDrilledFlag,
  PRAGroundLevelElevationUnit,
  PRAGroundLvlElevationInQty,
  PRASlotNumber,
  LatitudeUnit,
  LongitudeUnit,
  PRAWellLatitudeInQuantity,
  WellLatitudeDirection,
  PRAWellLongitudeInQuantity,
  WellLongitudeDirection,
  PRALegalDescription,
  PRADrillOutDepthUnit,
  PRADrillOutDepthInQuantity,
  PRAQuarter1Number,
  PRAQuarter2Number,
  PRASectionNumber,
  PRATownshipNumber,
  PRATownshipDirection,
  PRARangeNumber,
  PRARangeDirection,
  PRATargetDepthUnit,
  PRATargetDepthInQuantity,
  cast ( ONRROwnership as char1 ) AS ONRROwnership,
  PRAWellNumberRangeGroup,
  PRAWellDocumentNumber,
  PRAWellDocumentYear,
  CreatedByUser,
  CreationDateTime
FROM I_PRAWell
LEFT OUTER JOIN R_PRAWellMsmtDocumentItemTP AS _PRAWellMsmtDocumentItem ON /* condition not available in parsed metadata */  -- association [1..*]
;

Learn More