topic DATA RETRIVAL in Application Development and Automation Discussions

DATA RETRIVAL

Former Member — Thu, 12 Jan 2006 06:12:32 GMT

Hi All!

I have to retrieve the customer details from ADRC table based on Customer Account number BKORM-KONTO.Please advice with the logic to retrieve.

Thanks in advance

Kumar

Former Member — Thu, 12 Jan 2006 06:19:52 GMT

Hi,

KNA1-KUNNR will be your Customer no.

KNA1-ADRNR will be your Customer address no.

ADRC-ADRNR based on this you can fetch customer details.

Thanks.

If this helps you reward with points.

Message was edited by: KDeepak

Former Member — Thu, 12 Jan 2006 06:23:29 GMT

Hi praneeth,

1. In same table BKORM

there is one field KOART

(account type)

2. If it is D = Vendor

then

fetch ADRNR

from table LFA1,

where LIFNR = BKORM-KONTO

Then fetch details

from table ADRC

where ADDRNUMBer = ADRNR (from above)

3. If it is K = Vendor

same for customer

in table KNA1

(field is ADRNR)

regards,

amit m.

Message was edited by: Amit Mittal