I_GHOWellTestPriority

DDL: I_GHOWELLTESTPRIORITY Type: view_entity BASIC
9 Fields 1 Data Sources

Well Test Priority

I_GHOWellTestPriority is a Basic CDS View that provides data about "Well Test Priority" in SAP S/4HANA. It reads from 1 data source (gho_well_prior) and exposes 9 fields with key fields GHONetworkID, GHOWellCompletionID, GHOWellID, InspectionLot.

Data Sources (1)

SourceAliasJoin Type
gho_well_prior gho_well_prior from

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Well Test Priority view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #BASIC view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY GHONetworkID Production Flow NW
KEY GHOWellCompletionID Well Completion ID
KEY GHOWellID Well ID
KEY InspectionLot insplot Inspection lot
ValidFromDateTime start_timestamp Valid From Timestamp
ValidToDateTime end_timestamp Valid To Timestamp
EffectiveFromDateTime effective_from Valid From Timestamp
EffectiveToDateTime effective_to Valid To Timestamp
GHOWellTestCategoryID gho_meas_cat_id Measurement Category

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_GHOWellTestPriority.
-- 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_GHOWellTestPriority AS
SELECT
  cast(netid as gho_network_id preserving type ) AS GHONetworkID,
  cast(gho_wc_id as gho_ntwkobj_id preserving type ) AS GHOWellCompletionID,
  cast(gho_well_id as gho_ntwkobj_id preserving type ) AS GHOWellID,
  insplot AS InspectionLot,
  start_timestamp AS ValidFromDateTime,
  end_timestamp AS ValidToDateTime,
  effective_from AS EffectiveFromDateTime,
  effective_to AS EffectiveToDateTime,
  gho_meas_cat_id AS GHOWellTestCategoryID
FROM gho_well_prior
;

Learn More