I_ChangeMstrObMgReMaterial

DDL: I_CHANGEMSTROBMGREMATERIAL SQL: IECNOMRMAT Type: view COMPOSITE

Change Number ObMaRe of Material

I_ChangeMstrObMgReMaterial is a Composite CDS View that provides data about "Change Number ObMaRe of Material" in SAP S/4HANA. It reads from 1 data source (I_ChangeMstrObjectMgmtRecord) and exposes 21 fields with key fields ChangeNumber, Material. It has 1 association to related views.

1 data source(s) 21 fields

Data Sources (1)

SourceAliasJoin Type
I_ChangeMstrObjectMgmtRecord I_ChangeMstrObjectMgmtRecord from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Product _Product $projection.Material = _Product.Product

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IECNOMRMAT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.dataClass #MASTER view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #COMPOSITE view
VDM.lifecycle.contract.type #PUBLIC_LOCAL_API view
EndUserText.label Change Number ObMaRe of Material view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber ChangeNumber
KEY Material
ObjMgmtRecdObject ObjMgmtRecdObject
ObjMgmtRecdObjectInternalID ObjMgmtRecdObjectInternalID
ChgNmbrAlternativeDateCounter ChgNmbrAlternativeDateCounter
ObjMgmtRecdDescription ObjMgmtRecdDescription
ObjMgmtRecdItemUUID ObjMgmtRecdItemUUID
ObjMgmtRecdLastChangedAt ObjMgmtRecdLastChangedAt
ObjMgmtRecdLastChangedBy ObjMgmtRecdLastChangedBy
ObjMgmtRecdCreationDate ObjMgmtRecdCreationDate
ObjMgmtRecdCreatedBy ObjMgmtRecdCreatedBy
ObjMgmtRecdObjLastChangedAt ObjMgmtRecdObjLastChangedAt
ObjMgmtRecdObjLastChangedBy ObjMgmtRecdObjLastChangedBy
ObjMgmtRecdObjIsLockedForChg ObjMgmtRecdObjIsLockedForChg
ObjMgmtRecdObjIsBaselined ObjMgmtRecdObjIsBaselined
ObjMgmtRecdChangeType ObjMgmtRecdChangeType
ObjMgmtRecdObjIsPlanned ObjMgmtRecdObjIsPlanned
ObjMgmtRecdObjRevisionLevel ObjMgmtRecdObjRevisionLevel
_ChangeMaster _ChangeMaster
_ChangeMasterAltDate _ChangeMasterAltDate
_Product _Product 
@AbapCatalog.sqlViewName: 'IECNOMRMAT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.supportedCapabilities: [ #CDS_MODELING_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET,
                                      #SQL_DATA_SOURCE ]

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

@Metadata.ignorePropagatedAnnotations: true

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

@EndUserText.label: 'Change Number ObMaRe of Material'
define view I_ChangeMstrObMgReMaterial
  as select from I_ChangeMstrObjectMgmtRecord
  association [0..1] to I_Product as _Product on $projection.Material = _Product.Product

{
  key ChangeNumber,
  key cast(ObjMgmtRecdObject as /plmb/matnr  ) as Material,

      ObjMgmtRecdObject,
      ObjMgmtRecdObjectInternalID,

      ChgNmbrAlternativeDateCounter,
      ObjMgmtRecdDescription,
      ObjMgmtRecdItemUUID,

      ObjMgmtRecdLastChangedAt,
      ObjMgmtRecdLastChangedBy,

      ObjMgmtRecdCreationDate,
      ObjMgmtRecdCreatedBy,
      ObjMgmtRecdObjLastChangedAt,
      ObjMgmtRecdObjLastChangedBy,

      ObjMgmtRecdObjIsLockedForChg,
      ObjMgmtRecdObjIsBaselined,
      ObjMgmtRecdChangeType,
      ObjMgmtRecdObjIsPlanned,
      ObjMgmtRecdObjRevisionLevel,

      /* Associations */
      _ChangeMaster,
      _ChangeMasterAltDate,
      _Product
}
where
  ChangeNumberObjectType = '41'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_CHANGEMSTROBJECTMGMTRECORD"
],
"ASSOCIATED":
[
"I_CHANGEMASTER",
"I_CHANGEMASTERALTDATE",
"I_PRODUCT"
],
"BASE":
[
"I_CHANGEMSTROBJECTMGMTRECORD"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More