SAP Knowledge Base Article - Public

2323955 - Purchase Request ID Missing When you Export Open Purchase Requests to Excel

Symptom

You want to export open purchase requests to Microsoft Excel. However system failed to show the field Purchase Request ID in the excel sheet

Reproducing the Issue

  1. Go to the Purchase Requests and Orders work center
  2. Go to the Purchase Requests view
  3. Select the query Open Purchase Requests
  4. Select Export & To Microsoft Excel
  5. In the excel sheet, the field Purchase Request ID is missing

Cause

When you export the open purchase requests, we do not display the Purchase Request ID on the excel sheet. Because the purchase request ID is a combination field which joins purchase request ID and purchase request Item ID at runtime & hence it is not pulled into the excel sheet during export.

Resolution

There is a field called Purchase Request ID which is hidden in the personalization screen, you can enable this field on the purchase request screen & then export to excel. Now the Purchase Request ID will be visible in the excel sheet.

  1. Go to the Personalize & select This Screen
  2. Select Purchase Requests section
  3. Go to the fields section & select the check box for Purchase Request ID
  4. Select Save

Keywords

KBA , AP-PRP , Purchase Request Processing , How To

Product

SAP BUSINESS BYDESIGN 1705 ; SAP BUSINESS BYDESIGN 1708 ; SAP Business ByDesign 1711 ; SAP Business ByDesign 1802