Business View Selection

Business views are the link between the report and the data in the JD Edwards EnterpriseOne database. They present data fields from one or more tables and limit the column selection to columns that are relevant to the business requirement of the report. Business views also improve performance by moving only the required fields across the network.

You can select a business view for a detail section using one of two methods:

• Select Business View

  Use the Query by Example (QBE) line to filter through all business views in the system. You can filter by product code, business view name, or entire or partial description, or you can leave the QBE line empty to return all business views.

  Business view names begin with the letter V and contain a maximum of eight characters. The name is formatted as VxxzzzzA, where the variable characters represent this information:

  • xx is the product code (55–59 are reserved for clients).

  • zzzz are the characters of the primary table.

  • A indicates the sequence in which the business view was created over the primary table.

• Favorite Business Views

  Select from a list of business views that you, or other users, have defined as favorites.

No matter which method you use to select a business view, the title bar of the detail section reflects the selected business view.

See "Designing Business Views" in the JD Edwards EnterpriseOne Tools Table Conversion Guide.