C_Qm_Mic_Methods

DDL: C_QM_MIC_METHODS SQL: C_QM_MICMETHODS Type: view CONSUMPTION
10 Fields 2 Data Sources 1 Associations

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.

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 Version
KEY InspectionSpecification I_InspSpecificationVersion InspectionSpecification Master IC
KEY InspectionSpecificationVersion I_InspSpecificationVersion InspectionSpecificationVersion XML Vers.
InspectionCharacteristic I_AssgmtInspMethInspSpec InspectionSpecification Master IC
InspectionMethodPlant I_AssgmtInspMethInspSpec InspectionMethodPlant Plant
InspectionMethod I_AssgmtInspMethInspSpec InspectionMethod Insp. Method
InspectionMethodVersion I_AssgmtInspMethInspSpec InspectionMethodVersion Version
InspectionMethodText
QltyMstrDataAuthorizationGroup I_InspSpecificationVersion QltyMstrDataAuthorizationGroup QM Matl Auth.
InspectionSpecificationStatus I_InspSpecificationVersion InspectionSpecificationStatus Status

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_Qm_Mic_Methods.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: C_QM_MICMETHODS

CREATE VIEW C_Qm_Mic_Methods AS
SELECT
  I_InspSpecificationVersion.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  I_InspSpecificationVersion.InspectionSpecification AS InspectionSpecification,
  I_InspSpecificationVersion.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  _AssgmtInspMethInspSpec.InspectionSpecification AS InspectionCharacteristic,
  _AssgmtInspMethInspSpec.InspectionMethodPlant AS InspectionMethodPlant,
  _AssgmtInspMethInspSpec.InspectionMethod AS InspectionMethod,
  _AssgmtInspMethInspSpec.InspectionMethodVersion AS InspectionMethodVersion,
  _InspectionMethodVersion._InspectionMethodText[1:Language = $session.system_language].InspectionMethodText AS InspectionMethodText,
  I_InspSpecificationVersion.QltyMstrDataAuthorizationGroup AS QltyMstrDataAuthorizationGroup,
  I_InspSpecificationVersion.InspectionSpecificationStatus AS InspectionSpecificationStatus
FROM I_InspSpecificationVersion
LEFT OUTER JOIN I_AssgmtInspMethInspSpec AS _AssgmtInspMethInspSpec ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_InspectionMethodVersion AS _InspectionMethodVersion ON InspectionMethodPlant = _InspectionMethodVersion.InspectionMethodPlant AND InspectionMethod = _InspectionMethodVersion.InspectionMethod AND InspectionMethodVersion = _InspectionMethodVersion.InspectionMethodVersion  -- association [0..1]
;

Learn More