SAP table STAS (BOMs - Item Selection)
SAP table STAS has 6 primary key fields being MANDT,STLTY,STLNR,STLAL,STLKN,STASZ.
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
Client
CLNT
3
0
T000
MANDT
BOM category
CHAR
1
0
STLTY
Possible values
D
Document Structure
E
Equipment BOM
K
Order BOM
M
Material BOM
P
Work Breakdown Structure BOM
S
Standard BOM
T
Functional Location BOM
Bill of Material
CHAR
8
0
STNUM
Alternative BOM
CHAR
2
0
STALT
BOM item node number
NUMC
8
0
STLKN
Internal counter
NUMC
8
0
CIM_COUNT
DATUV
Valid-From Date
DATS
8
0
DATUV
TECHV
Technical status from
CHAR
12
0
TECHV
AENNR
Change Number
CHAR
12
0
AENR
AENNR
LKENZ
Deletion Indicator
CHAR
1
0
LKENZ
ANDAT
Date Record Created On
DATS
8
0
ANDAT
ANNAM
User who created record
CHAR
12
0
ANNAM
AEDAT
Last Changed On
DATS
8
0
AEDAT
AENAM
Name of Person Who Changed Object
CHAR
12
0
AENAM
DVDAT
Date of last date shift
DATS
8
0
DVDAT
DVNAM
Name of the user who carried out the date shift
CHAR
12
0
DVNAM
AEHLP
Date Shift Hierarchy Indicator
NUMC
2
0
CC_AEHLP
STVKN
Inherited node number of BOM item
NUMC
8
0
STVKN
IDPOS
Item group
CHAR
20
0
CS_IDPOS
IDVAR
Component Variant
CHAR
5
0
CS_IDVAR
LPSRT
Sort key within a logical item
NUMC
4
0
CS_LPSRT
BOM_VERSN
BOM Version
CHAR
4
0
BOM_VERSION
STAS foreign key relationships
Table
Field
Check Table
Check Field
0 STAS
AENNR
AENR Change Master
AENNR