on 08-22-2018 9:10 AM
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
Hi Surojit,
Your query looks fine.
What version of SAP do you have? Cross joins are supported from 9.2 PL 07.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Sergei ,
I am in Stuck please give me suggestion .
Thanks
Surajit
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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.
User | Count |
---|---|
89 | |
7 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.