UPOV_WCDWN_HOURS

DDL: UPO_INT_V_WCDWN_HOURS SQL: UPOS_WCDWN_HOURS Type: view
4 Fields 1 Data Sources

Well Completion Downtime

UPOV_WCDWN_HOURS is a CDS View that provides data about "Well Completion Downtime" in SAP S/4HANA. It reads from 1 data source (UPOV_WCDWN_DETAILS) and exposes 4 fields.

Data Sources (1)

SourceAliasJoin Type
UPOV_WCDWN_DETAILS event from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName UPOS_WCDWN_HOURS view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Well Completion Downtime view

Fields (4)

KeyFieldSource TableSource FieldDescription
EventID UPOV_WCDWN_DETAILS EventID Event ID for B4H Transfer
strt_period UPOV_WCDWN_DETAILS strt_period Start Period
end_period UPOV_WCDWN_DETAILS end_period Result End Period
dec52asoiu_hrsendasHrs

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 UPOV_WCDWN_HOURS.
-- 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: UPOS_WCDWN_HOURS

CREATE VIEW UPOV_WCDWN_HOURS AS
SELECT
  event.EventID AS EventID,
  event.strt_period AS strt_period,
  event.end_period AS end_period,
  case when event.DiffSec <= 3596400 then event.eventTime else cast(cast('999' as abap.dec( 5, 2 ))as oiu_hrs) end as Hrs AS dec52asoiu_hrsendasHrs
FROM UPOV_WCDWN_DETAILS AS event
;

Learn More