C_CostCenterVH

DDL: C_COSTCENTERVH SQL: CFICOSTCENTERVH Type: view CONSUMPTION

Cost Center

C_CostCenterVH is a Consumption CDS View that provides data about "Cost Center" in SAP S/4HANA. It reads from 1 data source (I_CostCenterVH) and exposes 12 fields with key fields ControllingArea, CostCenter, ValidityEndDate.

Data Sources (1)

SourceAliasJoin Type
I_CostCenterVH CostCenter from

Annotations (16)

NameValueLevelField
AbapCatalog.sqlViewName CFICOSTCENTERVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CostCenter view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
VDM.viewType #CONSUMPTION view
EndUserText.label Cost Center view
Metadata.ignorePropagatedAnnotations true view
Consumption.ranked true view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea I_CostCenterVH ControllingArea
KEY CostCenter I_CostCenterVH CostCenter
KEY ValidityEndDate I_CostCenterVH ValidityEndDate
ValidityStartDate I_CostCenterVH ValidityStartDate
CostCenterName I_CostCenterVH CostCenterName
CompanyCode I_CostCenterVH CompanyCode
CostCenterCategory I_CostCenterVH CostCenterCategory
CostCenterCategoryName
ProfitCenter I_CostCenterVH ProfitCenter
CostCtrResponsiblePersonName I_CostCenterVH CostCtrResponsiblePersonName
CostCtrResponsibleUser I_CostCenterVH CostCtrResponsibleUser
_ControllingArea I_CostCenterVH _ControllingArea
@AbapCatalog.sqlViewName: 'CFICOSTCENTERVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true 
@AccessControl.authorizationCheck: #CHECK

@ObjectModel: { dataCategory: #VALUE_HELP,
                representativeKey: 'CostCenter',
                semanticKey: [ 'CostCenter', 'ControllingArea', 'ValidityEndDate' ],
                usageType.dataClass: #MASTER,
                usageType.serviceQuality: #B,
                usageType.sizeCategory: #M }

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Search.searchable: true
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Cost Center'
@Metadata.ignorePropagatedAnnotations: true
@Consumption.ranked: true
define view C_CostCenterVH
  as select from I_CostCenterVH as CostCenter
{
      @UI.hidden: false
  key CostCenter.ControllingArea,

      @ObjectModel.text.element: [ 'CostCenterName' ]
      @Search: { defaultSearchElement:  true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
      @UI: {
 //       textArrangement: #TEXT_LAST,

        lineItem: [{ position: 1 }]
      }
  key CostCenter.CostCenter,

      @Semantics.businessDate.to: true
      @Consumption.filter.multipleSelections: false
      @Consumption.filter.selectionType: #SINGLE
      @UI: {
        lineItem: [{ position: 8 }]
      }        
  key CostCenter.ValidityEndDate,

      @Semantics.businessDate.from: true
      @Consumption.filter.multipleSelections: false
      @Consumption.filter.selectionType: #SINGLE
      @UI: {
        lineItem: [{ position: 7 }]
      }              
      CostCenter.ValidityStartDate,

      @Semantics.text: true
      @Search: { defaultSearchElement:  true, ranking: #HIGH, fuzzinessThreshold: 0.8 }
      @UI: {  
        lineItem: [{ position: 5 }]
      }      
      CostCenter.CostCenterName,

      @Consumption.valueHelpDefinition: [{
        entity: {
          name: 'C_CostCenterCompanyCodeVH',
          element: 'CompanyCode'
        },
        distinctValues: true
      }]
      CostCenter.CompanyCode,
      
      @Consumption.valueHelpDefinition: [{ 
        entity: { 
            name : 'C_CostCenterCategoryVH', 
            element : 'CostCenterCategory' 
        } 
      }]
      @ObjectModel.text.element: [ 'CostCenterCategoryName' ] 
      @UI.textArrangement: #TEXT_LAST 
      CostCenter.CostCenterCategory,
      
      @Semantics.text: true
      cast( _CostCenterCategory._Text[1:Language=$session.system_language].CostCenterCategoryName as fis_cc_kosar_name preserving type ) as CostCenterCategoryName,

      CostCenter.ProfitCenter,

      @Search: { defaultSearchElement: true, ranking: #LOW }
      CostCenter.CostCtrResponsiblePersonName,

      @Search: { defaultSearchElement: true, ranking: #LOW }
      CostCenter.CostCtrResponsibleUser,

      CostCenter._ControllingArea
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_COSTCENTERCATEGORY",
"I_COSTCENTERCATEGORYTEXT",
"I_COSTCENTERVH"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA"
],
"BASE":
[
"I_COSTCENTERVH"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/