NSDM_E_MSPR

CDS View
29 Fields 4 CDS Views

MSPR Compatibility View

NSDM_E_MSPR is a CDS View in S/4HANA. MSPR Compatibility View. It contains 29 fields. 4 CDS views read from this table.

CDS Views using this table (4)

ViewTypeJoinVDMDescription
NSDM_E_U_15121 view from U_15121 Compatibility View
NSDM_E_V_BF_MSPR view from V_BF_MSPR Compatibility View
NSDM_E_V_CF_MSPR view from V_CF_MSPR Compatibility View
NSDM_E_V_MMIM_QN view from V_MMIM_QN Compatibility View

Fields (29)

KeyField CDS FieldsUsed in Views
KEY charg charg 4
KEY lgort lgort 4
KEY mandt mandt 4
KEY matnr matnr 4
KEY pspnr pspnr 4
KEY sobkz sobkz 4
KEY werks werks 4
ersda ersda 1
lfgja lfgja 4
lfmon lfmon 4
prdll prdll 1
prein CEINM,einme,prein 4
prfll prfll 1
prflq prflq 1
prfls prfls 1
prill kzill,prill 2
prilq kzilq,prilq 2
prils kzils,prils 2
prins CINSM,insme,prins 4
prlab CLABS,labst,prlab 4
prspe CSPEM,prspe,speme 4
prspr prspr,SPERC,sperr 3
prvei CVMEI,prvei,vmein 3
prvin CVMIN,prvin,vmins 3
prvla CVMLA,prvla,vmlab 3
prvll kzvll,prvll 2
prvlq kzvlq,prvlq 2
prvls kzvls,prvls 2
prvsp CVMSP,prvsp,vmspe 3

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- MSPR Compatibility View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NSDM_E_MSPR (
    CHARG,
    LGORT,
    MANDT,
    MATNR,
    PSPNR,
    SOBKZ,
    WERKS,
    ERSDA,
    LFGJA,
    LFMON,
    PRDLL,
    PREIN,
    PRFLL,
    PRFLQ,
    PRFLS,
    PRILL,
    PRILQ,
    PRILS,
    PRINS,
    PRLAB,
    PRSPE,
    PRSPR,
    PRVEI,
    PRVIN,
    PRVLA,
    PRVLL,
    PRVLQ,
    PRVLS,
    PRVSP,
    PRIMARY KEY (CHARG, LGORT, MANDT, MATNR, PSPNR, SOBKZ, WERKS)
);

Learn More