hi,
I have a requirement, where i have to combine two tables , which doesnt have any field in common. but i have to combine the tables
VBRK and LIPS.
from lips
i have to select matnr and lfimg.
from vbrk, i have to take vkorg,vtweg, kunrg.
how can i take the materials from lips for the partiicular VKORG or KUNRG.?
the only possible link, i have got is linking vbuk with both the tables.since the vbuk-vbeln hold the vbeln of both these tables.
i m not willing to use join also.
I prefer for all entries.
can some one help me out with the codes.