How to check the fields involved in R/3 Query ?

[ERP]

Hi all,

Can someone please tell me how to see the R/3 Querie Technical fields?
I'm trying to implement the "Payment List" query (S_P99_41000099) into SA BW,
and is there is anyway to see the list of fields involved in this R/3 Query? It makes life easy to find out the tables
related to each technical field.

There is a way to check the technical field name by taking F1 help on the result, but is there any other way to see all the fields involved in the Query?

Thanks in advance,

ERP

[Portal]

Hi ERP,

If you need to know the tables, just by using F1 help button.
Else ask the required consultant who created the report, to access the program of the particular report. Then you can check the program how all the fields are fetched.

I dont think there is any other way that you can find..other just checking the program itself.
If you know any particular datasource...sur you can check through the following options:

Refer to RSA5 (Business Content DS) transaction to get the standard DS.

Also you can refer RSA6 for the DS which are active in the system.

Also you can refer the table ROOSOURCE to get the standard DS list in ECC.

Hope this helps.

Regards,
Portal

[Golfi]

Hi,

If you have access to query designer then open the query in designer and from tool bar simply switch on the technical names. You will get the technical name of all the Infobjects involved in the query.

In the left hand side panel you will see the name of Infoprovider. So in the query the directly used fields will be part of Infoprovider and the navigation attributes will be part of base Infoobject.

Regards,
Golfi