Sales Order/Schedule agreement

[Former Member]

When sales order is created with ref. schedule agreement-save the document, but when I go back to another screen, I got this message update is terminated, I get the sales order number, but when I check, system shows on document.

Error Info... 00 671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC

Can any one help with this.

thanks

[Former Member · Accepted solution]

Dear Shahid,

First of all , kindly tell us why you have created Sales Order with reference to Scheduling Agreement?

You need not have to create Sales order with reference to Scheduling Agreement.

Scheduling Agreement has got its own schedule line.

So, you can directly create Delivery with reference to Scheduling Agreement.

In case of Contract, we create Release order (just standard Sales order) with reference to Contract and then create Delivery from the Release order.

Contract does not contain schedule lines of its own , therefore it requires Release orders to be completed.

But, Scheduling Agrement contains its own schedule line.

So, instead of creating Sales order, you create Delivery directly with reference to the Scheduling Agreement.

Regards

Pradyumna

[nisha_sharma1]

Hi,

This runtime error is because of number range inconsistency.

Go to transaction SE38

Execute report ->RSSNR0T1

Enter the number range object

and execute.

Hope this will solve the issue.

Best Regards,

Nisha

[jpfriends079]

Are you using internal number range?.

Have you changed the number range especially the current number manually?

Use tcode VOV8 and select the document type used for invoices. Double click on it and look at the document range number that it is using.

Then use tcode VN01, to check your number range, click on change status button. Go to the doc number range for your document type and maintain accordingly.

Also, check SAP Note 382954 - 00671: ABAP/4 processor: SAPSQL_ARRAY_INSERT_DUPREC, if you are on client version 45B.

Thanks & Regards

JP

[Former Member]

Hi,

Please check the number ranges assigned to Order documents.

You might have to assgin new number range for your order document type.

Regards

Vishal