topic Re: Update/Insert Dbase Tables in Application Development and Automation Discussions

Update/Insert Dbase Tables

Former Member — Thu, 09 Jul 2009 14:28:52 GMT

Hi,

Am trying to update/insert some fields into the sap tables like ADR2,ADR3,ADR6 . Are there any FM to do this or best way to achive this rather than updating/inserting directly?

am using the code as below :

UPDATE adr6 SET smtp_addr = lv_smtp_addr

WHERE persnumber = lv_persnumber.

Thanks,

Kumar.

Re: Update/Insert Dbase Tables

kanishakgupta1 — Thu, 09 Jul 2009 14:38:59 GMT

I came accross such a requirement but couldn't find a single function module.

I think try using both the FM's else BDC is the only option left.

you can use the FM "DEBITOR_BDCDATA" to get the BDC data for vendor and then edit it to add the address fields required.

regards

kanishak

Re: Update/Insert Dbase Tables

Former Member — Thu, 09 Jul 2009 14:39:38 GMT

Hi,

Check if these solve your purpose:

BAPI_ADDRESSORG_CHANGE

BAPI_ADDRESSPERS_CHANGE

BAPI_ADDRESSCONTPART_CHANGE

Thanks,

Wenonah

Re: Update/Insert Dbase Tables

RaymondGiuseppi — Thu, 09 Jul 2009 14:43:18 GMT

SAP provides a list of the BAPI for [Business Address Services (BC-SRV-ADR)|http://help.sap.com/saphelp_sm32/helpdata/en/c8/13b237b9a9a968e10000009b38f8cf/frameset.htm], look at [BAPI Function Modules|http://help.sap.com/saphelp_sm32/helpdata/en/ed/622e29b36ae44e97f4a36397520e11/frameset.htm]

Regards,

Raymond

Re: Update/Insert Dbase Tables

Former Member — Wed, 22 Jul 2009 14:20:49 GMT

closing issue