SAP Table MSSA
Total Customer Orders on Hand
MSSA (Total Customer Orders on Hand) 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 MSSA to other SAP tables.
MSSA 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 | ||||||||
| SOBKZ | Special Stock Indicator | SOBKZ | T148 | CHAR | 1 | 0 | ||||||||
| VBELN | Sales and Distribution Document Number | VBELN | VBUK | CHAR | 10 | 0 | ||||||||
| POSNR | Item number of the SD document | POSNR | VBUP | NUMC | 6 | 0 | ||||||||
| LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4 | 0 | |||||||||
| LFMON | Current period (posting period) | LFMON | NUMC | 2 | 0 | |||||||||
| SALAB | Valuated Unrestricted-Use Stock | LABST | QUAN | 13 | 3 | |||||||||
| SAINS | Stock in Quality Inspection | INSME | QUAN | 13 | 3 | |||||||||
| SASPE | Blocked Stock | SPEME | QUAN | 13 | 3 | |||||||||
| SAEIN | Total Stock of All Restricted Batches | EINME | QUAN | 13 | 3 | |||||||||
| ERSDA | Created On | ERSDA | DATS | 8 | 0 | |||||||||
| KZBWS | Valuation of Special Stock | KZBWS | CHAR | 1 | 0 |
Possible values
|
||||||||
| SATRA | Stock in transit | SATRA | QUAN | 13 | 3 | |||||||||
| SARUE | MxxxH rec. already exists for per. before last of Mxxx per. | SBRUE | CHAR | 1 | 0 |
Possible values
|
||||||||
| SABWE | Valuated Goods Receipt Blocked Stock, Sales Order | SABWE | QUAN | 13 | 3 | |||||||||
MSSA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| MSSA | MANDT | MSSA | MANDT | T000 | Clients | MANDT |
| MSSA | MATNR | MSSA | MANDT | MARA | General Material Data | MANDT |
| MSSA | MATNR | MSSA | MATNR | MARA | General Material Data | MATNR |
| MSSA | POSNR | MSSA | MANDT | VBUP | Sales Document: Item Status | MANDT |
| MSSA | POSNR | MSSA | VBELN | VBUP | Sales Document: Item Status | VBELN |
| MSSA | POSNR | MSSA | POSNR | VBUP | Sales Document: Item Status | POSNR |
| MSSA | SOBKZ | MSSA | MANDT | T148 | Special Stock Indicator | MANDT |
| MSSA | SOBKZ | MSSA | SOBKZ | T148 | Special Stock Indicator | SOBKZ |
| MSSA | VBELN | MSSA | VBELN | VBUK | Sales Document: Header Status and Administrative Data | VBELN |
| MSSA | VBELN | MSSA | MANDT | VBUK | Sales Document: Header Status and Administrative Data | MANDT |
| MSSA | WERKS | MSSA | MANDT | T001W | Plants/Branches | MANDT |
| MSSA | WERKS | MSSA | WERKS | T001W | Plants/Branches | WERKS |
