Possible to do data patching of Ship-to address in DO?

[Former Member]

Dear Experts,

Is it possible to do data patching of ship-to address in DO, after DO has been PGI?

The Ship-to Addresses in multiple DOs for 1 single order were all over-written by the last DO ship-to address.

Pls advise.

Thanks and Rgds,

Betty

[Former Member]

Hi

I guess you would have a pre production system. Please check in that. As far as I can say, it would not have any major impacts at all. But for your own safety, try to follow the same procedure in the pre production system. But as I said, it is neither prudent nor advisable to change table entries when it concerns just sanity of data in the database related to some ship-to.

Regards

Indranil

[Former Member]

Hi Indranil,

Thank you very much for your advise.

Appreciate it lots.

Rgds,

Betty

[Former Member]

At least the OSS note will take care of future such issues.

For this issue your options are pretty limited. But here is what you can do.

1. Check in ADRC table the different address numbers maintained for this ship-to. Ideally if you have changed it only once, then there would be 2 different address numbers. One for before the change and the other after the change.

2. So after the ship-to address was changed, the WE partner function address numbers in the VBUP table that is the ship-to party address numbers in delivery were all changed to the new number.

3. To rectify this you would have to get the old address number, in the address number field of VBUP table (VBUP-ADRNR)

4. Since you cannot change the address in the deliveries now as GI has been done and invoicing has been done, the only way is to change the table entries for such affected deliveries as suggested above.

It is too much of a pain if you are only doing this to keep a sanity of data.

Regards

Indranil

[Former Member]

Hi Indranil,

Thanks alot for your prompt advise!

You mentioned that the only way is to change table entries, do you mean that we can "patch" the correct address numbers into VBUP table directly? What is the risk of doing so and will it cause any data corruption or something?

Hope to get clear understanding of the consequences for this course of action.

Thanks and Rgds,

Betty

[Former Member]

It is not possible directly in the delivery, but why do you want to change it now when the FY has been closed? What is the final aim of changing the delivery addresses?

Indranil

[Former Member]

Indranil

Because as I've mentioned earlier, the issue arises when we have just discovered that all the Ship-to Addresses in parital DOs for 1 single order were all over-written by the last DO ship-to address.

We have checked and realised this over-writing of ship-to address is SAP standard feature, and have followed an OSS note to rectify the issue of over-writing.

However the past transaction data is not accurate, and hopefully we can patch back the correct data, so that it will not create more confusion.

Pls advise.

Thanks and Rgds,

Betty

[Former Member]

It is not possible to patch the Ship-to address in a DO after goods issue has already been done. Please reverse the goods issue for the DO and then you can change the ship-to address in the delivery.

Indranil

[Former Member]

Hi Indranil

We are unable to reverse the PGI, as the number of records affected is approximately 10,000 and those records are past transactions from last FY, thus most have been invoiced.

Any other ways that we can rectify this?

Pls advise.

Thanks and Rgds,

Betty