• Introducing Dark Mode! Switch by clicking on the lightbulb icon next to Search or by clicking on Default style at the bottom left of the page!

Table Join F41021/F4105


Reputable Poster
I am wondering if there is a way to create a business view with F41021 and F4105 for a specific cost method; i.e "07".


OneWorld B733 Cum 2 SP11.3, NT SP6a, SQL 7.0 SP3


Active Member
If the filter criteria is not going change you can create a SQL view where the two tables are joined and include the filter criteria.

You can then map a JDE table F55???? and JDE business view V55??? to this SQL view as though it were a SQL table.

When you create the table you will need to click on the Generate Table button and then click on cancel when it prompts for the environment to generate the table in. This will generate the table specs.

You can not use the Universal Table Browser to look at data in this view.

David Robertson

Reputable Poster
Search through the posts for Foreign Tables I think. The create view method is documented in some detail within here somewhere.

Let me know if you need more info on it, if it helps..