E_MaterialSample

DDL: E_MATERIALSAMPLE SQL: EMATERIALSAMPLE Type: view EXTENSION Package: VDM_QM_INSPECTION
1 Fields 1 Data Sources

Material Sample Extension

E_MaterialSample is a Extension CDS View that provides data about "Material Sample Extension" in SAP S/4HANA. It reads from 1 data source (qprs) and exposes 1 field with key field MaterialSample. Part of development package VDM_QM_INSPECTION.

Data Sources (1)

SourceAliasJoin Type
qprs Persistence from

Annotations (7)

NameValueLevelField
EndUserText.label Material Sample Extension view
AbapCatalog.sqlViewName EMATERIALSAMPLE view
VDM.viewType #EXTENSION view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view

Fields (1)

KeyFieldSource TableSource FieldDescription
KEY MaterialSample phynr Sample

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_MaterialSample.
-- 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: EMATERIALSAMPLE

CREATE VIEW E_MaterialSample AS
SELECT
  phynr AS MaterialSample
FROM qprs AS Persistence
;

Learn More