P_RU_BusPartnerClearingNotRvsd

DDL: P_RU_BUSPARTNERCLEARINGNOTRVSD SQL: PRUBPCLRNR Type: view CONSUMPTION

P_RU_BusPartnerClearingNotRvsd is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_RU_BusPartnerClearing, I_JournalEntry) and exposes 13 fields with key fields ClearingInfoCompanyCode, ClearingAccountingDocument, ClearingFiscalYear, ClearingInformationIndex.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
P_RU_BusPartnerClearing ClearedBPItem from
I_JournalEntry ClearingAccDocHeader inner

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PRUBPCLRNR view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
VDM.private true view
VDM.viewType #CONSUMPTION view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY ClearingInfoCompanyCode P_RU_BusPartnerClearing ClearingInfoCompanyCode
KEY ClearingAccountingDocument P_RU_BusPartnerClearing ClearingAccountingDocument
KEY ClearingFiscalYear P_RU_BusPartnerClearing ClearingFiscalYear
KEY ClearingInformationIndex P_RU_BusPartnerClearing ClearingInformationIndex
TransactionCurrency P_RU_BusPartnerClearing TransactionCurrency
ClearingInformationType P_RU_BusPartnerClearing ClearingInformationType
CompanyCode P_RU_BusPartnerClearing CompanyCode
AccountingDocument P_RU_BusPartnerClearing AccountingDocument
FiscalYear P_RU_BusPartnerClearing FiscalYear
AccountingDocumentItem P_RU_BusPartnerClearing AccountingDocumentItem
DebitCreditCode P_RU_BusPartnerClearing DebitCreditCode
AccountType P_RU_BusPartnerClearing AccountType
SpecialGLCode P_RU_BusPartnerClearing SpecialGLCode 
@AbapCatalog.sqlViewName: 'PRUBPCLRNR'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_BusPartnerClearingNotRvsd
  as select from P_RU_BusPartnerClearing as ClearedBPItem

    inner join   I_JournalEntry          as ClearingAccDocHeader on  ClearingAccDocHeader.CompanyCode        = ClearedBPItem.CompanyCode
                                                                 and ClearingAccDocHeader.AccountingDocument = ClearedBPItem.ClearingAccountingDocument
                                                                 and ClearingAccDocHeader.FiscalYear         = ClearedBPItem.ClearingFiscalYear

{
  key ClearedBPItem.ClearingInfoCompanyCode,
  key ClearedBPItem.ClearingAccountingDocument,
  key ClearedBPItem.ClearingFiscalYear,
  key ClearedBPItem.ClearingInformationIndex,

      ClearedBPItem.TransactionCurrency,
      ClearedBPItem.ClearingInformationType,

      ClearedBPItem.CompanyCode,
      ClearedBPItem.AccountingDocument,
      ClearedBPItem.FiscalYear,
      ClearedBPItem.AccountingDocumentItem,

      ClearedBPItem.DebitCreditCode,
      ClearedBPItem.AccountType,
      ClearedBPItem.SpecialGLCode
}
where
      ClearingAccDocHeader.IsReversal = ''
  and ClearingAccDocHeader.IsReversed = ''

Learn More