i have get all lfm1-ekorg for all vendors in lfa1-lifnr

[Former Member]

Hi Experts,

Please help for the following query.

select lifnr

ekorg from lfm1 into corresponding fields of table i_lfm1

for all entries in i_final_ven

where lifnr = i_final_ven-lifnr.

by using this i have getting the ekorg only for the lfa1-lifnr.

but my intension is i have to get all ekorg for lfm1 which is assinged in the lfm1 table.

Because the vendors having the different ekorg so you can understand the problem

please help me.

[Former Member]

Check this thread

[Former Member]

Hi ,

To get all the EKORG for that particular Vendor ..

Then this below Query is correct :

select lifnr

ekorg from lfm1 into corresponding fields of table i_lfm1

for all entries in i_final_ven

where lifnr = i_final_ven-lifnr.

also please check the LFM1 Table by giving the different Purchase Organization Value from the List in the field EKORG

and Run .. You may find the Variace EKORG for That Vendor ..

For Multiple Vendor give the Vendor No in Range

Or else you want only the Required Purchase Organization Data.

Then Keep a Selection Parameter in The Screen for EKORG and

write a query directly to retrieve the data from LFM1 where EKORG In Selection-Screen Ekorg..

This how it Works ..

All The Best

With Regards,

Vinu.R