SAP table MSKAHO1 (MSKAH: Additional quantities appendix)
SAP table MSKAHO1 has 11 primary key fields being MANDT,MATNR,WERKS,LGORT,CHARG,SOBKZ,VBELN,POSNR,LFGJA,LFMON,MSEHI.
If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |
|---|---|---|---|---|---|---|---|
| MANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |
| MATNR | Material Number | CHAR | 40 | 0 | MARA | MATNR | |
| WERKS | Plant | CHAR | 4 | 0 | T001W | WERKS_D | |
| LGORT | Storage location | CHAR | 4 | 0 | T001L | LGORT_D | |
| CHARG | Batch Number | CHAR | 10 | 0 | MCH1 | CHARG_D | |
| SOBKZ | Special Stock Indicator | CHAR | 1 | 0 | T148 | SOBKZ | |
| VBELN | Sales and Distribution Document Number | CHAR | 10 | 0 | VBELN | ||
| POSNR | Item number of the SD document | NUMC | 6 | 0 | POSNR | ||
| LFGJA | Fiscal Year of Current Period | NUMC | 4 | 0 | LFGJA | ||
| LFMON | Current period (posting period) | NUMC | 2 | 0 | LFMON | ||
| MSEHI | Unit of Measurement | UNIT | 3 | 0 | T006 | MSEHI | |
| KALAB | Valuated Unrestricted-Use Stock | QUAN | 13 | 3 | LABST | ||
| KAINS | Stock in Quality Inspection | QUAN | 13 | 3 | INSME | ||
| KASPE | Blocked Stock | QUAN | 13 | 3 | SPEME | ||
| KAEIN | Total Stock of All Restricted Batches | QUAN | 13 | 3 | EINME |
MSKAHO1 foreign key relationships
| Table | Field | Check Table | Check Field | |
|---|---|---|---|---|
| 0 MSKAHO1 | CHARG | MCH1 | Batches (if Batch Management Cross-Plant) | MANDT |
| 1 MSKAHO1 | LGORT | T001L | Storage Locations | MANDT |
| 1 MSKAHO1 | LGORT | T001L | Storage Locations | WERKS |
| 0 MSKAHO1 | MANDT | T000 | Clients | MANDT |
| 1 MSKAHO1 | MATNR | MARA | General Material Data | MANDT |
| 1 MSKAHO1 | MATNR | MARA | General Material Data | MATNR |
| 0 MSKAHO1 | MSEHI | T006 | Units of Measurement | MANDT |
| 1 MSKAHO1 | SOBKZ | T148 | Special Stock Indicator | MANDT |
| 1 MSKAHO1 | SOBKZ | T148 | Special Stock Indicator | SOBKZ |
| 0 MSKAHO1 | WERKS | T001W | Plants/Branches | MANDT |
| 0 MSKAHO1 | WERKS | T001W | Plants/Branches | WERKS |