P_RU_PseudoReversedDocument

DDL: P_RU_PSEUDOREVERSEDDOCUMENT SQL: PRUPREVERSEDDOC Type: view CONSUMPTION

P_RU_PseudoReversedDocument is a Consumption CDS View in SAP S/4HANA. It reads from 2 data sources (P_RU_CFinPseudoReversedDoc1, I_JournalEntry) and exposes 21 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

2 data source(s) 21 fields

Data Sources (2)

SourceAliasJoin Type
P_RU_CFinPseudoReversedDoc1 ReversalDoc from
I_JournalEntry ReversedDoc inner

Annotations (10)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUPREVERSEDDOC view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #XXL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY AccountingDocument I_JournalEntry AccountingDocument
KEY FiscalYear I_JournalEntry FiscalYear
AccountingDocumentType I_JournalEntry AccountingDocumentType
PostingDate I_JournalEntry PostingDate
TaxReportingDate I_JournalEntry TaxReportingDate
DocumentReferenceID I_JournalEntry DocumentReferenceID
IsReversal
IsReversed
ReversalDocument P_RU_CFinPseudoReversedDoc1 AccountingDocument
ReversalDocumentFiscalYear P_RU_CFinPseudoReversedDoc1 FiscalYear
ReversalDocumentType P_RU_CFinPseudoReversedDoc1 AccountingDocumentType
ReversalDocumentPostingDate P_RU_CFinPseudoReversedDoc1 PostingDate
ReversalDocumentTaxRepDate P_RU_CFinPseudoReversedDoc1 TaxReportingDate
ReversalDocumentReferenceID P_RU_CFinPseudoReversedDoc1 DocumentReferenceID
ReversalDocumentIsReversal P_RU_CFinPseudoReversedDoc1 IsReversal
ReversalDocumentIsReversed P_RU_CFinPseudoReversedDoc1 IsReversed
ReversalDocumentCntrySpecRef2 P_RU_CFinPseudoReversedDoc1 JrnlEntryCntrySpecificRef2
LedgerGroup I_JournalEntry LedgerGroup
CompanyCodeCurrency I_JournalEntry CompanyCodeCurrency
RU_ReverseType 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUPREVERSEDDOC'
@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_PseudoReversedDocument
  as select from P_RU_CFinPseudoReversedDoc1 as ReversalDoc
  //  as select from P_RU_PseudoReversedDocument1 as ReversalDoc

    inner join   I_JournalEntry              as ReversedDoc on  ReversedDoc.CompanyCode        = ReversalDoc.CompanyCode
                                                            and ReversedDoc.AccountingDocument = ReversalDoc.OriginalAccountingDocument
                                                            and ReversedDoc.FiscalYear         = ReversalDoc.OriginalFiscalYear
{
  key ReversedDoc.CompanyCode,

  key ReversedDoc.AccountingDocument,
  key ReversedDoc.FiscalYear,
      ReversedDoc.AccountingDocumentType,
      ReversedDoc.PostingDate,
      ReversedDoc.TaxReportingDate,
      ReversedDoc.DocumentReferenceID,
      cast (''  as fins_xreversing preserving type ) as IsReversal,
      cast ('X' as fins_xreversed  preserving type ) as IsReversed,

      ReversalDoc.AccountingDocument                 as ReversalDocument,
      ReversalDoc.FiscalYear                         as ReversalDocumentFiscalYear,
      ReversalDoc.AccountingDocumentType             as ReversalDocumentType,
      ReversalDoc.PostingDate                        as ReversalDocumentPostingDate,
      ReversalDoc.TaxReportingDate                   as ReversalDocumentTaxRepDate,
      ReversalDoc.DocumentReferenceID                as ReversalDocumentReferenceID,
      ReversalDoc.IsReversal                         as ReversalDocumentIsReversal,
      ReversalDoc.IsReversed                         as ReversalDocumentIsReversed,
      ReversalDoc.JrnlEntryCntrySpecificRef2         as ReversalDocumentCntrySpecRef2,

      ReversedDoc.LedgerGroup,
      ReversedDoc.CompanyCodeCurrency,
      'PSVD'                                         as RU_ReverseType
}
where
      ReversedDoc.IsReversal = ''
  and ReversedDoc.IsReversed = ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY",
"P_RU_CFINPSEUDOREVERSEDDOC1"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More