Interface: ORDE - QA inspection plan Version 2013.00

This documentation describes the AbaConnect Interface QA inspection plan for the ORDE Application.


General Information

General information about the AbaConnect interface.

AbaConnect Interface Information
Application :ORDE
Interface Name :QA inspection plan
ID :Pruefplan ( QS )
Version :2013.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 :QA inspection plan
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>ORDE</Application>
      <Id>Pruefplan</Id>
      <MapId>AbaDefault</MapId>
      <Version>2013.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>
      <InspectionPlanHeader mode='SAVE'>
          <!-- The specific data fields for the AbaConnect interface are included here. -->
      </InspectionPlanHeader>
    </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"  "-aORDE"  "-version2013.00"  "-M7777"  "-acidPruefplan"  "-mapidAbaDefault"  "-datamodeXML"  "-responseYES"  "-responsefileX:\response.xml"  "-exportfileX:\data.xml"

Import :
abaconnectimportconsole.exe "/USRuser" "/PWxxx"  "-aORDE"  "-version2013.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
InspectionPlanHeaderInspection plan header---No
    InspectionPlanHeaderFieldsFieldsInspectionPlanHeader--No
        - InspectionPlanNumberInspection plan no. (PPNR)
InspectionPlanHeaderFieldsNumber10No
        - InspectionPlanVersionNumberVersion no. (VERSNR)
InspectionPlanHeaderFieldsNumber6No
        - DesignationDesignation (BEZEICHNUNG)
InspectionPlanHeaderFieldsText40No
        - CodeTypeType (CDTYP)
InspectionPlanHeaderFieldsNumber2No
        - InactiveInactive (CBINAKTIV)
InspectionPlanHeaderFieldsBoolean-No
        - ValidFromValid from (GUELTIGAB)
InspectionPlanHeaderFieldsDate-No
        - ProcessFlowNumberSequence no. (ABLAUFNR)
InspectionPlanHeaderFieldsNumber4No
        - StockLocationStorage location (LAGERORT)
InspectionPlanHeaderFieldsText8No
        - BinLocationStorage place (LAGERPLATZ)
InspectionPlanHeaderFieldsText8No
        - ItemDeletionAllowedDeleting item allowed (CBPOSDEL)
InspectionPlanHeaderFieldsBoolean-No
        - CreationDateCreated on (ERSTDAT)
InspectionPlanHeaderFieldsDate/Time-No
        - ModificationDateModified on (MUTDAT)
InspectionPlanHeaderFieldsDate/Time-No
        - InspectionPlanBlockedSwitchInspection plan blocked Y/N (RECLOCK)
InspectionPlanHeaderFieldsNumber2No
        - StockLocationSampleStorage location for sample (LAGERORTMUSTER)
InspectionPlanHeaderFieldsText8No
        - BinLocationSampleStorage place for sample (LAGERPLATZMUSTER)
InspectionPlanHeaderFieldsText8No
        - ModificationUserModified by (OPKMUTUSER)
InspectionPlanHeaderFieldsText255No
        - CreationUserCreated by (OPKESTUSER)
InspectionPlanHeaderFieldsText255No
    InspectionPlanItemInspection plan itemInspectionPlanHeader--No
        InspectionPlanItemFieldsFieldsInspectionPlanItem--No
            - InspectionPlanNumberInspection plan no. (PPNR)
InspectionPlanItemFieldsNumber10No
            - InspectionPlanVersionNumberVersion no. (VERSNR)
InspectionPlanItemFieldsNumber6No
            - ItemNumberItem no. (POSNR)
InspectionPlanItemFieldsNumber8No
            - ItemTypeItem type (POSTYP)
InspectionPlanItemFieldsNumber2No
            - SpecificationNumberSpecification no. (SPEZNR)
InspectionPlanItemFieldsNumber8No
            - SpecificationDesignation1Specification designation 1 (SPEZBEZ1)
InspectionPlanItemFieldsText40No
            - SpecificationDesignation2Specification designation 2 (SPEZBEZ2)
InspectionPlanItemFieldsText40No
            - SpecificationReleaseRelevantSpecification is relevant for release (CBRELEVANT)
InspectionPlanItemFieldsBoolean-No
            - UnitNumberUnit no. (EINHNR)
InspectionPlanItemFieldsNumber4No
            - MinimumValueMinimum value of the specification (SOLLMIN)
InspectionPlanItemFieldsNumber12No
            - MaximumValueMaximum of the specification (SOLLMAX)
InspectionPlanItemFieldsNumber12No
            - TargetValueSpecificationTarget value of the specification (SOLLZIEL)
InspectionPlanItemFieldsNumber12No
            - SpecificationTextSpecification text (SOLLTEXT)
InspectionPlanItemFieldsText40No
            - SpecificationCodeTable entry no. 23 (CDSPEZ)
InspectionPlanItemFieldsNumber4No
            - InspectionLocationCodeTable entry no. 24 (CDPRPLATZ)
InspectionPlanItemFieldsNumber4No
            - InspectionEquipmentCodeTable entry no. 25 (CDPRMITTEL)
InspectionPlanItemFieldsNumber4No
        ItemTextTexts ABEA ###VIEWLET_OTX_POSITIONTEXT###InspectionPlanItem--No
            ItemTextFieldsFieldsItemText--No
                - TextNumberText no. (TEXT_NR)
ItemTextFieldsNumber4No
                - HtmlText (HTML_TEXT)
ItemTextFieldsText-1No
    HeaderTextTexts ABEA ###VIEWLET_OTX_KOPF_KOPFTEXT###InspectionPlanHeader--No
        HeaderTextFieldsFieldsHeaderText--No
            - TextTypeText type (TEXT_TYP)
HeaderTextFieldsText2No
            - DocumentTypeDocument type (DOK_TYP)
HeaderTextFieldsNumber8No
            - HtmlHeaderText (HTML_KOPFTEXT)
HeaderTextFieldsText-1No



Field Information

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

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

                

Inspection plan no.
XML Element Name:InspectionPlanNumber
Parent Element:InspectionPlanHeaderFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Version no.
XML Element Name:InspectionPlanVersionNumber
Parent Element:InspectionPlanHeaderFields
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 "VERSNR")
                    

Designation
XML Element Name:Designation
Parent Element:InspectionPlanHeaderFields
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 "BEZEICHNUNG")
                    

Type
XML Element Name:CodeType
Parent Element:InspectionPlanHeaderFields
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 "CDTYP")
                    

Inactive
XML Element Name:Inactive
Parent Element:InspectionPlanHeaderFields
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 "CBINAKTIV")
                    

Valid from
XML Element Name:ValidFrom
Parent Element:InspectionPlanHeaderFields
Field Type:Datum (2000-03-20)
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Sequence no.
XML Element Name:ProcessFlowNumber
Parent Element:InspectionPlanHeaderFields
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 "ABLAUFNR")
                    

Storage location
XML Element Name:StockLocation
Parent Element:InspectionPlanHeaderFields
Field Type:Text
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Storage location for stock transfer at release
(The internal field ID for this element is "LAGERORT")

Storage place
XML Element Name:BinLocation
Parent Element:InspectionPlanHeaderFields
Field Type:Text
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Storage place for stock transfer at release
(The internal field ID for this element is "LAGERPLATZ")

Deleting item allowed
XML Element Name:ItemDeletionAllowed
Parent Element:InspectionPlanHeaderFields
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 "CBPOSDEL")
                    

Created on
XML Element Name:CreationDate
Parent Element:InspectionPlanHeaderFields
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 :   -
Description:

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

Modified on
XML Element Name:ModificationDate
Parent Element:InspectionPlanHeaderFields
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 "MUTDAT")
                    

Inspection plan blocked Y/N
XML Element Name:InspectionPlanBlockedSwitch
Parent Element:InspectionPlanHeaderFields
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 "RECLOCK")
                    

Storage location for sample
XML Element Name:StockLocationSample
Parent Element:InspectionPlanHeaderFields
Field Type:Text
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Storage place for sample
XML Element Name:BinLocationSample
Parent Element:InspectionPlanHeaderFields
Field Type:Text
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Modified by
XML Element Name:ModificationUser
Parent Element:InspectionPlanHeaderFields
Field Type:Text
Action Type:Export only
Field Length:   255Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Created by
XML Element Name:CreationUser
Parent Element:InspectionPlanHeaderFields
Field Type:Text
Action Type:Export only
Field Length:   255Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Inspection plan item
XML Element Name:InspectionPlanItem
Parent Element:InspectionPlanHeader
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

                

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

                

Inspection plan no.
XML Element Name:InspectionPlanNumber
Parent Element:InspectionPlanItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   10Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Version no.
XML Element Name:InspectionPlanVersionNumber
Parent Element:InspectionPlanItemFields
Field Type:Nummer
Action Type:Export only
Field Length:   6Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:

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

Item no.
XML Element Name:ItemNumber
Parent Element:InspectionPlanItemFields
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 "POSNR")
                    

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

Specification no.
XML Element Name:SpecificationNumber
Parent Element:InspectionPlanItemFields
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 "SPEZNR")
                    

Specification designation 1
XML Element Name:SpecificationDesignation1
Parent Element:InspectionPlanItemFields
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 "SPEZBEZ1")
                    

Specification designation 2
XML Element Name:SpecificationDesignation2
Parent Element:InspectionPlanItemFields
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 "SPEZBEZ2")
                    

Specification is relevant for release
XML Element Name:SpecificationReleaseRelevant
Parent Element:InspectionPlanItemFields
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 "CBRELEVANT")
                    

Unit no.
XML Element Name:UnitNumber
Parent Element:InspectionPlanItemFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
According to EIO basis no.
(The internal field ID for this element is "EINHNR")

Minimum value of the specification
XML Element Name:MinimumValue
Parent Element:InspectionPlanItemFields
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 "SOLLMIN")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Maximum of the specification
XML Element Name:MaximumValue
Parent Element:InspectionPlanItemFields
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 "SOLLMAX")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Target value of the specification
XML Element Name:TargetValueSpecification
Parent Element:InspectionPlanItemFields
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 "SOLLZIEL")
                    
The decimal separator for numbers must be represented with a point, as defined by the XML standards from W3C.

Specification text
XML Element Name:SpecificationText
Parent Element:InspectionPlanItemFields
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 "SOLLTEXT")
                    

Table entry no. 23
XML Element Name:SpecificationCode
Parent Element:InspectionPlanItemFields
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 "CDSPEZ")
                    

Table entry no. 24
XML Element Name:InspectionLocationCode
Parent Element:InspectionPlanItemFields
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 "CDPRPLATZ")
                    

Table entry no. 25
XML Element Name:InspectionEquipmentCode
Parent Element:InspectionPlanItemFields
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 "CDPRMITTEL")
                    

Texts ABEA ###VIEWLET_OTX_POSITIONTEXT###
XML Element Name:ItemText
Parent Element:InspectionPlanItem
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Standard texts, product texts, assembly texts, header, footer and item texts, general texts, tables

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

                

Text no.
XML Element Name:TextNumber
Parent Element:ItemTextFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   4Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
if header, footer, item or pruduct text
0-9
if work flow text
WA_BEREICH:
0   General
1   Sales
2   Purchase
3   Stock
4   Production
7   Misc. documents sales
8   Misc. documents purchasing
9   Misc. documents base data
(The internal field ID for this element is "TEXT_NR")

XML Element Name:HtmlText
Parent Element:ItemTextFields
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 "HTML_TEXT")
                    

Texts ABEA ###VIEWLET_OTX_KOPF_KOPFTEXT###
XML Element Name:HeaderText
Parent Element:InspectionPlanHeader
Field Type:ID
Action Type:Import und Export
Field Length:   -Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Standard texts, product texts, assembly texts, header, footer and item texts, general texts, tables

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

                

Text type
XML Element Name:TextType
Parent Element:HeaderTextFields
Field Type:Text
Action Type:Import und Export
Field Length:   2Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Text type within the text section
Possible values:
CD   Table codes
ST   Standard text (text element) 
VT   Variant text
KT   Header text
FT   Footer text
PT   Item text
BT   Assembly text
PV   Product text sales
PE   Product text purchasing
WF  Workflow text
GF   General footer text
GK  General header text
BN  User key text
CX  Charges text
SX   Serial no text
FL   Invoice text supplier
FM  Invoice text manual stock entries
FS   Invoice text carrier
SH  Assemly list header
SP   Assembly list item / Spezifikationstext bei QS
KK   Calculation
KZ   Calculation line
DK  Dimension combination
DT  Dimension
(The internal field ID for this element is "TEXT_TYP")

Document type
XML Element Name:DocumentType
Parent Element:HeaderTextFields
Field Type:Nummer
Action Type:Import und Export
Field Length:   8Decimal Places:   0Mandatory Field:   NoRevision:   0Ascii ID :   -
Description:
Documents for which the text is defined
Possible values:
- BEREICH Sales: Doc Nr.
- BEREICH Purchase Doc Nr.
(The internal field ID for this element is "DOK_TYP")

XML Element Name:HtmlHeaderText
Parent Element:HeaderTextFields
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 "HTML_KOPFTEXT")