I_MaterialDescription

DDL: I_MATERIALDESCRIPTION SQL: IMATDESC Type: view BASIC
2 Fields 2 Data Sources

Material Description

I_MaterialDescription is a Basic CDS View that provides data about "Material Description" in SAP S/4HANA. It reads from 2 data sources (makt, mara) and exposes 2 fields with key field Material.

Data Sources (2)

SourceAliasJoin Type
makt makt left_outer
mara mara from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName IMATDESC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Material Description view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY Material mara matnr Vehicle Model
MaterialDescription makt maktx Product Description

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_MaterialDescription.
-- 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: IMATDESC

CREATE VIEW I_MaterialDescription AS
SELECT
  mara.matnr AS Material,
  makt.maktx AS MaterialDescription
FROM mara
LEFT OUTER JOIN makt ON /* join condition not captured in parsed metadata */
;

Learn More