09-09-2008 2:03 AM
Hi All,
i want to create view between two tables.
what is t.code to use creating a view?
and give me one example for created view.
thanks,
srii.
09-09-2008 3:36 AM
Hi Sridhar,
Creating a View is a Simple Task and need not to worry.
Here is a simple step by step procedure to create a View for 2 Tables.
Go to the T-CODE SE11
1. Give a View name and create.
2. Select Database View and.
3. Give Short Description and save.
4. Now select (enter) the two tables which you want to join or view.
5. You can place the Join conditions if necessary.
for example: you can join VBFA and VBAK tables.
and the join condition will be VBAK-VBELN = VBFA-VBELV.
6. Now go to the Viewfields Tab..
7. Select the Table fields and select Table.
8. Now choose the fields you want to display for view.
Finished creating the view.
Its Simple.
Regards,
Dileep Kumar Chinnaiah.
09-09-2008 2:27 AM
09-09-2008 2:29 AM
Hi Sridhar,
Transaction Code to create a View : SE11
For Step by Step procedure refer to :
[http://help.sap.com/saphelp_40b/helpdata/en/cf/21ed06446011d189700000e8322d00/content.htm]
Regards
Hemant Khemani
09-09-2008 3:36 AM
Hi Sridhar,
Creating a View is a Simple Task and need not to worry.
Here is a simple step by step procedure to create a View for 2 Tables.
Go to the T-CODE SE11
1. Give a View name and create.
2. Select Database View and.
3. Give Short Description and save.
4. Now select (enter) the two tables which you want to join or view.
5. You can place the Join conditions if necessary.
for example: you can join VBFA and VBAK tables.
and the join condition will be VBAK-VBELN = VBFA-VBELV.
6. Now go to the Viewfields Tab..
7. Select the Table fields and select Table.
8. Now choose the fields you want to display for view.
Finished creating the view.
Its Simple.
Regards,
Dileep Kumar Chinnaiah.