SAP Table MDFQ
View of Production Version and Quota Arrangement
MDFQ (View of Production Version and Quota Arrangement) 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 MDFQ to other SAP tables.
Source: MDFQ (View of Production Version and Quota Arrangement)
MDFQ table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | CLNT | 3 | 0 | |||||||
| MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||
| WERKS | Plant | WERKS_D | 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 | CHAR | 1 | 0 | |||||||
| VERTO | Distribution key for quantity produced | SA_VERTO | 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 | CHAR | 4 | 0 | |||||||
| ELPRO | Proposed issue storage location for components | SA_ELPRO | CHAR | 4 | 0 | |||||||
| PRVBE | Default supply area for components | SA_PRVBE | CHAR | 10 | 0 | |||||||
| MATKO | Other material for which BOM and task list are maintained | MKAL_MATKO | CHAR | 18 | 0 | |||||||
| PLNNR | Key for Task List Group | PLNNR | CHAR | 8 | 0 | |||||||
| ALNAL | Group Counter | PLNAL | CHAR | 2 | 0 | |||||||
| MKSP | Production version is locked | MKSP | CHAR | 1 | 0 |
Possible values
|
||||||
| QUNUM | Number of Quota Arrangement | QUNUM | CHAR | 10 | 0 | |||||||
| QUPOS | Quota Arrangement Item | QUPOS | NUMC | 3 | 0 | |||||||
| QUOTE | Quota | QUOTE | DEC | 3 | 0 | |||||||
| PREIH | Priority for Determination of Sequence | PREIH | NUMC | 2 | 0 | |||||||
| MAXMG | Maximum Quantity of Quota Arrangement Item | QUMAX | QUAN | 15 | 3 | |||||||
| QUBMG | Quota Base Quantity of Quota Arrangement Item | QUBAS | QUAN | 15 | 3 | |||||||
| QUMNG | Allocated Quantity of Quota Arrangement Item | QUMNG | QUAN | 15 | 3 | |||||||
| TEXT1 | Short text on the production version | VERS_TEXT | CHAR | 40 | 0 | |||||||
