The Period Table
Here you find the most common database table,
XDBxx, and the fields it contains. There is one XDB table for each
year, for example, XDB01 for the year 2001.
The XDBxx database table fields are described in the following table:
| Field Name | Description |
|---|---|
| BELOPP | Amount |
| BOL | Company |
| BTYP | Journal Type |
| DIM1 | Dimension 1 |
| DIM2 | Dimension 2 |
| DIM3 | Dimension 3 |
| DIM4 | Dimension 4 |
| ETYP | Automatic Journal Type |
| INO | Automatic Identification Number |
| KONTO | Account Code |
| KTYPKONC | The group type and group to which values from the elimination of the acquisition calculations are booked. |
| MOTBOL | Counter Company used for intercompany balances and shareholdings. |
| MOTDIM | Counter Dimension used for eliminations of intercompany balances. This is only valid for dimension 1. |
| PERAKT | Period and Actuality |
| TRAVKD | Transaction Currency Code . |
| TRBELOPP | Transaction Currency Amount |
| URSBOL | Original Company (is different from BOL after consolidation), which reported the intercompany balance. |
| VERNR | Journal Number |
| VKOD | Currency Code |
| VTYP | Currency Type, where the field indicates if a journal has been entered in another currency than the local currency. |