V_EBEW_MD
V_EBEW_MD is an SAP database table in S/4HANA. It contains 34 fields. 3 CDS views read from this table.
CDS Views using this table (3)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| FCML_MAT_DDL | view | inner | CDS View with structure of table FCML_MAT | |
| P_Matval_Manage_Xbew | view | union_all | COMPOSITE | Base View for Mat.Val., Master Data |
| pchk_par_sel_xbew | view | union_all | Xbew selection for parallel packaging |
Fields (34)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | bwkey | ValuationArea | 1 |
| KEY | bwtar | InventoryValuationType | 1 |
| KEY | matnr | Material | 1 |
| bklas | bklas,MaterialValuationClass | 2 | |
| bwtty | InventoryValuationCategory | 1 | |
| bwva1 | FutrCostEstValuationVariant | 1 | |
| bwva2 | CurCostEstValuationVariant | 1 | |
| bwva3 | PrevCostEstValuationVariant | 1 | |
| ekalr | IsMaterialCostedWithQtyStruc | 1 | |
| fbwst | FutrPlanProjSlsOrdValnStrategy | 1 | |
| fplpx | FxdPortnOfFutPlPrcInCoCodeCrcy | 1 | |
| hkmat | IsMaterialRelatedOrigin | 1 | |
| hrkft | CostOriginGroup,hrkft | 2 | |
| kosgr | CostingOverheadGroup | 1 | |
| laepr | PriceLastChangeDate | 1 | |
| lbwst | CurPlanProjSlsOrdValnStrategy | 1 | |
| lplpr | CurrentPlanPriceInCoCodeCrcy | 1 | |
| pdatl | CurrentCostEstFiscalYear | 1 | |
| pdatv | PreviousCostEstFiscalYear | 1 | |
| pdatz | FutureCostEstFiscalYear | 1 | |
| posnr | SalesOrderItem | 1 | |
| pprdl | CurrentCostEstFiscalPeriod | 1 | |
| pprdv | PreviousCostEstFiscalPeriod | 1 | |
| pprdz | FutureCostEstimateFiscalPeriod | 1 | |
| sobkz | InvtryValnSpecialStockType | 1 | |
| vbeln | SalesOrder | 1 | |
| vbwst | PrevPlanProjSlsOrdValnStrategy | 1 | |
| vers1 | FutureCostEstCostingVersion | 1 | |
| vers2 | CurrentCostEstCostingVersion | 1 | |
| vers3 | PreviousCostEstCostingVersion | 1 | |
| vjbkl | ValuationClassInPrevYear | 1 | |
| vmbkl | ValuationClassInPrevPeriod | 1 | |
| vplpr | PreviousPlanPriceInCoCodeCrcy | 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_EBEW_MD (
BWKEY,
BWTAR,
MATNR,
BKLAS,
BWTTY,
BWVA1,
BWVA2,
BWVA3,
EKALR,
FBWST,
FPLPX,
HKMAT,
HRKFT,
KOSGR,
LAEPR,
LBWST,
LPLPR,
PDATL,
PDATV,
PDATZ,
POSNR,
PPRDL,
PPRDV,
PPRDZ,
SOBKZ,
VBELN,
VBWST,
VERS1,
VERS2,
VERS3,
VJBKL,
VMBKL,
VPLPR,
ZPLPR,
PRIMARY KEY (BWKEY, BWTAR, MATNR)
);
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