Selecting Fields From Other Sources

Sometimes an external database source is the driving table of the distribution or sometimes some of the file’s fields are required from this external source via a table lookup to complete the driver report.

In our example, a combination of an existing JDE table and an external table were required to build our report. To create the burst driver report in our example that will eventually pull the appropriate F0411 A/P Voucher Detail, we’ll use the F0006 Business Unit Master, which contains the BU’s and may also contain the Responsible Person or owners of the BU’s in a category code. In our example ERP environment, the emails are stored outside of JDE.

We’ll use an external Excel spreadsheet that contains business units, the owners of the business units, and their emails. The information in the Excel file will provide the email addresses used in the mail merge component in the distribution.

We’ll assume an Excel document was created earlier with corresponding email addresses with business unit owners. Our Excel example has the business unit number, employee number, and email addresses we’ll need for an upcoming table lookup step.

We’ll assume that an external data source connection to DAS has been created. (External Connections is taught in another course. Please refer to that training content if you are not yet familiar with External Connections.)

So, to start our driver report, we open the F0006 Business Unit Master and select the columns required to generate the distribution report. In our screenshot, our example selected the Business Unit column (MCU) and then created an Associated Description for the Business Unit.