Skip to Content
0

OData Report "G/L Accounts - Line Items " Filter PARA_FISCYEARPER

Apr 18, 2017 at 12:09 PM

92

avatar image

Hello Experts,

I am currently getting in touch with the OData-Services for Reports.

Especially the Report for G/L Accounts - Line Items is interesting for me.

Unfortunately I can't manage to use the filter "PARA_FISCYEARPER". I tried to use following calls:

PARA_FISCYEARPER eq 022016
PARA_FISCYEARPER eq 0022016
PARA_FISCYEARPER eq 2016
PARA_FISCYEARPER eq 12.2016
PARA_FISCYEARPER eq 012.2016

Someone can give me an advice how to use this filter?

Regards,

Martin

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Knut Heusermann
Apr 18, 2017 at 12:22 PM
1
Show 6 Share
10 |10000 characters needed characters left characters exceeded

Hi Knut,

thank you for the fast answer.

Your URL isn't working for me. I get the error "variable contains invalid values". Using your URL without the "important" part is working.

https://myxxxxxx.sapbydesign.com/sap/byd/odata/fin_generalledger_analytics.svc/RPFINGLAU02_Q0001QueryResults?$inlinecount=allpages&$select=FCDEBIT_CURRCOMP,FCCREDIT_CURRCOMP,KCBALANCE_CURRCOMP,CCOMPANY_UUID,TCOMPANY_UUID,CGLACCT,TGLACCT,CPOSTING_DATE,CACC_DOC_UUID,CACC_DOC_IT_UUID,CFISCYEAR,CFISCPER,TCOST_CTR_UUID,CCREATION_DATE,TFUNCAREA,TGLACCT_TC,CNOTE_IT,TPRODUCT_TYPE&$filter=PARA_COMPANY%20eq%20%271000%27&$top=100

I tried different values, and the period is open in the given time.

Any guesses what I am doing wrong?

Best regards

Martin

0

Hi Martin,

could you please check if the fiscal year period PARA_FISCYEARPER is listed in OData Report metadata:
https://myXXXXXX.sapbydesign.com/sap/byd/odata/fin_generalledger_analytics.svc/$metadata?entityset=RPFINGLAU02_Q0001QueryResults ?

Best regards,
Knut

0

Hi Knut,

yes, PARA_FISYEARPER is listed in the metadata.

If I use values like "2016" I don't get an error, but the filter is not working.

Best regards.

Martin

0

Hello Martin,

I just figured out that the representation varies with the fiscal year variant settings and hence you need to find out the formatting on your system first:

1. Create new custom report as copy of report "G/L Accounts - Line Items"; add the key figure "Counter" and the characteristic "Accounting Period/Year" in your custom report.

2. Get an example record via OData, for example:
https://myXXXXXX.sapbydesign.com/sap/byd/odata/cc_home_analytics.svc/RPZB9A728B38DD8A0CC1C0337QueryResults?$inlinecount=allpages&$select=CFISCALYEARPERIO,CACCDOCTYPE,KCZ0COUNT&$filter=PARA_COMPANY eq '1000' and PARA_SETOFBKS eq '7000'

3. Pick the format of field CFISCALYEARPERIO to fill the filter parameter PARA_FISCYEARPER, for example:
https://myXXXXXX.sapbydesign.com/sap/byd/odata/cc_home_analytics.svc/RPZB9A728B38DD8A0CC1C0337QueryResults?$inlinecount=allpages&$select=CFISCALYEARPERIO,CACCDOCTYPE,KCZ0COUNT&$filter=PARA_COMPANY eq '1000' and PARA_SETOFBKS eq '7000' and PARA_FISCYEARPER eq 12016

Hope that solves your question.

Best regards,
Knut

0

Hello Knut,

thanks a lot for the explanation.

I got one last question: is there any way to use relative select like "Current Fiscal Period" or "Previous Fiscal Period"

thanks in advance, best regards.

Martin

0

Hello Martin,

relative selects are not supported in OData filter parameter, but you can use relative selects in Report Fixed Value Selections and Report Initial Selection Default Values which apply for OData requests as well, if not overwritten by corresponding filter parameter provided in the OData request.

Please find more details in the blog posts Using Filter and Selection Parameter in ByD OData for Analytics and OData for SAP Business ByDesign Analytics.

Best regards,
Knut

1