P_RU_REVERSEDDOCUMENT

CDS View

Reversed Document

P_RU_REVERSEDDOCUMENT is a CDS View in S/4HANA. Reversed Document. 2 CDS views read from this table.

Used by 2 CDS view(s)

CDS Views using this table (2)

ViewTypeJoinVDMDescription
P_RU_CommissionTradeInvoice10 view_entity union_all CONSUMPTION Comission Trade Invoices - Alternative 0
P_RU_ReverseDocument view from CONSUMPTION Reverse Document 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUREVERSEDDOC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
    serviceQuality: #B,
    sizeCategory: #XXL,
    dataClass: #TRANSACTIONAL
}
define view P_RU_ReversedDocument
  as select from P_RU_RealReversedDocument

{
  key CompanyCode,

  key AccountingDocument,
  key FiscalYear,
      AccountingDocumentType,
      PostingDate,
      TaxReportingDate,
      DocumentReferenceID,
      IsReversal,
      IsReversed,
      ReversalDocumentBKPF           as ReverseDocumentBKPF,
      ReversalDocumentFiscalYearBKPF as ReverseDocumentFiscalYearBKPF,

      ReversalDocument               as ReverseDocument,
      ReversalDocumentFiscalYear     as ReverseDocumentFiscalYear,
      ReversalDocumentType           as ReverseDocumentType,
      ReversalDocumentPostingDate    as ReverseDocumentPostingDate,
      ReversalDocumentTaxRepDate     as ReverseDocumentTaxRepDate,
      ReversalDocumentReferenceID    as ReverseDocumentReferenceID,
      ReversalDocumentIsReversal     as ReverseDocumentIsReversal,
      ReversalDocumentIsReversed     as ReverseDocumentIsReversed,

      LedgerGroup,
      CompanyCodeCurrency,
      RU_ReverseType
}

union all select from P_RU_PseudoReversedDocument

{
  key CompanyCode,

  key AccountingDocument,
  key FiscalYear,
      AccountingDocumentType,
      PostingDate,
      TaxReportingDate,
      DocumentReferenceID,
      IsReversal,
      IsReversed,
      ''                          as ReverseDocumentBKPF,
      '0000'                      as ReverseDocumentFiscalYearBKPF,

      ReversalDocument            as ReverseDocument,
      ReversalDocumentFiscalYear  as ReverseDocumentFiscalYear,
      ReversalDocumentType        as ReverseDocumentType,
      ReversalDocumentPostingDate as ReverseDocumentPostingDate,
      ReversalDocumentTaxRepDate  as ReverseDocumentTaxRepDate,
      ReversalDocumentReferenceID as ReverseDocumentReferenceID,
      ReversalDocumentIsReversal  as ReverseDocumentIsReversal,
      ReversalDocumentIsReversed  as ReverseDocumentIsReversed,

      LedgerGroup,
      CompanyCodeCurrency,
      RU_ReverseType
}

Learn More