P_RRBWrittenOffDynamicItem01

DDL: P_RRBWRITTENOFFDYNAMICITEM01 SQL: PRRBWRTOFFDYIT01 Type: view CONSUMPTION

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

4 data source(s) 18 fields

Data Sources (4)

SourceAliasJoin Type
I_RRBDynamicItem DynamicItem inner
I_RRBDynamicItemTotalFlow DynamicTotalFlow from
I_JournalEntryItem JournalEntryItem inner
I_LedgerCA LedgerCA inner

Annotations (5)

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

Fields (18)

KeyFieldSource TableSource FieldDescription
KEY Ledger I_JournalEntryItem Ledger
KEY SourceLedger I_JournalEntryItem SourceLedger
KEY CompanyCode I_JournalEntryItem CompanyCode
KEY FiscalYear I_JournalEntryItem FiscalYear
KEY AccountingDocument I_JournalEntryItem AccountingDocument
KEY LedgerGLLineItem I_JournalEntryItem LedgerGLLineItem
PostingDate I_JournalEntryItem PostingDate
PartnerCompanyCode I_JournalEntryItem PartnerCompanyCode
ControllingArea I_JournalEntryItem ControllingArea
ControllingObject I_JournalEntryItem ControllingObject
ServicesRenderedDate I_JournalEntryItem ServicesRenderedDate
DocumentDate I_JournalEntryItem DocumentDate
GlobalCurrency I_JournalEntryItem GlobalCurrency
AmountInGlobalCurrency I_JournalEntryItem AmountInGlobalCurrency
TransactionCurrency I_JournalEntryItem TransactionCurrency
AmountInTransactionCurrency I_JournalEntryItem AmountInTransactionCurrency
ReferenceDocument I_JournalEntryItem ReferenceDocument
ReferenceDocumentItem I_JournalEntryItem ReferenceDocumentItem 
@AbapCatalog.sqlViewName: 'PRRBWRTOFFDYIT01'
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED

define view P_RRBWrittenOffDynamicItem01 as select from I_RRBDynamicItemTotalFlow as DynamicTotalFlow

inner join I_RRBDynamicItem   as DynamicItem     on DynamicTotalFlow.RRBDynamicItem = DynamicItem.RRBDynamicItem

inner join I_JournalEntryItem as JournalEntryItem  on JournalEntryItem.AccountingDocument  = DynamicItem.AccountingDocument                                                                                 
                                                   and JournalEntryItem.LedgerGLLineItem    = DynamicItem.LedgerGLLineItem
                                                   and JournalEntryItem.ControllingObject   = DynamicItem.ControllingObject
                                                   and JournalEntryItem.TransactionCurrency = DynamicItem.TransactionCurrency
                                                   and JournalEntryItem.FiscalYear = DynamicItem.FiscalYear
                                                   
inner join I_LedgerCA as LedgerCA on  JournalEntryItem.Ledger = LedgerCA.Ledger
                                   and JournalEntryItem.ControllingArea = LedgerCA.ControllingArea
                                   and LedgerCA.Version                 = '000'
{
  key JournalEntryItem.Ledger,
  key JournalEntryItem.SourceLedger,
  key JournalEntryItem.CompanyCode,
  key JournalEntryItem.FiscalYear,
  key JournalEntryItem.AccountingDocument,
  key JournalEntryItem.LedgerGLLineItem,

      JournalEntryItem.PostingDate,
      JournalEntryItem.PartnerCompanyCode,
      JournalEntryItem.ControllingArea,
      JournalEntryItem.ControllingObject,
      JournalEntryItem.ServicesRenderedDate,
      JournalEntryItem.DocumentDate,      
      /* Measures */
      JournalEntryItem.GlobalCurrency,
      JournalEntryItem.AmountInGlobalCurrency        as AmountInGlobalCurrency,
      JournalEntryItem.TransactionCurrency,
      JournalEntryItem.AmountInTransactionCurrency   as AmountInTransactionCurrency,
      
      JournalEntryItem.ReferenceDocument             as ReferenceDocument,
      JournalEntryItem.ReferenceDocumentItem         as ReferenceDocumentItem
       
}

Learn More