SAP Knowledge Base Article - Public

3484734 - Field Name "Type" On Account Is Missing In Reports

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

  1. Go to Customer work center.
  2. Go to Account work center view.
  3. Account screen OWL has column for standard field "Type".
  4. Click on Advance filter.
  5. Field name "Type" is available in advance filter of Account.
  6. Go to Business Analytics work center.
  7. Go to Data Reports work center view.
  8. Select the associated report of accounts you are designing.
  9. Go to Edit With
  10. Select the Report Wizard option from Edit with Drop down values.
  11. Go to 3 step Select Characteristics.
  12. In Column "Characteristic name", search for Type.
  13. "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

Product

SAP Cloud for Customer add-ins all versions ; SAP Cloud for Customer core applications 2405