SHSM_M_MBANV

DDL: SHSM_M_MBANV SQL: SHSMMMBANV Type: view Package: ME
11 Fields 2 Data Sources

Purchase Requisitions per Sales Document

SHSM_M_MBANV is a CDS View that provides data about "Purchase Requisitions per Sales Document" in SAP S/4HANA. It reads from 2 data sources (eban, ebkn) and exposes 11 fields with key fields vbeln, vbelp, veten, banfn, bnfpo. Part of development package ME.

Data Sources (2)

SourceAliasJoin Type
eban eban from
ebkn ebkn inner

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMBANV 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 Sales Document view

Fields (11)

KeyFieldSource TableSource FieldDescription
KEY vbeln ebkn vbeln SD Sched. Agmt
KEY vbelp ebkn vbelp Schd. Agmt Item
KEY veten ebkn veten Schedule Line
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_MBANV.
-- 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: SHSMMMBANV

CREATE VIEW SHSM_M_MBANV AS
SELECT
  ebkn.vbeln AS vbeln,
  ebkn.vbelp AS vbelp,
  ebkn.veten AS veten,
  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