Download all addresses in SAP

[Former Member]

Hi everybody,

I have to implement a report that downloads all available and active adresses that are stored in SAP-system to a file. How can I implement this= Is there eprhaps something like a SAP-standard report or perhaps a function module?

Or should I use the table directly? But which table really contains all the address-data?

Kind regards

JetGum

[former_member376453]

Check ADRC table, you will get all the active Business Addresses.

One more point is, depending on which you want to download all the data, like customer / Employee ??

Kuntal

Edited by: Kuntal Nandi on Mar 9, 2009 2:35 PM

[Former Member]

When you have found the addresses you need then you could extract them using the function modules ADDR1_EXTRACT_TABLES and ADDR2_EXTRACT_TABLES.

best wishes

Ed

[former_member156446]

Try this:

DATA: ADDR_GET_SELECTION  LIKE ADDR1_SEL.     
          
ADDR_GET_SELECTION-ADDRNUMBER = KNVK-ADRND.  

 CALL FUNCTION 'ADDR_GET'                       
  EXPORTING                                       
   ADDRESS_SELECTION = ADDR_GET_SELECTION  
   ADDRESS_GROUP     = 'CA01'    "check which category to use                     
    IMPORTING                                     
      SADR              = SADR                     
 EXCEPTIONS                                     
      OTHERS            = 01.

in Structure SADR you will have the address of the customer/vendor etc....