Link tables

The header, document, and data tables are linked to one another by primary key relations, which are specified in the pkfield XML element.

XML element

XML attribute

Description

pkfield

name

Name of the primary key (table column name)

 

fktablename

Identifier of the table referenced
by a foreign key relation

 

fkfieldname

Name of the foreign key (table column name)

 

logicaloperator

Valid values: eq, neq, gt, geq, lt, leq. Default value: eq

prefix

 

String inserted before the extracted foreign key value

postfix

 

String inserted after the extracted foreign key value

fkpart

readfrom
(optional)

Direction of the substring forming the foreign key
Valid values: left, right
Default value: left

 

startposition

Position from which the substring is formed

 

length
(optional)

Length of substring
Default value: Start or end of string, depending on the value of the readfrom XML attribute

value

 

Value specified for conditions, prefixes, and postfixes

Example

The file extract below shows the configuration that is used to extract the VBELN and POSNR database fields from the VBAP table. The foreign key relations are established by the content of the TABKEY field in the CDPOS table.
The first ten characters in the TABKEY field contain the value that is assigned to the VBELN field in the VBAP table and the following six characters contain the value that is assigned to the POSNR field in the VBAP table.

<table name="VBAP">

<pkfield name="VBELN" fktablename="CDPOS"

fkfieldname="TABKEY">

<fkpart startposition="0" length="10"/>

</pkfield>

<pkfield name="POSNR" fktablename="CDPOS"

fkfieldname="TABKEY">

<fkpart startposition="10" length="6"/>

</pkfield>

<fieldtoread name="VBELN"/>

<fieldtoread name="POSNR"/>

</table>