Issue in duplicate condition record number update in table level.

[Former Member]

Hi Gurus,

I have one issue in pricing condition records(VK11). User maintained the condition records with three different dates like below.

Valid from      Valid to               Amount    

05/13/2014     04/02/2015          24.50

04/03/2015     04/30/2015          24.50

05/01/2015     12/31/9999          24.50.

As per the above details those records has not interlinked with other records. All are individual. But after saving these records it has updates in table "A559" like below.

V	ZG10	NL01	1205468	25010-PWR	04/02/2015	05/13/2014	0052147684
V	ZG10	NL01	1205468	25010-PWR	04/30/2015	04/03/2015	0062540462
V	ZG10	NL01	1205468	25010-PWR	12/31/9999	05/01/2015	0052147684

Here the 1st and 3rd condition record has the same condition record number "0052147684".

Could you please let me know why is has happened like this.

Note: In VK11 1st and 3rd condition records are in Green color and 2nd condition record is in Black color. Please explain it what could be the reason behind this.

Thanks in advance.

Regards,

Venkatakiran Boru.

[tao_sun2]

Hi Kumar,

Are you sure you created condition records with same amount (24.50) for 3 difference periods?

It doesn't make sense.

The only possibility that duplicated KNUMH occurs in standard system is described in note 66943.

This means you first created a condition record with amount 24.50 from 05/13/2014 to 31/12/9999.

Then you inserted a condition record with a different amount 25.00 from 04/03/2015 to 04/31/2015.

In this case, the first and third condition record have the same number. This is standard behavior.

Best regards,

Tao

[Former Member]

Hi Kiran,

by using T.Code VK11 and maintain condition record thrice and every time system generate different ConditionRecond No.

Find below records maintained in my system.

PR00	1000	10	60001304		15.05.2015	13.05.2015		0000402948
PR00	1000	10	60001304		20.05.2015	16.05.2015		0000402949
PR00	1000	10	60001304		25.05.2015	22.05.2015		0000402950
PR00	1000	10	60001304		31.12.9999	26.05.2015		0000402951

It is very strange how you maintain condition record so that system give you same number?

If your maintenance of condition record process is correct still getting same issue please raise OSS message to SAP.

Regards

Arun

[Former Member]

The details which i provided i just copy from SAP and Pasted here.

[moazzam_ali]

Hi

What do you mean green color and black color in VK11? Could you please show that screen? Also update what have you maintained in access sequence for exclusive indicator field?

Thank$

[Former Member]

Its not an issue in access sequence for exclusive indicator field. My issue is Duplicate Condition record number update in table level.

[former_member183879]

Hi Kiran,

Using the condition record number, check in the table KONH if the deletion indicator is updated or not.

If I am not, one of the records should be having the deletion indicator, else the validity dates will be different.

[Former Member]

Hi Navaneetha,

Thank you for your reply.

As per your instructions i have checked in KONH table and i found only two entries.

52147684	EKAPITEI	13.05.2014	A	559	V	ZG10	NL01000120546825010-PWR	13.05.2014	31.12.9999
62540462	MXS0913	03.04.2015	A	559	V	ZG10	NL01000120546825010-PWR	03.04.2015	30.04.2015

Here in the above data the system mixed the 1st and last record and updated in single line. But no one record has deleted.

Regards,

Venkatakiran boru.