Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

Updating Address changes

Former Member

‎2005 Sep 09 7:46 PM

0 Likes
3,537

Hi all,

Iam developing a new transaction where an user can change delivery even after GI has peen posted(std.SAP doesn't allow this).

In this , when an user wants to update address of the partners i do not want t change master data.

i want to create a new adr. number and store the address in that for the particular KUNNR.

any ideas on how to do this..

Thanks...

Hi all,

Iam developing a new transaction where an user can change delivery even after GI has peen posted(std.SAP doesn't allow this).

In this , when an user wants to update address of the partners i do not want t change master data.

i want to create a new adr. number and store the address in that for the particular KUNNR.

any ideas on how to do this..

Thanks...

Reply
8 REPLIES 8
Read only

Former Member

‎2005 Sep 09 8:10 PM

0 Likes
2,218

There is a reason why SAP does not allow changes to a delivery after it has been issued. Now what changes are you going to allow? How are you going to change the delivery? Are you going to update the tables directly(I hope not)?

When you are planning on changing the address of a partner on the document, don't you think it is too late to make those changes? What if you are allowing them change the ship-to address and the truck is already enroute to the old address?

All document specific addresses(if they are allowed by config) are stored in VBPA by their address number(VBPA-ADRNR). Even if you create a new address with a new address number, are you planning to update this field directly?

Please let the forum know your reasons/requirement.

Srinivas

Read only

RichHeilman
Developer Advocate
Developer Advocate
In response to Former Member

‎2005 Sep 09 8:13 PM

0 Likes
2,218

I agree with Srinivas, SAP is not allowing you to do this for a reason. If you are planning to do direct table updates, you are close the edge without a parachute.

Regards,

Rich Heilman

Read only

Former Member
In response to Former Member

‎2005 Sep 09 10:14 PM

0 Likes
2,217

surprisngly yes. iam doing direct table updates.

actually iam continuing the effort started by some one else and he told me that they did research into the options and had none except direct updates.

One reason he gave me is that SD is the only module being used in this client which is true and the other reason is SAP does not allow to pack and unpack after a PGI for a delivery. The business requirement is such that they have to change the packing sometimes even after PGI. and this was the driving factor for a custom transaction. Iam updating LIKP,LIPS,VBPA directly as of now.

Now they want to change address details of a partner and i was confused how to update those changes because there are three tables VBPA, ADRC and KNA1 involved.

I have seen that SAP is genertaing a new ADRNR in VBPA for a changed address ( also in ADRC ) but not touching KNA1.

Is there any other better way to do this whole thing or

this method ( updating tables directly is ok) if only SD is involved or no downstream applications.

Thanks for your previous input.

Greatly appreciate it..

Read only

Former Member
In response to Former Member

‎2005 Sep 09 10:28 PM

0 Likes
2,217

and also only a few specific PARVW are changed like 'CARRIER' etc.,

The packing and assigning to new HU's occurs at the "PORT OF EXIT" parvw.

i will get more business info on this...

Thanks

Read only

Former Member

‎2005 Sep 10 2:20 AM

0 Likes
2,217

Hi,

Check with your business if they can reverse Post Goods Issue with tcode VL09 to make the changes and later they can repost goods issue.

Also delivery billing will be impacted if FI implemented on your system.

Cheers.

Read only

Former Member
In response to Former Member

‎2005 Sep 10 5:14 AM

0 Likes
2,217

Sanjay is right. I was about to say the same thing. Why didn't they consider reversing the PGI, make the changes and then redo the PGI. Or even better, why don't you do it in your custom transaction like this. The end user doesn't to know about it. Only that they will see additional documents in the document flow.

I am still wondering how anyone agreed to this. Are you not under any strict auditing regime? This way of direct database table updates is the very first thing that ticks off the auditors. It raises a very big red flag with them.

Even if you are using it in a limited sense, using just SD, are you sure you have these changes under control? Where does the transactions stop in SAP. Do they go to SD billing and stop there or do they go further to FI? Are you sure changing the address does not impact business? What if some of those changes require redetermining transportation routing ir new payment terms or freight charges, or changes to the delivery time, now that the address is in Hawaii instead of Halifax?

Even the packing/unpacking, how are doing this? Are you not facing any issues with the inventory? Are you not having issues with your packing material? This must a lot complicated transaction than the VL02N itself. What controls do you have in place that it wont be misused or mishandled by a user?

Even if someone did it this way does not mean that we should support it. See if your client sees the validity of this argument and try to do what Sanjay has said.

I don't think there is any realistic solution to it if you still have to do it this way.

Regards,

Srinivas

Read only

Former Member

‎2005 Sep 12 7:22 PM

0 Likes
2,217

i found some answers from the business regarding reversing PGI and then changing delivery..

the reason they dont want to do this is they dont want the customer to receive more than one invoice or they dont want the customer to know about the process of packing and unpacking....

Billing is where the process comes to an end in this business client..

the user has access to my custom transaction if he would like to change delivery after PGI.

I have come to know that the team here contacted SAP in regards to this and finally arrived at this decision as they had no other option..

That is the reason i have to do direct table updates in my transaction as any BAPI/FM would gain not work for changing delivery doc after PGI.

Thanks a lot...

Read only

Former Member
In response to Former Member

‎2005 Sep 12 7:45 PM

0 Likes
2,217

I am confused here a little bit. The two reasons given by your business are

1. they dont want the customer to receive more than one invoice.

2. they dont want the customer to know about the process of packing and unpacking

Why they don't want the customer know about the unpacking and repacking? Will this not create a problem with the packing list? Wont the packing list that went out to the customer differ from the actual contents of the package? How will they reconcile this? Now if you don't want the customer know about this, for what reasons do you do this?

Will this change the charges to the customer? If so, then why there is a problem with sending a revised invoice? If not, then can you not simply stop re-sending the invoice?

Since they already went this route, I know you cannot change their mindset now. But I am curious as to how they unpacking and repacking after PGI, as you have to deal with handling units.

Just a thought, if this is all for internal reasons, why not build some Z tables to store all the changes and use them for all reporting purposes? Just a crazy thought.

Srinivas