topic Re: LSMW - Problem in Application Development and Automation Discussions

LSMW - Problem

Former Member — Fri, 11 May 2007 19:04:26 GMT

Hi,

In the following code:

vkorg is sales org

vwerks is delivery plant

The lsmw reads the vkorg and vwerk. However, say the 1st vkorg is zpmb, with vwerk 1010. It will read all of those entries and when it gets to the next vkorg (say zprm) it will continue to use the same vwerk, instead of the real one.

How do i fix this?

Thanks,

John

Message was edited by:

John Damion

Message was edited by:

John Damion

Re: LSMW - Problem

Former Member — Fri, 11 May 2007 19:16:01 GMT

HI John,

Try with the following changes:

select single werks from tvkwz into wa-werks where vkorg = main_cust_file-vkorg.

if wa_werks is initial.

import wa_werks from memory id wa-mid2.

endif.

bknvv-vwerk = wa_werks.

export wa-werks to wa_mid2.

Regards,

ravi

Re: LSMW - Problem

Former Member — Fri, 11 May 2007 19:43:06 GMT

Please tell me, why did you make the changes this way?

Please explain the changes and what they signify.

Re: LSMW - Problem

Former Member — Fri, 11 May 2007 23:35:37 GMT

1) get the plant from the table for the VKORG in the fiel.

select single werks from tvkwz into wa-werks where vkorg = main_cust_file-vkorg.

2) If there is no Plant in the table for the VKORG in the file,

get the previous plant(The plant that was exported to memory last record).

3) Export the current plant number to make it available for next record if needed.

Regards,

Ravi