DMEE Tables

[Former Member]

Hello colleagues,

I have a question regarding to DMEE tables. I'm trying to create mapping (using DMEE t-code) and I've noticed that in the most cases it uses 'structures' instead of real tables. Let me clarify what I mean by this, as according to my understanding, the structure is something like 'View' in the SQL Server, i.e. predefined selection of some particular fields from different tables:

In this case the structure is 'FPAYHX' and used field is 'NAMEZ', and I need to know from what table this field originally comes from? How I can track it back and figure out from what tables this structure consists of? Is there any special t-code which can show me not only table/structure fields but also the linkage between tables?

...and,  is there any way to identify the actual name of table in the database (as there are hundreds of tables with some weird names)???

Thank you.

[Former Member]

Hello colleagues,

I have a question regarding to DMEE tables. I'm trying to create mapping (using DMEE t-code) and I've noticed that in the most cases it uses 'structures' instead of real tables. Let me clarify what I mean by this, as according to my understanding, the structure is something like 'View' in the SQL Server, i.e. predefined selection of some particular fields from different tables:

In this case the structure is 'FPAYHX' and used field is 'NAMEZ', and I need to know from what table this field originally comes from? How I can track it back and figure out from what tables this structure consists of? Is there any special t-code which can show me not only table/structure fields but also the linkage between tables?

...and,  is there any way to identify the actual name of table in the database (as there are hundreds of tables with some weird names)???

Thank you.

[rosenberg_eitan]

Hi,

From sap site:

http://help.sap.com/saphelp_nw70/helpdata/en/fc/eb3138358411d1829f0000e829fbfe/content.htm

A structure is not a 'View' in the SQL Server .

The field are filled by program code (e.g. result of calculation , result of SQL select etc. )

Regards.

[Former Member]

Thanks for the reply.

But still can't get it, if this is a piece of program code, how I can see structure source code in this case?

Is there any clue, how I can identify table name in the database?

Thank you!

[RaymondGiuseppi]

There is not always a direct relation between a structure and database table behind, somewhere a program read some table to fill data with this structure. Perform some where-used on the structure definition to get the program and analyze it. As an alternative look at data element of fields of the structure and look for database table using those data elements.

Regards,

Raymond

[Azeemquadri]

You can go to the structure and field-name and do a where used list. In the where used list select tables.

[rosenberg_eitan]

Hi,

I am not familiar with Package ID-DMEE.

I assume that when you "test the active version" (f8) the code behind it will fill the structures.

Try using ST05 (SQL Trace) and analyze the tables used in the process.

Regards.

[marcduf001]

See OSS note 2820775

It provides an Excel file with the mapping of each FPAYH, FPAYHX and FPAYP field