Fiscal Perdiod format error on Fiori CRUD application

[former_member655669]

Hi all,

I made a CRUD Master Detail application on FIORI where I need to maintain a table with Fiscal Period field.
When I try to update or create a new entry I receive erros.

• If I try using 0122019 I receive this error message:

{"error":{"code":"/IWBEP/CM_MGW_RT/010","message":{"lang":"en","value":"'Use input-screen format __.____ for input'."},"innererror":{"application":{"component_id":"","service_namespace":"/SAP/","service_id":"ZXXXXXXXXX_SERVICE","service_version":"0001"},"transactionid":"56C4F46DC46E00C0E005E24BCD620C90","timestamp":"20200122124724.3878410","Error_Resolution":{"SAP_Transaction":"Run transaction /IWFND/ERROR_LOG on SAP Gateway hub system (System Alias LOCAL) and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[{"code":"/IWBEP/CX_MGW_MED_EXCEPTION","message":"'Use input-screen format __.____ for input'","propertyref":"","severity":"error","target":""}]}}}

• If I use 012.2019 I receive this:

{"error":{"code":"SY/530","message":{"lang":"en","value":"An exception was raised."},"innererror":{"application":{"component_id":"","service_namespace":"/SAP/","service_id":"ZXXXXXXXXXSRV","service_version":"0001"},"transactionid":"56C4F46DC46E0000E005E24BCDAD2EAB","timestamp":"20200122125026.8824670","Error_Resolution":{"SAP_Transaction":"Run transaction /IWFND/ERROR_LOG on SAP Gateway hub system (System Alias LOCAL) and search for entries with the timestamp above for more details","SAP_Note":"See SAP Note 1797736 for error analysis (https://service.sap.com/sap/support/notes/1797736)"},"errordetails":[{"code":"CX_SY_CONVERSION_NO_NUMBER","message":"The argument '012.2019' cannot be interpreted as a number","propertyref":"","severity":"error","target":""},{"code":"CX_XSLT_DESERIALIZATION_ERROR","message":"Error during deserialization","propertyref":"","severity":"error","target":""},{"code":"/IWBEP/CX_MGW_TECH_EXCEPTION","message":"An exception was raised","propertyref":"","severity":"error","target":""}]}}}

Fiscal Period data element is an number , lenght = 8, while debugging the create/update method , for case 0122019 I see that backend receive 00122019 with an extra 0. I do not find in my FIORI application where I can edit the field before sending to backend.

I hope you can help me !

Thanks!

[Joseph_BERTHE · Accepted solution]

Hi,

You problem comes from the convertion routine of your field FiscalYear. You have to disable it in the SEGW.

TO help you read this blog Conversions in SAP Gateway Foundation – Part 1 from thomas.nitschke

Regards,

Joseph

[former_member655669 · Accepted solution]

Hi Joseph, thanks for your answer !

I could disable conversion routine and I works fine.

Thanks & regards!

Christian.

[laurent_burtaire]

Hello,

0122019 or 012.2019 is not a date format.

If it is a data type as DATS, value should be YYYYMMDD at ABAP level.

What is the data type of your field in the OData model?

Regards.

Laurent.

[former_member655669]

Hi Laurent thanks for yout answer,

In this case I am using characteristic 0FISCPER where data is stored in format I mentioned in the description 000.2019, 001.2019 ... 012.2019 for example. Sorry for not clarify it on the description !

Regards