SHSM_KNMT_REF

DDL: SHSM_KNMT_REF Type: view

CDS View replacing KNMT_REF

SHSM_KNMT_REF is a CDS View that provides data about "CDS View replacing KNMT_REF" in SAP S/4HANA. It reads from 3 data sources (knmt, knmt, knmta) and exposes 13 fields with key fields kunnr, vkorg, kdmat, matnr, vtweg. It has 1 association to related views.

3 data source(s) 13 fields

Data Sources (3)

SourceAliasJoin Type
knmt knmt from
knmt knmt union
knmta knmta inner

Associations (1)

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

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName SHSMKNMTREF view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey kunnr view
EndUserText.label CDS View replacing KNMT_REF view

Fields (13)

KeyFieldSource TableSource FieldDescription
KEY kunnr kunnr
KEY vkorg vkorg
KEY kdmat kdmat
KEY matnr matnr
KEY vtweg vtweg
kdptx postx
kunnr
KEY vkorg knmt vkorg
KEY kdmat knmta kdmat
KEY matnr knmt matnr
KEY vtweg knmt vtweg
kdptx knmta addpostx
_Customer _Customer 
@AbapCatalog: {
  sqlViewName: 'SHSMKNMTREF',
  compiler.compareFilter: true,
  preserveKey: true
}
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking:  #('TRANSACTIONAL_DATA')
@ClientHandling.algorithm : #SESSION_VARIABLE 
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.representativeKey: 'kunnr'

@EndUserText.label: 'CDS View replacing KNMT_REF'

define view SHSM_KNMT_REF as select from knmt

    association [0..1] to I_Customer                   as _Customer                      on  $projection.kunnr = _Customer.Customer
{
  
  key kunnr,
  key vkorg,
  key kdmat,
  key matnr,
  key vtweg,
      postx as kdptx,
      
  _Customer
  
}

  union select from knmt inner join knmta on knmta.guid = knmt.guid
  
    association [0..1] to I_Customer                   as _Customer                      on  $projection.kunnr = _Customer.Customer  
{

  key knmt.kunnr,
  key knmt.vkorg,
  key knmta.kdmat,
  key knmt.matnr,
  key knmt.vtweg,
      knmta.addpostx as kdptx,
  
  _Customer
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"KNMT",
"KNMTA"
],
"ASSOCIATED":
[
"I_CUSTOMER"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More