What is I_ProdnRtgInspCharcAssgmtDEX in SAP S/4HANA?

I_ProdnRtgInspCharcAssgmtDEX is a basic CDS view in SAP S/4HANA. Prodn Rtg Insp Charcs Assignment It contains 106 fields.

Which tables does I_ProdnRtgInspCharcAssgmtDEX read from?

I_ProdnRtgInspCharcAssgmtDEX reads data from: P_ProdnRtgInspCharcsAssgmtDEX.

What VDM layer is I_ProdnRtgInspCharcAssgmtDEX?

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

I_ProdnRtgInspCharcAssgmtDEX

DDL: I_PRODNRTGINSPCHARCASSGMTDEX Type: view_entity BASIC Package: VDM_PP_MD_RTG

106 Fields 1 Data Sources 1 Associations

Prodn Rtg Insp Charcs Assignment

I_ProdnRtgInspCharcAssgmtDEX (Basic)

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

ProductionRtgInspCharcsAssgmt · Manufacturing

I_ProdnRtgInspCharcAssgmtDEX is a Basic CDS View (Dimension) that provides data about "Prodn Rtg Insp Charcs Assignment" in SAP S/4HANA. It reads from 1 data source (P_ProdnRtgInspCharcsAssgmtDEX) and exposes 106 fields with key fields BillOfOperationsType, ProductionRoutingGroup, BOOCharacteristicType, ProductionRoutingOpIntID, BOOCharacteristic. It has 1 association to related views. Part of development package VDM_PP_MD_RTG.

SAP Help Documentation

Category	CDS Views for Basic Routing Data
Data Category	DIMENSION

Purpose
This CDS view is designed to provide detailed information about the assignment of inspection characteristics within production routing. It serves as a dimension view that can be used for analytical purposes, allowing users to extract and analyze data related to production routing inspection characteristics. This CDS view provides the data to answer the following business questions: What are the inspection characteristics assigned to specific production routings? How are inspection methods and specifications linked to production operations? What are the validity periods for different inspection characteristics within production routings? What are the control indicators and tolerance specifications associated with inspection characteristics? How are defect codes and catalog entries managed within production routing inspection characteristics? What sampling procedures and sample data are associated with inspection characteristics? What administrative data, such as creation and last change information, is available for inspection characteristics? How are dynamic modification rules and quality control criteria applied to inspection characteristics in production routings? 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 a role with the following restriction types set to read access: C_ROUT - Authorizations for Routings These restriction types are edited in the Maintain Business Roles app.

Structure
Important Fields Important fields in this view include the following: Field Name Description BOOCharacteristic Insp. Characteristic BOOCHARCDIVISION Internal Division ID BOOCharcSourceCharc Source Charc BOOCharcGroup Characteristic Group BOOCharcGroupDivision Internal Division ID InspCharcDynModifRef DynMod. as for char. BOOCharacteristicVersion Counter ProductionRoutingOpIntID Task List Node BOOOperationPRTInternalID Test equipment InspSpecToleranceChgValidTo Tolerance Valid To InspSpecToleranceChgValidFrom Tolerance Valid From LastChangeDate Changed On ValidityStartDate Valid From ValidityEndDate Valid To CreationDate Created On InspectionMethodPlant Insp. Method Plant BOOCharacteristicType Characteristic type InspSpecHasUprPlausibilityLmt Not Initial InspSpecLowerPlausibilityLimit Lower Plausib. Limit InspSpecHasLowrPlausibilityLmt Not Initial InspSpecHasFirstUpperSpecLimit Not Initial InspSpecHasClassMidpoint Not Initial InspSpecHasFirstLowerSpecLimit Not Initial InspSpecHasSecondUprSpecLimit Not Initial InspSpecHasSecondLowrSpecLimit Not Initial InspSpecHasUprSpecLimitChange Not Initial InspSpecHasLowrSpecLimitChange Not Initial InspSpecHasClassWidth Not Initial BOOCharcSampleQuantity Base Sample Quantity InspSpecClassMidpointQty Class Midpoint InspSpecClassWidthQty Class Width InspSpecLowerSpecLimitChange Change to Lower Specification Limit InspSpecUpperSpecLimitChange Change to Upper Specification Limit InspSpecSecondLowerSpecLimit 2nd Lower Limit InspSpecSecondUpperSpecLimit 2nd Upper Limit InspSpecFirstLowerSpecLimit 1st Lower Limit InspSpecFirstUpperSpecLimit 1st Upper Limit InspSpecLowerPlausibilityLimit Lower Plausib. Limit InspSpecUpperPlausibilityLimit Upper Plausib. Limit InspSpecLowerLimit Lower Specif. Limit InspSpecUpperLimit Upper Specif. Limit InspSpecTargetValue Target Value InspectionSpecification Master Insp. Charac. InspectionMethod Inspection Method InspectionSpecificationVersion Version InspectionMethodVersion Version InspCharacteristicSampleUnit Sample Unit of Meas. InspectionSpecificationUnit Unit of Measurement ProductionRoutingGroup Grou

View on SAP Help Portal →

SAP API Hub

Category	Basic
State	C1
Line of Business	Manufacturing
Application Component	PP-VDM-MD-2CL
Capabilities	Data Source for Data Extraction,Association Target for Defining CDS Entities,Analytical Dimension
Extensible (Key User)	No
Extensible (Developer)	No
Release State (Key User)	Released
Release State (Developer)	Not Released
Package	Manufacturing for SAP S/4HANA Cloud Public Edition
Description	<p>This CDS view is designed to provide detailed information about the assignment of inspection characteristics within production routing. It serves as a dimension view that can be used for analytical purposes, allowing users to extract and analyze data related to production routing inspection characteristics.</p> <p>This CDS view provides the data to answer the following business questions:</p> <ul> <li><p>What are the inspection characteristics assigned to specific production routings?</p></li> <li><p>How are inspection methods and specifications linked to production operations?</p></li> <li><p>What are the validity periods for different inspection characteristics within production routings?</p></li> <li><p>What are the control indicators and tolerance specifications associated with inspection characteristics?</p></li> <li><p>How are defect codes and catalog entries managed within production routing inspection characteristics?</p></li> <li><p>What sampling procedures and sample data are associated with inspection characteristics?</p></li> <li><p>What administrative data, such as creation and last change information, is available for inspection characteristics?</p></li> <li><p>How are dynamic modification rules and quality control criteria applied to inspection characteristics in production routings?</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 Public Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Public Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Public Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Custom Communication Scenarios — Create custom communication scenarios to configure custom communication arrangement
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Public Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
P_ProdnRtgInspCharcsAssgmtDEX	P_ProdnRtgInspCharcsAssgmtDEX	from

Associations (1)

Cardinality	Target	Alias	Condition
[1..*]	I_ProductionRoutingDEX	_ProductionRouting	`$projection.BillOfOperationsType = _ProductionRouting.BillOfOperationsType and $projection.ProductionRoutingGroup = _ProductionRouting.ProductionRoutingGroup`

Annotations (14)

Name	Value	Level
AccessControl.authorizationCheck	#MANDATORY	view
VDM.viewType	#BASIC	view
ObjectModel.representativeKey	BOOCharacteristicVersion	view
ObjectModel.usageType.serviceQuality	#A	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.dataClass	#MASTER	view
Analytics.dataCategory	#DIMENSION	view
Analytics.dataExtraction.enabled	true	view
Analytics.internalName	#LOCAL	view
ObjectModel.sapObjectNodeType.name	ProductionRtgInspCharcsAssgmt	view
Metadata.allowExtensions	true	view
Metadata.ignorePropagatedAnnotations	true	view
ObjectModel.modelingPattern	#ANALYTICAL_DIMENSION	view
EndUserText.label	Prodn Rtg Insp Charcs Assignment	view

Fields (106)

Key	Field	Source Field	Description
KEY	BillOfOperationsType	BillOfOperationsType	Task List Type
KEY	ProductionRoutingGroup	ProductionRoutingGroup	Key for Task List Group
KEY	BOOCharacteristicType	BOOCharacteristicType	Characteristic Type
KEY	ProductionRoutingOpIntID	ProductionRoutingOpIntID	Number of the Task List Node
KEY	BOOCharacteristic	BOOCharacteristic	Inspection Characteristic Number
KEY	BOOCharacteristicVersion	BOOCharacteristicVersion	Internal counter
	ValidityStartDate	ValidityStartDate	Validity Start Date
	ValidityEndDate	ValidityEndDate	Valid-to date
	ChangeNumber	ChangeNumber	Change Number
	IsDeleted	IsDeleted	Deletion Indicator
	InspectionMethodPlant	InspectionMethodPlant	Plant for Inspection Method
	InspectionMethod	InspectionMethod	Inspection Method
	InspectionMethodVersion	InspectionMethodVersion	Version Number of Inspection Method
	InspSpecImportanceCode	InspSpecImportanceCode	Weighting of Characteristic
	InspectorQualification	InspectorQualification	Inspector Qualification
	BOOOperationPRTInternalID	BOOOperationPRTInternalID	Assigned Test Equipment
	InspectionSpecificationPlant	InspectionSpecificationPlant	Plant for Master Inspection Characteristic
	InspectionSpecification	InspectionSpecification	Master Inspection Characteristic
	InspectionSpecificationVersion	InspectionSpecificationVersion	Version Number of Master Inspection Characteristic
	BOOCharcHasInspSpecReference	BOOCharcHasInspSpecReference	Reference to Master Insp. Characteristic in Task List
	InspSpecControlIndicators	InspSpecControlIndicators	Cntrl Indicator String for Insp. Char./Master Insp. Char.
	InspToleranceSpecification	InspToleranceSpecification	Tolerance Key
	InspSpecDecimalPlaces	InspSpecDecimalPlaces	Number of Places to the Right of a Decimal Point (Accuracy)
	InspectionSpecificationUnit	InspectionSpecificationUnit	Unit of Measurement in Which Quantitative Data Is Stored
	InspSpecTargetValue	InspSpecTargetValue	Target Value for a Quantitative Characteristic
	InspSpecHasTargetValue	InspSpecHasTargetValue	Value Not Initial If Set
	InspSpecUpperLimit	InspSpecUpperLimit	Upper Specification Limit
	InspSpecLowerLimit	InspSpecLowerLimit	Lower Specification Limit
	InspSpecHasUpperLimit	InspSpecHasUpperLimit	Value Not Initial If Set
	InspSpecHasLowerLimit	InspSpecHasLowerLimit	Value Not Initial If Set
	InspSpecUpperPlausibilityLimit	InspSpecUpperPlausibilityLimit	Upper Plausibility Limit
	InspSpecHasUprPlausibilityLmt	InspSpecHasUprPlausibilityLmt	Value Not Initial If Set
	InspSpecLowerPlausibilityLimit	InspSpecLowerPlausibilityLimit	Lower Plausibility Limit
	InspSpecHasLowrPlausibilityLmt	InspSpecHasLowrPlausibilityLmt	Value Not Initial If Set
	InspSpecFirstUpperSpecLimit	InspSpecFirstUpperSpecLimit	First Upper Specification Limit
	InspSpecHasFirstUpperSpecLimit	InspSpecHasFirstUpperSpecLimit	Value Not Initial If Set
	InspSpecFirstLowerSpecLimit	InspSpecFirstLowerSpecLimit	First Lower Specification Limit
	InspSpecHasFirstLowerSpecLimit	InspSpecHasFirstLowerSpecLimit	Value Not Initial If Set
	InspSpecSecondUpperSpecLimit	InspSpecSecondUpperSpecLimit	Second Upper Specification Limit
	InspSpecHasSecondUprSpecLimit	InspSpecHasSecondUprSpecLimit	Value Not Initial If Set
	InspSpecSecondLowerSpecLimit	InspSpecSecondLowerSpecLimit	Second Lower Specification Limit
	InspSpecHasSecondLowrSpecLimit	InspSpecHasSecondLowrSpecLimit	Value Not Initial If Set
	InspSpecToleranceChgValidFrom	InspSpecToleranceChgValidFrom	Date from Which the Tolerance Change Is Valid
	InspSpecToleranceChgValidTo	InspSpecToleranceChgValidTo	Date Until Which the Tolerance Change Is Valid
	InspSpecUpperSpecLimitChange	InspSpecUpperSpecLimitChange	Change to Upper Specification Limit
	InspSpecHasUprSpecLimitChange	InspSpecHasUprSpecLimitChange	Value Not Initial If Set
	InspSpecLowerSpecLimitChange	InspSpecLowerSpecLimitChange	Change to Lower Specification Limit
	InspSpecHasLowrSpecLimitChange	InspSpecHasLowrSpecLimitChange	Value Not Initial If Set
	InspSpecNumberOfClasses	InspSpecNumberOfClasses	Number of Value Classes for Inspection Results
	InspSpecClassWidthQty	InspSpecClassWidthQty	Class Width
	InspSpecHasClassWidth	InspSpecHasClassWidth	Value Not Initial If Set
	InspSpecClassMidpointQty	InspSpecClassMidpointQty	Class Midpoint
	InspSpecHasClassMidpoint	InspSpecHasClassMidpoint	Value Not Initial If Set
	InspSpecHasFormula	InspSpecHasFormula	Check and Calculate Formula in QM
	InspSpecFormula1	InspSpecFormula1	Formula Field
	InspSpecFormula2	InspSpecFormula2	Formula Field
	InspSpecDefectCodeGrpRejection	InspSpecDefectCodeGrpRejection	Defect Code Group for General Rejection
	InspSpecDefectCodeRejection	InspSpecDefectCodeRejection	Defect Code for Rejection: General
	InspSpecDefectCodeGrpRjcnUpper	InspSpecDefectCodeGrpRjcnUpper	Defect Code Group for Rejection at Upper Tolerance
	InspSpecDefectCodeRjcnUpper	InspSpecDefectCodeRjcnUpper	Defect Code for Rejection at Upper Specification Limit
	InspSpecDefectCodeGrpRjcnLower	InspSpecDefectCodeGrpRjcnLower	Defect Code Group for Rejection at Lower Tolerance
	InspSpecDefectCodeRjcnLower	InspSpecDefectCodeRjcnLower	Defect Code for Rejection at Lower Specification Limit
	SelectedCodeSet	SelectedCodeSet	Assigned Code Group or Selected Set
	SelectedCodeSetPlant	SelectedCodeSetPlant	Plant of the Assigned Selected Set
	InspSpecAdditionalCatalog2	InspSpecAdditionalCatalog2	Catalog Type of Assigned Code Group or Selected Set
	CatalogEntryIsSelectedSet2	CatalogEntryIsSelectedSet2	Catalog Entry Is a Selected Set
	InspSpecAddlCodeGrpSeldSet2	InspSpecAddlCodeGrpSeldSet2	Assigned Code Group or Selected Set
	InspSpecAddlSeldCodeSetPlant2	InspSpecAddlSeldCodeSetPlant2	Plant of the Assigned Selected Set
	InspSpecAdditionalCatalog3	InspSpecAdditionalCatalog3	Catalog Type of Assigned Code Group or Selected Set
	CatalogEntryIsSelectedSet3	CatalogEntryIsSelectedSet3	Catalog Entry Is a Selected Set
	InspSpecAddlCodeGrpSeldSet3	InspSpecAddlCodeGrpSeldSet3	Assigned Code Group or Selected Set
	InspSpecAddlSeldCodeSetPlant3	InspSpecAddlSeldCodeSetPlant3	Plant of the Assigned Selected Set
	InspSpecAdditionalCatalog4	InspSpecAdditionalCatalog4	Catalog Type of Assigned Code Group or Selected Set
	CatalogEntryIsSelectedSet4	CatalogEntryIsSelectedSet4	Catalog Entry Is a Selected Set
	InspSpecAddlCodeGrpSeldSet4	InspSpecAddlCodeGrpSeldSet4	Assigned Code Group or Selected Set
	InspSpecAddlSeldCodeSetPlant4	InspSpecAddlSeldCodeSetPlant4	Plant of the Assigned Selected Set
	InspSpecAdditionalCatalog5	InspSpecAdditionalCatalog5	Catalog Type of Assigned Code Group or Selected Set
	CatalogEntryIsSelectedSet5	CatalogEntryIsSelectedSet5	Catalog Entry Is a Selected Set
	InspSpecAddlCodeGrpSeldSet5	InspSpecAddlCodeGrpSeldSet5	Assigned Code Group or Selected Set
	InspSpecAddlSeldCodeSetPlant5	InspSpecAddlSeldCodeSetPlant5	Plant of the Assigned Selected Set
	SamplingProcedure	SamplingProcedure	Sampling Procedure in Inspection Characteristic
	InspCharacteristicSampleUnit	InspCharacteristicSampleUnit	Sample Unit of Measure
	BOOCharcSampleQuantity	BOOCharcSampleQuantity	Sample Quantity Factor for Sample(Mult. Sample Unit of Msr.)
	InspSpecInformationField1	InspSpecInformationField1	Text Line for Additional Information
	InspSpecInformationField2	InspSpecInformationField2	Text Line for Additional Information
	InspSpecInformationField3	InspSpecInformationField3	Text Line for Additional Information
	InspectionSpecificationText	InspectionSpecificationText	Short Text for Inspection Characteristic
	CreatedByUser	CreatedByUser	User Who Created Record
	CreationDate	CreationDate	System Date on Which Data Record Was Created
	LastChangedByUser	LastChangedByUser	Name of User Who Last Changed Data Record
	LastChangeDate	LastChangeDate	System Date on Which Data Record Was Changed
	InspLotDynamicCriteria	InspLotDynamicCriteria	String for Dynamic Modification Criteria (Database Relevant)
	InspLotDynamicRule	InspLotDynamicRule	Dynamic Modification Rule
	InspCharcDynModifRef	InspCharcDynModifRef	Characteristic (in Plan) whose Q-Level Will Be Copied
	QltyCtrlChartAggrgnCriterion	QltyCtrlChartAggrgnCriterion	SPC Criterion
	InspSpecInputProcedure	InspSpecInputProcedure	Parameters for Input Processing in QM Results Recording
	BOOCharcGroup	BOOCharcGroup	Characteristic Group
	BOOCharcSourceCharc	BOOCharcSourceCharc	Source Characteristic of Characteristic Group Division
	BOOCharcGroupDivision	BOOCharcGroupDivision	Internal Division ID
	BillOfOperationsVersion	BillOfOperationsVersion	Routing Version
	_BillOfOperationsGroup	_BillOfOperationsGroup
	_BillOfOperationsType	_BillOfOperationsType
	_BOOCharacteristic	_BOOCharacteristic
	_BOOOperationInternalID	_BOOOperationInternalID
	_ProdnRtgCharacteristicType	_ProdnRtgCharacteristicType
	_ProductionRouting	_ProductionRouting

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_ProdnRtgInspCharcAssgmtDEX.
-- 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_ProdnRtgInspCharcAssgmtDEX AS
SELECT
  BillOfOperationsType,
  ProductionRoutingGroup,
  BOOCharacteristicType,
  ProductionRoutingOpIntID,
  BOOCharacteristic,
  BOOCharacteristicVersion,
  ValidityStartDate,
  ValidityEndDate,
  ChangeNumber,
  IsDeleted,
  InspectionMethodPlant,
  InspectionMethod,
  InspectionMethodVersion,
  InspSpecImportanceCode,
  InspectorQualification,
  BOOOperationPRTInternalID,
  InspectionSpecificationPlant,
  InspectionSpecification,
  InspectionSpecificationVersion,
  BOOCharcHasInspSpecReference,
  InspSpecControlIndicators,
  InspToleranceSpecification,
  InspSpecDecimalPlaces,
  InspectionSpecificationUnit,
  InspSpecTargetValue,
  InspSpecHasTargetValue,
  InspSpecUpperLimit,
  InspSpecLowerLimit,
  InspSpecHasUpperLimit,
  InspSpecHasLowerLimit,
  InspSpecUpperPlausibilityLimit,
  InspSpecHasUprPlausibilityLmt,
  InspSpecLowerPlausibilityLimit,
  InspSpecHasLowrPlausibilityLmt,
  InspSpecFirstUpperSpecLimit,
  InspSpecHasFirstUpperSpecLimit,
  InspSpecFirstLowerSpecLimit,
  InspSpecHasFirstLowerSpecLimit,
  InspSpecSecondUpperSpecLimit,
  InspSpecHasSecondUprSpecLimit,
  InspSpecSecondLowerSpecLimit,
  InspSpecHasSecondLowrSpecLimit,
  InspSpecToleranceChgValidFrom,
  InspSpecToleranceChgValidTo,
  InspSpecUpperSpecLimitChange,
  InspSpecHasUprSpecLimitChange,
  InspSpecLowerSpecLimitChange,
  InspSpecHasLowrSpecLimitChange,
  InspSpecNumberOfClasses,
  InspSpecClassWidthQty,
  InspSpecHasClassWidth,
  InspSpecClassMidpointQty,
  InspSpecHasClassMidpoint,
  InspSpecHasFormula,
  InspSpecFormula1,
  InspSpecFormula2,
  InspSpecDefectCodeGrpRejection,
  InspSpecDefectCodeRejection,
  InspSpecDefectCodeGrpRjcnUpper,
  InspSpecDefectCodeRjcnUpper,
  InspSpecDefectCodeGrpRjcnLower,
  InspSpecDefectCodeRjcnLower,
  SelectedCodeSet,
  SelectedCodeSetPlant,
  InspSpecAdditionalCatalog2,
  CatalogEntryIsSelectedSet2,
  InspSpecAddlCodeGrpSeldSet2,
  InspSpecAddlSeldCodeSetPlant2,
  InspSpecAdditionalCatalog3,
  CatalogEntryIsSelectedSet3,
  InspSpecAddlCodeGrpSeldSet3,
  InspSpecAddlSeldCodeSetPlant3,
  InspSpecAdditionalCatalog4,
  CatalogEntryIsSelectedSet4,
  InspSpecAddlCodeGrpSeldSet4,
  InspSpecAddlSeldCodeSetPlant4,
  InspSpecAdditionalCatalog5,
  CatalogEntryIsSelectedSet5,
  InspSpecAddlCodeGrpSeldSet5,
  InspSpecAddlSeldCodeSetPlant5,
  SamplingProcedure,
  InspCharacteristicSampleUnit,
  BOOCharcSampleQuantity,
  InspSpecInformationField1,
  InspSpecInformationField2,
  InspSpecInformationField3,
  InspectionSpecificationText,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  InspLotDynamicCriteria,
  InspLotDynamicRule,
  InspCharcDynModifRef,
  QltyCtrlChartAggrgnCriterion,
  InspSpecInputProcedure,
  BOOCharcGroup,
  BOOCharcSourceCharc,
  BOOCharcGroupDivision,
  BillOfOperationsVersion
FROM P_ProdnRtgInspCharcsAssgmtDEX
LEFT OUTER JOIN I_ProductionRoutingDEX AS _ProductionRouting ON BillOfOperationsType = _ProductionRouting.BillOfOperationsType AND ProductionRoutingGroup = _ProductionRouting.ProductionRoutingGroup  -- association [1..*]
;

Depth:

I_ProdnRtgInspCharcAssgmtDEX view_entity

P_ProdnRtgInspCharcsAssgmtDEX view_entity