SAP Table WWMI
Product catalog
WWMI (Product catalog) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link WWMI to other SAP tables.
WWMI table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||
| WMINR | Product catalog number | WMINR | CHAR | 10 | 0 | |||||||
| WMTYP | Prod. catalog category | WMTYP | CHAR | 2 | 0 |
Possible values
|
||||||
| AKTNR | Promotion | WAKTION | WAKH | CHAR | 10 | 0 | ||||||
| LAYVR | Layout | LAYVAR | TWGV | CHAR | 10 | 0 | ||||||
| MEANT | Unit of measure for display size in product catalog | W_KMEANT | T006 | UNIT | 3 | 0 | ||||||
| KZHIR | Indicator for hierarchical product catalog | KZHIR | CHAR | 1 | 0 |
Possible values
|
||||||
| ABDAT | Product catalog valid from | WMDATAB | DATS | 8 | 0 | |||||||
| BISDAT | Product catalog valid to | WMDATBIS | DATS | 8 | 0 | |||||||
| KALVG | Document schema for determining a calculation schema | WMKALVG | TVKV | CHAR | 1 | 0 | ||||||
| KUNNR | Reference customer | REFKUNNR | KNA1 | CHAR | 10 | 0 | ||||||
| VKORG | Sales Organization | VKORG | TVKO | CHAR | 4 | 0 | ||||||
| VTWEG | Distribution Channel | VTWEG | TVTW | CHAR | 2 | 0 | ||||||
| SPART | Division | SPART | TSPA | CHAR | 2 | 0 | ||||||
| STTAG | Key date for product catalog price determination | WMSTTAG | DATS | 8 | 0 | |||||||
| ANZWA | Display currency | WMANZWA | TCURC | CUKY | 5 | 0 | ||||||
| KZPRS | Indicates price display | WMKZPRS | CHAR | 1 | 0 |
Possible values
|
||||||
| BEGRU | Authorization group product catalog | PCBEGRU | CHAR | 4 | 0 | |||||||
| ORGSYS | Original system | W_PC_ORGSY | CHAR | 10 | 0 | |||||||
| PCTYP | Product catalog type | W_PC_PCTYP | TWPCTYPE | CHAR | 4 | 0 | ||||||
| CCODE | Catalog code | W_PC_CCODE | CHAR | 4 | 0 | |||||||
WWMI foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| WWMI | AKTNR | WWMI | MANDT | WAKH | Promotion Header Data, IS-R | MANDT |
| WWMI | AKTNR | WWMI | AKTNR | WAKH | Promotion Header Data, IS-R | AKTNR |
| WWMI | ANZWA | WWMI | MANDT | TCURC | Currency Codes | MANDT |
| WWMI | ANZWA | WWMI | ANZWA | TCURC | Currency Codes | WAERS |
| WWMI | KALVG | WWMI | MANDT | TVKV | Pricing Procedures: Transaction | MANDT |
| WWMI | KALVG | WWMI | KALVG | TVKV | Pricing Procedures: Transaction | KALVG |
| WWMI | KUNNR | WWMI | MANDT | KNA1 | General Data in Customer Master | MANDT |
| WWMI | KUNNR | WWMI | KUNNR | KNA1 | General Data in Customer Master | KUNNR |
| WWMI | LAYVR | WWMI | MANDT | TWGV | Layout | MANDT |
| WWMI | LAYVR | WWMI | LAYVR | TWGV | Layout | LAYVR |
| WWMI | MANDT | WWMI | MANDT | T000 | Clients | MANDT |
| WWMI | MEANT | WWMI | MANDT | T006 | Units of Measurement | MANDT |
| WWMI | MEANT | WWMI | MEANT | T006 | Units of Measurement | MSEHI |
| WWMI | PCTYP | WWMI | MANDT | TWPCTYPE | Product Catalog Type | MANDT |
| WWMI | PCTYP | WWMI | PCTYP | TWPCTYPE | Product Catalog Type | PCTYP |
| WWMI | SPART | WWMI | SPART | TSPA | Organizational Unit: Sales Divisions | SPART |
| WWMI | SPART | WWMI | MANDT | TSPA | Organizational Unit: Sales Divisions | MANDT |
| WWMI | VKORG | WWMI | MANDT | TVKO | Organizational Unit: Sales Organizations | MANDT |
| WWMI | VKORG | WWMI | VKORG | TVKO | Organizational Unit: Sales Organizations | VKORG |
| WWMI | VTWEG | WWMI | VTWEG | TVTW | Organizational Unit: Distribution Channels | VTWEG |
| WWMI | VTWEG | WWMI | MANDT | TVTW | Organizational Unit: Distribution Channels | MANDT |
