I_PRAMaintVenture

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_PRAMaintVenture.
-- 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_PRAMaintVenture AS
SELECT
  bukrs AS CompanyCode,
  vname AS PRAJointVenture,
  vname_int_cd AS PRAJointVentureInterestCode,
  vname_nm AS PRAJointVentureName,
  shtxt AS PRAJointVentureDesc,
  sts_code AS PRAJointVentureStatus,
  sts_eff_dt AS PRAJointVentureStsEffctvDte,
  Country,
  pri_geo_loc AS PrimaryGeogrlLocation,
  sec_geo_loc AS SecondaryGeogrlLocation,
  acq_dt AS PRAJointVentureAcquiredDate,
  type_cd AS PRAJointVentureUsageType,
  old_vname_no AS PRAJointVentureOldLeaseID,
  unit_fl AS JointVentureIsUnit,
  doi_by_tr_fl AS PRAJointVentureHasDOIByTract,
  drl_fund_fl AS PRAJntVntrIsSubjToDrillFund,
  ons_ofs_cd AS PRAJntVntrOnshoreOffshoreCode,
  acq_from_kunnr AS PRAJointVentureAcquiredFrom,
  sld_to_kunnr AS PRAJointVentureSoldTo,
  leg_de_cmt_fl AS PRAJointVentureHasLegalDesc,
  field AS PRAFieldID,
  space_ord_no AS PRAJntVntrSpacingOrdNmbr,
  lpn_no AS PRAJntVntrLandPrptyNmbr,
  doi_prt_fl AS PRAJntVntrDOINameIsPrinted,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM oiu_do_jv
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRAVentureStatusCodeVH AS _PRAVentureStatusCodeVH ON _PRAVentureStatusCodeVH.PRAVentureStatus = PRAJointVentureStatus  -- association [1..1]
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = Country  -- association [1..1]
LEFT OUTER JOIN I_PrimaryGeogrlLocation AS _PrimaryGeogrlLocation ON _PrimaryGeogrlLocation.Country = Country AND _PrimaryGeogrlLocation.PrimaryGeogrlLocation = PrimaryGeogrlLocation  -- association [1..1]
LEFT OUTER JOIN I_SecondaryGeogrlLocation AS _Location ON Country = _Location.Country AND PrimaryGeogrlLocation = _Location.PrimaryGeogrlLocation AND SecondaryGeogrlLocation = _Location.SecondaryGeogrlLocation  -- association [1..1]
LEFT OUTER JOIN I_PRAJointVentureUsageTypeVH AS _PRAJointVentureUsageTypeVH ON _PRAJointVentureUsageTypeVH.PRAJointVentureUsageType = PRAJointVentureUsageType  -- association [1..1]
LEFT OUTER JOIN I_PRAOnshoreOffshoreCodeVH AS _PRAOnshoreOffshoreCodeVH ON _PRAOnshoreOffshoreCodeVH.PRAJntVntrOnshoreOffshoreCode = PRAJntVntrOnshoreOffshoreCode  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _AcquiredFrom ON _AcquiredFrom.Customer = PRAJointVentureAcquiredFrom  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _SoldTo ON _SoldTo.Customer = PRAJointVentureSoldTo  -- association [1..1]
LEFT OUTER JOIN I_GeologicField AS _Field ON PRAFieldID = _Field.GeologicField  -- association [1..1]
LEFT OUTER JOIN I_PRAVentureInterestCodeVH AS _PRAVentureInterestCodeVH ON PRAJointVentureInterestCode = _PRAVentureInterestCodeVH.PRAJointVentureInterestCode  -- association [1..1]
LEFT OUTER JOIN I_PRAMaintUnitVenture AS _UnitVenture ON /* condition not available in parsed metadata */  -- association [0..*]
;