Update/Insert Dbase Tables

[Former Member]

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.

[kanishakgupta1]

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

[Former Member]

Hi,

Check if these solve your purpose:

BAPI_ADDRESSORG_CHANGE

BAPI_ADDRESSPERS_CHANGE

BAPI_ADDRESSCONTPART_CHANGE

Thanks,

Wenonah

[RaymondGiuseppi]

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

[Former Member]

closing issue