ABAP query - Customer master

[Shiva_Ram]

Hi,

I would like to extract customer details like name,street,city,country,region (which is structure ADDR1_DATA)using customer number.I also would like to use structure RF02D-vkorg and table KNVK-name1 to extract the details. Any help how to extract using an ABAP query? Is there any standard function module or standard logical databases table availble?

Thanks in advance.

Message was edited by: Shiva Ram

[Shiva_Ram]

Is this useful: <b>BAPI_CUSTOMER_GETDETAIL2</b>

[Former Member]

Is this useful: <b>BAPI_CUSTOMER_GETDETAIL2</b>

[Former Member]

U can write a program and inside use FM (BAPI_CUSTOMER_GETLIST) to fetch the customer address details and other details using select statement.

Alos, U can write q query using SQ01 wherein u can specify the necessary required tables and automatically the code is generated.

Pl. award points if helpful.

[Shiva_Ram]

Hi,

Thanks for your response. But this function module does not fetch the contact person details.

If I am missing something, can you clarify?

Thank you

[Former Member]

Use the FM BAPI_ADDRESSORG_GETDETAIL

The Import parameterds should be

OBJ_TYPE = 'KNA1'

OBJ_ID = (customer number )

CONTEXT 0001

IV_CURRENT_COMM_DATA X

The FM can be used to get the details for vendor as well as the customer .

In case of vendor use 'LFA1' for OBJ_TYPE.

Let me know if still do not get the required customer data .

Regards,

Vijay .

[Former Member]

Take a look at this: <b>BAPI_CUSTOMER_GETCONTACTLIST</b>

[Shiva_Ram]

Hi all,

Thank you for your responses. I found one of the tables in the system ADRC and after joining this table with other tables I got the required details.

Once again thank you for quick responses.