SHSM_M_MBANC

DDL: SHSM_M_MBANC SQL: SHSMMMBANC Type: view

Purchase Requn for Procuring Plant

SHSM_M_MBANC is a CDS View that provides data about "Purchase Requn for Procuring Plant" in SAP S/4HANA. It reads from 1 data source (eban) and exposes 10 fields with key fields ekgrp, werks, reswk, beswk, banpr.

1 data source(s) 10 fields

Data Sources (1)

SourceAliasJoin Type
eban eban from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMBANC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view
EndUserText.label Purchase Requn for Procuring Plant view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY ekgrp ekgrp
KEY werks werks
KEY reswk reswk
KEY beswk beswk
KEY banpr banpr
KEY banfn banfn
KEY bnfpo bnfpo
iseopblocked iseopblocked
ekorg ekorg
bsart bsart 
@AbapCatalog.sqlViewName: 'SHSMMMBANC'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking
@ClientHandling.algorithm : #SESSION_VARIABLE
@ObjectModel.usageType.serviceQuality:#C
@ObjectModel.usageType.sizeCategory:#L
@ObjectModel.usageType.dataClass:#MIXED
@ObjectModel.dataCategory: #VALUE_HELP
@Metadata.ignorePropagatedAnnotations: true
@EndUserText.label: 'Purchase Requn for Procuring Plant'
define view SHSM_M_MBANC 
  as select from eban 
  {   
    key ekgrp,
    key werks,
    key reswk,
    key beswk,
    key banpr,
    key banfn,
    key bnfpo,
        iseopblocked,
        @Consumption.hidden: true
        ekorg,
        @Consumption.hidden: true
        bsart
  
}
where beswk != '' and
      ( iseopblocked = '' or iseopblocked is null )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"EBAN"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More