P_RABalMvtDirectPostingAmtQtr

DDL: P_RABALMVTDIRECTPOSTINGAMTQTR Type: view_entity COMPOSITE
67 Fields 4 Data Sources

P_RABalMvtDirectPostingAmtQtr is a Composite CDS View in SAP S/4HANA. It reads from 4 data sources (I_RAJournalEntryItem, I_RAJournalEntryItem, I_RAJournalEntryItem, I_RAJournalEntryItem) and exposes 67 fields with key fields CompanyCode, AccountingPrinciple, RevenueAccountingContract, RevnAcctgPostingCategory, PerformanceObligation.

Data Sources (4)

SourceAliasJoin Type
I_RAJournalEntryItem _RAJournalEntryItem from
I_RAJournalEntryItem _RAJournalEntryItem union_all
I_RAJournalEntryItem _RAJournalEntryItem union_all
I_RAJournalEntryItem _RAJournalEntryItem 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 #XXL view
ObjectModel.usageType.dataClass #MIXED view
VDM.private true view
VDM.viewType #COMPOSITE view

Fields (67)

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 RevnAcctgPostingCategory I_RAJournalEntryItem RevnAcctgPostingCategory
KEY PerformanceObligation I_RAJournalEntryItem PerformanceObligation Performance Obligation
KEY FiscalYear G/L Fiscal Year
KEY FiscalQuarter
FiscalYearVariant I_RAJournalEntryItem FiscalYearVariant FY Variant
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
CompanyCode Receiver Company Code
KEY AccountingPrinciple I_RAJournalEntryItem AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract I_RAJournalEntryItem RevenueAccountingContract Revenue Contract
KEY RevnAcctgPostingCategory I_RAJournalEntryItem RevnAcctgPostingCategory
KEY PerformanceObligation Performance Obligation
KEY FiscalYear G/L Fiscal Year
KEY FiscalQuarter
FiscalYearVariant I_RAJournalEntryItem FiscalYearVariant FY Variant
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
P_FiscalYearFrom
P_FiscalPeriodFrom
P_FiscalYearTo
CompanyCode Receiver Company Code
KEY AccountingPrinciple I_RAJournalEntryItem AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract I_RAJournalEntryItem RevenueAccountingContract Revenue Contract
KEY RevnAcctgPostingCategory I_RAJournalEntryItem RevnAcctgPostingCategory
KEY PerformanceObligation I_RAJournalEntryItem PerformanceObligation Performance Obligation
KEY FiscalYear I_RAJournalEntryItem FiscalYear G/L Fiscal Year
KEY FiscalQuarter _RAContrBalFiscalPeriodSel FiscalQuarter
FiscalYearVariant I_RAJournalEntryItem FiscalYearVariant FY Variant
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
P_FiscalYearFrom
P_FiscalPeriodFrom
P_FiscalYearTo
CompanyCode Receiver Company Code
KEY AccountingPrinciple I_RAJournalEntryItem AccountingPrinciple AP Ledger/CoCode
KEY RevenueAccountingContract I_RAJournalEntryItem RevenueAccountingContract Revenue Contract
KEY RevnAcctgPostingCategory I_RAJournalEntryItem RevnAcctgPostingCategory
KEY PerformanceObligation Performance Obligation
KEY FiscalYear I_RAJournalEntryItem FiscalYear G/L Fiscal Year
KEY FiscalQuarter _RAContrBalFiscalPeriodSel FiscalQuarter
FiscalYearVariant I_RAJournalEntryItem FiscalYearVariant FY Variant
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

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_RABalMvtDirectPostingAmtQtr.
-- 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_RABalMvtDirectPostingAmtQtr AS
SELECT
  _RAJournalEntryItem.CompanyCode AS CompanyCode,
  _RAJournalEntryItem.AccountingPrinciple AS AccountingPrinciple,
  _RAJournalEntryItem.RevenueAccountingContract AS RevenueAccountingContract,
  _RAJournalEntryItem.RevnAcctgPostingCategory AS RevnAcctgPostingCategory,
  _RAJournalEntryItem.PerformanceObligation AS PerformanceObligation,
  cast('0000' as fis_gjahr preserving type) AS FiscalYear,
  cast('0' as fins_fscalquarter preserving type) AS FiscalQuarter,
  _RAJournalEntryItem.FiscalYearVariant AS FiscalYearVariant,
  _RAJournalEntryItem.SalesDocumentCurrency AS SalesDocumentCurrency,
  _RAJournalEntryItem.CompanyCodeCurrency AS CompanyCodeCurrency,
  _RAJournalEntryItem.AdditionalCurrency1 AS AdditionalCurrency1,
  _RAJournalEntryItem.AdditionalCurrency2 AS AdditionalCurrency2,
  sum(_RAJournalEntryItem.RevnAcctgPostgAmtInSlsDocCrcy) AS RevnAcctgPostgAmtInSlsDocCrcy,
  sum(_RAJournalEntryItem.RevnAcctgPostgAmtInCoCodeCrcy) AS RevnAcctgPostgAmtInCoCodeCrcy,
  sum(_RAJournalEntryItem.RevnAcctgPostgAmtInAddlCrcy1) AS RevnAcctgPostgAmtInAddlCrcy1,
  sum(_RAJournalEntryItem.RevnAcctgPostgAmtInAddlCrcy2) as RevnAcctgPostgAmtInAddlCrcy2 AS P_FiscalYearFrom,
  P_FiscalPeriodFrom: $parameters.P_FiscalPeriodFrom AS P_FiscalPeriodFrom,
  P_FiscalYearTo: $parameters.P_FiscalYearTo AS P_FiscalYearTo,
  sum(_RAJournalEntryItem.RevnAcctgPostgAmtInAddlCrcy2) AS RevnAcctgPostgAmtInAddlCrcy2
FROM I_RAJournalEntryItem AS _RAJournalEntryItem
-- UNION ALL with additional select branch(es): I_RAJournalEntryItem
;

Learn More