SHSM_M_MEBZX

DDL: SHSM_M_MEBZX SQL: SHSMMMEBZX Type: view Package: ME

CDS View replacing M_MEBZX in search help

SHSM_M_MEBZX is a CDS View that provides data about "CDS View replacing M_MEBZX in search help" in SAP S/4HANA. It reads from 1 data source (m_mebzx) and exposes 17 fields. Part of development package ME.

Data Sources (1)

SourceAliasJoin Type
m_mebzx m_mebzx from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName SHSMMMEBZX view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #REQUIRED 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

Fields (17)

KeyFieldSource TableSource FieldDescription
lifnr lifnr Vendor no.
xblnr xblnr Reference
ebeln ebeln Source PurchDoc
ebelp ebelp Item pur. doc.
stunr stunr Step Number
zaehk zaehk Counter
vgabe vgabe Transact. Type
gjahr gjahr Settlement Year
belnr belnr SD Document
buzei buzei Posting View Item
iseopblocked iseopblocked Business Usage Comp.
bsart bsart Stnd purch.ord.
ekorg ekorg Purchasing Org.
ekgrp ekgrp Sub. purchasing grp
werks werks Receiving Plant
statu statu Vehicle Status
bstyp bstyp Source doc.cat.

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_MEBZX.
-- 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: SHSMMMEBZX

CREATE VIEW SHSM_M_MEBZX AS
SELECT
  lifnr,
  xblnr,
  ebeln,
  ebelp,
  stunr,
  zaehk,
  vgabe,
  gjahr,
  belnr,
  buzei,
  iseopblocked,
  bsart,
  ekorg,
  ekgrp,
  werks,
  statu,
  bstyp
FROM m_mebzx
;