NSDM_E_MSFS

DDL: NSDM_DDL_MSFS SQL: NSDM_V_MSFS Type: view Package: MBND_PUBLIC
13 Fields 1 Data Sources

MSFS Compatibility View

NSDM_E_MSFS is a CDS View that provides data about "MSFS Compatibility View" in SAP S/4HANA. It reads from 1 data source (msfs_md) and exposes 13 fields with key fields mandt, matnr, werks, sobkz, lifnr. Part of development package MBND_PUBLIC.

Data Sources (1)

SourceAliasJoin Type
msfs_md m from

Annotations (10)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.sqlViewName NSDM_V_MSFS view
AbapCatalog.compiler.compareFilter true view
EndUserText.label MSFS Compatibility View 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 (13)

KeyFieldSource TableSource FieldDescription
KEY mandt msfs_md mandt Editing Client
KEY matnr msfs_md matnr Vehicle Model
KEY werks msfs_md werks Receiving Plant
KEY sobkz msfs_md sobkz Special Stock
KEY lifnr msfs_md lifnr Vendor no.
KEY vbeln msfs_md vbeln SD Sched. Agmt
KEY posnr msfs_md posnr WBS Element
fslab
fsins
fsein
ersda msfs_md ersda Entry Date
xobew msfs_md xobew Vendor stk val.
fsrue

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

CREATE VIEW NSDM_E_MSFS AS
SELECT
  m.mandt AS mandt,
  m.matnr AS matnr,
  m.werks AS werks,
  m.sobkz AS sobkz,
  m.lifnr AS lifnr,
  m.vbeln AS vbeln,
  m.posnr AS posnr,
  case when t.fslab is null then 0 else t.fslab end AS fslab,
  case when t.fsins is null then 0 else t.fsins end AS fsins,
  case when t.fsein is null then 0 else t.fsein end AS fsein,
  m.ersda AS ersda,
  m.xobew AS xobew,
  'X' AS fsrue
FROM msfs_md AS m
;

Learn More