Composite data entities

(1) Share

Report

Posted on by DP-04060556-0

109

Hi experts,

Recently I has an issue whereby users can not use "Open in excel" for composites data entities for users hold "Data migration admin" role. They can access Composites data entities from Data management workspace but cannot see those entities from "Open in excel" menu. please advise.

Daniel

I have the same question (0)

All responses (4)

Answers (1)

Layan Jwei 8,165 Super User 2026 Season 1 on at

Like (0)

Report
Copy link

Link copied!

Hi,

What are the composite entities that you can't see? Are they standard or custom? And if they are custom, did you create privileges for them and assigned them to the data migration role? If not, then make sure the role has access to those entities

Also can you see them using a different role?

Was this reply helpful? Yes No
DP-04060556-0 109 on at

Like (0)

Report
Copy link

Link copied!

Hi Layan Jwei,

the data entity that users cannot see is Inventory adjustment journal headers and lines V2, however user can see Inventory movement journal headers and lines V4 from "Open in excel". it is a standard items and I did not create new privilege for it. I had try to assigned "Data migration administrator" , "IT manager" to users but unsuccessful.

Daniel

Was this reply helpful? Yes No
Verified answer

Martin Dráb 239,029 Most Valuable Professional on at

Like (2)

Report
Copy link

Link copied!

Note that this thread isn't about composite data entities at all.

Composite entities aren't exposed via OData, and because Open in Excel uses OData, they can't be used there either. They're supported in data management only.

Both InventInventoryMovementJournalEntryV4Entity and InventInventoryAdjustmentJournalEntryV2Entity are normal data entities, not composite ones.

Access to InventInventoryAdjustmentJournalEntryV2Entity is granted by two privileges: InventInventoryAdjustmentJournalEntryEntityExport and InventInventoryAdjustmentJournalEntryEntityImport. But it won't work even if you assign them to users, because they have Integration Mode = Data Management, therefore they don't give permissions to OData. You'll have to create new privileges.

Was this reply helpful? Yes No
DP-04060556-0 109 on at

Like (1)

Report
Copy link

Link copied!

Hi Martin Dráb ,

yes, you are right. thanks for your advise.

Daniel

Was this reply helpful? Yes No