Which tables does SHSM_WRF_SALES_MAT_CHAR use?

SHSM_WRF_SALES_MAT_CHAR reads from 1 data source(s): vbak.

How many fields does SHSM_WRF_SALES_MAT_CHAR have?

SHSM_WRF_SALES_MAT_CHAR has 9 fields. Key fields: vbeln.

SHSM_WRF_SALES_MAT_CHAR

DDL: SHSM_WRF_SALES_MAT_CHAR SQL: SHSMSALESMATCHAR Type: view

CDS replacing VBAP in WRF_SALES_MAT_CHAR

SHSM_WRF_SALES_MAT_CHAR is a CDS View that provides data about "CDS replacing VBAP in WRF_SALES_MAT_CHAR" in SAP S/4HANA. It reads from 1 data source (vbak) and exposes 9 fields with key field vbeln.

Data Sources (1)

Source	Alias	Join Type
vbak	vbak	from

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	SHSMSALESMATCHAR	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#CHECK	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
ObjectModel.usageType.serviceQuality	#B	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.representativeKey	vbeln	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.dataCategory	#VALUE_HELP	view
Metadata.ignorePropagatedAnnotations	true	view
EndUserText.label	CDS replacing VBAP in WRF_SALES_MAT_CHAR	view

Fields (9)

Key	Field	Source Table	Source Field
KEY	vbeln	vbap	vbeln
	matnr	vbap	matnr
	wrf_charstc1	vbap	wrf_charstc1
	wrf_charstc2	vbap	wrf_charstc2
	wrf_charstc3	vbap	wrf_charstc3
	vkorg	vbak	vkorg
	vtweg	vbak	vtweg
	spart	vbak	spart
	auart	vbak	auart

@AbapCatalog.sqlViewName: 'SHSMSALESMATCHAR'
@AbapCatalog.compiler.compareFilter: true

@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking
@ClientHandling.algorithm : #SESSION_VARIABLE

@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.representativeKey: 'vbeln'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.dataCategory: #VALUE_HELP

@Metadata.ignorePropagatedAnnotations: true

@EndUserText.label: 'CDS replacing VBAP in WRF_SALES_MAT_CHAR'

define view SHSM_WRF_SALES_MAT_CHAR as select from vbak as vbak
     join vbap as vbap on 
         vbak.vbeln = vbap.vbeln  
{      
   key  vbap.vbeln,
        vbap.matnr,
        vbap.wrf_charstc1,
        vbap.wrf_charstc2,
        vbap.wrf_charstc3,
@Consumption.hidden: true
        vbak.vkorg, 
@Consumption.hidden: true
        vbak.vtweg,
@Consumption.hidden: true
        vbak.spart, 
@Consumption.hidden: true          
        vbak.auart
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"VBAK",
"VBAP"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

SHSM_WRF_SALES_MAT_CHAR view

vbak