tables for mm03 (specification-material assignment)

[Former Member]

Hi All,

We have a need to find out which material masters are assigned to GCD (Global Chemical Database) specifications.what are the possibilities from Material master side.

Specification information (in tab "Spec assignment") on material master side is on a structure RCGMMJIOT. can anybody help with the table name for the corresponding structure.

Thanks in advance

[JuanCarlosDelga · Accepted solution]

Hi vibhuti.

In EHS the relation between specification & material is in table ESTMJ - EHS: Specification-Material Assignment.

The specification header is in table ESTRH, here you have the field SUBID - Specification.

Regards.

[Former Member]

HI Vibhuti,

More detailed information about EHS tables are as follows

Description--> Table Name

Specification Header ESTRH

Identifiers ESTRI

Identifier - Regulatory list assignment ESTRL

Referencing in specifications ESTRR

Specification - Material assignment ESTMJ

Specification status assignment ESTST

Specification - Value Assignment Type Assignment (Property tree) ESTVH

Value assignment Item (e.g. composition values) ESTVP

Shadow table for AUSP (Characteristic values) ESTAUSP

Additional Information: Value Assignment Assessment ESTDR

Additional Information: Value Assignment Source ESTDS

Additional Information: Value Assignment Usage ESTDU

Additional Information - User-Defined Text ESTDF

Value assignment table (Classes) ESTVA

I hope this complete list may will be helpful for you.

Regards

Amol