Skip to Content
author's profile photo Former Member
Former Member

Entries not found in table BSIS for a particular G/L Account

Hi,

When I display a Document through FB03 Eg. '3062000670', I can see that two G/L are being hit

3000 1 40 5700700 LHW 2,464,177.00

3000 2 50 1990990 GL-Initial BalUpload 2,464,177.00-

When I goto to the table BSIS to Display the lineitems of the G/L '5700700' , no entries are found.

I have to write a report based on the G/L Account .

Please help.

Salman Zahir

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

2 Answers

  • Best Answer
    Posted on Mar 17, 2009 at 07:28 AM

    Check in BSAS and BSEG.

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Thanks for your quick answer,

      I have checked the table BSAS as well, it also has no entries corresponding the above G/Laccount.

      I can find the entries in BSEG for that G/L, but since it does not have the G/L account as primary key

      my program will take very long processing time as the user will give range of G/L accounts.

      When I Check the Report FS10N with the same G/L account, and double click to see the lineitems

      it also gives me the message 'no line items found' eventhough it shows some amount in the first screen.

      Salman Zahir

  • author's profile photo Former Member
    Former Member
    Posted on Mar 17, 2009 at 07:35 AM

    Hi,

    You should be able to find it in these tables below:

    BSID = Accounting: Secondary Index for Customers (Open Items)

    BSIK = Accounting: Secondary Index for Vendors (Open Items)

    BSIS = Accounting: Secondary Index for G/L Accounts (Open Items)

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

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

    BSAS = Accounting: Secondary Index for G/L Accounts (Cleared Items)

    Regards,

    Lim...

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Can you try to do SQL trace ST05 to SAP program, and see which other tables may be used? I doubt SAP just store the data in BSEG, which is very costly to access, it should have other tables for the performance reason.

      Regards,

      Lim...

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.