SHSM_M_MBANN

DDL: SHSM_M_MBANN SQL: SHSMMMBANN Type: view

Purchase Requisitions per Network

SHSM_M_MBANN is a CDS View that provides data about "Purchase Requisitions per Network" in SAP S/4HANA. It reads from 2 data sources (eban, ebkn) and exposes 11 fields with key fields nplnr, aufpl, aplzl, banfn, bnfpo.

2 data source(s) 11 fields

Data Sources (2)

SourceAliasJoin Type
eban eban from
ebkn ebkn inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMBANN 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 #B view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Purchase Requisitions per Network view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY nplnr ebkn nplnr
KEY aufpl ebkn aufpl
KEY aplzl ebkn aplzl
KEY banfn eban banfn
KEY bnfpo eban bnfpo
KEY zebkn ebkn zebkn
iseopblocked eban iseopblocked
werks eban werks
ekorg eban ekorg
ekgrp eban ekgrp
bsart eban bsart 
@AbapCatalog.sqlViewName: 'SHSMMMBANN'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #BLOCKED_DATA_EXCLUDED
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:#B
@ObjectModel.usageType.sizeCategory:#L
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Purchase Requisitions per Network'
define view SHSM_M_MBANN 
as select from eban inner join ebkn on eban.banfn = ebkn.banfn and
                                       eban.bnfpo = ebkn.bnfpo 
 {
    key ebkn.nplnr,
    key ebkn.aufpl,
    key ebkn.aplzl,
    key eban.banfn,
    key eban.bnfpo,
    key ebkn.zebkn,
        eban.iseopblocked,
        @Consumption.hidden: true
        eban.werks,
        @Consumption.hidden: true
        eban.ekorg,
        @Consumption.hidden: true
        eban.ekgrp,
        @Consumption.hidden: true
        eban.bsart           
}where
( iseopblocked = '' or iseopblocked is null )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EBAN",
"EBKN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More