Phrase Texts Recovering

[Former Member]

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.

[christoph_bergemann · Accepted solution]

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

[former_member502870]

You can use Function Module "C14X_PHRASE_TEXT_READ"

Regards

Vivek Pareek