tables for open items?

[Former Member]

hi,

can anyone tell me which table to use for the open items to display?

even if the vendors clering date is after key date it should have the vendor information in tnat table.

[Former Member]

hi,

can anyone tell me which table to use for the open items to display?

even if the vendors clering date is after key date it should have the vendor information in tnat table.

[ThomasZloch]

vendor open items? -> table BSIK

Thomas

[former_member585060]

Check this Tcode :- FBL1N

[former_member585060]

All open items for vendor are in BSIK. If an item is cleared, it will then be transfered to BSAK. Here, the clearing document is assign to the AUGBL field.

[Former Member]

Hi,

BSIK is the table of Vendor open items

FBL1N is the TCode of Vendor Line Item Display (Open/Cleared/All)

BSID is the table of Customer open items

FBL5N is the TCode of Vendor Line Item Display (Open/Cleared/All)

Regards,

Chandu

[Former Member]

As the others have said, BSIK has the open items, but if you want items open at a key date, you will also have to look at BSAK (cleared vendor items) and check the clearing date (AUGDT) against the key date.

Rob

[Former Member]

can you explain me in detail?

my problem is : if the key date is 31st march and if some vendors have clearing date as 5th april even then it should display me this record for the given key date.

which table do i nedd to use?

[Former Member]

Have a look at the transactions the others have mentioned.

Rob

[Former Member]

they have not mentioned transactions they have mentioned tables.

thanks

[Former Member]

FBL1N is the transaction that the others mentioned.

Rob