I_JntVntrPartOwnrEquityShr

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_JntVntrPartOwnrEquityShr.
-- 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.
-- SQL view name: IJVPARTOWNREQSHR

CREATE VIEW I_JntVntrPartOwnrEquityShr AS
SELECT
  bukrs AS CompanyCode,
  vname AS JointVenture,
  egrup AS JntOpgAgrmtEquityGrp,
  partn AS JointVenturePartner,
  _Customer.CustomerName AS JointVenturePartnerShortText,
  _Customer.BPCustomerName AS JointVenturePartner2ShortText,
  _Customer.BPCustomerFullName AS JointVenturePartnerLongText,
  eqshare AS JntVntrEquityShare,
  ownsusp AS JntVntrOwnrIsSuspended,
  ownsusper AS JntVntrOwnrSuspendedPerd,
  ownsusyear AS JntVntrOwnrSuspendedYr,
  ownunsus AS JntVntrOwnrIsNotSuspended,
  ownususper AS JntVntrOwnrNotSuspendedPerd,
  ownususyr AS JntVntrOwnrNotSuspendedYr,
  inttype AS JntVntrInterestType,
  drillrecpc AS JntVntrDrillingRcvryPercent,
  operrecpc AS JntVntrOpgRcvryPercent,
  stoppay AS JntVntrPayIsStppd,
  cioutper AS JntVntrPartWrkgIntrstPerd,
  cioutyear AS JntVntrPartWrkgIntrstYrValue,
  cigroup AS JntVntrCarriedIntrstGrp,
  npigroup AS JntVntrNetProfitIntrstGrp,
  regio AS JntVntrOperatorAddressArea
FROM t8jq
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Customer ON JointVenturePartner = _Customer.Customer  -- association [0..1]
LEFT OUTER JOIN I_JntVntrValueHelp AS _JntVntrValueHelp ON CompanyCode = _JntVntrValueHelp.CompanyCode AND JointVenture = _JntVntrValueHelp.JointVenture  -- association [1..1]
LEFT OUTER JOIN I_JntVntrEquityGrp AS _JntVntrEquityGrp ON CompanyCode = _JntVntrEquityGrp.CompanyCode AND JointVenture = _JntVntrEquityGrp.JointVenture AND JntOpgAgrmtEquityGrp = _JntVntrEquityGrp.JntOpgAgrmtEquityGrp  -- association [1..1]
LEFT OUTER JOIN I_JointVentureSuspenseText AS _JointVentureSuspenseText ON JntVntrOwnrIsSuspended = _JointVentureSuspenseText.JntVntrSuspenseStatus  -- association [0..*]
LEFT OUTER JOIN I_JointVentureMasterFld AS _JointVentureMasterFld ON CompanyCode = _JointVentureMasterFld.CompanyCode AND JointVenture = _JointVentureMasterFld.JointVenture  -- association [1..1]
;