A_PRAWellTP

DDL: A_PRAWELLTP Type: view_entity CONSUMPTION
32 Fields 1 Data Sources

PRA Well

A_PRAWellTP is a Consumption CDS View that provides data about "PRA Well" in SAP S/4HANA. It reads from 1 data source (R_PRAWellTP) and exposes 32 fields with key field Well.

Data Sources (1)

SourceAliasJoin Type
R_PRAWellTP R_PRAWellTP projection

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #NOT_REQUIRED view
EndUserText.label PRA Well view
OData.entityType.name PRAWell_Type view
OData.entitySet.name PRAWell view
ObjectModel.sapObjectNodeType.name PRAWell view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Metadata.ignorePropagatedAnnotations true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY Well Well Well
WellName WellName
APIWellNumber APIWellNumber
PRAWellDescription PRAWellDescription
PRAWellDrilledFlag PRAWellDrilledFlag
PRAGroundLevelElevationUnit PRAGroundLevelElevationUnit
PRAGroundLvlElevationInQty PRAGroundLvlElevationInQty
PRASlotNumber PRASlotNumber
LatitudeUnit LatitudeUnit
LongitudeUnit LongitudeUnit
PRAWellLatitudeInQuantity PRAWellLatitudeInQuantity
WellLatitudeDirection WellLatitudeDirection
PRAWellLongitudeInQuantity PRAWellLongitudeInQuantity
WellLongitudeDirection WellLongitudeDirection
PRALegalDescription PRALegalDescription
PRADrillOutDepthUnit PRADrillOutDepthUnit
PRADrillOutDepthInQuantity PRADrillOutDepthInQuantity
PRAQuarter1Number PRAQuarter1Number
PRAQuarter2Number PRAQuarter2Number
PRASectionNumber PRASectionNumber
PRATownshipNumber PRATownshipNumber
PRATownshipDirection PRATownshipDirection
PRARangeNumber PRARangeNumber
PRARangeDirection PRARangeDirection
PRATargetDepthUnit PRATargetDepthUnit
PRATargetDepthInQuantity PRATargetDepthInQuantity
ONRROwnership ONRROwnership
PRAWellNumberRangeGroup PRAWellNumberRangeGroup
PRAWellDocumentNumber PRAWellDocumentNumber
PRAWellDocumentYear PRAWellDocumentYear
CreatedByUser CreatedByUser User Name
CreationDateTime CreationDateTime Timestamp

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 A_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 A_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,
  ONRROwnership,
  PRAWellNumberRangeGroup,
  PRAWellDocumentNumber,
  PRAWellDocumentYear,
  CreatedByUser,
  CreationDateTime
FROM R_PRAWellTP
;

Learn More