I_Well

DDL: I_WELL SQL: IPVWELL Type: view BASIC Package: OIU_VDM_CDS
11 Fields 1 Data Sources 2 OData Services

Well

I_Well (Basic)

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

Production Revenue Accounting Well · Cross Applications

I_Well is a Basic CDS View (Dimension) that provides data about "Well" in SAP S/4HANA. It reads from 1 data source (oiu_pr_well) and exposes 11 fields with key field Well. It is exposed through 2 OData services (UI_INTERESTDETAILSDATAMANAGE, UI_INTRSTOWNRDETSDATAMANAGE). Part of development package OIU_VDM_CDS.

SAP API Hub

CategoryBasic
StateC1
Line of BusinessCross Applications
Application ComponentIS-OIL-PRA
CapabilitiesData Source for Data Extraction,Data Source in SQL Select,Analytical Dimension,Association Target for Defining CDS Entities,Data Source for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageCross Applications for SAP S/4HANA Cloud Public Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
oiu_pr_well oiu_pr_well from

Annotations (16)

NameValueLevelField
EndUserText.label Well view
Analytics.dataCategory #DIMENSION view
Metadata.allowExtensions true view
Analytics.dataExtraction.enabled true view
VDM.viewType #BASIC view
AbapCatalog.sqlViewName IPVWELL view
AccessControl.authorizationCheck #CHECK view
ObjectModel.representativeKey Well view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.sapObjectNodeType.name PRAWell view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

OData Services (2)

ServiceBindingVersionContractRelease
UI_INTERESTDETAILSDATAMANAGE UI_INTRSTDETAILSDATAMANAGE V2 C1 NOT_RELEASED
UI_INTRSTOWNRDETSDATAMANAGE UI_INTRSTOWNRDETSMANAGE V2 C1 NOT_RELEASED

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY Well wl_no Well ID number
WellName Well Description
APIWellNumber Roy 2.0 CO - Well API Number
LatitudeUnit Unit of Measure
LongitudeUnit Unit of Measure
WellLatitude sur_lat_no Surface Latitude
WellLatitudeDirection sur_lat_d_cd Surface latitude Direction
WellLongitude sur_lng_no Surface longitude
WellLongitudeDirection sur_lng_d_cd Surface longitude direction code
CreatedByUser Created By
CreationDateTime Created On 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 I_Well.
-- 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.
-- SQL view name: IPVWELL

CREATE VIEW I_Well AS
SELECT
  wl_no AS Well,
  cast (wl_de as oiu_wl_de preserving type) AS WellName,
  cast (api_no as oiuya_co_wlapi preserving type) AS APIWellNumber,
  cast ( 'DEG' as oiu_uom ) AS LatitudeUnit,
  cast ( 'DEG' as oiu_uom ) AS LongitudeUnit,
  sur_lat_no AS WellLatitude,
  sur_lat_d_cd AS WellLatitudeDirection,
  sur_lng_no AS WellLongitude,
  sur_lng_d_cd AS WellLongitudeDirection,
  cast( oiu_cruser as fclm_bam_created_by ) AS CreatedByUser,
  cast( oiu_timestamp as oiu_vdm_created_on_ts ) AS CreationDateTime
FROM oiu_pr_well
;

Learn More