Hana View(Composite Provider) - Navigation Attribute Data Preview Error
I created a Hana View from Composite Provider by checking external SAP HANA View option as below.
In composite provider, there are assignments for key fields(G_ARC0200) and navigation attributes(G_ARC0200__G_ARC0206) in the target. G_ARC0200__G_ARC0206 (MATKL - Mdse Catgry) is a navigation attribute of G_ARC0200 (MATNR - Article).
I received the error below whenever I tried to preview data in Hana View perspective.
The error message doesn't show up when I select to preview G_ARC0200.
But the error message will show up when I select to preview G_ARC0206.
Table - /BIC/PG_ARC0200 is Master Data Table for G_ARC0200
Table - /BIC/XG_ARC0200 is Attribute SID Table for G_ARC0200
Anyone have any idea what might have caused the error messages above whenever I tried to preview data for G_ARC0200 and G_ARC0206 ? If yes, can you please advise me the possible solution for these error messages?