A_PRAWellTestHdr

DDL: A_PRAWELLTESTHDR Type: view_entity CONSUMPTION Package: OIU_ODATA_PRD_VOL
37 Fields 1 Data Sources 1 OData Services

PRA Well Test

A_PRAWellTestHdr is a Consumption CDS View that provides data about "PRA Well Test" in SAP S/4HANA. It reads from 1 data source (R_PRAWellTestHdrTP) and exposes 37 fields with key fields PRAWellTestNumber, PRAWellTestDocYear. It is exposed through 1 OData service (API_PRAWELLTESTHDR). Part of development package OIU_ODATA_PRD_VOL.

Data Sources (1)

SourceAliasJoin Type
R_PRAWellTestHdrTP R_PRAWellTestHdrTP projection

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label PRA Well Test view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.contract.type #PUBLIC_REMOTE_API view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
OData.entityType.name WellTest_Type view
OData.entitySet.name WellTest view

OData Services (1)

ServiceBindingVersionContractRelease
API_PRAWELLTESTHDR API_PRAWELLTEST V4 C2 C1

Fields (37)

KeyFieldSource TableSource FieldDescription
KEY PRAWellTestNumber PRAWellTestNumber
KEY PRAWellTestDocYear PRAWellTestDocYear
Well Well Well
WellCompletion WellCompletion Well Completion
PRAWellTestDateTime PRAWellTestDateTime
PRAStreamTypeCode PRAStreamTypeCode
PRATestTypeCode PRATestTypeCode
PRAIsAllocated PRAIsAllocated
PRAOilCondensateUnit PRAOilCondensateUnit
PRAOilCondensateQuantity PRAOilCondensateQuantity
PRAWaterUnit PRAWaterUnit
PRAWaterQuantity PRAWaterQuantity
PRADurationHours PRADurationHours
PRADurationMinutes PRADurationMinutes
HeatingValUnit HeatingValUnit
HeatingValue HeatingValue
PRAGasLiftGasUnit PRAGasLiftGasUnit
PRAGasLiftGasQuantity PRAGasLiftGasQuantity
PRAGasUnit PRAGasUnit
PRAGasQuantity PRAGasQuantity
PRANetGasUnit PRANetGasUnit
PRANetGasQuantity PRANetGasQuantity
PRANitrogenGasPercent PRANitrogenGasPercent
PRACarbon2OxidePct PRACarbon2OxidePct
PRAPercentUnit PRAPercentUnit
PRAChokeSize PRAChokeSize
PRAChokeSizeUnit PRAChokeSizeUnit
PRAFlowPressureUnit PRAFlowPressureUnit
PRAFlowPressure PRAFlowPressure
PRATemperatureUnit PRATemperatureUnit
PRAWellTestTemperature PRAWellTestTemperature
PRADensityAtStdBaseCndnUnit PRADensityAtStdBaseCndnUnit
PRADensityAtStdBaseCndnQty PRADensityAtStdBaseCndnQty
PRADensityType PRADensityType
CreatedByUser CreatedByUser User Name
PRACreationDateTime PRACreationDateTime Time Stamp
OriginTransaction OriginTransaction

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_PRAWellTestHdr.
-- 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_PRAWellTestHdr AS
SELECT
  PRAWellTestNumber,
  PRAWellTestDocYear,
  Well,
  WellCompletion,
  PRAWellTestDateTime,
  PRAStreamTypeCode,
  PRATestTypeCode,
  PRAIsAllocated,
  PRAOilCondensateUnit,
  PRAOilCondensateQuantity,
  PRAWaterUnit,
  PRAWaterQuantity,
  PRADurationHours,
  PRADurationMinutes,
  HeatingValUnit,
  HeatingValue,
  PRAGasLiftGasUnit,
  PRAGasLiftGasQuantity,
  PRAGasUnit,
  PRAGasQuantity,
  PRANetGasUnit,
  PRANetGasQuantity,
  PRANitrogenGasPercent,
  PRACarbon2OxidePct,
  PRAPercentUnit,
  PRAChokeSize,
  PRAChokeSizeUnit,
  PRAFlowPressureUnit,
  PRAFlowPressure,
  PRATemperatureUnit,
  PRAWellTestTemperature,
  PRADensityAtStdBaseCndnUnit,
  PRADensityAtStdBaseCndnQty,
  PRADensityType,
  CreatedByUser,
  PRACreationDateTime,
  OriginTransaction
FROM R_PRAWellTestHdrTP
;

Learn More