Search Tables an Alternate to Searching Characteristic Values from AUSP table
I always found Classification System to be a maze in SAP and I wanted to find a better way to search characteristic values from AUSP table. As you might be aware that searching in AUSP table can sometimes be a nightmare. I stumbled upon one hidden functionality in SAP to make life a bit simpler. SAP calls it Search Tables. I wish it had a better name.
This document describes Configuration, Master Data and Setup required to enable this feature in ECC.
1) Navigate to Path: IMG>Cross-Application Components>Classification System>Classes>Maintain Object Types and Class Types
2) You will be presented a list of tables that represent Object Types supported by Classification System. For this document I will use MARA (for Material). Click the Object type under which the Class Type is defined for which you want to generate Search table. In this case I am looking for “001” class type.
3) Select the Class Type from the list of Class types that are supported by the system for the object types. Once selected Click the Details button.
4) Select the indicator “Generate tables” in the view presented by the system.
Following are the prerequisites to enable this indicator:
- “Multiple objs allowed” indicator must be set.
- “ECH (parameter)” indicator must not be set.
5) Go Back and Save the configuration.
Master Data Setup:
1) Go to Tcode: CL02
2) Enter the Class for which you want to generate the Search Table and Hit Enter.
3) Navigate to the Characteristic Table
4) Mark all characteristics that you need in the Search Table with “Index Relevant” indicator.
Note: SAP recommends that you do not select more than 12 characteristics.
5) Click Save. Acknowledge the popup message “Regenrate the search table”.
Search Table Setup:
1) Go to Tcode: CLGT
2) Enter the Class Type and the Class for which you want to generate the Search Table.
Note: This step will work on if the Master Data Setup as described able is done.
3) This transaction not only generates the necessary tables but also populates them with the characteristic values from AUSP table. Hence it is advised that you are executing this in background and during times when there are less or no users logged on. This is because the AUSP tables in some client can be really massive.
4) After the job is executed, you will find the details of the Search tables generated by the program in the following two tables:
GEN_TABLES_MAIN (for Characteristic with Single value)
GEN_TABLES_SUB (for Characteristic with Multiple Values)
You can now use these tables to search data using SE16N, use them in SQVI or in programs.
Note: As these Search tables are very Box specific, you need some serious coding to use them in your programs.
I am sure there must be other better ways to deal with this problem but wanted to share this option which I stumbled upon in SAP. Happy searching AUSP table.
Very Nice write up , thanks for sharing your finding with the forum.