Symptom
Accounts has standard field named as 'Type'. This field is not extended in Standard 'Account Details' Data source and reports.
Environment
SAP Cloud for Customer
Reproducing the Issue
- Go to Customer work center.
- Go to Account work center view.
- Account screen OWL has column for standard field "Type".
- Click on Advance filter.
- Field name "Type" is available in advance filter of Account.
- Go to Business Analytics work center.
- Go to Data Reports work center view.
- Select the associated report of accounts you are designing.
- Go to Edit With
- Select the Report Wizard option from Edit with Drop down values.
- Go to 3 step Select Characteristics.
- In Column "Characteristic name", search for Type.
- "Type" name does not exist in reports.
Cause
"Type" field is currently not available as datasource in reports.
Resolution
Type field for account is not available in datasource for reports.
This is current and expected behaviour.
Note: Report datasource for Account has another field with name "Role", which can be used as workaround for unavailable field "Type". Role is the dropdown field with multiple value selection including values that are available for field "Type", namely customer, prospects.
Keywords
Account, datasource, reports, Field Role, Advance filter, Missing , KBA , LOD-CRM-ACC , Account , AP-RC-ANA , C4C, ByD, Travel: Analytics Tools & Frameworks , Problem
SAP Knowledge Base Article - Public