How to find an empty field in CRM ?

[Former Member]

Hello,

I would like to find a list of Objects for which the field Country in the Address block is empty.

I tried to get a complete list in SAP with transaction ZORC, but the report is not trustable.

In my case, an Object can belong to a Contract, but genrally a Contract has several Objects, and that's the issue.

If I have one Contract per Object, then SAP can find the Country code in CRM, but if I have several Objects in one Contract, even if the Country code is exactly the same for each Object, this code is not reported by ZORC.

Do you know another way to sort out Objects with a specific empty field or a transaction in SAP to get a report showing the Country code in any case ?

Thanks for your help.

[spencer_liang]

The standard function is imcompleteness check. It will raise error if any customized field is not filled.