SAP Table MDFD
MRP firming date
MDFD (MRP firming date) 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 MDFD to other SAP tables.
MDFD table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| MATNR | Material Number | MATNR | MARA | CHAR | 18 | 0 | ||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| PLSCN | Planning Scenario of Long-Term Planning | PLSCN | PLSC | NUMC | 3 | 0 | ||
| OPFDT | Date of firm planned order last copied from MRP | OPFDT | DATS | 8 | 0 | |||
| MFXDT | Manual firming date | MFXDT | DATS | 8 | 0 | |||
| MFNAM | Set manual firming date: User | MFNAM | CHAR | 12 | 0 | |||
| MFDAT | Set manual firming date: Date to set | MFDAT | DATS | 8 | 0 | |||
MDFD foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MDFD | MANDT | MDFD | MANDT | T000 | Clients | MANDT |
| MDFD | MATNR | MDFD | MANDT | MARA | General Material Data | MANDT |
| MDFD | MATNR | MDFD | MATNR | MARA | General Material Data | MATNR |
| MDFD | PLSCN | MDFD | MANDT | PLSC | Planning scenarios in long-term planning | MANDT |
| MDFD | PLSCN | MDFD | PLSCN | PLSC | Planning scenarios in long-term planning | PLSCN |
| MDFD | WERKS | MDFD | WERKS | T001W | Plants/Branches | WERKS |
| MDFD | WERKS | MDFD | MANDT | T001W | Plants/Branches | MANDT |
