CABN SAP (Characteristic) Table details
Dictionary Type: Table
Description: Characteristic
Description: Characteristic
Table field list including key, data, relationships and ABAP select examples
CABN is a standard SAP Table which is used to store Characteristic data and is available within R/3 SAP systems depending on the version and release level.
The CABN table consists of various fields, each holding specific information or linking keys about Characteristic data available in SAP. These include ATINN (Internal characteristic), ADZHL (Internal counter for archiving objects via engin. chg. mgmt), ATNAM (Characteristic Name), ATIDN (Object identification).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
Text table = CABNT
SAP CABN table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
ATINN | Internal characteristic | ATINN | NUMC | 10 | ATINN | ATINN | |||
ADZHL | Internal counter for archiving objects via engin. chg. mgmt | ADZHL | NUMC | 4 | NUMC4 | ||||
ATNAM | Characteristic Name | ATNAM | CHAR | 30 | ATNAM | FEA | |||
ATIDN | Object identification | ATIDN | CHAR | 2 | ATIDN | FEI | |||
ATFOR | Data type of characteristic | ATFOR | CHAR | 4 | ATFOR | ||||
ANZST | Number of Characters | ANZST | INT2 | 5 | ANZST | ||||
ANZDZ | Number of Decimal Places | ANZDZ | INT2 | 5 | ANZDZ | ||||
ATVOR | Value with Plus or Minus Sign | ATVOR | CHAR | 1 | XFELD | ||||
ATSCH | Value with template | ATSCH | CHAR | 30 | CHAR30 | ||||
ATKLE | Case Sensitive | ATKLE | CHAR | 1 | XFELD | ||||
ATKON | Name of Conversion Routine | ATKON | CHAR | 5 | UCNV_____4 | ||||
ATEND | Aggregating characteristic | ATEND | CHAR | 1 | ATXFE | ||||
ATAEN | Balance characteristic | ATAEN | CHAR | 1 | XFELD | ||||
ATKLA | Chars Group | ATKLA | CHAR | 10 | TCMG | ATKLA | |||
ATERF | Entry Required | ATERF | CHAR | 1 | ATXFE | ||||
ATEIN | Single value | ATEIN | CHAR | 1 | XFELD | ||||
ATAME | Multilingual characteristic | ATAME | CHAR | 1 | XFELD | ||||
ATWME | Values in more than one language | ATWME | CHAR | 1 | XFELD | ||||
MSEHI | Unit of Measurement | MSEHI | UNIT | 3 | T006 | CUNIT | MEINS | ||
ATDIM | Exponent display | ATDIM | INT2 | 5 | EXP10 | ||||
ATGLO | Indicator: Whether You Can Make an Entry for Ref. Chars | ATGLO | CHAR | 1 | ATXFE | ||||
ATGLA | Indicator: restrictable characteristic | ATGLA | CHAR | 1 | XFELD | ||||
ATINT | Interval Values Allowed | ATINT | CHAR | 1 | ATXFE | ||||
ATUNS | Entry Required in Configuration | ATUNS | CHAR | 1 | ATXFE | ||||
ATSON | Indicator: Additional Values | ATSON | CHAR | 1 | ATXFE | ||||
ATTAB | Table Name | ATTAB | CHAR | 30 | UDTAB | ||||
ATFEL | Field Name | ATFEL | CHAR | 30 | Assigned to domain | FDNAME | |||
ATTEI | Field Name for Unit | ATTEI | CHAR | 30 | Assigned to domain | FDNAME | |||
ATPRT | Check table | ATPRT | CHAR | 30 | UDTAB | ||||
ATPRR | Name of Check Report Program | ATPRR | CHAR | 40 | DDREPNAME | ||||
ATPRF | Function Module for Checking Values | ATPRF | CHAR | 30 | ATPRF | ||||
ATWRD | Display Allowed Values Defined in Characteristic | ATWRD | CHAR | 1 | ATXFE | ||||
ATFOD | Unformatted Entry Control | ATFOD | CHAR | 1 | ATXFE | ||||
ATHIE | Explode value hierarchy | ATHIE | CHAR | 1 | ATXFE | ||||
ATDEX | Exponent Display Format | ATDEX | NUMC | 1 | ATDEX | ||||
ATFGA | Indicator: formatted editing | ATFGA | CHAR | 1 | XFELD | ||||
ATVSC | Indicator: Display Template When Assigning Values | ATVSC | CHAR | 1 | ATXFE | ||||
ANAME | Name of Person who Created the Object | ERNAM | CHAR | 12 | USNAM | ||||
ADATU | Date on Which Record Was Created | ERDAT | DATS | 8 | DATUM | ||||
VNAME | Name of Person Who Changed Object | AENAM | CHAR | 12 | USNAM | ||||
VDATU | Changed On | AEDAT | DATS | 8 | DATUM | ||||
ATXAC | Indicator for Multiple Table Assignments | ATXAC | CHAR | 1 | XFELD | ||||
ATYAC | Indicator: Align Characteristic Values to the Right | ATYAC | CHAR | 1 | ATXFE | ||||
ATMST | Status of a characteristic | ATMST | CHAR | 1 | TCMS | ATMST | |||
ATWSO | Display of Allowed Values | ATWSO | CHAR | 1 | ATSOR | ||||
ATBSO | Display of values assigned to a characteristic | ATBSO | CHAR | 1 | ATSOR | ||||
DATUV | Valid-From Date | DATUV | DATS | 8 | DATUM | ||||
TECHV | Technical status from | TECHV | CHAR | 12 | TECHS | ||||
AENNR | Change Number | AENNR | CHAR | 12 | AENR | AENNR | AENNR | AEN | |
LKENZ | Deletion Indicator | LKENZ | CHAR | 1 | XFELD | ||||
ATWRI | Indicator: Keep Sequence in Value Assignment | ATWRI | CHAR | 1 | XFELD | ||||
DOKAR | Document Type | DOKAR | CHAR | 3 | Assigned to domain | DOKAR | CV2 | ||
DOKNR | Document number | DOKNR | CHAR | 25 | Assigned to domain | ALPHA | DOKNR | CV1 | |
DOKVR | Document Version | DOKVR | CHAR | 2 | DOKVR | CV3 | |||
DOKTL | Document Part | DOKTL_D | CHAR | 3 | DOKTL | CV4 | |||
KNOBJ | Number of Object with Assigned Dependencies | KNOBJ | NUMC | 18 | KNOBJ | ||||
ATINP | No Entry Can be Made for Characteristic | ATINP | CHAR | 1 | ATXFE | ||||
ATVIE | Characteristic Not to be Displayed | ATVIE | CHAR | 1 | ATXFE | ||||
WERKS | Plant | WERKS_D | CHAR | 4 | Assigned to domain | WERKS | WRK | H_T001W_C | |
KATALOGART | Catalog | QKATART_CL | CHAR | 1 | QKATART_CL | ||||
AUSWAHLMGE | Selected Set | QAUSWAHLMG_CL | CHAR | 8 | QAUSWAHLMG_CL | ||||
ATHKA | Indicator: display node in a value hierarchy | ATHKA | CHAR | 1 | ATXFE | ||||
ATHKO | Indicator: nodes are selectable | ATHKO | CHAR | 1 | ATXFE | ||||
CLINT | Internal Class Number | CLINT | NUMC | 10 | KLAH | CLINT | |||
ATTOL | Indicator for Allowed Tolerances | ATTOL | CHAR | 1 | ATXFE | ||||
ATZUS | Indicator: Values Can Be Assigned to Ref. Characteristics | ATZUS | CHAR | 1 | XFELD | ||||
ATVPL | Relevant to Planning | ATVPL | CHAR | 1 | XFELD | ||||
ATAUTH | Authorization Group for Characteristics Maintenance | ATAUTH | CHAR | 3 | CHAR3 | ||||
COUNTRYGRP | Characteristic is Country-Dependent | COUNTRYGRP | CHAR | 1 | XFELD |
Key field | Non-key field |
How do I retrieve data from SAP table CABN using ABAP code
The following ABAP code Example will allow you to do a basic selection on CABN to SELECT all data from the tableDATA: WA_CABN TYPE CABN.
SELECT SINGLE *
FROM CABN
INTO CORRESPONDING FIELDS OF WA_CABN
WHERE...
How to access SAP table CABN
Within an ECC or HANA version of SAP you can also view further information about CABN and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects