topic Re: open and cleared items in Application Development and Automation Discussions

open and cleared items

Former Member — Fri, 02 May 2008 05:10:30 GMT

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.

Re: open and cleared items

Former Member — Fri, 02 May 2008 05:15:10 GMT

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

Re: open and cleared items

Former Member — Fri, 02 May 2008 06:50:37 GMT

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

Re: open and cleared items

Former Member — Fri, 02 May 2008 06:56:05 GMT

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

Re: open and cleared items

Former Member — Fri, 02 May 2008 08:27:30 GMT

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!

Re: open and cleared items

Former Member — Fri, 02 May 2008 11:25:03 GMT

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