C_Qm_Mic_F4

DDL: C_QM_MIC_F4 SQL: CQMMICF4 Type: view CONSUMPTION Package: ODATA_QM_RR

Master Inspection Characteristics

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

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
I_InspSpecificationVersion I_InspSpecificationVersion from

Associations (1)

CardinalityTargetAliasCondition
[0..1] C_Qm_Mic_Methods _Qm_Mic_Methods $projection.Plant = _Qm_Mic_Methods.InspectionSpecificationPlant and $projection.InspectionSpecification = _Qm_Mic_Methods.InspectionSpecification and $projection.InspectionSpecificationVersion = _Qm_Mic_Methods.InspectionSpecificationVersion

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CQMMICF4 view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #CONSUMPTION view
EndUserText.label 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 InspectionSpecification I_InspSpecificationVersion InspectionSpecification
KEY InspectionSpecificationVersion I_InspSpecificationVersion InspectionSpecificationVersion
KEY Plant I_InspSpecificationVersion Plant
PlantName Plant Name
InspectionCharacteristic Inspection Characteristic
InspectionSpecificationText
InspSpecControlIndicators I_InspSpecificationVersion InspSpecControlIndicators
QltyMstrDataAuthorizationGroup I_InspSpecificationVersion QltyMstrDataAuthorizationGroup
InspectionSpecificationStatus I_InspSpecificationVersion InspectionSpecificationStatus
_Qm_Mic_Methods _Qm_Mic_Methods 
@AbapCatalog.sqlViewName: 'CQMMICF4'
@ClientDependent: true
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #CONSUMPTION
@EndUserText.label: 'Master Inspection Characteristics'
@Search.searchable: true
@ObjectModel.usageType: {
    dataClass: #MASTER,
    sizeCategory: #M,
    serviceQuality: #C
}
define view C_Qm_Mic_F4
  as select from I_InspSpecificationVersion
  association [0..1] to C_Qm_Mic_Methods as _Qm_Mic_Methods on  $projection.Plant                          = _Qm_Mic_Methods.InspectionSpecificationPlant
                                                            and $projection.InspectionSpecification        = _Qm_Mic_Methods.InspectionSpecification
                                                            and $projection.InspectionSpecificationVersion = _Qm_Mic_Methods.InspectionSpecificationVersion

{
          @Search.defaultSearchElement: true
          @Search.fuzzinessThreshold: 0.8
  key     I_InspSpecificationVersion.InspectionSpecification  as InspectionSpecification,
  key     I_InspSpecificationVersion.InspectionSpecificationVersion,
  key     I_InspSpecificationVersion.Plant,
          @EndUserText.label: 'Plant Name'
          concat(concat(I_InspSpecificationVersion.Plant, '('), concat(I_InspSpecificationVersion._Plant.PlantName,')'))                                 as PlantName,
          @EndUserText.label: 'Inspection Characteristic'
          concat(concat(I_InspSpecificationVersion.InspectionSpecificationSrchTxt, '('), concat(I_InspSpecificationVersion.InspectionSpecification,')')) as InspectionCharacteristic,

          I_InspSpecificationVersion._Text[1:Language = $session.system_language].InspectionSpecificationText,

          I_InspSpecificationVersion.InspSpecControlIndicators,
          @UI.hidden: true
          I_InspSpecificationVersion.QltyMstrDataAuthorizationGroup, // Added for DCL

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


          /* Associations */
          _Qm_Mic_Methods
}
where
  (
       I_InspSpecificationVersion.InspSpecTransferType          = #QVOLLST.'1'
    or I_InspSpecificationVersion.InspSpecTransferType          = #QVOLLST.'X'
  )
  and  I_InspSpecificationVersion.InspectionSpecificationStatus = #QLOESCHKZ.'2'

Learn More