Vendor Balances table

[Former Member]

Hi,

We are developing a report on vendor balances.

We want to take the vendor total open items upto March 31, 2007 as a single figure, after that we want to show as invoice level.

In which table we can get consolidated fiscal year wise open items for vendor.

Sateesh

[former_member194797 · Accepted solution]

See table LFC1 - Vendor master (transaction figures).

[Former Member · Accepted solution]

Thanks Henri,

I need one more clarification on this.

Does the tables consolidates upto that period?.

Whenever posting done against that vendor does it reflects immediately in this table.

Sateesh

[former_member194797]

LFC1 is continuesly uptodate. Just not forget balance carryforward at beginning of year.

The balance at the end of a month = LFC1-UMSAV + LFC1-UM1S - LFC01-UM01H ... + LFC1-UMxxS -LFC1-UMxxS where xx is the number of the month.

Use a DO n TIMES with 2 VARYING options for computing this balance.

[Former Member]

hii..

Use table BSIK,LFA1,LFB1,RF140,BSAK & SKAT for developing a report for vendor open items.

Regards,

Aakash

[Former Member]

HI

Using Logical database KDF would be more appropriate and time saving in terms of performance.

Thanks

Anupam

[Former Member]

Hi

You can use table BSIK for the same. However using a logical database KDF

Thanks

Anupam

[Former Member]

Hi Anupam,

Thanks for Quick reply.

If we extract all the years data it will be big pain to our local database table.

Thats why we want to take consolidate balnces upto last fiscal year, after that we want to show the invoice level.

Sateesh