topic Re: difference between joins &for all entries in Application Development and Automation Discussions

difference between joins &for all entries

Former Member — Tue, 18 Mar 2008 06:02:14 GMT

difference between joins &for all entries

Re: difference between joins &for all entries

Former Member — Tue, 18 Mar 2008 06:06:51 GMT

Reward points..

Re: difference between joins &for all entries

Former Member — Tue, 18 Mar 2008 06:08:34 GMT

hi,

Join statement is used to create a view on two or more tables that is we can select the enetries from two or more tables simultaneously.. Like if we want VBAK( SO header tab) and VBAP(SO item tab) details in single work area we go for join statement .

For all enetries option is used when we want to select data intio the table on the basis of already existing internal table data. Like we have SO header deatils in vbak_itab internal table and now we want SO item deatails in separate vbap_itab then we will go for this option..

Check the syntax that will help in understanding..

Reward points!!!!!!!!!!!

Re: difference between joins &for all entries

Former Member — Tue, 18 Mar 2008 06:08:49 GMT

Hi,

Joins are used to fetch data from two database table based on certain joining condition.But for all entries is used to fetch data from database table based on the data present in the internal table.

Hope this will help

Regards

Shibin

Re: difference between joins &for all entries

chandra_sekhar3 — Sun, 02 Jan 2011 11:20:41 GMT

Hi,

FOR ALL ENTRIES retrieves all the table entries depending on another table.

joins: To select the data from more than one database table with atleast one field

at once in to these same internal table.