P_RU_Invoice

DDL: P_RU_INVOICE SQL: PRUINVOICE Type: view CONSUMPTION

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

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
I_OperationalAcctgDocItem AccDocItem inner
P_RU_Invoice2 Invoice from

Annotations (6)

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

Fields (5)

KeyFieldSource TableSource FieldDescription
CompanyCode P_RU_Invoice2 CompanyCode
AccountingDocument P_RU_Invoice2 AccountingDocument
FiscalYear P_RU_Invoice2 FiscalYear
ClearingAccountingDocument I_OperationalAcctgDocItem ClearingJournalEntry
ClearingDocFiscalYear I_OperationalAcctgDocItem ClearingJournalEntryFiscalYear 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUINVOICE'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_Invoice
  as select from P_RU_Invoice2             as Invoice
    inner join   I_OperationalAcctgDocItem as AccDocItem on  AccDocItem.CompanyCode            = Invoice.CompanyCode
                                                         and AccDocItem.AccountingDocument     = Invoice.AccountingDocument
                                                         and AccDocItem.FiscalYear             = Invoice.FiscalYear
                                                         and (
                                                            AccDocItem.FinancialAccountType    = 'D'
                                                            or AccDocItem.FinancialAccountType = 'K'
                                                          )

{
  Invoice.CompanyCode,
  Invoice.AccountingDocument,
  Invoice.FiscalYear,
  AccDocItem.ClearingJournalEntry as ClearingAccountingDocument,
  AccDocItem.ClearingJournalEntryFiscalYear as ClearingDocFiscalYear 
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_OPERATIONALACCTGDOCITEM",
"P_RU_INVOICE2"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More