SAP Knowledge Base Article - Public

2453500 - How to Export Notes Using Data Workbench


How to export the Notes for Data Workbench Objects like Accounts, Contacts, Opportunities and so on using Data Workbench.


To export the notes you can follow the below steps

  1. Go to Data Workbench work center
  2. Select Export View
  3. Select Account Notes / Contact Notes object
  4. Select All Data or Select the Account for which you want note to be extracted
  5. Select Next
  6. Select Export Data

Also as a workaround, you may extract the Notes for the objects like Accounts, Contacts, using the below steps.

  1. Go to Administrator work center
  2. Go to OData Service Explorer view
  3. Show SAP Odata Services
  4. Highlight the Service name: c4codataap1 and select Test
  5. On the OData Console, in the left pane, select the Entity Set (for Example: AccountNotesCollection)
  6. Select the Test tab
  7. Copy the URL available in the Request Method GET
  8. Run the the query in Chrome browser
  9. Select the Object ID for any Account, which is obtained from the execution of the above URL (for example: 00163XXXXXXXXXXXXXXXXXXXXXXXXXXX)
  10. Now query'<ObjectID>')/CorporateAccountTextCollection
  11. You will be able to see the Account Notes maintained for the Account
  12. Similarly, for Contacts we have the Entity Set ContactNotesCollection
  13. The query is
  14. Select the Object ID for any Contact, which is obtained from the execution of the above URL (for example: 00163YYYYYYYYYYYYYYYYYYYYYYYYYYY)
  15. Now query'<ObjectID>')/ContactTextCollection


Data Workbench, Export Notes using Data Workbench , KBA , data workbench , export notes using data workbench , LOD-CRM-INT-DWB , Data Workbench , How To


SAP Cloud for Customer 1805 ; SAP Cloud for Customer add-ins 1802 ; SAP Cloud for Customer add-ins 1808 ; SAP Cloud for Customer add-ins 1811 ; SAP Cloud for Customer add-ins 1902 ; SAP Hybris Cloud for Customer add-ins 1711