Structure | Lucanet Knowledge Base

Getting Started

Global Functions

Lucanet Lume

Data Hub

Administration

Extended Planning & Analysis (xP&A)

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Tax Administration

Income Taxes

User Interface of Income Taxes

Modules and Additional Functions in Income Taxes

Income Tax Forms

Master Data

Periods

Countries

Reporting Dimensions

Companies

Foreign Branches / Fonds

CoA Group

CoA Company

Toolbox

Interfaces

Configuration

Structure

Position Mapping

Import Mapping

Administration

Company

(Sub-) Group

Reporting

Pillar 2

Country-by-Country Reporting

First Steps in Pillar 2 and CbCR

Tax Balance

Tax Services

Glossary

You can use interface structures to define the format of files imported into Income Taxes.

This article describes how to create and configure interface structures.

To create a new interface structure:

In the Structure workspace, click Create:

Configure the interface structure (see following subheading).

Click Save.

Configure an interface structure as follows.

(Areas marked with an asterisk * are displayed by default for all interface types.)

The ID area is displayed as follows:

Specify the following:

Name of the structure

Defines whether the structure is for a data import or an export.

Furthermore, the Workflow bot option can be used. For more information about the Workflow Bot, see Workflow Bot.

Defines the type of interface and the source of the import or export. The following interface types / sources are available for selection:

For an Export

Standard (csv, txt, xls)

Questionnaire

Custom Report

For an Import

Standard (csv, txt, xls)

Questionnaire

SAP RFC

for data exchange with SAP systems

Direct import

SAP RFC (flexibel)

for data exchange with SAP systems

Rest Service

The interface type chosen here depends on which details need to be configured for a structure in the following sections.

Selection of the area within Income Taxes into which the data are to be imported or from which the data are to be exported.

Selection of the connection created under Administration | Connection parameters.

The type must always match (REST connection for a REST structure etc.)

This field is visible only if you have chosen SAP RFC or SAP RFC (flexible) as interface type.

Selection of whether it is a default interface.

If an interface structure is defined as a default interface, it is always displayed in the import dialog.

If the data for companies are to be imported from different interfaces, an interface structure that has not been defined as a default interface can be explicitly assigned to the company (in the company's master data).

Whether and with which fields the General Settings area is displayed depends on what you have selected as Interface type/source under ID.

For the interface type Standard (csv, txt, xls), the General Settings area is displayed, for example, as follows:

Specify the following:

Name of the Excel worksheet to be imported/exported.

For export into a database table, the Excel worksheet must have the name of the database table.

Path of the file to be imported/exported

The following placeholders can be used when specifying the path:

{YYYY} last year

{MM} last month

{DD} last day

{year} current year

{month} current month

{day} current day

{min} current minute

{sec} current second

{PERIODID} period ID

{UNITID} company ID

{USERID} user ID

{USERNAME} user name

{BUKRS} reporting entity of the company

{ BUKRS1} 1. reporting entity of the company

{PATH_FILESERVER} path to the file server from system parameters

Example: For a period with end of period 2018-12-31, the path specification "C:\temp\import_{MM}{DD}.txt" is interpreted in the GTC as "C:\temp\import_1231.txt".

The desired number format (including decimal places, without sign) as a number > 1000.

Examples: 1 000.0 or 1234,56 or 1.234,56

Excel files (.XLS/.XLSX) provide the values with a period (.) as decimal separator and a preceding minus sign.

The delimiter used in the file

Specifies whether the file contains a header row.

Select Yes = 1 and No = 0

Symbol used for comments

Specifies whether the import file should be saved as a comment in each imported row or in the dialog.

Specifies whether the import value should be created as a comment in each imported row or in the dialog.

An automation is executed if the target is a sub-group, a calculation interface is present, or the import is triggered via a web service.

Whether and with which fields the Automation area is displayed depends on what you have selected as Interface type / source under ID.

For the interface type Standard (csv, txt, xls), the Automation area is displayed, for example, as follows:

Workspace Structure: Configure 'Automation'

Materiality levels to be imported. Only those companies whose materiality matches the materiality defined here are included.

Reporting dimensions to be taken into account for the import. The import is performed only for companies to which the reporting dimension chosen here is assigned.

Open milestones

: Open milestones for the import.

Close milestones

: Set milestones to the status finished after a successful import, if possible.

Reset milestones

: Set milestones for the import to the status in process.

Depending on which check box you activate in this area, the corresponding proposed values will be adopted or the differences in the B/S Comparison workspace will be distributed automatically:

Split differences

Set tax rates for LCF (KSt, GewSt)

If no tax rates are provided, the proposed value (= value from the master data) will be adopted.

LCF: Gross amount long term usable

Others: Adjustments related to other periods

Tax calculation Germany: Tax balance sheet profit/loss

Tax calculation Toolbox: Changes in differences

TRR: Transfer proposed values: Adopts the proposed values for the tax reconciliation (Tax Rate Reconciliation, TRR).

In the Data settings area, specify the rows and columns of the export or import files that contain the corresponding values.

Whether and with which fields the Data settings area is displayed depends on what you have selected as Interface type / source under ID.

For the interface type Standard (csv, txt, xls), the Data settings area is displayed, for example, as follows:

The area is only displayed if you have selected Direct import as the Interface type/Source under ID. It is not relevant for configuring interfaces on the Lucanet CFO Solution Platform.

The area is displayed as follows:

In the Parameters for the Import area, specify the import parameters.

This area is displayed only if you have chosen the type SAP RFC (flexible) as Interface type / source under ID.

The area is displayed as follows:

The data table transmitted from SAP can be defined in the Data table area.

This area is displayed only if you have chosen the type SAP RFC (flexible) as Interface type / source under ID and it is not relevant for the configuration of interfaces on the CFO Solution Platform.