Table Join F41021/F4105

tmackin

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".

TIA

OneWorld B733 Cum 2 SP11.3, NT SP6a, SQL 7.0 SP3
 
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.
 
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..

Dave
 
There is a nice article in the QuestDirect magazine that explains this. Check out http://www.questdirect.org, click the 'Members' line on the top, click on the 'Q&A Archives' link, and then the 'Fall 2000 Issue' link. You'll see an article name 'Using Database views in Oneworld'. I also attached the article.
 

Attachments

  • 3-23429-OneWorldDatabaseViews.doc
    40.5 KB · Views: 131
Back
Top