SHSM_H_MVKE

DDL: SHSM_H_MVKE SQL: SHSMHMVKE Type: view

CDS View for H_MVKE (search help)

SHSM_H_MVKE is a CDS View that provides data about "CDS View for H_MVKE (search help)" in SAP S/4HANA. It reads from 5 data sources (mvke, tvko, tvkot, tvtw, tvtwt) and exposes 6 fields with key fields matnr, vkorg, vtweg. It has 1 association to related views.

5 data source(s) 6 fields

Data Sources (5)

SourceAliasJoin Type
mvke mv from
tvko tv left_outer
tvkot tvk left_outer
tvtw tw left_outer
tvtwt twt left_outer

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_Product _Product $projection.matnr = _Product.Product

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName SHSMHMVKE view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.dataCategory #VALUE_HELP view
ObjectModel.representativeKey matnr view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
EndUserText.label CDS View for H_MVKE (search help) view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY matnr
KEY vkorg
KEY vtweg
vtext
vtext_vtw
_Product _Product 
@AbapCatalog.sqlViewName: 'SHSMHMVKE'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'matnr'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@EndUserText.label: 'CDS View for H_MVKE (search help)'
define view SHSM_H_MVKE
  as select from    mvke  as mv
    left outer join tvko  as tv  on mv.vkorg = tv.vkorg
    left outer join tvtw  as tw  on mv.vtweg = tw.vtweg
    left outer join tvkot as tvk on tv.vkorg = tvk.vkorg
    left outer join tvtwt as twt on  tw.vtweg  = twt.vtweg
                                 and tvk.spras = $session.system_language
                                 and twt.spras = $session.system_language
  association [1..1] to I_Product as _Product on $projection.matnr = _Product.Product

{
  key cast( mv.matnr as matnr preserving type )  as matnr,
  key cast( mv.vkorg as vkorg preserving type )  as vkorg,
  key cast( mv.vtweg as vtweg preserving type )  as vtweg,
      cast( tvk.vtext as vtext preserving type ) as vtext,
      cast( twt.vtext as vtext preserving type ) as vtext_vtw,
      _Product
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MVKE",
"TVKO",
"TVKOT",
"TVTW",
"TVTWT"
],
"ASSOCIATED":
[
"I_PRODUCT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More