P_RACatchUpDeferralItem
116C: Deferral Item
P_RACatchUpDeferralItem is a Composite CDS View that provides data about "116C: Deferral Item" in SAP S/4HANA. It reads from 1 data source (I_RevnAcctgDeferralItem) and exposes 34 fields with key fields RevnAcctgReconciliationKey, PerformanceObligation, ConditionType. Part of development package ODATA_FARR_REV_CATCHUP.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_RevnAcctgDeferralItem | _RevnAcctgDeferralItem | from |
Annotations (3)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #NOT_REQUIRED | view | |
| VDM.private | true | view | |
| VDM.viewType | #COMPOSITE | view |
Fields (34)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | RevnAcctgReconciliationKey | I_RevnAcctgDeferralItem | RevnAcctgReconciliationKey | Reconcil. Key |
| KEY | PerformanceObligation | I_RevnAcctgDeferralItem | PerformanceObligation | Performance Obligation |
| KEY | ConditionType | I_RevnAcctgDeferralItem | ConditionType | Condition type |
| RevenueAccountingContract | I_RevnAcctgDeferralItem | RevenueAccountingContract | Revenue Contract | |
| CompanyCode | I_RevnAcctgDeferralItem | CompanyCode | Receiver Company Code | |
| AccountingPrinciple | I_RevnAcctgDeferralItem | AccountingPrinciple | AP Ledger/CoCode | |
| FiscalYear | ||||
| FiscalPeriod | ||||
| SalesDocumentCurrency | I_RevnAcctgDeferralItem | SalesDocumentCurrency | Currency | |
| PerfOblgnEffectiveQuantityUnit | I_RevnAcctgDeferralItem | PerfOblgnEffectiveQuantityUnit | Unit of Measure | |
| CumltvEffectiveAmtInSlsDocCrcy | I_RevnAcctgDeferralItem | CumltvEffectiveAmtInSlsDocCrcy | Effective Value | |
| DeltaEffectiveAmtInSlsDocCrcy | I_RevnAcctgDeferralItem | DeltaEffectiveAmtInSlsDocCrcy | Delta Amount | |
| PrevRecognizedAmtInSlsDocCrcy | I_RevnAcctgDeferralItem | PrevRecognizedAmtInSlsDocCrcy | Sum Prev. Def. | |
| DeltaRecognizedAmtInSlsDocCrcy | I_RevnAcctgDeferralItem | DeltaRecognizedAmtInSlsDocCrcy | Posting Amount | |
| RecgdCatchUpAmtInSlsDocCrcy | I_RevnAcctgDeferralItem | RecgdCatchUpAmtInSlsDocCrcy | Catchup Amount | |
| CumulativeEffectiveQuantity | I_RevnAcctgDeferralItem | CumulativeEffectiveQuantity | ||
| DeltaEffectiveQuantity | I_RevnAcctgDeferralItem | DeltaEffectiveQuantity | ||
| PerfOblgnPreviousFulfilledQty | I_RevnAcctgDeferralItem | PerfOblgnPreviousFulfilledQty | ||
| DeltaPerfOblgnFulfilledQty | I_RevnAcctgDeferralItem | DeltaPerfOblgnFulfilledQty | ||
| BusinessPartner | ||||
| Customer | ||||
| PerfOblgnFulfillmentType | ||||
| RAPerformanceObligationType | ||||
| RevnAcctgSalesOrganization | ||||
| FunctionalArea | ||||
| BusinessArea | ||||
| Segment | ||||
| ProfitCenter | ||||
| ProfitabilitySegment | ||||
| CostCenter | ||||
| OrderID | ||||
| SalesOrder | ||||
| WBSElementExternalID | ||||
| IsBusinessPurposeCompleted |
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 P_RACatchUpDeferralItem.
-- 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 P_RACatchUpDeferralItem AS
SELECT
_RevnAcctgDeferralItem.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
_RevnAcctgDeferralItem.PerformanceObligation AS PerformanceObligation,
_RevnAcctgDeferralItem.ConditionType AS ConditionType,
_RevnAcctgDeferralItem.RevenueAccountingContract AS RevenueAccountingContract,
_RevnAcctgDeferralItem.CompanyCode AS CompanyCode,
_RevnAcctgDeferralItem.AccountingPrinciple AS AccountingPrinciple,
_RevnAcctgDeferralItem._RevnAcctgReconciliationKey.FiscalYear AS FiscalYear,
_RevnAcctgDeferralItem._RevnAcctgReconciliationKey.FiscalPeriod AS FiscalPeriod,
_RevnAcctgDeferralItem.SalesDocumentCurrency AS SalesDocumentCurrency,
_RevnAcctgDeferralItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
_RevnAcctgDeferralItem.CumltvEffectiveAmtInSlsDocCrcy AS CumltvEffectiveAmtInSlsDocCrcy,
_RevnAcctgDeferralItem.DeltaEffectiveAmtInSlsDocCrcy AS DeltaEffectiveAmtInSlsDocCrcy,
_RevnAcctgDeferralItem.PrevRecognizedAmtInSlsDocCrcy AS PrevRecognizedAmtInSlsDocCrcy,
_RevnAcctgDeferralItem.DeltaRecognizedAmtInSlsDocCrcy AS DeltaRecognizedAmtInSlsDocCrcy,
_RevnAcctgDeferralItem.RecgdCatchUpAmtInSlsDocCrcy AS RecgdCatchUpAmtInSlsDocCrcy,
_RevnAcctgDeferralItem.CumulativeEffectiveQuantity AS CumulativeEffectiveQuantity,
_RevnAcctgDeferralItem.DeltaEffectiveQuantity AS DeltaEffectiveQuantity,
_RevnAcctgDeferralItem.PerfOblgnPreviousFulfilledQty AS PerfOblgnPreviousFulfilledQty,
_RevnAcctgDeferralItem.DeltaPerfOblgnFulfilledQty AS DeltaPerfOblgnFulfilledQty,
_RevnAcctgDeferralItem._RAPerformanceObligation.BusinessPartner AS BusinessPartner,
_RevnAcctgDeferralItem._RAPerformanceObligation.Customer AS Customer,
_RevnAcctgDeferralItem._RAPerformanceObligation.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
_RevnAcctgDeferralItem._RAPerformanceObligation.RAPerformanceObligationType AS RAPerformanceObligationType,
_RevnAcctgDeferralItem._RAPerformanceObligation.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
_RevnAcctgDeferralItem._RAPerformanceObligation.FunctionalArea AS FunctionalArea,
_RevnAcctgDeferralItem._RAPerformanceObligation.BusinessArea AS BusinessArea,
_RevnAcctgDeferralItem._RAPerformanceObligation.Segment AS Segment,
_RevnAcctgDeferralItem._RAPerformanceObligation.ProfitCenter AS ProfitCenter,
_RevnAcctgDeferralItem._RAPerformanceObligation.ProfitabilitySegment_2 AS ProfitabilitySegment,
_RevnAcctgDeferralItem._RAPerformanceObligation.CostCenter AS CostCenter,
_RevnAcctgDeferralItem._RAPerformanceObligation.OrderID AS OrderID,
_RevnAcctgDeferralItem._RAPerformanceObligation.SalesOrder AS SalesOrder,
_RevnAcctgDeferralItem._RAPerformanceObligation.WBSElementExternalID AS WBSElementExternalID,
_RevnAcctgDeferralItem._RevenueAccountingContract.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM I_RevnAcctgDeferralItem AS _RevnAcctgDeferralItem
;
Learn More
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- CDS View Annotations — A Complete Guide
- What Is a CDS View in SAP S/4HANA?
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- BW Extractor to CDS View Migration Guide
- S/4HANA CDS View Deprecation: What You Need to Know
- ABAP CDS View Tutorial — From Basics to Real-World Examples
- RAP and CDS Views — Building Transactional Apps in SAP S/4HANA
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA