topic Re: KNA1 - Customer Information in Application Development and Automation Discussions

KNA1 - Customer Information

Former Member — Tue, 26 Jun 2007 20:49:03 GMT

Hi,

KNA1 contains customer information (name, address and etc.)

Where is the customer phone number stored and how do I get to it?

Also, where is the supplier stored (say my company information)?

Thanks,

John

Points will be rewarded and all help will be greatly appreciated.

Re: KNA1 - Customer Information

Former Member — Tue, 26 Jun 2007 20:52:54 GMT

Check with ADRC Table

Take KNA1-ADRNR field and do compare with ADRC ,here ADRC-tel_number

Thanks

Seshu

Re: KNA1 - Customer Information

Former Member — Tue, 26 Jun 2007 20:54:26 GMT

Not sure...But I think that it's on KNB1....Field TLFXS.

Greetings,

Blag.

Re: KNA1 - Customer Information

Former Member — Tue, 26 Jun 2007 21:04:36 GMT

Even though your company is the supplier to your customers, your company is not stored in your system as a supplier. Your company will be stored in your system as a company code and it will be in T001. Your company will be stored in your customer system as a vendor/supplier.

Your suppliers are stored in LFA1. You will apply the same rule everywhere to get the address details, i.e, find ADRNR from KNA1, T001 or LFA1 and then go to ADRC with that number to get the rest of the details.

Re: KNA1 - Customer Information

Former Member — Tue, 26 Jun 2007 21:29:09 GMT

Thank you (points awarded.)

Do you by any chance know how to find the supplier based on the invoice (VBELN) number?

Thanks,

John

Re: KNA1 - Customer Information

Former Member — Tue, 26 Jun 2007 21:35:20 GMT

Are you talking about customer invoice or vendor (supplier) invoice? If it is customer invoices, then the information is on VBRK, VBRP tables and if it is vendor (supplier) invoice, then look at RBKP, RSEG.