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 | Possible values | ||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT | T000 |
CLNT
|
3 | 0 | |||||||
|
WMINR
Product catalog number
|
WMINR |
CHAR
|
10 | 0 | ||||||||
|
WMTYP
Prod. catalog category
|
WMTYP |
CHAR
|
2 | 0 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
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 | ||||||||
|
||||||||||||
|
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 | ANZWA |
TCURC
Currency Codes
|
WAERS |
| WWMI | ANZWA | WWMI | MANDT |
TCURC
Currency Codes
|
MANDT |
| 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 | LAYVR |
TWGV
Layout
|
LAYVR |
| WWMI | LAYVR | WWMI | MANDT |
TWGV
Layout
|
MANDT |
| 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 | MANDT |
TSPA
Organizational Unit: Sales Divisions
|
MANDT |
| WWMI | SPART | WWMI | SPART |
TSPA
Organizational Unit: Sales Divisions
|
SPART |
| WWMI | VKORG | WWMI | MANDT |
TVKO
Organizational Unit: Sales Organizations
|
MANDT |
| WWMI | VKORG | WWMI | VKORG |
TVKO
Organizational Unit: Sales Organizations
|
VKORG |
| WWMI | VTWEG | WWMI | MANDT |
TVTW
Organizational Unit: Distribution Channels
|
MANDT |
| WWMI | VTWEG | WWMI | VTWEG |
TVTW
Organizational Unit: Distribution Channels
|
VTWEG |