cancel
Showing results for 
Search instead for 
Did you mean: 

DTW import blank fields

jbrotto
Active Contributor

Is it possible to import blank fields into SAP as when I use DTW if a field in SAP is populated and I want to erade a record it seems it is not possible with a blakn fileind in the import template.

Accepted Solutions (1)

Accepted Solutions (1)

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Hi jbrotto,

When updating a record in which you wish to set a field to a blank value, put the ‘/’ (slash) symbol in the field in the template. This function does not delete any line items from an object. It enables to delete existing values from a specific field only.

It's not possible to update date and numeric data types with a blank value via DTW.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

CoreSolution
Explorer
0 Kudos

Hello Ankit,

SAP gives me this error for any changes made in the item master data "The unit of length, width, height or weight cannot be set if the length, width, height or weight is 0."

The value 0.000000 is saved on the database instead of null.
In this case, if the value (numeric) cannot be updated with the DTW, should SAP be involved?

Thank you,

Best regards.

Simona

ANKIT_CHAUHAN
Product and Topic Expert
Product and Topic Expert
0 Kudos

Dear michele.benatti,

We saw your posted comment. We recommend raising your question again as a new question and follow our rules of engagement: https://community.sap.com/resources/rules-of-engagement. Please feel free to take our Q&A tutorial at: https://developers.sap.com/tutorials/community-qa.html. With these tips you will be able to prepare questions that draw responses from our members.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

Answers (0)