Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Handling null in Database

Hi All,

I have an issue in IDOC - DB scenario.

Source field is optional

Target field is mandatory in DB and defined it as Integer in XI [datatype is Numeric in stored procedure]

I mapped the source field in such way that if it is null, then map Constant(Gave null value) else do the necessary transformation and used the mapwithdefault(null) and mapped it to Target field.

This is working fine when there is some value in the source field, but if source field is empty, there is an error.

NumberFormat exception in CommunicationChannel....

Its unable to convert the null to numeric format. But from Database end, I tested through query analyzer by populating some null value into that field and its working fine by accepting the null value.

Any pointers in this..



Former Member
Not what you were looking for? View more on this topic or Ask a question