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 | Possible values | ||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||
|
||||||||||||||
|
KZSTA
Indicator: Status-relevant
|
KZSTA |
CHAR
|
1 | 0 | ||||||||||
|
||||||||||||||
|
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 | ||||||||||
|
||||||||||||||