Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT

Managing SAP Classes and Characteristics with Qlik Gold Client

No ratings
cancel
Showing results for 
Search instead for 
Did you mean: 
Steve_Chabala
Support
Support

Managing SAP Classes and Characteristics with Qlik Gold Client

Last Update:

Jun 10, 2022 8:50:29 AM

Updated By:

Sonja_Bauernfeind

Created date:

Jun 10, 2022 8:50:29 AM

SAP Classes (tables KLAH, KSSK, KLAT, KSML) and SAP Characteristics (tables INOB, AUSP, CABN, CABNT, CAWN, CAWNT) are master data typically associated with materials and batches. 

 

  Steve_Chabala_0-1654778575443.png

Figure 1 - Diagram with links among tables in classification and variant configuration 

https://blogs.sap.com/2013/08/16/do-you-know-the-links-among-tables-in-classification-and-variant-co...

This data uses internal numbers that can be specific to each system. Gold Client copies data at the table record level so numbering used in the source system will be imported into the target system. If manually created classes and characteristics exist in the target using different internal numbers than the source, data corruption could occur due to a misalignment of these internal numbers. 

Steve_Chabala_1-1654778756719.pngFigure 2 - Example of Characteristics created in DEV and moved to QA and PROD system using ALE 

 

In this scenario, while copying characteristics via Gold Client it will overwrite the entries based on the key fields and potentially corrupt data due to duplicated/missing characteristics. 

 

Steve_Chabala_2-1654778821632.png

Figure 3 - Example of Characteristics moved from PROD to QA using Gold Client 

 

Strategies to consider in order of preference to avoid this issue: 

  1. Use ALE to copy classes and characteristics across the landscape instead of Gold Client: Characteristic value movement across Systems through ALE in Release Strategy Implementation 

    Relevant SAP OSS Notes: 

    45951 - Transporting class data: system / client 
    10745 - Copying classification data to another client 
     943559 - FAQ: Frequently asked questions in the classification 

  2. Only copy classes and characteristics with Client Construct process in Gold Client.  This full table copy process can remove all existing classes and characteristics records in the target before importing source data.  The Delete Table Data Before Import needs to be selected during the Client Construct -> Client Importer process. 

    Any classes and characteristics data manually created or moved with ALE in the target would be deleted with this process.

    Steve_Chabala_3-1654779249560.png

    Figure 4 - Client Importer - Conflicting Data Options screen

    Client Construct datatype CHARACTERISTICS & CLASSES should contain the following tables:

    • AUSP
    • CABN
    • CABNT
    • CABNZ
    • CABS
    • CAWN
    • CAWNT 
    • CLAENNR 
    • CLINDEXATINN 
    • CLSELSTATADM
    • CLSELSTATISTICS
    • CLSELSTATISTICS2
    • GEN_TABLES_MAIN 
    • INOB
    • KLAH 
    • KLAT
    • KSML
    • KSSK
    • SWOR
    • TCME
    • VBMUE 
    • VBMUET
    • VBMUEZ 

  3. Adjust Gold Client Data Echo configuration to exclude classes and characteristics data.  Consider marking the following linkages inactive in the Data Echo configuration 

    • CA - EQUIPMENT DATA -> LINK - OBJECT TO CLASSIFICATION 
    • MM - BATCHES (MCH1) -> CA - CHARACTERISTICS 
    • MM - BATCHES (MCHA) -> CA - CHARACTERISTICS 
    • MM - CONFIGURABLE MATERIAL -> LINK - MATERIAL TO CLASS 
    • MM - CONFIGURABLE MATERIAL -> LINK - MATERIAL TO CLASS 
    • MM - MATERIAL MASTER W/ VC DATA -> MM - CONFIGURABLE MATERIAL 

      Refer to this link on searching the Gold Client configuration for tables KLAH, KSSK, KLAT, KSML:  How do I know if a table is part of my Gold Client configuration?  

 

 Active Gold Client customers can contact Qlik Support for additional assistance. 

 

 

 

 

Labels (1)
Version history
Last update:
‎2022-06-10 08:50 AM
Updated by: