BSID table

[former_member799271]

My client has below requirment, pl guide me how can i achieve this.

Customer balance FBL5N as on 31.03.2020 if i consider all open items its displaying including cleared items as well. but in BSID table if i pass Co.code , customer account document date as on 31.03.2020 balances are comming only open items.

in BSID table which criteria needs to be give to match with my FBL5N report as on 31.03.2020.

based on this i have to give logic.

[raymond_giuseppi]

Change your tag as SAP IQ doesn't seem relevant?

[raymond_giuseppi]

Some basic on ,FI index tables

• BSID contains the currently uncleared items
• BSAD contains the currently cleared items

If you want to display the balance at a past reference date, you have to

• add BSAD records with a clearing date greater than the reference date
• only select records in both tables with a posting date less or equal to the reference date

[former_member799271]

Thanks Raymond, it was useful. 🙂

[RolandKramer]

Hello prakash1984

Please check the Blog - SAP ILM based on SAP IQ Database as you will find details for the ILM Archiving there.

Best Regards Roland

Please follow the Rules of Engagement