I_JVAActualCashCallLineItem

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_JVAActualCashCallLineItem.
-- 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: IJVACTCASHCALL
-- Parameters: P_FiscalYear : gjahr, P_FiscalPeriod : poper

CREATE VIEW I_JVAActualCashCallLineItem AS
SELECT
  _GLAcctLineItem.SourceLedger AS SourceLedger,
  _GLAcctLineItem.CompanyCode AS CompanyCode,
  _GLAcctLineItem.FiscalYear AS FiscalYear,
  _GLAcctLineItem.AccountingDocument AS AccountingDocument,
  _GLAcctLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  FiscalYearVariant,
  LedgerFiscalYear,
  FiscalPeriod,
  ChartOfAccounts,
  GLAccount,
  DebitCreditCode,
  _GLAcctLineItem.ControllingArea AS ControllingArea,
  _GLAcctLineItem.CostCenter AS CostCenter,
  _GLAcctLineItem.ProfitCenter AS ProfitCenter,
  FiscalYearPeriod,
  _GLAcctLineItem.WBSElementInternalID AS WBSElementInternalID,
  _GLAcctLineItem.JointVenture AS JointVenture,
  _JVMaster.JointVentureType AS JointVentureType,
  _GLAcctLineItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  _GLAcctLineItem.JointVentureEquityType AS JointVentureEquityType,
  _GLAcctLineItem.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  _GLAcctLineItem.JointVenturePartner AS JointVenturePartner,
  _GLAcctLineItem.JointVentureBillingType AS JointVentureBillingType,
  JointVentureAccountingActivity,
  CompanyCodeCurrency,
  _GLAcctLineItem._CompanyCode AS _CompanyCode
FROM I_GLAccountLineItemRawData AS _GLAcctLineItem
INNER JOIN I_JVALedger AS _JVALedger ON /* join condition not captured in parsed metadata */
INNER JOIN I_JointVentureMasterFld AS _JVMaster ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JVABillingMethodPostgRule AS _JVBillMethPostRl ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JntVntrRecoveryInd AS _JVRecoveryInd ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JntVntrCoCodeParam AS _JntVntrCoCodeParam ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JointVentureMasterFld AS _JointVentureMasterFld ON CompanyCode = _JointVentureMasterFld.CompanyCode AND JointVenture = _JointVentureMasterFld.JointVenture  -- association [0..1]
LEFT OUTER JOIN I_JntVntrEquityGrp AS _JntVntrEquityGrp ON CompanyCode = _JntVntrEquityGrp.CompanyCode AND JointVenture = _JntVntrEquityGrp.JointVenture AND JointVentureEquityGroup = _JntVntrEquityGrp.JntOpgAgrmtEquityGrp  -- association [0..1]
LEFT OUTER JOIN I_JntVntrRecoveryInd AS _JntVntrRecoveryInd ON CompanyCode = _JntVntrRecoveryInd.CompanyCode AND JointVentureCostRecoveryCode = _JntVntrRecoveryInd.JointVentureRecoveryCode  -- association [0..1]
LEFT OUTER JOIN I_JntVntrEquityTypeMaster AS _JntVntrEquityTypeMaster ON CompanyCode = _JntVntrEquityTypeMaster.CompanyCode AND JointVentureEquityType = _JntVntrEquityTypeMaster.JointVentureEquityType  -- association [0..1]
LEFT OUTER JOIN I_JntVntrBusinessPartner AS _JntVntrBusinessPartner ON CompanyCode = _JntVntrBusinessPartner.CompanyCode AND JointVenturePartner = _JntVntrBusinessPartner.JointVenturePartner  -- association [0..1]
LEFT OUTER JOIN I_JointVenturePayrollType AS _JointVenturePayrollType ON JointVentureBillingType = _JointVenturePayrollType.JointVentureBillingType  -- association [0..1]
;