Deprecated
This CDS view is deprecated in S/4HANA. View all deprecated CDS views →

P_RRBSalesPricingDynamicItem01

DDL: P_RRBSALESPRICINGDYNAMICITEM01 SQL: PRRBSLSPRDYITM01 Type: view CONSUMPTION Package: PS_BILLING_PROPOSALS
18 Fields 5 Data Sources

CDS version view for journal entry item

P_RRBSalesPricingDynamicItem01 is a Consumption CDS View that provides data about "CDS version view for journal entry item" in SAP S/4HANA. It reads from 5 data sources (I_RRBDynamicItem, I_JournalEntryItem, I_LedgerCA, I_RRBSalesPricingDynamicItem, I_RRBSalesPricingHeader) and exposes 18 fields with key fields Ledger, SourceLedger, CompanyCode, FiscalYear, AccountingDocument. Part of development package PS_BILLING_PROPOSALS.

Data Sources (5)

SourceAliasJoin Type
I_RRBDynamicItem DynamicItem inner
I_JournalEntryItem JournalEntryItem inner
I_LedgerCA LedgerCA inner
I_RRBSalesPricingDynamicItem SalesPricingDynamicItem inner
I_RRBSalesPricingHeader SalesPricingHeader from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PRRBSLSPRDYITM01 view
VDM.private true view
VDM.viewType #CONSUMPTION view
VDM.lifecycle.status #DEPRECATED view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view

Fields (18)

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
ReferenceDocument I_JournalEntryItem ReferenceDocument Reference Document
ReferenceDocumentItem I_JournalEntryItem ReferenceDocumentItem Reference item

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_RRBSalesPricingDynamicItem01.
-- 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: PRRBSLSPRDYITM01

CREATE VIEW P_RRBSalesPricingDynamicItem01 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,
  JournalEntryItem.ReferenceDocument AS ReferenceDocument,
  JournalEntryItem.ReferenceDocumentItem AS ReferenceDocumentItem
FROM I_RRBSalesPricingHeader AS SalesPricingHeader
INNER JOIN I_RRBSalesPricingDynamicItem AS SalesPricingDynamicItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_RRBDynamicItem AS DynamicItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_JournalEntryItem AS JournalEntryItem ON /* join condition not captured in parsed metadata */
INNER JOIN I_LedgerCA AS LedgerCA ON /* join condition not captured in parsed metadata */
;

Learn More