Connection between Structure Field and Table Field

[Former Member]

Hello everybody,

I'm trying to find a connection between a field in the structure and the actual filed in the table of the database. For example in the structure CAUFVD you have the field PLNNR. This information is stored in the table AFFL in the field PLNNR.

In the transaction SE84 you can display a structure with all it's fields but I don't see anywhere from which table and field the information is gathered.

Can you please help me in finding the connection between the structure field and the table field in the database in which the displayed information is stored?

Thanks and best regards,

CALIN Marius-Bogdan

SAP - PP-KeyUser

[Former Member]

Hello everybody,

I'm trying to find a connection between a field in the structure and the actual filed in the table of the database. For example in the structure CAUFVD you have the field PLNNR. This information is stored in the table AFFL in the field PLNNR.

In the transaction SE84 you can display a structure with all it's fields but I don't see anywhere from which table and field the information is gathered.

Can you please help me in finding the connection between the structure field and the table field in the database in which the displayed information is stored?

Thanks and best regards,

CALIN Marius-Bogdan

SAP - PP-KeyUser

[brad_bohn]

Double-click on the structure field and you can do a where-used to find the codepoints, interface usage, etc. You might find it that way. You could also look at the flow logic of your screen and try to trace it back. Otherwise, you'd have to use watchpoints, the debugger, runtime analysis or various other developer tools to find the data population. If you are a user and not a developer as your signature indicates, you might need to find a developer for this. Sometimes, it can be incredibly frustrating with SAP because the data field will be handed off 4 or 5 times before it actually reaches its destination field. Unfortunately, I haven't worked with PP in at least 10 years so I can't give you a better answer; maybe someone else can.

[former_member378318]

There is no direct link between a screen structure and database table/field. In some cases you get lucky and the screen structure refers directly to a database table and field. When the screen refers to a structure then its fields maybe populated or derived in any manner at all. As previous poster says in this case debug must be used to find the source of the field.

[Former Member]

The best way to find out the link is to double click on the Structure Field, the component type and then further to the data element.

You need to apply a Where used list on the on the Data Element.

You can choose the option as Table Types.

This will list you all the tables in which the related data element occurs and among them , with the help of Table Description, you will definately get the appropriate table.

I hope this helps. Revert if you have doubts.

Thanks,

Manu