I_MM_ProfitCenterValueHelp

DDL: I_MM_PROFITCENTERVALUEHELP SQL: IMMPRFCTRVH Type: view BASIC

Purchasing Profit Center Value Help

I_MM_ProfitCenterValueHelp is a Basic CDS View that provides data about "Purchasing Profit Center Value Help" in SAP S/4HANA. It reads from 1 data source (I_ProfitCenter) and exposes 7 fields with key fields ControllingArea, ProfitCenter, ValidityEndDate. It has 1 association to related views.

1 data source(s) 7 fields

Data Sources (1)

SourceAliasJoin Type
I_ProfitCenter ProfitCenter from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_ProfitCenterText _Text $projection.ControllingArea = _Text.ControllingArea and $projection.ProfitCenter = _Text.ProfitCenter and $projection.ValidityEndDate = _Text.ValidityEndDate

Annotations (14)

NameValueLevelField
VDM.viewType #BASIC view
EndUserText.label Purchasing Profit Center Value Help view
AbapCatalog.sqlViewName IMMPRFCTRVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
Search.searchable true view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY ControllingArea I_ProfitCenter ControllingArea
KEY ProfitCenter I_ProfitCenter ProfitCenter
KEY ValidityEndDate I_ProfitCenter ValidityEndDate
ProfitCtrResponsiblePersonName I_ProfitCenter ProfitCtrResponsiblePersonName
ProfitCtrResponsibleUser I_ProfitCenter ProfitCtrResponsibleUser
_Text _Text
_ControllingArea _ControllingArea 
@VDM.viewType: #BASIC

@EndUserText.label: 'Purchasing Profit Center Value Help'
@AbapCatalog.sqlViewName: 'IMMPRFCTRVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #S
@ObjectModel.usageType.dataClass: #MASTER


@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations:  [ '_Text' ]
@AccessControl.personalData.blocking: #NOT_REQUIRED

@ClientHandling.algorithm: #SESSION_VARIABLE
@Consumption.ranked: true
@Search.searchable: true

define view I_MM_ProfitCenterValueHelp
  as select from I_ProfitCenter as ProfitCenter
  association [0..*] to I_ProfitCenterText as _Text on  $projection.ControllingArea = _Text.ControllingArea
                                                    and $projection.ProfitCenter    = _Text.ProfitCenter
                                                    and $projection.ValidityEndDate = _Text.ValidityEndDate
{
      @UI.hidden: true
      @ObjectModel.foreignKey.association: '_ControllingArea'
  key ProfitCenter.ControllingArea                as      ControllingArea,

      @ObjectModel.text.association: '_Text'
      @Search: { defaultSearchElement: true, ranking: #HIGH }
  key ProfitCenter.ProfitCenter                   as      ProfitCenter,

      @Semantics.businessDate.to: true
      @Search: { defaultSearchElement: true, ranking: #HIGH }
  key ProfitCenter.ValidityEndDate                as      ValidityEndDate,

      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      ProfitCenter.ProfitCtrResponsiblePersonName as      ProfitCtrResponsiblePersonName,

      @Search: { defaultSearchElement: true, ranking: #LOW, fuzzinessThreshold: 0.8 }
      ProfitCenter.ProfitCtrResponsibleUser       as      ProfitCtrResponsibleUser,

      //associations

      _Text,
      _ControllingArea
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_PROFITCENTER"
],
"ASSOCIATED":
[
"I_CONTROLLINGAREA",
"I_PROFITCENTERTEXT"
],
"BASE":
[
"I_PROFITCENTER"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More