C_JVACarriedIntrstPyoutFDP

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 C_JVACarriedIntrstPyoutFDP.
-- 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: CJVCIPYOUTFDP

CREATE VIEW C_JVACarriedIntrstPyoutFDP AS
SELECT
  FiscalYear,
  PostingPeriod,
  CompanyCode,
  JointVenturePartner,
  JointVenture,
  JntOpgAgrmtEquityGrp,
  JntVntrCarriedIntrstGrp,
  CompanyCodeCurrency,
  _stopPay.JntVntrPayIsStppd AS JntVntrPayIsStppd,
  PnltyAmtInCoCodeCrcy,
  StartingBalanceAmtInCoCodeCrcy,
  CurPerdAmtInCCrcy,
  EndingBalanceAmtInCoCodeCrcy,
  cast('' as char30 ) AS JntVntrFDPCustField2,
  cast('' as char30 ) AS JntVntrFDPCustField3,
  cast('' as char30 ) AS JntVntrFDPCustField4,
  cast('' as char30 ) AS JntVntrFDPCustField5
FROM I_JVACarriedIntrstPyoutFDP
LEFT OUTER JOIN C_JVACarriedIntrstInvcItmFDP AS _stopPay ON CompanyCode = _stopPay.CompanyCode AND FiscalYear = _stopPay.FiscalYear AND PostingPeriod = _stopPay.PostingPeriod AND JointVenturePartner = _stopPay.JointVenturePartner AND JointVenture = _stopPay.JointVenture AND JntOpgAgrmtEquityGrp = _stopPay.JntOpgAgrmtEquityGrp AND JntVntrCarriedIntrstGrp = _stopPay.JntVntrCarriedIntrstGrp AND JntVntrAcctgIsExpnOrRevn = 'R'  -- association [1..1]
;