Custmer balance

[Former Member]

Hi,

Does anyone know which table the customer balance is held?

I am tryin to do a join in quick viewer from KNB1 to another table to find out the balance (join on customer number I would have thought?).

Thanks

CT

[Former Member · Accepted solution]

Hi,

Try BSEG

[Former Member · Accepted solution]

Hi,

Thanks for the reply but quick viewer says BSEG cannot be used in a join for some reason?

Thanks

CT

[Former Member]

Hi,

Try BSID- WRBTR.

Regards,

Chandra

[Lakshmipathi]

Dear Chris

Not sure, how far you will succeed in using tables to find out customer balance, as it has to check multiple tables. Instead of you run Function Module BAPI_AR_ACC_GETOPENITEMS in SE37, it will give the exact figure.

thanks

G. Lakshmipathi

[Former Member]

Yeah not as simple as I thought.

Thanks for your help anyway, points awarded.