Skip to Content
Author's profile photo Jignesh Mehta

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.

untitled.JPG

Thanks,

Jignesh Mehta

Assigned Tags

      20 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Former Member
      Former Member

      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..

      Author's profile photo Jignesh Mehta
      Jignesh Mehta
      Blog Post Author

      Thank you Krishna.

      Appreciation from you all keeps us motivated.

      Author's profile photo G Lakshmipathi
      G Lakshmipathi

      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

      Author's profile photo Jignesh Mehta
      Jignesh Mehta
      Blog Post Author

      Thank you Lakshmipathi. 

      Appreciation from you all keeps me motivated.

      Author's profile photo Srinu S
      Srinu S

      Hello Jignesh,

        Thanks for posting this document and very useful document.

      thnaks,

      Srinu.

      Author's profile photo Jignesh Mehta
      Jignesh Mehta
      Blog Post Author

      Thank you Srinu.

      Author's profile photo Gurunath Kumar Dadamu
      Gurunath Kumar Dadamu

      Very helpful for the Abapers. 🙂

      Regards,

      Gurunath

      Author's profile photo Jignesh Mehta
      Jignesh Mehta
      Blog Post Author

      Thank you Gurunath

      Author's profile photo Former Member
      Former Member

      It is also helpful for one time customer in sales order.

      Regards

      Arun

      Author's profile photo Jignesh Mehta
      Jignesh Mehta
      Blog Post Author

      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

      Author's profile photo Former Member
      Former Member

      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

      Author's profile photo Jignesh Mehta
      Jignesh Mehta
      Blog Post Author

      Thank you Arun.

      Author's profile photo Former Member
      Former Member

      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 ...

      Author's profile photo Md. Enayet Hossain
      Md. Enayet Hossain

      hi Jignesh,

      Thanks for good documents.

      This is very helpful to customer master related.

      thanks

      Md. Enayet Hossain

      Author's profile photo Suman Sardar
      Suman Sardar

      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.

      Author's profile photo Jignesh Mehta
      Jignesh Mehta
      Blog Post Author

      Thank you Suman

      Author's profile photo Former Member
      Former Member

      Hi,

      Its really helpful...

      Thanks for sharing.

      Best Regards,

      Khushi

      Author's profile photo Jignesh Mehta
      Jignesh Mehta
      Blog Post Author

      Thank you Khushi Mughal.

      Regards,

      Jignesh Mehta

      Author's profile photo Former Member
      Former Member

      Useful one...Thanks.

      Best Regards,

      Naresh K.

      Author's profile photo sumit sharma
      sumit sharma

      Hi Mehta,

      Helpful Information......

      Regards

      Sumit