NSDM_E_V_MMIM_VW

DDL: NSDM_DDL_V_MMIM_VW SQL: NSDM_V_V_MMIM_VW Type: view Package: MBND_PUBLIC

V_MMIM_VW Compatibility View

NSDM_E_V_MMIM_VW is a CDS View that provides data about "V_MMIM_VW Compatibility View" in SAP S/4HANA. It reads from 3 data sources (mara, nsdm_e_msku, nsdm_e_marc) and exposes 19 fields with key fields mandt, matnr, werks, charg, sobkz. Part of development package MBND_PUBLIC.

Data Sources (3)

SourceAliasJoin Type
mara a from
nsdm_e_msku b inner
nsdm_e_marc c inner

Annotations (12)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName NSDM_V_V_MMIM_VW view
EndUserText.label V_MMIM_VW 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
AccessControl.personalData.blocking #NOT_REQUIRED view
AbapCatalog.viewEnhancementCategory #PROJECTION_LIST view

Fields (19)

KeyFieldSource TableSource FieldDescription
KEY mandt nsdm_e_msku mandt Editing Client
KEY matnr nsdm_e_msku matnr Vehicle Model
KEY werks nsdm_e_msku werks Receiving Plant
KEY charg nsdm_e_msku charg Chargeable Proc.
KEY sobkz nsdm_e_msku sobkz Special Stock
KEY kunnr nsdm_e_msku kunnr Stock customer
lfgja nsdm_e_msku lfgja Year Cur.Period
lfmon nsdm_e_msku lfmon Current Period
KZILL nsdm_e_msku kuill Warehouse stock
KZILQ nsdm_e_msku kuilq QualInspStock
KZVLL nsdm_e_msku kuvll Warehouse stock
KZVLQ nsdm_e_msku kuvlq QualInspStock
mtart mara mtart Product Type
matkl mara matkl Product Sold Group
abcin nsdm_e_marc abcin CC Phys. Inv.
lvorm nsdm_e_marc lvorm Stock del. flag
LABST nsdm_e_msku kulab Unrestricted
INSME nsdm_e_msku kuins Quality Insp.
EINME nsdm_e_msku kuein Restricted-Use

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_V_MMIM_VW.
-- 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_V_MMIM_VW

CREATE VIEW NSDM_E_V_MMIM_VW AS
SELECT
  b.mandt AS mandt,
  b.matnr AS matnr,
  b.werks AS werks,
  b.charg AS charg,
  b.sobkz AS sobkz,
  b.kunnr AS kunnr,
  b.lfgja AS lfgja,
  b.lfmon AS lfmon,
  b.kuill AS KZILL,
  b.kuilq AS KZILQ,
  b.kuvll AS KZVLL,
  b.kuvlq AS KZVLQ,
  a.mtart AS mtart,
  a.matkl AS matkl,
  c.abcin AS abcin,
  c.lvorm AS lvorm,
  b.kulab AS LABST,
  b.kuins AS INSME,
  b.kuein AS EINME
FROM mara AS a
INNER JOIN nsdm_e_msku AS b ON /* join condition not captured in parsed metadata */
INNER JOIN nsdm_e_marc AS c ON /* join condition not captured in parsed metadata */
;