MODMIXP_DB (Model Mix Items: Database Structure) 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 MODMIXP_DB to other SAP tables.
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||
|
MMGUID
Internal Identification of the Model Mix
|
PVS_MMGUID | MODMIXH |
RAW
|
16 | 0 | |||||||||
|
MMCNT
Internal Counter for PVS Objects
|
PVS_CNT4 |
NUMC
|
4 | 0 | ||||||||||
|
PPEGUID
Internal Identification for PVS Objects
|
PVS_GUID |
RAW
|
16 | 0 | ||||||||||
|
PLANID
Internal Number of iPPE Node
|
PVS_PNGUID |
RAW
|
16 | 0 | ||||||||||
|
MMNUM
Absolute Share of Material/Product in Model Mix
|
PPE_MMNUM |
DEC
|
6 | 0 | ||||||||||
|
CMPID
Internal Identification of the Component (Material/Product)
|
PVS_CMPID |
CHAR
|
32 | 0 | ||||||||||
|
LOCID
Plant/Location in iPPE
|
PPE_LOCID |
CHAR
|
22 | 0 | ||||||||||
|
PPEUSE
Usage in iPPE
|
PPE_USE |
CHAR
|
3 | 0 | ||||||||||
|
PLAN_NAME
iPPE Node Description
|
PVS_PNODE |
CHAR
|
40 | 0 | ||||||||||
|
CLINT
Internal Class Number
|
CLINT |
NUMC
|
10 | 0 | ||||||||||
|
DBOP
Update indicator
|
PVS_DBOP |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||