NSDM_E_MSEG

CDS View
192 Fields 11 CDS Views

Extension for Append DISUB_MSEG_DATA on MSEG

NSDM_E_MSEG is a CDS View in S/4HANA. Extension for Append DISUB_MSEG_DATA on MSEG. It contains 192 fields. 11 CDS views read from this table.

CDS Views using this table (11)

ViewTypeJoinVDMDescription
C_GdsRcptItemQty view from Goods Receipt Item Quantity
FAC_AUDIT_Z3_MATERIAL_ITEM view left_outer Material items
NSDM_E_M_MBMPS view from M_MBMPS Compatibility View
NSDM_E_SAPNEA_ROWA_V view from /SAPNEA/ROWA_V Compatibility View
V_WB2_MKPF_MSEG_1 view from Business Volume from Goods Receipt
V_WB2_MKPF_MSEG_2 view from Business Volume from Goods Receipt -EKKN
view_gr_items_p view from Item Related Data of Goods Receipt
Wb2_Cds_Ccs_Matdoc view from CCS: Material Document
WB2_DDL_MKPF_MSEG view inner Redirection View for Material Documents (without WBGT)
WB2_DDL_MKPF_MSEG_WBGT view inner Redirection View for Material Documents
WCB_DDL_MKPF_MSEG view inner Material Documents - Business Volume Determination

Fields (192)

KeyField CDS FieldsUsed in Views
KEY mandt mandt,MANDT_I 3
KEY mblnr GoodsMovement,mblnr,MBLNR_I 6
KEY mjahr GoodsMovementYear,mjahr,MJAHR_I 6
KEY sjahr sjahr,SJAHR_I 4
KEY smbln smbln,SMBLN_I 4
KEY smblp smblp,SMBLP_I 4
KEY zeile GoodsMovementItem,zeile,ZEILE_I 8
KEY zekkn zekkn,ZEKKN_I 4
ablad ABLAD,ABLAD_I 3
aktnr AKTNR,AKTNR_I 3
anln1 anln1,ANLN1_I 4
anln2 anln2,ANLN2_I 4
aplzl APLZL,APLZL_I 3
aufnr aufnr,AUFNR_I 4
aufpl AUFPL,AUFPL_I 3
aufps AUFPS,AUFPS_I 3
belnr BELNR,BELNR_I 3
belum BELUM,BELUM_I 3
bemot BEMOT,BEMOT_I 3
berkz BERKZ,BERKZ_I 3
bestq BESTQ,BESTQ_I 3
bnbtr bnbtr,BNBTR_I 4
bpmng BPMNG,BPMNG_I 3
bprme BPRME,BPRME_I 3
bstme bstme,BSTME_I 5
bstmg BSTMG,BSTMG_I 3
bualt BUALT,BUALT_I 3
budat_mkpf budat,BUDAT_MKPF 3
bukrs bukrs,BUKRS_I 5
bustm BUSTM,BUSTM_I 3
bustw BUSTW,BUSTW_I 3
buzei BUZEI,BUZEI_I 3
buzum BUZUM,BUZUM_I 3
bwart bwart,BWART_I 4
bwlvs BWLVS,BWLVS_I 3
bwtar bwtar,BWTAR_I 5
charg charg,CHARG_I 4
condi CONDI 1
cpudt_mkpf CPUDT_MKPF 1
cputm_mkpf CPUTM_MKPF 1
cuobj_ch CUOBJ_CH,CUOBJ_CH_I 3
dabrbz DABRBZ,DABRBZ_I 3
dabrz DABRZ,DABRZ_I 3
dmbtr dmbtr,DMBTR_I,InventoryValueInCoCodeCrcy 5
dmbum dmbum,DMBUM_I 4
dypla DYPLA,DYPLA_I 3
ebeln ebeln,EBELN_I 4
ebelp ebelp,EBELP_I 4
elikz ELIKZ,ELIKZ_I 3
ematn EMATN,EMATN_I 3
emlif emlif,EMLIF_I 4
equnr EQUNR,EQUNR_I 3
erfme erfme,ERFME_I,GoodsMovementEntryUnit 7
erfmg erfmg,ERFMG_I,GoodsMovementEntryQty 5
evere EVERE,EVERE_I 3
evers EVERS,EVERS_I 3
exbwr EXBWR,EXBWR_I 3
exvkw EXVKW,EXVKW_I 3
fipos FIPOS,FIPOS_I 3
fistl FISTL,FISTL_I 3
fkber fkber,FKBER_I 4
geber GEBER,GEBER_I 3
gjahr GJAHR,GJAHR_I 3
grant_nbr GRANT_NBR 1
grund grund,GRUND_I 4
gsber gsber,GSBER_I 5
hsdat HSDAT,HSDAT_I 3
imkey IMKEY,IMKEY_I 3
insmk INSMK,INSMK_I 3
j_1agirupd J_1AGIRUPD,J_1AGIRUPD_I 3
j_1bexbase J_1BEXBASE,J_1BEXBASE_I 3
kblnr KBLNR 1
kblpos KBLPOS 1
kdauf kdauf,KDAUF_I 4
kdein kdein,KDEIN_I 4
kdpos kdpos,KDPOS_I 4
kokrs kokrs,KOKRS_I 4
kostl kostl,KOSTL_I 4
kstrg KSTRG,KSTRG_I 3
kunnr kunnr,KUNNR_I 4
kzbew kzbew,KZBEW_I 4
kzbws KZBWS,KZBWS_I 3
kzear KZEAR,KZEAR_I 3
kzstr KZSTR,KZSTR_I 3
kzvbr kzvbr,KZVBR_I 4
kzzug kzzug,KZZUG_I 4
lbkum lbkum,LBKUM_I 4
lfbja LFBJA,LFBJA_I 3
lfbnr LFBNR,LFBNR_I 3
lfpos LFPOS,LFPOS_I 3
lgnum LGNUM,LGNUM_I 3
lgort lgort,LGORT_I 4
lgpla LGPLA,LGPLA_I 3
lgtyp LGTYP,LGTYP_I 3
lifnr lifnr,LIFNR_I 6
line_depth LINE_DEPTH,LINE_DEPTH_I 3
line_id LINE_ID,LINE_ID_I 3
llief LLIEF,LLIEF_I 3
lsmeh LSMEH,LSMEH_I 3
lsmng LSMNG,LSMNG_I 3
lstar LSTAR,LSTAR_I 3
maa_urzei MAA_URZEI 1
mat_kdauf MAT_KDAUF,MAT_KDAUF_I 3
mat_kdpos MAT_KDPOS,MAT_KDPOS_I 3
mat_pspnr MAT_PSPNR,MAT_PSPNR_I 3
matbf MATBF,MATBF_I 3
matnr Material,matnr,MATNR_I 6
meins BaseUnit,meins,MEINS_I 7
menge GdsMovementEntryQtyInBaseUnit,menge,MENGE_I 5
mengu MENGU,MENGU_I 3
mwskz MWSKZ,MWSKZ_I 3
nplnr nplnr,NPLNR_I 4
nschn NSCHN,NSCHN_I 3
oicondcod OICONDCOD 1
oinavnw OINAVNW 1
palan PALAN,PALAN_I 3
paobjnr PAOBJNR,PAOBJNR_I 3
parbu parbu,PARBU_I 4
parent_id PARENT_ID,PARENT_ID_I 3
pargb pargb,PARGB_I 4
pbamg PBAMG,PBAMG_I 3
plpla PLPLA,PLPLA_I 3
pprctr pprctr,PPRCTR_I 4
prctr prctr,PRCTR_I 5
projn projn,PROJN_I 4
prznr PRZNR,PRZNR_I 3
ps_psp_pnr ps_psp_pnr,PS_PSP_PNR_I 5
qinspst QINSPST,QINSPST_I 3
rsart RSART,RSART_I 3
rsnum RSNUM,RSNUM_I 3
rspos RSPOS,RSPOS_I 3
sakto sakto,SAKTO_I 4
salk3 salk3,SALK3_I 4
sgt_rcat SGT_RCAT 1
sgt_scat SGT_SCAT 1
sgt_umscat SGT_UMSCAT 1
sgtxt sgtxt,SGTXT_I 4
shkum shkum,SHKUM_I 4
shkzg shkzg,SHKZG_I 7
sobkz sobkz,SOBKZ_I 4
spe_gts_stock_ty SPE_GTS_STOCK_TY 1
tanum TANUM,TANUM_I 3
tbnum TBNUM,TBNUM_I 3
tbpos TBPOS,TBPOS_I 3
tbpri TBPRI,TBPRI_I 3
tcode2_mkpf TCODE2_MKPF 1
txjcd TXJCD,TXJCD_I 3
ubnum UBNUM,UBNUM_I 3
umbar UMBAR,UMBAR_I 3
umcha UMCHA,UMCHA_I 3
umlgo UMLGO,UMLGO_I 3
ummab UMMAB,UMMAB_I 3
ummat ummat,UMMAT_I 4
umsok UMSOK,UMSOK_I 3
umwrk umwrk,UMWRK_I 4
umzst UMZST,UMZST_I 3
umzus UMZUS,UMZUS_I 3
urzei URZEI,URZEI_I 3
usnam_mkpf USNAM_MKPF 1
vbeln_im VBELN_IM 1
vbelp_im VBELP_IM 1
vfdat VFDAT,VFDAT_I 3
vgart_mkpf VGART_MKPF 1
vkmws VKMWS,VKMWS_I 3
vkwra VKWRA,VKWRA_I 3
vkwrt VKWRT,VKWRT_I 3
vprsv vprsv,VPRSV_I 4
vptnr vptnr,VPTNR_I 4
vschn VSCHN,VSCHN_I 3
waers GoodsMovementCurrency,waers,WAERS_I 5
weanz WEANZ,WEANZ_I 3
wempf WEMPF,WEMPF_I 3
werks werks,WERKS_I 6
wertu WERTU,WERTU_I 3
weunb weunb,WEUNB_I 4
xauto XAUTO,XAUTO_I 3
xbeau XBEAU,XBEAU_I 3
xblnr_mkpf XBLNR_MKPF 1
xblvs XBLVS,XBLVS_I 3
xmacc XMACC 1
xobew XOBEW,XOBEW_I 3
xruej xruej,XRUEJ_I 4
xruem xruem,XRUEM_I 4
xsauf XSAUF,XSAUF_I 3
xserg XSERG,XSERG_I 3
xskst XSKST,XSKST_I 3
xspro XSPRO,XSPRO_I 3
xwoff XWOFF,XWOFF_I 3
xwsbr XWSBR,XWSBR_I 3
zusch ZUSCH,ZUSCH_I 3
zustd ZUSTD,ZUSTD_I 3
zustd_t156m ZUSTD_T156M 1

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.

-- Extension for Append DISUB_MSEG_DATA on MSEG
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE NSDM_E_MSEG (
    MANDT,
    MBLNR,
    MJAHR,
    SJAHR,
    SMBLN,
    SMBLP,
    ZEILE,
    ZEKKN,
    ABLAD,
    AKTNR,
    ANLN1,
    ANLN2,
    APLZL,
    AUFNR,
    AUFPL,
    AUFPS,
    BELNR,
    BELUM,
    BEMOT,
    BERKZ,
    BESTQ,
    BNBTR,
    BPMNG,
    BPRME,
    BSTME,
    BSTMG,
    BUALT,
    BUDAT_MKPF,
    BUKRS,
    BUSTM,
    BUSTW,
    BUZEI,
    BUZUM,
    BWART,
    BWLVS,
    BWTAR,
    CHARG,
    CONDI,
    CPUDT_MKPF,
    CPUTM_MKPF,
    CUOBJ_CH,
    DABRBZ,
    DABRZ,
    DMBTR,
    DMBUM,
    DYPLA,
    EBELN,
    EBELP,
    ELIKZ,
    EMATN,
    EMLIF,
    EQUNR,
    ERFME,
    ERFMG,
    EVERE,
    EVERS,
    EXBWR,
    EXVKW,
    FIPOS,
    FISTL,
    FKBER,
    GEBER,
    GJAHR,
    GRANT_NBR,
    GRUND,
    GSBER,
    HSDAT,
    IMKEY,
    INSMK,
    J_1AGIRUPD,
    J_1BEXBASE,
    KBLNR,
    KBLPOS,
    KDAUF,
    KDEIN,
    KDPOS,
    KOKRS,
    KOSTL,
    KSTRG,
    KUNNR,
    KZBEW,
    KZBWS,
    KZEAR,
    KZSTR,
    KZVBR,
    KZZUG,
    LBKUM,
    LFBJA,
    LFBNR,
    LFPOS,
    LGNUM,
    LGORT,
    LGPLA,
    LGTYP,
    LIFNR,
    LINE_DEPTH,
    LINE_ID,
    LLIEF,
    LSMEH,
    LSMNG,
    LSTAR,
    MAA_URZEI,
    MAT_KDAUF,
    MAT_KDPOS,
    MAT_PSPNR,
    MATBF,
    MATNR,
    MEINS,
    MENGE,
    MENGU,
    MWSKZ,
    NPLNR,
    NSCHN,
    OICONDCOD,
    OINAVNW,
    PALAN,
    PAOBJNR,
    PARBU,
    PARENT_ID,
    PARGB,
    PBAMG,
    PLPLA,
    PPRCTR,
    PRCTR,
    PROJN,
    PRZNR,
    PS_PSP_PNR,
    QINSPST,
    RSART,
    RSNUM,
    RSPOS,
    SAKTO,
    SALK3,
    SGT_RCAT,
    SGT_SCAT,
    SGT_UMSCAT,
    SGTXT,
    SHKUM,
    SHKZG,
    SOBKZ,
    SPE_GTS_STOCK_TY,
    TANUM,
    TBNUM,
    TBPOS,
    TBPRI,
    TCODE2_MKPF,
    TXJCD,
    UBNUM,
    UMBAR,
    UMCHA,
    UMLGO,
    UMMAB,
    UMMAT,
    UMSOK,
    UMWRK,
    UMZST,
    UMZUS,
    URZEI,
    USNAM_MKPF,
    VBELN_IM,
    VBELP_IM,
    VFDAT,
    VGART_MKPF,
    VKMWS,
    VKWRA,
    VKWRT,
    VPRSV,
    VPTNR,
    VSCHN,
    WAERS,
    WEANZ,
    WEMPF,
    WERKS,
    WERTU,
    WEUNB,
    XAUTO,
    XBEAU,
    XBLNR_MKPF,
    XBLVS,
    XMACC,
    XOBEW,
    XRUEJ,
    XRUEM,
    XSAUF,
    XSERG,
    XSKST,
    XSPRO,
    XWOFF,
    XWSBR,
    ZUSCH,
    ZUSTD,
    ZUSTD_T156M,
    PRIMARY KEY (MANDT, MBLNR, MJAHR, SJAHR, SMBLN, SMBLP, ZEILE, ZEKKN)
);

Learn More