I_MaterialText

DDL: I_MATERIALTEXT Type: view BASIC

Material Text

I_MaterialText is a Basic CDS View that provides data about "Material Text" in SAP S/4HANA. It reads from 1 data source (makt) and exposes 4 fields with key fields Material, Language. It has 1 association to related views. It is exposed through 4 OData services (BOMEXPLOSION, UI_PPS_PURCHASE_CONTRACT, UI_PURCONTRRENEGTTN_MANAGE, ...). It is used in 2 Fiori applications: Manage Purchase Orders - Fashion, Manage Renegotiations.

1 data source(s) Exposed by 4 service(s) Used in 2 Fiori app(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
makt makt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Material _Material $projection.Material = _Material.Material

Annotations (14)

NameValueLevelField
AbapCatalog.sqlViewName IMATERIALTEXT view
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Material Text view
ObjectModel.representativeKey Material view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
Search.searchable true view

OData Services (4)

ServiceBindingVersionContractRelease
BOMEXPLOSION BOM_EXPLOSION_V2 V2 C1 NOT_RELEASED
UI_PPS_PURCHASE_CONTRACT UI_PPS_PURCHASE_CONTRACT_2 V2 C1 NOT_RELEASED
UI_PURCONTRRENEGTTN_MANAGE UI_PURCONTRRENEGTTN_MANAGE V2 C1 NOT_RELEASED
UI_RFM_PO_MNG UI_RFM_PO_MNG V2 C1 NOT_RELEASED

Fiori Apps (2)

App IDApp NameTypeDescription
F5391 Manage Purchase Orders - Fashion Transactional
F5714 Manage Renegotiations Transactional An application to create and manage renegotiations of central purchase contracts

Manage Purchase Orders - Fashion

Business Role: Purchaser (Retail)

With this app, you can now consolidate purchase order items into an existing purchase order based on the settings in the rule maintained using the Configure Purchase Order Consolidation Rule app.

Manage Renegotiations

Business Role: Purchaser

With this app, you can initiate renegotiations on the prices for items in existing central purchase contracts. You can revisit prevalent central purchase contracts for chosen items and renegotiate the pricing conditions, to gain value from changed market conditions. The following new business add-in (BAdI) is available with this app:Change of Purchase Contract Renegotiation Item Pricing

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY Material makt matnr
KEY Language makt spras
MaterialName makt maktx
_Material _Material 
@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
}

Learn More