1. Home
  2. Resources
  3. SAP Tables
  4. KSML_SEL - KSML w/ additional characteristic data for object selection

SAP Table KSML_SEL

KSML w/ additional characteristic data for object selection

KSML_SEL (KSML w/ additional characteristic data for object selection) 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 KSML_SEL to other SAP tables.

KSML_SEL table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
CLINT Internal Class Number CLINT KLAH NUMC 10 0
POSNR Item number KPOSNR NUMC 3 0
ADZHL Internal counter for archiving objects via engin. chg. mgmt ADZHL NUMC 4 0
ABTEI Organizational Area ABTEILUNG CHAR 10 0
DINKB Code letter DINKENNBU CHAR 3 0
HERKU Characteristic origin HERKUNFT CHAR 10 0
IMERK Internal characteristic ATINN NUMC 10 0
OMERK Object-Dependent Characteristic ATINO NUMC 10 0
KLART Class Type KLASSENART TCLA CHAR 3 0
RELEV Relevancy Indicator RELEVANZKZ CHAR 1 0
1 For info only
2 Relevant to variants
3 Logistics unit of measure
DATUV Valid-From Date DATUV DATS 8 0
TECHV Indicator: changed with new effectivity KZEFFE CHAR 12 0
AENNR Change Number AENNR AENR CHAR 12 0
LKENZ Deletion Indicator LKENZ CHAR 1 0
X Yes
NULL No
VMERK New characteristic without values VMERK CHAR 1 0
X Yes
NULL No
DPLEN Field output length DPLENG NUMC 3 0
OFFST Offset in work area OFFSET INT2 5 0
BLLIN Line Number in Block BLZEIL NUMC 2 0
DPTXT Display Text Instead of Content ANZTEXT CHAR 1 0
NULL Field Contents, Not Text
1 Short Keyword
2 Medium Keyword
3 Long Keyword
4 Report Header
5 Language-Independent Heading
6 Underscore Line
7 Vertical Line
8 Blank Line
CUSTR Text, 40 Characters Long TEXT40 CHAR 40 0
JUSTR Display right-justified RECHTS CHAR 1 0
X Yes
NULL No
COLOR Color FARBE CHAR 1 0
NULL 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 INTSF CHAR 1 0
NULL Global settings
0 Highlighting off
1 Highlighting on
INVER Inverse INVER CHAR 1 0
NULL Global settings
0 Inverse off
1 Inverse on
CKBOX Checkbox CKBOX INT4 10 0
0 No Checkbox
1 Checkbox
INPUT Entry EINGAB INT4 10 0
0 No entry possible
1 Entry possible
AMERK Relevancy indicator (print, search, display) RELEVKZ NUMC 10 0
MKENN Standard Code Letter DINKENN CHAR 15 0
ATNAM Characteristic Name ATNAM CHAR 30 0
ATFOR Data type of characteristic ATFOR CHAR 4 0
CHAR Character Format
CURR Currency Format
DATE Date Format
NUM Numeric Format
TIME Time Format
UDEF User-Defined Data Type
POSITION Item number KPOSNR NUMC 3 0
ATAME Multilingual characteristic ATAME CHAR 1 0
X Yes
NULL No
ATWME Values in more than one language ATWME CHAR 1 0
X Yes
NULL No
ATBEZ Characteristic description ATBEZ CHAR 30 0
ATINT Interval Values Allowed ATINT CHAR 1 0
X Yes
NULL No
* Reference indicator
ATEIN Single value ATEIN CHAR 1 0
X Yes
NULL No
ATSCH Value with template ATSCH CHAR 30 0
ATKLE Case Sensitive ATKLE CHAR 1 0
X Yes
NULL No

KSML_SEL foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
KSML_SEL AENNR KSML_SEL MANDT AENR Change Master MANDT
KSML_SEL AENNR KSML_SEL AENNR AENR Change Master AENNR
KSML_SEL CLINT KSML_SEL MANDT KLAH Class Header Data MANDT
KSML_SEL CLINT KSML_SEL CLINT KLAH Class Header Data CLINT
KSML_SEL KLART KSML_SEL MANDT TCLA Class Types MANDT
KSML_SEL KLART KSML_SEL KLART TCLA Class Types KLART
KSML_SEL MANDT KSML_SEL MANDT T000 Clients MANDT