SAP Table SPTAB
Table of Material Master Tables with Full Key
SPTAB (Table of Material Master Tables with Full Key) 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 SPTAB to other SAP tables.
SPTAB table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MATNR | Material Number | MATNR | CHAR | 18 | 0 | |||||||||
| VKORG | Sales Organization | VKORG | CHAR | 4 | 0 | |||||||||
| VTWEG | Distribution Channel | VTWEG | CHAR | 2 | 0 | |||||||||
| WERKS | Plant | WERKS_D | CHAR | 4 | 0 | |||||||||
| LGORT | Storage Location | LGORT_D | CHAR | 4 | 0 | |||||||||
| LGNUM | Warehouse Number / Warehouse Complex | LGNUM | CHAR | 3 | 0 | |||||||||
| LGTYP | Storage Type | LGTYP | CHAR | 3 | 0 | |||||||||
| BWKEY | Valuation Area | BWKEY | CHAR | 4 | 0 | |||||||||
| BWTAR | Valuation Type | BWTAR_D | CHAR | 10 | 0 | |||||||||
| MYKEY | LIFO valuation level | MYKEY | CHAR | 4 | 0 | |||||||||
| TBNAM | Table name | TBNAM | CHAR | 30 | 0 | |||||||||
| RCODE | Return Code | SYSUBRC | INT4 | 10 | 0 | |||||||||
| KZMUS | Exactly One Entry of Material Master Table is Relevant | KZMUS | CHAR | 1 | 0 |
Possible values
|
||||||||
| KZSTA | Indicator: Status-relevant | KZSTA | CHAR | 1 | 0 |
Possible values
|
||||||||
| UPDKZ | Update indicator | UPDKZ_D | CHAR | 1 | 0 | |||||||||
| BISTSTAT | Maintenance status | PSTAT_D | CHAR | 15 | 0 | |||||||||
| PFSTATUS | Maintenance status | PSTAT_D | CHAR | 15 | 0 | |||||||||
| AKTVST_I | Maintenance status | PSTAT_D | CHAR | 15 | 0 | |||||||||
| AKTVST_U | Maintenance status | PSTAT_D | CHAR | 15 | 0 | |||||||||
| AKTVST_D | Maintenance status | PSTAT_D | CHAR | 15 | 0 | |||||||||
| AKTVST_G | Maintenance status | PSTAT_D | CHAR | 15 | 0 | |||||||||
| RPSRF | Referenced status for retail | RPSRF | CHAR | 15 | 0 | |||||||||
| BERID | MRP Area | BERID | CHAR | 10 | 0 | |||||||||
| BERTY | Type of MRP area | BERTY | NUMC | 2 | 0 |
Possible values
|
||||||||
