What is I_InspPlanOpCharcVersion_2 in SAP S/4HANA?

I_InspPlanOpCharcVersion_2 is a composite CDS view in SAP S/4HANA. Version of Insp Plan Characteristic It contains 118 fields.

Which tables does I_InspPlanOpCharcVersion_2 read from?

I_InspPlanOpCharcVersion_2 reads data from: I_BOOCharacteristicVersion, I_InspPlanOpAssgmt.

What VDM layer is I_InspPlanOpCharcVersion_2?

I_InspPlanOpCharcVersion_2 is classified as a Composite view that combines data from multiple basic views.

I_InspPlanOpCharcVersion_2

DDL: I_INSPPLANOPCHARCVERSION_2 Type: view_entity COMPOSITE

118 Fields 2 Data Sources 5 Associations

Version of Insp Plan Characteristic

I_InspPlanOpCharcVersion_2 (Composite)

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

Manufacturing

I_InspPlanOpCharcVersion_2 is a Composite CDS View that provides data about "Version of Insp Plan Characteristic" in SAP S/4HANA. It reads from 2 data sources (I_BOOCharacteristicVersion, I_InspPlanOpAssgmt) and exposes 118 fields with key fields InspectionPlanGroup, BOOOperationInternalID, BOOCharacteristic, BOOCharacteristicVersion, InspectionPlan. It has 5 associations to related views.

SAP Help Documentation

Category	CDS Views for Quality Planning

Purpose
This CDS view retrieves the inspection characteristics of the operations of an inspection plan (task list type Q). This CDS view provides the data to answer the following business questions: Which inspection characteristics are assigned to the operation in the inspection plan? How must the inspection characteristics be inspected? To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view must have one of the following business catalogs assigned: SAP_QM_BC_INSP_PLANNING_PC (QM - Inspection Planning) SAP_QM_BC_INSP_PLNG_DSP_PC (QM - Inspection Planning Display) SAP_A4C_BC_DEV_TST_QM_PLNG_PC (Development - API Test - QM - Quality Planning)

Structure
Fields Used for Filtering The main filters are as follows: InspectionPlanGroup (Group) and InspectionPlan (Group Counter): These fields are used to filter for the inspection plan the characteristics are assigned to. BOOOperationInternalID : This field is used to filter for the operation the characteristics are assigned to. Further Important Fields Important fields in this view include the following: Field Name Description BOOCharacteristic Inspection Characteristic Number BOOCharcHasInspSpecReference Reference to Master Inspection Characteristic InspectionSpecification Master Inspection Characteristic InspectionSpecificationVersion Version Number of Master Inspection Characteristic InspectionSpecificationPlant Plant for Master Inspection Characteristic InspectionSpecificationText Short Text for Inspection Characteristic InspectionMethod Inspection Method InspectionMethodVersion Version Number of Inspection Method InspectionMethodPlant Plant for Inspection Method

Constraints
If a master inspection characteristic is referenced ( BOOCharcHasInspSpecReference = true), most attributes of the CDS view are initial. In this case, the values from the master inspection characteristic apply. You can read them using the CDS view I_InspSpecificationVersion ( Version of Master Inspection Characteristic ).

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Manufacturing
Application Component	QM-PT
Capabilities	Data Source in SQL Select, Association Target for Defining CDS Entities, Data Source for Defining CDS Entities
Package	Manufacturing for SAP S/4HANA Cloud Private Edition
Description	<p>This CDS view retrieves the inspection characteristics of the operations of an inspection plan (task list type Q).</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>Which inspection characteristics are assigned to the operation in the inspection plan?</p></li> <li><p>How must the inspection characteristics be inspected?</p></li> </ul> <p>To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views.</p>

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 (2)

Source	Alias	Join Type
I_BOOCharacteristicVersion	_BOOCharacteristicVersion	from
I_InspPlanOpAssgmt	_InspPlanOpAssgmt	inner

Associations (5)

Cardinality	Target	Alias	Condition
[1..1]	I_BillOfOperationsType	_BillOfOperationsType	`$projection.BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType`
[1..1]	I_BillOfOperationsGroup	_BillOfOperationsGroup	`$projection.BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType and $projection.InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup`
[1..1]	I_InspPlanOperationVersion_2	_InspPlanOperationVersion	`$projection.InspectionPlanGroup = _InspPlanOperationVersion.InspectionPlanGroup and $projection.BOOOperationInternalID = _InspPlanOperationVersion.BOOOperationInternalID and $projection.BillOfOperationsType = _InspPlanOperationVersion.BillOfOperationsType and $projection.ValidityStartDate >= _InspPlanOperationVersion.ValidityStartDate and $projection.ValidityStartDate <= _InspPlanOperationVersion.ValidityEndDate`
[1..1]	I_InspectionPlanVersion	_InspPlanVersion	`$projection.InspectionPlanGroup = _InspPlanVersion.InspectionPlanGroup and $projection.InspectionPlan = _InspPlanVersion.InspectionPlan and $projection.BillOfOperationsType = _InspPlanVersion.BillOfOperationsType and $projection.ValidityStartDate >= _InspPlanVersion.ValidityStartDate and $projection.ValidityStartDate <= _InspPlanVersion.ValidityEndDate`
[1..1]	E_BOOCharacteristic	_Extension	`$projection.BillOfOperationsType = _Extension.BillOfOperationsType and $projection.InspectionPlanGroup = _Extension.BillOfOperationsGroup and $projection.BOOOperationInternalID = _Extension.BOOOperationInternalID and $projection.BOOCharacteristic = _Extension.BOOCharacteristic and $projection.BOOCharacteristicVersion = _Extension.BOOCharacteristicVersion`

Annotations (8)

Name	Value	Level
EndUserText.label	Version of Insp Plan Characteristic	view
AccessControl.authorizationCheck	#MANDATORY	view
Metadata.ignorePropagatedAnnotations	true	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_LOCAL_API	view
ObjectModel.usageType.serviceQuality	#C	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view

Fields (118)

Key	Field	Source Table	Source Field	Description
KEY	InspectionPlanGroup	I_BOOCharacteristicVersion	BillOfOperationsGroup	Key for Task List Group
KEY	BOOOperationInternalID	I_BOOCharacteristicVersion	BOOOperationInternalID	Number of the Task List Node
KEY	BOOCharacteristic	I_BOOCharacteristicVersion	BOOCharacteristic	Inspection Characteristic Number
KEY	BOOCharacteristicVersion	I_BOOCharacteristicVersion	BOOCharacteristicVersion	Internal counter
KEY	InspectionPlan	I_InspPlanOpAssgmt	InspectionPlan	Group Counter
KEY	BillOfOperationsType	I_BOOCharacteristicVersion	BillOfOperationsType	Task List Type
	ValidityStartDate	I_BOOCharacteristicVersion	ValidityStartDate	Validity Start Date
	ValidityEndDate	I_BOOCharacteristicVersion	ValidityEndDate	Valid-to date
	ChangeNumber	I_BOOCharacteristicVersion	ChangeNumber	Change Number
	IsDeleted	I_BOOCharacteristicVersion	IsDeleted	Deletion Indicator
	BOOOperationPRTInternalID	I_BOOCharacteristicVersion	BOOOperationPRTInternalID	Assigned Test Equipment
	InspectionMethod	I_BOOCharacteristicVersion	InspectionMethod	Inspection Method
	InspectionMethodVersion	I_BOOCharacteristicVersion	InspectionMethodVersion	Version Number of Inspection Method
	InspectionMethodPlant	I_BOOCharacteristicVersion	InspectionMethodPlant	Plant for Inspection Method
	InspSpecImportanceCode	I_BOOCharacteristicVersion	InspSpecImportanceCode	Weighting of Characteristic
	InspectorQualification	I_BOOCharacteristicVersion	InspectorQualification	Inspector Qualification
	InspectionSpecification	I_BOOCharacteristicVersion	InspectionSpecification	Master Inspection Characteristic
	InspectionSpecificationVersion	I_BOOCharacteristicVersion	InspectionSpecificationVersion	Version Number of Master Inspection Characteristic
	InspectionSpecificationPlant	I_BOOCharacteristicVersion	InspectionSpecificationPlant	Plant for Master Inspection Characteristic
	BOOCharcHasInspSpecReference	I_BOOCharacteristicVersion	BOOCharcHasInspSpecReference	Reference to Master Insp. Characteristic in Task List
	InspSpecControlIndicators	I_BOOCharacteristicVersion	InspSpecControlIndicators	Cntrl Indicator String for Insp. Char./Master Insp. Char.
	InspSpecIsQuantitative	I_BOOCharacteristicVersion	InspSpecIsQuantitative	Is Quantitative Characteristic
	InspSpecCharacteristicType	I_BOOCharacteristicVersion	InspSpecCharacteristicType	Characteristic Type
	InspSpecIsMeasuredValueRqd	I_BOOCharacteristicVersion	InspSpecIsMeasuredValueRqd	Measured Values Must Be Recorded
	InspSpecIsSelectedSetRequired	I_BOOCharacteristicVersion	InspSpecIsSelectedSetRequired	Reference to Characteristic Attribute Required
	InspSpecIsUpperLimitRequired	I_BOOCharacteristicVersion	InspSpecIsUpperLimitRequired	Upper Specification Limit
	InspSpecIsLowerLimitRequired	I_BOOCharacteristicVersion	InspSpecIsLowerLimitRequired	Lower Specification Limit
	InspSpecIsTargetValueInLimit	I_BOOCharacteristicVersion	InspSpecIsTargetValueInLimit	Check Target Value
	InspectionScope	I_BOOCharacteristicVersion	InspectionScope	Inspection Scope
	InspSpecIsLongTermInspection	I_BOOCharacteristicVersion	InspSpecIsLongTermInspection	Long-Term Inspection
	InspSpecRecordingType	I_BOOCharacteristicVersion	InspSpecRecordingType	Recording Type
	InspResultIsDocumentationRqd	I_BOOCharacteristicVersion	InspResultIsDocumentationRqd	Documentation Required for Inspection Result
	InspSpecCharcCategory	I_BOOCharacteristicVersion	InspSpecCharcCategory	Characteristic Category
	InspSpecIsSampleQtyAdditive	I_BOOCharacteristicVersion	InspSpecIsSampleQtyAdditive	Inspection Sample Quantity Is Added
	InspSpecIsDestructive	I_BOOCharacteristicVersion	InspSpecIsDestructive	Destructive Inspection
	InspSpecResultCalculation	I_BOOCharacteristicVersion	InspSpecResultCalculation	Characteristic Result Calculation
	InspSpecIsSamplingProcedRqd	I_BOOCharacteristicVersion	InspSpecIsSamplingProcedRqd	Sampling Procedure Is Required
	InspSpecIsScrapRelevant	I_BOOCharacteristicVersion	InspSpecIsScrapRelevant	Characteristic Relevant for Quality Score and Scrap Share
	InspSpecHasFixedCtrlIndicators	I_BOOCharacteristicVersion	InspSpecHasFixedCtrlIndicators	Default Control Indicators Cannot Be Changed
	InspSpecIsDefectRecordingRqd	I_BOOCharacteristicVersion	InspSpecIsDefectRecordingRqd	Recording the Number of Defects
	InspSpecIsTestEquipmentRqd	I_BOOCharacteristicVersion	InspSpecIsTestEquipmentRqd	Assignment of Test Equipment Required
	InspSpecIsDefectsRecgAutomatic	I_BOOCharacteristicVersion	InspSpecIsDefectsRecgAutomatic	Defects Recording Automatically Called Up
	InspSpecIsChgDocRequired	I_BOOCharacteristicVersion	InspSpecIsChgDocRequired	Create Change Documents During Results Recording
	InspSpecIsControlChartUsed	I_BOOCharacteristicVersion	InspSpecIsControlChartUsed	SPC Characteristic
	InspSpecPrintControl	I_BOOCharacteristicVersion	InspSpecPrintControl	Inspection Print Control
	InspToleranceSpecification	I_BOOCharacteristicVersion	InspToleranceSpecification	Tolerance Key
	InspSpecDecimalPlaces	I_BOOCharacteristicVersion	InspSpecDecimalPlaces	Number of Places to the Right of a Decimal Point (Accuracy)
	InspectionSpecificationUnit	I_BOOCharacteristicVersion	InspectionSpecificationUnit	Unit of Measurement in Which Quantitative Data Is Stored
	InspSpecTargetValue	I_BOOCharacteristicVersion	InspSpecTargetValue	Target Value for a Quantitative Characteristic
	InspSpecHasTargetValue	I_BOOCharacteristicVersion	InspSpecHasTargetValue	Value Not Initial If Set
	InspSpecUpperLimit	I_BOOCharacteristicVersion	InspSpecUpperLimit	Upper Specification Limit
	InspSpecLowerLimit	I_BOOCharacteristicVersion	InspSpecLowerLimit	Lower Specification Limit
	InspSpecHasLowerLimit	I_BOOCharacteristicVersion	InspSpecHasLowerLimit	Value Not Initial If Set
	InspSpecHasUpperLimit	I_BOOCharacteristicVersion	InspSpecHasUpperLimit	Value Not Initial If Set
	InspSpecInputProcedure	I_BOOCharacteristicVersion	InspSpecInputProcedure	Parameters for Input Processing in QM Results Recording
	InspSpecHasFormula	I_BOOCharacteristicVersion	InspSpecHasFormula	Check and Calculate Formula in QM
	InspSpecFormula1	I_BOOCharacteristicVersion	InspSpecFormula1	Formula Field
	InspSpecFormula2	I_BOOCharacteristicVersion	InspSpecFormula2	Formula Field
	InspSpecNumberOfClasses	I_BOOCharacteristicVersion	InspSpecNumberOfClasses	Number of Value Classes for Inspection Results
	InspSpecClassWidthQty	I_BOOCharacteristicVersion	InspSpecClassWidthQty	Class Width
	InspSpecHasClassWidth	I_BOOCharacteristicVersion	InspSpecHasClassWidth	Value Not Initial If Set
	InspSpecClassMidpointQty	I_BOOCharacteristicVersion	InspSpecClassMidpointQty	Class Midpoint
	InspSpecHasClassMidpoint	I_BOOCharacteristicVersion	InspSpecHasClassMidpoint	Value Not Initial If Set
	InspSpecFirstUpperSpecLimit	I_BOOCharacteristicVersion	InspSpecFirstUpperSpecLimit	First Upper Specification Limit
	InspSpecHasFirstUpperSpecLimit	I_BOOCharacteristicVersion	InspSpecHasFirstUpperSpecLimit	Value Not Initial If Set
	InspSpecFirstLowerSpecLimit	I_BOOCharacteristicVersion	InspSpecFirstLowerSpecLimit	First Lower Specification Limit
	InspSpecHasFirstLowerSpecLimit	I_BOOCharacteristicVersion	InspSpecHasFirstLowerSpecLimit	Value Not Initial If Set
	InspSpecSecondUpperSpecLimit	I_BOOCharacteristicVersion	InspSpecSecondUpperSpecLimit	Second Upper Specification Limit
	InspSpecHasSecondUprSpecLimit	I_BOOCharacteristicVersion	InspSpecHasSecondUprSpecLimit	Value Not Initial If Set
	InspSpecSecondLowerSpecLimit	I_BOOCharacteristicVersion	InspSpecSecondLowerSpecLimit	Second Lower Specification Limit
	InspSpecHasSecondLowrSpecLimit	I_BOOCharacteristicVersion	InspSpecHasSecondLowrSpecLimit	Value Not Initial If Set
	InspSpecDefectCodeGrpRejection	I_BOOCharacteristicVersion	InspSpecDefectCodeGrpRejection	Defect Code Group for General Rejection
	InspSpecDefectCodeRejection	I_BOOCharacteristicVersion	InspSpecDefectCodeRejection	Defect Code for Rejection: General
	InspSpecDefectCodeGrpRjcnUpper	I_BOOCharacteristicVersion	InspSpecDefectCodeGrpRjcnUpper	Defect Code Group for Rejection at Upper Tolerance
	InspSpecDefectCodeRjcnUpper	I_BOOCharacteristicVersion	InspSpecDefectCodeRjcnUpper	Defect Code for Rejection at Upper Specification Limit
	InspSpecDefectCodeGrpRjcnLower	I_BOOCharacteristicVersion	InspSpecDefectCodeGrpRjcnLower	Defect Code Group for Rejection at Lower Tolerance
	InspSpecDefectCodeRjcnLower	I_BOOCharacteristicVersion	InspSpecDefectCodeRjcnLower	Defect Code for Rejection at Lower Specification Limit
	SelectedCodeSet	I_BOOCharacteristicVersion	SelectedCodeSet	Assigned Code Group or Selected Set
	SelectedCodeSetPlant	I_BOOCharacteristicVersion	SelectedCodeSetPlant	Plant of the Assigned Selected Set
	InspSpecAdditionalCatalog2	I_BOOCharacteristicVersion	InspSpecAdditionalCatalog2	Catalog Type of Assigned Code Group or Selected Set
	InspSpecAdditionalSelectedSet2	I_BOOCharacteristicVersion	InspSpecAdditionalSelectedSet2	Assigned Code Group or Selected Set
	InspSpecAdditionalCodeGroup2	I_BOOCharacteristicVersion	InspSpecAdditionalCodeGroup2	Assigned Code Group or Selected Set
	InspSpecAddlSeldCodeSetPlant2	I_BOOCharacteristicVersion	InspSpecAddlSeldCodeSetPlant2	Plant of the Assigned Selected Set
	InspSpecAdditionalCatalog3	I_BOOCharacteristicVersion	InspSpecAdditionalCatalog3	Catalog Type of Assigned Code Group or Selected Set
	InspSpecAdditionalSelectedSet3	I_BOOCharacteristicVersion	InspSpecAdditionalSelectedSet3	Assigned Code Group or Selected Set
	InspSpecAdditionalCodeGroup3	I_BOOCharacteristicVersion	InspSpecAdditionalCodeGroup3	Assigned Code Group or Selected Set
	InspSpecAddlSeldCodeSetPlant3	I_BOOCharacteristicVersion	InspSpecAddlSeldCodeSetPlant3	Plant of the Assigned Selected Set
	InspSpecAdditionalCatalog4	I_BOOCharacteristicVersion	InspSpecAdditionalCatalog4	Catalog Type of Assigned Code Group or Selected Set
	InspSpecAdditionalSelectedSet4	I_BOOCharacteristicVersion	InspSpecAdditionalSelectedSet4	Assigned Code Group or Selected Set
	InspSpecAdditionalCodeGroup4	I_BOOCharacteristicVersion	InspSpecAdditionalCodeGroup4	Assigned Code Group or Selected Set
	InspSpecAddlSeldCodeSetPlant4	I_BOOCharacteristicVersion	InspSpecAddlSeldCodeSetPlant4	Plant of the Assigned Selected Set
	InspSpecAdditionalCatalog5	I_BOOCharacteristicVersion	InspSpecAdditionalCatalog5	Catalog Type of Assigned Code Group or Selected Set
	InspSpecAdditionalSelectedSet5	I_BOOCharacteristicVersion	InspSpecAdditionalSelectedSet5	Assigned Code Group or Selected Set
	InspSpecAdditionalCodeGroup5	I_BOOCharacteristicVersion	InspSpecAdditionalCodeGroup5	Assigned Code Group or Selected Set
	InspSpecAddlSeldCodeSetPlant5	I_BOOCharacteristicVersion	InspSpecAddlSeldCodeSetPlant5	Plant of the Assigned Selected Set
	SamplingProcedure	I_BOOCharacteristicVersion	SamplingProcedure	Sampling Procedure in Inspection Characteristic
	InspCharacteristicSampleUnit	I_BOOCharacteristicVersion	InspCharacteristicSampleUnit	Sample Unit of Measure
	BOOCharcSampleQuantity	I_BOOCharacteristicVersion	BOOCharcSampleQuantity	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)
	QltyCtrlChartAggrgnCriterion	I_BOOCharacteristicVersion	QltyCtrlChartAggrgnCriterion	SPC Criterion
	InspSpecInformationField1	I_BOOCharacteristicVersion	InspSpecInformationField1	Text Line for Additional Information
	InspSpecInformationField2	I_BOOCharacteristicVersion	InspSpecInformationField2	Text Line for Additional Information
	InspSpecInformationField3	I_BOOCharacteristicVersion	InspSpecInformationField3	Text Line for Additional Information
	InspectionSpecificationText	I_BOOCharacteristicVersion	InspectionSpecificationText	Short Text for Inspection Characteristic
	InspLotDynamicRule	I_BOOCharacteristicVersion	InspLotDynamicRule	Dynamic Modification Rule
	InspCharcDynModifRef	I_BOOCharacteristicVersion	InspCharcDynModifRef	Characteristic (in Plan) whose Q-Level Will Be Copied
	MatlIsConsideredForDynModif	I_BOOCharacteristicVersion	MatlIsConsideredForDynModif	Material Considered for Dynamic Modification
	SuplrIsConsideredForDynModif	I_BOOCharacteristicVersion	SuplrIsConsideredForDynModif	Supplier Considered for Dynamic Modification
	MfrIsConsideredForDynModif	I_BOOCharacteristicVersion	MfrIsConsideredForDynModif	Manufacturer Considered for Dynamic Modification
	CustIsConsideredForDynModif	I_BOOCharacteristicVersion	CustIsConsideredForDynModif	Customer Considered for Dynamic Modification
	CreatedByUser	I_BOOCharacteristicVersion	CreatedByUser	User who created record
	CreationDate	I_BOOCharacteristicVersion	CreationDate	System Date on Which Data Record Was Created
	LastChangedByUser	I_BOOCharacteristicVersion	LastChangedByUser	Name of User Who Last Changed Data Record
	LastChangeDate	I_BOOCharacteristicVersion	LastChangeDate	System Date on Which Data Record Was Changed
	BillOfOperationsVersion	I_BOOCharacteristicVersion	BillOfOperationsVersion	Routing Version
	_BillOfOperationsType		_BillOfOperationsType
	_BillOfOperationsGroup		_BillOfOperationsGroup
	_InspPlanVersion		_InspPlanVersion
	_InspPlanOperationVersion		_InspPlanOperationVersion

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_InspPlanOpCharcVersion_2.
-- 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_InspPlanOpCharcVersion_2 AS
SELECT
  _BOOCharacteristicVersion.BillOfOperationsGroup AS InspectionPlanGroup,
  _BOOCharacteristicVersion.BOOOperationInternalID AS BOOOperationInternalID,
  _BOOCharacteristicVersion.BOOCharacteristic AS BOOCharacteristic,
  _BOOCharacteristicVersion.BOOCharacteristicVersion AS BOOCharacteristicVersion,
  _InspPlanOpAssgmt.InspectionPlan AS InspectionPlan,
  _BOOCharacteristicVersion.BillOfOperationsType AS BillOfOperationsType,
  _BOOCharacteristicVersion.ValidityStartDate AS ValidityStartDate,
  _BOOCharacteristicVersion.ValidityEndDate AS ValidityEndDate,
  _BOOCharacteristicVersion.ChangeNumber AS ChangeNumber,
  _BOOCharacteristicVersion.IsDeleted AS IsDeleted,
  _BOOCharacteristicVersion.BOOOperationPRTInternalID AS BOOOperationPRTInternalID,
  _BOOCharacteristicVersion.InspectionMethod AS InspectionMethod,
  _BOOCharacteristicVersion.InspectionMethodVersion AS InspectionMethodVersion,
  _BOOCharacteristicVersion.InspectionMethodPlant AS InspectionMethodPlant,
  _BOOCharacteristicVersion.InspSpecImportanceCode AS InspSpecImportanceCode,
  _BOOCharacteristicVersion.InspectorQualification AS InspectorQualification,
  _BOOCharacteristicVersion.InspectionSpecification AS InspectionSpecification,
  _BOOCharacteristicVersion.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  _BOOCharacteristicVersion.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  _BOOCharacteristicVersion.BOOCharcHasInspSpecReference AS BOOCharcHasInspSpecReference,
  _BOOCharacteristicVersion.InspSpecControlIndicators AS InspSpecControlIndicators,
  _BOOCharacteristicVersion.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  _BOOCharacteristicVersion.InspSpecCharacteristicType AS InspSpecCharacteristicType,
  _BOOCharacteristicVersion.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  _BOOCharacteristicVersion.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  _BOOCharacteristicVersion.InspSpecIsUpperLimitRequired AS InspSpecIsUpperLimitRequired,
  _BOOCharacteristicVersion.InspSpecIsLowerLimitRequired AS InspSpecIsLowerLimitRequired,
  _BOOCharacteristicVersion.InspSpecIsTargetValueInLimit AS InspSpecIsTargetValueInLimit,
  _BOOCharacteristicVersion.InspectionScope AS InspectionScope,
  _BOOCharacteristicVersion.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  _BOOCharacteristicVersion.InspSpecRecordingType AS InspSpecRecordingType,
  _BOOCharacteristicVersion.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd,
  _BOOCharacteristicVersion.InspSpecCharcCategory AS InspSpecCharcCategory,
  _BOOCharacteristicVersion.InspSpecIsSampleQtyAdditive AS InspSpecIsSampleQtyAdditive,
  _BOOCharacteristicVersion.InspSpecIsDestructive AS InspSpecIsDestructive,
  _BOOCharacteristicVersion.InspSpecResultCalculation AS InspSpecResultCalculation,
  _BOOCharacteristicVersion.InspSpecIsSamplingProcedRqd AS InspSpecIsSamplingProcedRqd,
  _BOOCharacteristicVersion.InspSpecIsScrapRelevant AS InspSpecIsScrapRelevant,
  _BOOCharacteristicVersion.InspSpecHasFixedCtrlIndicators AS InspSpecHasFixedCtrlIndicators,
  _BOOCharacteristicVersion.InspSpecIsDefectRecordingRqd AS InspSpecIsDefectRecordingRqd,
  _BOOCharacteristicVersion.InspSpecIsTestEquipmentRqd AS InspSpecIsTestEquipmentRqd,
  _BOOCharacteristicVersion.InspSpecIsDefectsRecgAutomatic AS InspSpecIsDefectsRecgAutomatic,
  _BOOCharacteristicVersion.InspSpecIsChgDocRequired AS InspSpecIsChgDocRequired,
  _BOOCharacteristicVersion.InspSpecIsControlChartUsed AS InspSpecIsControlChartUsed,
  _BOOCharacteristicVersion.InspSpecPrintControl AS InspSpecPrintControl,
  _BOOCharacteristicVersion.InspToleranceSpecification AS InspToleranceSpecification,
  _BOOCharacteristicVersion.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  _BOOCharacteristicVersion.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  _BOOCharacteristicVersion.InspSpecTargetValue AS InspSpecTargetValue,
  _BOOCharacteristicVersion.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  _BOOCharacteristicVersion.InspSpecUpperLimit AS InspSpecUpperLimit,
  _BOOCharacteristicVersion.InspSpecLowerLimit AS InspSpecLowerLimit,
  _BOOCharacteristicVersion.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  _BOOCharacteristicVersion.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  _BOOCharacteristicVersion.InspSpecInputProcedure AS InspSpecInputProcedure,
  _BOOCharacteristicVersion.InspSpecHasFormula AS InspSpecHasFormula,
  _BOOCharacteristicVersion.InspSpecFormula1 AS InspSpecFormula1,
  _BOOCharacteristicVersion.InspSpecFormula2 AS InspSpecFormula2,
  _BOOCharacteristicVersion.InspSpecNumberOfClasses AS InspSpecNumberOfClasses,
  _BOOCharacteristicVersion.InspSpecClassWidthQty AS InspSpecClassWidthQty,
  _BOOCharacteristicVersion.InspSpecHasClassWidth AS InspSpecHasClassWidth,
  _BOOCharacteristicVersion.InspSpecClassMidpointQty AS InspSpecClassMidpointQty,
  _BOOCharacteristicVersion.InspSpecHasClassMidpoint AS InspSpecHasClassMidpoint,
  _BOOCharacteristicVersion.InspSpecFirstUpperSpecLimit AS InspSpecFirstUpperSpecLimit,
  _BOOCharacteristicVersion.InspSpecHasFirstUpperSpecLimit AS InspSpecHasFirstUpperSpecLimit,
  _BOOCharacteristicVersion.InspSpecFirstLowerSpecLimit AS InspSpecFirstLowerSpecLimit,
  _BOOCharacteristicVersion.InspSpecHasFirstLowerSpecLimit AS InspSpecHasFirstLowerSpecLimit,
  _BOOCharacteristicVersion.InspSpecSecondUpperSpecLimit AS InspSpecSecondUpperSpecLimit,
  _BOOCharacteristicVersion.InspSpecHasSecondUprSpecLimit AS InspSpecHasSecondUprSpecLimit,
  _BOOCharacteristicVersion.InspSpecSecondLowerSpecLimit AS InspSpecSecondLowerSpecLimit,
  _BOOCharacteristicVersion.InspSpecHasSecondLowrSpecLimit AS InspSpecHasSecondLowrSpecLimit,
  _BOOCharacteristicVersion.InspSpecDefectCodeGrpRejection AS InspSpecDefectCodeGrpRejection,
  _BOOCharacteristicVersion.InspSpecDefectCodeRejection AS InspSpecDefectCodeRejection,
  _BOOCharacteristicVersion.InspSpecDefectCodeGrpRjcnUpper AS InspSpecDefectCodeGrpRjcnUpper,
  _BOOCharacteristicVersion.InspSpecDefectCodeRjcnUpper AS InspSpecDefectCodeRjcnUpper,
  _BOOCharacteristicVersion.InspSpecDefectCodeGrpRjcnLower AS InspSpecDefectCodeGrpRjcnLower,
  _BOOCharacteristicVersion.InspSpecDefectCodeRjcnLower AS InspSpecDefectCodeRjcnLower,
  _BOOCharacteristicVersion.SelectedCodeSet AS SelectedCodeSet,
  _BOOCharacteristicVersion.SelectedCodeSetPlant AS SelectedCodeSetPlant,
  _BOOCharacteristicVersion.InspSpecAdditionalCatalog2 AS InspSpecAdditionalCatalog2,
  _BOOCharacteristicVersion.InspSpecAdditionalSelectedSet2 AS InspSpecAdditionalSelectedSet2,
  _BOOCharacteristicVersion.InspSpecAdditionalCodeGroup2 AS InspSpecAdditionalCodeGroup2,
  _BOOCharacteristicVersion.InspSpecAddlSeldCodeSetPlant2 AS InspSpecAddlSeldCodeSetPlant2,
  _BOOCharacteristicVersion.InspSpecAdditionalCatalog3 AS InspSpecAdditionalCatalog3,
  _BOOCharacteristicVersion.InspSpecAdditionalSelectedSet3 AS InspSpecAdditionalSelectedSet3,
  _BOOCharacteristicVersion.InspSpecAdditionalCodeGroup3 AS InspSpecAdditionalCodeGroup3,
  _BOOCharacteristicVersion.InspSpecAddlSeldCodeSetPlant3 AS InspSpecAddlSeldCodeSetPlant3,
  _BOOCharacteristicVersion.InspSpecAdditionalCatalog4 AS InspSpecAdditionalCatalog4,
  _BOOCharacteristicVersion.InspSpecAdditionalSelectedSet4 AS InspSpecAdditionalSelectedSet4,
  _BOOCharacteristicVersion.InspSpecAdditionalCodeGroup4 AS InspSpecAdditionalCodeGroup4,
  _BOOCharacteristicVersion.InspSpecAddlSeldCodeSetPlant4 AS InspSpecAddlSeldCodeSetPlant4,
  _BOOCharacteristicVersion.InspSpecAdditionalCatalog5 AS InspSpecAdditionalCatalog5,
  _BOOCharacteristicVersion.InspSpecAdditionalSelectedSet5 AS InspSpecAdditionalSelectedSet5,
  _BOOCharacteristicVersion.InspSpecAdditionalCodeGroup5 AS InspSpecAdditionalCodeGroup5,
  _BOOCharacteristicVersion.InspSpecAddlSeldCodeSetPlant5 AS InspSpecAddlSeldCodeSetPlant5,
  _BOOCharacteristicVersion.SamplingProcedure AS SamplingProcedure,
  _BOOCharacteristicVersion.InspCharacteristicSampleUnit AS InspCharacteristicSampleUnit,
  _BOOCharacteristicVersion.BOOCharcSampleQuantity AS BOOCharcSampleQuantity,
  _BOOCharacteristicVersion.QltyCtrlChartAggrgnCriterion AS QltyCtrlChartAggrgnCriterion,
  _BOOCharacteristicVersion.InspSpecInformationField1 AS InspSpecInformationField1,
  _BOOCharacteristicVersion.InspSpecInformationField2 AS InspSpecInformationField2,
  _BOOCharacteristicVersion.InspSpecInformationField3 AS InspSpecInformationField3,
  _BOOCharacteristicVersion.InspectionSpecificationText AS InspectionSpecificationText,
  _BOOCharacteristicVersion.InspLotDynamicRule AS InspLotDynamicRule,
  _BOOCharacteristicVersion.InspCharcDynModifRef AS InspCharcDynModifRef,
  _BOOCharacteristicVersion.MatlIsConsideredForDynModif AS MatlIsConsideredForDynModif,
  _BOOCharacteristicVersion.SuplrIsConsideredForDynModif AS SuplrIsConsideredForDynModif,
  _BOOCharacteristicVersion.MfrIsConsideredForDynModif AS MfrIsConsideredForDynModif,
  _BOOCharacteristicVersion.CustIsConsideredForDynModif AS CustIsConsideredForDynModif,
  _BOOCharacteristicVersion.CreatedByUser AS CreatedByUser,
  _BOOCharacteristicVersion.CreationDate AS CreationDate,
  _BOOCharacteristicVersion.LastChangedByUser AS LastChangedByUser,
  _BOOCharacteristicVersion.LastChangeDate AS LastChangeDate,
  _BOOCharacteristicVersion.BillOfOperationsVersion AS BillOfOperationsVersion
FROM I_BOOCharacteristicVersion AS _BOOCharacteristicVersion
INNER JOIN I_InspPlanOpAssgmt AS _InspPlanOpAssgmt ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_BillOfOperationsType AS _BillOfOperationsType ON BillOfOperationsType = _BillOfOperationsType.BillOfOperationsType  -- association [1..1]
LEFT OUTER JOIN I_BillOfOperationsGroup AS _BillOfOperationsGroup ON BillOfOperationsType = _BillOfOperationsGroup.BillOfOperationsType AND InspectionPlanGroup = _BillOfOperationsGroup.BillOfOperationsGroup  -- association [1..1]
LEFT OUTER JOIN I_InspPlanOperationVersion_2 AS _InspPlanOperationVersion ON InspectionPlanGroup = _InspPlanOperationVersion.InspectionPlanGroup AND BOOOperationInternalID = _InspPlanOperationVersion.BOOOperationInternalID AND BillOfOperationsType = _InspPlanOperationVersion.BillOfOperationsType AND ValidityStartDate >= _InspPlanOperationVersion.ValidityStartDate AND ValidityStartDate <= _InspPlanOperationVersion.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN I_InspectionPlanVersion AS _InspPlanVersion ON InspectionPlanGroup = _InspPlanVersion.InspectionPlanGroup AND InspectionPlan = _InspPlanVersion.InspectionPlan AND BillOfOperationsType = _InspPlanVersion.BillOfOperationsType AND ValidityStartDate >= _InspPlanVersion.ValidityStartDate AND ValidityStartDate <= _InspPlanVersion.ValidityEndDate  -- association [1..1]
LEFT OUTER JOIN E_BOOCharacteristic AS _Extension ON BillOfOperationsType = _Extension.BillOfOperationsType AND InspectionPlanGroup = _Extension.BillOfOperationsGroup AND BOOOperationInternalID = _Extension.BOOOperationInternalID AND BOOCharacteristic = _Extension.BOOCharacteristic AND BOOCharacteristicVersion = _Extension.BOOCharacteristicVersion  -- association [1..1]
;

Depth:

I_InspPlanOpCharcVersion_2 view_entity

I_BOOCharacteristicVersion view
I_InspPlanOpAssgmt view