I have two real time external tables defined for JDE Item Master and JDE Item Base Pricing tables. I want to join these tables so I can do a search on the joined table, and also filter the tables by a specific field, in this case the Business Unit. I created applications to view the data in both individual tables and those work. The table definitions app allows me to create a join table across the 2 tables using the ShortItemNumber. I can create an application on the joined table, but I do not see any data in the joined table application. Is it possible to do this?
Hi @brandt.koos , it is not supported. You will need to create a joined business view in JDE over those two tables and then build a real-time table over that in our Platform. I will follow up on the fact that we let you define a Join Table Definition in our platform in that manner.
1 Like
Thanks for the quick response. Appreciate and understand.
1 Like