From the course: SAP Business One: Reporting and Customization

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Use JOIN for multiple tables

Use JOIN for multiple tables - SAP ERP Tutorial

From the course: SAP Business One: Reporting and Customization

Start my 1-month free trial

Use JOIN for multiple tables

“

- [Narrator] Now that you added one more table, let's add a few more. You've looked at one major use of JOINS, taking data from other tables. Another big use of JOINS is associating rows and modules with its header information. Let's add component information to report for everything OEC is making. The header information in the Production Order for example, can be associated with rows of materials. As I mentioned earlier, you'll find a general pattern that the rows are the first subtable of data. The OWR table for Production Order has WOR1 for rows. If you pull up a new Query Generator, you can use that for a little bit of a reference. And type in WOR1. At the top you'll see a common column in many tables. The DocEntry column. It's bolder because it is a way to link back to OWOR's DocEntry. Notice a column underneath it, which has the row's number. For each DocEntry, it'll be a sequence of row numbers, starting at…

Contents