Business View joining F4101 and F4105

Hello List,

I need to create a report comparing various business unit/cost method
combinations for costing purposes. It would have fields as follows:

Item, Branch Plant 1, Cost Method 1, Cost 1, Branch Plant 2, Cost Method 2, Cost
2, Differenc (2-1), Percent Difference

It seems the only way to get close is to create a business view joining F4101
and F4105 to get 1 and do table I/O to get the second group.

Is there any danger (performance wise) in creating such a BV? Management is
concerned about business views that would "kill the system." I found a document
(ott-00-0037- Limits on Join Business Views) which seems to say that JDE has
eliminated this possibility by putting these limitations in place.

Any thoughts?

John Gaughan
The Pfaltzgraff Company
OneWorld Xe
SP15.1
HP-UX 11
Oracle 8.1.5 Prod
Oracle 8.1.71 Test

John,

you seem to have a good handle on what's required.

Sounds like someone is playing the FUD (Fear, Uncertainty, Doubt) tune to your management. The Business view and report you describe are very straightforward and definitely would not "kill the system". JDE has several out-of-the-box reports that are good at that though - particularly in the accounting/finance areas.

When you create the view be sure you link the tables by the Short Item Number, not the 2nd Item Number. This is because F4105 does not have any indices beginning with the 2nd Item Number.

Regards,

Larry Jones
[email protected]
OneWorld B733.1, SP 11.3
HPUX 11, Oracle SE 8.1.6
SandBox: OneWorld XE SP15