What is A_InspectionSpecification in SAP S/4HANA?

A_InspectionSpecification is a composite CDS view in SAP S/4HANA. Master Inspection Characteristics It contains 80 fields.

Which tables does A_InspectionSpecification read from?

A_InspectionSpecification reads data from: I_InspSpecificationVersion.

What VDM layer is A_InspectionSpecification?

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

A_InspectionSpecification

DDL: A_INSPECTIONSPECIFICATION SQL: AINSPSPEC Type: view COMPOSITE

80 Fields 1 Data Sources 2 Associations

Master Inspection Characteristics

A_InspectionSpecification is a Composite CDS View that provides data about "Master Inspection Characteristics" in SAP S/4HANA. It reads from 1 data source (I_InspSpecificationVersion) and exposes 80 fields with key fields InspectionSpecification, InspectionSpecificationVersion, InspectionSpecificationPlant. It has 2 associations to related views.

Data Sources (1)

Source	Alias	Join Type
I_InspSpecificationVersion	I_InspSpecificationVersion	from

Associations (2)

Cardinality	Target	Alias	Condition
[0..*]	A_InspectionSpecificationText	_Text	`$projection.InspectionSpecificationPlant = _Text.InspectionSpecificationPlant and $projection.InspectionSpecification = _Text.InspectionSpecification and $projection.InspectionSpecificationVersion = _Text.InspectionSpecificationVersion`
[1..1]	E_InspSpecificationVersion	_Extension	`$projection.InspectionSpecificationPlant = _Extension.InspectionSpecificationPlant and $projection.InspectionSpecification = _Extension.InspectionSpecification and $projection.InspectionSpecificationVersion = _Extension.InspectionSpecificationVersion`

Annotations (16)

Name	Value	Level
AbapCatalog.sqlViewName	AINSPSPEC	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
VDM.viewType	#COMPOSITE	view
VDM.lifecycle.contract.type	#PUBLIC_REMOTE_API	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
EndUserText.label	Master Inspection Characteristics	view
AccessControl.authorizationCheck	#CHECK	view
ObjectModel.usageType.dataClass	#MASTER	view
ObjectModel.usageType.sizeCategory	#M	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.compositionRoot	true	view
ObjectModel.createEnabled	false	view
ObjectModel.updateEnabled	false	view
ObjectModel.deleteEnabled	false	view
Metadata.ignorePropagatedAnnotations	true	view

Fields (80)

Key	Field	Source Table	Source Field	Description
KEY	InspectionSpecification	I_InspSpecificationVersion	InspectionSpecification	Master IC
KEY	InspectionSpecificationVersion	I_InspSpecificationVersion	InspectionSpecificationVersion	XML Vers.
KEY	InspectionSpecificationPlant	I_InspSpecificationVersion	InspectionSpecificationPlant	Version
	Plant	I_InspSpecificationVersion	Plant	Valuation Area
	ValidityStartDate	I_InspSpecificationVersion	ValidityStartDate	Validity Start Date
	InspectionSpecificationSrchTxt	I_InspSpecificationVersion	InspectionSpecificationSrchTxt	Search Field
	InspSpecGlobalName	I_InspSpecificationVersion	InspSpecGlobalName
	InspectionSpecificationStatus	I_InspSpecificationVersion	InspectionSpecificationStatus	Status
	InspSpecTransferType	I_InspSpecificationVersion	InspSpecTransferType
	InspSpecCreatedByUser	I_InspSpecificationVersion	InspSpecCreatedByUser	Created By
	InspSpecCreationDate	I_InspSpecificationVersion	InspSpecCreationDate	Start Date
	InspSpecChangedByUser	I_InspSpecificationVersion	InspSpecChangedByUser	Changed By
	InspSpecChangeDate	I_InspSpecificationVersion	InspSpecChangeDate	Last change
	InspSpecIsQuantitative	I_InspSpecificationVersion	InspSpecIsQuantitative	Quant.charac.
	InspSpecCharacteristicType	I_InspSpecificationVersion	InspSpecCharacteristicType
	InspSpecIsMeasuredValueRqd	I_InspSpecificationVersion	InspSpecIsMeasuredValueRqd
	InspSpecIsSelectedSetRequired	I_InspSpecificationVersion	InspSpecIsSelectedSetRequired
	InspSpecIsUpperLimitRequired	I_InspSpecificationVersion	InspSpecIsUpperLimitRequired
	InspSpecIsLowerLimitRequired	I_InspSpecificationVersion	InspSpecIsLowerLimitRequired
	InspSpecIsTargetValueInLimit	I_InspSpecificationVersion	InspSpecIsTargetValueInLimit
	InspectionScope	I_InspSpecificationVersion	InspectionScope
	InspSpecIsLongTermInspection	I_InspSpecificationVersion	InspSpecIsLongTermInspection
	InspSpecRecordingType	I_InspSpecificationVersion	InspSpecRecordingType
	InspResultIsDocumentationRqd	I_InspSpecificationVersion	InspResultIsDocumentationRqd
	InspSpecCharcCategory	I_InspSpecificationVersion	InspSpecCharcCategory
	InspSpecIsDefectsRecgAutomatic	I_InspSpecificationVersion	InspSpecIsDefectsRecgAutomatic
	InspSpecIsSampleQtyAdditive	I_InspSpecificationVersion	InspSpecIsSampleQtyAdditive
	InspSpecIsDestructive	I_InspSpecificationVersion	InspSpecIsDestructive
	InspSpecResultCalculation	I_InspSpecificationVersion	InspSpecResultCalculation
	InspSpecIsSamplingProcedRqd	I_InspSpecificationVersion	InspSpecIsSamplingProcedRqd
	InspSpecIsScrapRelevant	I_InspSpecificationVersion	InspSpecIsScrapRelevant
	InspSpecIsTestEquipmentRqd	I_InspSpecificationVersion	InspSpecIsTestEquipmentRqd
	InspSpecIsChgDocRequired	I_InspSpecificationVersion	InspSpecIsChgDocRequired
	InspSpecIsControlChartUsed	I_InspSpecificationVersion	InspSpecIsControlChartUsed
	InspSpecPrintControl	I_InspSpecificationVersion	InspSpecPrintControl
	InspSpecImportanceCode	I_InspSpecificationVersion	InspSpecImportanceCode
	InspectorQualification	I_InspSpecificationVersion	InspectorQualification	Inspctr qualif.
	InspSpecInformationField1	I_InspSpecificationVersion	InspSpecInformationField1	Info Field 1
	InspSpecInformationField2	I_InspSpecificationVersion	InspSpecInformationField2	Info Field 2
	InspSpecInformationField3	I_InspSpecificationVersion	InspSpecInformationField3	Info Field 3
	QltyMstrDataAuthorizationGroup	I_InspSpecificationVersion	QltyMstrDataAuthorizationGroup	QM Matl Auth.
	InspToleranceSpecification	I_InspSpecificationVersion	InspToleranceSpecification	Tolerance Key
	InspSpecDecimalPlaces	I_InspSpecificationVersion	InspSpecDecimalPlaces	Decimal Places
	InspectionSpecificationUnit	I_InspSpecificationVersion	InspectionSpecificationUnit	Unit of Meas.
	InspSpecificationUnitTechName
	InspSpecificationUnitISOCode
	InspSpecificationUnitSAPCode
	InspSpecTargetValue	I_InspSpecificationVersion	InspSpecTargetValue	Target Value
	InspSpecHasTargetValue	I_InspSpecificationVersion	InspSpecHasTargetValue	Not Initial
	InspSpecLowerLimit	I_InspSpecificationVersion	InspSpecLowerLimit	Lower Limit
	InspSpecHasLowerLimit	I_InspSpecificationVersion	InspSpecHasLowerLimit	Not Initial
	InspSpecLowerPlausibilityLimit	I_InspSpecificationVersion	InspSpecLowerPlausibilityLimit	LoPlaus. Limit
	InspSpecHasLowrPlausibilityLmt	I_InspSpecificationVersion	InspSpecHasLowrPlausibilityLmt	Not Initial
	InspSpecFirstLowerSpecLimit	I_InspSpecificationVersion	InspSpecFirstLowerSpecLimit	1st Lower Limit
	InspSpecHasFirstLowerSpecLimit	I_InspSpecificationVersion	InspSpecHasFirstLowerSpecLimit	Not Initial
	InspSpecSecondLowerSpecLimit	I_InspSpecificationVersion	InspSpecSecondLowerSpecLimit	2nd Lower Limit
	InspSpecHasSecondLowrSpecLimit	I_InspSpecificationVersion	InspSpecHasSecondLowrSpecLimit	Not Initial
	InspSpecLowerSpecLimitChange	I_InspSpecificationVersion	InspSpecLowerSpecLimitChange
	InspSpecHasLowrSpecLimitChange	I_InspSpecificationVersion	InspSpecHasLowrSpecLimitChange	Not Initial
	InspSpecUpperLimit	I_InspSpecificationVersion	InspSpecUpperLimit	Upper Limit
	InspSpecHasUpperLimit	I_InspSpecificationVersion	InspSpecHasUpperLimit	Not Initial
	InspSpecUpperPlausibilityLimit	I_InspSpecificationVersion	InspSpecUpperPlausibilityLimit	UpPlaus. Limit
	InspSpecHasUprPlausibilityLmt	I_InspSpecificationVersion	InspSpecHasUprPlausibilityLmt	Not Initial
	InspSpecFirstUpperSpecLimit	I_InspSpecificationVersion	InspSpecFirstUpperSpecLimit	1st Upper Limit
	InspSpecHasFirstUpperSpecLimit	I_InspSpecificationVersion	InspSpecHasFirstUpperSpecLimit	Not Initial
	InspSpecSecondUpperSpecLimit	I_InspSpecificationVersion	InspSpecSecondUpperSpecLimit	2nd Upper Limit
	InspSpecHasSecondUprSpecLimit	I_InspSpecificationVersion	InspSpecHasSecondUprSpecLimit	Not Initial
	InspSpecUpperSpecLimitChange	I_InspSpecificationVersion	InspSpecUpperSpecLimitChange
	InspSpecHasUprSpecLimitChange	I_InspSpecificationVersion	InspSpecHasUprSpecLimitChange	Not Initial
	InspSpecToleranceChgValidFrom	I_InspSpecificationVersion	InspSpecToleranceChgValidFrom
	InspSpecToleranceChgValidTo	I_InspSpecificationVersion	InspSpecToleranceChgValidTo
	InspSpecDefectCodeGrpRejection	I_InspSpecificationVersion	InspSpecDefectCodeGrpRejection	DefCodeGrp Rej.
	InspSpecDefectCodeRejection	I_InspSpecificationVersion	InspSpecDefectCodeRejection
	InspSpecDefectCodeGrpRjcnUpper	I_InspSpecificationVersion	InspSpecDefectCodeGrpRjcnUpper	UpLim defect
	InspSpecDefectCodeRjcnUpper	I_InspSpecificationVersion	InspSpecDefectCodeRjcnUpper	DefCodeUpperSpL
	InspSpecDefectCodeGrpRjcnLower	I_InspSpecificationVersion	InspSpecDefectCodeGrpRjcnLower	LoLim defect
	InspSpecDefectCodeRjcnLower	I_InspSpecificationVersion	InspSpecDefectCodeRjcnLower	DefCodeLowSpecL
	CharacteristicInternalID
	DefectFractionEstimationProced	I_InspSpecificationVersion	DefectFractionEstimationProced
	_Text		_Text

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 A_InspectionSpecification.
-- 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: AINSPSPEC

CREATE VIEW A_InspectionSpecification AS
SELECT
  I_InspSpecificationVersion.InspectionSpecification AS InspectionSpecification,
  I_InspSpecificationVersion.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  I_InspSpecificationVersion.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  I_InspSpecificationVersion.Plant AS Plant,
  I_InspSpecificationVersion.ValidityStartDate AS ValidityStartDate,
  I_InspSpecificationVersion.InspectionSpecificationSrchTxt AS InspectionSpecificationSrchTxt,
  I_InspSpecificationVersion.InspSpecGlobalName AS InspSpecGlobalName,
  I_InspSpecificationVersion.InspectionSpecificationStatus AS InspectionSpecificationStatus,
  I_InspSpecificationVersion.InspSpecTransferType AS InspSpecTransferType,
  I_InspSpecificationVersion.InspSpecCreatedByUser AS InspSpecCreatedByUser,
  I_InspSpecificationVersion.InspSpecCreationDate AS InspSpecCreationDate,
  I_InspSpecificationVersion.InspSpecChangedByUser AS InspSpecChangedByUser,
  I_InspSpecificationVersion.InspSpecChangeDate AS InspSpecChangeDate,
  I_InspSpecificationVersion.InspSpecIsQuantitative AS InspSpecIsQuantitative,
  I_InspSpecificationVersion.InspSpecCharacteristicType AS InspSpecCharacteristicType,
  I_InspSpecificationVersion.InspSpecIsMeasuredValueRqd AS InspSpecIsMeasuredValueRqd,
  I_InspSpecificationVersion.InspSpecIsSelectedSetRequired AS InspSpecIsSelectedSetRequired,
  I_InspSpecificationVersion.InspSpecIsUpperLimitRequired AS InspSpecIsUpperLimitRequired,
  I_InspSpecificationVersion.InspSpecIsLowerLimitRequired AS InspSpecIsLowerLimitRequired,
  I_InspSpecificationVersion.InspSpecIsTargetValueInLimit AS InspSpecIsTargetValueInLimit,
  I_InspSpecificationVersion.InspectionScope AS InspectionScope,
  I_InspSpecificationVersion.InspSpecIsLongTermInspection AS InspSpecIsLongTermInspection,
  I_InspSpecificationVersion.InspSpecRecordingType AS InspSpecRecordingType,
  I_InspSpecificationVersion.InspResultIsDocumentationRqd AS InspResultIsDocumentationRqd,
  I_InspSpecificationVersion.InspSpecCharcCategory AS InspSpecCharcCategory,
  I_InspSpecificationVersion.InspSpecIsDefectsRecgAutomatic AS InspSpecIsDefectsRecgAutomatic,
  I_InspSpecificationVersion.InspSpecIsSampleQtyAdditive AS InspSpecIsSampleQtyAdditive,
  I_InspSpecificationVersion.InspSpecIsDestructive AS InspSpecIsDestructive,
  I_InspSpecificationVersion.InspSpecResultCalculation AS InspSpecResultCalculation,
  I_InspSpecificationVersion.InspSpecIsSamplingProcedRqd AS InspSpecIsSamplingProcedRqd,
  I_InspSpecificationVersion.InspSpecIsScrapRelevant AS InspSpecIsScrapRelevant,
  I_InspSpecificationVersion.InspSpecIsTestEquipmentRqd AS InspSpecIsTestEquipmentRqd,
  I_InspSpecificationVersion.InspSpecIsChgDocRequired AS InspSpecIsChgDocRequired,
  I_InspSpecificationVersion.InspSpecIsControlChartUsed AS InspSpecIsControlChartUsed,
  I_InspSpecificationVersion.InspSpecPrintControl AS InspSpecPrintControl,
  I_InspSpecificationVersion.InspSpecImportanceCode AS InspSpecImportanceCode,
  I_InspSpecificationVersion.InspectorQualification AS InspectorQualification,
  I_InspSpecificationVersion.InspSpecInformationField1 AS InspSpecInformationField1,
  I_InspSpecificationVersion.InspSpecInformationField2 AS InspSpecInformationField2,
  I_InspSpecificationVersion.InspSpecInformationField3 AS InspSpecInformationField3,
  I_InspSpecificationVersion.QltyMstrDataAuthorizationGroup AS QltyMstrDataAuthorizationGroup,
  I_InspSpecificationVersion.InspToleranceSpecification AS InspToleranceSpecification,
  I_InspSpecificationVersion.InspSpecDecimalPlaces AS InspSpecDecimalPlaces,
  I_InspSpecificationVersion.InspectionSpecificationUnit AS InspectionSpecificationUnit,
  cast( _UnitOfMeasure._Text[ 1: Language = $session.system_language ].UnitOfMeasureTechnicalName as vdm_qmasseh_tech_name preserving type ) AS InspSpecificationUnitTechName,
  cast( I_InspSpecificationVersion._UnitOfMeasure.UnitOfMeasureISOCode as vdm_qmasseh_iso_code preserving type ) AS InspSpecificationUnitISOCode,
  cast( I_InspSpecificationVersion._UnitOfMeasure.UnitOfMeasureSAPCode as vdm_qmasseh_sap_code preserving type ) AS InspSpecificationUnitSAPCode,
  I_InspSpecificationVersion.InspSpecTargetValue AS InspSpecTargetValue,
  I_InspSpecificationVersion.InspSpecHasTargetValue AS InspSpecHasTargetValue,
  I_InspSpecificationVersion.InspSpecLowerLimit AS InspSpecLowerLimit,
  I_InspSpecificationVersion.InspSpecHasLowerLimit AS InspSpecHasLowerLimit,
  I_InspSpecificationVersion.InspSpecLowerPlausibilityLimit AS InspSpecLowerPlausibilityLimit,
  I_InspSpecificationVersion.InspSpecHasLowrPlausibilityLmt AS InspSpecHasLowrPlausibilityLmt,
  I_InspSpecificationVersion.InspSpecFirstLowerSpecLimit AS InspSpecFirstLowerSpecLimit,
  I_InspSpecificationVersion.InspSpecHasFirstLowerSpecLimit AS InspSpecHasFirstLowerSpecLimit,
  I_InspSpecificationVersion.InspSpecSecondLowerSpecLimit AS InspSpecSecondLowerSpecLimit,
  I_InspSpecificationVersion.InspSpecHasSecondLowrSpecLimit AS InspSpecHasSecondLowrSpecLimit,
  I_InspSpecificationVersion.InspSpecLowerSpecLimitChange AS InspSpecLowerSpecLimitChange,
  I_InspSpecificationVersion.InspSpecHasLowrSpecLimitChange AS InspSpecHasLowrSpecLimitChange,
  I_InspSpecificationVersion.InspSpecUpperLimit AS InspSpecUpperLimit,
  I_InspSpecificationVersion.InspSpecHasUpperLimit AS InspSpecHasUpperLimit,
  I_InspSpecificationVersion.InspSpecUpperPlausibilityLimit AS InspSpecUpperPlausibilityLimit,
  I_InspSpecificationVersion.InspSpecHasUprPlausibilityLmt AS InspSpecHasUprPlausibilityLmt,
  I_InspSpecificationVersion.InspSpecFirstUpperSpecLimit AS InspSpecFirstUpperSpecLimit,
  I_InspSpecificationVersion.InspSpecHasFirstUpperSpecLimit AS InspSpecHasFirstUpperSpecLimit,
  I_InspSpecificationVersion.InspSpecSecondUpperSpecLimit AS InspSpecSecondUpperSpecLimit,
  I_InspSpecificationVersion.InspSpecHasSecondUprSpecLimit AS InspSpecHasSecondUprSpecLimit,
  I_InspSpecificationVersion.InspSpecUpperSpecLimitChange AS InspSpecUpperSpecLimitChange,
  I_InspSpecificationVersion.InspSpecHasUprSpecLimitChange AS InspSpecHasUprSpecLimitChange,
  I_InspSpecificationVersion.InspSpecToleranceChgValidFrom AS InspSpecToleranceChgValidFrom,
  I_InspSpecificationVersion.InspSpecToleranceChgValidTo AS InspSpecToleranceChgValidTo,
  I_InspSpecificationVersion.InspSpecDefectCodeGrpRejection AS InspSpecDefectCodeGrpRejection,
  I_InspSpecificationVersion.InspSpecDefectCodeRejection AS InspSpecDefectCodeRejection,
  I_InspSpecificationVersion.InspSpecDefectCodeGrpRjcnUpper AS InspSpecDefectCodeGrpRjcnUpper,
  I_InspSpecificationVersion.InspSpecDefectCodeRjcnUpper AS InspSpecDefectCodeRjcnUpper,
  I_InspSpecificationVersion.InspSpecDefectCodeGrpRjcnLower AS InspSpecDefectCodeGrpRjcnLower,
  I_InspSpecificationVersion.InspSpecDefectCodeRjcnLower AS InspSpecDefectCodeRjcnLower,
  cast( I_InspSpecificationVersion.CharcInternalID as atinn preserving type ) AS CharacteristicInternalID,
  I_InspSpecificationVersion.DefectFractionEstimationProced AS DefectFractionEstimationProced
FROM I_InspSpecificationVersion
LEFT OUTER JOIN A_InspectionSpecificationText AS _Text ON InspectionSpecificationPlant = _Text.InspectionSpecificationPlant AND InspectionSpecification = _Text.InspectionSpecification AND InspectionSpecificationVersion = _Text.InspectionSpecificationVersion  -- association [0..*]
LEFT OUTER JOIN E_InspSpecificationVersion AS _Extension ON InspectionSpecificationPlant = _Extension.InspectionSpecificationPlant AND InspectionSpecification = _Extension.InspectionSpecification AND InspectionSpecificationVersion = _Extension.InspectionSpecificationVersion  -- association [1..1]
;

Depth:

A_InspectionSpecification view

I_InspSpecificationVersion view