P_RACatchUpDeferralItemByQtr

DDL: P_RACATCHUPDEFERRALITEMBYQTR Type: view_entity COMPOSITE
35 Fields 1 Data Sources 1 Associations

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

Data Sources (1)

SourceAliasJoin Type
P_RACatchUpDeferralItem _RACatchUpDeferralItem from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_RAAccountingPeriod _RAAccountingPeriod _RACatchUpDeferralItem.CompanyCode = _RAAccountingPeriod.CompanyCode and _RACatchUpDeferralItem.AccountingPrinciple = _RAAccountingPeriod.AccountingPrinciple and _RACatchUpDeferralItem.FiscalYear = _RAAccountingPeriod.FiscalYear and _RACatchUpDeferralItem.FiscalPeriod = _RAAccountingPeriod.FiscalPeriod

Annotations (3)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY RevnAcctgReconciliationKey P_RACatchUpDeferralItem RevnAcctgReconciliationKey
KEY PerformanceObligation P_RACatchUpDeferralItem PerformanceObligation Performance Obligation
KEY ConditionType P_RACatchUpDeferralItem ConditionType Condition type
RevenueAccountingContract P_RACatchUpDeferralItem RevenueAccountingContract Revenue Contract
CompanyCode P_RACatchUpDeferralItem CompanyCode Receiver Company Code
AccountingPrinciple P_RACatchUpDeferralItem AccountingPrinciple AP Ledger/CoCode
FiscalYear P_RACatchUpDeferralItem FiscalYear G/L Fiscal Year
FiscalPeriod P_RACatchUpDeferralItem FiscalPeriod Tax period
FiscalQuarter _RAAccountingPeriod FiscalQuarter
SalesDocumentCurrency P_RACatchUpDeferralItem SalesDocumentCurrency Currency
PerfOblgnEffectiveQuantityUnit P_RACatchUpDeferralItem PerfOblgnEffectiveQuantityUnit Unit of Measure
CumltvEffectiveAmtInSlsDocCrcy P_RACatchUpDeferralItem CumltvEffectiveAmtInSlsDocCrcy
DeltaEffectiveAmtInSlsDocCrcy P_RACatchUpDeferralItem DeltaEffectiveAmtInSlsDocCrcy
PrevRecognizedAmtInSlsDocCrcy P_RACatchUpDeferralItem PrevRecognizedAmtInSlsDocCrcy
DeltaRecognizedAmtInSlsDocCrcy P_RACatchUpDeferralItem DeltaRecognizedAmtInSlsDocCrcy
RecgdCatchUpAmtInSlsDocCrcy P_RACatchUpDeferralItem RecgdCatchUpAmtInSlsDocCrcy
CumulativeEffectiveQuantity P_RACatchUpDeferralItem CumulativeEffectiveQuantity
DeltaEffectiveQuantity P_RACatchUpDeferralItem DeltaEffectiveQuantity
PerfOblgnPreviousFulfilledQty P_RACatchUpDeferralItem PerfOblgnPreviousFulfilledQty
DeltaPerfOblgnFulfilledQty P_RACatchUpDeferralItem DeltaPerfOblgnFulfilledQty
BusinessPartner P_RACatchUpDeferralItem BusinessPartner Issuing Authority
Customer P_RACatchUpDeferralItem Customer Sold-to Party
PerfOblgnFulfillmentType P_RACatchUpDeferralItem PerfOblgnFulfillmentType Fulfillment Type
RAPerformanceObligationType P_RACatchUpDeferralItem RAPerformanceObligationType Performance Obligation Type
RevnAcctgSalesOrganization P_RACatchUpDeferralItem RevnAcctgSalesOrganization Sales Org.
FunctionalArea P_RACatchUpDeferralItem FunctionalArea Sendr Fctl Area
BusinessArea P_RACatchUpDeferralItem BusinessArea Business Area
Segment P_RACatchUpDeferralItem Segment Segment number
ProfitCenter P_RACatchUpDeferralItem ProfitCenter Profit Center
ProfitabilitySegment P_RACatchUpDeferralItem ProfitabilitySegment Profitability Segment
CostCenter P_RACatchUpDeferralItem CostCenter Cost Center
OrderID P_RACatchUpDeferralItem OrderID Order ID
SalesOrder P_RACatchUpDeferralItem SalesOrder SD Document
WBSElementExternalID P_RACatchUpDeferralItem WBSElementExternalID WBS Element External ID
IsBusinessPurposeCompleted P_RACatchUpDeferralItem IsBusinessPurposeCompleted Purpose Completed

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_RACatchUpDeferralItemByQtr.
-- 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_RACatchUpDeferralItemByQtr AS
SELECT
  _RACatchUpDeferralItem.RevnAcctgReconciliationKey AS RevnAcctgReconciliationKey,
  _RACatchUpDeferralItem.PerformanceObligation AS PerformanceObligation,
  _RACatchUpDeferralItem.ConditionType AS ConditionType,
  _RACatchUpDeferralItem.RevenueAccountingContract AS RevenueAccountingContract,
  _RACatchUpDeferralItem.CompanyCode AS CompanyCode,
  _RACatchUpDeferralItem.AccountingPrinciple AS AccountingPrinciple,
  _RACatchUpDeferralItem.FiscalYear AS FiscalYear,
  _RACatchUpDeferralItem.FiscalPeriod AS FiscalPeriod,
  _RAAccountingPeriod.FiscalQuarter AS FiscalQuarter,
  _RACatchUpDeferralItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  _RACatchUpDeferralItem.PerfOblgnEffectiveQuantityUnit AS PerfOblgnEffectiveQuantityUnit,
  _RACatchUpDeferralItem.CumltvEffectiveAmtInSlsDocCrcy AS CumltvEffectiveAmtInSlsDocCrcy,
  _RACatchUpDeferralItem.DeltaEffectiveAmtInSlsDocCrcy AS DeltaEffectiveAmtInSlsDocCrcy,
  _RACatchUpDeferralItem.PrevRecognizedAmtInSlsDocCrcy AS PrevRecognizedAmtInSlsDocCrcy,
  _RACatchUpDeferralItem.DeltaRecognizedAmtInSlsDocCrcy AS DeltaRecognizedAmtInSlsDocCrcy,
  _RACatchUpDeferralItem.RecgdCatchUpAmtInSlsDocCrcy AS RecgdCatchUpAmtInSlsDocCrcy,
  _RACatchUpDeferralItem.CumulativeEffectiveQuantity AS CumulativeEffectiveQuantity,
  _RACatchUpDeferralItem.DeltaEffectiveQuantity AS DeltaEffectiveQuantity,
  _RACatchUpDeferralItem.PerfOblgnPreviousFulfilledQty AS PerfOblgnPreviousFulfilledQty,
  _RACatchUpDeferralItem.DeltaPerfOblgnFulfilledQty AS DeltaPerfOblgnFulfilledQty,
  _RACatchUpDeferralItem.BusinessPartner AS BusinessPartner,
  _RACatchUpDeferralItem.Customer AS Customer,
  _RACatchUpDeferralItem.PerfOblgnFulfillmentType AS PerfOblgnFulfillmentType,
  _RACatchUpDeferralItem.RAPerformanceObligationType AS RAPerformanceObligationType,
  _RACatchUpDeferralItem.RevnAcctgSalesOrganization AS RevnAcctgSalesOrganization,
  _RACatchUpDeferralItem.FunctionalArea AS FunctionalArea,
  _RACatchUpDeferralItem.BusinessArea AS BusinessArea,
  _RACatchUpDeferralItem.Segment AS Segment,
  _RACatchUpDeferralItem.ProfitCenter AS ProfitCenter,
  _RACatchUpDeferralItem.ProfitabilitySegment AS ProfitabilitySegment,
  _RACatchUpDeferralItem.CostCenter AS CostCenter,
  _RACatchUpDeferralItem.OrderID AS OrderID,
  _RACatchUpDeferralItem.SalesOrder AS SalesOrder,
  _RACatchUpDeferralItem.WBSElementExternalID AS WBSElementExternalID,
  _RACatchUpDeferralItem.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted
FROM P_RACatchUpDeferralItem AS _RACatchUpDeferralItem
LEFT OUTER JOIN I_RAAccountingPeriod AS _RAAccountingPeriod ON _RACatchUpDeferralItem.CompanyCode = _RAAccountingPeriod.CompanyCode AND _RACatchUpDeferralItem.AccountingPrinciple = _RAAccountingPeriod.AccountingPrinciple AND _RACatchUpDeferralItem.FiscalYear = _RAAccountingPeriod.FiscalYear AND _RACatchUpDeferralItem.FiscalPeriod = _RAAccountingPeriod.FiscalPeriod  -- association [1..1]
;

Learn More