I_MaterialDescription

DDL: I_MATERIALDESCRIPTION SQL: IMATDESC Type: view BASIC

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.

2 data source(s) 2 fields

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
MaterialDescription makt maktx 
@AbapCatalog.sqlViewName: 'IMATDESC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel:{
              usageType.serviceQuality: #A,
              usageType.sizeCategory: #L,
              usageType.dataClass: #TRANSACTIONAL
                }
@EndUserText.label: 'Material Description'
define view I_MaterialDescription 
  as select from    mara
    left outer join makt on  makt.matnr = mara.matnr
                         and makt.spras = $session.system_language
{
  key mara.matnr        as Material,
      makt.maktx        as MaterialDescription
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MAKT",
"MARA"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More