Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Hi Reg Using inner join and for all entries with internal tabel

Former Member
0 Kudos

Hi

I am working on a report which needs data to be retrieved from 12 internal tables..

I have used join condition to get the data's..i gotta probelm when i am retrieving same fields from different tables , i mean to say that i need to have vbak-vbeln ans ekkn-vbeln also

in my internal table i have declared it like

vbeln type vbak-vbeln

k_vbeln type ekkn-vbeln.

But when i am tried to fire a select query to retrieve this entries

i am getting only blank in the k_vbeln fields

Can any one suggest me some better way to do this?/

2 REPLIES 2

Former Member
0 Kudos

Hi,

Use FOR ALL ENTRIES option. because it will give good performance, easy to understand the coding.But you shold check itab is initial or not, then select entry

Ex.

if itab[] is not initial.

select * from vbrp for all entries in itab

where vbeln = itab-vbeln

endif.

if itab is initial, select statement reads all entries from tabl.

reward if useful

Former Member
0 Kudos

Hi,

You can use For all entries instead of join....

Join reduces the performance so better not to use it..

If u can show the code then we can check where the problem is...

Otherwise if you want any sample code for ... For All Entries...

Then i can send you that..

Reward if helpful.