I_ChangeMstrObMgReMatlBOM

DDL: I_CHANGEMSTROBMGREMATLBOM Type: view_entity COMPOSITE Package: VDM_PLMB_ECN
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 Public 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. Part of development package VDM_PLMB_ECN.

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?

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

CategoryComposite
StateC1
Line of BusinessR&D Engineering
Application ComponentPLM-WUI-OBJ-ECN-2CL
CapabilitiesData Source for Defining CDS Entities,Data Source in SQL Select,Association Target for Defining CDS Entities
Extensible (Key User)No
Extensible (Developer)No
Release State (Key User)Released
Release State (Developer)Not Released
PackageR&D/Engineering for SAP S/4HANA Cloud Public 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 (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK 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 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.

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