I_PRAOwnershipTransferChgDet

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_PRAOwnershipTransferChgDet.
-- 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_PRAOwnershipTransferChgDet AS
SELECT
  rtch_no AS PRAFundsTransferChangeNumber,
  ocust_vend_cd AS PRATransferFromCustSuplrCode,
  oown_no AS PRAFundsTransferFromOwner,
  oown_int_type_cd AS PRAFndsTransfFrmOwnrIntrstType,
  oown_isq_no AS PRAFndsTransfFrmOwnrIntrstSeq,
  nw_cust_vend_cd AS PRATransferToCustSuplrCode,
  nw_own_no AS PRAFundsTransferToOwner,
  nw_own_int_type AS PRAFndsTransfToOwnrIntrstType,
  nw_own_isq_no AS PRAFndsTransfToOwnrIntrstSeq,
  bukrs AS CompanyCode,
  vname AS PRAJointVenture,
  doi_no AS DivisionOfInterest,
  eff_from_dt AS PRATransferEffectiveFromDate,
  tfr_chg_cd AS PRATransferChangeCode,
  eff_to_dt AS PRATransferEffectiveToDate,
  doc_no AS PRAOwnerRequestDocNumber,
  doc_year AS PRAOwnerRequestDocYear,
  item_no AS PRAOwnerRequestDocItmNmbr,
  nri_decm_pc AS NetRevenueInterestRatio,
  al_decm_pc AS PRAOwnerAllocationRatio,
  ovrd_pay_cd AS OverrideOwnerPaymentStatus,
  ovrd_susp_cd AS OverrideSuspenseReason,
  ovrd_lease_id AS PRAOverrideLeaseID,
  oiu_cruser AS CreatedByUser,
  oiu_timestamp AS CreationDateTime
FROM oiuow_rtd
LEFT OUTER JOIN I_PRAOwner AS _PRATransferFromOwner ON PRAFundsTransferFromOwner = _PRATransferFromOwner.PRAOwner  -- association [1..1]
LEFT OUTER JOIN I_PRAOwner AS _PRATransferToOwner ON PRAFundsTransferToOwner = _PRATransferToOwner.PRAOwner  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_JointVenture AS _JointVenture ON CompanyCode = _JointVenture.CompanyCode AND PRAJointVenture = _JointVenture.JointVenture  -- association [1..1]
LEFT OUTER JOIN I_DivisionOfInterest AS _DivisionOfInterest ON CompanyCode = _DivisionOfInterest.CompanyCode AND PRAJointVenture = _DivisionOfInterest.JointVenture AND DivisionOfInterest = _DivisionOfInterest.DivisionOfInterest  -- association [1..1]
;