P_RU_VATInvoiceClearingPR

DDL: P_RU_VATINVOICECLEARINGPR SQL: PRUVATINVCLRPR Type: view CONSUMPTION

P_RU_VATInvoiceClearingPR is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (I_JournalEntry, I_OperationalAcctgDocItem) and exposes 12 fields.

2 data source(s) 12 fields

Data Sources (2)

SourceAliasJoin Type
I_JournalEntry ClearingHeader inner
I_OperationalAcctgDocItem InvClearingItem from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUVATINVCLRPR view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (12)

KeyFieldSource TableSource FieldDescription
CompanyCode I_OperationalAcctgDocItem CompanyCode
AccountingDocument I_OperationalAcctgDocItem InvoiceReference
FiscalYear I_OperationalAcctgDocItem InvoiceReferenceFiscalYear
AccountingDocumentItem I_OperationalAcctgDocItem InvoiceItemReference
AccountType I_OperationalAcctgDocItem FinancialAccountType
ClearingAccountingDocument I_OperationalAcctgDocItem AccountingDocument
ClearingFiscalYear I_OperationalAcctgDocItem FiscalYear
ClearingInformationIndex
ClearingInformationType
ClearedAccountingDocument I_OperationalAcctgDocItem AccountingDocument
ClearedFiscalYear I_OperationalAcctgDocItem FiscalYear
ClearingLevel 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUVATINVCLRPR'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
define view P_RU_VATInvoiceClearingPR
  as select from I_OperationalAcctgDocItem as InvClearingItem

    inner join   I_JournalEntry            as ClearingHeader on  ClearingHeader.CompanyCode        = InvClearingItem.CompanyCode
                                                             and ClearingHeader.AccountingDocument = InvClearingItem.AccountingDocument
                                                             and ClearingHeader.FiscalYear         = InvClearingItem.FiscalYear

{
  InvClearingItem.CompanyCode,
  InvClearingItem.InvoiceReference           as AccountingDocument,
  InvClearingItem.InvoiceReferenceFiscalYear as FiscalYear,
  InvClearingItem.InvoiceItemReference       as AccountingDocumentItem,
  InvClearingItem.FinancialAccountType       as AccountType,

  InvClearingItem.AccountingDocument         as ClearingAccountingDocument,
  InvClearingItem.FiscalYear                 as ClearingFiscalYear,
  '      '                                   as ClearingInformationIndex,
  ' '                                        as ClearingInformationType,

  InvClearingItem.AccountingDocument         as ClearedAccountingDocument,
  InvClearingItem.FiscalYear                 as ClearedFiscalYear,

  'P'                                        as ClearingLevel
}
where
      InvClearingItem.FollowOnDocumentType       =  'P'
  and InvClearingItem.AccountingDocumentCategory <> 'S'
  and ClearingHeader.IsReversed                  =  ''

Learn More