I_PRAWellCompletionDated

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_PRAWellCompletionDated.
-- 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_PRAWellCompletionDated AS
SELECT
  wl_no AS Well,
  wc_no AS WellCompletion,
  eff_from_dt AS EffectiveFromDate,
  eff_to_dt AS EffectiveToDate,
  hvcls AS HeatingValueClass,
  crud_type_cd AS PRACrudeTypeCode,
  op_fl AS NetworkIsOperated,
  contn_fl AS CycleIsContinuous,
  wl_count AS PRAWellCount,
  prd_mth_cd AS ProducingMethod,
  wl_class_cd AS PRAWellClassCode,
  bukrs AS CompanyCode,
  cost_center AS CostCenter,
  Operator,
  status_cd AS PRAWellCompltnStatus,
  cast ( pspnr as ps_s4_pspnr preserving type ) AS PRAWellCompletionWBSIdentifier,
  cast ( _WBSElement.WBSElement as ps_s4_posid preserving type ) AS PRAWellCompletionWBSElement,
  ext_loss_pc AS PRAExternalLossPercent,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM oiu_pr_wcvd
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [0..1]
LEFT OUTER JOIN I_PRACrudeType AS _CrudeType ON PRACrudeTypeCode = _CrudeType.PRACrudeTypeCode  -- association [0..1]
LEFT OUTER JOIN I_PRACalorificValueClassVH AS _HeatingValueClass ON HeatingValueClass = _HeatingValueClass.PRACalorificValueClass  -- association [0..1]
LEFT OUTER JOIN I_Indicator AS _NetworkIsOperated ON NetworkIsOperated = _NetworkIsOperated.IndicatorValue  -- association [0..1]
LEFT OUTER JOIN I_Customer AS _Operator ON Operator = _Operator.Customer  -- association [0..1]
LEFT OUTER JOIN I_PRAProducingMethodCodeVH AS _ProducingMethodCode ON ProducingMethod = _ProducingMethodCode.ProducingMethod  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON PRAWellCompletionWBSIdentifier = _WBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_PRAWellClassCodeVH AS _WellClassCode ON PRAWellClassCode = _WellClassCode.PRAWellClassCode  -- association [0..1]
LEFT OUTER JOIN I_PRAWell AS _Well ON Well = _Well.Well  -- association [1..1]
LEFT OUTER JOIN I_PRAWellCompletion AS _WellCompletion ON Well = _WellCompletion.Well AND WellCompletion = _WellCompletion.WellCompletion  -- association [1..1]
LEFT OUTER JOIN I_PRAWellCompletionStatusVH AS _WellCompletionStatus ON PRAWellCompltnStatus = _WellCompletionStatus.PRAWellCompltnStatus  -- association [0..1]
;