How to determine SAP GL ACCOUNT #

[Former Member]

hello,

I need to determine the SAP account number by using the company code and either the SAP Vendor # OR the SAP Customer #

What Tables do I need to look into to achieve this?

[Former Member]

Hi,

Check tables BSAK, BSIK, BSAD & BSID

Regards,

Satish

[Former Member]

Hi,

You can get all the G/L accounts for the company code in table [SKB1]...

thanks

Prashant Gupta

[Former Member]

Hi,

Check table

SKB1 G/L account master (company code)

[Former Member]

Thanks everyone...

This could help in a roundabout way...

If I grab the GL account from SKB1, how could I either determine Vendors # or Customer # associated with that GL #?

[Former Member]

Hi

Check [KNB1]

[Former Member]

Hi,

Vendor - Table LFB1 GL Account field is AKONT

Customer - Table KNB1 GL Account field is AKONT.

You can give the BUKRS and AKONT to verify in SKB1.

[Former Member]

Please note that Customer and Vendor ledger are linked to General Ledger through Reconciliation account. This reconciliation account is part of General Ledger.

You can use table KNB1- For customer and LFB1- For Vendor master. SAP stores the Reconciliation GL account in the field "AKONT" for above two tables.( Inofrmation is kept at company code level)

Regards

[Former Member]

I do not think reconciliation accounts are the same as GL accounts No?