SAP table CABN (Characteristic)

SAP table CABN has 3 primary key fields being MANDT,ATINN,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
MANDT Client CLNT 3 0 T000 MANDT
ATINN Internal characteristic NUMC 10 0 ATINN
ADZHL Internal Counter for Archiving Objects by ECM NUMC 4 0 ADZHL
ATNAM Characteristic Name CHAR 30 0 ATNAM
ATIDN Object identification CHAR 2 0 ATIDN
ATFOR Data type of characteristic CHAR 4 0 ATFOR
CHAR Character Format
CURR Currency Format
DATE Date Format
NUM Numeric Format
TIME Time Format
UDEF User-Defined Data Type
ANZST Number of Characters INT2 5 0 ANZST
ANZDZ Number of Decimal Places INT2 5 0 ANZDZ
ATVOR Value with Plus or Minus Sign CHAR 1 0 ATVOR
ATSCH Value with template CHAR 70 0 ATSCH
ATKLE Case Sensitive CHAR 1 0 ATKLE
ATKON Name of Conversion Routine CHAR 5 0 ATKON
ATEND Aggregating characteristic CHAR 1 0 ATEND
ATAEN Balance characteristic CHAR 1 0 ATAEN
ATKLA Characteristics Group CHAR 10 0 TCMG ATKLA
ATERF Entry Required CHAR 1 0 ATERF
ATEIN Single Value CHAR 1 0 ATEIN
ATAME Multilingual characteristic CHAR 1 0 ATAME
ATWME Values in more than one language CHAR 1 0 ATWME
MSEHI Unit of Measurement UNIT 3 0 T006 MSEHI
ATDIM Exponent display INT2 5 0 ATDIM
ATGLO Indicator: Whether You Can Make an Entry for Ref. Chars CHAR 1 0 ATGLO
ATGLA Indicator: restrictable characteristic CHAR 1 0 ATGLA
ATINT Interval Values Allowed CHAR 1 0 ATINT
ATUNS Entry Required in Configuration CHAR 1 0 ATUNS
ATSON Indicator: Additional Values CHAR 1 0 ATSON
ATTAB Table Name CHAR 30 0 ATTAB
ATFEL Field Name CHAR 30 0 ATFEL
ATTEI Field Name for Unit CHAR 30 0 ATTEI
ATPRT Check table CHAR 30 0 ATPRT
ATPRR Name of Check Report Program CHAR 40 0 ATPRR
ATPRF Function Module for Checking Values CHAR 30 0 ATPRF
ATWRD Display Allowed Values Defined in Characteristic CHAR 1 0 ATWRD
ATFOD Unformatted Entry Control CHAR 1 0 ATFOD
ATHIE Explode value hierarchy CHAR 1 0 ATHIE
ATDEX Exponent Display Format NUMC 1 0 ATDEX
0 No exponent
1 Standard
2 Exponent entered
3 Scientific exponent
ATFGA Indicator: formatted editing CHAR 1 0 ATFGA
ATVSC Indicator: Display Template When Assigning Values CHAR 1 0 ATVSC
ANAME Name of Person Responsible for Creating the Object CHAR 12 0 ERNAM
ADATU Date on which the record was created DATS 8 0 ERDAT
VNAME Name of Person Who Changed Object CHAR 12 0 AENAM
VDATU Last Changed On DATS 8 0 AEDAT
ATXAC Indicator for Multiple Table Assignments CHAR 1 0 ATXAC
ATYAC Indicator: Align Characteristic Values to the Right CHAR 1 0 ATYAC
ATMST Status of a characteristic CHAR 1 0 TCMS ATMST
ATWSO Display of Allowed Values CHAR 1 0 ATWSO
ATBSO Display of values assigned to a characteristic CHAR 1 0 ATBSO
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
ATWRI Indicator: Keep Order in Value Assignment CHAR 1 0 ATWRI
DOKAR Document Type CHAR 3 0 DOKAR
DOKNR Document number CHAR 25 0 DOKNR
DOKVR Document Version CHAR 2 0 DOKVR
DOKTL Document Part CHAR 3 0 DOKTL_D
KNOBJ Number of Object with Assigned Dependencies NUMC 18 0 KNOBJ
ATINP No Entry Can be Made for Characteristic CHAR 1 0 ATINP
ATVIE Characteristic Not to be Displayed CHAR 1 0 ATVIE
WERKS Plant CHAR 4 0 WERKS_D
KATALOGART Catalog CHAR 1 0 QKATART_CL
AUSWAHLMGE Selected Set CHAR 8 0 QAUSWAHLMG_CL
ATHKA Indicator: display node in a value hierarchy CHAR 1 0 ATHKA
ATHKO Indicator: nodes are selectable CHAR 1 0 ATHKO
CLINT Internal Class Number NUMC 10 0 KLAH CLINT
ATTOL Indicator for Allowed Tolerances CHAR 1 0 ATTOL
ATZUS Indicator: Values Can Be Assigned to Ref. Characteristics CHAR 1 0 ATZUS
ATVPL Relevant to Planning CHAR 1 0 ATVPL
ATAUTH Authorization Group for Characteristics Maintenance CHAR 3 0 ATAUTH
COUNTRYGRP Characteristic is Country/Region-Dependent CHAR 1 0 COUNTRYGRP
DATUB Valid-to date DATS 8 0 DATUB
LASTCHANGEDDATETIME UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun) DEC 21 7 TIMESTAMPL
UNIT Unit of Measurement UNIT 3 0 MSEHI
CURRENCY Currency Key CUKY 5 0 WAERS_CURC

CABN foreign key relationships

Table Field Check Table Check Field
0 CABN AENNR AENR Change Master AENNR
1 CABN ATKLA TCMG Characteristics Groups MANDT
1 CABN ATKLA TCMG Characteristics Groups ATKLA
0 CABN ATMST TCMS Characteristic Status MANDT
1 CABN CLINT KLAH Class Header Data MANDT
1 CABN CLINT KLAH Class Header Data CLINT
0 CABN MANDT T000 Clients MANDT
1 CABN MSEHI T006 Units of Measurement MANDT