Items missing in BSID table and available in BSEG And BKPF Tables

[former_member586210]

actually when i trying to find the line items(open items) in FBL5N And in BSID the system shows me that no values found. But in the G/L Balances (FS10N) and in Document entry view (Fb03) The values are there. So I need to to upload the data in BSID tables with Respect to GL Accounts and that data will not going to affect on other tables like BKPF and BSEG please suggest me the solution.

[former_member239428]

Just to clarify, you have a customer item in the accounting document right? I am just asking because you keep talking about G/L accounts.

[former_member586210]

Hi,

Yes,

We have a customer item in the accounting document

Thanks,

[iklovski · Accepted solution]

Hi,

You have to fully understand what you are doing. It is not just about allegedly missing data in BSID. BSID data is integrated in other totals table. You have to coordinate with your FI analyst and (s)he is better to be a good one. You have to see all the possible impacts and adopt a strategy to resolve the issue, if it was indeed a 'virus' as you put it. You have to consider restoring your database, for example. Again, all this I'm saying under assumption that this mysterious virus deleted just BSID and didn't touch anything else.

Regards,

Eli

[raymond_giuseppi]

To select open items you must provide a reference date, then read BSID (document item created before the reference date) AND BSAD (document item created before the reference date and cleared after reference date)

[former_member586210]

Hi,

Thank you for the reply.. But the thing is we came to know that, the entire database was crashed because of virus attack ..

and i have Searched with the reference number too.. in SE16N But i could't found..... the entire BSID Table is missing, So we need to upload it ..

So Can you please tell me how to upload into BSID table?

Thanks,

G.Anil Kumar

[raymond_giuseppi]

So a virus executed SE14 by mistake...

Did you company considere restoring data to a previous status ?

Else, did you execute some check reports such as SAPF190 and did you look at some correction reports such as SAPF070, but first you must send a message to OSS (under component FI-GL-GL-X) as there are some other programs that they will suggest (and call themselves)