Itab has fields A,B,C.
Data: begin of itab occurs 1,
A type I,
B type I,
C type I,
End of itab.
Jtab has fields A, I, J.
Data: begin of itab occurs 1,
A type I,
I type I,
J type I,
End of itab
The common field between itab and jtab is u201CAu201D.
Now I need to collect A,B,C,I, J in another internal table ktab.
How should I be doing this.
If I use a SELECT query with inner join between itab and jtab it says u201Citab is not a database tableu201D.
How should I get the result ktab with A B C I J fields?
Please help, nay help will be highly appreciated?