You would like to report on the Main Account checkbox in the contact master data, however this field is not available in any data source. You would like to know if there is any way to create reports that include this field.
SAP Cloud for Customer
Reproducing the Issue
- Go to the work center Customers, view Contacts.
- Open a contact.
- Go to the tab Relationships.
- At the bottom of this screen, there is a checkbox called Main Account. You would like to report on it.
The data source Business Partner Relationship (CODBPRELATIONSHIP) contains the field Reverse Default Indicator which can be used for this purpose. It is labeled more generically since this data source contains relationships of all kinds, not only contact person relationships.
So when building a report based on that data source, a restriction can be set to return only contact persons. To do so, set a selection on the field Relationship Name = BUR001 (Contact Person Rel.ship).
business analytics, missing field, main account, Business Partner Relationship, CODBPRELATIONSHIP, Reverse Default Indicator, analysis , KBA , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , How To