C_MM_RevisionLvlValueHelp

DDL: C_MM_REVISIONLVLVALUEHELP SQL: CMMMREVLVL_VH Type: view CONSUMPTION

Revision Level Value Help

C_MM_RevisionLvlValueHelp is a Consumption CDS View that provides data about "Revision Level Value Help" in SAP S/4HANA. It reads from 1 data source (aeoi) and exposes 8 fields with key fields ChangeNumber, ObjectType, MaterialRevisionLevel. It has 1 association to related views.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
aeoi aeoi from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_ChangeMaster _ChangeMaster $projection.ChangeNumber = _ChangeMaster.ChangeNumber

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CMMMREVLVL_VH view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
Search.searchable true view
ObjectModel.representativeKey MaterialRevisionLevel view
EndUserText.label Revision Level Value Help view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber aennr
KEY ObjectType
KEY MaterialRevisionLevel
ChangeNumberCreationDate andat
ChangeNumberCreatedByUser annam
ChangeNumberDescription _ChangeMaster ChangeNumberDescription
AuthorizationGroup _ChangeMaster AuthorizationGroup
_ChangeMaster _ChangeMaster 
@AbapCatalog.sqlViewName: 'CMMMREVLVL_VH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@Search.searchable: true
@ObjectModel.semanticKey: [ 'ChangeNumber', 'ObjectType' ]
@ObjectModel.representativeKey: 'MaterialRevisionLevel'
@EndUserText.label: 'Revision Level Value Help'

@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #S
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

define view C_MM_RevisionLvlValueHelp
  as select from aeoi

  association [1..1] to I_ChangeMaster as _ChangeMaster on $projection.ChangeNumber = _ChangeMaster.ChangeNumber

{

             @ObjectModel.foreignKey.association: '_ChangeMaster'
             @Search: { defaultSearchElement: true, ranking: #HIGH }
             @ObjectModel.text.element: 'ChangeNumberDescription'
  key        aennr                as ChangeNumber,

//             @Search: { defaultSearchElement: true, ranking: #HIGH }

//             @ObjectModel.foreignKey.association

  key        cast(objkt as matnr) as ObjectType,

             @Search: { defaultSearchElement: true, ranking: #HIGH }
  key        cast( revlv as vdm_qm_revlv preserving type )  as MaterialRevisionLevel,

             andat                as ChangeNumberCreationDate,

             annam                as ChangeNumberCreatedByUser,
             
             @Semantics.text:true
             @Consumption.hidden: true
             _ChangeMaster.ChangeNumberDescription,
             
             _ChangeMaster.AuthorizationGroup,
             
             @Consumption.hidden: true
             _ChangeMaster

}
where
  aetyp = '41'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEMASTER",
"AEOI"
],
"ASSOCIATED":
[
"I_CHANGEMASTER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More