topic Re: internal table and internal structure in Application Development and Automation Discussions

internal table and internal structure

Former Member — Mon, 07 Apr 2008 12:06:49 GMT

I want to know the internal table from which the field anrex in paooo2 (for personal data) gets populated . How do I proceed.

I tried by pressing F1 on the dropdown of title in the personal data screen and then checking in technical specification i get q0002 which is a structure but how can i know from where this structure gets the data(ie. MR. ,Miss ....etc.)

pls reply

Re: internal table and internal structure

Sm1tje — Mon, 07 Apr 2008 12:09:00 GMT

from table T522G.

Re: internal table and internal structure

Former Member — Mon, 07 Apr 2008 12:16:13 GMT

Thankyou so much . But friend What i want to know is how did you find that it is the internal table for the field?

Re: internal table and internal structure

Former Member — Mon, 07 Apr 2008 12:20:56 GMT

hi anzar..

first things first, its not an internal table but a data base table or an external table or a sap table. this comes from the SAP directly and we cannot change or delete this table as we do not get sufficient priviledges from the security people.

how did the guy above came to know is all because of experience. as i hav worked with certain tables, i know wat fields are related to them as so does the same holds for the above.

<REMOVED BY MODERATOR>

Edited by: Alvaro Tejada Galindo on Apr 7, 2008 4:05 PM

Re: internal table and internal structure

Sm1tje — Mon, 07 Apr 2008 12:21:42 GMT

It's not the internal table but T522G is a database table which is maintained in customizing.

Display PA0002 in SE11. Go to field ANRED, focus cursor on this field of mark the row. Next click on the foreign key button (button with a key displayed on it). You will get the foreign key which points to the table mentioned above.

Re: internal table and internal structure

Sm1tje — Mon, 07 Apr 2008 12:32:41 GMT

You are right about experience (knowing tables etc), however, it is also a matter of knowing how SAP Data Dictionary works in general. Value table, check table, search helps etc. etc. This way, next time anyone has the same problem, he can find out himself.

About changing / deleting: This table is provided by SAP, but it can (and will) be changed / deleted since it is a customizing table. To find out is customizing or not do this:

go to SM30, enter name of table and press customizing. Next pop-up, enter project or else, click button to proceed without project. This will lead you to the customizing (transaction SPRO).