cancel
Showing results for 
Search instead for 
Did you mean: 

Crossjoin Not working in BusinessPartners and EmployeesInfo ?

former_member209771
Active Participant
0 Kudos
491

Hi Expert ,

I want to use CrossJoin between two Entity (BusinessPartners and EmployeesInfo) .As per service layer documentation i have wrote below join but not working .Please give me suggestion .


Get Request : https://10.0.0.181:50000/b1s/v1/$crossjoin(BusinessPartners,EmployeesInfo)?$expand=BusinessPartners(... )&$filter=BusinessPartners/SalesPersonCode eq EmployeesInfo/SalesPersonCode


Respone : { "error": { "code": -1000, "message": { "lang": "en-us", "value": "Internal server error." } } }


Thanks

Surajit Kundu

Accepted Solutions (0)

Answers (3)

Answers (3)

former_member390407
Contributor

Hi Surojit,

Your query looks fine.

What version of SAP do you have? Cross joins are supported from 9.2 PL 07.

former_member209771
Active Participant
0 Kudos

Hi Sergei ,

I am in Stuck please give me suggestion .

Thanks

Surajit

former_member209771
Active Participant
0 Kudos

Hi Sergei,

Thanks for your reply. I am checking in two environment one (9.2 pl09 and 9.3 pl00) but same issue.

Thanks

Surajit

former_member390407
Contributor

Hi Surojit,

I ran this request in my test environment and it works perfect (SAP B1 9.3 PL 03, SBODEMOGB database).

I would recommend to try firstly run a simple request to both entities and contact SAP support with collected information.