Message Mapping:

Namespace: http://roche.com/rd/GL/PA/PRI/DWH_IF002-GL/Product/10


User defined functions

getMessageID

substringRight

checkNoDataSign

substringLeft

substringMid

getMappedValue

concat3

getReceiverService

checkInteger

getValueByQualifier

Mapping

Target fieldMapping ruleSource field
/ns0:JDBCStoreProduct
  • 1:1
  • /ZM80_ALE_MATMAS_CLARIFY_EXT
    /ns0:JDBCStoreProduct/InsertProduct
  • 1:1
  • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC
    /ns0:JDBCStoreProduct/InsertProduct/Product/@action
    • "INSERT"
    /ns0:JDBCStoreProduct/InsertProduct/Product/table
    • "IMP_INC_PRODUCTS_CLARIFY_INTERFACE"
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/EXCHANGEID
    • substringRight
      • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/EDI_DC40/SERIAL
      • "14"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/EDI_DC40/SERIAL
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/CBISWFLID
    • getMessageID
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/CBISSTATUS
    • "12"
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/CBISLASTCHANGE
    • "getdate()"
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/CBISLASTCHANGE/@hasQuot
    • "NO"
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/MATNR
    • substringRight
      • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MATNR
      • "11"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MATNR
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/ARTIKEL_TEXT
    • removeContexts
      • checkNoDataSign
        • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MAKTM/MAKTX
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MAKTM/MAKTX
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/PART_STATUS
    • IF
      • and
        • exists
          • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM
        • stringEquals
          • getMappedValue
            • getReceiverService
            • "ZS48Config"
            • "Config_Key"
            • "Material_Main_SalesOrg"
            • "Config_Value"
            • "#_ERR_#"
          • mapWithDefault
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VKORG
    • THEN
      • substringLeft
        • getMappedValue
          • getReceiverService
          • "ZS48PartSt"
          • "SGeneralStatus;SSpecificStatus;SSpecDistStatus"
          • concat3
            • mapWithDefault
              • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MSTAE
            • mapWithDefault
              • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/MMSTA
            • mapWithDefault
              • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VMSTA
            • ";"
          • "CPartStatus"
          • getMappedValue
            • getReceiverService
            • "ZS48PartSt"
            • "SGeneralStatus;SSpecificStatus;SSpecDistStatus"
            • "*;*;*"
            • "CPartStatus"
            • "#_ERR_#"
        • "25"
    • ELSE
      • IF
        • stringEquals
          • getMappedValue
            • getReceiverService
            • "ZS48PartMPTyp"
            • "SMatNr"
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MATNR
            • "CPartType"
            • getMappedValue
              • getReceiverService
              • "ZS48PartTyp"
              • "SPartTypeCode"
              • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
              • "CPartType"
              • getMappedValue
                • getReceiverService
                • "ZS48PartTyp"
                • "SPartTypeCode"
                • "*"
                • "CPartType"
                • "#_ERR_#"
          • "Unknown"
      • THEN
        • "Inactive"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MSTAE/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/MMSTA/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VMSTA/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VKORG/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MATNR/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/DOMAINNAME
    • substringLeft
      • getMappedValue
        • getReceiverService
        • "ZS48PartDomain"
        • "CPartType"
        • getMappedValue
          • getReceiverService
          • "ZS48PartMPTyp"
          • "SMatNr"
          • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MATNR
          • "CPartType"
          • getMappedValue
            • getReceiverService
            • "ZS48PartTyp"
            • "SPartTypeCode;SSERNP"
            • concat
              • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
              • mapWithDefault
                • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/SERNP
            • "CPartType"
            • getMappedValue
              • getReceiverService
              • "ZS48PartTyp"
              • "SPartTypeCode;SSERNP"
              • concat
                • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
                • ""
              • "CPartType"
              • getMappedValue
                • getReceiverService
                • "ZS48PartTyp"
                • "SPartTypeCode"
                • "*"
                • "CPartType"
                • "/"
        • "CDomain"
        • "/"
      • "40"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MATNR/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/SERNP/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/SUBSTITUTION
    • substringRight
      • checkNoDataSign
        • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_REPLACED_BY
      • "11"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_REPLACED_BY
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/BRUTTO_GEWICHT
    • checkNoDataSign
      • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/BRGEW
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/BRGEW
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/EXTERNEHERSTELLNR
    • substringLeft
      • checkNoDataSign
        • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MFRPN
      • "25"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MFRPN
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/STATUS
    • IF
      • or
        • stringEquals
          • mapWithDefault
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VMSTA
          • ""
        • or
          • stringEquals
            • ""
            • mapWithDefault
              • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MSTAE
          • stringEquals
            • mapWithDefault
              • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/MMSTA
            • ""
    • THEN
      • getMappedValue
        • getReceiverService
        • "ZS48PartSt"
        • "SGeneralStatus;SSpecificStatus;SSpecDistStatus"
        • "*;*;*"
        • "CProductStatus"
        • "#_ERR_#"
    • ELSE
      • getMappedValue
        • getReceiverService
        • "ZS48PartSt"
        • "SGeneralStatus;SSpecificStatus;SSpecDistStatus"
        • concat3
          • mapWithDefault
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MSTAE
          • mapWithDefault
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/MMSTA
          • mapWithDefault
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VMSTA
          • ";"
        • "CProductStatus"
        • getMappedValue
          • getReceiverService
          • "ZS48PartSt"
          • "SGeneralStatus;SSpecificStatus;SSpecDistStatus"
          • "*;*;*"
          • "CProductStatus"
          • "#_ERR_#"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VMSTA/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MSTAE/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/MMSTA/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MSTAE/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/MMSTA/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VMSTA
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/LOT_REQUIRED
    • removeContexts
      • IF
        • stringEquals
          • mapWithDefault
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/XCHPF
          • "X"
      • THEN
        • "1"
      • ELSE
        • "0"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/XCHPF
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/MATERIALKLASSE
  • 1:1
  • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MATKL
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/REPAIR_TYPE
    • removeContexts
      • IF
        • stringEquals
          • mapWithDefault
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
          • "SR"
      • THEN
        • "Repairable"
      • ELSE
        • "Expendable"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/PART_TYPE
    • getMappedValue
      • getReceiverService
      • "ZS48PartMPTyp"
      • "SMatNr"
      • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MATNR
      • "CPartType"
      • getMappedValue
        • getReceiverService
        • "ZS48PartTyp"
        • "SPartTypeCode;SSERNP"
        • concat
          • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
          • mapWithDefault
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/SERNP
        • "CPartType"
        • getMappedValue
          • getReceiverService
          • "ZS48PartTyp"
          • "SPartTypeCode;SSERNP"
          • concat
            • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
            • ""
          • "CPartType"
          • getMappedValue
            • getReceiverService
            • "ZS48PartTyp"
            • "SPartTypeCode"
            • "*"
            • "CPartType"
            • "/"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MATNR/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MARCM/SERNP/ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PRODUCT_CATEGORY
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/WARRANTY
    • removeContexts
      • IF
        • stringEquals
          • substringLeft
            • mapWithDefault
              • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_WARRANTY_INFO
            • "1"
          • "W"
      • THEN
        • "1"
      • ELSE
        • "0"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_WARRANTY_INFO
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/RETURN_PART_MANDATORY
    • removeContexts
      • IF
        • stringEquals
          • substringMid
            • mapWithDefault
              • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_WARRANTY_INFO
            • "1"
            • "1"
          • "R"
      • THEN
        • "1"
      • ELSE
        • "0"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_WARRANTY_INFO
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/DELIVERY_QUANTITY
    • substringLeft
      • removeContexts
        • checkNoDataSign
          • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PACKAGE_SIZE
      • "11"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_PACKAGE_SIZE
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/STOCK_CATEGORY
    • checkNoDataSign
      • substringLeft
        • getMappedValue
          • getReceiverService
          • "ZS48PartSC"
          • "SStockCatCode"
          • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_STOCK_CATEGORY
          • "CStockCatText"
          • "/"
        • "50"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/Z1M80_ALE_DMS_DATA/DMS_STOCK_CATEGORY
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/MENGENEINHEIT
    • checkNoDataSign
      • getMappedValue
        • getReceiverService
        • "ZS48PartISO"
        • "SISOCode"
        • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MEINS
        • "CCode"
        • "/"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/MEINS
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/GEWICHTSEINHEIT
    • checkNoDataSign
      • getMappedValue
        • getReceiverService
        • "ZS48PartISO"
        • "SISOCode"
        • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/GEWEI
        • "CCode"
        • "/"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/GEWEI
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/LITERATURE
    • "0"
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/Purchase_Unit
    • checkNoDataSign
      • getMappedValue
        • getReceiverService
        • "ZS48PartISO"
        • "SISOCode"
        • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/BSTME
        • "CCode"
        • "/"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/BSTME
    /ns0:JDBCStoreProduct/InsertProduct/Product/access/Sales_Unit
    • checkNoDataSign
      • getMappedValue
        • getReceiverService
        • "ZS48PartISO"
        • "SISOCode"
        • /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VRKME
        • "CCode"
        • "/"
    /ZM80_ALE_MATMAS_CLARIFY_EXT/IDOC/E1MARAM/E1MVKEM/VRKME