SHSM_M_MBAND

DDL: SHSM_M_MBAND SQL: SHSMMMBAND Type: view

Purchase Requisitions with Services

SHSM_M_MBAND is a CDS View that provides data about "Purchase Requisitions with Services" in SAP S/4HANA. It reads from 1 data source (eban) and exposes 8 fields with key fields ekgrp, werks, matkl, banfn, txz01.

1 data source(s) 8 fields

Data Sources (1)

SourceAliasJoin Type
eban eban from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMBAND view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Purchase Requisitions with Services view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY ekgrp ekgrp
KEY werks werks
KEY matkl matkl
KEY banfn banfn
KEY txz01 txz01
iseopblocked iseopblocked
ekorg ekorg
bsart bsart 
@AbapCatalog.sqlViewName: 'SHSMMMBAND'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:#A
@ObjectModel.usageType.sizeCategory:#L
@ObjectModel.usageType.dataClass:#TRANSACTIONAL
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Purchase Requisitions with Services'
define view SHSM_M_MBAND
  as select from eban
  {
    key ekgrp,
    key werks,
    key matkl,
    key banfn,
    key txz01,
        iseopblocked,
        @Consumption.hidden: true
        ekorg,
        @Consumption.hidden: true
        bsart
} where packno > '0000000000' and
        ( iseopblocked = '' or iseopblocked is null )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EBAN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More