DGE5

[former_member241703]

Hi all,

I want to know how the values from substance workbench are read in the report related to the T-code DGE5

Means is any function modue they are using to read the values from substance workbench?

Thanks in Advance

Uday

[Former Member · Accepted solution]

Hi Uday,

There is a mapping for each filed of DG Master Vs Field in Specificiaton Workbench ( Value Assignment Type)

This is a part of Customization.

Path

Environment, Health and Safety--> Dangerous Goods Management--> Interfaces: Filling and Distribution--> Filling--> Specify Assignment Objects for Filling

This data get stored in varipus tables such as DGTM2, DGTMD, RDG_DGTMD_FILL, RDG_DGTPK_FILL.

This is a standard customization or functionality. so there is no single FM for it.

Regards

Amol

[former_member241703 · Accepted solution]

Hi Amol,

I am doing analysis of the report related to DGE5,in that report how thes values from substance workbench is populated,that i am looking for.

And how the dgtmd & dgtm2 tables gets updated in the report.

Thanks

Uday

[christoph_bergemann · Accepted solution]

Dear Uday

take a look first here:

http://help.sap.com/erp2005_ehp_06/helpdata/en/de/5174db4c4b11d18a110000e816ae6e/frameset.htm

Chapter "Filling" and "Assigning Table Fields". Be aware of the fact that during filling process phrases are generated automatically and you need therefore further customizing.

To my knowledge there is no further consulting OSS available. Therefore try to understand the correspnding custimizing activities.

Update of fields: Pay attention. Especialy in the areaa of dangerous goods filling very often change numbers are used. This increases the complexity of filling and how the data is used later. Be aware of the fact that using Enhancement packges DG master is "changed" (EnhPack 3, 5, 6 provides changes here) and therefore the whole process might be more complex as in the past.

You need a good understanding of data model which is used during filling and how to maintain the data etc. correct.

C.B.

PS: you need a basic understanding regarding: Usage, Regulatory List and how these technical objects are used within filling.

[Former Member · Accepted solution]

Hi Uday,

As perfectly explained by Christoph, Please refert to attached link and explanation.

However, still trying to explain the technical part

The main table for DG filling is TDG79.

Your question was "HOW Filling is done?"

so in this table, we are telling the system the 'exact' mapping at filed level.

e.g. below is mapping

Table Name          Field Name           Srce tab. VA                              Field/charact.

DGTM2                FLG_EMSN1_U     SAP_EHS_1022_024                SAP_EHS_1022_024_FLG_EMSN1_U

Your question was "HOW Filling is done?"

so here we are telling the sytem that, Pick the Value of Chracterstics (SAP_EHS_1022_024_FLG_EMSN1_U) of Values Assignemnt type (P_EHS_1022_024) and copy that value to filed (FLG_EMSN1_U ) of table (DGTM2)

In this way, value of Specificaiton workbench get transferred to DG tables.

again ... Following FM get called when DG filling process starts

• CONVERSION_EXIT_CHRI2_INPUT
• CONVERSION_EXIT_MATN1_INPUT

I hope...it is making sense...

Regards

Amol