I_RAJournalEntryItem

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_RAJournalEntryItem.
-- 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: IRAJRNLENTRITM

CREATE VIEW I_RAJournalEntryItem AS
SELECT
  _CAT_MAP.RevnAcctgPostingCategory AS RevnAcctgPostingCategory,
  _FINSC.AccountingPrinciple AS AccountingPrinciple,
  _ACDOCA.ra_contract_id AS RevenueAccountingContract,
  _ACDOCA.ra_pob_id AS PerformanceObligation,
  _ACDOCA.rldnr AS Ledger,
  _ACDOCA.gjahr AS FiscalYear,
  _ACDOCA.belnr AS AccountingDocument,
  _ACDOCA.docln AS GLAccountLineItem,
  _ACDOCA.rbukrs AS CompanyCode,
  _ACDOCA.drcrk AS DebitCreditCode,
  cast( '' as kscha ) AS ConditionType,
  cast( '' as farr_recon_key ) AS RevnAcctgReconciliationKey,
  cast( 'C' as farr_recon_key_status ) AS RevnAcctgRecnclnKeyStatus,
  _ACDOCA.periv AS FiscalYearVariant,
  _CompanyCode.ControllingArea AS ControllingArea,
  _ACDOCA.slalittype AS SubLedgerAcctLineItemType,
  cast(case _FINSC.AdditionalCurrency1Field when 'GC' then _ACDOCA.rkcur when 'FDC1' then _ACDOCA.rocur when 'FDC2' then _ACDOCA.rvcur when 'FDC3' then _ACDOCA.rbcur when 'FDC4' then _ACDOCA.rccur when 'FDC5' then _ACDOCA.rdcur when 'FDC6' then _ACDOCA.recur when 'FDC7' then _ACDOCA.rfcur when 'FDC8' then _ACDOCA.rgcur end as hwae2) as AdditionalCurrency1 AS rgcurendashwae2asAdditionalCurrency1,
  cast(case _FINSC.AdditionalCurrency2Field when 'GC' then _ACDOCA.rkcur when 'FDC1' then _ACDOCA.rocur when 'FDC2' then _ACDOCA.rvcur when 'FDC3' then _ACDOCA.rbcur when 'FDC4' then _ACDOCA.rccur when 'FDC5' then _ACDOCA.rdcur when 'FDC6' then _ACDOCA.recur when 'FDC7' then _ACDOCA.rfcur when 'FDC8' then _ACDOCA.rgcur end as hwae3) as AdditionalCurrency2 AS rgcurendashwae3asAdditionalCurrency2,
  cast( '' as kstat ) AS ConditionIsForStatistics,
  cast( '' as farr_rai_srcco ) AS RevnAcctgSenderComponent,
  cast( '' as farr_rai_srcls ) AS RASndgCompLogicalSystem,
  cast( '' as farr_rai_srcty ) AS RASndgCompDocumentItemType,
  cast( '' as farr_rai_srcid ) AS RASndgCompDocumentItem,
  cast( _ACDOCA.wsl as farr_amount_tc) AS RevnAcctgPostgAmtInSlsDocCrcy,
  cast( _ACDOCA.rwcur as waers) AS SalesDocumentCurrency,
  cast( _ACDOCA.hsl as farr_amount_lc) AS RevnAcctgPostgAmtInCoCodeCrcy,
  cast( _ACDOCA.rhcur as hwaer) AS CompanyCodeCurrency,
  _ACDOCA.racct AS GLAccount,
  _CAT_MAP.DeferralItemCatPerCndnType AS DeferralItemCatPerCndnType,
  _ACDOCA.rfarea AS FunctionalArea,
  _ACDOCA.rbusa AS BusinessArea,
  _ACDOCA.rcntr AS CostCenter,
  _ACDOCA.poper AS FiscalPeriod,
  _ACDOCA.fiscyearper AS FiscalYearPeriod,
  _ACDOCA.segment AS Segment,
  _ACDOCA.prctr AS ProfitCenter,
  cast(_ACDOCA.paobjnr as rkeobjnr_char) AS ProfitabilitySegment,
  _ACDOCA.aufnr AS OrderID,
  _ACDOCA.kdauf AS SalesOrder,
  _InternalWBSElement.WBSElementExternalID AS WBSElementExternalID,
  cast( _ACDOCA.ps_psp_pnr as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  _ACDOCA.budat AS PostingDate,
  _ACDOCA.awtyp AS OriginalReferenceDocumentType,
  _ACDOCA.awsys AS ReferenceDocumentLogicalSystem,
  _ACDOCA.aworg AS ReferenceDocumentContext,
  _ACDOCA.awref AS ReferenceDocument,
  _ACDOCA.timestamp AS RAPostingItemLastChgDateTime
FROM P_ACDOCA AS _ACDOCA
INNER JOIN I_LedgerCompanyCodeCrcyRoles AS _FINSC ON /* join condition not captured in parsed metadata */
INNER JOIN I_RAAcctgPrncpRepLdgrMapping AS _ACCPRNCPLDGR ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN I_RAPerformanceObligation AS _RAPerformanceObligation ON PerformanceObligation = _RAPerformanceObligation.PerformanceObligation  -- association [1..1]
LEFT OUTER JOIN I_RAPostingCategory AS _RAPostingCategory ON RevnAcctgPostingCategory = _RAPostingCategory.RevnAcctgPostingCategory  -- association [1..1]
LEFT OUTER JOIN I_DebitCreditCode AS _DebitCreditCode ON DebitCreditCode = _DebitCreditCode.DebitCreditCode  -- association [1..1]
LEFT OUTER JOIN I_RevenueAccountingContract AS _RevenueAccountingContract ON RevenueAccountingContract = _RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SalesDocumentCurrency = _Currency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _CompanyCodeCurrency ON CompanyCodeCurrency = _CompanyCodeCurrency.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency1 ON AdditionalCurrency1 = _AdditionalCurrency1.Currency  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _AdditionalCurrency2 ON AdditionalCurrency2 = _AdditionalCurrency2.Currency  -- association [1..1]
LEFT OUTER JOIN I_ControllingArea AS _ControllingArea ON ControllingArea = _ControllingArea.ControllingArea  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearForCompanyCode AS _FiscalYear ON FiscalYear = _FiscalYear.FiscalYear AND CompanyCode = _FiscalYear.CompanyCode  -- association [0..1]
LEFT OUTER JOIN I_GLAccountInCompanyCode AS _GLAccountInCompanyCode ON CompanyCode = _GLAccountInCompanyCode.CompanyCode AND GLAccount = _GLAccountInCompanyCode.GLAccount  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON BusinessArea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_ProfitCenter AS _ProfitCenter ON ControllingArea = _ProfitCenter.ControllingArea AND ProfitCenter = _ProfitCenter.ProfitCenter  -- association [0..*]
LEFT OUTER JOIN I_ProfitCenter AS _CurrentProfitCenter ON ControllingArea = _CurrentProfitCenter.ControllingArea AND ProfitCenter = _CurrentProfitCenter.ProfitCenter AND _CurrentProfitCenter.ValidityStartDate <= $session.system_date AND _CurrentProfitCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON FunctionalArea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON Segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_CostCenter AS _CostCenter ON ControllingArea = _CostCenter.ControllingArea AND CostCenter = _CostCenter.CostCenter  -- association [0..*]
LEFT OUTER JOIN I_CostCenter AS _CurrentCostCenter ON ControllingArea = _CurrentCostCenter.ControllingArea AND CostCenter = _CurrentCostCenter.CostCenter AND _CurrentCostCenter.ValidityStartDate <= $session.system_date AND _CurrentCostCenter.ValidityEndDate >= $session.system_date  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _InternalWBSElement ON WBSElementInternalID = _InternalWBSElement.WBSElementInternalID  -- association [0..1]
LEFT OUTER JOIN I_WBSElementByExternalID AS _WBSElement ON WBSElementExternalID = _WBSElement.WBSElementExternalID  -- association [0..1]
LEFT OUTER JOIN I_FiscalYearVariant AS _FiscalYearVariant ON FiscalYearVariant = _FiscalYearVariant.FiscalYearVariant  -- association [0..1]
LEFT OUTER JOIN I_Ledger AS _Ledger ON Ledger = _Ledger.Ledger  -- association [0..1]
;