I_RevenueAccountingPosting

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_RevenueAccountingPosting.
-- 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.

CREATE VIEW I_RevenueAccountingPosting AS
SELECT
  company_code AS CompanyCode,
  acct_principle AS AccountingPrinciple,
  recon_key AS RevnAcctgReconciliationKey,
  cast(pob_id as farr_cds_pob_id preserving type) AS PerformanceObligation,
  condition_type AS ConditionType,
  post_cat AS RevnAcctgPostingCategory,
  shkzg AS DebitCreditCode,
  guid AS RevnAcctgPostingItemUUID,
  cast(contract_id as farr_cds_contract_id preserving type) AS RevenueAccountingContract,
  betrw AS RevnAcctgPostgAmtInSlsDocCrcy,
  cast(waers as waerk preserving type) AS SalesDocumentCurrency,
  cast(betrh as farr_cds_postg_revn_company preserving type) AS RevnAcctgPostgAmtInCoCodeCrcy,
  hwaer AS CompanyCodeCurrency,
  betr2 AS RevnAcctgPostgAmtInAddlCrcy1,
  hwae2 AS AdditionalCurrency1,
  betr3 AS RevnAcctgPostgAmtInAddlCrcy2,
  hwae3 AS AdditionalCurrency2,
  timestamp AS RAPostingItemLastChgDateTime,
  statistic AS ConditionIsForStatistics,
  cast(gjahr as fis_gjahr_no_conv preserving type) AS FiscalYear,
  cast(substring(recon_key, 1, 7) as fis_jahrper_conv) AS FiscalYearPeriod,
  hkont AS GLAccount,
  spec_indicator AS DeferralItemCatPerCndnType,
  fkber AS FunctionalArea,
  gsber AS BusinessArea,
  Segment,
  prctr AS ProfitCenter,
  kostl AS CostCenter,
  aufnr AS OrderID,
  kdauf AS SalesOrder,
  _InternalWBSElement.WBSElementExternalID AS WBSElementExternalID,
  cast(ps_psp_pnr as ps_s4_pspnr preserving type) AS WBSElementInternalID,
  paobjnr AS ProfitabilitySegment,
  _CompanyCode.ControllingArea AS ControllingArea,
  invoice_guid AS RevnAcctgInvoiceUUID,
  srcdoc_comp AS RevnAcctgSenderComponent,
  srcdoc_logsys AS RASndgCompLogicalSystem,
  srcdoc_type AS RASndgCompDocumentItemType,
  srcdoc_id AS RASndgCompDocumentItem,
  poper AS FiscalPeriod,
  aggregation_type AS RAPostingAggregationType
FROM farr_d_posting AS post
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_RevnAcctgReconciliationKey AS _RevnAcctgReconciliationKey ON CompanyCode = _RevnAcctgReconciliationKey.CompanyCode AND AccountingPrinciple = _RevnAcctgReconciliationKey.AccountingPrinciple AND RevenueAccountingContract = _RevnAcctgReconciliationKey.RevenueAccountingContract AND RevnAcctgReconciliationKey = _RevnAcctgReconciliationKey.RevnAcctgReconciliationKey  -- 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_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_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_Order AS _Order ON OrderID = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_SalesOrder AS _SalesOrder ON SalesOrder = _SalesOrder.SalesOrder  -- association [0..1]
LEFT OUTER JOIN I_RevenueAccountingInvoice AS _Invoice ON RevnAcctgInvoiceUUID = _Invoice.RevnAcctgInvoiceUUID AND PerformanceObligation = _Invoice.PerformanceObligation  -- association [0..1]
;