DATA RETRIVAL

[Former Member]

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]

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]

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