P_RU_CFinVATRevisionDocument

DDL: P_RU_CFINVATREVISIONDOCUMENT SQL: PRUCFINVATREVDOC Type: view CONSUMPTION

P_RU_CFinVATRevisionDocument is a Consumption CDS View in SAP S/4HANA. It reads from 3 data sources (I_JournalEntry, I_RU_VatCorrectionRevision, I_RU_VatCorrectionRevision) and exposes 11 fields.

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 <> ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"I_RU_VATCORRECTIONREVISION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More