Skip to Content
Dec 30, 2016 at 09:08 AM

Fiscal Period Format issue with OData Service based on Bex Query after migration to BW on HANA


Hi, experts

We have a OData Service that generated by BeX Query with a variable parameter "Fiscal Period", and the data element of it is "/BI0/OFISCPER"(NUMC7) which has a conversion routine “PERI7”. So we can request the OData service with Period in format "MMM.YYYY"(eg. 002.2009) as parameter.

But after we updgraded our BW system to HANA, it throw an error: "Value '200.002.' is not valid for variable ODATA Fiscal Period or does not exist" when accessing the OData Service with Period “002.2009”. after several times test, I found it works only with format "YYYYMMM"(2009002) as the actual value for the period. and the Display Value "002.2009" is not supported any more.

Usually this issue is caused by default date settings of user, But it's as same as before upgraded. Also, the Query and OData Metadata are as same.

It seems the conversion routine does not work in HANA.
Does anyone know whether there are some extra settings to control the conversion routine?
Or what should I do to correct this issue?

Thanks a lot.

Here's the component version:
After upgrade:
SAP_GWFND 750 0005 SAPK-75005INSAPGWFND SAP Gateway Foundation
SAP_BW 750 0004 SAPK-75004INSAPBW SAP Business Warehouse

Before upgrade:
SAP_GWFND 740 0012 SAPK-74012INSAPGWFND SAP Gateway Foundation 7.40 SAP_BW 740 0011 SAPKW74011 SAP Business Warehouse


1. https://host:port/sap/opu/odata/sap/Z_XXX_SRV/Z_XXX_002(ZFISCPER='002.2009',Z_EXRTSM='')/Results?$format=json

Error Message:
"Value '200.002.' is not valid for variable ODATA Fiscal Period or does not exist"

2. https://host:port/sap/opu/odata/sap/Z_XXX_SRV/Z_XXX_002(ZFISCPER='2009002',Z_EXRTSM='')/Results?$format=json