Interface: NORM - ###KALKULATIONSANSATZ### Version 2012.00

This documentation describes the AbaConnect Interface ###KALKULATIONSANSATZ### for the NORM Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :NORM
Interface Name :###KALKULATIONSANSATZ###
ID :BA ( BA )
Version :2012.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
Master data.
See comment of the field RECART.
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 :###KALKULATIONSANSATZ###
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>NORM</Application>
      <Id>BA</Id>
      <MapId>AbaDefault</MapId>
      <Version>2012.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>
      <CalculationRateHeader mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </CalculationRateHeader>
    </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"  "-aNORM"  "-version2012.00"  "-M7777"  "-acidBA"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aNORM"  "-version2012.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
CalculationRateHeader###KALKULATIONSANSATZ###---No
    CalculationRateHeaderFieldsFieldsCalculationRateHeader--No
        - IDIDCalculationRateHeaderFieldsText10No
        - RateType###ANSATZ_TYP###CalculationRateHeaderFieldsNumber2No
        - AverageSalaryProposalAverage salary proposalCalculationRateHeaderFieldsText10No
        - Standard###NPK_STANDARD###CalculationRateHeaderFieldsBoolean-No
        - AutomaticProjectTransferAutomatic transfer to projectCalculationRateHeaderFieldsBoolean-No
        - ModificationDatePrice modification dateCalculationRateHeaderFieldsDate/Time-No
        - DataYearDatenjahrCalculationRateHeaderFieldsNumber4No
    CalculationRateHeaderText###KALKULATIONSANSATZ_KOPFTEXT###CalculationRateHeader--No
        CalculationRateHeaderTextFieldsFieldsCalculationRateHeaderText--No
            - LanguageCodeLanguageCalculationRateHeaderTextFieldsText6No
            - DesignationDesignationCalculationRateHeaderTextFieldsText60No
    CalculationRateItemCalculation rate itemCalculationRateHeader--No
        CalculationRateItemFieldsFieldsCalculationRateItem--No
            - ItemNumberItem no.CalculationRateItemFieldsNumber4No
            - ItemTypeItem typeCalculationRateItemFieldsNumber2No
            - RecognitionTypeRecognition typeCalculationRateItemFieldsNumber2No
            - PosTypeInfoPos-Typ InfoCalculationRateItemFieldsNumber2No
            - ItemNumberReferenceReferenceCalculationRateItemFieldsNumber4No
            - CalcGroupKalkulationsgruppeCalculationRateItemFieldsNumber8No
            - ValueValueCalculationRateItemFieldsNumber4No
            - ItemTotalItem totalCalculationRateItemFieldsNumber6No
            - TotalTotalCalculationRateItemFieldsNumber6No
            - Example###BEISPIELRECHNUNG_VERRECHNET###CalculationRateItemFieldsNumber12No
            - ItemAndRecognitionType###POS_AND_RECOGNITION_TYP###CalculationRateItemFieldsText100000No
        CalculationRateItemText###KALKULATIONSANSATZ_POSITIONSTEXT###CalculationRateItem--No
            CalculationRateItemTextFieldsFieldsCalculationRateItemText--No
                - LanguageCodeLanguageCalculationRateItemTextFieldsText6No
                - DesignationDesignationCalculationRateItemTextFieldsText60No



Field Information

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

Fields
XML Element Name:CalculationRateHeaderFields
Parent Element:CalculationRateHeader
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

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

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

###ANSATZ_TYP###
XML Element Name:RateType
Parent Element:CalculationRateHeaderFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Average salary proposal
XML Element Name:AverageSalaryProposal
Parent Element:CalculationRateHeaderFields
Field Type:Text
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

###NPK_STANDARD###
XML Element Name:Standard
Parent Element:CalculationRateHeaderFields
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Automatic transfer to project
XML Element Name:AutomaticProjectTransfer
Parent Element:CalculationRateHeaderFields
Field Type:Boolean (true oder false)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Price modification date
XML Element Name:ModificationDate
Parent Element:CalculationRateHeaderFields
Field Type:Datum/Zeit (2006-08-08T10:16:54.509+02:00)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Datenjahr
XML Element Name:DataYear
Parent Element:CalculationRateHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

###KALKULATIONSANSATZ_KOPFTEXT###
XML Element Name:CalculationRateHeaderText
Parent Element:CalculationRateHeader
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data

Fields
XML Element Name:CalculationRateHeaderTextFields
Parent Element:CalculationRateHeaderText
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Language
XML Element Name:LanguageCode
Parent Element:CalculationRateHeaderTextFields
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

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

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

Calculation rate item
XML Element Name:CalculationRateItem
Parent Element:CalculationRateHeader
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data.
The header in the base is in BOS.RECART=KALKANSATZ (calc. rate).
The texts in th base belonging to the items are in BOW.RECART=KALKANSATZPOS (calc. rate item).
In Project Management, the items in the project are in BLZ.

Fields
XML Element Name:CalculationRateItemFields
Parent Element:CalculationRateItem
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Item no.
XML Element Name:ItemNumber
Parent Element:CalculationRateItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Item type
XML Element Name:ItemType
Parent Element:CalculationRateItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Recognition type
XML Element Name:RecognitionType
Parent Element:CalculationRateItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Pos-Typ Info
XML Element Name:PosTypeInfo
Parent Element:CalculationRateItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Reference
XML Element Name:ItemNumberReference
Parent Element:CalculationRateItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Kalkulationsgruppe
XML Element Name:CalcGroup
Parent Element:CalculationRateItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

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

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

Item total
XML Element Name:ItemTotal
Parent Element:CalculationRateItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Total
XML Element Name:Total
Parent Element:CalculationRateItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   4Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

###BEISPIELRECHNUNG_VERRECHNET###
XML Element Name:Example
Parent Element:CalculationRateItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   12Decimal Places:   8Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

###POS_AND_RECOGNITION_TYP###
XML Element Name:ItemAndRecognitionType
Parent Element:CalculationRateItemFields
Field Type:Text
Action Type:Export only
Field Length:   100000Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

###KALKULATIONSANSATZ_POSITIONSTEXT###
XML Element Name:CalculationRateItemText
Parent Element:CalculationRateItem
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data

Fields
XML Element Name:CalculationRateItemTextFields
Parent Element:CalculationRateItemText
Field Type:Type[ 15 ]
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

Language
XML Element Name:LanguageCode
Parent Element:CalculationRateItemTextFields
Field Type:Text
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

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

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