Table access configuration

XML element

XML attribute

Description

jdbc_table-configuration

 

List of table configurations

configuration

name

Unique identifier of the table configuration

 

printname
(optional)

Switch. yes means that the configuration name is output as a prefix to the field names.
Default value: no

 

classtouse
(optional)

Name of the Java class that is used for editing the configuration
Default value: Standard implementation

globaltable
(optional)

name

Identifier of the table from which global system attributes are extracted

 

tablename
(optional)

Name of the table in the source system
Default value: Specified in the name XML attribute

 

classtouse
(optional)

Name of the Java class that is used for extracting data from the table
Default value: Standard implementation

docspec

-

Grouping of the specifications of all foreign key tables and the system event table

docreftable

name

Identifier of a foreign key table

 

tablename
(optional)

Name of the table in the source system
Default value: Specified in the name XML attribute

 

classtouse
(optional)

Name of the Java class that is used for extracting data from the table
Default value: Standard implementation

doctable

name

Identifier of the system event table. Each line extracted creates a system event in the XML file.

 

tablename
(optional)

Name of the table in the source system
Default value: Specified in the name XML attribute

 

classtouse
(optional)

Name of the Java class that is used for extracting data from the table
Default value: Standard implementation

table
(optional)

name

Identifier of the data table from which supplementary information is extracted

 

tablename
(optional)

Name of the table in the source system
Default value: Specified in the name XML attribute

 

classtouse
(optional)

Name of the Java class that is used for extracting data from the table
Default value: Standard implementation

Each table may only be referenced once in the configuration. In order to be able to extract a table multiple times, reference the same table (tablename XML attribute) using different identifiers.

Example

You want to extract the VBAP-MATNR_1 and VBAP-MATNR_2 fields from the PRODH table. The file extract below illustrates the configuration:

<table name="PROD_HIER_1" tablename="PRODH"

classtouse="ZTable">

<pkfield name="HNUM" fktablename="VBAP"

fkfieldname="MATNR_1"/>

<fieldtoread name="HVAL"/>

</table>

<table name="PROD_HIER_2" tablename="PRODH"

classtouse="ZTable">

<pkfield name="HNUM" fktablename="VBAP"

fkfieldname="MATNR_2"/>

<fieldtoread name="HVAL"/>

</table>