I_ChangeMstrObMgReMatlBOM

DDL: I_CHANGEMSTROBMGREMATLBOM SQL: IECNOMRMBOM Type: view COMPOSITE
23 Fields 1 Data Sources 1 Associations

Change Number ObMaRe of Material BOM

I_ChangeMstrObMgReMatlBOM (Composite)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

R&D Engineering

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

SAP Help Documentation

CategoryChange Number
StatusReleased
Purpose
This CDS view provides the prerequisites for answering the following business questions: Which material BOMs are assigned to a change master? If a material BOM was changed using a change master, who initiated these changes and when?

Prerequisites
Users who want to run reports using this CDS view must have display rights for the following authorization objects: C_AENR_BGR C_AENR_ERW

Structure
Object types This view is built on the following object types: Change master Material BOM Main CDS parameters and filters The main filters are: Change number ( ChangeNumber ) Material number ( Material ) Plant ( Plant ) BOM usage ( BillOfMaterialVariantUsage ) Object management record creator ( ObjMgmtRecdCreatedBy ) Object management record creation date ( ObjMgmtRecdCreationDate )

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessR&D Engineering
Application ComponentPLM-WUI-OBJ-ECN
CapabilitiesAssociation Target for Defining CDS Entities, Data Source for Defining CDS Entities, Data Source in SQL Select
PackageR&D Engineering for SAP S/4HANA Cloud Private Edition
Description <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which material BOMs are assigned to a change master?</p></li> <li><p>If a material BOM was changed using a change master, who initiated these changes and when?</p></li> </ul>

Documentation

Data Sources (1)

SourceAliasJoin Type
I_ChangeMstrObjectMgmtRecord I_ChangeMstrObjectMgmtRecord from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_MaterialBOMLink _MaterialBOMLink $projection.Material = _MaterialBOMLink.Material and $projection.Plant = _MaterialBOMLink.Plant and $projection.BillOfMaterialVariantUsage = _MaterialBOMLink.BillOfMaterialVariantUsage

Annotations (12)

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

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY ChangeNumber ChangeNumber Change Number
KEY Material Material Number
KEY Plant Plant
KEY BillOfMaterialVariantUsage BOM Usage
ObjMgmtRecdObject ObjMgmtRecdObject Change object (internal use)
ObjMgmtRecdObjectInternalID ObjMgmtRecdObjectInternalID Identification of object to be changed
ChgNmbrAlternativeDateCounter ChgNmbrAlternativeDateCounter Engineering change management: alternative date counter
ObjMgmtRecdDescription ObjMgmtRecdDescription Object management record description
ObjMgmtRecdItemUUID ObjMgmtRecdItemUUID Object Management Record Item GUID
ObjMgmtRecdLastChangedAt ObjMgmtRecdLastChangedAt Date of Last Change
ObjMgmtRecdLastChangedBy ObjMgmtRecdLastChangedBy Name of person who changed object
ObjMgmtRecdCreationDate ObjMgmtRecdCreationDate Date record created on
ObjMgmtRecdCreatedBy ObjMgmtRecdCreatedBy User who created record
ObjMgmtRecdObjLastChangedAt ObjMgmtRecdObjLastChangedAt Date on which the object was last changed
ObjMgmtRecdObjLastChangedBy ObjMgmtRecdObjLastChangedBy User who last changed the object
ObjMgmtRecdObjIsLockedForChg ObjMgmtRecdObjIsLockedForChg Indicator: Object locked for changes
ObjMgmtRecdObjIsBaselined ObjMgmtRecdObjIsBaselined Baselining for object was performed
ObjMgmtRecdChangeType ObjMgmtRecdChangeType Change Type for Object
ObjMgmtRecdObjIsPlanned ObjMgmtRecdObjIsPlanned Indicator: planned record
ObjMgmtRecdObjRevisionLevel ObjMgmtRecdObjRevisionLevel Revision Level without Conversion Exit
_ChangeMaster _ChangeMaster
_ChangeMasterAltDate _ChangeMasterAltDate
_MaterialBOMLink _MaterialBOMLink

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_ChangeMstrObMgReMatlBOM.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: IECNOMRMBOM

CREATE VIEW I_ChangeMstrObMgReMatlBOM AS
SELECT
  ChangeNumber,
  cast(substring(ObjMgmtRecdObject, 1, 40) as matnr) AS Material,
  cast(substring(ObjMgmtRecdObject, 41, 4) as werks_d) AS Plant,
  cast(substring(ObjMgmtRecdObject, 45, 1) as stlan) AS BillOfMaterialVariantUsage,
  ObjMgmtRecdObject,
  ObjMgmtRecdObjectInternalID,
  ChgNmbrAlternativeDateCounter,
  ObjMgmtRecdDescription,
  ObjMgmtRecdItemUUID,
  ObjMgmtRecdLastChangedAt,
  ObjMgmtRecdLastChangedBy,
  ObjMgmtRecdCreationDate,
  ObjMgmtRecdCreatedBy,
  ObjMgmtRecdObjLastChangedAt,
  ObjMgmtRecdObjLastChangedBy,
  ObjMgmtRecdObjIsLockedForChg,
  ObjMgmtRecdObjIsBaselined,
  ObjMgmtRecdChangeType,
  ObjMgmtRecdObjIsPlanned,
  ObjMgmtRecdObjRevisionLevel
FROM I_ChangeMstrObjectMgmtRecord
LEFT OUTER JOIN I_MaterialBOMLink AS _MaterialBOMLink ON Material = _MaterialBOMLink.Material AND Plant = _MaterialBOMLink.Plant AND BillOfMaterialVariantUsage = _MaterialBOMLink.BillOfMaterialVariantUsage  -- association [0..*]
;

Learn More