topic ADR6 table in Application Development and Automation Discussions

ADR6 table

Former Member — Tue, 11 Dec 2007 09:44:42 GMT

Hello all,

I have a requirement to save the e-mail of a partner, but this needs to be sales order dependent address.

See this scenario: if you go create a sales order in VA01, go to partner tab and change the address of a selected partner you can get the e-mail and all the information saved (and this is related to the sales order itself). I can get all the information saved, but not the e-mail.. Do you know a Function that provides me that? I need to save the e-mail in table ADR6.... (sales order dependent)

Thanks a lot

Re: ADR6 table

Former Member — Tue, 11 Dec 2007 10:01:31 GMT

Hi,

I think you can use fm BAPI_ADDRESSORG_SAVEREPLICA after filling email address in BAPIADSMTP.

or you can try FM : ADDR_SAVE_INTERN

Reward points if helps.

Thanks

Sivaparvathi

Re: ADR6 table

Former Member — Wed, 19 Dec 2007 11:12:02 GMT

Hi all,

I still have this problem..

I tried to use the function, but nothing is saved in table ADR6:

ADR6_I-client = '120'.

ADR6_I-addrnumber = '9000004478'.

ADR6_I-date_from = '00010101'.

ADR6_I-consnumber = '001'.

ADR6_I-flgdefault = 'X'.

ADR6_I-home_flag = 'X'.

ADR6_I-smtp_addr = 'teste@teste.com'.

ADR6_I-smtp_srch = 'TESTE@TESTE.COM'.

CALL FUNCTION 'ADDR_SAVE_INTERN' IN UPDATE TASK

TABLES

adrc_d = adrc_d

adrc_u = adrc_u

adrc_i = adrc_i

adrct_d = adrct_d

adrct_u = adrct_u

adrct_i = adrct_i

adrp_d = adrp_d

adrp_u = adrp_u

adrp_i = adrp_i

adcp_d = adcp_d

adcp_u = adcp_u

adcp_i = adcp_i

adrt_d = adrt_d

adrt_u = adrt_u

adrt_i = adrt_i

adr2_d = adr2_d

adr2_u = adr2_u

adr2_i = adr2_i

adr3_d = adr3_d

adr3_u = adr3_u

adr3_i = adr3_i

adr4_d = adr4_d

adr4_u = adr4_u

adr4_i = adr4_i

adr5_d = adr5_d

adr5_u = adr5_u

adr5_i = adr5_i

adr6_d = adr6_d

adr6_u = adr6_u

adr6_i = adr6_i

adr7_d = adr7_d

adr7_u = adr7_u

adr7_i = adr7_i

adr8_d = adr8_d

adr8_u = adr8_u

adr8_i = adr8_i

adr9_d = adr9_d

adr9_u = adr9_u

adr9_i = adr9_i

adr10_d = adr10_d "*178i

adr10_u = adr10_u "*178i

adr10_i = adr10_i "*178i

adr11_d = adr11_d "*178i

adr11_u = adr11_u "*178i

adr11_i = adr11_i "*178i

adr12_d = adr12_d "*178i

adr12_u = adr12_u "*178i

adr12_i = adr12_i "*178i

adr13_d = adr13_d "*178i

adr13_u = adr13_u "*178i

adr13_i = adr13_i "*178i

adrcomc_d = adrcomc_d

adrcomc_u = adrcomc_u

adrcomc_i = adrcomc_i

adrg_d = adrg_d

adrg_u = adrg_u

adrg_i = adrg_i

adrgp_d = adrgp_d

adrgp_u = adrgp_u

adrgp_i = adrgp_i

adrv_d = adrv_d

adrv_u = adrv_u

adrv_i = adrv_i

adrvp_d = adrvp_d

adrvp_u = adrvp_u

adrvp_i = adrvp_i "*981u

adru_d = adru_d "*981i

adru_u = adru_u "*981i

adru_i = adru_i. "*981i

commit work and wait.

Please help me... I am sure that exists any function that allows me to do that..

Thanks and best regards

Re: ADR6 table

Former Member — Fri, 16 Oct 2009 16:01:56 GMT

Have you solved this task?

Re: ADR6 table

former_member191735 — Fri, 16 Oct 2009 16:17:47 GMT

When you change the address in sales order, the default address number will be changed to some 9000*** (or based on the number range) and this values are stored in VBPA table by the ordering party. for example, if you change sold to party address, you can see the address number will be changed in VBPA for sold to party.

At the same time, based on your change the related tables will be updated. I mean, if you change email, ADR6 will be updated with new record with the new address number. if it is phone, ADR3 will be updated.

VBPA-VBELN = VBAK-VBELN where vbpa-kunnr and get vbpa-adrnr

Get from ADR6 email using this addressnumber

Good luck

Re: ADR6 table

Former Member — Fri, 16 Oct 2009 16:55:41 GMT

Thanks.

But actually I have another task related to e-mail maintenance ADR6 and posiible witр the help of ADDR_SAVE_INTERN.

Re: ADR6 table

Former Member — Fri, 16 Oct 2009 19:41:14 GMT

Thanks for using the search, but I recommend opening a new question of your own to explain your question / discussion.

This thread is 2 years old. Even the technology and best practices have changed..

Cheers,

Julius

Re: ADR6 table

Former Member — Fri, 16 Oct 2009 19:48:09 GMT

Hi,

Try this "BAPI_ADDRESSORG_CHANGE".

Thanks,

Raj