I_RADeferralItemWithoutInvoice

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_RADeferralItemWithoutInvoice.
-- 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_RADeferralItemWithoutInvoice AS
SELECT
  recon_key AS RevnAcctgReconciliationKey,
  cast(Defitem.pob_id as farr_cds_pob_id preserving type) AS PerformanceObligation,
  cast(condition_type as farr_cond_type preserving type) AS ConditionType,
  cast( contract_id as farr_original_contract_id preserving type) AS OriglRevenueAccountingContract,
  cast(substring(recon_key,1,7) as fis_jahrper_conv) AS FiscalYearPeriod,
  Defitem.company_code AS CompanyCode,
  Defitem.acct_principle AS AccountingPrinciple,
  category AS RevnAcctgConditionCategory,
  Defitem.fulfill_type AS PerfOblgnFulfillmentType,
  Defitem.event_type AS PerfOblgnEventType,
  statistic AS ConditionIsForStatistics,
  spec_indicator AS DeferralItemCatPerCndnType,
  amount_curk AS SalesDocumentCurrency,
  Defitem.quantity_unit AS PerfOblgnEffectiveQuantityUnit,
  cast(doc_qty_cumulate as farr_cds_effective_quantity) AS CumulativeEffectiveQuantity,
  cast(doc_qty_delta as farr_cds_effective_quantity) AS DeltaEffectiveQuantity,
  doc_amt_delta AS DeltaEffectiveAmtInSlsDocCrcy,
  doc_amt_cumulate AS CumltvEffectiveAmtInSlsDocCrcy,
  rev_amt_delta AS DeltaRecognizedAmtInSlsDocCrcy,
  rev_amt_posted AS PrevRecognizedAmtInSlsDocCrcy,
  cast(rev_qty_delta as farr_total_fulfilled_quantity) AS DeltaPerfOblgnFulfilledQty,
  cast(rev_qty_posted as farr_fulfilled_qty_to_cur_perd) AS PerfOblgnPreviousFulfilledQty,
  rev_amt_catchup AS RecgdCatchUpAmtInSlsDocCrcy,
  cast(source_acct as fin_glacct preserving type) AS RevnAcctgSourceAccount,
  cast(target_acct as fin_glacct preserving type) AS RevnAcctgTargetAccount,
  latest_defitem AS DeferralItemIsLatest,
  timestamp AS DeferralItemLastChangeDateTime,
  Defitem.created_on AS DeferralItemCreationDateTime
FROM farr_d_defitem AS Defitem
LEFT OUTER JOIN I_RAPerfOblgnWithoutAcctAssgmt AS _RAPerformanceObligation ON PerformanceObligation = _RAPerformanceObligation.PerformanceObligation  -- association [1..1]
LEFT OUTER JOIN I_RevenueAccountingContract AS _RevenueAccountingContract ON RevenueAccountingContract = _RevenueAccountingContract.RevenueAccountingContract  -- association [1..1]
LEFT OUTER JOIN I_RevenueAccountingContract AS _OriglRevnAccountingContract ON OriglRevenueAccountingContract = _OriglRevnAccountingContract.RevenueAccountingContract  -- association [1..1]
LEFT OUTER JOIN I_RevnAcctgReconciliationKey AS _RevnAcctgReconciliationKey ON OriglRevenueAccountingContract = _RevnAcctgReconciliationKey.RevenueAccountingContract AND RevnAcctgReconciliationKey = _RevnAcctgReconciliationKey.RevnAcctgReconciliationKey AND CompanyCode = _RevnAcctgReconciliationKey.CompanyCode AND AccountingPrinciple = _RevnAcctgReconciliationKey.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN I_RAConditionCategory AS _RAConditionCategory ON RevnAcctgConditionCategory = _RAConditionCategory.RevnAcctgConditionCategory  -- association [1..1]
LEFT OUTER JOIN I_RADeferralItemCatPerCndnType AS _RADeferralItemCatPerCndnType ON DeferralItemCatPerCndnType = _RADeferralItemCatPerCndnType.DeferralItemCatPerCndnType  -- association [1..1]
LEFT OUTER JOIN I_RAPerfObligationEventType AS _RAPerfObligationEventType ON PerfOblgnEventType = _RAPerfObligationEventType.PerfOblgnEventType  -- association [1..1]
LEFT OUTER JOIN I_RAPerfOblgnFlfmtType AS _RAPerfOblgnFlfmtType ON PerfOblgnFulfillmentType = _RAPerfOblgnFlfmtType.PerfOblgnFulfillmentType  -- association [1..1]
LEFT OUTER JOIN I_CompanyCode AS _CompanyCode ON CompanyCode = _CompanyCode.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_GLAccount AS _GLAccount ON RevnAcctgSourceAccount = _GLAccount.GLAccount AND CompanyCode = _GLAccount.CompanyCode  -- association [1..1]
LEFT OUTER JOIN I_AccountingPrinciple AS _AccountingPrinciple ON AccountingPrinciple = _AccountingPrinciple.AccountingPrinciple  -- association [1..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _UnitOfMeasure ON PerfOblgnEffectiveQuantityUnit = _UnitOfMeasure.UnitOfMeasure  -- association [1..1]
LEFT OUTER JOIN I_Currency AS _Currency ON SalesDocumentCurrency = _Currency.Currency  -- association [1..1]
;