KNA1 - Customer Information

[Former Member]

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.

[Former Member]

Check with ADRC Table

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

Thanks

Seshu

[Former Member]

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

Greetings,

Blag.

[Former Member]

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.

[Former Member]

Thank you (points awarded.)

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

Thanks,

John

[Former Member]

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.