I need to write a price audit report. The BA says the business view need to be a left outer join on F42199 and F42199 (ledger). (not a typo)
Has anyone done a business view with the same tables?
BSVW designs let me do it.
I'm wondering if there is anything I need to watch out for and...
Have created a business view joining 4 tables. The primary table is connected to two tables with a simple join. The 4 th table is joined to one of the two 2ry ry tables with a simple join. It should return 54 records. But it returns only 32 for the report.
From the logs of the UBE...