SAP Knowledge Base Article - Public

3780169 - Error Message "Error on sheet IS_EBDR_ADMIN, column B: field name REF_SYSTEM for structure SDBIL_EBDR_REQUEST_SENDLOGSYS is invalid" in the Manage Billing Document Request (F2960) App

Symptom

When importing an excel template in the "Manage Billing Document Requests"(F2960) app, the upload fails with the error: "Error on sheet IS_EBDR_ADMIN, column B: field name REF_SYSTEM for structure SDBIL_EBDR_REQUEST_SENDLOGSYS is invalid."

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Open the "Manage Billing Document Requests"(F2960) app.
  2. Use the import function and upload the provided Excel template.
  3. Start the import; the system raises: "Error on sheet IS_EBDR_ADMIN, column B: field name REF_SYSTEM for structure SDBIL_EBDR_REQUEST_SENDLOGSYS is invalid."

Cause

The excel template maintained REF_SYSTEM in cell B1 (column B) on sheet IS_EBDR_ADMIN, which is not a valid position.

Resolution

  1. Open the excel template and navigate to worksheet IS_EBDR_ADMIN.
  2. Maintain the field name REF_SYSTEM in cell A2 (column A).
  3. Save the file.
  4. Re-import the corrected template in the "Manage Billing Document Requests"(F2960) app and verify the import completes without the error.

See Also

SAP Help Portal :Creating External Billing Document Requests via Spreadsheet Import

Keywords

manage billing document request, billing request import, excel template, IS_EBDR_ADMIN, REF_SYSTEM, sender logical system, SDBIL_EBDR_REQUEST_SENDLOGSYS, invalid field name, column B, A2 cell, import error, external billing, mass upload, spreadsheet mapping, admin sheet configuration , KBA , SD-BIL-IV-2CL , Processing Billing Documents (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions