cancel
Showing results for 
Search instead for 
Did you mean: 

Customer Open Items Mapping

Former Member
0 Kudos

Hi gurus,

We're currently creating a new periodic statement specific for a new company code. I'm new to this so I'd like to ask your helping in mapping the open items per customer account.

What we would like to map in our periodic statement are the following:

Document Number:

Doc Date:

Due Date:

Amount:

I know that this can be retrieve in FBL5N however the table is structured. so I can't normally access it in se16.

I hope you could help us.

thanks,

john

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member188028
Active Contributor
0 Kudos

You have to collect the data from BSID and BSAD tables

BSID-Open items remians here

BSAD-Cleared items remains here

If you want to execute the report on back dated then you have to use clearing date to fetch the items from BSAD.

Rgds

Murali. N