SAP table KSML (Characteristics of a Class)
SAP table KSML has 4 primary key fields being MANDT,CLINT,POSNR,ADZHL.
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
Internal Class Number
NUMC
10
0
KLAH
CLINT
Item number
NUMC
3
0
KPOSNR
Internal Counter for Archiving Objects by ECM
NUMC
4
0
ADZHL
ABTEI
Organizational Area
CHAR
10
0
ABTEILUNG
DINKB
Code letter
CHAR
3
0
DINKENNBU
HERKU
Characteristic origin
CHAR
10
0
HERKUNFT
IMERK
Internal characteristic
NUMC
10
0
ATINN
OMERK
Object-Dependent Characteristic
NUMC
10
0
ATINO
KLART
Class Type
CHAR
3
0
TCLA
KLASSENART
RELEV
Relevancy Indicator
CHAR
1
0
RELEVANZKZ
Possible values
1
For info only
2
Relevant to variants
3
Logistics unit of measure
DATUV
Valid-From Date
DATS
8
0
DATUV
TECHV
Indicator: changed with new effectivity
CHAR
12
0
KZEFFE
AENNR
Change Number
CHAR
12
0
AENR
AENNR
LKENZ
Deletion Indicator
CHAR
1
0
LKENZ
VMERK
New characteristic without values
CHAR
1
0
VMERK
DPLEN
Field output length
NUMC
3
0
DPLENG
OFFST
Offset in work area
INT2
5
0
OFFSET
BLLIN
Line Number in Block
NUMC
2
0
BLZEIL
DPTXT
Display Text Instead of Content
CHAR
1
0
ANZTEXT
CUSTR
Text, 40 Characters Long
CHAR
40
0
TEXT40
JUSTR
Display right-justified
CHAR
1
0
RECHTS
COLOR
Color
CHAR
1
0
FARBE
Possible values
Background color
0
No color
1
Color 1 (color settings)
2
Color 2
3
Color 3
4
Color 4
5
Color 5
6
Color 6
7
Color 7
INTSF
Highlighted
CHAR
1
0
INTSF
Possible values
Global settings
0
Highlighting off
1
Highlighting on
INVER
Inverse
CHAR
1
0
INVER
Possible values
Global settings
0
Inverse off
1
Inverse on
CKBOX
Checkbox
INT4
10
0
CKBOX
Possible values
INPUT
Entry
INT4
10
0
EINGAB
AMERK
Relevancy indicator (print, search, display)
NUMC
10
0
RELEVKZ
MKENN
Standard Code Letter
CHAR
15
0
DINKENN
DATUB
Valid-to date
DATS
8
0
DATUB
PPREL
Proportion/Product Unit Relevant
CHAR
1
0
PPREL
EWM_REL
EWM Relevant
CHAR
1
0
EWM_REL
PROP_REL
Proposal Relevant
CHAR
1
0
PROP_REL
KSML foreign key relationships
Table
Field
Check Table
Check Field
0 KSML
AENNR
AENR Change Master
AENNR
1 KSML
CLINT
KLAH Class Header Data
MANDT
1 KSML
CLINT
KLAH Class Header Data
CLINT
0 KSML
KLART
TCLA Class Types
MANDT
1 KSML
MANDT
T000 Clients
MANDT