SAP Table SBSE
Stock Mngmt Levels for Inventory Sampling
SBSE (Stock Mngmt Levels for Inventory Sampling) 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 SBSE to other SAP tables.
SBSE table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||
|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||
| SINUM | Inventory sampling number | MBS_SINUM | CHAR | 10 | 0 | |||
| SJAHR | Calendar year of the inventory sampling | MBS_SJAHR | NUMC | 4 | 0 | |||
| NRBSE | Stock management level number | MBS_NRBSE | NUMC | 3 | 0 | |||
| WERKS | Plant | WERKS_D | T001W | CHAR | 4 | 0 | ||
| GJAHR | Fiscal Year | GJAHR | NUMC | 4 | 0 | |||
| WAERS | Currency Key | WAERS | TCURC | CUKY | 5 | 0 | ||
| URFAK | Conversion factor for currency of inventory sampling | MBS_URFAK | DEC | 9 | 5 | |||
| LGORT | Storage Location | LGORT_D | T001L | CHAR | 4 | 0 | ||
| MTART | Material Type | MTART | T134 | CHAR | 4 | 0 | ||
| BSTAR | Stock type | BSTAR | T064A | CHAR | 1 | 0 | ||
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | T300 | CHAR | 3 | 0 | ||
| LGTYP | Storage Type | LGTYP | T301 | CHAR | 3 | 0 | ||
| NGBSE | No of stratum elements of stock mgmt unit | MBS_NGBSE | NUMC | 5 | 0 | |||
| BUBSE | Book value of stock management unit | MBS_BUBSE | CURR | 13 | 2 | |||
| SMBSE | Standard deviation of mean-value estimation | MBS_SMBSE | FLTP | 16 | 16 | |||
SBSE foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| SBSE | BSTAR | SBSE | BSTAR | T064A | Physical Inventory Stock Types | BSTAR |
| SBSE | LGNUM | SBSE | MANDT | T300 | WM Warehouse Numbers | MANDT |
| SBSE | LGNUM | SBSE | LGNUM | T300 | WM Warehouse Numbers | LGNUM |
| SBSE | LGORT | SBSE | MANDT | T001L | Storage Locations | MANDT |
| SBSE | LGORT | SBSE | WERKS | T001L | Storage Locations | WERKS |
| SBSE | LGORT | SBSE | LGORT | T001L | Storage Locations | LGORT |
| SBSE | LGTYP | SBSE | MANDT | T301 | WM Storage Types | MANDT |
| SBSE | LGTYP | SBSE | LGNUM | T301 | WM Storage Types | LGNUM |
| SBSE | LGTYP | SBSE | LGTYP | T301 | WM Storage Types | LGTYP |
| SBSE | MANDT | SBSE | MANDT | T000 | Clients | MANDT |
| SBSE | MTART | SBSE | MANDT | T134 | Material Types | MANDT |
| SBSE | MTART | SBSE | MTART | T134 | Material Types | MTART |
| SBSE | WAERS | SBSE | MANDT | TCURC | Currency Codes | MANDT |
| SBSE | WAERS | SBSE | WAERS | TCURC | Currency Codes | WAERS |
| SBSE | WERKS | SBSE | MANDT | T001W | Plants/Branches | MANDT |
| SBSE | WERKS | SBSE | WERKS | T001W | Plants/Branches | WERKS |
