Master Data Setup
Initialization script
- An initialization script must be written which uses the DAL (DAL.NEW) of the involved tables to create rows in the database tables mentioned in the sections below.
- Naming conventions mentioned in this document should be strictly adhered to. Otherwise, mixing up with (future) standard data cannot be ruled out.
Business objects (tfgld454)
This table shows the business objects that will be part of integration transactions displayed in, for example, the Integration Transactions (tfgld4582m000) session.
| Field | Description | Format | Domain | Mandatory * | Comments |
|---|---|---|---|---|---|
| bona | business object | str(17) | tcbona | Yes | must start with the "#"-character; other characters are free to choose; this name will be displayed in, for example, the Integration Transactions (tfgld4582m000) |
| lita | transaction logging allowed | enum | tcyesno | Yes | value: tcyesno.yes |
| maal | mapping allowed | enum | tcyesno | Yes | value: tcyesno.no |
* For external data, this setting may be different from the table field’s property.
Elements (tfgld456)
This table shows the elements that will be logged related to integration transactions, and will be primarily used for ledger account and dimension mapping. The elements are displayed when, for example, you set up the mapping scheme.
| Field | Description | Format | Domain | Mandatory * | Comments |
|---|---|---|---|---|---|
| elcd | element code | str(12) | tfgld.elcd | Yes | must start with the string "EXT"; other characters must be numeric |
| bonm | business object | str(17) | tcbona | Yes | soft reference to tfgld454.bona |
| boat | business object attribute | str(17) | tcboat | Yes | must start with the "#" character; other characters are free to choose; this name will be displayed when you maintain the mapping scheme |
| elds | element description | str(30) | tcdsca | Yes | description of the element that will be visible to the user |
| levl | element level | byte | tfgld.srno | Yes | value: 1 |
| pecd | parent element | str(12) | tfgld.elcd | No | should be left empty (not used externally) |
| rcel | reconciliation element | str(12) | tcrelc | No | should be left empty (not used externally) |
| bpyn | business partner | enum | tcyesno | Yes | value: tcyesno.no (not used externally) |
| expi | expired y/n | enum | tcyesno | Yes | value: tcyesno.no |
* For external data, this setting may be different from the table field’s property.
Integration document types (tfgld457)
This table shows the integration document types that will be part of integration transactions displayed in, for example, the Integration Transactions (tfgld4582m000) session.
| Field | Description | Format | Domain | Mandatory * | Comments |
|---|---|---|---|---|---|
| idtc | integration document type | str(8) | tcidty | Yes | must start with the string "EXT"; other characters must be numeric |
| idtd | integration document type description | str(30) | tcdsca | Yes | must start with the "#" character; other characters are free to choose; this name will be displayed in, for example, the Integration Transactions (tfgld4582m000) session |
| bonm | business object | str(17) | tcbona | Yes | soft reference to tfgld454.bona |
| secd | sort element | str(12) | tfgld.elcd | no | soft reference to tfgld456.elcd; must only be filled if the sort element functionality is used |
| modt | modifiable document type | enum | tcyesno | Yes | value: tcyesno.no |
| ppdt | publish posting details | enum | tcyesno | Yes | value: tcyesno.no (not used externally) |
| expi | expired y/n | enum | tcyesno | Yes | value: tcyesno.no |
| lemm | ledger mapping mandatory | enum | tcyesno | Yes | value: tcyesno.yes |
| dlae | log all elements debit | enum | tcyesno | Yes | value: tcyesno.yes |
| clae | log all elements credit | enum | tcyesno | Yes | value: tcyesno.yes |
| maal | mapping allowed | enum | tcyesno | Yes | value: tcyesno.yes |
| ltia | linked to integration account | enum | tcyesno | Yes | value: tcyesno.yes |
* For external data, this setting may be different from the table field’s property.
Elements by integration document type (tfgld458)
This table shows the elements that will be logged for a particular integration document type, and that can be used within the mapping scheme for ledger account and dimension mapping.
| Field | Description | Format | Domain | Mandatory * | Comments |
|---|---|---|---|---|---|
| idtc | integration document type | str(8) | tcidty | Yes | refers to tfgld457.idtc |
| elcd | element code | str(12) | tfgld.elcd | Yes | refers to tfgld456.elcd |
| dele | debit ledger mapping applicable | enum | tcyesno | Yes | value: tcyesno.yes |
| crle | credit ledger mapping applicable | enum | tcyesno | Yes | value: tcyesno.yes |
| nefi | never filled | enum | tcyesno | Yes | value: tcyesno.no |
| bpgl | business partner for general ledger | enum | tcyesno | Yes | value: tcyesno.no (not used externally) |
* For external data, this setting may be different from the table field’s property.
Additional procedure steps
After running the initialization script, complete these steps:
- To update the business object and integration document type language dependent descriptions, in the Integration Parameters (tfgld4150s000) session, from the appropriate menu, select .
-
In the Period Handling by Integration Document Type (tfgld4579m000) session, for each external integration document type – debit/credit combination, set Closed Period Handling to either Post to next open period or Post to current period. (Exception handling is only applicable for internal business objects.)
Because table tfgld479 must be shared for all financial companies (please check!), you do not need to repeat this step for each individual financial company.