C_MM_CostCenterValueHelp

DDL: C_MM_COSTCENTERVALUEHELP SQL: CMMCOSTCNTR_VH Type: view CONSUMPTION Package: ODATA_MM_PUR_CTRITEMACCT_MNTR

Value Help for Cost Center

C_MM_CostCenterValueHelp is a Consumption CDS View that provides data about "Value Help for Cost Center" in SAP S/4HANA. It reads from 1 data source (I_CostCenter) and exposes 7 fields with key fields CostCenter, ControllingArea, ValidityEndDate. Part of development package ODATA_MM_PUR_CTRITEMACCT_MNTR.

Data Sources (1)

SourceAliasJoin Type
I_CostCenter CostCenter from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CMMCOSTCNTR_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey CostCenter view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
EndUserText.label Value Help for Cost Center view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CostCenter I_CostCenter CostCenter
KEY ControllingArea I_CostCenter ControllingArea
KEY ValidityEndDate I_CostCenter ValidityEndDate
CostCenterName
CompanyCode I_CostCenter CompanyCode
CostCtrResponsiblePersonName I_CostCenter CostCtrResponsiblePersonName
ValidityStartDate I_CostCenter ValidityStartDate
@AbapCatalog.sqlViewName: 'CMMCOSTCNTR_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #MANDATORY
@VDM.viewType: #CONSUMPTION
@ObjectModel.representativeKey: 'CostCenter'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@EndUserText.label: 'Value Help for Cost Center'
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@Search.searchable: true

// ---------------------------------------------------------------

// Kindly Do not use this Value Help. It has been deprecated.

// ---------------------------------------------------------------


define view C_MM_CostCenterValueHelp
  as select from I_CostCenter as CostCenter
{

       @Search: { defaultSearchElement: true, ranking: #HIGH }
  key  CostCenter.CostCenter                                                   as CostCenter,

       @UI.hidden: true
  key  CostCenter.ControllingArea                                              as ControllingArea,

       @Search: { defaultSearchElement: true, ranking: #LOW }
  key  CostCenter.ValidityEndDate                                              as ValidityEndDate,

       @Search: { defaultSearchElement: true, ranking: #HIGH, fuzzinessThreshold: 0.7 }
       CostCenter._Text[1: Language = $session.system_language].CostCenterName as CostCenterName,

       @Search: { defaultSearchElement: true, ranking: #MEDIUM }
       CostCenter.CompanyCode                                                  as CompanyCode,

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

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