Changed Customer Address in Sales Document on Print-Outs
Hello All,
Normally we pick the Customer Address in Smartforms by taking Address Number from KNA1 & passing the same in ARDC Table. This will give Customer’s address as entered in Customer Master Record.
But think of a scenario where User has changed Customer Address in Sales Order & the same need to be printed in Print-Outs. How to ensure that this new (One-time) address is Printed in Sales Document Print-Outs.
Just like system assigns a address number to each Customer Master, similarly whenever the Address is changed in Sales Documents, system stores the new Address in ADRC Table with new Address number.
Ask your ABAPer to include the following logic in Smartform program:
Go to SE16N & Explore Table VBPA
Enter the relevant Sales Document Number & Partner Function & Execute.
Pick the Address Number (ADRNR) & pass the same to ADRC Table to get the changed address.
Also in VBPA the indicator (Address Indicator) – ADRDA is set to E if Address is changed in Sales Document Manually.
This will ensure that system will print the correct address in Sales Document Print-Outs.
Thanks,
Jignesh Mehta
Mehta,
Very helpful for the ppl like me who doesn't have realtime knowledge.. Looking fwd to read such kind of topics from you..
Regards
Krishna..
Thank you Krishna.
Appreciation from you all keeps us motivated.
Nice tips Jignesh but as you rightly indicated, predominently, we fetch the address from KNA1 table only for print outs. This being the case, I have a feeling that just for one scenario, it is not advicable to do ABAP coding. Instead coding should be in such a way that based on the logic what you have outlined, for all documents, system should fetch the address for print out.
Thanks
G. Lakshmipathi
Thank you Lakshmipathi.
Appreciation from you all keeps me motivated.
Hello Jignesh,
Thanks for posting this document and very useful document.
thnaks,
Srinu.
Thank you Srinu.
Very helpful for the Abapers. 🙂
Regards,
Gurunath
Thank you Gurunath
It is also helpful for one time customer in sales order.
Regards
Arun
Hello Arun,
Would you not like to try this your self in your Development server?
By the way, any address which is changed in Sales Doucment level, get a new Address number, which is stored in table mentioned above. Which means this will work for One time customers also.
Thanks,
Jignesh Mehta
Hi Jignesh,
I gave information that this very helpful if customer is one time customer. and we devlope as you said in my last project which is working well.
Regards
Arun
Thank you Arun.
Dear jiginesh sir ,, what ever you posted in scn forum that is more and more beneficial to me and others . to learn new new topics
thank you so much sir ...
hi Jignesh,
Thanks for good documents.
This is very helpful to customer master related.
thanks
Md. Enayet Hossain
Yes I really think this should be followed so that no user will be responsible for the changes and the his need will be fulfilled.
Thank you Suman
Hi,
Its really helpful...
Thanks for sharing.
Best Regards,
Khushi
Thank you Khushi Mughal.
Regards,
Jignesh Mehta
Useful one...Thanks.
Best Regards,
Naresh K.
Hi Mehta,
Helpful Information......
Regards
Sumit