SAP Table
TMQ2 Quota Arrangement Rules
SAP table TMQ2 has 2 primary key fields being MANDT,USEQU.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
TMQ2 columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| KeyUSEQU | Quota arrangement usage | CHAR | 1 | 0 | USEQU | ||
| QBEST | Purchase order will be included in quota arrangement | CHAR | 1 | 0 | QBEST | ||
| QLPET | Manual SA Deliv. Schedule Line Subject to Quota Arrangement | CHAR | 1 | 0 | QLPET | ||
| QPLAF | Planned order (manual) to be included in quota arrangement | CHAR | 1 | 0 | QPLAF | ||
| QBANF | Purchase requisition will be included in quota arrangement | CHAR | 1 | 0 | QBANF | ||
| QDISP | Quota system will be applied during automatic MRP process | CHAR | 1 | 0 | QDISP | ||
| QFAUF | Quota arrangement applied to production order | CHAR | 1 | 0 | QFAUF | ||
| QFIR | Invoice Subject to Quota Arrangement | CHAR | 1 | 0 | QFIR |