C_Qm_Mic_Methods

DDL: C_QM_MIC_METHODS SQL: C_QM_MICMETHODS Type: view CONSUMPTION Package: ODATA_QM_RR

Methods assigned to Master Inspection Characteristics

C_Qm_Mic_Methods is a Consumption CDS View that provides data about "Methods assigned to Master Inspection Characteristics" in SAP S/4HANA. It reads from 2 data sources (I_AssgmtInspMethInspSpec, I_InspSpecificationVersion) and exposes 10 fields with key fields InspectionSpecificationPlant, InspectionSpecification, InspectionSpecificationVersion. It has 1 association to related views. Part of development package ODATA_QM_RR.

2 data source(s) 10 fields

Data Sources (2)

SourceAliasJoin Type
I_AssgmtInspMethInspSpec _AssgmtInspMethInspSpec left_outer
I_InspSpecificationVersion I_InspSpecificationVersion from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_InspectionMethodVersion _InspectionMethodVersion $projection.InspectionMethodPlant = _InspectionMethodVersion.InspectionMethodPlant and $projection.InspectionMethod = _InspectionMethodVersion.InspectionMethod and $projection.InspectionMethodVersion = _InspectionMethodVersion.InspectionMethodVersion

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName C_QM_MICMETHODS view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label Methods assigned to Master Inspection Characteristics view
Search.searchable true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY InspectionSpecificationPlant I_InspSpecificationVersion InspectionSpecificationPlant
KEY InspectionSpecification I_InspSpecificationVersion InspectionSpecification
KEY InspectionSpecificationVersion I_InspSpecificationVersion InspectionSpecificationVersion
InspectionCharacteristic I_AssgmtInspMethInspSpec InspectionSpecification
InspectionMethodPlant I_AssgmtInspMethInspSpec InspectionMethodPlant
InspectionMethod I_AssgmtInspMethInspSpec InspectionMethod
InspectionMethodVersion I_AssgmtInspMethInspSpec InspectionMethodVersion
InspectionMethodText
QltyMstrDataAuthorizationGroup I_InspSpecificationVersion QltyMstrDataAuthorizationGroup
InspectionSpecificationStatus I_InspSpecificationVersion InspectionSpecificationStatus 
@AbapCatalog.sqlViewName: 'C_QM_MICMETHODS'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Methods assigned to Master Inspection Characteristics'
@Search.searchable: true
@ObjectModel.usageType: {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #C
}
define view C_Qm_Mic_Methods
  as select from    I_InspSpecificationVersion
  //    left outer join I_InspSpecificationVersion_Method_Catalog as _Method_Catalog

  //    on  I_InspSpecificationVersion.InspectionSpecificationPlant   = _Method_Catalog.InspectionSpecificationPlant

  //    and I_InspSpecificationVersion.InspectionSpecification       = _Method_Catalog.InspectionCharacteristic

  //    and I_InspSpecificationVersion.InspectionSpecificationVersion = _Method_Catalog.InspectionSpecificationVersion


  //    association[0..1] to I_QM_Inspection_Methods as _MethodMaster

  //    on  $projection.InspectionMethodPlant   = _MethodMaster.InspectionMethodPlant

  //    and $projection.InspectionMethod        = _MethodMaster.InspectionMethod

  //    and $projection.InspectionMethodVersion = _MethodMaster.InspectionMethodVersion


    left outer join I_AssgmtInspMethInspSpec as _AssgmtInspMethInspSpec on  I_InspSpecificationVersion.InspectionSpecificationPlant   = _AssgmtInspMethInspSpec.InspectionSpecificationPlant
                                                                        and I_InspSpecificationVersion.InspectionSpecification        = _AssgmtInspMethInspSpec.InspectionSpecification
                                                                        and I_InspSpecificationVersion.InspectionSpecificationVersion = _AssgmtInspMethInspSpec.InspectionSpecificationVersion

  association [0..1] to I_InspectionMethodVersion as _InspectionMethodVersion on  $projection.InspectionMethodPlant   = _InspectionMethodVersion.InspectionMethodPlant
                                                                              and $projection.InspectionMethod        = _InspectionMethodVersion.InspectionMethod
                                                                              and $projection.InspectionMethodVersion = _InspectionMethodVersion.InspectionMethodVersion

{
  key I_InspSpecificationVersion.InspectionSpecificationPlant,
  key I_InspSpecificationVersion.InspectionSpecification,
  key I_InspSpecificationVersion.InspectionSpecificationVersion,
      _AssgmtInspMethInspSpec.InspectionSpecification as InspectionCharacteristic,
      _AssgmtInspMethInspSpec.InspectionMethodPlant,
      _AssgmtInspMethInspSpec.InspectionMethod,
      _AssgmtInspMethInspSpec.InspectionMethodVersion,
      _InspectionMethodVersion._InspectionMethodText[1:Language = $session.system_language].InspectionMethodText,
      @UI.hidden: true
      I_InspSpecificationVersion.QltyMstrDataAuthorizationGroup,        // Added for DCL

      @UI.hidden: true
      I_InspSpecificationVersion.InspectionSpecificationStatus         // Added for DCL      


}
where
      InspectionMethodPlant   <> ''
  and InspectionMethod        <> ''
  and InspectionMethodVersion <> ''

Learn More