nsdm_e_mspr

DDL: NSDM_DDL_MSPR SQL: NSDM_V_MSPR Type: view
37 Fields 1 Data Sources

MSPR Compatibility View

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

Data Sources (1)

SourceAliasJoin Type
mspr t from

Annotations (11)

NameValueLevelField
AbapCatalog.preserveKey true view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.sqlViewName NSDM_V_MSPR view
EndUserText.label MSPR 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 (37)

KeyFieldSource TableSource FieldDescription
KEY mandt mspr mandt Editing Client
KEY matnr mspr matnr Vehicle Model
KEY werks mspr werks Receiving Plant
KEY lgort mspr lgort Sublocation
KEY charg mspr charg Chargeable Proc.
KEY sobkz mspr sobkz Special Stock
KEY pspnr mspr pspnr WBS Element
prspr mspr prspr Phys. Inv. Blk
prlab
prins
prspe
prvla
prvin
prvsp
prill mspr prill Warehouse stock
prilq mspr prilq QualInspStock
prils mspr prils Blocked stock
prvll mspr prvll Warehouse stock
prvlq mspr prvlq QualInspStock
prvls mspr prvls Blocked stock
prfll mspr prfll Warehouse stock
prflq mspr prflq QualInspStock
prfls mspr prfls Blocked stock
prdll mspr prdll Last Count Date
prein
prvei
ersda mspr ersda Entry Date
prjin mspr prjin Fiscal year of current physical inventory indicator
prrue
/cwm/prlab
/cwm/prins
/cwm/prspe
/cwm/prvla
/cwm/prvin
/cwm/prvsp
/cwm/prein
/cwm/prvei

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_mspr.
-- 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_MSPR

CREATE VIEW nsdm_e_mspr AS
SELECT
  t.mandt AS mandt,
  t.matnr AS matnr,
  t.werks AS werks,
  t.lgort AS lgort,
  t.charg AS charg,
  t.sobkz AS sobkz,
  t.pspnr AS pspnr,
  t.prspr AS prspr,
  case when m.prlab is null then 0 else m.prlab end AS prlab,
  case when m.prins is null then 0 else m.prins end AS prins,
  case when m.prspe is null then 0 else m.prspe end AS prspe,
  case when m.prvla is null then 0 else m.prvla end AS prvla,
  case when m.prvin is null then 0 else m.prvin end AS prvin,
  case when m.prvsp is null then 0 else m.prvsp end AS prvsp,
  t.prill AS prill,
  t.prilq AS prilq,
  t.prils AS prils,
  t.prvll AS prvll,
  t.prvlq AS prvlq,
  t.prvls AS prvls,
  t.prfll AS prfll,
  t.prflq AS prflq,
  t.prfls AS prfls,
  t.prdll AS prdll,
  case when m.prein is null then 0 else m.prein end AS prein,
  case when m.prvei is null then 0 else m.prvei end AS prvei,
  t.ersda AS ersda,
  t.prjin AS prjin,
  case when m.prrue is null then ' ' else m.prrue end AS prrue,
  case when m./cwm/prlab is null then 0 else m./cwm/prlab end AS /cwm/prlab,
  case when m./cwm/prins is null then 0 else m./cwm/prins end AS /cwm/prins,
  case when m./cwm/prspe is null then 0 else m./cwm/prspe end AS /cwm/prspe,
  case when m./cwm/prvla is null then 0 else m./cwm/prvla end AS /cwm/prvla,
  case when m./cwm/prvin is null then 0 else m./cwm/prvin end AS /cwm/prvin,
  case when m./cwm/prvsp is null then 0 else m./cwm/prvsp end AS /cwm/prvsp,
  case when m./cwm/prein is null then 0 else m./cwm/prein end AS /cwm/prein,
  case when m./cwm/prvei is null then 0 else m./cwm/prvei end AS /cwm/prvei
FROM mspr AS t
;

Learn More