I_InspMethInspSpec

DDL: I_INSPMETHINSPSPEC SQL: IIMETHDISPEC Type: view COMPOSITE Package: VDM_QM_PLANNING

Master Charcs. of Inspection Method

I_InspMethInspSpec is a Composite CDS View that provides data about "Master Charcs. of Inspection Method" in SAP S/4HANA. It reads from 2 data sources (I_AssgmtInspMethInspSpec, I_InspSpecificationVersion) and exposes 13 fields with key fields InspectionMethod, InspectionMethodPlant, InspectionMethodVersion, InspectionSpecification, InspectionSpecificationPlant. Part of development package VDM_QM_PLANNING.

2 data source(s) 13 fields

Data Sources (2)

SourceAliasJoin Type
I_AssgmtInspMethInspSpec I_AssgmtInspMethInspSpec inner
I_InspSpecificationVersion I_InspSpecificationVersion from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IIMETHDISPEC view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Master Charcs. of Inspection Method view
VDM.viewType #COMPOSITE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
Metadata.ignorePropagatedAnnotations true view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY InspectionMethod I_AssgmtInspMethInspSpec InspectionMethod
KEY InspectionMethodPlant I_AssgmtInspMethInspSpec InspectionMethodPlant
KEY InspectionMethodVersion I_AssgmtInspMethInspSpec InspectionMethodVersion
KEY InspectionSpecification I_InspSpecificationVersion InspectionSpecification
KEY InspectionSpecificationPlant I_InspSpecificationVersion InspectionSpecificationPlant
KEY InspectionSpecificationVersion I_InspSpecificationVersion InspectionSpecificationVersion
InspSpecCharacteristicType I_InspSpecificationVersion InspSpecCharacteristicType
InspectionSpecificationStatus I_InspSpecificationVersion InspectionSpecificationStatus
_InspSpecVersionText I_InspSpecificationVersion _Text
_InspSpecificationPlant I_InspSpecificationVersion _InspSpecificationPlant
_InspSpecCharcType I_InspSpecificationVersion _InspSpecCharcType
_InspSpecStatus I_InspSpecificationVersion _InspSpecStatus
_InspectionMethodVersion I_AssgmtInspMethInspSpec _InspectionMethodVersion 
@AbapCatalog.sqlViewName: 'IIMETHDISPEC'
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Master Charcs. of Inspection Method'
@VDM.viewType: #COMPOSITE
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
}
@Metadata.ignorePropagatedAnnotations: true

define view I_InspMethInspSpec as select from I_InspSpecificationVersion 
  inner join I_AssgmtInspMethInspSpec 
        on    I_InspSpecificationVersion.InspectionSpecification = I_AssgmtInspMethInspSpec.InspectionSpecification
          and I_InspSpecificationVersion.InspectionSpecificationPlant = I_AssgmtInspMethInspSpec.InspectionSpecificationPlant
          and I_InspSpecificationVersion.InspectionSpecificationVersion = I_AssgmtInspMethInspSpec.InspectionSpecificationVersion
          and I_AssgmtInspMethInspSpec.InspectionMethodPlant    <> ' '
          and I_AssgmtInspMethInspSpec.InspectionMethod         <> ' '
          and I_AssgmtInspMethInspSpec.InspectionMethodVersion  <> ' '

{
   key I_AssgmtInspMethInspSpec.InspectionMethod,
   key I_AssgmtInspMethInspSpec.InspectionMethodPlant,
   key I_AssgmtInspMethInspSpec.InspectionMethodVersion,
   key I_InspSpecificationVersion.InspectionSpecification,
   @ObjectModel.foreignKey.association: '_InspSpecificationPlant'
   key I_InspSpecificationVersion.InspectionSpecificationPlant,
   key I_InspSpecificationVersion.InspectionSpecificationVersion,
   
   @ObjectModel.foreignKey.association: '_InspSpecCharcType'
   I_InspSpecificationVersion.InspSpecCharacteristicType,
   @ObjectModel.foreignKey.association: '_InspSpecStatus'
   I_InspSpecificationVersion.InspectionSpecificationStatus,
   case I_InspSpecificationVersion.InspectionSpecificationStatus
    /* 'Neutral' is reflected by 0, 'Negative' is reflected by 1, the value 'Critical' by 2, and the value 'Positive' by 3.*/
     when '2' then 3 // 2=Released --> 3=Positive

     when '1' then 2 // 1=Being Created --> 2=Critical

     when '3' then 1 // 3=Can no longer be used --> 1=Negative                                                                                                      

     else 0 
   end as InspSpecStatusCriticality,
   
   /* Associations */
   I_InspSpecificationVersion._Text                      as _InspSpecVersionText,
   I_InspSpecificationVersion._InspSpecificationPlant    as _InspSpecificationPlant,
   I_InspSpecificationVersion._InspSpecCharcType         as _InspSpecCharcType,
   I_InspSpecificationVersion._InspSpecStatus            as _InspSpecStatus,
   I_AssgmtInspMethInspSpec._InspectionMethodVersion     as _InspectionMethodVersion
   
}

Learn More