P_PerfOblgnCatchUpByPeriod

DDL: P_PERFOBLGNCATCHUPBYPERIOD Type: view_entity COMPOSITE
8 Fields 1 Data Sources

P_PerfOblgnCatchUpByPeriod is a Composite CDS View in SAP S/4HANA. It reads from 1 data source (I_RevnAcctgDeferralItem) and exposes 8 fields with key fields CompanyCode, AccountingPrinciple, PerformanceObligation, FiscalYear, FiscalPeriod.

Data Sources (1)

SourceAliasJoin Type
I_RevnAcctgDeferralItem DeferralItem from

Parameters (4)

NameTypeDefault
P_FiscalYearFrom fis_gjahr
P_FiscalPeriodFrom fis_poper
P_FiscalYearTo fis_gjahr
P_FiscalPeriodTo fis_poper

Annotations (3)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_RevnAcctgDeferralItem CompanyCode Receiver Company Code
KEY AccountingPrinciple I_RevnAcctgDeferralItem AccountingPrinciple AP Ledger/CoCode
KEY PerformanceObligation I_RevnAcctgDeferralItem PerformanceObligation Performance Obligation
KEY FiscalYear
KEY FiscalPeriod
SalesDocumentCurrency I_RevnAcctgDeferralItem SalesDocumentCurrency Currency
RecgdCatchUpAmtInSlsDocCrcy
DeltaRecognizedAmtInSlsDocCrcy

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_PerfOblgnCatchUpByPeriod.
-- 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.
-- Parameters: P_FiscalYearFrom : fis_gjahr, P_FiscalPeriodFrom : fis_poper, P_FiscalYearTo : fis_gjahr, P_FiscalPeriodTo : fis_poper

CREATE VIEW P_PerfOblgnCatchUpByPeriod AS
SELECT
  DeferralItem.CompanyCode AS CompanyCode,
  DeferralItem.AccountingPrinciple AS AccountingPrinciple,
  DeferralItem.PerformanceObligation AS PerformanceObligation,
  DeferralItem._RevnAcctgReconciliationKey.FiscalYear AS FiscalYear,
  DeferralItem._RevnAcctgReconciliationKey.FiscalPeriod AS FiscalPeriod,
  DeferralItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  sum(DeferralItem.RecgdCatchUpAmtInSlsDocCrcy) AS RecgdCatchUpAmtInSlsDocCrcy,
  sum(DeferralItem.DeltaRecognizedAmtInSlsDocCrcy) AS DeltaRecognizedAmtInSlsDocCrcy
FROM I_RevnAcctgDeferralItem AS DeferralItem
;

Learn More