Skip to Content
author's profile photo Former Member
Former Member

Phrase Texts Recovering


I am trying to do a simple query extraction related with transaction DGP3 containing material, dangerous goods description and hazard-inducing substances fields. Until this point no problem as this can be extracted from tables DGTMD and DGTM2. But I would like to extract too the descriptions (texts) of fields DGTM2-PDGNUD, DGTM2-PRES1, DGTM2-PRES2, DGTM2-PRES3. Could you please indicate what are the tables in SAP that store these descriptions and what are the key fields for linking (ESTPP, ESTPH??).

** I attached an screeshoot from SAP containing exactly the texts fields from trasncation DGP3 that I want to recover.

Thanks in Advance,

Best Regards,


EH&S query.gif (20.4 kB)
Add comment
10|10000 characters needed characters exceeded

2 Answers

  • Best Answer
    Posted on Jul 10, 2012 at 08:00 PM

    Dear Willy

    in principle you detected the right tables. The fields you have highlighted in the DG master are represented by phrases which are generated during the so called filling/generation of DG master data (per regulation).

    ESTPH is representing the so called phrase header and

    ESTPP is representing the so called phrase position

    You can refer e.g. to:

    Chapter "Further Phrase Data". If you use se16 you will realize and check the tables you will find easily that there a fields available which are called RECN etc. RECNROOT etc. You easily find that the tables are linked to each other using these fields.

    Technically you need invest to much time (may be). You can check e.g. these function modules:







    You can use these function modules and you need only populate the import parameter correct and you will get results. YOu need to do the whole topic by yourself. You need to understand that phrases are a core part of EH&S. Therefore SAP must provide tools/techniques to read the phrase items etc.


    PS: take a look on top may be here: =>

    Add comment
    10|10000 characters needed characters exceeded

  • Posted on Nov 04, 2013 at 04:34 PM

    You can use Function Module "C14X_PHRASE_TEXT_READ"


    Vivek Pareek

    Add comment
    10|10000 characters needed characters exceeded