change VBPA-ADRNR for a particular sale order

[milascon_daniel]

Hi abapers,

i have spent a lot of time searching for a solution to my requirement and i have not found yet.

My requirement is that i want to change field VBPA-ADRNR with an existing one for a particular sale order for partner role RE.

I tried with BAPI_SALESORDER_CHANGE but it creates a new address number every time.

If there is no standard SAP function, it is advisable to manually change value of this field using SQL statement UPDATE from a ABAP program?

Thank you.

[Former Member]

Similar discussion happened in the below link-

Venk@

[milascon_daniel]

that discusion doesn't help me so much.

yes, USEREXIT_SAVE_DOCUMENT it's an option but this is not so usefull for me because a lots of sales order are created yet.

Anyone? any idea?

[Former Member]

Technically speaking, you shouldn't update address number field in partner table (VBPA) directly.

What do you want to do? If you want to change the Bill-to party adress, just change the Bill-to party customer number, with the proper customer number which has the address you want to display.

If the address you want to change is only for printing purposes, it's better to determine the address number in Smartforms/SAPscript with some programming logic, but leaving the sales document unchanged.

Regards

[milascon_daniel]

customer is one time account.

because it's one time account, sap split billings. that's why i want to update all the VBPA-ADRNR to all sale order to be the same.

[Former Member]

have you tried this FM?

SD_SALES_PARTNER_MAINTAIN

[Former Member]

Hello Dan,

Please update thread with solution you adopted to resolve issue.

I have similar issue and looking for best suitable answer.

Regards,

Dhanraj