SAP Knowledge Base Article - Public

3781747 - External Billing Document Request via Template Does Not Determine Pricing and Taxes Due to Missing Tax Classification Fields in Import File – SAP S/4HANA Cloud Public Edition

Symptom

Pricing and tax conditions are not determined as expected when creating a 'Billing Document Request' via the 'External Billing Document Request (EBDR)' template in 'Manage Billing Document Requests' app.

Environment

SAP S/4HANA Cloud Public Edition

Reproducing the Issue

  1. Upload and create a 'Billing Document Request' using the 'External Billing Document Request' spreadsheet template.
  2. Observe that pricing and tax conditions are not determined.
  3. Create a manual 'Debit Memo Request' for a comparable scenario and note that tax conditions are automatically applied.
  4. Compare the behavior regarding region consideration in manual processing versus the spreadsheet template.

Cause

Required tax classification fields 'PRODUCTTAXCLASSIFICATION' and 'CUSTOMERTAXCLASSIFICATION1' were not maintained in worksheet 'IT_EBDR_REQUEST' of the spreadsheet import.

Resolution

To ensure that the required tax information is available for tax condition determination, proceed as follows:

  1. Generate and download the latest External Billing Document Request template from the 'Manage Billing Document Requests' app.
  2. Open worksheet IT_EBDR_REQUEST in the downloaded template.
  3. Maintain the following fields for each relevant item:
    • CUSTOMERTAXCLASSIFICATION1.
    • PRODUCTTAXCLASSIFICATION.
  4. Ensure the maintained values align with the customer and material tax setups required for tax condition determination.
  5. Save the file and upload it again to create the External Billing Document Request.
  6. Verify that pricing and tax conditions are now determined as expected.

See Also

Keywords

external billing document request, spreadsheet import, pricing not calculated, taxes not determined, debit memo request, tax conditions, CUSTOMERTAXCLASSIFICATION1, PRODUCTTAXCLASSIFICATION, IT_EBDR_REQUEST, manage billing document requests, tax classification fields, EBDR, manage billing document requests , KBA , SD-BIL-IV-2CL , Processing Billing Documents (Public Cloud) , Problem

Product

SAP S/4HANA Cloud Public Edition all versions