Error in SRCLST01 IDOC via LSMW

Hi Guys,

I am using SRCLST01 Idoc in LSMW. It is working just fine for inserting new records but when I try to change/update any record, it gives me error:

"Please reconcile source list record".

I am using select and passing correct value for ZEORD field for the record to be updated.

Any clue, what must be going wrong?

Cheers!!!

Amit

SAP Managed Tags:
MM (Materials Management)

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (0)

Answers (1)

Can you give some evidence for " passing correct value"

Screenshot with IDoc data and from EORD would help

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Thanks for prompt response Juergen.

I wrote this code for ZEORD field:

In dubug mode, I confirmed that the select is fetching correct value 0001 for the record counter.

EORD currently have from date 01012016 and to date 12312016. I am passing 03012016 to 1231999.

I am also trying to set the Fixed vendor indicator for the record, which is not set right now.

This is the only record in EORD for this material and this plant. There is no other record conflicting with it.

Please let me know if you need any other information/details.

Cheers!!!

Amit

I asked for something different

Sorry, my bad. Here are the screen shots for IDOC Header, Item data and EORD Data:

Cheers!!!

Amit

This error message would for example be issued if you had 2 source list entries which are both valid in overlapping periods and having both the fixed source indicator active.

The field values from Idoc match with the values of the database record, can you try with MSGFN 004.

If that does not help then I would try with a slightly different coding:

I would do a select single * from EORD to fetch all field values from the source list table and then move corresponding to the IDoc fields of E1EORDM and E1EORDH

Your coding (selection) is not sufficient for any possible case of source list entries, you need to add much more fields to really identify and select a unique record.

One vendor can have several entries in a source list, for different validity periods, for different purchasing orgs, for countless different contracts and for multiple supplying plants.

Your coding only works by chance if you just have a single record per vendor.

One more idea: I see that the logical system in your EORD record is empty, this field may need to be filled to enable IDoc updates, see OSS note 769394 - ALE Verteilung Orderbuch

Thanks Juergen for taking time for response.

I did try with 004 and even 005 and both didn't work. We have a situation where we won't have multiple records for same vendor in source list. Due to this situation, I didn't bother much on selecting all records for the same vendor.

The logical system is blank in EORD for all the records. When I tried debugging the code with a break point, I see that the standard FM has hard coded value as "I" which is just an insert record.

Have you already successfully updated the records with this IDoc? If yes, can you please help me with sharing the code/sample code?

This is critical and I hate going to BDC if SAP is providing something standard 🙂

Cheers!!!

Amit

I used this Idoc in 2005 in my first SAP to SAP migration, using LSMW to create the Idoc, but since then I did not migrate any source lists. I can't remember if there were specific issues, probably not otherwise I would remember.

Just in case an update does not work, then I would just delete the old records using ME07 transaction and enter new records with the Idoc.

Deleting via ME07 may not be the good and accepted option.

I checked the code and it is trying to match the logical system against EORD table. My EORD records don't have any logical system and that's why the code is not entering in the update loop.

Any clue on this?

Cheers!!!

Amit

Had you read the OSS note? It has a report to update the logical system field in existing soure list records.

Sorry for the late reply. I was trying to see if Logical System is the logical solution for us.

This solution is mainly targeting for the situation where centralized system is getting updated with records from other systems.

In our case, it's just simple one landscape and have no such requirement. We are just trying to use this LSMW to mass upload and maintain the source list records. Updating and maintaining logical system across the landscape just for this purpose, may not be the right solution.

Looking for any other way of handling it. BDC via LSMW is out of question, I guess...

Cheers!!!

Amit

Why don't you just enter a Logical system?

I used IDocs to load source lists and we do not distribute source lists at all and the logical system is a mandatory entry since the IDoc belongs to the ALE interface.

We manually maintain day-to-day entries and manual entry doesn't add logical system in EORD system.

Also, if we refresh any system from production or any other system, the refreshed system will have wrong logical system in EORD as it's a part of data record in table.

Not sure, how to handle these two issues.

Cheers!!!

Amit

Ask SAP Support via Marketplace.

Ask a Question

Top Q&A Solution Author

User

Count

102