I_InspSpecificationVersionTP

DDL: I_INSPSPECIFICATIONVERSIONTP Type: view_entity TRANSACTIONAL Package: VDM_QM_PLANNING

Master Inspection Characteristic

I_InspSpecificationVersionTP is a Transactional CDS View that provides data about "Master Inspection Characteristic" in SAP S/4HANA. It reads from 1 data source (I_InspSpecificationVersion) and exposes 133 fields with key fields InspectionSpecificationPlant, InspectionSpecification, InspectionSpecificationVersion. It has 4 associations to related views. Part of development package VDM_QM_PLANNING.

Data Sources (1)

SourceAliasJoin Type
I_InspSpecificationVersion I_InspSpecificationVersion from

Associations (4)

CardinalityTargetAliasCondition
[1..1] E_InspSpecificationVersion _Extension $projection.InspectionSpecificationPlant = _Extension.InspectionSpecificationPlant and $projection.InspectionSpecification = _Extension.InspectionSpecification and $projection.InspectionSpecificationVersion = _Extension.InspectionSpecificationVersion
[0..*] I_InspSpecInspMethTP _InspectionMethod
[0..*] I_InspSpecCatalogTP _InspSpecCatalog
[0..*] I_InspSpecVersionTextTP _InspSpecVersionText

Annotations (13)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Master Inspection Characteristic view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.transactionalProcessingEnabled true view
ObjectModel.sapObjectNodeType.name InspectionSpecification view
ObjectModel.lifecycle.enqueue.expiryBehavior #RELATIVE_TO_LAST_CHANGE view
ObjectModel.lifecycle.enqueue.expiryInterval PT15M view
ObjectModel.lifecycle.processing.expiryBehavior #RELATIVE_TO_LAST_CHANGE view
ObjectModel.lifecycle.processing.expiryInterval PT30M view

Fields (133)

KeyFieldSource TableSource FieldDescription
KEY InspectionSpecificationPlant I_InspSpecificationVersion InspectionSpecificationPlant
KEY InspectionSpecification I_InspSpecificationVersion InspectionSpecification
KEY InspectionSpecificationVersion I_InspSpecificationVersion InspectionSpecificationVersion
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
ChangedDateTime I_InspSpecificationVersion ChangedDateTime
InspSpecControlIndicators I_InspSpecificationVersion InspSpecControlIndicators
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
InspSpecIsSampleQtyAdditive I_InspSpecificationVersion InspSpecIsSampleQtyAdditive
InspSpecIsDestructive I_InspSpecificationVersion InspSpecIsDestructive
InspSpecResultCalculation I_InspSpecificationVersion InspSpecResultCalculation
InspSpecIsSamplingProcedRqd I_InspSpecificationVersion InspSpecIsSamplingProcedRqd
InspSpecIsScrapRelevant I_InspSpecificationVersion InspSpecIsScrapRelevant
InspSpecHasFixedCtrlIndicators I_InspSpecificationVersion InspSpecHasFixedCtrlIndicators
InspSpecIsDefectRecordingRqd I_InspSpecificationVersion InspSpecIsDefectRecordingRqd
InspSpecIsTestEquipmentRqd I_InspSpecificationVersion InspSpecIsTestEquipmentRqd
InspSpecIsDefectsRecgAutomatic I_InspSpecificationVersion InspSpecIsDefectsRecgAutomatic
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
InspSpecTargetValue I_InspSpecificationVersion InspSpecTargetValue
InspSpecHasTargetValue I_InspSpecificationVersion InspSpecHasTargetValue
InspSpecUpperLimit I_InspSpecificationVersion InspSpecUpperLimit
InspSpecHasUpperLimit I_InspSpecificationVersion InspSpecHasUpperLimit
InspSpecLowerLimit I_InspSpecificationVersion InspSpecLowerLimit
InspSpecHasLowerLimit I_InspSpecificationVersion InspSpecHasLowerLimit
InspSpecFirstUpperSpecLimit I_InspSpecificationVersion InspSpecFirstUpperSpecLimit
InspSpecHasFirstUpperSpecLimit I_InspSpecificationVersion InspSpecHasFirstUpperSpecLimit
InspSpecFirstLowerSpecLimit I_InspSpecificationVersion InspSpecFirstLowerSpecLimit
InspSpecHasFirstLowerSpecLimit I_InspSpecificationVersion InspSpecHasFirstLowerSpecLimit
InspSpecSecondUpperSpecLimit I_InspSpecificationVersion InspSpecSecondUpperSpecLimit
InspSpecHasSecondUprSpecLimit I_InspSpecificationVersion InspSpecHasSecondUprSpecLimit
InspSpecSecondLowerSpecLimit I_InspSpecificationVersion InspSpecSecondLowerSpecLimit
InspSpecHasSecondLowrSpecLimit I_InspSpecificationVersion InspSpecHasSecondLowrSpecLimit
InspSpecUpperPlausibilityLimit I_InspSpecificationVersion InspSpecUpperPlausibilityLimit
InspSpecHasUprPlausibilityLmt I_InspSpecificationVersion InspSpecHasUprPlausibilityLmt
InspSpecLowerPlausibilityLimit I_InspSpecificationVersion InspSpecLowerPlausibilityLimit
InspSpecHasLowrPlausibilityLmt I_InspSpecificationVersion InspSpecHasLowrPlausibilityLmt
InspSpecUpperSpecLimitChange I_InspSpecificationVersion InspSpecUpperSpecLimitChange
InspSpecHasUprSpecLimitChange I_InspSpecificationVersion InspSpecHasUprSpecLimitChange
InspSpecLowerSpecLimitChange I_InspSpecificationVersion InspSpecLowerSpecLimitChange
InspSpecHasLowrSpecLimitChange I_InspSpecificationVersion InspSpecHasLowrSpecLimitChange
InspSpecToleranceChgValidFrom I_InspSpecificationVersion InspSpecToleranceChgValidFrom
InspSpecToleranceChgValidTo I_InspSpecificationVersion InspSpecToleranceChgValidTo
InspSpecDefectCodeGrpRjcnLower I_InspSpecificationVersion InspSpecDefectCodeGrpRjcnLower
InspSpecDefectCodeRjcnLower I_InspSpecificationVersion InspSpecDefectCodeRjcnLower
InspSpecDefectCodeGrpRjcnUpper I_InspSpecificationVersion InspSpecDefectCodeGrpRjcnUpper
InspSpecDefectCodeRjcnUpper I_InspSpecificationVersion InspSpecDefectCodeRjcnUpper
CharcInternalID I_InspSpecificationVersion CharcInternalID
CharacteristicInternalID I_InspSpecificationVersion CharcInternalID
Characteristic
CharcDescription
CharacteristicDescription
DefectFractionEstimationProced I_InspSpecificationVersion DefectFractionEstimationProced
InspSpecDefectCodeGrpRejection I_InspSpecificationVersion InspSpecDefectCodeGrpRejection
InspSpecDefectCodeRejection I_InspSpecificationVersion InspSpecDefectCodeRejection
InspSpecDeterminationRule I_InspSpecificationVersion InspSpecDeterminationRule
InspSpecIsDetnRuleActive I_InspSpecificationVersion InspSpecIsDetnRuleActive
_InspectionMethod _InspectionMethod
_InspSpecCatalog _InspSpecCatalog
_InspSpecVersionText _InspSpecVersionText
_Text _Text
_InspectionSpecification _InspectionSpecification
_InspSpecStatus _InspSpecStatus
_InspSpecStatusText _InspSpecStatusText
_InspSpecificationPlant _InspSpecificationPlant
_Plant _Plant
_InspSpecCreatedByUser _InspSpecCreatedByUser
_CreatedByUserContactCard _CreatedByUserContactCard
_InspSpecChangedByUser _InspSpecChangedByUser
_ChangedByUserContactCard _ChangedByUserContactCard
_InspToleranceSpec _InspToleranceSpec
_InspToleranceSpecText _InspToleranceSpecText
_InspSpecTransferType _InspSpecTransferType
_InspSpecTransferTypeText _InspSpecTransferTypeText
_InspSpecCharcType _InspSpecCharcType
_InspSpecCharcTypeText _InspSpecCharcTypeText
_InspectionScope _InspectionScope
_InspectionScopeText _InspectionScopeText
_InspSpecRecordingType _InspSpecRecordingType
_InspSpecRecordingTypeText _InspSpecRecordingTypeText
_InspResultDocuRequired _InspResultDocuRequired
_InspResultDocuRequiredText _InspResultDocuRequiredText
_InspectorQualification _InspectorQualification
_InspectorQualificationText _InspectorQualificationText
_QltyMstrDataAuthznGrp _QltyMstrDataAuthznGrp
_QltyMstrDataAuthznGrpTxt _QltyMstrDataAuthznGrpTxt
_InspSpecCharcCategory _InspSpecCharcCategory
_InspSpecCharcCategoryText _InspSpecCharcCategoryText
_InspSpecRsltCalculation _InspSpecRsltCalculation
_InspSpecRsltCalculationText _InspSpecRsltCalculationText
_InspSpecPrintControl _InspSpecPrintControl
_InspSpecPrintControlText _InspSpecPrintControlText
_UnitOfMeasure _UnitOfMeasure
_InspDefectCodeGrpRejection _InspDefectCodeGrpRejection
_InspDefectCodeRejection _InspDefectCodeRejection
_InspDefectCodeGrpRjcnLower _InspDefectCodeGrpRjcnLower
_InspDefectCodeRjcnLower _InspDefectCodeRjcnLower
_InspDefectCodeGrpRjcnUpper _InspDefectCodeGrpRjcnUpper
_InspDefectCodeRjcnUpper _InspDefectCodeRjcnUpper
_InspSpecImportanceCode _InspSpecImportanceCode
_InspSpecImportanceCodeText _InspSpecImportanceCodeText
_DefectFractionEstnProced _DefectFractionEstnProced
_DefectFractionEstnProcedTxt _DefectFractionEstnProcedTxt
_ClfnCharcDescForKeyDate _ClfnCharcDescForKeyDate
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Master Inspection Characteristic'
@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API
}
@ObjectModel.usageType: {
    dataClass: #MASTER,
    sizeCategory: #M, //expected number of rows < 100.000

    serviceQuality: #C // includes A,B as well

}

/* Draft 2.0 */
@ObjectModel.semanticKey:  [ 'InspectionSpecificationPlant' , 'InspectionSpecification' , 'InspectionSpecificationVersion' ] 
@ObjectModel:{
    transactionalProcessingEnabled: true,
    sapObjectNodeType.name: 'InspectionSpecification',
    lifecycle.enqueue: {
        expiryBehavior: #RELATIVE_TO_LAST_CHANGE,  // Default #RELATIVE_TO_LAST_CHANGE

        expiryInterval: 'PT15M'                   // Default 'PT15M'

      //  notificationBeforeExpiryInterval: 'PT1M'   // Default 'PT5M'

    },
    lifecycle.processing: {
        expiryBehavior: #RELATIVE_TO_LAST_CHANGE,  // Default #RELATIVE_TO_LAST_CHANGE

        expiryInterval: 'PT30M'                        // Default 'PT30M'

      //  notificationBeforeExpiryInterval: 'PT3M'       // Default 'PT10M'

    }
}

define root view entity I_InspSpecificationVersionTP as select from I_InspSpecificationVersion

  composition [0..*] of I_InspSpecInspMethTP           as _InspectionMethod             
                                                                                        
                                                                                        

  composition [0..*] of I_InspSpecCatalogTP            as _InspSpecCatalog              
                                                                                        
                                                                                        
  
  composition [0..*] of I_InspSpecVersionTextTP        as _InspSpecVersionText          
                                                                                        
                                                                                        
  
  //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.InspectionSpecificationPlant,
   key I_InspSpecificationVersion.InspectionSpecification,
   key I_InspSpecificationVersion.InspectionSpecificationVersion,
   
      I_InspSpecificationVersion.Plant,
      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.ChangedDateTime,
      I_InspSpecificationVersion.InspSpecControlIndicators,
      I_InspSpecificationVersion.InspSpecIsQuantitative,
      I_InspSpecificationVersion.InspSpecCharacteristicType,
      I_InspSpecificationVersion.InspSpecIsMeasuredValueRqd,
      I_InspSpecificationVersion.InspSpecIsSelectedSetRequired,
      I_InspSpecificationVersion.InspSpecIsUpperLimitRequired,
      I_InspSpecificationVersion.InspSpecIsLowerLimitRequired,
      I_InspSpecificationVersion.InspSpecIsTargetValueInLimit,
      I_InspSpecificationVersion.InspectionScope,
      I_InspSpecificationVersion.InspSpecIsLongTermInspection,
      I_InspSpecificationVersion.InspSpecRecordingType,
      I_InspSpecificationVersion.InspResultIsDocumentationRqd,
      I_InspSpecificationVersion.InspSpecCharcCategory,
      I_InspSpecificationVersion.InspSpecIsSampleQtyAdditive,
      I_InspSpecificationVersion.InspSpecIsDestructive,
      I_InspSpecificationVersion.InspSpecResultCalculation,
      I_InspSpecificationVersion.InspSpecIsSamplingProcedRqd,
      I_InspSpecificationVersion.InspSpecIsScrapRelevant,
      I_InspSpecificationVersion.InspSpecHasFixedCtrlIndicators,
      I_InspSpecificationVersion.InspSpecIsDefectRecordingRqd,
      I_InspSpecificationVersion.InspSpecIsTestEquipmentRqd,
      I_InspSpecificationVersion.InspSpecIsDefectsRecgAutomatic,
      I_InspSpecificationVersion.InspSpecIsChgDocRequired,
      I_InspSpecificationVersion.InspSpecIsControlChartUsed,
      I_InspSpecificationVersion.InspSpecPrintControl,
      I_InspSpecificationVersion.InspSpecImportanceCode,
      I_InspSpecificationVersion.InspectorQualification,
      I_InspSpecificationVersion.InspSpecInformationField1,
      I_InspSpecificationVersion.InspSpecInformationField2,
      I_InspSpecificationVersion.InspSpecInformationField3,
      I_InspSpecificationVersion.QltyMstrDataAuthorizationGroup,
      I_InspSpecificationVersion.InspToleranceSpecification,
      I_InspSpecificationVersion.InspSpecDecimalPlaces,
      I_InspSpecificationVersion.InspectionSpecificationUnit,
      I_InspSpecificationVersion.InspSpecTargetValue,
      I_InspSpecificationVersion.InspSpecHasTargetValue,
      I_InspSpecificationVersion.InspSpecUpperLimit,
      I_InspSpecificationVersion.InspSpecHasUpperLimit,
      I_InspSpecificationVersion.InspSpecLowerLimit,
      I_InspSpecificationVersion.InspSpecHasLowerLimit,
      I_InspSpecificationVersion.InspSpecFirstUpperSpecLimit,
      I_InspSpecificationVersion.InspSpecHasFirstUpperSpecLimit,
      I_InspSpecificationVersion.InspSpecFirstLowerSpecLimit,
      I_InspSpecificationVersion.InspSpecHasFirstLowerSpecLimit,
      I_InspSpecificationVersion.InspSpecSecondUpperSpecLimit,
      I_InspSpecificationVersion.InspSpecHasSecondUprSpecLimit,
      I_InspSpecificationVersion.InspSpecSecondLowerSpecLimit,
      I_InspSpecificationVersion.InspSpecHasSecondLowrSpecLimit,
      I_InspSpecificationVersion.InspSpecUpperPlausibilityLimit,
      I_InspSpecificationVersion.InspSpecHasUprPlausibilityLmt,
      I_InspSpecificationVersion.InspSpecLowerPlausibilityLimit,
      I_InspSpecificationVersion.InspSpecHasLowrPlausibilityLmt,
      I_InspSpecificationVersion.InspSpecUpperSpecLimitChange,
      I_InspSpecificationVersion.InspSpecHasUprSpecLimitChange,
      I_InspSpecificationVersion.InspSpecLowerSpecLimitChange,
      I_InspSpecificationVersion.InspSpecHasLowrSpecLimitChange,
      I_InspSpecificationVersion.InspSpecToleranceChgValidFrom,
      I_InspSpecificationVersion.InspSpecToleranceChgValidTo,
      I_InspSpecificationVersion.InspSpecDefectCodeGrpRjcnLower,
      I_InspSpecificationVersion.InspSpecDefectCodeRjcnLower,
      I_InspSpecificationVersion.InspSpecDefectCodeGrpRjcnUpper,
      I_InspSpecificationVersion.InspSpecDefectCodeRjcnUpper,
      I_InspSpecificationVersion.CharcInternalID,
      I_InspSpecificationVersion.CharcInternalID as CharacteristicInternalID,  // GFN CharacteristicInternalID deprecated, keep it for compatibility

      @ObjectModel: {
        text.element: ['CharcDescription']
      }
      _ClfnCharacteristicForKeyDate(P_KeyDate: $session.system_date).Characteristic as Characteristic,
      _ClfnCharcDescForKeyDate(P_KeyDate: $session.system_date)[1:Language = $session.system_language ].CharcDescription,                                 
      _ClfnCharcDescForKeyDate(P_KeyDate: $session.system_date)[1:Language = $session.system_language ].CharcDescription as CharacteristicDescription, // GFN CharacteristicDescription deprecated, keep it for compatibility

      I_InspSpecificationVersion.DefectFractionEstimationProced,
      I_InspSpecificationVersion.InspSpecDefectCodeGrpRejection,
      I_InspSpecificationVersion.InspSpecDefectCodeRejection,
      I_InspSpecificationVersion.InspSpecDeterminationRule,
      I_InspSpecificationVersion.InspSpecIsDetnRuleActive,
   
      /* Compoistions */
      _InspectionMethod,
      _InspSpecCatalog,
      _InspSpecVersionText,
      
      /* Associations */
      _Text,
      _InspectionSpecification,
      _InspSpecStatus,
      _InspSpecStatusText,
      _InspSpecificationPlant,
      _Plant,
      _InspSpecCreatedByUser,
      _CreatedByUserContactCard,
      _InspSpecChangedByUser,
      _ChangedByUserContactCard,
      _InspToleranceSpec,
      _InspToleranceSpecText,
      _InspSpecTransferType,
      _InspSpecTransferTypeText,
      _InspSpecCharcType,
      _InspSpecCharcTypeText,
      _InspectionScope,
      _InspectionScopeText,
      _InspSpecRecordingType,
      _InspSpecRecordingTypeText,
      _InspResultDocuRequired,
      _InspResultDocuRequiredText,
      _InspectorQualification,
      _InspectorQualificationText,
      _QltyMstrDataAuthznGrp,
      _QltyMstrDataAuthznGrpTxt,
      _InspSpecCharcCategory,
      _InspSpecCharcCategoryText,
      _InspSpecRsltCalculation,
      _InspSpecRsltCalculationText,
      _InspSpecPrintControl,
      _InspSpecPrintControlText,
      _UnitOfMeasure,
      _InspDefectCodeGrpRejection,
      _InspDefectCodeRejection,
      _InspDefectCodeGrpRjcnLower,
      _InspDefectCodeRjcnLower,
      _InspDefectCodeGrpRjcnUpper,
      _InspDefectCodeRjcnUpper,
//      _InspSpecDeterminationRule,

//      _InspSpecDeterminationRuleTxt,

      _InspSpecImportanceCode,
      _InspSpecImportanceCodeText,
      _DefectFractionEstnProced,
      _DefectFractionEstnProcedTxt,
//      _ClfnCharacteristicForKeyDate,

      _ClfnCharcDescForKeyDate

}