I_JVANonOperatorInvoiceFDP

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_JVANonOperatorInvoiceFDP.
-- 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: IJVANONOPTRIVFDP

CREATE VIEW I_JVANonOperatorInvoiceFDP AS
SELECT
  I_GLAccountLineItem.SourceLedger AS SourceLedger,
  I_GLAccountLineItem.AccountingDocument AS AccountingDocument,
  I_GLAccountLineItem.CompanyCode AS CompanyCode,
  I_GLAccountLineItem.FiscalYear AS FiscalYear,
  I_GLAccountLineItem.LedgerGLLineItem AS LedgerGLLineItem,
  I_GLAccountLineItem.Ledger AS Ledger,
  I_GLAccountLineItem.JointVenture AS JointVenture,
  I_GLAccountLineItem.JointVenturePartner AS JointVenturePartner,
  I_GLAccountLineItem.JointVentureEquityGroup AS JointVentureEquityGroup,
  I_GLAccountLineItem.JointVentureEquityType AS JointVentureEquityType,
  I_GLAccountLineItem.JointVentureAccountingActivity AS JointVentureAccountingActivity,
  I_GLAccountLineItem.FiscalPeriod AS PostingPeriod,
  I_GLAccountLineItem.ReferenceDocumentItem AS ReferenceDocumentItem,
  I_GLAccountLineItem.TransactionSubitem AS TransactionSubitem,
  I_GLAccountLineItem.BalanceTransactionCurrency AS BalanceTransactionCurrency,
  I_GLAccountLineItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  I_GLAccountLineItem.GlobalCurrency AS GlobalCurrency,
  I_GLAccountLineItem.CostCenter AS CostCenter,
  I_GLAccountLineItem.AmountInBalanceTransacCrcy AS AmountInBalanceTransacCrcy,
  I_GLAccountLineItem.AmountInCompanyCodeCurrency AS AmountInCompanyCodeCurrency,
  I_GLAccountLineItem.AmountInTransactionCurrency AS AmountInTransactionCurrency,
  I_GLAccountLineItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  I_GLAccountLineItem.ItemIsSplit AS ItemIsSplit,
  I_GLAccountLineItem.DocumentItemText AS DocumentItemText,
  I_GLAccountLineItem.Supplier AS Supplier,
  I_GLAccountLineItem.InvtrySpclStockWBSElmntIntID AS InvtrySpclStockWBSElmntIntID,
  I_GLAccountLineItem.InventorySpclStockWBSElement AS InventorySpclStockWBSElement,
  I_GLAccountLineItem.MasterFixedAsset AS MasterFixedAsset,
  I_GLAccountLineItem.AssetClass AS AssetClass,
  I_GLAccountLineItem.WBSElementInternalID AS WBSElementInternalID,
  I_GLAccountLineItem.WBSElement AS WBSElement,
  I_GLAccountLineItem.ProjectInternalID AS ProjectInternalID,
  I_GLAccountLineItem.Project AS Project,
  I_GLAccountLineItem.ControllingDocumentItem AS ControllingDocumentItem,
  _AccountingDocSeg.dmbtr AS LocalCrcyTotal,
  _AccountingDocSeg.wrbtr AS FundingCrcyTotal,
  _Venture.JntVntrBillgFormat AS JntVntrBillgFormat,
  _Venture.JntVntrNonBillgFormat AS JntVntrNonBillgFormat,
  _Venture_Desc.JointVentureName AS JointVentureName,
  _Partner.JntVntrBillgFormat AS JntVntrPartnerBillgFormat,
  _Partner.JntVntrHardCopyBillgIsSupp AS JntVntrHardCopyBillgIsSupp,
  _Partner_Data._StandardAddress.Country AS Country,
  _Partner_Data.FaxNumber AS JntVntrPartnerFaxNumber,
  _Partner_Data.Country AS JntVntrPartnerCountry,
  _Partner_Data.AddressID AS JntVntrPartnerAddressID,
  _Partner_Data.Language AS Language,
  _Partner_Data._StandardAddress._DefaultEmailAddress.EmailAddress AS EmailAddress,
  _Partner_Data.BusinessPartnerName1 AS JointVentureOperatorName,
  _JV_Company.Operator AS JointVentureOperator,
  _AccountingDocHdr.Currency AS Currency,
  _AccountingDocHdr.ExchangeRate AS ExchangeRate,
  _AccountingDocHdr.CompanyCodeCurrency AS LocalCurrency,
  _VentureEquity_Data.JntVntrNonOperatedShare AS JntVntrNonOperatedShare,
  _VentureEquity_Data.JntVntrOperatedShare AS JntVntrOperatedShare,
  _Equity_Desc.JntOpgAgrmtEquityGrpText AS JointVentureEquityGroupName,
  _Partner_Data.BPCustomerName AS JointVenturePartnerName
FROM I_GLAccountLineItem
INNER JOIN I_JVALedger AS ld ON /* join condition not captured in parsed metadata */
INNER JOIN bseg AS _AccountingDocSeg ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_JntVntrCoCodeParam AS _JV_Company ON CompanyCode = _JV_Company.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingDocument AS _AccountingDocHdr ON CompanyCode = _AccountingDocHdr.CompanyCode AND AccountingDocument = _AccountingDocHdr.AccountingDocument AND FiscalYear = _AccountingDocHdr.FiscalYear  -- association [1..1]
LEFT OUTER JOIN I_JointVentureDetails AS _Venture ON JointVenture = _Venture.JointVenture AND CompanyCode = _Venture.CompanyCode AND JointVentureEquityGroup = _Venture.JntOpgAgrmtEquityGrp  -- association [1..1]
LEFT OUTER JOIN I_JointVentureDesc AS _Venture_Desc ON JointVenture = _Venture_Desc.JointVenture AND CompanyCode = _Venture_Desc.CompanyCode AND _Venture_Desc.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_JntVntrBusinessPartner AS _Partner ON CompanyCode = _Partner.CompanyCode AND JointVenturePartner = _Partner.JointVenturePartner  -- association [1..1]
LEFT OUTER JOIN I_Customer AS _Partner_Data ON JointVenturePartner = _Partner_Data.Customer  -- association [1..1]
LEFT OUTER JOIN I_JntVntrEquityGrp AS _VentureEquity_Data ON JointVenture = _VentureEquity_Data.JointVenture AND CompanyCode = _VentureEquity_Data.CompanyCode AND JointVentureEquityGroup = _VentureEquity_Data.JntOpgAgrmtEquityGrp  -- association [1..1]
LEFT OUTER JOIN I_JntVntrEquityGrpText AS _Equity_Desc ON CompanyCode = _Equity_Desc.CompanyCode AND JointVenture = _Equity_Desc.JointVenture AND JointVentureEquityGroup = _Equity_Desc.JntOpgAgrmtEquityGrp AND _Equity_Desc.Language = $session.system_language  -- association [1..1]
;