What is I_MfgBillOfOperationsChgSt in SAP S/4HANA?

I_MfgBillOfOperationsChgSt is a basic CDS view in SAP S/4HANA. Manufacturing Bill of Operations Change State It contains 66 fields.

Which tables does I_MfgBillOfOperationsChgSt read from?

I_MfgBillOfOperationsChgSt reads data from: I_BillOfOperationsChangeState.

What VDM layer is I_MfgBillOfOperationsChgSt?

I_MfgBillOfOperationsChgSt is classified as a Basic (interface) view providing a 1:1 representation of a database table.

I_MfgBillOfOperationsChgSt

DDL: I_MFGBILLOFOPERATIONSCHGST SQL: IMFGBILLOFOPERCS Type: view BASIC

66 Fields 1 Data Sources 1 Associations

Manufacturing Bill of Operations Change State

I_MfgBillOfOperationsChgSt (Basic)

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

ProductionRoutingChangeState · Manufacturing

I_MfgBillOfOperationsChgSt is a Basic CDS View (Dimension) that provides data about "Manufacturing Bill of Operations Change State" in SAP S/4HANA. It reads from 1 data source (I_BillOfOperationsChangeState) and exposes 66 fields with key fields BillOfOperationsType, BillOfOperationsGroup, BillOfOperationsVariant, BOOInternalVersionCounter. It has 1 association to related views.

SAP Help Documentation

Category	CDS Views for Basic Routing Data
Data Category	Basic, Dimension
Status	Released

Purpose
With this CDS view you can retrieve header data of the change state (table PLKO ) for a manufacturing bill of operations (routing/recipe). This CDS view provides the prerequisites for answering the following business questions: Which bill of operations change states exist for a bill of operations? What was the last change date and time for a bill of operations change state? What are the validity start and end dates? Which work center is assigned to a manufacturing bill of operations change state?

Prerequisites
You have authorizations to display a bill of operations by type ( C_ROUT ).

Structure
Measures and attributes The following main attributes are provided: Bill of operations types Bill of operations Bill of operations variant Bill of operations change state Creation date and time Last change date and time Last change user ID Validity start and end date Change number Deletion indicators Description Work center internal ID Bill of operations usage code Bill of operations status Responsible planner group Bill of operations unit Minimum and maximum lot size quantity

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Manufacturing
Application Component	PP-VDM-MD
Capabilities	Analytical Dimension, Association Target for Defining CDS Entities, Data Source in SQL Select, Data Source for Defining CDS Entities, Data Source for Data Extraction
Package	Manufacturing for SAP S/4HANA Cloud Private Edition
Description	<p>With this CDS view you can retrieve header data of the change state (table PLKO) for a manufacturing bill of operations (routing/recipe).</p> <p>This CDS view provides the prerequisites for answering the following business questions:</p> <ul> <li><p>Which bill of operations change states exist for a bill of operations?</p></li> <li><p>What was the last change date and time for a bill of operations change state?</p></li> <li><p>What are the validity start and end dates?</p></li> <li><p>Which work center is assigned to a manufacturing bill of operations change state?</p></li> </ul>

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_BillOfOperationsChangeState	plko	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..1]	I_MfgBillOfOperations	_BillOfOperations	`$projection.BillOfOperationsType = _BillOfOperations.BillOfOperationsType and $projection.BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup and $projection.BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant`

Annotations (19)

Name	Value	Level
AbapCatalog.sqlViewName	IMFGBILLOFOPERCS	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#CHECK	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ClientHandling.type	#CLIENT_DEPENDENT	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
ObjectModel.representativeKey	BOOInternalVersionCounter	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.dataClass	#MASTER	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
VDM.viewType	#BASIC	view
EndUserText.label	Manufacturing Bill of Operations Change State	view
ObjectModel.sapObjectNodeType.name	ProductionRoutingChangeState	view

Fields (66)

Key	Field	Source Table	Source Field	Description
KEY	BillOfOperationsType	I_BillOfOperationsChangeState	BillOfOperationsType	Task List Type
KEY	BillOfOperationsGroup	I_BillOfOperationsChangeState	BillOfOperationsGroup	Key for Task List Group
KEY	BillOfOperationsVariant	I_BillOfOperationsChangeState	BillOfOperationsVariant	Group Counter
KEY	BOOInternalVersionCounter	I_BillOfOperationsChangeState	BOOInternalVersionCounter	Internal counter
	CreationDate			Date Record Created On
	CreatedByUser	I_BillOfOperationsChangeState	CreatedByUser	Created By User
	LastChangeDate	I_BillOfOperationsChangeState	LastChangeDate	Last Changed On
	LastChangedByUser	I_BillOfOperationsChangeState	LastChangedByUser	Last Changed By User
	ChangedDateTime	I_BillOfOperationsChangeState	ChangedDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	ChangeNumber			Change Number
	ValidityStartDate	I_BillOfOperationsChangeState	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_BillOfOperationsChangeState	ValidityEndDate	Valid-To Date
	LastReorganizationDate			Archive date
	LastUsageDate	I_BillOfOperationsChangeState	LastUsageDate	Date of the Last Call
	NumberOfUsages	I_BillOfOperationsChangeState	NumberOfUsages	Number of Calls
	BillOfOperationsDateTime	I_BillOfOperationsChangeState	BillOfOperationsDateTime	UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
	IsDeleted	I_BillOfOperationsChangeState	IsDeleted	Deletion Indicator
	IsImplicitlyDeleted	I_BillOfOperationsChangeState	IsImplicitlyDeleted	Deletion Indicator
	IsMarkedForDeletion	I_BillOfOperationsChangeState	IsMarkedForDeletion	Indicator: Delete completely in reorganization run
	ReplacedBillOfOperations	I_BillOfOperationsChangeState	ReplacedBillOfOperations	Old TL Number
	BillOfOperationsDesc	I_BillOfOperationsChangeState	BillOfOperationsDesc	Routing Description
	LongTextLanguageCode	I_BillOfOperationsChangeState	LongTextLanguageCode	Language Key
	WorkCenterTypeCode	I_BillOfOperationsChangeState	WorkCenterTypeCode	Object types of the CIM resource
	WorkCenterInternalID	I_BillOfOperationsChangeState	WorkCenterInternalID	Work center group with planning function
	Plant	I_BillOfOperationsChangeState	Plant	Valuation Area
	BillOfOperationsUsage	I_BillOfOperationsChangeState	BillOfOperationsUsage	Work Center Category
	BillOfOperationsStatus	I_BillOfOperationsChangeState	BillOfOperationsStatus	Vehicle Status
	BillOfOperationsProfile	I_BillOfOperationsChangeState	BillOfOperationsProfile	Profile
	ResponsiblePlannerGroup	I_BillOfOperationsChangeState	ResponsiblePlannerGroup	Responsible Planner Group or Department
	LineHierarchyInternalID	I_BillOfOperationsChangeState	LineHierarchyInternalID	Object ID
	InspSubsetFieldCombination	I_BillOfOperationsChangeState	InspSubsetFieldCombination	Identification for the Inspection Point Field Combination
	InspectionPartialLot	I_BillOfOperationsChangeState	InspectionPartialLot	Partial Lot Assignment in an Inspection During Production
	SmplDrawingProcedure	I_BillOfOperationsChangeState	SmplDrawingProcedure	Sample-Drawing Procedure
	SmplDrawingProcedureVersion	I_BillOfOperationsChangeState	SmplDrawingProcedureVersion	Version No. of the Sample-Drawing Procedure
	InspectionLotDynamicLevel	I_BillOfOperationsChangeState	InspectionLotDynamicLevel	Level at Which Dynamic Modification Parameters Are Defined
	InspLotDynamicRule	I_BillOfOperationsChangeState	InspLotDynamicRule	Dynamic Modification Rule
	InspExternalNumberingOfValues	I_BillOfOperationsChangeState	InspExternalNumberingOfValues	External Numbering of Units to Be Inspected
	BillOfOperationsUnit	I_BillOfOperationsChangeState	BillOfOperationsUnit	Task List Unit of Measure
	MinimumLotSizeQuantity	I_BillOfOperationsChangeState	MinimumLotSizeQuantity	Minimum Lot Size
	MaximumLotSizeQuantity	I_BillOfOperationsChangeState	MaximumLotSizeQuantity	Maximum Lot Size
	OperationReferenceQuantity	I_BillOfOperationsChangeState	OperationReferenceQuantity	Base Quantity
	OperationUnit	I_BillOfOperationsChangeState	OperationUnit	Unit of measure for activity
	OpQtyToBaseQtyNmrtr	I_BillOfOperationsChangeState	OpQtyToBaseQtyNmrtr	Numerator for Converting Routing and Operation UoM
	OpQtyToBaseQtyDnmntr	I_BillOfOperationsChangeState	OpQtyToBaseQtyDnmntr	Denominator for Converting Routing and Operation UoM
	_BillOfOperations		_BillOfOperations
	_BillOfOperationsGroup		_BillOfOperationsGroup
	_BillOfOperationsStatus		_BillOfOperationsStatus
	_BillOfOperationsType		_BillOfOperationsType
	_BillOfOperationsUnit		_BillOfOperationsUnit
	_BillOfOperationsUsage		_BillOfOperationsUsage
	_ChangeMaster		_ChangeMaster
	_CreatedByUser		_CreatedByUser
	_InspExtNumbering		_InspExtNumbering
	_InspLotDynamicRule		_InspLotDynamicRule
	_InspPartialLotAssignment		_InspPartialLotAssignment
	_InspSubsetFieldCombination		_InspSubsetFieldCombination
	_InspectionLotDynamicLevel		_InspectionLotDynamicLevel
	_LastChangedByUser		_LastChangedByUser
	_LineHierarchy		_LineHierarchy
	_LongTextLanguage		_LongTextLanguage
	_Plant		_Plant
	_ResponsiblePlannerGroup		_ResponsiblePlannerGroup
	_SampleDrawingProcedure		_SampleDrawingProcedure
	_SmplDrwgProcedureVersion		_SmplDrwgProcedureVersion
	_WorkCenter		_WorkCenter
	_WorkCenterType		_WorkCenterType

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_MfgBillOfOperationsChgSt.
-- 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: IMFGBILLOFOPERCS

CREATE VIEW I_MfgBillOfOperationsChgSt AS
SELECT
  plko.BillOfOperationsType AS BillOfOperationsType,
  plko.BillOfOperationsGroup AS BillOfOperationsGroup,
  plko.BillOfOperationsVariant AS BillOfOperationsVariant,
  plko.BOOInternalVersionCounter AS BOOInternalVersionCounter,
  plko.CreatedByUser AS CreatedByUser,
  plko.LastChangeDate AS LastChangeDate,
  plko.LastChangedByUser AS LastChangedByUser,
  plko.ChangedDateTime AS ChangedDateTime,
  plko.ValidityStartDate AS ValidityStartDate,
  plko.ValidityEndDate AS ValidityEndDate,
  plko.LastUsageDate AS LastUsageDate,
  plko.NumberOfUsages AS NumberOfUsages,
  plko.BillOfOperationsDateTime AS BillOfOperationsDateTime,
  plko.IsDeleted AS IsDeleted,
  plko.IsImplicitlyDeleted AS IsImplicitlyDeleted,
  plko.IsMarkedForDeletion AS IsMarkedForDeletion,
  plko.ReplacedBillOfOperations AS ReplacedBillOfOperations,
  plko.BillOfOperationsDesc AS BillOfOperationsDesc,
  plko.LongTextLanguageCode AS LongTextLanguageCode,
  plko.WorkCenterTypeCode AS WorkCenterTypeCode,
  plko.WorkCenterInternalID AS WorkCenterInternalID,
  plko.Plant AS Plant,
  plko.BillOfOperationsUsage AS BillOfOperationsUsage,
  plko.BillOfOperationsStatus AS BillOfOperationsStatus,
  plko.BillOfOperationsProfile AS BillOfOperationsProfile,
  plko.ResponsiblePlannerGroup AS ResponsiblePlannerGroup,
  plko.LineHierarchyInternalID AS LineHierarchyInternalID,
  plko.InspSubsetFieldCombination AS InspSubsetFieldCombination,
  plko.InspectionPartialLot AS InspectionPartialLot,
  plko.SmplDrawingProcedure AS SmplDrawingProcedure,
  plko.SmplDrawingProcedureVersion AS SmplDrawingProcedureVersion,
  plko.InspectionLotDynamicLevel AS InspectionLotDynamicLevel,
  plko.InspLotDynamicRule AS InspLotDynamicRule,
  plko.InspExternalNumberingOfValues AS InspExternalNumberingOfValues,
  plko.BillOfOperationsUnit AS BillOfOperationsUnit,
  plko.MinimumLotSizeQuantity AS MinimumLotSizeQuantity,
  plko.MaximumLotSizeQuantity AS MaximumLotSizeQuantity,
  plko.OperationReferenceQuantity AS OperationReferenceQuantity,
  plko.OperationUnit AS OperationUnit,
  plko.OpQtyToBaseQtyNmrtr AS OpQtyToBaseQtyNmrtr,
  plko.OpQtyToBaseQtyDnmntr AS OpQtyToBaseQtyDnmntr
FROM I_BillOfOperationsChangeState AS plko
LEFT OUTER JOIN I_MfgBillOfOperations AS _BillOfOperations ON BillOfOperationsType = _BillOfOperations.BillOfOperationsType AND BillOfOperationsGroup = _BillOfOperations.BillOfOperationsGroup AND BillOfOperationsVariant = _BillOfOperations.BillOfOperationsVariant  -- association [1..1]
;

Depth:

I_MfgBillOfOperationsChgSt view

I_BillOfOperationsChangeState view