Follow us on LinkedIn for your next SAP project

SAP Table MODMIXP_DB

Model Mix Items: Database Structure

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.

MODMIXP_DB table fields

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

MODMIXP_DB foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MODMIXP_DB MMGUID SYST MANDT MODMIXH
Model Mix Header Data
MANDT
MODMIXP_DB MMGUID MODMIXP_DB MMGUID MODMIXH
Model Mix Header Data
MMGUID