Managing SAP Classes and Characteristics with Qlik Gold Client

[Steve_Chabala]

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. 

  

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. 

Figure 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. 

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.
   
   
   
   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.