SHSM_EINA

DDL: SHSM_EINA SQL: SHSMEINA Type: view

SHSM_EINA is a CDS View in SAP S/4HANA. It reads from 1 data source (eina) and exposes 4 fields with key field infnr. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
eina eina from

Associations (1)

CardinalityTargetAliasCondition
[1..*] eine _eine $projection.INFNR = _eine.infnr

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHSMEINA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY infnr eina infnr
ekorg _eine ekorg
werks _eine werks
ekgrp _eine ekgrp
@AbapCatalog.sqlViewName: 'SHSMEINA'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true

define view SHSM_EINA as select from eina 
 association [1..*] to eine as _eine on $projection.INFNR = _eine.infnr 
 {
  key eina.infnr,

  @Consumption.hidden:true
  _eine.ekorg,
  @Consumption.hidden:true
  _eine.werks,
  @Consumption.hidden:true
  _eine.ekgrp
  
  
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EINA",
"EINE"
],
"ASSOCIATED":
[
"EINE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/