Skip to Content
avatar image
Former Member

Phrase Texts Recovering

Dears,

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,

Willy.

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

  • Follow
  • Get RSS Feed

2 Answers

  • Best Answer
    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:

    http://help.sap.com/printdocu/core/print46c/en/data/pdf/EHSSAF/CAGTFADM-EHS.pdf

    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:

    BAPI_BUS1091_CREATE

    BAPI_BUS1091_CHANGE

    BAPI_BUS1091_DELETE

    BAPI_BUS1091_GETDETAIL

    BAPI_BUS1091_DETAIL


    etc.

    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.

    C.B.

    PS: take a look on top may be here:

    http://www.sapnet.ru/m/list_BAPI.html =>

    http://www.stechno.net/component/sapfunc/?view=sapfunc&id=BAPI_BUS1091_DELETE

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Nov 04, 2013 at 04:34 PM

    You can use Function Module "C14X_PHRASE_TEXT_READ"

    Regards

    Vivek Pareek

    Add comment
    10|10000 characters needed characters exceeded