How to check if customer invoice is paid in ByD via OData

[mathiasmueller-aico]

Dear SAP community,

I have a problem finding the correct Business Object name and field while configuring an OData service in SAP ByDesign.

I’m trying to check whether the client’s invoice is open or cleared. I found this article, but it didn’t help me much:https://community.sap.com/t5/technology-q-a/how-to-check-if-customer-invoice-is-paid-in-byd-via-webs...

I’m not sure which Business Object (BO) it should be. Has anyone else encountered this issue before?

To make things clearer, I’m including some screenshots below showing the exact location where the status is displayed.

In the OData Configuration Tool, I tried to select the BO name CustomerInvoice, but it doesn’t seem to be the correct one.

Can someone please assist me with this?

Best wishes!

   

[may_thitsaoo · Accepted solution]

Hello,

BO should be TradeReceivablesPayablesRegister.
But you can use Reporting OData.

Go to Business Analytics - Design Reports WOC.
Select [Accounts Receivable - Line Items] report.
Click [Build OData Queries].
Select Attributes and Filters as you want.
Then you can create OData query service.

Ref : OData for SAP Business ByDesign Analytics 

Hope this helps.

Regards,

May

[mathiasmueller-aico · Accepted solution]

Hi May,

[mathiasmueller-aico · Accepted solution]

Hi May, thank you for the reply! The report itself is working and I am getting the Status field. When I try to build the Query, every single time I receive 0 results 😞

[mathiasmueller-aico · Accepted solution]

Hi May, thank you for the reply! The report itself is working and I am getting the Status field. When I try to build the Query, every single time I receive 0 results :(. As far as I understand and also see in metadata, there are some mandatory filters, but in the UI I do not see them listed so I may filter based on them. I am pretty confused.

[may_thitsaoo · Accepted solution]

Hello,

Yes, you need some filter prameters.

Here is the sample Odata query which works in our test tenant. 

(please update parameter values with your system real data)

https://my12345.sapbydesign.com/sap/byd/odata/ana_businessanalytics_analytics.svc/RPFINGLAU08_Q0001QueryResults?$select=CGLACCT,CCINHUUID,CIM_OP_IT_STAT,TIM_OP_IT_STAT,CACC_DOC_UUID_C&$filter=(CCOMPANY_UUID eq 'XXXXX')and (PARA_FISCYEARPER eq 2024010) and (PARA_SETOFBKS eq 'XXXXX')&$format=json

Regards,

May

[mathiasmueller-aico · Accepted solution]

Hi May thank you for your quick response!

[mathiasmueller-aico · Accepted solution]

Hi May thank you for your quick response! I tried to me and I still do not have any success. 2 more questions I have and I really appreciate your support. 1. If I watch the metadata I see the field BYD_P_CURDATE to be mandatory but I do not see it in your request, I am a bit confused how it is working like this. 2 Question is regarding the UUID from the company. From where do you get it? If I try with the same name which I choose in the Filter UI (generating report in BYD) it is not working. This is how I tried https://<URLBYD>.sap/sap/byd/odata/ana_businessanalytics_analytics.svc/RPFINGLAU08_Q0001QueryResults?$select=CGLACCT,CCINHUUID,CIM_OP_IT_STAT,TIM_OP_IT_STAT,CACC_DOC_UUID_C&$filter=(CCOMPANY_UUID eq 'XXX') and (PARA_SETOFBKS eq 'xxxx') and (BYD_P_CURDATE eq datetime'2025-05-12T00:00:00')&$format=json

[may_thitsaoo · Accepted solution]

Hello, 1.I am able to retrieve data with or without BYD_P_CURDATE filter. 2.It is the same ID value as you select in Report view selection Company. Your query seems no problem. Just double check the filter value, comparing with the Report vaules in the system.