Where is my data stored in SAP Auto-ID Infrastructure?
SAP AII provides many different methods (Auto-ID Cockpit, function modules, etc.) to query the data stored in the backend database. However, there are times when you may need to view the data directly for troubleshooting or where specific data is not returned via the other methods. In previous versions of SAP AII - AII 4.0 and AII 5.1 context items were visible through the Auto-ID Cockpit. In AII 7.0, however, the Auto-ID Cockpit no longer returns the object context (user data) data.
Step 1: View List of AII Object Tables
Access the data browser using transaction SE16. To see a list of all the tables which store the AII object (EPC) data, enter /AIN/DM_OBJ* for the Table Name and Click on the circle button to the right of the text box.
Figure 1 Data Browser
Step 2: Select a Table to Browse
There are six tables whch store AII Object data. We're going to focus on three main tables.
Figure 2 AII Object Tables
/AIN/DM_OBJECT - the master table for all AII object records. It contains the Object GUID (SAP internal identifier), GTIN or SSCC data for the object, Product GUID whch correlates to the product master data associated with the objet, EPC value in HEX format, datetime the object was added and/or updated, and more.
Figure 3 DM_OBJECT Table
/AIN/DM_OBJ_ID - Stores the Object GUID along with the associated HEX, Pure ID and Tag URI encodings for the object. This is a valuable table for locating the object GUID by its associated HEX value, Pure ID value or Tag URI value.
Figure 4 DM_OBJ_ID Table
/AIN/DM_OBJ_CTX - table stores all the user data associated wth an object via name-value pairs.
Figure 5 DM_OBJ_CTX Table
By accessing the AII Object tables directly, you can verify whether AII is capturing the data successfully as well as gain a better understanding on how AII stores and uses the object data. Through a proper AII implementation
it is possible to report and view all the data elements.