MBV_MBEW

CDS View
93 Fields 16 CDS Views

Compatibility view for MBEW table

MBV_MBEW is a CDS View in S/4HANA. Compatibility view for MBEW table. It contains 93 fields. 16 CDS views read from this table.

CDS Views using this table (16)

ViewTypeJoinVDMDescription
C_PH_StockQuery view from CONSUMPTION Ph Stock Query Philippines
Mbv_Ent5507 view from Compatibility view for ENT5507 view (ML integration)
Mbv_J_1ambew view from Compatibility view for J_1AMBEW view (ML integration)
Mbv_Macku view inner Compatibility view for MACKU view (ML integration)
Mbv_Mb61v view from Compatibility view for MB61V view (ML integration)
Mbv_Srmerp_Css_Mat view inner Compatibility view for /SRMERP/CCS_MAT view (ML integration)
Mbv_V_Mmim_Wb view from Compatibility view for V_MMIM_WB view (ML integration)
Mbv_V_Satz1 view inner Compatibility view for V_SATZ1 view (ML integration)
Mbv_Vkp_Mbew view from Compatibility view for VKP_MBEW view (ML integration)
Mbv_Vmbew view from Compatibility view for VMBEW view (ML integration)
Mbv_Wrma_V_Mbew view inner Compatibility view for /SRMERP/CCS_MAT view (ML integration)
NSDM_e_V_SLGH_1 view inner V_SLGH_1 Compatibility View
NSDM_e_V_SLGH_2 view inner V_SLGH_2 Compatibility View
OIB_MBEW_QUANTITY view from Book inventory with valuation type and base Uom
P_CurrentMatlPriceByCostEst view from COMPOSITE
P_MaterialInfo view left_outer BASIC

Fields (93)

KeyField CDS FieldsUsed in Views
KEY bwkey bwkey 11
KEY bwtar bwtar 9
KEY mandt mandt 3
KEY matnr matnr 6
KEY peinh peinh 6
KEY salk3 salk3 5
KEY stprs stprs 5
KEY verpr MaterialPriceInCoCodeCurrency,verpr 6
KEY vksal vksal 5
KEY vprsv vprsv 5
abciw abciw 2
abwkz abwkz 1
bklas bklas 2
bwpei bwpei 1
bwph1 bwph1 2
bwprh bwprh 2
bwprs bwprs 2
bwps1 bwps1 2
bwspa bwspa 2
bwtty bwtty 2
bwva1 bwva1 1
bwva2 bwva2 1
bwva3 bwva3 1
ekalr ekalr 2
hkmat hkmat 2
hrkft hrkft 2
kalkl kalkl 1
kalkv kalkv 1
kalkz kalkz 1
kaln1 kaln1 2
kalnr kalnr 2
kalsc kalsc 1
kosgr kosgr 1
kziwl kziwl 2
laepr laepr 1
lbkum lbkum 6
lfgja lfgja 2
lfmon lfmon 2
lplpr lplpr 1
lvorm lvorm 2
mlast mlast 1
mlmaa mlmaa 1
mypol mypol 1
pdatl pdatl 1
pdatv pdatv 1
pdatz pdatz 1
pperl pperl 1
pperv pperv 1
pperz pperz 1
pprdl pprdl 1
pprdv pprdv 1
pprdz pprdz 1
pstat pstat 1
salkv salkv 1
sperw sperw 2
stprv stprv 1
vers1 vers1 1
vers2 vers2 1
vers3 vers3 1
vjbkl vjbkl 1
vjbwh vjbwh 2
vjbws vjbws 2
vjkum vjkum 1
vjpei vjpei 1
vjsal vjsal 1
vjsav vjsav 1
vjstp vjstp 1
vjver vjver 1
vjvpr vjvpr 1
vmbkl vmbkl 1
vmkum vmkum 2
vmpei vmpei 2
vmsal vmsal 2
vmsav vmsav 1
vmstp vmstp 2
vmver vmver 1
vmvpr vmvpr 1
vplpr vplpr 1
vvjlb vvjlb 1
vvjsl vvjsl 1
vvmlb vvmlb 1
vvsal vvsal 1
wlinl wlinl 2
xlifo xlifo 1
zkdat zkdat 2
zkprs zkprs 2
zpld1 zpld1 2
zpld2 zpld2 2
zpld3 zpld3 2
zplp1 zplp1 2
zplp2 zplp2 2
zplp3 zplp3 2
zplpr zplpr 2

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.

-- Compatibility view for MBEW table
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE MBV_MBEW (
    BWKEY,
    BWTAR,
    MANDT,
    MATNR,
    PEINH,
    SALK3,
    STPRS,
    VERPR,
    VKSAL,
    VPRSV,
    ABCIW,
    ABWKZ,
    BKLAS,
    BWPEI,
    BWPH1,
    BWPRH,
    BWPRS,
    BWPS1,
    BWSPA,
    BWTTY,
    BWVA1,
    BWVA2,
    BWVA3,
    EKALR,
    HKMAT,
    HRKFT,
    KALKL,
    KALKV,
    KALKZ,
    KALN1,
    KALNR,
    KALSC,
    KOSGR,
    KZIWL,
    LAEPR,
    LBKUM,
    LFGJA,
    LFMON,
    LPLPR,
    LVORM,
    MLAST,
    MLMAA,
    MYPOL,
    PDATL,
    PDATV,
    PDATZ,
    PPERL,
    PPERV,
    PPERZ,
    PPRDL,
    PPRDV,
    PPRDZ,
    PSTAT,
    SALKV,
    SPERW,
    STPRV,
    VERS1,
    VERS2,
    VERS3,
    VJBKL,
    VJBWH,
    VJBWS,
    VJKUM,
    VJPEI,
    VJSAL,
    VJSAV,
    VJSTP,
    VJVER,
    VJVPR,
    VMBKL,
    VMKUM,
    VMPEI,
    VMSAL,
    VMSAV,
    VMSTP,
    VMVER,
    VMVPR,
    VPLPR,
    VVJLB,
    VVJSL,
    VVMLB,
    VVSAL,
    WLINL,
    XLIFO,
    ZKDAT,
    ZKPRS,
    ZPLD1,
    ZPLD2,
    ZPLD3,
    ZPLP1,
    ZPLP2,
    ZPLP3,
    ZPLPR,
    PRIMARY KEY (BWKEY, BWTAR, MANDT, MATNR, PEINH, SALK3, STPRS, VERPR, VKSAL, VPRSV)
);

Learn More