Skip to Content
0
May 18, 2018 at 09:29 AM

SAP B1 Service Layer crossjoin

1637 Views

We would like to do a crossjoin to get items with their translations.

So we came up with the following url:

$crossjoin(Items,MultiLanguageTranslations)?$expand=Items($select=ItemCode, ItemName,ItemsGroupCode),MultiLanguageTranslations($select=TableName,FieldAlias,PrimaryKeyofobject)&$filter=Items/ItemCode eq MultiLanguageTranslations/PrimaryKeyofobject and MultiLanguageTranslations/TableName eq 'OITM'

But now we also would like to get the actual translation from the MultiLanguageTranslations.TranslationsInUserLanguages property.

How can we achieve this?