P_RU_BUSPARTNERCLEARING

CDS View

P_RU_BUSPARTNERCLEARING is a CDS View in S/4HANA. It contains 13 fields. 2 CDS views read from this table.

Used by 2 CDS view(s) 13 fields

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_BusPartnerClearingNotRvsd view from CONSUMPTION
P_RU_VATInvoiceClearingChain2 view inner CONSUMPTION

Fields (13)

KeyField CDS FieldsUsed in Views
KEY ClearingAccountingDocument ClearingAccountingDocument 2
KEY ClearingFiscalYear ClearingFiscalYear 2
KEY ClearingInfoCompanyCode ClearingInfoCompanyCode 1
KEY ClearingInformationIndex ClearingInformationIndex 2
AccountingDocument AccountingDocument,ClearedAccountingDocument 2
AccountingDocumentItem AccountingDocumentItem,ClearedAccountingDocumentItem 2
AccountType AccountType,ClearedAccountType 2
ClearingInformationType ClearingInformationType 2
CompanyCode CompanyCode 1
DebitCreditCode DebitCreditCode 1
FiscalYear ClearedFiscalYear,FiscalYear 2
SpecialGLCode SpecialGLCode 1
TransactionCurrency TransactionCurrency 1 
@AbapCatalog.sqlViewName: 'PRUBPCLR'
@AbapCatalog.preserveKey: true
@AbapCatalog.compiler.compareFilter: true
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_BusPartnerClearing
  as select from I_ClrgInfoRelationForAcctgDoc

{
  key ClearingInfoCompanyCode,
  key ClearingAccountingDocument,
  key ClearingFiscalYear,
  key ClearingInformationIndex,

      TransactionCurrency,
      ClearingInformationType,

      CompanyCode,
      AccountingDocument,
      FiscalYear,
      AccountingDocumentItem,

      DebitCreditCode,
      AccountType,
      SpecialGLCode
}
where
  (
       AccountType         =  'K'
    or AccountType         =  'D'
  )
  and  TransactionCurrency <> '' //it is empty for clearing during reversing

Learn More