I_InspMethVersVH

DDL: I_INSPMETHVERSVH SQL: IIMV__VH1 Type: view COMPOSITE

Inspection Method Version Value Help

I_InspMethVersVH is a Composite CDS View that provides data about "Inspection Method Version Value Help" in SAP S/4HANA. It reads from 1 data source (I_InspectionMethodVersion) and exposes 14 fields with key fields InspectionMethod, InspectionMethodVersion, InspectionMethodPlant.

Data Sources (1)

SourceAliasJoin Type
I_InspectionMethodVersion I_InspectionMethodVersion from

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IIMV__VH1 view
AbapCatalog.compiler.compareFilter true view
VDM.viewType #COMPOSITE view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey InspectionMethodVersion view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Inspection Method Version Value Help view
Consumption.ranked true view
Search.searchable true view

Fields (14)

KeyFieldSource TableSource FieldDescription
KEY InspectionMethod InspectionMethod Insp. Method
KEY InspectionMethodVersion InspectionMethodVersion XML Vers.
KEY InspectionMethodPlant InspectionMethodPlant Receiving Plant
InspectionMethodStatus InspectionMethodStatus Status
QltyMstrDataAuthorizationGroup QltyMstrDataAuthorizationGroup QM Matl Auth.
InspectionMethodValidFromDate InspectionMethodValidFromDate Valid From
InspectionMethodSearchField InspectionMethodSearchField Search Field
InspectorQualification InspectorQualification Inspector Qualification
InspMethInformationField1 InspMethInformationField1 Info Field 1
InspMethInformationField2 InspMethInformationField2 Info Field 2
InspMethInformationField3 InspMethInformationField3 Info Field 3
_InspectionMethodPlant _InspectionMethodPlant
_InspectionMethod _InspectionMethod
_InspectorQualification _InspectorQualification

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_InspMethVersVH.
-- 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: IIMV__VH1

CREATE VIEW I_InspMethVersVH AS
SELECT
  InspectionMethod,
  InspectionMethodVersion,
  InspectionMethodPlant,
  InspectionMethodStatus,
  QltyMstrDataAuthorizationGroup,
  InspectionMethodValidFromDate,
  InspectionMethodSearchField,
  InspectorQualification,
  InspMethInformationField1,
  InspMethInformationField2,
  InspMethInformationField3
FROM I_InspectionMethodVersion
;