Creating an Assignment Table

Getting Started

Global Functions

Lucanet Lume

Administration

Extended Planning & Analysis (xP&A)

creating-model

xP&A Video Tutorials

User Roles in Lucanet xP&A

Lucanet xP&A User Interface

All Steps at a Glance

Basic Concepts and Elements

Integrating Data

Connecting to a Data Source

sharing-data-connections

Working With Integrated Data

Guideline for Exchanging Data Between xP&A and CFP

Connecting to a Lucanet CFP Data Source

Initial Data Import from xP&A to CFP

Creating a Data Export in xP&A for CFP

Creating and Configuring the Script Lucanet xP&A #3700-xP&A.SQL.FOS

Creating and Configuring the Data Source

Creating an Assignment Table

Creating and Executing the Data Import into CFP

Updating the Data Import from xP&A to CFP

Modeling Your Data

Viewing and Visualizing Data

Working with Models

Using Comments and Descriptions

Comparison: xP&A vs. Excel Performance

Consolidation & Financial Planning

ESG Reporting

Disclosure Management

XBRL Tagger

Lease Accounting

Banking & Cash Management

Data Collection

Tax Compliance & Reporting

Glossary

An assignment table is used to save all elements imported from xP&A (e.g. accounts, reporting entities/cost centers, transaction currency, etc.) and their assignment to elements in CFP.

Assignments are defined during the data import and can then be changed or deleted at any time.

Note for customers who still use Lucanet.Financial Client

You can either perform this step in the Lucanet CFO Solution Platform or in Lucanet.Financial Client. The data source will be visible and editable in both systems, no matter where you created it.

To create an assignment table, proceed as follows:

In the tree view, right-click the Assignment tables folder and choose Create | Assignment table from the context menu.

The Create element dialog is displayed:

Specify the name of the assignment table in the Name field.

Click Save or press Enter.

The assignment table is displayed in the tree view and can be selected when creating the data import (see Creating and Executing the Data Import ).

Last updated on May 28, 2026

Creating an Assignment Table

Overview

Creating an Assignment Table

Overview