topic ABAP query - Customer master in Application Development and Automation Discussions

ABAP query - Customer master

Shiva_Ram — Tue, 20 Dec 2005 18:50:24 GMT

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

Re: ABAP query - Customer master

Former Member — Tue, 20 Dec 2005 19:17:57 GMT

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

Re: ABAP query - Customer master

Former Member — Tue, 20 Dec 2005 19:19:56 GMT

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.

Re: ABAP query - Customer master

Shiva_Ram — Tue, 20 Dec 2005 19:41:47 GMT

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

Re: ABAP query - Customer master

Former Member — Tue, 20 Dec 2005 19:56:36 GMT

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 .

Re: ABAP query - Customer master

Former Member — Tue, 20 Dec 2005 20:12:53 GMT

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

Re: ABAP query - Customer master

Shiva_Ram — Tue, 20 Dec 2005 21:13:01 GMT

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.