Exporting master data

[Former Member]

Hello all,

How can I export customer master data from 3 different tables (KNB1 and RF02D); having the results on the same view. to be specific I would like to extract fields KUNNR, SORT1 , SORT2, ACTKN

Please help!!

Edited by: TosinSD on Aug 14, 2011 7:12 PM

[Former Member]

Hi,

Refer below thread

[http://help.sap.com/saphelp_46c/helpdata/en/74/5f5238f40c11d2adff080009d2232d/content.htm]

Thank,s

[Former Member]

Hi TosinSD,

You can use a Simple SQ01, SE16 or better if you use a MW like Business Objects.

The RF02D is an structure, you need the table:

- KUNNR -- table KNA1, KNB1

- SORT1 / SORT2 -- table ADRC, you need to get the KNA1.ADRNR and map it to ADRC.ADDRNUMBER

- ALTKN --- table KNB1

Regards

Daniel