Skip to Content
avatar image
Former Member

Update/Insert Dbase Tables

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    Jul 09, 2009 at 02:38 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 09, 2009 at 02:39 PM

    Hi,

    Check if these solve your purpose:

    BAPI_ADDRESSORG_CHANGE

    BAPI_ADDRESSPERS_CHANGE

    BAPI_ADDRESSCONTPART_CHANGE

    Thanks,

    Wenonah

    Add comment
    10|10000 characters needed characters exceeded

  • Jul 09, 2009 at 02:43 PM

    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

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 22, 2009 at 02:20 PM

    closing issue

    Add comment
    10|10000 characters needed characters exceeded