I_InspMethInspSpec

DDL: I_INSPMETHINSPSPEC SQL: IIMETHDISPEC Type: view COMPOSITE
13 Fields 2 Data Sources

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.

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 Insp. Method
KEY InspectionMethodPlant I_AssgmtInspMethInspSpec InspectionMethodPlant Plant
KEY InspectionMethodVersion I_AssgmtInspMethInspSpec InspectionMethodVersion Version
KEY InspectionSpecification I_InspSpecificationVersion InspectionSpecification Master IC
KEY InspectionSpecificationPlant I_InspSpecificationVersion InspectionSpecificationPlant Version
KEY InspectionSpecificationVersion I_InspSpecificationVersion InspectionSpecificationVersion XML Vers.
InspSpecCharacteristicType I_InspSpecificationVersion InspSpecCharacteristicType
InspectionSpecificationStatus I_InspSpecificationVersion InspectionSpecificationStatus Status
_InspSpecVersionText I_InspSpecificationVersion _Text
_InspSpecificationPlant I_InspSpecificationVersion _InspSpecificationPlant
_InspSpecCharcType I_InspSpecificationVersion _InspSpecCharcType
_InspSpecStatus I_InspSpecificationVersion _InspSpecStatus
_InspectionMethodVersion I_AssgmtInspMethInspSpec _InspectionMethodVersion

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 I_InspMethInspSpec.
-- 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: IIMETHDISPEC

CREATE VIEW I_InspMethInspSpec AS
SELECT
  I_AssgmtInspMethInspSpec.InspectionMethod AS InspectionMethod,
  I_AssgmtInspMethInspSpec.InspectionMethodPlant AS InspectionMethodPlant,
  I_AssgmtInspMethInspSpec.InspectionMethodVersion AS InspectionMethodVersion,
  I_InspSpecificationVersion.InspectionSpecification AS InspectionSpecification,
  I_InspSpecificationVersion.InspectionSpecificationPlant AS InspectionSpecificationPlant,
  I_InspSpecificationVersion.InspectionSpecificationVersion AS InspectionSpecificationVersion,
  I_InspSpecificationVersion.InspSpecCharacteristicType AS InspSpecCharacteristicType,
  I_InspSpecificationVersion.InspectionSpecificationStatus AS InspectionSpecificationStatus,
  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
FROM I_InspSpecificationVersion
INNER JOIN I_AssgmtInspMethInspSpec ON /* join condition not captured in parsed metadata */
;

Learn More