topic Re: DMEE Tables in Application Development and Automation Discussions

DMEE Tables

Former Member — Thu, 14 Mar 2013 10:26:14 GMT

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.

Re: DMEE Tables

rosenberg_eitan — Thu, 14 Mar 2013 11:07:05 GMT

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.

Re: DMEE Tables

Former Member — Thu, 14 Mar 2013 11:48:11 GMT

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!

Re: DMEE Tables

RaymondGiuseppi — Thu, 14 Mar 2013 12:06:40 GMT

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

Re: DMEE Tables

Azeemquadri — Thu, 14 Mar 2013 12:09:22 GMT

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

Re: DMEE Tables

rosenberg_eitan — Thu, 14 Mar 2013 12:10:21 GMT

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.

Re: DMEE Tables

marcduf001 — Fri, 29 Nov 2024 16:02:11 GMT

See OSS note 2820775

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