How to locate the repository table relevant to my custom report. ?

[Former Member]

Hi

I have to develop custom user report in SAP GTS.

User wants custom report with product, classification and tariff details.

Please tell me, How do I locate the relevant table and field from the the GTS SAP repository ?

BTW, Where do I go from here and do some more research and understand the GTS schema or repository database understand the different tables and its purpose and also its relation, etc.

Any pointers ?

Your help is much appreciated. Many thanks in advance.

-siva

[Former Member]

Go to the relevent standard transaction, put the cursor on an appropiate field and choose F1 and than press the toolbox button.

You'll see there the source table and field.

Regards,

Rebeka

[Former Member]

Is there any document which list all the tables there in GTS.

BTW, I want at least 10 to 15 important table we use in GTS very freuently.

thanks

siva

x41004

[GauthamV]

hi,

open ur transaction and in menu goto system status and find program name.

then in se37 open GET_TABLES func module.give program name and execute.

u will get all tables related to that transaction.use the tables which have ur required fields.

[Former Member]

Gautham,

Thank you. This is really great input. Again Thank you for that.

But, still I am looking for

1. Some document on GTS repository database

2. List of 10-15 GTS main repository table, which are very commonly used in the IT world.

thanks

siva