NSDM_E_U_15121

DDL: NSDM_DDL_U_15121 SQL: NSDM_V_U_15121 Type: view

U_15121 Compatibility View

NSDM_E_U_15121 is a CDS View that provides data about "U_15121 Compatibility View" in SAP S/4HANA. It reads from 1 data source (nsdm_e_mspr) and exposes 29 fields with key fields mandt, matnr, werks, lgort, charg.

Data Sources (1)

SourceAliasJoin Type
nsdm_e_mspr a from

Annotations (11)

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

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY mandt nsdm_e_mspr mandt Editing Client
KEY matnr nsdm_e_mspr matnr Vehicle Model
KEY werks nsdm_e_mspr werks Receiving Plant
KEY lgort nsdm_e_mspr lgort Sublocation
KEY charg nsdm_e_mspr charg Chargeable Proc.
KEY sobkz nsdm_e_mspr sobkz Special Stock
KEY pspnr nsdm_e_mspr pspnr WBS Element
lfgja nsdm_e_mspr lfgja Year Cur.Period
lfmon nsdm_e_mspr lfmon Current Period
prspr nsdm_e_mspr prspr Phys. Inv. Blk
prlab nsdm_e_mspr prlab Unrestricted
prins nsdm_e_mspr prins Quality Insp.
prspe nsdm_e_mspr prspe Permanently
prvla nsdm_e_mspr prvla Unrestr.-use
prvin nsdm_e_mspr prvin In qual. insp.
prvsp nsdm_e_mspr prvsp Blocked
prill nsdm_e_mspr prill Warehouse stock
prilq nsdm_e_mspr prilq QualInspStock
prils nsdm_e_mspr prils Blocked stock
prvll nsdm_e_mspr prvll Warehouse stock
prvlq nsdm_e_mspr prvlq QualInspStock
prvls nsdm_e_mspr prvls Blocked stock
prfll nsdm_e_mspr prfll Warehouse stock
prflq nsdm_e_mspr prflq QualInspStock
prfls nsdm_e_mspr prfls Blocked stock
prdll nsdm_e_mspr prdll Last Count Date
prein nsdm_e_mspr prein Restricted-Use
prvei nsdm_e_mspr prvei Restr.-use PP
ersda nsdm_e_mspr ersda Entry Date

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

CREATE VIEW NSDM_E_U_15121 AS
SELECT
  a.mandt AS mandt,
  a.matnr AS matnr,
  a.werks AS werks,
  a.lgort AS lgort,
  a.charg AS charg,
  a.sobkz AS sobkz,
  a.pspnr AS pspnr,
  a.lfgja AS lfgja,
  a.lfmon AS lfmon,
  a.prspr AS prspr,
  a.prlab AS prlab,
  a.prins AS prins,
  a.prspe AS prspe,
  a.prvla AS prvla,
  a.prvin AS prvin,
  a.prvsp AS prvsp,
  a.prill AS prill,
  a.prilq AS prilq,
  a.prils AS prils,
  a.prvll AS prvll,
  a.prvlq AS prvlq,
  a.prvls AS prvls,
  a.prfll AS prfll,
  a.prflq AS prflq,
  a.prfls AS prfls,
  a.prdll AS prdll,
  a.prein AS prein,
  a.prvei AS prvei,
  a.ersda AS ersda
FROM nsdm_e_mspr AS a
;