List of SAP EHS and QIM tables?

[rama_shankar3]

Please can one of you provide me a list of SAP EHS and QIM standard table list?

Thanks,

Rama

[christoph_bergemann · Accepted solution]

Dear Rama

SAP EHS is a "big term". Which moduile is of interest? Same question has been asked often in this FORUM. May be check:

http://scn.sap.com/docs/DOC-41109

Is this a mistype? Not QIM but QM? What are you looking for? To talk about EHS tables is in most cases the wrong approach to solve a specific business case as you normally use only the APIa/BAPIs to read, create, update, delete EHS data without manipulating them "direct".

C.B.

[rama_shankar3 · Accepted solution]

Thanks CB.  This helps.

Any info on QIM will be helpful as well.

Rama

[rama_shankar3 · Accepted solution]

CB,

I am also looking for QIM (quality incident management) table names. The reason is that I have to write ABAP to extract QIM issue details into BW and integrate with EHS data being extracted. As you may know QIM and EHS are 2 separate ECC instances and I plan to architect a solution to integrate EHS incidents with QIM issues in SAP BW - Sounds Cool - Right ( Smiling ) - to do this I need to know where EHS incident reference issues in QIM are stored...

That is why...I will research tips received and I think I should have some clue on tables within EHS..

Any additional inputs would be greatly appreciated.

Thanks,

Rama

[christoph_bergemann · Accepted solution]

Dear Rama

please explain your topic more. As discussed in different threads: We have now two EHS incident solutions. The "old" one (classic) and Component Extension one.

In http://scn.sap.com/docs/DOC-44567 some options to use EHS data in different context is collected.

One option is SAP BW integration and SuPM (check e.g. http://www54.sap.com/solution/lob/sustainability/software/performance-management/index.html) is one example.

C.B.

PS: may be check: http://www54.sap.com/solution/lob/sustainability/software/overview/reporting-analytics.html or http://www.sdn.sap.com/irj/bpx/index?rid=/webcontent/uuid/f00efca5-db78-2d10-c3a3-e8b8e1bb79e7

[former_member74037]

Hi Rama,

tables for SAP Quality Issue Management are:

/IAM/D_I_ROOT for issue (and cause, efect, defect) root data

/IAM/D_ACT_ROOT for activity root data

You should be able to find related tables for issue and activity in SE11 by searching /IAM/D_I_* and /IAM/D_ACT_*, respectively.

Customizing tables are /iam/C*

I hope this helps 🙂

Best regards, Andreas

[Former Member]

Hi Ram,

There are many options available to find out table details in sap competent. There are few details i have posted here for your information.i think it is useful for you.

1) Occupational Heath

T.Code  - SE80 Select Package - P99Q1 - Dictionary Objects - Database Tables

2. Injury and Illness

SE80 -Select Package CBIH  -Dictionary Objects - Database Tables

3 Product Safety

http://www.tcodesearch.com/sap-tables/list?module=EHS&comp=EHS-SAF&desc=Product%20Safety

4) Waste management

http://www.tcodesearch.com/sap-tables/list?module=EHS&comp=EHS-WA&desc=Waste%20Management

5) Dangerous Goods Management

http://www.tcodesearch.com/sap-tables/list?module=EHS&comp=EHS-DGP&desc=Dangerous%20Goods%20Manageme...

I don't have idea about QIM (Quality Issue Management) but you will get some important Tables details for QIM below link

http://www.erpgreat.com/quality/important-qm-tables.htm

http://rlaan.mine.nu/SAP-Tables/SAP%20Table%20Listing.htm

Edward

[rama_shankar3]

Hi Ed,

Thanks for the information. It is helpful. BTW, we are using bits and pieces of most of the items.

QIM is a new module. It is not QM like you mentioned. I am in a huge implementation doing QIM and EHS analytics and dashboards. So, if you get any QIM info, please do share.

Rama