open and cleared items

[Former Member]

Hi all!

I need help in retrieving open and cleared items? What tables to use? Is it BSAK and BSIK?

And how are this tables related to RSEG and RBKP?

Basically, I have 3 radiobuttons.

Open Items

Cleared Items

All Items.

[Former Member]

Hi,

Cleared Items

BSAD ........ Accounting: Secondary Index for Customers (Cleared Items)

BSAK .........Accounting: Secondary Index for Vendors (Cleared Items)

BSAS ......... Accounting: Secondary Index for G/L Account (Cleared Items)

Open Items

BSID ........... Accounting: Secondary Index for Customers

BSIK .......... Accounting: Secondary Index for Vendors

BSIS ......... Accounting: Secondary Index for G/L Account.

RSEG and RBKP are linked with these fields

BELNR.......Accounting Document Number

GJAHR.......Fiscal Year

Hope this helps...

Best regards,

raam

[Former Member]

Thanks so much for the reply.

Clarification:

You said that rseg and rbkp's belnr is connected to bsak and bsik.

Is it the belnr of bsak and bsik that is connected to rseg and rbkp or the augbl?

rseg-belnr eq rbkp-belnr = bsak/bsik-belnr? or bask/belnr-augbl?

Thanks!

Edited by: navi on May 2, 2008 2:51 PM

Edited by: navi on May 2, 2008 2:55 PM

[Former Member]

Hi Navi,

U can check out all these tables in SE11 or SE16 by giving BS* in the input field on table name and press F4.

reward if helpful

raam

[Former Member]

Hi,

I see that the values of belnr under the BSIK/BSAK is different from that of RSEG and RBKP.

Am i right in concluding that they may not be connected or linked after all?

Pls. reply.

Thanks!thanks!

[Former Member]

Hi Navi,

I said RSEG and RBKP are linked with these fields

BELNR.......Accounting Document Number

GJAHR.......Fiscal Year

BSAK-BELNR is different from RBKP-BELNR.

If u want to link BSAK Table and RBKP Table using Field LIFNR--->Account Number of Vendor or Creditor

Please check this out

Hope this helps...

reward if helpful

raam