SAP Table MDFV
Generated Table for View MDFV
MDFV (Generated Table for View MDFV) 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 MDFV to other SAP tables.
MDFV 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 | ||||||
| VERID | Production Version | VERID | CHAR | 4 | 0 | |||||||
| BDATU | Run-time end: production version | BDATM | DATS | 8 | 0 | |||||||
| ADATU | Valid-from date of production version | ADATM | DATS | 8 | 0 | |||||||
| STLAL | Alternative BOM | STALT | CHAR | 2 | 0 | |||||||
| STLAN | BOM Usage | STLAN | T416 | CHAR | 1 | 0 | ||||||
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | 0 | |||||||
| ALNAL | Group Counter | PLNAL | CHAR | 2 | 0 | |||||||
| TEXT1 | Short text on the production version | VERS_TEXT | CHAR | 40 | 0 | |||||||
| VERTO | Distribution key for quantity produced | SA_VERTO | T437V | CHAR | 4 | 0 | ||||||
| BSTMI | Lower value of the lot-size interval | SA_LOSVN | QUAN | 13 | 3 | |||||||
| BSTMA | Upper value of the lot-size interval | SA_LOSBS | QUAN | 13 | 3 | |||||||
| ALORT | Receiving storage location for repetitive manufacturing | ALORT | T001L | CHAR | 4 | 0 | ||||||
| MATKO | Other material for which BOM and task list are maintained | MKAL_MATKO | MARA | CHAR | 18 | 0 | ||||||
| ELPRO | Proposed issue storage location for components | SA_ELPRO | T001L | CHAR | 4 | 0 | ||||||
| PRVBE | Default supply area for components | SA_PRVBE | CHAR | 10 | 0 | |||||||
| MKSP | Production version is locked | MKSP | CHAR | 1 | 0 |
Possible values
|
||||||
MDFV foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MDFV | ALORT | MDFV | MANDT | T001L | Storage Locations | MANDT |
| MDFV | ALORT | MDFV | WERKS | T001L | Storage Locations | WERKS |
| MDFV | ALORT | MDFV | ALORT | T001L | Storage Locations | LGORT |
| MDFV | ELPRO | MDFV | ELPRO | T001L | Storage Locations | LGORT |
| MDFV | ELPRO | MDFV | MANDT | T001L | Storage Locations | MANDT |
| MDFV | ELPRO | MDFV | WERKS | T001L | Storage Locations | WERKS |
| MDFV | MANDT | MDFV | MANDT | T000 | Clients | MANDT |
| MDFV | MATKO | MDFV | MANDT | MARA | General Material Data | MANDT |
| MDFV | MATKO | MDFV | MATKO | MARA | General Material Data | MATNR |
| MDFV | MATNR | MDFV | MANDT | MARA | General Material Data | MANDT |
| MDFV | MATNR | MDFV | MATNR | MARA | General Material Data | MATNR |
| MDFV | STLAN | MDFV | MANDT | T416 | BOM Usage - Item Statuses | MANDT |
| MDFV | STLAN | MDFV | STLAN | T416 | BOM Usage - Item Statuses | STLAN |
| MDFV | VERTO | MDFV | MANDT | T437V | Distribution key in MRP | MANDT |
| MDFV | VERTO | MDFV | WERKS | T437V | Distribution key in MRP | WERKS |
| MDFV | VERTO | MDFV | VERTO | T437V | Distribution key in MRP | VERTL |
| MDFV | WERKS | MDFV | MANDT | T001W | Plants/Branches | MANDT |
| MDFV | WERKS | MDFV | WERKS | T001W | Plants/Branches | WERKS |
