E_InspSpecificationVersion

DDL: E_INSPSPECIFICATIONVERSION SQL: EINSPSPEC Type: view EXTENSION

Inspection Specification Version Ext.

E_InspSpecificationVersion is a Extension CDS View that provides data about "Inspection Specification Version Ext." in SAP S/4HANA. It reads from 1 data source (qpmk) and exposes 3 fields with key fields InspectionSpecificationPlant, InspectionSpecification, InspectionSpecificationVersion.

Data Sources (1)

SourceAliasJoin Type
qpmk Persistence from

Annotations (8)

NameValueLevelField
EndUserText.label Inspection Specification Version Ext. view
AbapCatalog.sqlViewName EINSPSPEC view
VDM.viewType #EXTENSION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ClientHandling.algorithm #AUTOMATED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (3)

KeyFieldSource TableSource FieldDescription
KEY InspectionSpecificationPlant qpmk zaehler Version
KEY InspectionSpecification qpmk mkmnr Master IC
KEY InspectionSpecificationVersion qpmk version XML Vers.

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 E_InspSpecificationVersion.
-- 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: EINSPSPEC

CREATE VIEW E_InspSpecificationVersion AS
SELECT
  Persistence.zaehler AS InspectionSpecificationPlant,
  Persistence.mkmnr AS InspectionSpecification,
  Persistence.version AS InspectionSpecificationVersion
FROM qpmk AS Persistence
;