NSDM_E_MSKA
MSKA Compatibility View
NSDM_E_MSKA is a CDS View in S/4HANA. MSKA Compatibility View. It contains 25 fields. 5 CDS views read from this table.
CDS Views using this table (5)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| NSDM_E_MB_SIT_OBDLV | view | from | MB_SIT_OBDLV Compatibility View | |
| NSDM_E_V_BF_MSKA | view | from | V_BF_MSKA Compatibility View | |
| NSDM_E_V_CF_MSKA | view | from | V_CF_MSKA Compatibility View | |
| NSDM_E_V_MMIM_EN | view | from | V_MMIM_EN Compatibility View | |
| NSDM_E_V_MMIM_EN2 | view | from | V_MMIM_EN2 Compatibility View |
Fields (25)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | charg | charg | 5 |
| KEY | lgort | lgort | 5 |
| KEY | mandt | mandt | 5 |
| KEY | matnr | matnr | 5 |
| KEY | posnr | posnr | 5 |
| KEY | sobkz | sobkz | 5 |
| KEY | vbeln | vbeln | 5 |
| KEY | werks | werks | 5 |
| kaein | CEINM,EINME | 4 | |
| kaill | kzill | 2 | |
| kailq | kzilq | 2 | |
| kails | kzils | 2 | |
| kains | CINSM,INSME | 4 | |
| kalab | CLABS,LABST | 4 | |
| kaspe | CSPEM,kaspe,SPEME | 5 | |
| kaspr | SPERC,SPERR | 2 | |
| kavei | CVMEI,VMEIN | 2 | |
| kavin | CVMIN,VMINS | 2 | |
| kavla | CVMLA,VMLAB | 2 | |
| kavll | kzvll | 2 | |
| kavlq | kzvlq | 2 | |
| kavls | kzvls | 2 | |
| kavsp | CVMSP,VMSPE | 2 | |
| lfgja | lfgja | 4 | |
| lfmon | lfmon | 4 |
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.
-- MSKA Compatibility View
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NSDM_E_MSKA (
CHARG,
LGORT,
MANDT,
MATNR,
POSNR,
SOBKZ,
VBELN,
WERKS,
KAEIN,
KAILL,
KAILQ,
KAILS,
KAINS,
KALAB,
KASPE,
KASPR,
KAVEI,
KAVIN,
KAVLA,
KAVLL,
KAVLQ,
KAVLS,
KAVSP,
LFGJA,
LFMON,
PRIMARY KEY (CHARG, LGORT, MANDT, MATNR, POSNR, SOBKZ, VBELN, WERKS)
);
Learn More
- Understanding Data Lineage in SAP S/4HANA
- SAP Tables vs CDS Views — Key Differences
- Understanding the SAP S/4HANA Data Model
- BSEG to ACDOCA: The Universal Journal Migration
- Business Partner Migration: KNA1/LFA1 to BUT000
- Material Document Migration: MSEG/MKPF to MATDOC
- How to Find the Right CDS View for an SAP Table
- Sales Document Status Migration: VBUP/VBUK Removal in S/4HANA
- CO Tables in S/4HANA: COEP, COBK, COSS, COSP to ACDOCA