I_MM_CostCenterValueHelp

DDL: I_MM_COSTCENTERVALUEHELP SQL: IMMCOSTCNTR_VH Type: view BASIC Package: ODATA_MM_COMMONS_VH

Purchasing Cost Center Value Help

I_MM_CostCenterValueHelp is a Basic CDS View that provides data about "Purchasing Cost Center Value Help" 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_COMMONS_VH.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_CostCenter CostCenter from

Annotations (15)

NameValueLevelField
VDM.viewType #BASIC view
EndUserText.label Purchasing Cost Center Value Help view
AbapCatalog.sqlViewName IMMCOSTCNTR_VH view
AbapCatalog.compiler.compareFilter true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey CostCenter view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #NOT_REQUIRED view
Search.searchable true view
Consumption.ranked true view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY CostCenter I_CostCenter CostCenter
KEY ControllingArea I_CostCenter ControllingArea
KEY ValidityEndDate I_CostCenter ValidityEndDate
CompanyCode I_CostCenter CompanyCode
CostCtrResponsiblePersonName I_CostCenter CostCtrResponsiblePersonName
ValidityStartDate I_CostCenter ValidityStartDate
_Text _Text 
@VDM.viewType: #BASIC
@EndUserText.label: 'Purchasing Cost Center Value Help'

@AbapCatalog.sqlViewName: 'IMMCOSTCNTR_VH'
@AbapCatalog.compiler.compareFilter: true

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'CostCenter'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M

@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #NOT_REQUIRED
@Search.searchable: true
@Consumption.ranked: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:  [ '_Text' ]

@Metadata.allowExtensions: true //3224355


define view I_MM_CostCenterValueHelp
  as select from I_CostCenter as CostCenter
  association[0..*] to I_CostCenterText as _Text on  $projection.ControllingArea = _Text.ControllingArea
                                                      and $projection.CostCenter      = _Text.CostCenter
                                                      and $projection.ValidityEndDate = _Text.ValidityEndDate
{
              @ObjectModel.text.association: '_Text'
       @Search: { defaultSearchElement: true, ranking: #HIGH }
  key  CostCenter.CostCenter                   as CostCenter,

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

       @Search: { defaultSearchElement: true, ranking: #HIGH }
       @Semantics.businessDate.to: true
       @Consumption.filter.multipleSelections: false
       @Consumption.filter.selectionType: #INTERVAL
  key  CostCenter.ValidityEndDate              as ValidityEndDate,

       @Consumption.valueHelpDefinition: [{ entity: { name : 'C_MM_CompanyCodeValueHelp', element : 'CompanyCode' } }]
       @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
       CostCenter.CompanyCode                  as CompanyCode,

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

       @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
       @Semantics.businessDate.from: true
       @Consumption.filter.multipleSelections: false
       @Consumption.filter.selectionType: #INTERVAL
       CostCenter.ValidityStartDate            as ValidityStartDate,

       // associations

       _Text
}

Learn More