I_RACatchUpByCompanyCode

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_RACatchUpByCompanyCode.
-- 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_RACatchUpByCompanyCode AS
SELECT
  _RACatchUpChangeTypePeriod.PerformanceObligation AS PerformanceObligation,
  _RACatchUpChangeTypePeriod.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  _RACatchUpChangeTypePeriod.RevnAcctgContrChangeEffctvDate AS RevnAcctgContrChangeEffctvDate,
  _RACatchUpChangeTypePeriod.RevenueAccountingContract AS RevenueAccountingContract,
  _RACatchUpChangeTypePeriod.FiscalYear AS FiscalYear,
  _RACatchUpChangeTypePeriod.FiscalQuarter AS FiscalQuarter,
  _RACatchUpChangeTypePeriod.FiscalPeriod AS FiscalPeriod,
  cast(0 as sysuuid_c32) AS CaseUniqueID,
  _RACatchUpChangeTypePeriod.CompanyCode AS CompanyCode,
  _RACatchUpChangeTypePeriod.AccountingPrinciple AS AccountingPrinciple,
  cast('1' as farr_rev_catchup_displaymode) AS RevenueCatchUpDisplayDimension,
  cast('M' as farr_exchange_rate_type) AS ExchangeRateType,
  cast($session.system_date as vdm_v_exchange_rate_date preserving type) AS ExchangeRateDate,
  cast('' as farr_catchup_reporting_perd) AS FiscalYearQuarter,
  cast('' as fis_jahrper_conv) AS FiscalYearPeriod,
  cast('' as waerk) AS SalesDocumentCurrency,
  cast('' as vdm_v_display_currency) AS DisplayCurrency,
  cast(0 as farr_recog_rev_sc) AS RARecognizedRevnInSlsDocCrcy,
  cast(abap.curr'0.00' as farr_rev_catchup_amt_sc) AS RecgdCatchUpAmtInSlsDocCrcy,
  cast(abap.curr'0.00' as farr_recog_rev_dc) AS RARecognizedRevnInDspCrcy,
  cast(abap.curr'0.00' as farr_rev_catchup_amt_dc) AS RecgdCatchUpAmtInDspCrcy,
  cast(0 as farr_ra_cup_dblimit_instr) AS NumberOfWorkItems,
  cast('1900' as farr_from_fiscal_year preserving type) AS FromFiscalYear,
  cast('001' as farr_from_fiscal_period preserving type) AS FromFiscalPeriod,
  cast('9999' as farr_to_fiscal_year preserving type) AS ToFiscalYear,
  cast('016' as farr_to_fiscal_period preserving type) AS ToFiscalPeriod,
  _RAPerformanceObligation.BusinessPartner AS BusinessPartner,
  _RAPerformanceObligation._BusinessPartner.BusinessPartnerName AS BusinessPartnerName,
  _RAPerformanceObligation.Customer AS Customer,
  _RAPerformanceObligation._Customer.CustomerName AS CustomerName,
  _RAPerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  cast('' as val_text) AS PerfOblgnFulfillmentTypeName,
  _RAPerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
  _RAPerformanceObligation.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  _RAPerformanceObligation.FunctionalArea AS FunctionalArea,
  _RAPerformanceObligation.BusinessArea AS BusinessArea,
  _RAPerformanceObligation.Segment AS Segment,
  _RAPerformanceObligation.ProfitCenter AS ProfitCenter,
  _RAPerformanceObligation.ProfitabilitySegment_2 AS ProfitabilitySegment,
  _RAPerformanceObligation.CostCenter AS CostCenter,
  _RAPerformanceObligation.OrderID AS OrderID,
  _RAPerformanceObligation.SalesOrder AS SalesOrder,
  _RAPerformanceObligation.WBSElementExternalID AS WBSElementExternalID,
  _RAPerformanceObligation._BusinessPartner AS _BusinessPartner,
  _RAPerformanceObligation._Customer AS _Customer
FROM P_RACatchUpChangeTypePeriod AS _RACatchUpChangeTypePeriod
LEFT OUTER JOIN I_RAPerformanceObligation AS _RAPerformanceObligation ON PerformanceObligation = _RAPerformanceObligation.PerformanceObligation  -- association [1..1]
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_Currency AS _Currency ON DisplayCurrency = _Currency.Currency  -- association [0..1]
LEFT OUTER JOIN I_SalesOrganization AS _SalesOrganization ON revnacctgsalesorganization = _SalesOrganization.SalesOrganization  -- association [0..1]
LEFT OUTER JOIN I_FunctionalArea AS _FunctionalArea ON functionalarea = _FunctionalArea.FunctionalArea  -- association [0..1]
LEFT OUTER JOIN I_BusinessArea AS _BusinessArea ON businessarea = _BusinessArea.BusinessArea  -- association [0..1]
LEFT OUTER JOIN I_Segment AS _Segment ON segment = _Segment.Segment  -- association [0..1]
LEFT OUTER JOIN I_Order AS _Order ON orderid = _Order.OrderID  -- association [0..1]
LEFT OUTER JOIN I_ExchangeRateType AS _ExchangeRateType ON ExchangeRateType = _ExchangeRateType.ExchangeRateType  -- association [0..1]
;