Reporting of unused customer master data

[Former Member]

Hy experts.

I have to fulfil one issue: There should be many unused/redundant customer master data on our system.

Do anyone knows an report, which shows all unused/unbooked customers?

I have tried RFDUML00 and set the flag "accounts w/o sales", this would work. But one big issue, it doesn't consider archived bookings.

Thanks a lot

best regards

Roland

[Former Member]

hi,

You can check the list of customers from customer master data, now run FBL5N for all these customers selecting All Items radio button. Excluding these from the initial list will fetch you the desired list.

Regards,

GK

[Former Member]

Thanks for your answer, but there is still a question open...

We have 25000 customers with about 1.000.000 postings in BSID and BSAD. If I would run FBL5N I would get a very long list of all postings. Beside this, how can I match this list with the list of all customers?

The solution would be a generated list with one sum per customer. If I would have such a list, it won't be a problem to compare this with the list of all customers in Excel. But up to now, I do not find any list, which would offer this information for all years.

Regards

RoBr