Interface: NORM - ###SPALTENSET### Version 2015.00

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


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :NORM
Interface Name :###SPALTENSET###
ID :BF ( BF )
Version :2015.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
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 :###SPALTENSET###
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>BF</Id>
      <MapId>AbaDefault</MapId>
      <Version>2015.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>
      <ColumnSet mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </ColumnSet>
    </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"  "-version2015.00"  "-M7777"  "-acidBF"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aNORM"  "-version2015.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
ColumnSet###SPALTENSET###---No
    ColumnSetFieldsFieldsColumnSet--No
        - ColumnSetNumberNo.ColumnSetFieldsNumber6No
        - ServiceCodeService codeColumnSetFieldsNumber8No
    ColumnSetDesignation###SPALTENSET_TEXT###ColumnSet--No
        ColumnSetDesignationFieldsFieldsColumnSetDesignation--No
            - LanguageCodeLanguageColumnSetDesignationFieldsText6No
            - DesignationDesignationColumnSetDesignationFieldsText30No
    DailyReportColumn###SPALTENDEFINITION###ColumnSet--No
        DailyReportColumnFieldsFieldsDailyReportColumn--No
            - ValuationTypeRate typeDailyReportColumnFieldsNumber2No
            - ColumnNumberColumn no.DailyReportColumnFieldsNumber4No
            - ItemTypeItem typeDailyReportColumnFieldsNumber2No
            - AreaAreaDailyReportColumnFieldsNumber4No
            - ProductTypeProduct typeDailyReportColumnFieldsText3No
            - CostElementMainGroupCE main groupDailyReportColumnFieldsNumber6No
            - CostElementSubgroupCE sub-groupDailyReportColumnFieldsNumber4No
            - CostElementNumberCE no.DailyReportColumnFieldsText30No
            - QuantityNumberQUDailyReportColumnFieldsNumber4No
            - VariantProductDailyReportColumnFieldsBoolean-No
            - ProductVariantIDProduct variantDailyReportColumnFieldsNumber8No
            - CategoryCategoryDailyReportColumnFieldsNumber2No
            - ServiceCodeService codeDailyReportColumnFieldsNumber8No
            - VisibleVisibleDailyReportColumnFieldsBoolean-No
        ColumnDesignation###SPALTENDEFINITION_TEXT###DailyReportColumn--No
            ColumnDesignationFieldsFieldsColumnDesignation--No
                - LanguageCodeLanguageColumnDesignationFieldsText6No
                - DesignationDesignationColumnDesignationFieldsText40No
        TariffItem###REGIETARIFPOSITIONEN###DailyReportColumn--No
            TariffItemFieldsFieldsTariffItem--No
                - ItemNumberNr. 4TariffItemFieldsNumber2No
                - RegieAreaAreaTariffItemFieldsNumber4No
                - RegieYearYearTariffItemFieldsNumber4No
                - RegieRegionRegionTariffItemFieldsNumber4No
                - CategoryCategoryTariffItemFieldsNumber2No
                - TariffItemNumberTariff item no.TariffItemFieldsText12No
                - RateNumberRate no.TariffItemFieldsNumber2No
                - ProposedPriceTypeSuggested price typeTariffItemFieldsNumber2No



Field Information

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

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

                

No.
XML Element Name:ColumnSetNumber
Parent Element:ColumnSetFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Service code
XML Element Name:ServiceCode
Parent Element:ColumnSetFields
Field Type:Nummer
Action Type:Export only
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

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

Fields
XML Element Name:ColumnSetDesignationFields
Parent Element:ColumnSetDesignation
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:ColumnSetDesignationFields
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:ColumnSetDesignationFields
Field Type:Text
Action Type:Import und Export
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

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

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

                

Rate type
XML Element Name:ValuationType
Parent Element:DailyReportColumnFields
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 "ANSATZTYP")
                    

Column no.
XML Element Name:ColumnNumber
Parent Element:DailyReportColumnFields
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 "SPALTENNR")
                    

Item type
XML Element Name:ItemType
Parent Element:DailyReportColumnFields
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")
                    

Area
XML Element Name:Area
Parent Element:DailyReportColumnFields
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 "KEBEREICH")
                    

Product type
XML Element Name:ProductType
Parent Element:DailyReportColumnFields
Field Type:Text
Action Type:Import und Export
Field Length:   3Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

CE main group
XML Element Name:CostElementMainGroup
Parent Element:DailyReportColumnFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

CE sub-group
XML Element Name:CostElementSubgroup
Parent Element:DailyReportColumnFields
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 "KEUNTERGRP")
                    

CE no.
XML Element Name:CostElementNumber
Parent Element:DailyReportColumnFields
Field Type:Text
Action Type:Import und Export
Field Length:   30Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

QU
XML Element Name:QuantityNumber
Parent Element:DailyReportColumnFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Quantity unit
(The internal field ID for this element is "EHTNR")

XML Element Name:VariantProduct
Parent Element:DailyReportColumnFields
Field Type:Boolean (true oder false)
Action Type:Export only
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Product variant
XML Element Name:ProductVariantID
Parent Element:DailyReportColumnFields
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 "VARID")
                    

Category
XML Element Name:Category
Parent Element:DailyReportColumnFields
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 "KEKAT")
                    

Service code
XML Element Name:ServiceCode
Parent Element:DailyReportColumnFields
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 "LEIART")
                    

Visible
XML Element Name:Visible
Parent Element:DailyReportColumnFields
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 "SICHTBAR")
                    

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

Fields
XML Element Name:ColumnDesignationFields
Parent Element:ColumnDesignation
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:ColumnDesignationFields
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:ColumnDesignationFields
Field Type:Text
Action Type:Import und Export
Field Length:   40Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

###REGIETARIFPOSITIONEN###
XML Element Name:TariffItem
Parent Element:DailyReportColumn
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data.
See comment of the field RECART.

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

                

Nr. 4
XML Element Name:ItemNumber
Parent Element:TariffItemFields
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")
                    

Area
XML Element Name:RegieArea
Parent Element:TariffItemFields
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 "REBEREICH")
                    

Year
XML Element Name:RegieYear
Parent Element:TariffItemFields
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 "REJAHR")
                    

Region
XML Element Name:RegieRegion
Parent Element:TariffItemFields
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 "REREGION")
                    

Category
XML Element Name:Category
Parent Element:TariffItemFields
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 "KEKAT")
                    

Tariff item no.
XML Element Name:TariffItemNumber
Parent Element:TariffItemFields
Field Type:Text
Action Type:Import und Export
Field Length:   12Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Rate no.
XML Element Name:RateNumber
Parent Element:TariffItemFields
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 "ANSATZNR")
                    

Suggested price type
XML Element Name:ProposedPriceType
Parent Element:TariffItemFields
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 "PREISTYPVORSCHLAG")