P_DrctCarryFwdDeltaPostgByYr

DDL: P_DRCTCARRYFWDDELTAPOSTGBYYR Type: view_entity COMPOSITE Package: FARR_CDS_ANALYTICS
31 Fields 2 Data Sources

Carry Forward and Delta Posting on Year Level

P_DrctCarryFwdDeltaPostgByYr is a Composite CDS View that provides data about "Carry Forward and Delta Posting on Year Level" in SAP S/4HANA. It reads from 2 data sources (I_RAJournalEntryItem, I_RAJournalEntryItem) and exposes 31 fields with key fields CompanyCode, AccountingPrinciple, RevenueAccountingContract, SubLedgerAcctLineItemType, PerformanceObligation. Part of development package FARR_CDS_ANALYTICS.

Data Sources (2)

SourceAliasJoin Type
I_RAJournalEntryItem RACarryForwardPosting from
I_RAJournalEntryItem RADeltaPosting union_all

Parameters (4)

NameTypeDefault
P_FiscalYearFrom fis_gjahr
P_FiscalPeriodFrom fis_poper
P_FiscalYearTo fis_gjahr
P_FiscalPeriodTo fis_poper

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (31)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_RAJournalEntryItem CompanyCode Receiver Company Code
KEY AccountingPrinciple I_RAJournalEntryItem AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract I_RAJournalEntryItem RevenueAccountingContract Revenue Contract
KEY SubLedgerAcctLineItemType I_RAJournalEntryItem SubLedgerAcctLineItemType SLALineItemType
KEY PerformanceObligation I_RAJournalEntryItem PerformanceObligation Performance Obligation
KEY FiscalYear G/L Fiscal Year
GLAccount I_RAJournalEntryItem GLAccount General Ledger
SalesDocumentCurrency I_RAJournalEntryItem SalesDocumentCurrency Currency
CompanyCodeCurrency I_RAJournalEntryItem CompanyCodeCurrency Local Currency
AdditionalCurrency1 I_RAJournalEntryItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_RAJournalEntryItem AdditionalCurrency2 Local curr. 3
RevnAcctgPostgAmtInSlsDocCrcy
RevnAcctgPostgAmtInCoCodeCrcy
RevnAcctgPostgAmtInAddlCrcy1
RevnAcctgPostgAmtInAddlCrcy2
CompanyCode Receiver Company Code
KEY AccountingPrinciple I_RAJournalEntryItem AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract I_RAJournalEntryItem RevenueAccountingContract Revenue Contract
KEY SubLedgerAcctLineItemType I_RAJournalEntryItem SubLedgerAcctLineItemType SLALineItemType
KEY PerformanceObligation I_RAJournalEntryItem PerformanceObligation Performance Obligation
KEY FiscalYear I_RAJournalEntryItem FiscalYear G/L Fiscal Year
GLAccount I_RAJournalEntryItem GLAccount General Ledger
SalesDocumentCurrency I_RAJournalEntryItem SalesDocumentCurrency Currency
CompanyCodeCurrency I_RAJournalEntryItem CompanyCodeCurrency Local Currency
AdditionalCurrency1 I_RAJournalEntryItem AdditionalCurrency1 Local curr. 2
AdditionalCurrency2 I_RAJournalEntryItem AdditionalCurrency2 Local curr. 3
RevnAcctgPostgAmtInSlsDocCrcy
RevnAcctgPostgAmtInCoCodeCrcy
RevnAcctgPostgAmtInAddlCrcy1
RevnAcctgPostgAmtInAddlCrcy2
RAPostLevelOfContractBalance

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_DrctCarryFwdDeltaPostgByYr.
-- 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_DrctCarryFwdDeltaPostgByYr AS
SELECT
  RACarryForwardPosting.CompanyCode AS CompanyCode,
  RACarryForwardPosting.AccountingPrinciple AS AccountingPrinciple,
  RACarryForwardPosting.RevenueAccountingContract AS RevenueAccountingContract,
  RACarryForwardPosting.SubLedgerAcctLineItemType AS SubLedgerAcctLineItemType,
  RACarryForwardPosting.PerformanceObligation AS PerformanceObligation,
  cast('0000' as fis_gjahr preserving type) AS FiscalYear,
  RACarryForwardPosting.GLAccount AS GLAccount,
  RACarryForwardPosting.SalesDocumentCurrency AS SalesDocumentCurrency,
  RACarryForwardPosting.CompanyCodeCurrency AS CompanyCodeCurrency,
  RACarryForwardPosting.AdditionalCurrency1 AS AdditionalCurrency1,
  RACarryForwardPosting.AdditionalCurrency2 AS AdditionalCurrency2,
  sum(RACarryForwardPosting.RevnAcctgPostgAmtInSlsDocCrcy) AS RevnAcctgPostgAmtInSlsDocCrcy,
  sum(RACarryForwardPosting.RevnAcctgPostgAmtInCoCodeCrcy) AS RevnAcctgPostgAmtInCoCodeCrcy,
  sum(RACarryForwardPosting.RevnAcctgPostgAmtInAddlCrcy1) AS RevnAcctgPostgAmtInAddlCrcy1,
  sum(RACarryForwardPosting.RevnAcctgPostgAmtInAddlCrcy2) AS RevnAcctgPostgAmtInAddlCrcy2,
  RADeltaPosting._RevenueAccountingContract.RAPostLevelOfContractBalance AS RAPostLevelOfContractBalance
FROM I_RAJournalEntryItem AS RACarryForwardPosting
-- UNION ALL with additional select branch(es): I_RAJournalEntryItem
;

Learn More