I_MATERIALDESCRIPTION

CDS View

Material Description

I_MATERIALDESCRIPTION is a CDS View in S/4HANA. Material Description. It contains 1 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 1 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_PhysInvtryGaugeRdng view left_outer COMPOSITE Physical Inventory gauge reading
I_TankVisualization view left_outer COMPOSITE Tank Visualization Details
I_VisualSimulation view left_outer COMPOSITE IPW Simulation in Visualization

Fields (1)

KeyField CDS FieldsUsed in Views
MaterialDescription DischargeDemandMaterialDesc,LoadDemandMaterialDesc,MaterialDesc,MaterialDescription 3 
@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