Problem in BDC

[Former Member]

I am extending a mterial to a new plant that is created

for that three flats files needs to be uplaoded one by one.

1). Basic Data

2) Financial Data

3) Batch Management Data

what i am doing is that i am uploading all three files into three internal tables ITAB1,ITAB2,ITAB3.

what i am doing is

loop at itab1.

in this loop i am calling transaction mm01 and uploading basic data

endloop,

loop at itab2.

in this loop again i am calling transaction mm01 and uplaoding financial data

endloop.

loop at itab3.

in this loop i am calling transaction MSC1N and uplaoding batch data

endloop.

In Mode 'A' it is working fine but when i am executing it in Mode 'N'

what it is doing it is uploading data of itab1 into mm01 but for rest two interanl tables it is saying the data is locked by the user from which i am executing my program

Can any one please tell me why it is happening and is tehre any solution for the same.

[Former Member]

HI

MM01 is for creation.

Means if you fill some data once and created a record then its locked and you can only modify it using mm03. So for ITAB2 data you need to call mm03 to modify the desired record.

Regards

Aditya

[Former Member]

Hi Ashish ,

Wht is happening is ur calling MM01 in first loop and again ur calling MM01 in 2nd loop and both of these loops are in same program .

U try include the whole data (For Basic and Finance ) in one file only and then upload the data for both basic and finance data .

After calling MM01 , u can go for uploading batch data in seperate loop .

Hope this will work for you .

[Former Member]

Hi aditya,

The process is that while extending the material in mm03 it will display the data for the valuation type for which the material has already been extended and once it is extended then the process is that teh material can not be extended in the same valuation type, if we are uing MM03 then we if we enter our valution type then it wil show an erro rmessage the material has not been extended for that valluation type and we have to extend the material for that valuation type,so using MM03 will not solve the issue

Hi Manik,

the probelm in your solution is that the second part can be done only when the first part is over coz teh valuation type depends on the valuation category that we enter during the basic data update.

so we cannot merge the files

[Former Member]

Thanks lot buddies.

Problem solved.

i just used

WAIT UP TO 30 SECONDS.

and its working fine.

Edited by: ashish pandey on Jun 6, 2008 7:29 AM

[Former Member]

problem solved

[Former Member]

Hi

After your first loop use the follwing statement:

COMMIT WORK AND WAIT.

This will force updation of data in first loop. Next loop will start only after the updates in first loop are complete.