SAPUI5 Function Import空日期参数调用报错问题求助

Let’s tackle this common OData Function Import issue head-on. The errors you’re seeing stem from mismatched validation rules between your SAPUI5 call and the OData gateway—here are three reliable fixes tailored to your scenario:

1. Mark Date Parameters as Optional in SEGW (and Skip Them When Empty) #

First, fix the root gateway validation issue by making your date parameters non-mandatory:

• Open your Function Import in SEGW, navigate to the Parameters tab.
• Set the Mandatory flag for both date fields to No.
• Regenerate and activate your OData service.

Then, in SAPUI5, dynamically build your request to only include non-empty date parameters. This avoids sending unnecessary parameters that trigger validation errors:

const oModel = this.getView().getModel(); // Get your OData model instance
const dateFrom = ""; // Your actual date input value (may be empty)
const dateTo = "";

// Build URL params only for non-empty dates
const urlParameters = {};
if (dateFrom?.trim()) {
  urlParameters.DateFrom = dateFrom;
}
if (dateTo?.trim()) {
  urlParameters.DateTo = dateTo;
}

oModel.callFunction("/YourFunctionImportName", {
  method: "GET",
  urlParameters: urlParameters,
  success: (oData) => {
    // Handle your response data here
  },
  error: (oError) => {
    // Handle error cases
  }
});

2. Pass null Instead of Empty Strings #

OData’s Edm.DateTime type rejects empty strings, but it accepts null as a valid empty value. Replace empty strings with null in your call:

oModel.callFunction("/YourFunctionImportName", {
  method: "GET",
  urlParameters: {
    DateFrom: dateFrom || null, // Fallback to null if input is empty
    DateTo: dateTo || null
  },
  success: (oData) => { /* Success handling logic */ },
  error: (oError) => { /* Error handling logic */ }
});

This tells the gateway to treat the parameter as an empty date, which maps correctly to ABAP’s initial date value (00000000) without syntax errors.

3. Set Default Null Values in SEGW #

If you need to ensure parameters are always sent (even when empty), configure default values in SEGW:

• In the Function Import’s Parameters tab, set the Default Value for each date parameter to NULL.
• Regenerate and activate your service.

Now, even if you don’t explicitly pass the parameter in SAPUI5, the gateway will automatically inject NULL as the value, bypassing the "Invalid function import parameter" error.

Critical Backend Check #

Whichever approach you use, ensure your ABAP function module handles empty dates correctly. For example:

IF iv_date_from IS INITIAL AND iv_date_to IS INITIAL.
  -- Logic for no date filter applied
ELSE.
  -- Logic for date range filtering
ENDIF.

内容的提问来源于stack exchange，提问作者Gander