P_RU_CFinVATRevisionDocument

DDL: P_RU_CFINVATREVISIONDOCUMENT SQL: PRUCFINVATREVDOC Type: view CONSUMPTION Package: GLO_FIN_IS_VAT_RU

Central Finance VAT Invoice Revision

P_RU_CFinVATRevisionDocument is a Consumption CDS View that provides data about "Central Finance VAT Invoice Revision" in SAP S/4HANA. It reads from 3 data sources (I_JournalEntry, I_RU_VatCorrectionRevision, I_RU_VatCorrectionRevision) and exposes 11 fields. Part of development package GLO_FIN_IS_VAT_RU.

3 data source(s) 11 fields

Data Sources (3)

SourceAliasJoin Type
I_JournalEntry RevJournalEntry inner
I_RU_VatCorrectionRevision VatCorRev from
I_RU_VatCorrectionRevision VatCorRev union_all

Annotations (6)

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

Fields (11)

KeyFieldSource TableSource FieldDescription
CompanyCode I_RU_VatCorrectionRevision CompanyCode
RevisionInvoice I_RU_VatCorrectionRevision RevisionInvoice
RevisionInvoiceYear I_RU_VatCorrectionRevision RevisionInvoiceYear
RevisionNumber I_RU_VatCorrectionRevision RevisionNumber
RevisionTaxReportingDate I_RU_VatCorrectionRevision RevisionTaxReportingDate
CompanyCode
RevisionInvoice I_JournalEntry AccountingDocument
RevisionInvoiceYear I_JournalEntry FiscalYear
RevisionNumber I_RU_VatCorrectionRevision RevisionNumber
RevisionTaxReportingDate I_RU_VatCorrectionRevision RevisionTaxReportingDate
SenderLogicalSystem I_RU_VatCorrectionRevision SenderLogicalSystem 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUCFINVATREVDOC'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #NOT_REQUIRED
define view P_RU_CFinVATRevisionDocument
  as select from I_RU_VatCorrectionRevision as VatCorRev

{
  VatCorRev.CompanyCode,
  VatCorRev.RevisionInvoice,
  VatCorRev.RevisionInvoiceYear,

  VatCorRev.RevisionNumber,
  VatCorRev.RevisionTaxReportingDate,

  VatCorRev.SenderLogicalSystem
}
where
      RevisionInvoice               <> ''
  and VatCorRev.SenderLogicalSystem =  ''

union all select from I_RU_VatCorrectionRevision as VatCorRev

  inner join          I_JournalEntry             as RevJournalEntry on  RevJournalEntry.SenderLogicalSystem      = VatCorRev.SenderLogicalSystem
                                                                    and RevJournalEntry.SenderCompanyCode        = VatCorRev.CompanyCode
                                                                    and RevJournalEntry.SenderAccountingDocument = VatCorRev.RevisionInvoice
                                                                    and RevJournalEntry.SenderFiscalYear         = VatCorRev.RevisionInvoiceYear

{
  RevJournalEntry.CompanyCode,
  RevJournalEntry.AccountingDocument as RevisionInvoice,
  RevJournalEntry.FiscalYear         as RevisionInvoiceYear,

  VatCorRev.RevisionNumber,
  VatCorRev.RevisionTaxReportingDate,

  VatCorRev.SenderLogicalSystem
}
where
      RevisionInvoice               <> ''
  and VatCorRev.SenderLogicalSystem <> ''

Learn More