Interface: NORM - Cost element Version 2012.00

This documentation describes the AbaConnect Interface Cost element for the NORM Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :NORM
Interface Name :Cost element
ID :BE ( BE )
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

                                  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 :Cost element
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>BE</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>
      <CostElementHeader mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </CostElementHeader>
    </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"  "-acidBE"  "-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
CostElementHeaderCost element---No
    CostElementHeaderFieldsFieldsCostElementHeader--No
        - CostElementAreaAreaCostElementHeaderFieldsNumber4No
        - CostElementCategoryCategoryCostElementHeaderFieldsNumber2No
        - CostElementMainGroupMain groupCostElementHeaderFieldsNumber6No
        - SubgroupSubgroupCostElementHeaderFieldsNumber2No
        - CostElementNumberCE no.CostElementHeaderFieldsText30No
        - QuantityUnitQUCostElementHeaderFieldsNumber4No
        - ProductGroupProduktegruppeCostElementHeaderFieldsNumber4No
        - ModificationDatePrice modification timeCostElementHeaderFieldsDate/Time-No
        - StatusStatusCostElementHeaderFieldsNumber2No
        - ANSATZTYPRate typeCostElementHeaderFieldsNumber2No
        - PriceModificationUserPrice modification user-NameCostElementHeaderFieldsText100000No
    CostElementHeaderTextCost element designationCostElementHeader--No
        CostElementHeaderTextFieldsFieldsCostElementHeaderText--No
            - LanguageCodeLanguageCostElementHeaderTextFieldsText6No
            - DesignationDesignationCostElementHeaderTextFieldsText60No
            - TextTextCostElementHeaderTextFieldsText-1No
    CostElementFieldValueCost element field valueCostElementHeader--No
        CostElementFieldValueFieldsFieldsCostElementFieldValue--No
            - FieldNumberField no.CostElementFieldValueFieldsNumber4No
            - ValueTypeValue typeCostElementFieldValueFieldsNumber2No
            - AmountAmountCostElementFieldValueFieldsNumber12No
            - PercentagePercentageCostElementFieldValueFieldsNumber4No
            - ServiceCodeService codeCostElementFieldValueFieldsNumber8No



Field Information

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

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

                

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

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

Main group
XML Element Name:CostElementMainGroup
Parent Element:CostElementHeaderFields
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")
                    

Subgroup
XML Element Name:Subgroup
Parent Element:CostElementHeaderFields
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 "KEUNTERGRP")
                    

CE no.
XML Element Name:CostElementNumber
Parent Element:CostElementHeaderFields
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:QuantityUnit
Parent Element:CostElementHeaderFields
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 "EHTNR")
                    

Produktegruppe
XML Element Name:ProductGroup
Parent Element:CostElementHeaderFields
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 "PRDGRP")
                    

Price modification time
XML Element Name:ModificationDate
Parent Element:CostElementHeaderFields
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")
                    

Status
XML Element Name:Status
Parent Element:CostElementHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Rate type
XML Element Name:ANSATZTYP
Parent Element:CostElementHeaderFields
Field Type:Nummer
Action Type:Export only
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Price modification user-Name
XML Element Name:PriceModificationUser
Parent Element:CostElementHeaderFields
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 "MUTPRUSER_NAME")
                    

Cost element designation
XML Element Name:CostElementHeaderText
Parent Element:CostElementHeader
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data. The designation of a cost element is not mandatory.

Fields
XML Element Name:CostElementHeaderTextFields
Parent Element:CostElementHeaderText
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:CostElementHeaderTextFields
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:CostElementHeaderTextFields
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")
                    

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

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

Cost element field value
XML Element Name:CostElementFieldValue
Parent Element:CostElementHeader
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Master data

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

                

Field no.
XML Element Name:FieldNumber
Parent Element:CostElementFieldValueFields
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 "KEFELDNR")
                    

Value type
XML Element Name:ValueType
Parent Element:CostElementFieldValueFields
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 "WERTTYP")
                    

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

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

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

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

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