I_MATERIALTEXT

CDS View

Material Text

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

Used by 15 CDS view(s) 3 fields

CDS Views using this table (15)

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_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 COMPOSITE Consolidation Combined Material Text
P_HU_MMInvoiceConsignment view inner COMPOSITE HU Audit Report: MM invoices for Consignment Process
P_Product_Fs view left_outer BASIC Private Factsheet - Product
P_Salesview_Fs view left_outer COMPOSITE Private Factsheet - Sales View
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 11 
@AbapCatalog:{
  sqlViewName: 'IMATERIALTEXT',
  preserveKey: true,
  compiler.compareFilter: true
  }
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #MANDATORY
@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
}

Learn More