Database Object

Definition

Subset of tables from a database.

You can use the Interface Toolbox to select the following database objects:

  • Set of all infotypes (MDTA) with the type Master Data

  • Payroll and Time Management data (PCL2) with the type Import/Export file

Use

You use the database object to create an interface format. When you create an interface format, note the following:

  • Database objects with the type Master Data (MDTA) are followed by table objects. Infotypes belong to the table objects.

If you create a database object with this type, you can assign required infotypes for the subsequent export.

The table object (infotype) automatically includes all field objects belonging to the relevant infotype.

  • If database objects have the type Import/Export File (PCL2), then the subordinate hierarchy level consists of cluster objects.

When you create a database object with this characteristic, you must enter the name of the database table on which the interface format is based (for example, PCL2). The Interface Toolbox will then check whether the specified database table exists in the SAP System.

You must also maintain the following objects which are lower in the hierarchy:

  • Cluster object

  • Table object

The table object automatically includes all field objects belonging to the table.

You can also create an additional database object at a later point.

You then run

  • The dialog for a table object for master data

  • The dialog for a cluster object for an import/export file