I_JVAGrossNetAmtByCostObjC

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_JVAGrossNetAmtByCostObjC.
-- 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: IJVANETGRCOC
-- Parameters: P_LedgerFiscalYear : gjahr, P_FiscalPeriod : poper

CREATE VIEW I_JVAGrossNetAmtByCostObjC AS
SELECT
  sl.Ledger AS Ledger,
  gl.CompanyCode AS CompanyCode,
  gl.FiscalYear AS FiscalYear,
  gl.AccountingDocument AS AccountingDocument,
  gl.LedgerGLLineItem AS LedgerGLLineItem,
  gl.JointVenture AS JointVenture,
  gl.JointVentureEquityGroup AS JointVentureEquityGroup,
  gl.GLAccount AS GLAccount,
  gl.CostCenter AS CostCenter,
  gl.OrderID AS OrderID,
  gl.WBSElementInternalID AS WBSElementInternalID,
  gl.WBSElement AS WBSElement,
  gl.ProjectNetwork AS ProjectNetwork,
  gl.RelatedNetworkActivity AS RelatedNetworkActivity,
  gl.CostObject AS CostObject,
  gl.FiscalPeriod AS FiscalPeriod,
  gl.JointVentureCostRecoveryCode AS JointVentureCostRecoveryCode,
  gl.TransactionCurrency AS TransactionCurrency
FROM I_GLAccountLineItemRawData AS gl
INNER JOIN I_LedgerSourceLedger AS sl ON /* join condition not captured in parsed metadata */
INNER JOIN I_JVALedger AS ld ON /* join condition not captured in parsed metadata */
INNER JOIN I_JointVentureMasterFld AS jv ON /* join condition not captured in parsed metadata */
INNER JOIN I_JntVntrCoCodeParam AS co ON /* join condition not captured in parsed metadata */
INNER JOIN I_JntVntrEquityGrp AS op ON /* join condition not captured in parsed metadata */
INNER JOIN I_JntVntrRecoveryInd AS ri ON /* join condition not captured in parsed metadata */
;