Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

BEx query - pulling data back at a point in time - FS-CD

Hello,

I work for an insurance company that uses the FS-CD module (cash receipts and disbursements).  FS-CD has a clearing process - for example, a premium receivable will be set up for a customer, and when we receive the payment, the receivable and payment will clear against each other.

There are times and other scenarios however where items will sit in suspense accounts.  I would like to build a BEx query that will allow users to see what items were sitting in suspense accounts at any point in time - currently, back at a random day, back at a quarter-end, etc - any date they select.  I believe this would be a combination of two scenarios:

  • Items that were posted before the user selected date, that are still open (has not cleared against another record yet).
  • Items that were posted before the user selected date, that cleared after that date.

Does something like this sound possible?  We have been using T-code FPo4 for this purpose, but with how much data resides in our FS-CD tables, that T-code is a big drag on our system.

Thank you for your help.

Angela

Tags:
Former Member
Not what you were looking for? View more on this topic or Ask a question