nsdm_e_mchb

DDL: NSDM_DDL_MCHB SQL: NSDM_V_MCHB Type: view Package: MBND_PUBLIC
50 Fields 1 Data Sources

MCHB Compatibility View

nsdm_e_mchb is a CDS View that provides data about "MCHB Compatibility View" in SAP S/4HANA. It reads from 1 data source (mchb) and exposes 50 fields with key fields mandt, matnr, werks, lgort, charg. Part of development package MBND_PUBLIC.

Data Sources (1)

SourceAliasJoin Type
mchb t from

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName NSDM_V_MCHB view
EndUserText.label MCHB Compatibility View view
DataAging.noAgingRestriction false view
ObjectModel.usageType.sizeCategory L view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ClientHandling.algorithm #AUTOMATED view
AccessControl.authorizationCheck #NOT_ALLOWED view
AbapCatalog.viewEnhancementCategory #PROJECTION_LIST view

Fields (50)

KeyFieldSource TableSource FieldDescription
KEY mandt mchb mandt Editing Client
KEY matnr mchb matnr Vehicle Model
KEY werks mchb werks Receiving Plant
KEY lgort mchb lgort Sublocation
KEY charg mchb charg Chargeable Proc.
lvorm mchb lvorm Stock del. flag
ersda mchb ersda Entry Date
ernam mchb ernam User Name
laeda mchb laeda Last Change
aenam mchb aenam User Name
sperc mchb sperc Phys. Inv. Blk
clabs
cumlm
cinsm
ceinm
cspem
cretm
cvmla
cvmum
cvmin
cvmei
cvmsp
cvmre
kzicl mchb kzicl Warehouse stock
kzicq mchb kzicq QualInspStock
kzice mchb kzice Restricted-use
kzics mchb kzics Blocked stock
kzvcl mchb kzvcl Warehouse stock
kzvcq mchb kzvcq QualInspStock
kzvce mchb kzvce Restricted use
kzvcs mchb kzvcs Blocked stock
herkl mchb herkl C/R of Origin
chdll mchb chdll Last Count Date
chjin mchb chjin Fiscal year of current physical inventory indicator
chrue
sgt_scat mchb sgt_scat Stock Segment
fsh_season
fsh_theme
/cwm/clabs
/cwm/cinsm
/cwm/ceinm
/cwm/cspem
/cwm/cretm
/cwm/cumlm
/cwm/cvmla
/cwm/cvmin
/cwm/cvmei
/cwm/cvmsp
/cwm/cvmre
/cwm/cvmum

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 nsdm_e_mchb.
-- 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: NSDM_V_MCHB

CREATE VIEW nsdm_e_mchb AS
SELECT
  t.mandt AS mandt,
  t.matnr AS matnr,
  t.werks AS werks,
  t.lgort AS lgort,
  t.charg AS charg,
  t.lvorm AS lvorm,
  t.ersda AS ersda,
  t.ernam AS ernam,
  t.laeda AS laeda,
  t.aenam AS aenam,
  t.sperc AS sperc,
  case when m.clabs is null then 0 else m.clabs end AS clabs,
  case when m.cumlm is null then 0 else m.cumlm end AS cumlm,
  case when m.cinsm is null then 0 else m.cinsm end AS cinsm,
  case when m.ceinm is null then 0 else m.ceinm end AS ceinm,
  case when m.cspem is null then 0 else m.cspem end AS cspem,
  case when m.cretm is null then 0 else m.cretm end AS cretm,
  case when m.cvmla is null then 0 else m.cvmla end AS cvmla,
  case when m.cvmum is null then 0 else m.cvmum end AS cvmum,
  case when m.cvmin is null then 0 else m.cvmin end AS cvmin,
  case when m.cvmei is null then 0 else m.cvmei end AS cvmei,
  case when m.cvmsp is null then 0 else m.cvmsp end AS cvmsp,
  case when m.cvmre is null then 0 else m.cvmre end AS cvmre,
  t.kzicl AS kzicl,
  t.kzicq AS kzicq,
  t.kzice AS kzice,
  t.kzics AS kzics,
  t.kzvcl AS kzvcl,
  t.kzvcq AS kzvcq,
  t.kzvce AS kzvce,
  t.kzvcs AS kzvcs,
  t.herkl AS herkl,
  t.chdll AS chdll,
  t.chjin AS chjin,
  'X' AS chrue,
  t.sgt_scat AS sgt_scat,
  ' ' AS fsh_season,
  ' ' AS fsh_theme,
  case when m./cwm/clabs is null then 0 else m./cwm/clabs end AS /cwm/clabs,
  case when m./cwm/cinsm is null then 0 else m./cwm/cinsm end AS /cwm/cinsm,
  case when m./cwm/ceinm is null then 0 else m./cwm/ceinm end AS /cwm/ceinm,
  case when m./cwm/cspem is null then 0 else m./cwm/cspem end AS /cwm/cspem,
  case when m./cwm/cretm is null then 0 else m./cwm/cretm end AS /cwm/cretm,
  case when m./cwm/cumlm is null then 0 else m./cwm/cumlm end AS /cwm/cumlm,
  case when m./cwm/cvmla is null then 0 else m./cwm/cvmla end AS /cwm/cvmla,
  case when m./cwm/cvmin is null then 0 else m./cwm/cvmin end AS /cwm/cvmin,
  case when m./cwm/cvmei is null then 0 else m./cwm/cvmei end AS /cwm/cvmei,
  case when m./cwm/cvmsp is null then 0 else m./cwm/cvmsp end AS /cwm/cvmsp,
  case when m./cwm/cvmre is null then 0 else m./cwm/cvmre end AS /cwm/cvmre,
  case when m./cwm/cvmum is null then 0 else m./cwm/cvmum end AS /cwm/cvmum
FROM mchb AS t
;

Learn More