P_CC_DefaultGlobalParameter

DDL: P_CC_DEFAULTGLOBALPARAMETER SQL: PCCGLOBALPARAM00 Type: view BASIC

P_CC_DefaultGlobalParameter is a Basic CDS View in SAP S/4HANA. It reads from 2 data sources (t000, tf004) and exposes 8 fields.

2 data source(s) 8 fields

Data Sources (2)

SourceAliasJoin Type
t000 t000 from
tf004 tf004 left_outer

Annotations (5)

NameValueLevelField
VDM.viewType #BASIC view
VDM.private true view
AccessControl.authorizationCheck #NOT_REQUIRED view
AbapCatalog.sqlViewName PCCGLOBALPARAM00 view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
CnsldtnDimension
CnsldtnChartOfAccounts
CnsldtnLedger
CnsldtnVersion
FiscalYear
FiscalPeriod
CnsldtnGroup
CnsldtnUnit 
@VDM.viewType: #BASIC
@VDM.private: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@AbapCatalog.sqlViewName: 'PCCGLOBALPARAM00'
@ClientHandling.algorithm: #SESSION_VARIABLE

define view P_CC_DefaultGlobalParameter 
as select from t000 t1 left outer join tf004 t2 on t2.uname = $session.user
{
    coalesce(t2.dimen, 'Y1') as CnsldtnDimension,
    coalesce(t2.itclg, '')   as CnsldtnChartOfAccounts,
    coalesce(t2.rldnr, 'Y1') as CnsldtnLedger,
    coalesce(t2.rvers, '')   as CnsldtnVersion,
    coalesce(t2.ryear, '')   as FiscalYear,
    coalesce(t2.perid, '')   as FiscalPeriod,
    coalesce(t2.congr, '')   as CnsldtnGroup,
    coalesce(t2.bunit, '')   as CnsldtnUnit    
} 
 where t1.mandt = $session.client
;
  
  
  
  
 
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T000",
"TF004"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"VERSION":0
}
}*/

Learn More