Which tables does A_InspectionSpecification use?

A_InspectionSpecification reads from 1 data source(s): I_InspSpecificationVersion.

A_InspectionSpecification

Q: How many fields does A_InspectionSpecification have?

A_InspectionSpecification has 80 fields. Key fields: InspectionSpecification, InspectionSpecificationVersion, InspectionSpecificationPlant.

DDL: A_INSPECTIONSPECIFICATION SQL: AINSPSPEC Type: view COMPOSITE Package: ODATA_QM_PLAN_API

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. Part of development package ODATA_QM_PLAN_API.

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
KEY	InspectionSpecification	I_InspSpecificationVersion	InspectionSpecification
KEY	InspectionSpecificationVersion	I_InspSpecificationVersion	InspectionSpecificationVersion
KEY	InspectionSpecificationPlant	I_InspSpecificationVersion	InspectionSpecificationPlant
	Plant	I_InspSpecificationVersion	Plant
	ValidityStartDate	I_InspSpecificationVersion	ValidityStartDate
	InspectionSpecificationSrchTxt	I_InspSpecificationVersion	InspectionSpecificationSrchTxt
	InspSpecGlobalName	I_InspSpecificationVersion	InspSpecGlobalName
	InspectionSpecificationStatus	I_InspSpecificationVersion	InspectionSpecificationStatus
	InspSpecTransferType	I_InspSpecificationVersion	InspSpecTransferType
	InspSpecCreatedByUser	I_InspSpecificationVersion	InspSpecCreatedByUser
	InspSpecCreationDate	I_InspSpecificationVersion	InspSpecCreationDate
	InspSpecChangedByUser	I_InspSpecificationVersion	InspSpecChangedByUser
	InspSpecChangeDate	I_InspSpecificationVersion	InspSpecChangeDate
	InspSpecIsQuantitative	I_InspSpecificationVersion	InspSpecIsQuantitative
	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
	InspSpecInformationField1	I_InspSpecificationVersion	InspSpecInformationField1
	InspSpecInformationField2	I_InspSpecificationVersion	InspSpecInformationField2
	InspSpecInformationField3	I_InspSpecificationVersion	InspSpecInformationField3
	QltyMstrDataAuthorizationGroup	I_InspSpecificationVersion	QltyMstrDataAuthorizationGroup
	InspToleranceSpecification	I_InspSpecificationVersion	InspToleranceSpecification
	InspSpecDecimalPlaces	I_InspSpecificationVersion	InspSpecDecimalPlaces
	InspectionSpecificationUnit	I_InspSpecificationVersion	InspectionSpecificationUnit
	InspSpecificationUnitTechName
	InspSpecificationUnitISOCode
	InspSpecificationUnitSAPCode
	InspSpecTargetValue	I_InspSpecificationVersion	InspSpecTargetValue
	InspSpecHasTargetValue	I_InspSpecificationVersion	InspSpecHasTargetValue
	InspSpecLowerLimit	I_InspSpecificationVersion	InspSpecLowerLimit
	InspSpecHasLowerLimit	I_InspSpecificationVersion	InspSpecHasLowerLimit
	InspSpecLowerPlausibilityLimit	I_InspSpecificationVersion	InspSpecLowerPlausibilityLimit
	InspSpecHasLowrPlausibilityLmt	I_InspSpecificationVersion	InspSpecHasLowrPlausibilityLmt
	InspSpecFirstLowerSpecLimit	I_InspSpecificationVersion	InspSpecFirstLowerSpecLimit
	InspSpecHasFirstLowerSpecLimit	I_InspSpecificationVersion	InspSpecHasFirstLowerSpecLimit
	InspSpecSecondLowerSpecLimit	I_InspSpecificationVersion	InspSpecSecondLowerSpecLimit
	InspSpecHasSecondLowrSpecLimit	I_InspSpecificationVersion	InspSpecHasSecondLowrSpecLimit
	InspSpecLowerSpecLimitChange	I_InspSpecificationVersion	InspSpecLowerSpecLimitChange
	InspSpecHasLowrSpecLimitChange	I_InspSpecificationVersion	InspSpecHasLowrSpecLimitChange
	InspSpecUpperLimit	I_InspSpecificationVersion	InspSpecUpperLimit
	InspSpecHasUpperLimit	I_InspSpecificationVersion	InspSpecHasUpperLimit
	InspSpecUpperPlausibilityLimit	I_InspSpecificationVersion	InspSpecUpperPlausibilityLimit
	InspSpecHasUprPlausibilityLmt	I_InspSpecificationVersion	InspSpecHasUprPlausibilityLmt
	InspSpecFirstUpperSpecLimit	I_InspSpecificationVersion	InspSpecFirstUpperSpecLimit
	InspSpecHasFirstUpperSpecLimit	I_InspSpecificationVersion	InspSpecHasFirstUpperSpecLimit
	InspSpecSecondUpperSpecLimit	I_InspSpecificationVersion	InspSpecSecondUpperSpecLimit
	InspSpecHasSecondUprSpecLimit	I_InspSpecificationVersion	InspSpecHasSecondUprSpecLimit
	InspSpecUpperSpecLimitChange	I_InspSpecificationVersion	InspSpecUpperSpecLimitChange
	InspSpecHasUprSpecLimitChange	I_InspSpecificationVersion	InspSpecHasUprSpecLimitChange
	InspSpecToleranceChgValidFrom	I_InspSpecificationVersion	InspSpecToleranceChgValidFrom
	InspSpecToleranceChgValidTo	I_InspSpecificationVersion	InspSpecToleranceChgValidTo
	InspSpecDefectCodeGrpRejection	I_InspSpecificationVersion	InspSpecDefectCodeGrpRejection
	InspSpecDefectCodeRejection	I_InspSpecificationVersion	InspSpecDefectCodeRejection
	InspSpecDefectCodeGrpRjcnUpper	I_InspSpecificationVersion	InspSpecDefectCodeGrpRjcnUpper
	InspSpecDefectCodeRjcnUpper	I_InspSpecificationVersion	InspSpecDefectCodeRjcnUpper
	InspSpecDefectCodeGrpRjcnLower	I_InspSpecificationVersion	InspSpecDefectCodeGrpRjcnLower
	InspSpecDefectCodeRjcnLower	I_InspSpecificationVersion	InspSpecDefectCodeRjcnLower
	CharacteristicInternalID
	DefectFractionEstimationProced	I_InspSpecificationVersion	DefectFractionEstimationProced
	_Text		_Text

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

define view A_InspectionSpecification
  as select from I_InspSpecificationVersion
  
  association [0..*] to A_InspectionSpecificationText as _Text on  $projection.InspectionSpecificationPlant   = _Text.InspectionSpecificationPlant 
                                                               and $projection.InspectionSpecification        = _Text.InspectionSpecification 
                                                               and $projection.InspectionSpecificationVersion = _Text.InspectionSpecificationVersion
  
    //Extension

  association [1..1] to E_InspSpecificationVersion     as _Extension                    on  $projection.InspectionSpecificationPlant   = _Extension.InspectionSpecificationPlant
                                                                                        and $projection.InspectionSpecification        = _Extension.InspectionSpecification
                                                                                        and $projection.InspectionSpecificationVersion = _Extension.InspectionSpecificationVersion
{
  key I_InspSpecificationVersion.InspectionSpecification,
  key I_InspSpecificationVersion.InspectionSpecificationVersion,
  key I_InspSpecificationVersion.InspectionSpecificationPlant,
      I_InspSpecificationVersion.Plant,
//      _Text[1:Language = $session.system_language].InspectionSpecificationText,

      I_InspSpecificationVersion.ValidityStartDate,
      I_InspSpecificationVersion.InspectionSpecificationSrchTxt,
      I_InspSpecificationVersion.InspSpecGlobalName,
      I_InspSpecificationVersion.InspectionSpecificationStatus,
      I_InspSpecificationVersion.InspSpecTransferType,
      I_InspSpecificationVersion.InspSpecCreatedByUser,
      I_InspSpecificationVersion.InspSpecCreationDate,
      I_InspSpecificationVersion.InspSpecChangedByUser,
      I_InspSpecificationVersion.InspSpecChangeDate,
      I_InspSpecificationVersion.InspSpecIsQuantitative,
      I_InspSpecificationVersion.InspSpecCharacteristicType,
      I_InspSpecificationVersion.InspSpecIsMeasuredValueRqd, // Measured Value Must Be Recorded

      I_InspSpecificationVersion.InspSpecIsSelectedSetRequired, //For Qualitative Char.: Selected Set is required

      I_InspSpecificationVersion.InspSpecIsUpperLimitRequired, // Upper Specification Limit Required

      I_InspSpecificationVersion.InspSpecIsLowerLimitRequired, // Lower Specification Limit Required

      I_InspSpecificationVersion.InspSpecIsTargetValueInLimit, // Check if target value is between lower and upper limit

      
      I_InspSpecificationVersion.InspectionScope, // Inspection Scope

      I_InspSpecificationVersion.InspSpecIsLongTermInspection, // Long-Term Inspection

      I_InspSpecificationVersion.InspSpecRecordingType, // RecordingType: Values from domain QESTKUZ

      I_InspSpecificationVersion.InspResultIsDocumentationRqd, // Documentation Required for Inspection Result

      I_InspSpecificationVersion.InspSpecCharcCategory, // Characteristic Category: Values from domain QRZWANG

      I_InspSpecificationVersion.InspSpecIsDefectsRecgAutomatic, // Defects Recording Automatically Called Up

      I_InspSpecificationVersion.InspSpecIsSampleQtyAdditive, // Sample Quantity Is Additive

      I_InspSpecificationVersion.InspSpecIsDestructive, // Destructive Inspection

      I_InspSpecificationVersion.InspSpecResultCalculation, // Result Calculation for Characteristics

      I_InspSpecificationVersion.InspSpecIsSamplingProcedRqd, // Sampling Procedure Is Required

      I_InspSpecificationVersion.InspSpecIsScrapRelevant, // Characteristic Relevant for Quality Score and Scrap Share

      I_InspSpecificationVersion.InspSpecIsTestEquipmentRqd, // Assignment of Test Equipment Required

      I_InspSpecificationVersion.InspSpecIsChgDocRequired, // Create Change Documents During Results Recording

      I_InspSpecificationVersion.InspSpecIsControlChartUsed, // SPC Characteristic; Control Chart is Used

      I_InspSpecificationVersion.InspSpecPrintControl, // Print Control

      I_InspSpecificationVersion.InspSpecImportanceCode,
      I_InspSpecificationVersion.InspectorQualification,
      I_InspSpecificationVersion.InspSpecInformationField1,
      I_InspSpecificationVersion.InspSpecInformationField2,
      I_InspSpecificationVersion.InspSpecInformationField3,
      I_InspSpecificationVersion.QltyMstrDataAuthorizationGroup,
      I_InspSpecificationVersion.InspToleranceSpecification,
      I_InspSpecificationVersion.InspSpecDecimalPlaces,
      @Semantics.unitOfMeasure: true
      I_InspSpecificationVersion.InspectionSpecificationUnit,
      @Semantics.text: true
      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,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecTargetValue,
      I_InspSpecificationVersion.InspSpecHasTargetValue,

      /* Lower limit related fields */
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecLowerLimit,
      I_InspSpecificationVersion.InspSpecHasLowerLimit,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecLowerPlausibilityLimit,
      I_InspSpecificationVersion.InspSpecHasLowrPlausibilityLmt,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecFirstLowerSpecLimit,
      I_InspSpecificationVersion.InspSpecHasFirstLowerSpecLimit,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecSecondLowerSpecLimit,
      I_InspSpecificationVersion.InspSpecHasSecondLowrSpecLimit,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecLowerSpecLimitChange,
      I_InspSpecificationVersion.InspSpecHasLowrSpecLimitChange,

      /* Upper limit related fields */
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecUpperLimit,
      I_InspSpecificationVersion.InspSpecHasUpperLimit,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecUpperPlausibilityLimit,
      I_InspSpecificationVersion.InspSpecHasUprPlausibilityLmt,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecFirstUpperSpecLimit,
      I_InspSpecificationVersion.InspSpecHasFirstUpperSpecLimit,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecSecondUpperSpecLimit,
      I_InspSpecificationVersion.InspSpecHasSecondUprSpecLimit,
      @Semantics.quantity.unitOfMeasure: 'InspectionSpecificationUnit'
      I_InspSpecificationVersion.InspSpecUpperSpecLimitChange,
      I_InspSpecificationVersion.InspSpecHasUprSpecLimitChange,

      /* Tolerance Change */
      I_InspSpecificationVersion.InspSpecToleranceChgValidFrom,
      I_InspSpecificationVersion.InspSpecToleranceChgValidTo,

      /* Defect Codes for Rejection */
      I_InspSpecificationVersion.InspSpecDefectCodeGrpRejection,
      I_InspSpecificationVersion.InspSpecDefectCodeRejection,
      
      I_InspSpecificationVersion.InspSpecDefectCodeGrpRjcnUpper,
      I_InspSpecificationVersion.InspSpecDefectCodeRjcnUpper,
      
      I_InspSpecificationVersion.InspSpecDefectCodeGrpRjcnLower,
      I_InspSpecificationVersion.InspSpecDefectCodeRjcnLower,
      
//      I_InspSpecificationVersion.CharcInternalID,

      cast( I_InspSpecificationVersion.CharcInternalID as atinn preserving type ) as CharacteristicInternalID, // GFN 'CharacteristicInternalID' is deprecated, underlying data source is using the successor

      
      I_InspSpecificationVersion.DefectFractionEstimationProced,
      
      /* Associations */
      _Text
}

Depth:

A_InspectionSpecification view

I_InspSpecificationVersion view