C_EntProjControllingAreaVH

DDL: C_ENTPROJCONTROLLINGAREAVH SQL: CEPCTRLNGAREAVH Type: view CONSUMPTION Package: ODATA_PPM_COMMON_UI

Controlling Area Value Help

C_EntProjControllingAreaVH is a Consumption CDS View that provides data about "Controlling Area Value Help" in SAP S/4HANA. It reads from 2 data sources (I_FinancialStatementHierT, I_ControllingArea) and exposes 16 fields with key field ControllingArea. Part of development package ODATA_PPM_COMMON_UI.

2 data source(s) 16 fields

Data Sources (2)

SourceAliasJoin Type
I_FinancialStatementHierT FinStateT left_outer
I_ControllingArea I_ControllingArea from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName CEPCTRLNGAREAVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
EndUserText.label Controlling Area Value Help view
VDM.viewType #CONSUMPTION view
AccessControl.authorizationCheck #NOT_REQUIRED view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #S view
Search.searchable true view
Consumption.ranked true view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea ControllingArea
FiscalYearVariant FiscalYearVariant
ControllingAreaName ControllingAreaName
ControllingAreaCurrency ControllingAreaCurrency
ChartOfAccounts ChartOfAccounts
CostCenterStandardHierarchy CostCenterStandardHierarchy Cost Center Standard Hierarchy
ProfitCenterStandardHierarchy ProfitCenterStandardHierarchy
FinancialManagementArea FinancialManagementArea
ControllingAreaCurrencyRole ControllingAreaCurrencyRole
CtrlgStdFinStatementVersion CtrlgStdFinStatementVersion
FinancialStmntHierarchyName I_FinancialStatementHierT FinancialStmntHierarchyName Hierarchy Description
ProfitCenterAccountingCurrency ProfitCenterAccountingCurrency Profit Center Local Currency
_ChartOfAccounts _ChartOfAccounts
_ChartOfAccountsText _ChartOfAccountsText
_Currency _Currency
_FinancialStatementVersion _FinancialStatementVersion 
@AbapCatalog.sqlViewName: 'CEPCTRLNGAREAVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@EndUserText.label: 'Controlling Area Value Help'

@VDM.viewType: #CONSUMPTION
// Authorization handling

@AccessControl: {
  authorizationCheck: #NOT_REQUIRED,
  personalData.blocking: #BLOCKED_DATA_EXCLUDED
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType: {
  dataClass: #CUSTOMIZING,
  serviceQuality: #B,
  sizeCategory: #S
}
@Search.searchable: true
@Consumption.ranked: true

define view C_EntProjControllingAreaVH as 
    select from I_ControllingArea 
        left outer join I_FinancialStatementHierT as FinStateT         
            on  CtrlgStdFinStatementVersion = FinStateT.FinancialStatementHierarchy
            and FinStateT.Language = $session.system_language
            and FinStateT.ValidityStartDate <= $session.system_date 
            and FinStateT.ValidityEndDate   >= $session.system_date 
{
  @Search.defaultSearchElement: true
  @Search.ranking: #HIGH
  //I_ControllingArea 

  key ControllingArea, 
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  FiscalYearVariant, 
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  ControllingAreaName, 
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  ControllingAreaCurrency, 
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  ChartOfAccounts, 
  @EndUserText.label: 'Cost Center Standard Hierarchy'
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  CostCenterStandardHierarchy, 
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  ProfitCenterStandardHierarchy, 
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  FinancialManagementArea, 
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  ControllingAreaCurrencyRole, 
  @Search.defaultSearchElement: true
  @Search.ranking: #LOW
  CtrlgStdFinStatementVersion, 
  
  @EndUserText.label: 'Hierarchy Description'
  FinStateT.FinancialStmntHierarchyName,
  
  @EndUserText.label: 'Profit Center Local Currency'
  ProfitCenterAccountingCurrency, 
  
  /* Associations */ 
  //I_ControllingArea 

  _ChartOfAccounts, 
  _ChartOfAccountsText, 
  _Currency, 
  _FinancialStatementVersion 
  //_FinancialStatementVersionText

}

Learn More