I_PRADivnOfIntrstOwner

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_PRADivnOfIntrstOwner.
-- 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_PRADivnOfIntrstOwner 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,
  _PRAOwner.PRAOwnerFullName AS PRAOwnerFullName,
  _PRAJointVenture.PRAJointVentureName AS PRAJointVentureName,
  _PRAJointVenture.Country AS Country,
  _PRAJointVenture.PrimaryGeogrlLocation AS PrimaryGeogrlLocation,
  _PRAJointVenture.SecondaryGeogrlLocation AS SecondaryGeogrlLocation,
  _DivisionOfInterest.DivisionOfInterestName AS DivisionOfInterestName,
  eff_to_dt AS DOIOwnerEffectiveToDate,
  do_no AS PRADivisionOfInterestNmbr,
  jib_offs_fl AS OwnerIsJntIntrstBilgEnabled,
  nri_pc AS NetRevenueInterestRatio,
  susp_cd AS SuspenseReason,
  _SuspenseReason.SuspenseReasonName AS SuspenseReasonName,
  tax_free_cd AS TaxBasis,
  _TaxBasis.TaxBasisName AS TaxBasisName,
  bg_no AS PRABearerGroup,
  pyout_cd AS PRAPayoutCode,
  pay_cd AS OwnerPaymentStatus,
  _OwnerPaymentStatus.OwnerPaymentStatusName AS OwnerPaymentStatusName,
  entl_cd AS PRAEntitlementCode,
  ssc_fl AS DOIOwnerIsSlidingScEnbld,
  mms_pop_comp_fl AS DOIOwnerIsPctOfProceedsEnbld,
  dual_acct_fl AS DOIOwnerIsDualAcctgEnbld,
  enty_cd AS PRALegalForm,
  _PRALegalForm.PRALegalFormName AS PRALegalFormName,
  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
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 CompanyCode = _PRAJointVenture.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_PRACustomerSupplierCodeVH AS _PRACustomerSupplierCodeVH ON PRACustomerSupplierCode = _PRACustomerSupplierCodeVH.PRACustomerSupplierCode  -- association [1..1]
LEFT OUTER JOIN I_PRAOwnerDetail 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_SuspenseReasonText AS _SuspenseReason ON SuspenseReason = _SuspenseReason.SuspenseReason AND _SuspenseReason.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_TaxBasisText AS _TaxBasis ON TaxBasis = _TaxBasis.TaxBasis AND _TaxBasis.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PRAPayOutCodeVH AS _PRAPayOutCodeVH ON PRAPayoutCode = _PRAPayOutCodeVH.PRAPayoutCode  -- association [1..1]
LEFT OUTER JOIN I_OwnerPaymentStatusText AS _OwnerPaymentStatus ON OwnerPaymentStatus = _OwnerPaymentStatus.OwnerPaymentStatus AND _OwnerPaymentStatus.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_PRAEntitlementCodeVH AS _PRAEntitlementCodeVH ON PRAEntitlementCode = _PRAEntitlementCodeVH.PRAEntitlementCode  -- association [1..1]
LEFT OUTER JOIN I_PRALegalFormText AS _PRALegalForm ON PRALegalForm = _PRALegalForm.PRALegalForm AND _PRALegalForm.Language = $session.system_language  -- 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_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]
;