FINCS_UH_POSTINGLEVEL

DDL: FINCS_UH_POSTINGLEVEL SQL: FINCS_UH_PLEVL Type: view

Consolidation Posting Level

FINCS_UH_POSTINGLEVEL is a CDS View that provides data about "Consolidation Posting Level" in SAP S/4HANA. It reads from 1 data source (I_CnsldtnPostingLevel) and exposes 1 field.

Data Sources (1)

SourceAliasJoin Type
I_CnsldtnPostingLevel I_CnsldtnPostingLevel from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName FINCS_UH_PLEVL view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Consolidation Posting Level view

Fields (1)

KeyFieldSource TableSource FieldDescription
PostingLevelText
@AbapCatalog.sqlViewName: 'FINCS_UH_PLEVL'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: {
  dataClass: #MASTER,
  serviceQuality: #C,
  sizeCategory: #M
}
@EndUserText.label: 'Consolidation Posting Level'
define view FINCS_UH_POSTINGLEVEL as select from I_CnsldtnPostingLevel {
  key 
  case PostingLevel
     when ''
       then '#'
     else 
       PostingLevel
   end as PostingLevel,  
  _Text[1:Language = $session.system_language].PostingLevelText
} where ConsolidationReportingLevel <> '' and PostingLevel <> '0T'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CNSLDTNPOSTINGLEVEL",
"I_CNSLDTNPOSTINGLEVELT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/