I_MATERIALTEXT

CDS View

Material Text

I_MATERIALTEXT is a CDS View in S/4HANA. Material Text. It contains 3 fields. 21 CDS views read from this table.

Used by 21 CDS view(s) 3 fields

CDS Views using this table (21)

ViewTypeJoinVDMDescription
C_PH_InventoryQuery view inner CONSUMPTION Ph Inventory Query Philippines
C_SupDmndOpenDelivQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndOvwDmndItmQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndOvwSupAssgmtQuery view left_outer CONSUMPTION Consumption view for Assignments
C_SupDmndOvwTotDmndQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndOvwTotSupQuery view left_outer CONSUMPTION Query View for Total Supply
C_SupDmndTotSlsOrdQuery view left_outer CONSUMPTION Query View for Total Demand
C_SupDmndTotSTOQuery view left_outer CONSUMPTION Query View for Total Demand
I_ACMApplicationOverview view left_outer TRANSACTIONAL Interface Layer for ACM Application Overview
I_ACMMaterialValueText view from COMPOSITE Interface for Material Description
I_ACMPrcgMaterialValueHelp view from COMPOSITE
I_MatlsValueHelp view from COMPOSITE
I_SettlementUnitLienHldrData view left_outer BASIC Interface layer for Unit Lien Data
I_SupDmndOvwAssgmtCube view left_outer COMPOSITE Supply Demand Overview Cube View(MDR)
I_SupDmndOvwCube view left_outer COMPOSITE Supply Demand Overview Cube View
P_CnsldtnMaterialT view from BASIC
P_HU_MMInvoiceConsignment view inner COMPOSITE
P_material_value_help view from COMPOSITE
P_Product_Fs view left_outer BASIC
P_Salesview_Fs view left_outer COMPOSITE
R_EvtBsdPostingRuleRcvrName view from COMPOSITE EB Posting Rule Receiver Name

Fields (3)

KeyField CDS FieldsUsed in Views
KEY Language Language 2
KEY Material Material 1
MaterialName MaterialDescription,MaterialName,ProductName 13 
@AbapCatalog:{
  sqlViewName: 'IMATERIALTEXT',
  preserveKey: true,
  compiler.compareFilter: true
  }
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Material Text'
@ObjectModel.representativeKey: 'Material'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@Search.searchable: true

define view I_MaterialText

  as select from makt
  association [1..1] to I_Material as _Material on $projection.Material = _Material.Material
{
  key makt.matnr as Material,
      @Semantics.language: true
  key makt.spras as Language,
      @Semantics.text: true
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @Search.ranking: #LOW
      makt.maktx as MaterialName,
      _Material
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MAKT"
],
"ASSOCIATED":
[
"I_MATERIAL"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More