P_RRBDynamicItemFlow03

DDL: P_RRBDYNAMICITEMFLOW03 SQL: PRRBDYNITMFLW03 Type: view CONSUMPTION
16 Fields 2 Data Sources

P_RRBDynamicItemFlow03 is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_JournalEntryItem, I_LedgerCA) and exposes 16 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument.

Data Sources (2)

SourceAliasJoin Type
I_JournalEntryItem JournalEntryItem from
I_LedgerCA LedgerCA inner

Annotations (5)

NameValueLevelField
AbapCatalog.sqlViewName PRRBDYNITMFLW03 view
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_JournalEntryItem Ledger Ledger
KEY SourceLedger I_JournalEntryItem SourceLedger Source Ledger
KEY CompanyCode I_JournalEntryItem CompanyCode Receiver Company Code
KEY FiscalYear I_JournalEntryItem FiscalYear G/L Fiscal Year
KEY AccountingDocument I_JournalEntryItem AccountingDocument Journal Entry
KEY LedgerGLLineItem I_JournalEntryItem LedgerGLLineItem Journal Entry Item
PostingDate I_JournalEntryItem PostingDate Posting Date for GR
PartnerCompanyCode I_JournalEntryItem PartnerCompanyCode Partner Company Code
ControllingArea I_JournalEntryItem ControllingArea Controlling Area
ControllingObject I_JournalEntryItem ControllingObject Object number
ServicesRenderedDate I_JournalEntryItem ServicesRenderedDate Services Rendered Date
DocumentDate I_JournalEntryItem DocumentDate Journal Entry Date
GlobalCurrency I_JournalEntryItem GlobalCurrency GM Billing Element: Global Currency
AmountInGlobalCurrency I_JournalEntryItem AmountInGlobalCurrency Amount in Global Currency
TransactionCurrency I_JournalEntryItem TransactionCurrency Transaction Currency
AmountInTransactionCurrency I_JournalEntryItem AmountInTransactionCurrency Pt Crcy Amt

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_RRBDynamicItemFlow03.
-- 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: PRRBDYNITMFLW03

CREATE VIEW P_RRBDynamicItemFlow03 AS
SELECT
  JournalEntryItem.Ledger AS Ledger,
  JournalEntryItem.SourceLedger AS SourceLedger,
  JournalEntryItem.CompanyCode AS CompanyCode,
  JournalEntryItem.FiscalYear AS FiscalYear,
  JournalEntryItem.AccountingDocument AS AccountingDocument,
  JournalEntryItem.LedgerGLLineItem AS LedgerGLLineItem,
  JournalEntryItem.PostingDate AS PostingDate,
  JournalEntryItem.PartnerCompanyCode AS PartnerCompanyCode,
  JournalEntryItem.ControllingArea AS ControllingArea,
  JournalEntryItem.ControllingObject AS ControllingObject,
  JournalEntryItem.ServicesRenderedDate AS ServicesRenderedDate,
  JournalEntryItem.DocumentDate AS DocumentDate,
  JournalEntryItem.GlobalCurrency AS GlobalCurrency,
  JournalEntryItem.AmountInGlobalCurrency AS AmountInGlobalCurrency,
  JournalEntryItem.TransactionCurrency AS TransactionCurrency,
  JournalEntryItem.AmountInTransactionCurrency AS AmountInTransactionCurrency
FROM I_JournalEntryItem AS JournalEntryItem
INNER JOIN I_LedgerCA AS LedgerCA ON /* join condition not captured in parsed metadata */
;

Learn More