P_RU_JrnlEntrRvsdNeg

DDL: P_RU_JRNLENTRRVSDNEG SQL: PRUJRNLENTRVSDNG Type: view CONSUMPTION

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

1 data source(s) 5 fields

Data Sources (1)

SourceAliasJoin Type
I_JournalEntry I_JournalEntry from

Parameters (2)

NameTypeDefault
P_FromPostingDate fis_budat_from
P_ToPostingDate fis_budat_to

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName PRUJRNLENTRVSDNG view
VDM.viewType #CONSUMPTION view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.buffering.status #NOT_ALLOWED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY CompanyCode I_JournalEntry CompanyCode
KEY FiscalYear I_JournalEntry FiscalYear
KEY AccountingDocument I_JournalEntry AccountingDocument
DocRefNum
DocRefYear 
@AbapCatalog.sqlViewName: 'PRUJRNLENTRVSDNG'
@VDM.viewType: #CONSUMPTION
@VDM.private:true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.buffering.status: #NOT_ALLOWED
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.dataClass:  #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AbapCatalog.preserveKey:true 
@AbapCatalog.compiler.compareFilter:true 

define view P_RU_JrnlEntrRvsdNeg
  with parameters
    P_FromPostingDate : fis_budat_from,
    P_ToPostingDate   : fis_budat_to

  as select from I_JournalEntry
{


  key I_JournalEntry.CompanyCode,
  key I_JournalEntry.FiscalYear,
  key I_JournalEntry.AccountingDocument,

      substring(I_JournalEntry.JrnlEntryCntrySpecificRef2, 5, 10) as DocRefNum,

      substring(I_JournalEntry.JrnlEntryCntrySpecificRef2, 15, 4) as DocRefYear


}
where
  JrnlEntryCntrySpecificRef2 like 'NEG^%' 
  and   I_JournalEntry.PostingDate             >= $parameters.P_FromPostingDate
  and  I_JournalEntry.PostingDate             <= $parameters.P_ToPostingDate
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_JOURNALENTRY"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More