speech

sap class characteristic assignment table

My Experiments with ABAP

SAP Classification System – CDS Modelling

The SAP classification system allows you to use characteristics to describe all types of objects and to group similar objects in classes. Class and classification are used to find objects more easily later. In this blog, I’ll explain tables and model these using CDS.

We will use material class in the blog to explore the classification system. We will start by defining characteristics like carbohydrate, fat, fiber, protein, Iron, Manganese etc. then we will club these characteristics together into two classes – macro and micronutrient.

Introduction to SAP Classification System and Tables

Characteristics.

Characteristics are defined in the transaction CT04 . There is a lot you can define here for characteristics along with descriptions in various languages, and restrictions on which class type they are valid for.

sap class characteristic assignment table

Most of this information will be stored in table CABN .

sap class characteristic assignment table

CDS- I_ClfnCharcBasic, I_Relstartchar, I_Characteristic .

A class is used to group classifications together, is defined in transaction CL01. While defining class, a class type needs to be specified. Class type usually defines the object we are working with. In this particular case, its Material hence class type 001.

sap class characteristic assignment table

Class header data is stored in table KSSK and KLAH

sap class characteristic assignment table

CDS: I_ClassHeader, I_ClfnClass, I_Relstratclass

Assign Characteristics to Class

In the same transaction CL01 under ‘ Char. ‘ tab characteristics are assigned to the class.

sap class characteristic assignment table

These relationships between class and characteristic are stored in table KSML .

sap class characteristic assignment table

CDS: I_ClfnClassCharcBasic

Using Class and Classification in Object

Objects which support classification usually have a screen where you can assign class to it and specify values to characteristics. I’ve assigned class and ZMACRONUTRIENT and ZMICRONUTRIENT (and one more) to material 262 and specified values for characteristics.

Values to object can also be defined in generic transaction CL20N .

sap class characteristic assignment table

These values against the object, Material in this case, are stored in table AUSP.

Classification can be of type character, numeric, date, time or range. To support all these types of values AUSP table has quite a few columns ATWRT, ATFLV, DEC_VALUE_FROM, DEC_VALUE_TO, DATE_FROM, DATE_TO, TIME_FROM, TIME_TO.

Class type can be assigned to exactly one object or multiple (TCLA-MULTOBJ). Depending on this restriction you can either select values from AUSP directly with the object key (Material number) or you first get the internal object number from INOB then you go to AUSP.

In the system I am working flag TCLA-MULTOBJ is set for class type 001 hence using INOB to get to AUSP.

Object to class assignment is stored in table KSSK. I have not included that in the below screenshot.

sap class characteristic assignment table

Where flag TCLA-MULTOBJ is not set, you can directly go to table AUSP with object key value in AUSP-OBJEK.

CDS: I_ClfnObjectCharcValueBasic

CDS: I_ClfnInternalIdObjectMapping (INOB Mapping)

sap class characteristic assignment table

SAP Classification (CA-CL)

CDS Modelling

Taking inspiration from CL20N or MM03 I have modelled the data in three layers; Object, Class (Assignment) and Characteristics values.

CDS ZI_CProduct has Product detail and its internal classification number (INOB). CDS ZI_CProdClass has classes assigned to Products and CDS ZI_CProdChValues has values specified under characteristics for Product.

For my test Product 262, data looks like this.

sap class characteristic assignment table

Fiori App using Odata service and list and object page UI annotation

sap class characteristic assignment table

CDS ZI_CProduct

CDS for Object key and its Internal classification number. For the reason explained earlier to get classification values for Material I need to go through INOB table. CDS is exposed as OData service in the Fiori example I used. Association to Class and Characteristics are used in Object Page.

sap class characteristic assignment table

CDS ZI_CProdClass

CDS model class assigned to product

sap class characteristic assignment table

CDS ZI_CProdChValues

CDS brings characteristics values from AUSP.

sap class characteristic assignment table

Quick Reference

SPRO: SAP Customizing Implementation Guide->Cross-Application Components->Classification System

Transactions: CT04 , CL01, CL20N

Tables: KSSK, KLAH, CABN, KSML, INOB, AUSP

Share this:

  • Click to share on Facebook (Opens in new window)
  • Click to share on Twitter (Opens in new window)
  • Click to share on LinkedIn (Opens in new window)

Related Articles

Sap list of inactive objects, sap fiori application translation, sap fiori variant management, leave a reply cancel reply.

SAP Logo

1820783 - Characteristic value assignments and classification

A single characteristic value is selected for a characteristic in the classification view of a material master (MM01, MM02) or the configuration profile (CU41, CU42). As a result, this characteristic value is the assigned value for this characteristic in the configuration of sales orders.

Classification, Characteristic, Chararcteristic Value, Default, Restriction, Precondition, MM01, MM02, CU41, CU42, CL20N , KBA , LO-VC , Variant Configuration , How To

About this page

Search for additional results.

Visit SAP Support Portal's SAP Notes and KBA Search .

Privacy | Terms of use | Legal Disclosure | Copyright | Trademark

Class characteristic Table in SAP

  • T242B Table for Characteristic values per characteristic Table Type : TRANSP Package : KC Module : CRM
  • TIVXCSCCHMPATTRI Table for Assignment of Characteristic ID to Characteristic Table Type : TRANSP Package : RE_XC_SC_CH Module : RE-FX
  • COMM_SCECHAINP Table for No User Entry for Characteristic of Class Table Type : TRANSP Package : COM_SCE_DB Module : CRM-BF-CFG
  • COMM_SCECHAPOS Table for Position of Characteristic in Class Table Type : TRANSP Package : COM_SCE_DB Module : CRM-BF-CFG
  • COMM_SCECHAVIS Table for Characteristic of Class Hidden/Shown Table Type : TRANSP Package : COM_SCE_DB Module : CRM-BF-CFG
  • COMM_SCECLNDOM Table for Allowed Values for Numeric Characteristic of Class Table Type : TRANSP Package : COM_SCE_DB Module : CRM-BF-CFG
  • COMM_SCECLSDOM Table for Allowed Values of Alphanumeric Characteristic of Class Table Type : TRANSP Package : COM_SCE_DB Module : CRM-BF-CFG
  • COMM_SCEINVIEW Table for Assignment of Characteristic of Class to Org. Area Table Type : TRANSP Package : COM_SCE_DB Module : CRM-BF-CFG
  • COMM_SCEVIEW Table for Assignment of Characteristic of Class to Org. Area Table Type : TRANSP Package : COM_SCE_DB Module : CRM-BF-CFG
  • OIISOCKL Table for SOC: Storage object characteristic class Table Type : TRANSP Package : OII Module : IS-OIL-DS-BDR
  • RSMRMT_C_CLS_ATR Table for Coupon Redemption Model - Class Characteristic List Table Type : TRANSP Package : RSMRM_CORM Module : BW-BCT-CRM
  • RSMRMT_C_CLS_REL Table for CoRM Model Results -> Class to Characteristic Value Relation Table Type : TRANSP Package : RSMRM_CORM Module : BW-BCT-CRM
  • SCECHAINP Table for No User Entry for Characteristic of Class Table Type : TRANSP Package : VSCE Module : CRM-BF-CFG
  • SCECHAPOS Table for Position of Characteristic in Class Table Type : TRANSP Package : VSCE Module : CRM-BF-CFG
  • SCECHAVIS Table for Characteristic of Class Hidden/Shown Table Type : TRANSP Package : VSCE Module : CRM-BF-CFG
  • SCECLNDOM Table for Allowed Values for Numeric Characteristic of Class Table Type : TRANSP Package : VSCE Module : CRM-BF-CFG
  • SCECLSDOM Table for Allowed Values of Alphanumeric Characteristic of Class Table Type : TRANSP Package : VSCE Module : CRM-BF-CFG
  • SCEINVIEW Table for Allocation of Characteristic of Class to Org. Area Table Type : TRANSP Package : VSCE Module : CRM-BF-CFG
  • TCG66 Table for EHS: Value Assignment Type Class Characteristic Table Type : TRANSP Package : CBEHS_BAS Module : CA-GTF-EHS
  • CDBC_BP_CATATTR Table for CDB BP: Assignment Class. Categorie -> Class.-Criteria Table Type : TRANSP Package : CDB Module : CRM-MSA
  • CDBC_BP_CATCRIT Table for CDB BP: Assignment Class. Categorie -> Class.-Criteria Table Type : TRANSP Package : CDB Module : CRM-MSA
  • CLASS_INCL Table for Archiving class which contains other archiving class Table Type : TRANSP Package : SARC Module : BC-CCM-ADK
  • CNV_00300_MAPSPC Table for CWB-ME Interface - Template ID - Profile Class - Check Class Table Type : TRANSP Package : CNV_00300 Module : CA-EUR
  • CRMC_BP_CATATTR Table for CRM BP: Assignment Class. Categorie -> Class.-Criteria Table Type : TRANSP Package : CRM_BUPA_CLASSIFICATION_MD Module : CRM-MD-BP
  • CRMC_BP_CATCRIT Table for CRM BP: Assignment Class. Categorie -> Class.-Criteria Table Type : TRANSP Package : CRM_BUPA_CLASSIFICATION_MD Module : CRM-MD-BP
  • KLLRDEF02 Table for Definition of Credit Equivalent Class (CEQ Class) Table Type : TRANSP Package : FTBK01 Module : IS-B-RA-CL
  • KLLRDEF02T Table for Text Table for Credit Equivalent Class (CEQ Class) Table Type : TRANSP Package : FTBK01 Module : IS-B-RA-CL
  • KLLRDEF03 Table for Definition of Loss Equivalent Class (LEQ Class) Table Type : TRANSP Package : FTBK01 Module : IS-B-RA-CL
  • TCACS_XHCRES Table for ICM Standard Contract: Handling Class By Exception Class Table Type : TRANSP Package : CACSC7 Module : ICM
  • UISSPPACCESS Table for Standard settings for access class and UI class for entity Table Type : TRANSP Package : UISS_MDG_CONTENT Module : CA-MDG-APP-ISS
  • UISSPPACCESS_C Table for Customizing for access class and UI class for entity Table Type : TRANSP Package : UISS_MDG_CONTENT Module : CA-MDG-APP-ISS
  • UISSPPACCESS_S Table for Customizing for access class and UI class for entity Table Type : TRANSP Package : UISS_MDG_CONTENT Module : CA-MDG-APP-ISS
  • /BEV3/CHBRKRAZ Table for Combination Rule Class/Rule Attribute/Agreement Class Table Type : TRANSP Package : /BEV3/CH Module : SD-SLS-PLL-OBS
  • /BEV3/CHTRKVKZ Table for Combination of Rule Class/Agreement Class (Time-Ref.) Table Type : TRANSP Package : /BEV3/CH Module : SD-SLS-PLL-OBS
  • /CUM/CLASS Table for CU: Class Table Type : TRANSP Package : /CUM/BASE Module : PM-WOC-MO
  • ADFDR_CUST Table for Customizing Flight Data Entry: Characteristic Assignment Table Type : TRANSP Package : DI_FDR Module : IS-AD
  • AFWCH_FDEP_SAMP Table for AFW: Sample Customizing Characteristic Dependencies Table Type : TRANSP Package : CFM_AFWCH Module : FIN-FSCM-TRM-AN
  • ATLAR Table for Characteristic Filter for Limit Types Table Type : TRANSP Package : FTLM Module : IS-B-RA-CL
  • AUSP Table for Characteristic Values Table Type : TRANSP Package : CL Module : CA-CL-CLS
  • AUSP_CONV Table for Characteristic Values Table Type : TRANSP Package : CL Module : CA-CL-CLS
  • BBPC_BIDDER_CHAD Table for Description of Bidder Characteristic Table Type : TRANSP Package : BBP_BUPA_FRG0020 Module : SRM-EBP
  • BBPM_BUT_FRG0020 Table for Business Partner: Bidder Characteristic (Administration) Table Type : TRANSP Package : BBP_BUPA_FRG0020 Module : SRM-EBP
  • BMA_CHVAL Table for OLD CFM Benchmarking: Characteristic Values Table Type : TRANSP Package : CFM_BMA Module : FIN-FSCM-TRM-PA
  • CABN Table for Characteristic Table Type : TRANSP Package : CT Module : CA-CL-CHR
  • CABNNEW Table for Characteristic Table Type : TRANSP Package : CT Module : CA-CL-CHR
  • CABNT Table for Characteristic Descriptions Table Type : TRANSP Package : CT Module : CA-CL-CHR
  • CAWN Table for Characteristic values Table Type : TRANSP Package : CT Module : CA-CL-CHR
  • CCIHC_IH05 Table for EHS: Assignment Display Field to Agent Characteristic Table Type : TRANSP Package : CBIH Module : EHS-IHS
  • CDBC_PARTNER_BV Table for Partner Characteristic - Estimation Table Type : TRANSP Package : CDB Module : CRM-MSA
  • CHARACTER_DMLDB Table for Characteristic Table Type : TRANSP Package : CME_CHAR Module : AP-CME
  • CLINDEXATINN Table for Characteristic - Index Assignment Table Type : TRANSP Package : CL Module : CA-CL-CLS
  • PLNFV Table Data element for Internal PI characteristic/characteristic value number
  • COMT_CFGD_CHNAME Table Data element for Characteristic name (object characteristic)
  • COMT_CFGD_CHSTORAGE Table Data element for Characteristic storage format (object characteristic)
  • COMT_CFGD_CHTNAME Table Data element for Characteristic table name (object characteristic)
  • COMT_CFGD_CHFNAME Table Data element for Characteristic fieldname (object characteristic)
  • OMADD Table Data element for Additional Characteristic (Reference Characteristic)
  • RCVALSEQU Table Data element for Serial number of characteristic value of a characteristic
  • RSPLS_CHA_ROLE Table Data element for Characteristic Relationships: Characteristic Role
  • MCW_ATINM1 Table Data element for Internal characteristic number, characteristic 1
  • MCW_ATINM2 Table Data element for Internal characteristic number, characteristic 2
  • MCW_ATINM3 Table Data element for Internal characteristic number, characteristic 3
  • QCHAR_TYPE02 Table Data element for Qualitative Characteristic with Characteristic Attributes

Class characteristic Table in SAP

Class characteristic related terms

Definitions.

SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.

Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.

Popular Table Searches

Latest table searches.

IMAGES

  1. SAP Classification Explained Part 2: Classification Tables

    sap class characteristic assignment table

  2. SAP Classification and Characteristics : Customizing & Tables (AUSP

    sap class characteristic assignment table

  3. Material Master Views in SAP: The Ultimate Guide (2023)

    sap class characteristic assignment table

  4. Intro to SAP Batch Management Configuration

    sap class characteristic assignment table

  5. SAP Classification and Characteristics : Customizing & Tables (AUSP

    sap class characteristic assignment table

  6. SAP AFS How to create Characteristic/Class for Material Master Data (CT04, CL01)

    sap class characteristic assignment table

VIDEO

  1. 7 Characteristic Classes

  2. SAP SD: Class no-104: Reconciliation GL Account Determination /Recon GL Account ||Your's Yuga SAP SD

  3. SAP SD: Class 97: Exchange rate types || Your's Yuga SAP SD

  4. SAP Class Dec 7

  5. SAP SD- Class 88: SAP tricks, tips and shortcuts || Your's Yuga SAP SD

  6. SAP CLASS PRICING PROCEDURE

COMMENTS

  1. Solved: Link between Class and characteristics created for...

    Answers (1) Former Member. 09-09-2008. 0 Kudos. Use CL30N to find the class and char. or use CL02 tcode and enter the class.it will show all the char assigned to this class. you can not find straight from one table but use the table to write the qurey. AUSP, KSSK, KLAH,

  2. Solved: Class and Chars Table

    TCODE is CL30N -Find objects in Classes. If its Material Class- 001, Pick the class assigned to it and hit "ENTER". Then Click "Find in Initial Class". You will see the materials assigned to the class. You have to "Change Layout" in that screen to see all the characteristics assigned to the material. or.

  3. SAP Classification and Characteristics : Customizing & Tables (AUSP)

    The path to customize Characteristics is: CT04: Customizing of SAP Characteristics. CL02: Customizing of SAP Classes. You can access the Customizing Tcodes directly from Standard SAP Menu under: SAP Men > Cross-Application Components > Classification System > Master Data. Fill a new for the new Characteristic. Then Choose the Data Type.

  4. Solved: Which Table, can I find the class and characterist...

    Answers (2) 04-19-20118:26 AM. Hi, As per above post, you can find classes. To find characteristics, Give EQUNR value in OBJEK field in AUSP table & get the ATINN value. Give ATINN value in ATINN field in CABN table & get ATNAM field value. In AUSP table, you can get the values against each characteristics as well. Regards, Maheswaran.

  5. Tables for Characteristic and Class details of Wor...

    Tables for Characteristic and Class details of Workceter. Former Member. on ‎10-26-2010. 0 Kudos. Hi, I am using Class type 019. i have workcenter and plant number. based on that i want to get class and characteristic details from Tables. In which table i can get these details if i pass Workcenter and Plant details.

  6. Solved: Table for characteristics value

    Table AUSP contains the values for a charcteristic for an object. There are a couple of others that you may need depending on the type of query you are creating. - KLAH Class Header Data. - KLAT Classes: Long texts. - KSML Characteristics of a Class. - KSSK Allocation Table: Object to Class. - CABN Characteristic.

  7. Solved: Table

    Table - characteristic values for a particular material. Dear all, We are using one class for all the FERT materials. say, a Class - FGCLASS ( which will have same set of characteristics for all FERT materials) will be assigned to all FERT materials in Classification view. The value of the characteristics varies for every FERT material.

  8. SAP Classification System

    The SAP classification system allows you to use characteristics to describe all types of objects and to group similar objects in classes. Class and classification are used to find objects more easily later. In this blog, I'll explain tables and model these using CDS. We will use material class in the blog to explore the classification system.

  9. Assigning Objects/Classes to a Class

    Choose Edit New assignments or New assignments. You see a dialog box, asking whether you want to assign a class or a specific object type (such as material) to the class. Select the object type you require. Enter the objects you want to assign to your class. If you want to assign values to characteristics, position the cursor on a class.

  10. SAP Help Portal

    Procedure. Use Class (transaction CL02). Enter a class name, for example, ISU_UIL_CONFIG. Select a class type, for example, 300 (Variants). Choose Change. Choose the Char. tab. In the fields of the Characteristic Name column, specify your characteristics. Save your changes. Task overview: Defining a Reference Product.

  11. Solved: selected set assignment to class characteristics

    Accepted Solutions (1) 09-10-2010. While creating characteristic in CT04 , go to Values tab, click on "other value check" tab.Now select catalog char. then give plant and selected set value . After this create MIC with reference to this class char. Vishal.

  12. Integration of Classes and Characteristics

    2. Select the table /SAPAPO/MATKEY and choose Organizational Areas. 3. Choose New Entries to create new organizational areas. To use characteristic-dependent planning (CDP), the ERP technical names of the batch class and the variant class must be the same (class type 023 and 300). In the SCM system, the characteristics of these two classes are ...

  13. Assigning Classes to a Class

    Procedure. To assign a class to another class, proceed as follows: In the classification system menu, choose Assignment Assign objects/classes to a class . Enter a class name and class type. Choose Last class processed to choose on of the last ten classes you have worked. These can also be classes that were processed with different applications.

  14. 1820783

    Visit SAP Support Portal's SAP Notes and KBA Search. A single characteristic value is selected for a characteristic in the classification view of a material master (MM01, MM02) or the configuration profile (CU41, CU42). As a result, this characteristic value is the assigned value for this characteristic in the configura.

  15. Class Characteristics Tables in SAP

    Master class characteristics for Class CA - Classification: Structure 14 : CVLC_CHAR_LINK: VELO : Assigning class characteristics to BW Characteristics IS - Vehicle Management System: Transparent Table 15 : E2KSML: Master class characteristics for class A - IDoc Interfaces for EDI: Structure 16 : E2KSMLM: Master class characteristics for class

  16. Class characteristics Table in SAP

    Here is a list of possible Class characteristics related tables in SAP. You will get more details about each SAP table by clicking on the table name. Table for CDB BP: Assignment Class. Categorie -> Class.-Criteria. Table for CDB BP: Assignment Class. Categorie -> Class.-Criteria. Table for CRM BP: Assignment Class. Categorie -> Class.-Criteria.

  17. Class Assignment Tables in SAP

    Class Assignment Database Tables in SAP (77 Tables) Login; Become a Premium Member; TCodes; Tables; ... Service-to-class assignment: Transparent Table 53 : ESH_TST_CLS_ASIG: ... BAPI for Characteristic Values Assigned to class assignment: CA - Classification: Structure 64 :

  18. Characteristic Assignment Tables in SAP

    characteristic assignment Table Entry Data Temp 0001 FIN - Accounting Engine: Transparent Table 8 : RCPS_IDL_ACT_EQR_CLASS_PROP: characteristic assignment of a Class at EQR for Action PLM - Recipe Management: Structure 9 : RCPS_IDL_ACT_PP_CLASS_PROP: characteristic assignment of a Class for Process Parameter PLM - Recipe Management: Structure 10

  19. Assigning Characteristics to Classes

    Assigning Characteristics to Classes; Contract Billing. 2023 Latest. Available Versions: 2023 Latest ; 2023 (Oct 2023) ... If you do not have an SAP ID, you can create one for free from the login page. Log on ... Share. Table of Contents ...

  20. Class characteristic Table in SAP

    Here is a list of possible Class characteristic related tables in SAP. You will get more details about each SAP table by clicking on the table name. Table for CDB BP: Assignment Class. Categorie -> Class.-Criteria. Table for CDB BP: Assignment Class. Categorie -> Class.-Criteria. Table for CRM BP: Assignment Class.

  21. Characteristic Class Assignment Tables in SAP

    Allocation Table: Object to Class Cross Application - Classes: Transparent Table 8 : CAWN characteristic values Cross Application - Characteristics: Transparent Table 9 : INOB Link between Internal Number and Object Cross Application - Classes: Transparent Table 10 : TADIR Directory of Repository Objects Basis - Transport Organizer: Transparent ...

  22. Characteristic Class Tables in SAP

    SOC: Storage object characteristic class transfer structure IS - Trader's and Scheduler's Workbench: Structure 7 : INOB: Link between Internal Number and Object Cross Application - Classes: Transparent Table 8 : KSSK: Allocation Table: Object to Class Cross Application - Classes: Transparent Table 9 : VBAP: Sales Document: Item Data SD - Sales ...

  23. Characteristic Assignment To Class Tables in SAP

    Transparent Table 20 : KSML characteristic s of a Class Cross Application - Classes: Transparent Table 21 : V_512W_D Generated Table for View V_512W_D Payroll - Payroll: General Parts: General View Structure 22 : RESP Project Number for SAP Partner Basis - Transport Organizer: Transparent Table 23 : PFO_SZO Segment assignment Table