Question:
Hi.
In EH&S in Incident/Accident Log I have defined a number of custom fields using characteristics attached to tabs (classes) within the classification system. I know that the data recorded against these fields is stored in 'transparent' tables. How do I access these transparent tables for viewing and extraction to BW?
Thanks
Conrad
Answer:
I found out how to view the transparent tables, below is an explanation, hopefully it will help someone in the future...
View (via SE16) table AUSP, here you will see the OBJEK number for the data captured against a characteristic field. The number will look something like 0000000000000001243700000000000000000000.
Now view table CCIHT_IAL. This table contains information about the incident/accident log, including the RECN number.
There is however no link between the incident/accident log (RECN) and the characteristic field data (OBJEK)
To do this you go to the Function Module Builder (SE37), Enter function module CBIH_IA30_IAL_READ and execute. Click on Test Data Directory. Select Get IAL Characteristic values. Your ABAPer will need to modify this function module to ensure the link between RECN and OBJEK is active.
Now select X_API_HEADER_TAB and enter the RECN number. Click back and then Execute.
Select E_API_IAPROP_DATA_TAB and there is a list linking your OBJEK data to the relevant RECN (Incident/Accident Log) record.
The BW consultant can now use this function module to extract the data entered against characteristic field into the cube for the relevant Incident/Accident log.
Cheers
Conrad