V_MBEW_MD

50 Fields 7 CDS Views

V_MBEW_MD is an SAP database table in S/4HANA. It contains 50 fields. 7 CDS views read from this table.

CDS Views using this table (7)

ViewTypeJoinVDMDescription
FCML_MAT_DDL view inner CDS View with structure of table FCML_MAT
I_COPCCMaterialValuation view from BASIC CO PCC Material Valuation
I_RO_SAFTProductValuation view from BASIC RO SAFT Product Valuation
P_FBV_PAR_SEL_MAT view inner BASIC Packing for BSV parallel processing
P_Matval_Manage_Cost_Max_Pre view inner BASIC Manage Material Valuations, table of cost estimates
P_Matval_Manage_Xbew view from COMPOSITE Base View for Mat.Val., Master Data
pchk_par_sel_xbew view from Xbew selection for parallel packaging

Fields (50)

KeyField CDS FieldsUsed in Views
KEY bwkey bwkey,ValuationArea 3
KEY bwtar bwtar,InventoryValuationType,ValuationType 3
KEY kaln1 CostEstimate 1
KEY mandt mandt 1
KEY matnr Material,matnr 2
abciw InventoryForCycleCountInd 1
abwkz DevaluationYearCount 1
bklas bklas,MaterialValuationClass,ValuationClass 4
bwspa ValuationMargin 1
bwtty bwtty,InventoryValuationCategory 2
bwva1 FutrCostEstValuationVariant 1
bwva2 CurCostEstValuationVariant 1
bwva3 PrevCostEstValuationVariant 1
ekalr IsMaterialCostedWithQtyStruc 1
eklas ValuationClassSalesOrderStock 1
fbwst FutrPlanProjSlsOrdValnStrategy 1
fplpx FxdPortnOfFutPlPrcInCoCodeCrcy 1
hrkft CostOriginGroup,hrkft 2
kalkl HasStdCostEstForCurrentPeriod 1
kalkv HasStdCostEstForPreviousPeriod 1
kalkz HasStdCostEstForFuturePeriod 1
kosgr CostingOverheadGroup 1
laepr PriceLastChangeDate 1
lbwst CurPlanProjSlsOrdValnStrategy 1
lplpr CurrentPlanPriceInCoCodeCrcy 1
lplpx FxdPortnOfPlanPrcInCoCodeCrcy 1
lvorm IsMarkedForDeletion,IsMatlOfValnTypeMarkedForDeltn 2
mtorg ProductOriginType 1
mtuse ProductUsageType 1
mypol LIFOValuationPoolNumber 2
oklas ValnClsForSpclStkAtVndr 1
ownpr IsProducedInhouse 1
pdatl CurrentCostEstFiscalYear 1
pdatv PreviousCostEstFiscalYear 1
pdatz FutureCostEstFiscalYear 1
pprdl CurrentCostEstFiscalPeriod 1
pprdv PreviousCostEstFiscalPeriod 1
pprdz FutureCostEstimateFiscalPeriod 1
pstat MaintenanceStatus 1
qklas ProjectStockValuationClass 1
sperw PhysicalInventoryBlockInd 1
vbwst PrevPlanProjSlsOrdValnStrategy 1
vers1 FutureCostEstCostingVersion 1
vers2 CurrentCostEstCostingVersion 1
vers3 PreviousCostEstCostingVersion 1
vplpr PreviousPlanPriceInCoCodeCrcy 1
vplpx FxdPortOfPrevPlPrcInCoCodeCrcy 1
wlinl DateOfLastPostedCntUnRstrcdStk 1
xbewm ValnIsBsdOnBatchSpecificUnit 1
zplpr PlannedPriceInCoCodeCrcy 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.

-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE V_MBEW_MD (
    BWKEY,
    BWTAR,
    KALN1,
    MANDT,
    MATNR,
    ABCIW,
    ABWKZ,
    BKLAS,
    BWSPA,
    BWTTY,
    BWVA1,
    BWVA2,
    BWVA3,
    EKALR,
    EKLAS,
    FBWST,
    FPLPX,
    HRKFT,
    KALKL,
    KALKV,
    KALKZ,
    KOSGR,
    LAEPR,
    LBWST,
    LPLPR,
    LPLPX,
    LVORM,
    MTORG,
    MTUSE,
    MYPOL,
    OKLAS,
    OWNPR,
    PDATL,
    PDATV,
    PDATZ,
    PPRDL,
    PPRDV,
    PPRDZ,
    PSTAT,
    QKLAS,
    SPERW,
    VBWST,
    VERS1,
    VERS2,
    VERS3,
    VPLPR,
    VPLPX,
    WLINL,
    XBEWM,
    ZPLPR,
    PRIMARY KEY (BWKEY, BWTAR, KALN1, MANDT, MATNR)
);

Learn More