I_CustomerMaterialValueHelp

DDL: I_CUSTOMERMATERIALVALUEHELP SQL: ICUSTMATVH Type: view BASIC Package: ODATA_SD_CUSTOMER_MATERIAL

Customer Material Value Help

I_CustomerMaterialValueHelp is a Basic CDS View that provides data about "Customer Material Value Help" in SAP S/4HANA. It reads from 1 data source (knmt) and exposes 8 fields with key fields MaterialByCustomer, Customer, Material, Product, SalesOrganization. It has 1 association to related views. Part of development package ODATA_SD_CUSTOMER_MATERIAL.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
knmt knmt from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Customer _Customer $projection.Customer = _Customer.Customer

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName ICUSTMATVH view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED view
EndUserText.label Customer Material Value Help view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
Search.searchable true view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY MaterialByCustomer kdmat
KEY Customer kunnr
KEY Material matnr
KEY Product
KEY SalesOrganization vkorg
KEY DistributionChannel vtweg
KEY MaterialDescriptionByCustomer postx Customer Material Description
_Customer _Customer 
@AbapCatalog.sqlViewName: 'ICUSTMATVH'
@AbapCatalog.compiler.compareFilter: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #REQUIRED
@EndUserText.label: 'Customer Material Value Help'


@VDM: {
  viewType: #BASIC
}

@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M

@Search.searchable: true

define view I_CustomerMaterialValueHelp
  as select from knmt
  association [0..1] to I_Customer as _Customer on $projection.Customer = _Customer.Customer

{
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
  key kdmat as MaterialByCustomer,
  key kunnr as Customer,
      @VDM.lifecycle.status: #DEPRECATED
      @VDM.lifecycle.successor: 'Product'
  key matnr as Material,
  key cast (matnr as productnumber preserving type) as Product,
  key vkorg as SalesOrganization,
  key vtweg as DistributionChannel,
      @Search.defaultSearchElement: true
      @Search.fuzzinessThreshold: 0.8
      @EndUserText.label: 'Customer Material Description'
  key postx as MaterialDescriptionByCustomer,

      //Associations

      _Customer

      //Data Privacy - Auth. Group

      //  _Customer.AuthorizationGroup as AuthorizationGroup


}

where
  kdmat != ''

Learn More