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 |
|
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 |
Direction of the substring forming the foreign key |
|
startposition |
Position from which the substring is formed |
|
length |
Length of substring |
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>