topic regarding view in Application Development and Automation Discussions

regarding view

Former Member — Sat, 30 Jun 2007 05:48:06 GMT

hi experts,

i hav created a view using 2 tables LIKP and VBAP.I hav also defined join conditions between these tables..view has been activated without any errors..but it is not showing any data..instead it shows a msg 'NO TABLE ENTRIES FOUND FOR THE SPECIFIED KEYS'...i dont understand why it is happening...plz get me out of this problem...

regards,

raman sharma

Re: regarding view

Former Member — Sat, 30 Jun 2007 06:28:23 GMT

You have just created a ZCustom View for LIKP and VBAP tables? but you have not populated the data into it

where from the data will come into it

You have to populate the data

In STD views data will be automatically populated along with tables in that when a related transaction is done.

Since this is a custom View you have to populate the data

Hope you have created a Database View for LIKP and VBAP.

Why you need view for these 2 tables?

Just join them using the following link of fields and fetch the data

LIPS-VGBEL = VBAp-VBELn and

LIPS-VGPOS = VBAP-POSNR

Reward points for useful Answers

Regards

Anji

Re: regarding view

Former Member — Sat, 30 Jun 2007 08:26:38 GMT

hi anji,

can u plz tell me if i want to add one more table MBEW in this view..what would b the join conditions then,with LIKP and VBAP..yaa m creating a database view.n i have joined LIKP and VBAP using LIPS as u have guided me.its working..how can i join MBEW now...plz guide me again...

regards,

raman,prakash,jatin