SAP Table
CABN Characteristic
SAP table CABN has 3 primary key fields being MANDT,ATINN,ADZHL.
If you are only analysing data from a single SAP instance you may omit field MANDT in your relationships as it will be the same across the entire dataset. On the other hand, if you are combining data from multiple SAP instances you need to take MANDT into account.
/ Fields
CABN columns.
| Field | Description | Data Type | Length | Decimals | Checktable | Data Element | |||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| KeyMANDT | Client | CLNT | 3 | 0 | T000 | MANDT | |||||||||||||
| KeyATINN | Internal characteristic | NUMC | 10 | 0 | ATINN | ||||||||||||||
| KeyADZHL | 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 | ||||||||||||||
|
|||||||||||||||||||
| 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 | ||||||||||||||
|
|||||||||||||||||||
| 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 | ||||||||||||||
/ Relationships
CABN foreign keys.
| Table | Field | Check Table | Description | Check Field |
|---|---|---|---|---|
| CABN | AENNR | AENR | Change Master | AENNR |
| CABN | ATKLA | TCMG | Characteristics Groups | MANDT |
| CABN | ATKLA | TCMG | Characteristics Groups | ATKLA |
| CABN | ATMST | TCMS | Characteristic Status | MANDT |
| CABN | CLINT | KLAH | Class Header Data | MANDT |
| CABN | CLINT | KLAH | Class Header Data | CLINT |
| CABN | MANDT | T000 | Clients | MANDT |
| CABN | MSEHI | T006 | Units of Measurement | MANDT |