Interface: FIBU - Deviation analysis data Version 2025.00

This documentation describes the AbaConnect Interface Deviation analysis data for the FIBU Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :FIBU
Interface Name :Deviation analysis data
ID :VarianceAnalysisData ( VarianceAnalysis )
Version :2025.00
Status:Productive


Displays the possible import and export features for this interface.

Export / Import Modus
Export :XML
Import :XML


Displays additional information for this interface.

Additional Information

                                  Highest field Revision for this interface : 0



Mapping Information

The following displays the Mapping details for this interface.

Mapping Information
Mapping ID :AbaDefault
Mapping Name :
Description :

                



Example AbaConnect XML Structure

The following is an example of an XML Header structure. This information is also visible in an AbaConnect XML Export file, that has been exported via the Abacus AbaConnect User Interface.

AbaConnect XML Struktur
<?xml version='1.0' encoding='UTF-8'?>
<AbaConnectContainer>
  <TaskCount>1</TaskCount>
  <Task>
    <Parameter>
      <Application>FIBU</Application>
      <Id>VarianceAnalysisData</Id>
      <MapId>AbaDefault</MapId>
      <Version>2025.00</Version>
      <!-- Attention : The client number (Mandant) is optional and implies that the data can only be imported into specified client (Mandant) -->
      <!-- The Client Option (Mandant) only has an influence when importing data. It can be configured in the AbaConnect Export Settings. -->
      <!-- By default, the client number (Mandant) is not written to the export file -->
      <Mandant>7777</Mandant>
    </Parameter>
    <Transaction>
      <FinancePlanData mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </FinancePlanData>
    </Transaction>
  </Task>
</AbaConnectContainer>



Example AbaConnect Command Line

The following includes examples of AbaConnect Command Line. The AbaConnect Command Line is executed with the abaconnectexportconsole.exe and abaconnectimportconsole.exe programmes. The AbaConnect Command Line must be run direct on the Abacus server. More detailed information about AbaConnect Command Line is available on the Abacus Homepage. The following examples serve as starting point for creating a simple command line.

AbaConnect Command Line
Export :
abaconnectexportconsole.exe "/USRuser" "/PWxxx"  "-aFIBU"  "-version2025.00"  "-M7777"  "-acidVarianceAnalysisData"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aFIBU"  "-version2025.00"  "-M7777"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-importfileX:\data.xml"

N.B. : For importing XML data, it is not necessary to specify the Interface ID and Mapping on the Command Line. This information is contained in the XML Import file.



Mapping Structure

The following displays a simplified mapping structure for this interface.
The XML-Element and Parent-Name are always in english. Click on the row to display additional information.

XML Element Name Field Name Parent Name Type Length Mandatory
FinancePlanDataDeviation analysis data---Yes
    - EnterpriseCompanyFinancePlanDataNumber6Yes
    - PlanPlanFinancePlanDataText10No
    - VariantVariantFinancePlanDataText10Yes
    - InstanceInstanceFinancePlanDataText10Yes
    - IDIDFinancePlanDataNumber12No
    - SourceTypeOrigin typeFinancePlanDataNumber6Yes
    ElementElementFinancePlanData--No
        - EnterpriseCompanyElementNumber6Yes
        - DivisionDivisionElementNumber6Yes
        - IDElement IDElementGUID36No
        - AccountAccountElementNumber12Yes
        - AccountIsClassificationAccount classifications groupElementBoolean-No
        - CostCenter1Cost centre 1ElementNumber12Yes
        - CostCenter1IsClassificationCost centre 1 classifications groupElementBoolean-No
        - CostCenter2Cost centre 2ElementNumber12Yes
        - CostCenter2IsClassificationCost centre 2 classifications groupElementBoolean-No
        - RepeatingRecurringElementBoolean-Yes
        - EditorUserElementGUID36No
        - EditedLast modificationElementDate/Time-No
        - CombinationCommentaryCombinations commentElementBoolean-Yes
        ValueValueElement--No
            - AmountAmountValueNumber14Yes
            - DateDateValueDate-Yes
            - QuantityQuantityValueNumber12No
            - RateValueNumber12No
        CommentaryCommentsElement--No
            - LanguageLanguageCommentaryText6Yes
            - TextTextCommentaryText99999999Yes
            - ColumnColumnCommentaryNumber3Yes
        DesignationDesignationElement--No
            - LanguageLanguageDesignationText6Yes
            - TextDesignationDesignationText200Yes
        - ProjectProject numberElementNumber11Yes
        - ProjectIsClassificationProject classificationElementBoolean-No
        - AccClassRefAccount classification informationElementGUID36No
        - Cc1ClassRefCost centre 1 classification informationElementGUID36No
        - Cc2ClassRefCost centre 2 classification informationElementGUID36No
        - ProjClassRefProject classification informationElementGUID36No
        - MeasureUnitElementText20No



Field Information

The following is a detailed description of the fields used in this interface.

Company
XML Element Name:Enterprise
Parent Element:FinancePlanData
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   7
Description:

                                  (The internal field ID for this element is "enterprise")
                    

Plan
XML Element Name:Plan
Parent Element:FinancePlanData
Field Type:Text
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "plan")
                    

Variant
XML Element Name:Variant
Parent Element:FinancePlanData
Field Type:Text
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

                                  (The internal field ID for this element is "variant")
                    

Instance
XML Element Name:Instance
Parent Element:FinancePlanData
Field Type:Text
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   3
Description:

                                  (The internal field ID for this element is "instance")
                    

ID
XML Element Name:ID
Parent Element:FinancePlanData
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

                                  (The internal field ID for this element is "id")
                    

Origin type
XML Element Name:SourceType
Parent Element:FinancePlanData
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   6
Description:

                                  (The internal field ID for this element is "sourceType")
                    

Element
XML Element Name:Element
Parent Element:FinancePlanData
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:

                                  (The internal field ID for this element is "fpElement")
                    

Company
XML Element Name:Enterprise
Parent Element:Element
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   14
Description:

                                  (The internal field ID for this element is "enterprise")
                    

Division
XML Element Name:Division
Parent Element:Element
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   15
Description:

                                  (The internal field ID for this element is "division")
                    

Element ID
XML Element Name:ID
Parent Element:Element
Field Type:GUID
Action Type:Import und Export
Field Length:   36Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "id")
                    

Account
XML Element Name:Account
Parent Element:Element
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

                                  (The internal field ID for this element is "account")
                    

Account classifications group
XML Element Name:AccountIsClassification
Parent Element:Element
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   3
Description:

                                  (The internal field ID for this element is "accIsClassification")
                    

Cost centre 1
XML Element Name:CostCenter1
Parent Element:Element
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   4
Description:

                                  (The internal field ID for this element is "costCenter1")
                    

Cost centre 1 classifications group
XML Element Name:CostCenter1IsClassification
Parent Element:Element
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   5
Description:

                                  (The internal field ID for this element is "cc1IsClassification")
                    

Cost centre 2
XML Element Name:CostCenter2
Parent Element:Element
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   6
Description:

                                  (The internal field ID for this element is "costCenter2")
                    

Cost centre 2 classifications group
XML Element Name:CostCenter2IsClassification
Parent Element:Element
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   7
Description:

                                  (The internal field ID for this element is "cc2IsClassification")
                    

Recurring
XML Element Name:Repeating
Parent Element:Element
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   8
Description:

                                  (The internal field ID for this element is "repeating")
                    

User
XML Element Name:Editor
Parent Element:Element
Field Type:GUID
Action Type:Import und Export
Field Length:   36Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   9
Description:

                                  (The internal field ID for this element is "editor")
                    

Last modification
XML Element Name:Edited
Parent Element:Element
Field Type:Datum/Zeit (2006-08-08T10:16:54.509+02:00)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   10
Description:

                                  (The internal field ID for this element is "edited")
                    

Combinations comment
XML Element Name:CombinationCommentary
Parent Element:Element
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   16
Description:

                                  (The internal field ID for this element is "combinationCommentary")
                    

Value
XML Element Name:Value
Parent Element:Element
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   11
Description:

                                  (The internal field ID for this element is "fpPool")
                    

Amount
XML Element Name:Amount
Parent Element:Value
Field Type:Nummer
Action Type:Import und Export
Field Length:   14Decimal Places:   2Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "amount")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Date
XML Element Name:Date
Parent Element:Value
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

                                  (The internal field ID for this element is "date")
                    

Quantity
XML Element Name:Quantity
Parent Element:Value
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   3
Description:

                                  (The internal field ID for this element is "quantity")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

XML Element Name:Rate
Parent Element:Value
Field Type:Nummer
Action Type:Import und Export
Field Length:   12Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   4
Description:

                                  (The internal field ID for this element is "rate")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Comments
XML Element Name:Commentary
Parent Element:Element
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   12
Description:

                                  (The internal field ID for this element is "fpNote")
                    

Language
XML Element Name:Language
Parent Element:Commentary
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "language")
                    

Text
XML Element Name:Text
Parent Element:Commentary
Field Type:Text
Action Type:Import und Export
Field Length:   99999999Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

                                  (The internal field ID for this element is "text")
                    

Column
XML Element Name:Column
Parent Element:Commentary
Field Type:Nummer
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   3
Description:

                                  (The internal field ID for this element is "column")
                    

Designation
XML Element Name:Designation
Parent Element:Element
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   13
Description:

                                  (The internal field ID for this element is "fpDesignation")
                    

Language
XML Element Name:Language
Parent Element:Designation
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   1
Description:

                                  (The internal field ID for this element is "language")
                    

Designation
XML Element Name:Text
Parent Element:Designation
Field Type:Text
Action Type:Import und Export
Field Length:   200Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   2
Description:

                                  (The internal field ID for this element is "text")
                    

Project number
XML Element Name:Project
Parent Element:Element
Field Type:Nummer
Action Type:Import und Export
Field Length:   11Decimal Places:   0Mandatory Field:   YesRevision:   0Ascii ID :   17
Description:

                                  (The internal field ID for this element is "project")
                    

Project classification
XML Element Name:ProjectIsClassification
Parent Element:Element
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   18
Description:

                                  (The internal field ID for this element is "projectIsClassification")
                    

Account classification information
XML Element Name:AccClassRef
Parent Element:Element
Field Type:GUID
Action Type:Import und Export
Field Length:   36Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   19
Description:

                                  (The internal field ID for this element is "accClassRef")
                    

Cost centre 1 classification information
XML Element Name:Cc1ClassRef
Parent Element:Element
Field Type:GUID
Action Type:Import und Export
Field Length:   36Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   20
Description:

                                  (The internal field ID for this element is "cc1ClassRef")
                    

Cost centre 2 classification information
XML Element Name:Cc2ClassRef
Parent Element:Element
Field Type:GUID
Action Type:Import und Export
Field Length:   36Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   21
Description:

                                  (The internal field ID for this element is "cc2ClassRef")
                    

Project classification information
XML Element Name:ProjClassRef
Parent Element:Element
Field Type:GUID
Action Type:Import und Export
Field Length:   36Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   22
Description:

                                  (The internal field ID for this element is "projClassRef")
                    

Unit
XML Element Name:Measure
Parent Element:Element
Field Type:Text
Action Type:Import und Export
Field Length:   20Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   23
Description:

                                  (The internal field ID for this element is "measure")