Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

Vendor's Credit/Debit Balance

Former Member
0 Kudos

Hi,

which table/transaction can I use to check whether the vendor has a credit or debit balance?

Thank you.

7 REPLIES 7

Former Member
0 Kudos

Hi Ravi,

you can use SHKZG field of table BSEG to check if it is a Debit or Credit balance.

If BSEG-SHKZG = H

It is CREDIT

IIf *BSEG-SHKZG = S8

It is DEBIT

Please set to resolve if it helps you.

Regards

Abhii...

0 Kudos

>

> you can use SHKZG field of table BSEG to check if it is a Debit or Credit balance.

> Please set to resolve if it helps you.

That would only tell you if an individual line item is a debit or a credit, not the vendor balance.

Rob

0 Kudos

Hi Rob,

DMBTR is the field which will give the balance.

Thanks for reminding Rob

Regards

Abhii...

0 Kudos

>

> DMBTR is the field which will give the balance.

BSEG-DMBTR is the amount of an individual line item, not the balance.

The balance of an account is the sum of all transactions (taking DRs and CRs into account) for a particular fiscal period (usually a month or year).

Table LFC1 holds the balances by month.

Rob

Edited by: Rob Burbank on Nov 12, 2009 10:39 AM

0 Kudos

Hello Rob,

I used your cue

Did a where-used & found that we have a trxn J1GVL which displays the Vendor Balances.

Thanks,

Suhas

PS: What naming convention did SAP use to name this trxn? I mean without knowing the table how can someone ignorant(read: me) get hold of this trxn ?

Edited by: Suhas Saha on Nov 12, 2009 5:14 PM

0 Kudos

>

> Did a where-used & found that we have a trxn J1GVL which displays the Vendor Balances.

I don't see this transaction in R3.

Anyway, I know there is an item on the Financial Accounting menu path that shows vendor balances. I ran that and used ST05 to find the table.

Rob

0 Kudos

Hello Rob,

I got the trxn. it is FK10N. ( BSI K and BSA K )

For vendors it is FD10N(BSI D & BSA D ) & G/L a/c's FS10N (BSI S & BSA S )

I think now i will remember the trxn names.

BR,

Suhas

PS:

I don't see this transaction in R3.

I am tired of saying i am still in ECC5.0 :'(