diffrent fields-different tables-one screen?

[kiran_k8]

Hi Folks,

1.Can anyone here please let me know the way to view different fields from different tables at one shot.Nothing related to Programming,but just for the convenience when we have to run through different fields from different tables.Is it possible?

2.Any idea on how to prepare test cases for BDC?

Thanks.

K.Kiran.

[raja_thangamani]

<b>Query1:</b> Create the View with all related tables but key should match..Goto SE11. There is a option to create.

Go thro the links..

http://help.sap.com/saphelp_47x200/helpdata/EN/4c/81c1351181b73fe10000009b38f839/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/en/36/74c0358373003ee10000009b38f839/frameset.htm

Raja T

Message was edited by:

Raja Thangamani

[amit_khare]

1. As far I can think of not possible directly unless you do extra work like creating a view.

2. Create an excel sheet with all your data in respective columns without header and save it as tab delimited file which is most generally used.

Regards,

Amit

Reward all helpful replies.

[Former Member]

i think you can see it in database view here you have to join desired tables and fields you want to see. you can create it in se11.

regards

shiba dutta

[Former Member]

Hi Kiran ,

If both the tables are related i.e. there is a common feild between the tables , then you will have to create a view combining the feild from the table for which you want to see the data.

Regards

Arun

[sreeramkumar_madisetty]

Hi

Thru view we can achieve this.

But to create a view matching key is must.

2: For BDC test case means whether all records are uploaded successfully uploaded we have to check in the concerned tables.

If we let me know the transaction u are using i can help u.

Regards,

kumar

[kiran_k8]

got the answer