P_Qm_Mic_Method_Catalog

DDL: P_QM_MIC_METHOD_CATALOG SQL: PQM_MIC_METH_CAT Type: view BASIC
34 Fields 1 Data Sources

P_Qm_Mic_Method_Catalog is a Basic CDS View in SAP S/4HANA. It reads from 1 data source (qpmz) and exposes 34 fields with key fields InspectionSpecificationPlant, InspectionCharacteristic, InspectionSpecificationVersion, InspectionMethodPlant, InspectionMethod.

Data Sources (1)

SourceAliasJoin Type
qpmz qpmz from

Annotations (6)

NameValueLevelField
AbapCatalog.sqlViewName PQM_MIC_METH_CAT view
ClientDependent true view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
VDM.private true view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY InspectionSpecificationPlant qpmz zaehler Version
KEY InspectionCharacteristic qpmz mkmnr Master IC
KEY InspectionSpecificationVersion qpmz version XML Vers.
KEY InspectionMethodPlant qpmz werkpm Plant
KEY InspectionMethod qpmz pmethode Insp. Method
KEY InspectionMethodVersion qpmz verspm Version
werkmk qpmz werkmk Plant
gueltigab qpmz gueltigab Valid From
anonr qpmz anonr Item
katab1 qpmz katab1 Selected Set
katalgart1 qpmz katalgart1 Catalog Type
auswmenge1 qpmz auswmenge1 CodeGrp/SelSet
version1 qpmz version1 Version
auswmgwrk1 qpmz auswmgwrk1 Plant
katab2 qpmz katab2 Selected Set
katalgart2 qpmz katalgart2 Catalog Type
auswmenge2 qpmz auswmenge2 CodeGrp/SelSet
version2 qpmz version2 Version
auswmgwrk2 qpmz auswmgwrk2 Plant
katab3 qpmz katab3 Selected Set
katalgart3 qpmz katalgart3 Catalog Type
auswmenge3 qpmz auswmenge3 CodeGrp/SelSet
version3 qpmz version3 Version
auswmgwrk3 qpmz auswmgwrk3 Plant
katab4 qpmz katab4 Selected Set
katalgart4 qpmz katalgart4 Catalog Type
auswmenge4 qpmz auswmenge4 CodeGrp/SelSet
version4 qpmz version4 Version
auswmgwrk4 qpmz auswmgwrk4 Plant
katab5 qpmz katab5 Selected Set
katalgart5 qpmz katalgart5 Catalog Type
auswmenge5 qpmz auswmenge5 CodeGrp/SelSet
version5 qpmz version5 Version
auswmgwrk5 qpmz auswmgwrk5 Plant

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 P_Qm_Mic_Method_Catalog.
-- 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: PQM_MIC_METH_CAT

CREATE VIEW P_Qm_Mic_Method_Catalog AS
SELECT
  qpmz.zaehler AS InspectionSpecificationPlant,
  qpmz.mkmnr AS InspectionCharacteristic,
  qpmz.version AS InspectionSpecificationVersion,
  qpmz.werkpm AS InspectionMethodPlant,
  qpmz.pmethode AS InspectionMethod,
  qpmz.verspm AS InspectionMethodVersion,
  qpmz.werkmk AS werkmk,
  qpmz.gueltigab AS gueltigab,
  qpmz.anonr AS anonr,
  qpmz.katab1 AS katab1,
  qpmz.katalgart1 AS katalgart1,
  qpmz.auswmenge1 AS auswmenge1,
  qpmz.version1 AS version1,
  qpmz.auswmgwrk1 AS auswmgwrk1,
  qpmz.katab2 AS katab2,
  qpmz.katalgart2 AS katalgart2,
  qpmz.auswmenge2 AS auswmenge2,
  qpmz.version2 AS version2,
  qpmz.auswmgwrk2 AS auswmgwrk2,
  qpmz.katab3 AS katab3,
  qpmz.katalgart3 AS katalgart3,
  qpmz.auswmenge3 AS auswmenge3,
  qpmz.version3 AS version3,
  qpmz.auswmgwrk3 AS auswmgwrk3,
  qpmz.katab4 AS katab4,
  qpmz.katalgart4 AS katalgart4,
  qpmz.auswmenge4 AS auswmenge4,
  qpmz.version4 AS version4,
  qpmz.auswmgwrk4 AS auswmgwrk4,
  qpmz.katab5 AS katab5,
  qpmz.katalgart5 AS katalgart5,
  qpmz.auswmenge5 AS auswmenge5,
  qpmz.version5 AS version5,
  qpmz.auswmgwrk5 AS auswmgwrk5
FROM qpmz
;

Learn More