SHSM_M_MBANK

DDL: SHSM_M_MBANK SQL: SHSMMMBANK Type: view
10 Fields 2 Data Sources

Purchase Requisitions per Cost Center

SHSM_M_MBANK is a CDS View that provides data about "Purchase Requisitions per Cost Center" in SAP S/4HANA. It reads from 2 data sources (eban, ebkn) and exposes 10 fields with key fields kostl, kokrs, banfn, bnfpo, zebkn.

Data Sources (2)

SourceAliasJoin Type
eban eban from
ebkn ebkn inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMBANK 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 per Cost Center view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY kostl ebkn kostl Substitute CC
KEY kokrs ebkn kokrs Org. Value
KEY banfn eban banfn Requisition
KEY bnfpo eban bnfpo Requisn. item
KEY zebkn ebkn zebkn Ser.no.acc.ass.
iseopblocked eban iseopblocked Business Usage Comp.
werks eban werks Receiving Plant
ekorg eban ekorg Purchasing Org.
ekgrp eban ekgrp Sub. purchasing grp
bsart eban bsart Stnd purch.ord.

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view SHSM_M_MBANK.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.
-- SQL view name: SHSMMMBANK

CREATE VIEW SHSM_M_MBANK AS
SELECT
  ebkn.kostl AS kostl,
  ebkn.kokrs AS kokrs,
  eban.banfn AS banfn,
  eban.bnfpo AS bnfpo,
  ebkn.zebkn AS zebkn,
  eban.iseopblocked AS iseopblocked,
  eban.werks AS werks,
  eban.ekorg AS ekorg,
  eban.ekgrp AS ekgrp,
  eban.bsart AS bsart
FROM eban
INNER JOIN ebkn ON /* join condition not captured in parsed metadata */
;

Learn More