P_CNSLDTNJRNLENTRYMAXITEM

CDS View

P_CNSLDTNJRNLENTRYMAXITEM is a CDS View in S/4HANA. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
P_CnsldtnJrnlEntryTP view inner BASIC 
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.sqlViewName: 'PJRNLENTRMI'
@AbapCatalog.compiler.compareFilter: true
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.private:true
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.dataClass: #MIXED
@ObjectModel.usageType.sizeCategory: #XL
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Metadata.ignorePropagatedAnnotations: true
define view P_CnsldtnJrnlEntryMaxItem
  as select from acdocu
{
  key    rldnr                                                                                        as ConsolidationLedger,
  key    rdimen                                                                                       as ConsolidationDimension,
  key    ryear                                                                                        as FiscalYear,
  key    docnr                                                                                        as ConsolidationDocumentNumber,
         max( docln )                                                                                 as ConsolidationPostingItem
}
where
  (
       plevl = '01'
    or plevl = '0C'
    or plevl = '10'
    or plevl = '20'
    or plevl = '30'
  )
  and  rrcty = '0'
group by
  ryear,
  docnr,
  rldnr,
  rdimen;
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ACDOCU"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More