ESH_N_MATSLNS

DDL: ESH_N_MATSLNS SQL: ESH_L_MATSLNS Type: view

ESH_N_MATSLNS is a CDS View in SAP S/4HANA. It reads from 1 data source (I_EQUIPMENT) and exposes 6 fields with key fields EQUIPMENT, MATERIAL, SERIALNUMBER.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
I_EQUIPMENT I_EQUIPMENT from

Parameters (1)

NameTypeDefault
P_Language abap.lang

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view
AccessControl.personalData.blocking #REQUIRED view
AbapCatalog.sqlViewName ESH_L_MATSLNS view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY EQUIPMENT EQUIPMENT
KEY MATERIAL MATERIAL
KEY SERIALNUMBER SERIALNUMBER
EQUIPMENTNAME
MATERIALNAME
PLANTNAME _PLANT PLANTNAME 
@AccessControl.authorizationCheck: #MANDATORY
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
@AbapCatalog.sqlViewName: 'ESH_L_MATSLNS'
define view ESH_N_MATSLNS
 with parameters
 @Consumption.hidden: true
 @Environment.systemField: #SYSTEM_LANGUAGE
 P_Language: abap.lang
as select from I_EQUIPMENT {

key EQUIPMENT,

key MATERIAL,

key SERIALNUMBER,

_EQUIPMENTTEXT[1: LANGUAGE = $parameters. P_Language].EQUIPMENTNAME,

_MATERIAL._TEXT[1: LANGUAGE = $parameters. P_Language].MATERIALNAME,

_PLANT.PLANTNAME
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_EQUIPMENT",
"I_EQUIPMENTTEXT",
"I_MATERIAL",
"I_MATERIALTEXT",
"I_PLANT"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More