topic Re: tables for open items? in Application Development and Automation Discussions https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348397#M1035561 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>BSIK is the table of Vendor open items</P><P>FBL1N is the TCode of Vendor Line Item Display (Open/Cleared/All)</P><P></P><P>BSID is the table of Customer open items</P><P>FBL5N is the TCode of Vendor Line Item Display (Open/Cleared/All)</P><P></P><P>Regards,</P><P>Chandu</P></BODY></HTML> Tue, 19 Aug 2008 15:34:49 GMT Former Member 2008-08-19T15:34:49Z tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348393#M1035557 <HTML><HEAD></HEAD><BODY><P>hi,</P><P>can anyone tell me which table to use for the open items to display?</P><P>even if the vendors clering date is after key date it should have the vendor information in tnat table.</P></BODY></HTML> Tue, 19 Aug 2008 15:25:06 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348393#M1035557 Former Member 2008-08-19T15:25:06Z Re: tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348394#M1035558 <HTML><HEAD></HEAD><BODY><P>vendor open items? -&gt; table BSIK</P><P>Thomas</P></BODY></HTML> Tue, 19 Aug 2008 15:27:14 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348394#M1035558 ThomasZloch 2008-08-19T15:27:14Z Re: tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348395#M1035559 <HTML><HEAD></HEAD><BODY><P>Check this Tcode :- FBL1N</P></BODY></HTML> Tue, 19 Aug 2008 15:29:04 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348395#M1035559 former_member585060 2008-08-19T15:29:04Z Re: tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348396#M1035560 <HTML><HEAD></HEAD><BODY><P>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.</P></BODY></HTML> Tue, 19 Aug 2008 15:30:40 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348396#M1035560 former_member585060 2008-08-19T15:30:40Z Re: tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348397#M1035561 <HTML><HEAD></HEAD><BODY><P>Hi,</P><P>BSIK is the table of Vendor open items</P><P>FBL1N is the TCode of Vendor Line Item Display (Open/Cleared/All)</P><P></P><P>BSID is the table of Customer open items</P><P>FBL5N is the TCode of Vendor Line Item Display (Open/Cleared/All)</P><P></P><P>Regards,</P><P>Chandu</P></BODY></HTML> Tue, 19 Aug 2008 15:34:49 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348397#M1035561 Former Member 2008-08-19T15:34:49Z Re: tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348398#M1035562 <HTML><HEAD></HEAD><BODY><P>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.</P><P></P><P>Rob</P></BODY></HTML> Tue, 19 Aug 2008 15:48:43 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348398#M1035562 Former Member 2008-08-19T15:48:43Z Re: tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348399#M1035563 <HTML><HEAD></HEAD><BODY><P>can you explain me in detail?</P><P></P><P>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.</P><P></P><P>which table do i nedd to use?</P></BODY></HTML> Wed, 20 Aug 2008 06:38:10 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348399#M1035563 Former Member 2008-08-20T06:38:10Z Re: tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348400#M1035564 <HTML><HEAD></HEAD><BODY><P>Have a look at the transactions the others have mentioned.</P><P></P><P>Rob</P></BODY></HTML> Wed, 20 Aug 2008 12:51:22 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348400#M1035564 Former Member 2008-08-20T12:51:22Z Re: tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348401#M1035565 <HTML><HEAD></HEAD><BODY><P>they have not mentioned transactions they have mentioned tables.</P><P>thanks</P></BODY></HTML> Thu, 21 Aug 2008 07:25:34 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348401#M1035565 Former Member 2008-08-21T07:25:34Z Re: tables for open items? https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348402#M1035566 <HTML><HEAD></HEAD><BODY><P>FBL1N is the transaction that the others mentioned.</P><P></P><P>Rob</P></BODY></HTML> Thu, 21 Aug 2008 12:56:05 GMT https://community.sap.com/t5/application-development-and-automation-discussions/tables-for-open-items/m-p/4348402#M1035566 Former Member 2008-08-21T12:56:05Z