Same Material, 2 different Info Record # under same Vendor

[Former Member]

Hi Sir/Mdm

Would like to seek your advise regarding the below info-record

Recently I've experience few items, under same Vendor, with same pricing, but has 2 different info records

May I know what causes it? Attached screenshot for your reference. The first info record (530012211) has a PO to it, whereas the second info record (5300122129) doesn't have. Was this the cause of it? I try to make an comparison between these 2 info records, but data were all similar. Even under the conditions dates.

May I ask what causes this duplication? If anyone can help me on this? can ME15 flagged this off?

[Former Member]

Hi All,

Thank you very much for your kind advise.

Just one question, which is also relating to PIR.

I've long since flagged Record: 5300122120, and there is already an 'X' indicator

However, when I create new PIR for plant 3000(as per 2nd line), why did those new PIR went to the Record#: 530012210 and not in 5300122134?

Since I've already flagged the wrong info record, shouldn't new PIR created at 53000122134?

[JL23]

It is an inconsistency if you have 2 info record numbers for the combination of same vendor and material.

It is not possible to mark one for deletion and use the other one. The programs can't do that, based on they key and the ABAP logic  the either find the first or the last record and continue using it.

[Former Member]

Thank you Jurgen for the prompt response.

I've came about this link regarding deletion of Info Record

http://www.erpgreat.com/materials/deletion-of-info-record.htm

I assume if I were to do this step, the record which I've flagged will no long be visible in the info record?

So what actually happens to those that were already saved inside the 'flagged' record? It will get deleted off as well?

Regarding the ABAP logic, can I know what you meant by this??

So sorry for the inconvenience ....

[JL23]

With ABAP logic I mean the SAP programs that make all your activities happen. And this is designed and hardcoded, this cannot be changed by you except you go for a modification.

2 info records got created because of a faulty own logic in your migration.

SAP did never expect to have 2 info records of the same combination, hence there is no program logic that could accommodate working with 2 records.

An info record is deleted if you do no more business for a vendor/material combination. This is a necessary step to archive the info record finally and to delete it physically from your tables.

But as soon you create a new PO for this combination SAP will automatically create the info record again.

You cannot have a deleted info record and continue business with that combination, that is just meaningless, except you decided to not use info records at all, you changed your customizing and subsequently deleted your existing info records.

Physical deletion can only be achieved with data archiving. And precondition is setting the deletion indicator.

But in your inconsistency case the archiving program cannot help you, you need to use the cleansing reports from the OSS note

[Former Member]

Hi;

Please check these conditions:

1. If any of these records are flagged for deletion?

2. If both inforecords are created with diff purchase org ?

Check if this message is Message no. 06312- PIR already exits is configured in your system.

Most IMP your screen shot does not allow us to see if same material/ text is used or not. it is hidden.

Check notes: Note 836917 - Duplicate or multiple info records,

Regards,

Priti.

[Former Member]

Hi Jurgen and Priti,

Thank you for the kind response. Sorry that I've to cancel the P/N and description just for confidentiality reason. Rest assured that these 2 parts number are the same and I would not asked in forum to create confusion. I've been viewing this forum since I started using SAP and realise how helpful the people are in in this forum

I've checked the following

1. neither records were flagged for deletion

2. Both are under the plant 6000 as per screenshot

I try click on the notes 836917, but it keeps prompting me to login, after I typed in my user name and password used in this forum, it just hangs there. how can I view the notes?

Thank you for the explanation.

[Former Member]

Hi,

Have you checked the message has been cofigured in your system?

Message no. 06312- PIR already exits is configured in your system

For checking notes you need to have have the ID PWD for service market place. Plz contact your basis person for the same also.

Regards,

Priti

[jagdeepsingh83]

Hi Levon

You can create two programs to clear the duplicate entries.. as SAP standard if you have two info records,system normally adopt the one that have lowest number. You have to create two programs to resolve this issue as per SAP note 836917. You can ask you basis guy to give you and abaper the correction instructions about the program ZCOREINA and ZDLEINAE.

Thanks,

Jagdeep

[JL23]

Unfortunately your screenshot does not qualify for an analysis since you hided the important information from us which makes an info record a duplicate .

But believing your analysis  the root cause to the problem is the data migration as explained in OSS notes 327083, 326028 and 836917 - Duplicate or multiple info records