P_RU_PseudoReversedDocument1

DDL: P_RU_PSEUDOREVERSEDDOCUMENT1 SQL: PRUPREVERSEDDOC1 Type: view CONSUMPTION

P_RU_PseudoReversedDocument1 is a Consumption CDS View in SAP S/4HANA. It reads from 1 data source (I_JournalEntry) and exposes 16 fields with key fields CompanyCode, AccountingDocument, FiscalYear.

1 data source(s) 16 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry I_JournalEntry from

Annotations (7)

NameValueLevelField
VDM.private true view
VDM.viewType #CONSUMPTION view
AbapCatalog.sqlViewName PRUPREVERSEDDOC1 view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode CompanyCode
KEY AccountingDocument AccountingDocument
KEY FiscalYear FiscalYear
AccountingDocumentType AccountingDocumentType
PostingDate PostingDate
TaxReportingDate TaxReportingDate
DocumentReferenceID DocumentReferenceID
IsReversal
IsReversed
JrnlEntryCntrySpecificRef2 JrnlEntryCntrySpecificRef2
OriginalAccountingDocument
OriginalFiscalYear
SenderLogicalSystem SenderLogicalSystem
SenderCompanyCode SenderCompanyCode
SenderAccountingDocument SenderAccountingDocument
SenderFiscalYear SenderFiscalYear 
@VDM.private: true
@VDM.viewType: #CONSUMPTION
@AbapCatalog.sqlViewName: 'PRUPREVERSEDDOC1'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
define view P_RU_PseudoReversedDocument1
  as select from I_JournalEntry

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

      JrnlEntryCntrySpecificRef2,
      substring(JrnlEntryCntrySpecificRef2, 5, 10)   as OriginalAccountingDocument,
      substring(JrnlEntryCntrySpecificRef2, 15, 4)   as OriginalFiscalYear,

      SenderLogicalSystem,
      SenderCompanyCode,
      SenderAccountingDocument,
      SenderFiscalYear
}
where
      JrnlEntryCntrySpecificRef2 like 'NEG^%'
  and IsReversal                 =    ''
  and IsReversed                 =    ''
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More