I_PRAMaintDOIOwner

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_PRAMaintDOIOwner.
-- 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_PRAMaintDOIOwner AS
SELECT
  bukrs AS CompanyCode,
  vname AS PRAJointVenture,
  doi_no AS DivisionOfInterest,
  cust_vend_cd AS PRACustomerSupplierCode,
  own_no AS PRAOwner,
  own_int_type_cd AS OwnerInterestType,
  own_isq_no AS OwnerInterestSequence,
  eff_from_dt AS DOIOwnerEffectiveFromDate,
  eff_to_dt AS DOIOwnerEffectiveToDate,
  do_no AS PRADivisionOfInterestNmbr,
  jib_offs_fl AS OwnerIsJntIntrstBilgEnabled,
  nri_pc AS NetRevenueInterestRatio,
  susp_cd AS SuspenseReason,
  tax_free_cd AS TaxBasis,
  bg_no AS PRABearerGroup,
  pyout_cd AS PRAPayoutCode,
  pay_cd AS OwnerPaymentStatus,
  entl_cd AS PRAEntitlementCode,
  ssc_fl AS DOIOwnerIsSlidingScEnbld,
  mms_pop_comp_fl AS DOIOwnerIsPctOfProceedsEnbld,
  dual_acct_fl AS DOIOwnerIsDualAcctgEnbld,
  enty_cd AS PRALegalForm,
  acct_ent_fl AS DOIOwnerHasAcctgEntrOvrrde,
  int_cat_cd AS OwnerInterestCategory,
  min_roy_dt AS DOIOwnerMinRoyaltyDate,
  do_curr AS CompanyCodeCurrency,
  min_roy_am AS DOIOwnerMinRoyaltyAmount,
  adv_arrs_cd AS DOIOwnerAdvncArrearsPaytCode,
  carr_bg_cd AS DOIOwnerCarriedBearerGrpCode,
  lse_use_pmt_cd AS DOIOwnerLeaseUsePaytCode,
  jib_partn AS JntIntrstBilgPartner,
  pp_kunnr AS DOIOwnerProdnPaytOwner,
  mms_recon_fl AS DOIOwnrHasTakeInKindContrExprd,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime,
  set_div AS DOIOwnerHasSettlmtDiversity,
  lease_id AS DOIOwnerLeaseID,
  net_mineral_acres AS DOIOwnerNetMineralAcresVal,
  gri_pc AS GrossRevenueInterestRatio,
  oag_id AS OwnerAttributeGroup,
  dsd_instr AS DynSettlmtDiversityInstrn,
  rt_bg_no AS DOIOwnerRecdTitleBearerGrp,
  _PRAMaintDOI.PRACombinedProductCode AS PRACombinedProductCode
FROM oiu_do_do
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRAJointVenture AS _PRAJointVenture ON _PRAJointVenture.PRAJointVenture = PRAJointVenture AND _PRAJointVenture.CompanyCode = CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRACustomerSupplierCodeVH AS _PRACustomerSupplierCodeVH ON PRACustomerSupplierCode = _PRACustomerSupplierCodeVH.PRACustomerSupplierCode  -- association [1..1]
LEFT OUTER JOIN I_PRAOwner AS _PRAOwner ON PRAOwner = _PRAOwner.PRAOwner  -- association [0..1]
LEFT OUTER JOIN I_OwnerInterestType AS _OwnerInterestType ON OwnerInterestType = _OwnerInterestType.OwnerInterestType  -- association [1..1]
LEFT OUTER JOIN I_SuspenseReason AS _SuspenseReason ON SuspenseReason = _SuspenseReason.SuspenseReason  -- association [1..1]
LEFT OUTER JOIN I_TaxBasis AS _TaxBasis ON TaxBasis = _TaxBasis.TaxBasis  -- association [1..1]
LEFT OUTER JOIN I_PRAPayOutCodeVH AS _PRAPayOutCodeVH ON PRAPayoutCode = _PRAPayOutCodeVH.PRAPayoutCode  -- association [1..1]
LEFT OUTER JOIN I_OwnerPaymentStatus AS _OwnerPaymentStatus ON OwnerPaymentStatus = _OwnerPaymentStatus.OwnerPaymentStatus  -- association [1..1]
LEFT OUTER JOIN I_PRAEntitlementCodeVH AS _PRAEntitlementCodeVH ON PRAEntitlementCode = _PRAEntitlementCodeVH.PRAEntitlementCode  -- association [1..1]
LEFT OUTER JOIN I_PRALegalForm AS _PRALegalForm ON PRALegalForm = _PRALegalForm.PRALegalForm  -- association [1..1]
LEFT OUTER JOIN I_OwnerInterestCategory AS _OwnerInterestCategory ON OwnerInterestCategory = _OwnerInterestCategory.OwnerInterestCategory  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON CompanyCodeCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_OwnrAdvncArrearsPaytCodeVH AS _OwnrAdvncArrearsPaytCodeVH ON DOIOwnerAdvncArrearsPaytCode = _OwnrAdvncArrearsPaytCodeVH.DOIOwnerAdvncArrearsPaytCode  -- association [1..1]
LEFT OUTER JOIN I_PRAPayOnLeaseUseFuelCodeVH AS _PayOnLeaseUseFuelCodeVH ON DOIOwnerLeaseUsePaytCode = _PayOnLeaseUseFuelCodeVH.DOIOwnerLeaseUsePaytCode  -- association [1..1]
LEFT OUTER JOIN I_PRAMaintCmbndProdCode AS _PRAMaintCmbndProdCode ON _PRAMaintDOI.PRACombinedProductCode = _PRAMaintCmbndProdCode.PRACombinedProductCode  -- association [1..1]
LEFT OUTER JOIN I_OwnerAttributeGroup AS _OwnerAttributeGroup ON OwnerAttributeGroup = _OwnerAttributeGroup.OwnerAttributeGroup  -- association [0..*]
LEFT OUTER JOIN I_PRADivisionOrderLease AS _PRADivisionOrderLease ON DOIOwnerLeaseID = _PRADivisionOrderLease.DOIOwnerLeaseID  -- association [0..1]
LEFT OUTER JOIN I_DivisionOfInterest AS _DivisionOfInterest ON CompanyCode = _DivisionOfInterest.CompanyCode AND PRAJointVenture = _DivisionOfInterest.JointVenture AND DivisionOfInterest = _DivisionOfInterest.DivisionOfInterest  -- association [1..1]
LEFT OUTER JOIN I_PRAMaintMarketingExempt AS _PRAMaintMarketingExempt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_PRAMaintStateTaxExempt AS _PRAMaintStateTaxExempt ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_PRAMaintSlidingScaleHdr AS _PRAMaintSlidingScaleHdr ON /* condition not available in parsed metadata */  -- association [0..*]
;