SHSM_M_MBANA

DDL: SHSM_M_MBANA SQL: SHSMMMBANA Type: view Package: ME
10 Fields 2 Data Sources

DDL for Search Help MBANA

SHSM_M_MBANA is a CDS View that provides data about "DDL for Search Help MBANA" in SAP S/4HANA. It reads from 2 data sources (eban, ebkn) and exposes 10 fields with key fields anln1, anln2, banfn, bnfpo, zebkn. Part of development package ME.

Data Sources (2)

SourceAliasJoin Type
eban eban from
ebkn ebkn inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMBANA view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label DDL for Search Help MBANA 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 #MASTER view
ObjectModel.dataCategory #VALUE_HELP view
Metadata.ignorePropagatedAnnotations true view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY anln1 ebkn anln1 Asset
KEY anln2 ebkn anln2 Sub-number
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_MBANA.
-- 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: SHSMMMBANA

CREATE VIEW SHSM_M_MBANA AS
SELECT
  ebkn.anln1 AS anln1,
  ebkn.anln2 AS anln2,
  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