Create an ERD definition

Applies to User roles: System Administrator

An Entity Relationship Diagram (ERD) is a graphic description of the logical structure of a database. Database administrators often rely on conceptual and physical data models to understand the relationships among tables, records, and data, and to produce reports.

To create an ERD definition:

  1. From the System Navigator, click Tailoring > Database Manager.
  2. In the Form field, type erddef and click Search.
  3. From the Associated Forms section, double-click the erddef.g form.
  4. Enter the First Filename, Second Filename, and Relationship Type.
  5. In the Field Names from First Filename text box, enter the fields for which you want to create the join.
  6. Enter the fields for which you want to create the join in the Field Names from Second Filename text box.
    In this example, the contact.name field in the probsummary table contains the same data as the contact.name field in the contacts table.
  7. Click Add.

For additional information about relationship types, see Create a join in the related topics.