P_RACatchUpDeferralItem

DDL: P_RACATCHUPDEFERRALITEM SQL: PRACUPDEFRLITM Type: view COMPOSITE
35 Fields 1 Data Sources

P_RACatchUpDeferralItem is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_RevnAcctgDeferralItem) and exposes 35 fields with key fields RevnAcctgReconciliationKey, PerformanceObligation, ConditionType.

Data Sources (1)

SourceAliasJoin Type
I_RevnAcctgDeferralItem _RevnAcctgDeferralItem from

Annotations (7)

NameValueLevelField
AbapCatalog.sqlViewName PRACUPDEFRLITM view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
VDM.private true view

Fields (35)

KeyFieldSource TableSource FieldDescription
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
RAContractIsCreatedByContrMgr
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.
-- SQL view name: PRACUPDEFRLITM

CREATE VIEW P_RACatchUpDeferralItem AS
SELECT
  _RevnAcctgDeferralItem.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  _RevnAcctgDeferralItem.PerformanceObligation AS PerformanceObligation,
  _RevnAcctgDeferralItem.ConditionType AS ConditionType,
  _RevnAcctgDeferralItem.RevenueAccountingContract AS RevenueAccountingContract,
  _RevnAcctgDeferralItem._RevenueAccountingContract.RAContractIsCreatedByContrMgr AS RAContractIsCreatedByContrMgr,
  _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