difference between joins &for all entries

[Former Member]

difference between joins &for all entries

[Former Member]

difference between joins &for all entries

[Former Member]

Reward points..

[Former Member]

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!!!!!!!!!!!

[Former Member]

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

[chandra_sekhar3]

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.