I_SpecChangeNumberValueHelp

DDL: I_SPECCHANGENUMBERVALUEHELP SQL: ISPECECNVH Type: view COMPOSITE

Value Help for Change Numbers in Specification

I_SpecChangeNumberValueHelp is a Composite CDS View that provides data about "Value Help for Change Numbers in Specification" in SAP S/4HANA. It reads from 1 data source (I_ChangeMasterObjTypeAssgmt) and exposes 17 fields with key field ChangeNumber.

1 data source(s) 17 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeMasterObjTypeAssgmt I_ChangeMasterObjTypeAssgmt from

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName ISPECECNVH view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Consumption.ranked true view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey ChangeNumber view
Search.searchable true view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
VDM.viewType #COMPOSITE view
EndUserText.label Value Help for Change Numbers in Specification view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber _ChangeMaster ChangeNumber
ChangeNumberDescription _ChangeMaster ChangeNumberDescription
ChangeNumberValidFromDate _ChangeMaster ChangeNumberValidFromDate
ChangeNumberStatus _ChangeMaster ChangeNumberStatus
ChangeNumberCreatedByUser _ChangeMaster ChangeNumberCreatedByUser
ChangeNumberCreationDate _ChangeMaster ChangeNumberCreationDate
ChangeNumberLastChangedByUser _ChangeMaster ChangeNumberLastChangedByUser
ChangeNumberLastChangedDate _ChangeMaster ChangeNumberLastChangedDate
_ChangeNumberStatus _ChangeMaster _ChangeNumberStatus
_CreatedByUser _ChangeMaster _CreatedByUser
_LastChangedByUser _ChangeMaster _LastChangedByUser
AuthorizationGroup _ChangeMaster AuthorizationGroup
ChangeNumberFunction _ChangeMaster ChangeNumberFunction
ChangeNumberReleaseKey _ChangeMaster ChangeNumberReleaseKey
_ChangeMasterLogAccMActive _ChangeMaster _ChangeMasterLogAccMActive
_ChgMstrLogAccMSecureIDAssgmt _ChangeMaster _ChgMstrLogAccMSecureIDAssgmt
_ChangeMstrLogAccMUserAuthzn _ChangeMaster _ChangeMstrLogAccMUserAuthzn 
@AbapCatalog.sqlViewName: 'ISPECECNVH'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey:true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: [
  '_ChangeMasterLogAccMActive'   ,
  '_ChgMstrLogAccMSecureIDAssgmt',
  '_ChangeMstrLogAccMUserAuthzn' ]

@ClientHandling.algorithm: #SESSION_VARIABLE

@Consumption.ranked: true

@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.dataClass: #MASTER

@ObjectModel.semanticKey:  [ 'ChangeNumber' ]
@ObjectModel.dataCategory:#VALUE_HELP
@ObjectModel.representativeKey: 'ChangeNumber'

@Search.searchable: true

@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@VDM.viewType: #COMPOSITE

@EndUserText.label: 'Value Help for Change Numbers in Specification'
define view I_SpecChangeNumberValueHelp
  as select from I_ChangeMasterObjTypeAssgmt
{
      @ObjectModel.text.element: 'ChangeNumberDescription'
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #HIGH
  key _ChangeMaster.ChangeNumber,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      @Semantics.text: true
      _ChangeMaster.ChangeNumberDescription,

      _ChangeMaster.ChangeNumberValidFromDate,
      _ChangeMaster.ChangeNumberStatus,

      _ChangeMaster.ChangeNumberCreatedByUser,
      _ChangeMaster.ChangeNumberCreationDate,
      _ChangeMaster.ChangeNumberLastChangedByUser,
      _ChangeMaster.ChangeNumberLastChangedDate,

      _ChangeMaster._ChangeNumberStatus,
      _ChangeMaster._CreatedByUser,
      _ChangeMaster._LastChangedByUser,

      @Consumption.hidden: true
      _ChangeMaster.AuthorizationGroup,
      @Consumption.hidden: true
      _ChangeMaster.ChangeNumberFunction,
      @Consumption.hidden: true
      _ChangeMaster.ChangeNumberReleaseKey,

      // Access Control Management, used in DCL

      @Consumption.hidden:true
      _ChangeMaster._ChangeMasterLogAccMActive,
      @Consumption.hidden:true
      _ChangeMaster._ChgMstrLogAccMSecureIDAssgmt,
      @Consumption.hidden:true
      _ChangeMaster._ChangeMstrLogAccMUserAuthzn
}
where
      ChangeNumberObjectType  = '60'
  and IsActiveForChangeNumber = 'X'

Learn More