Integrating Integrators – BizTalk, Windows Azure, Windows Workflow, and Beyond

Passing dummy inputs to one record in Maps

BizTalk 2009

This group is for all content related to BizTalk Server 2009. This includes a forum, samples, and videos. Most of the content here also applies to other versions of BizTalk beyond 2009.

Passing dummy inputs to one record in Maps

Not Answered This question is not answered

We have 2 records in destrination schemas, one is product record and the other is productcountry. Product record is related to USA and productcountry record is related to Chile

Business wants to process ‘Products country’ related to Chile. Currently we have only ‘Products’ for USA in place. This change must be in such a way that it satisfies the following scenarios:

1. If Business wants to process just USA– completed

2. If Business wants to process US & Chile – completed

3. If Business wants to process Just Chile data(product COuntry) – this has to be implemented (assuming the same and 2nd scenario but we need to pass dummy inputs to USA( I mean to product record) – so that the XML is intact)

Schema must not be changed. In Map, I need to change to ensure that the above scenarios are met. We have already completed 1 and 2 nd scenerios. But I dont have any idea how to do the scenerio 3. Please help me

Edit
All Replies
  • Hi,

    Follow the below link it will give some idea

    stackoverflow.com/.../how-to-set-a-default-value-to-an-destination-schema-element-in-biztalk-map

    Purnachandra..Yes

    • Top 25 Contributor
  • Can you post the input and expected output xml for scenario 3?.

    I think you achive it by using Logical Existence/Value mapping functoid.

    Edit
  • Can you post the input and expected output xml for scenario 3?.

    I think you achive it by using Logical Existence/Value mapping functoid.

    Regards,
    NISHIL
    MCT,MCTS | Freelance BizTalk Consultant.
    biztalkconnect.blogspot.com

    • Top 10 Contributor
  • INput XML:

    -<Receive xmlns="microsoft.lobservices.sap/.../Receive">-<idocData>-<EDI_DC40 xmlns="microsoft.lobservices.sap/.../702"><TABNAM xmlns="microsoft.lobservices.sap/.../TABNAM><MANDT xmlns="microsoft.lobservices.sap/.../MANDT><DOCNUM xmlns="microsoft.lobservices.sap/.../DOCNUM><DOCREL xmlns="microsoft.lobservices.sap/.../DOCREL><STATUS xmlns="microsoft.lobservices.sap/.../STATUS><DIRECT xmlns="microsoft.lobservices.sap/.../DIRECT><OUTMOD xmlns="microsoft.lobservices.sap/.../OUTMOD><EXPRSS xmlns="microsoft.lobservices.sap/.../><TEST xmlns="microsoft.lobservices.sap/.../><IDOCTYP xmlns="microsoft.lobservices.sap/.../IDOCTYP><CIMTYP xmlns="microsoft.lobservices.sap/.../CIMTYP><MESTYP xmlns="microsoft.lobservices.sap/.../MESTYP><MESCOD xmlns="microsoft.lobservices.sap/.../><MESFCT xmlns="microsoft.lobservices.sap/.../><STD xmlns="microsoft.lobservices.sap/.../><STDVRS xmlns="microsoft.lobservices.sap/.../><STDMES xmlns="microsoft.lobservices.sap/.../><SNDPOR xmlns="microsoft.lobservices.sap/.../SNDPOR><SNDPRT xmlns="microsoft.lobservices.sap/.../SNDPRT><SNDPFC xmlns="microsoft.lobservices.sap/.../><SNDPRN xmlns="microsoft.lobservices.sap/.../SNDPRN><SNDSAD xmlns="microsoft.lobservices.sap/.../><SNDLAD xmlns="microsoft.lobservices.sap/.../><RCVPOR xmlns="microsoft.lobservices.sap/.../RCVPOR><RCVPRT xmlns="microsoft.lobservices.sap/.../RCVPRT><RCVPFC xmlns="microsoft.lobservices.sap/.../><RCVPRN xmlns="microsoft.lobservices.sap/.../RCVPRN><RCVSAD xmlns="microsoft.lobservices.sap/.../><RCVLAD xmlns="microsoft.lobservices.sap/.../><CREDAT xmlns="microsoft.lobservices.sap/.../CREDAT><CRETIM xmlns="microsoft.lobservices.sap/.../CRETIM><REFINT xmlns="microsoft.lobservices.sap/.../><REFGRP xmlns="microsoft.lobservices.sap/.../><REFMES xmlns="microsoft.lobservices.sap/.../><ARCKEY xmlns="microsoft.lobservices.sap/.../><SERIAL xmlns="microsoft.lobservices.sap/.../EDI_DC40>-<E2MARAM007GRP xmlns="microsoft.lobservices.sap/.../><MAKTX>CRO SRV GASKET NICKEL</MAKTX><SPRAS_ISO/><SEGMENTPAD/></E2MAKTM001>-<E2MAKTM001><DATAHEADERCOLUMN_SEGNAM>E2MAKTM001</DATAHEADERCOLUMN_SEGNAM><DATAHEADERCOLUMN_MANDT>120</DATAHEADERCOLUMN_MANDT><DATAHEADERCOLUMN_DOCNUM>0000000000433844</DATAHEADERCOLUMN_DOCNUM><DATAHEADERCOLUMN_SEGNUM>000007</DATAHEADERCOLUMN_SEGNUM><DATAHEADERCOLUMN_PSGNUM>000001</DATAHEADERCOLUMN_PSGNUM><DATAHEADERCOLUMN_HLEVEL>03</DATAHEADERCOLUMN_HLEVEL><MSGFN/><SPRAS/><MAKTX>1X2 & 1.5X2 25-275 PSIG SOFT GOODS</MAKTX><SPRAS_ISO/><SEGMENTPAD/></E2MAKTM001>-<E2MARCM005GRP>-<E2MARCM005><DATAHEADERCOLUMN_SEGNAM>E2MARCM005</DATAHEADERCOLUMN_SEGNAM><DATAHEADERCOLUMN_MANDT>120</DATAHEADERCOLUMN_MANDT><DATAHEADERCOLUMN_DOCNUM>0000000000433844</DATAHEADERCOLUMN_DOCNUM><DATAHEADERCOLUMN_SEGNUM>000008</DATAHEADERCOLUMN_SEGNUM><DATAHEADERCOLUMN_PSGNUM>000001</DATAHEADERCOLUMN_PSGNUM><DATAHEADERCOLUMN_HLEVEL>03</DATAHEADERCOLUMN_HLEVEL><MSGFN/><WERKS>1201</WERKS><PSTAT/><LVORM/><BWTTY/><MAABC/><KZKRI/><EKGRP/><AUSME/><DISPR/><DISMM/><DISPO/><PLIFZ/><WEBAZ/><PERKZ/><AUSSS/><DISLS/><BESKZ/><SOBSL/><MINBE/><EISBE/><BSTMI/><BSTMA/><BSTFE/><BSTRF/><MABST/><LOSFX/><SBDKZ/><LAGPR/><ALTSL/><KZAUS/><AUSDT/><NFMAT/><KZBED/><MISKZ/><FHORI/><PFREI/><FFREI/><RGEKZ/><FEVOR/><BEARZ/><RUEZT/><TRANZ/><BASMG/><DZEIT/><MAXLZ/><LZEIH/><KZPRO/><GPMKZ/><UEETO/><UEETK/><UNETO/><WZEIT/><ATPKZ/><VZUSL/><HERBL/><INSMK/><SSQSS/><KZDKZ/><UMLMC/><LADGR/><XCHPF/><USEQU/><LGRAD/><AUFTL/><PLVAR/><OTYPE/><OBJID/><MTVFP/><PERIV/><KZKFK/><VRVEZ/><VBAMG/><VBEAZ/><LIZYK/><BWSCL/><KAUTB/><KORDB/><STAWN>8503.0090</STAWN><HERKL>IN</HERKL><HERKR>CL</HERKR><EXPME/><MTVER/><PRCTR/><TRAME/><MRPPP/><SAUFT/><FXHOR/><VRMOD/><VINT1/><VINT2/><STLAL/><STLAN/><PLNNR/><APLAL/><LOSGR/><SOBSK/><FRTME/><LGPRO/><DISGR/><KAUSF/><QZGTP/><TAKZT/><RWPRO/><COPAM/><ABCIN/><AWSLS/><SERNP/><STDPD/><SFEPR/><XMCNG/><QSSYS/><LFRHY/><RDPRF/><VRBMT/><VRBWK/><VRBDT/><VRBFK/><AUTRU/><PREFE/><PRENC/><PRENO/><PREND/><PRENE/><PRENG/><ITARK/><PRFRQ/><KZKUP/><STRGR/><LGFSB/><SCHGT/><CCFIX/><EPRIO/><QMATA/><PLNTY/><MMSTA/><SFCPF/><SHFLG/><SHZET/><MDACH/><KZECH/><MMSTD/><MFRGR/><FVIDK/><INDUS/><MOWNR/><MOGRU/><CASNR/><GPNUM/><STEUC/><FABKZ/><MATGR/><LOGGR/><VSPVB/><DPLFS/><DPLPU/><DPLHO/><MINLS/><MAXLS/><FIXLS/><LTINC/><COMPL/><CONVT/><FPRFM/><SHPRO/><FXPRU/><KZPSP/><OCMPF/><APOKZ/><AHDIS/><EISLO/><NCOST/><MEGRU/><ROTATION_DATE/><UCHKZ/><UCMAT/><IUID_RELEVANT/><IUID_TYPE/><UID_IEA/><SEGMENTPAD/></E2MARCM005>-<E2MARDM001><DATAHEADERCOLUMN_SEGNAM>E2MARDM001</DATAHEADERCOLUMN_SEGNAM><DATAHEADERCOLUMN_MANDT>120</DATAHEADERCOLUMN_MANDT><DATAHEADERCOLUMN_DOCNUM>0000000000433844</DATAHEADERCOLUMN_DOCNUM><DATAHEADERCOLUMN_SEGNUM>000009</DATAHEADERCOLUMN_SEGNUM><DATAHEADERCOLUMN_PSGNUM>000008</DATAHEADERCOLUMN_PSGNUM><DATAHEADERCOLUMN_HLEVEL>04</DATAHEADERCOLUMN_HLEVEL><MSGFN>005</MSGFN><LGORT>0100</LGORT><PSTAT>DL</PSTAT><LVORM>/</LVORM><DISKZ>/</DISKZ><LSOBS>/</LSOBS><LMINB>/</LMINB><LBSTF>/</LBSTF><HERKL/><EXPPG>/</EXPPG><EXVER>/</EXVER><LGPBE>/</LGPBE><PRCTL>/</PRCTL><LWMKB>/</LWMKB><BSKRF>/</BSKRF><SEGMENTPAD/></E2MARDM001></E2MARCM005GRP>-<E2MVKEM002><DATAHEADERCOLUMN_SEGNAM>E2MVKEM002</DATAHEADERCOLUMN_SEGNAM><DATAHEADERCOLUMN_MANDT>120</DATAHEADERCOLUMN_MANDT><DATAHEADERCOLUMN_DOCNUM>0000000000433844</DATAHEADERCOLUMN_DOCNUM><DATAHEADERCOLUMN_SEGNUM>000010</DATAHEADERCOLUMN_SEGNUM><DATAHEADERCOLUMN_PSGNUM>000001</DATAHEADERCOLUMN_PSGNUM><DATAHEADERCOLUMN_HLEVEL>03</DATAHEADERCOLUMN_HLEVEL><MSGFN/><VKORG/><VTWEG/><LVORM/><VERSG/><BONUS/><PROVG/><SKTOF/><VMSTA/><VMSTD/><AUMNG/><LFMNG/><EFMNG/><SCMNG/><SCHME/><VRKME/><MTPOS/><DWERK>1201</DWERK><PRODH/><PMATN/><KONDM/><KTGRM/><MVGR1/><MVGR2/><MVGR3/><MVGR4/><MVGR5/><SSTUF/><PFLKS/><LSTFL/><LSTVZ/><LSTAK/><PRAT1/><PRAT2/><PRAT3/><PRAT4/><PRAT5/><PRAT6/><PRAT7/><PRAT8/><PRAT9/><PRATA/><VAVME/><RDPRF/><MEGRU/><PMATN_EXTERNAL/><PMATN_VERSION/><PMATN_GUID/><SEGMENTPAD/></E2MVKEM002>-<E2MVKEM002><DATAHEADERCOLUMN_SEGNAM>E2MVKEM002</DATAHEADERCOLUMN_SEGNAM><DATAHEADERCOLUMN_MANDT>120</DATAHEADERCOLUMN_MANDT><DATAHEADERCOLUMN_DOCNUM>0000000000433844</DATAHEADERCOLUMN_DOCNUM><DATAHEADERCOLUMN_SEGNUM>000011</DATAHEADERCOLUMN_SEGNUM><DATAHEADERCOLUMN_PSGNUM>000001</DATAHEADERCOLUMN_PSGNUM><DATAHEADERCOLUMN_HLEVEL>03</DATAHEADERCOLUMN_HLEVEL><MSGFN/><VKORG/><VTWEG/><LVORM/><VERSG/><BONUS/><PROVG/><SKTOF/><VMSTA/><VMSTD/><AUMNG/><LFMNG/><EFMNG/><SCMNG/><SCHME/><VRKME/><MTPOS/><DWERK/><PRODH/><PMATN/><KONDM/><KTGRM/><MVGR1/><MVGR2/><MVGR3/><MVGR4/><MVGR5/><SSTUF/><PFLKS/><LSTFL/><LSTVZ/><LSTAK/><PRAT1/><PRAT2/><PRAT3/><PRAT4/><PRAT5/><PRAT6/><PRAT7/><PRAT8/><PRAT9/><PRATA/><VAVME/><RDPRF/><MEGRU/><PMATN_EXTERNAL/><PMATN_VERSION/><PMATN_GUID/><SEGMENTPAD/></E2MVKEM002>-<E2MVKEM002><DATAHEADERCOLUMN_SEGNAM>E2MVKEM002</DATAHEADERCOLUMN_SEGNAM><DATAHEADERCOLUMN_MANDT>120</DATAHEADERCOLUMN_MANDT><DATAHEADERCOLUMN_DOCNUM>0000000000433844</DATAHEADERCOLUMN_DOCNUM><DATAHEADERCOLUMN_SEGNUM>000012</DATAHEADERCOLUMN_SEGNUM><DATAHEADERCOLUMN_PSGNUM>000001</DATAHEADERCOLUMN_PSGNUM><DATAHEADERCOLUMN_HLEVEL>03</DATAHEADERCOLUMN_HLEVEL><MSGFN/><VKORG/><VTWEG/><LVORM/><VERSG/><BONUS/><PROVG/><SKTOF/><VMSTA/><VMSTD/><AUMNG/><LFMNG/><EFMNG/><SCMNG/><SCHME/><VRKME/><MTPOS/><DWERK/><PRODH/><PMATN/><KONDM/><KTGRM/><MVGR1/><MVGR2/><MVGR3/><MVGR4/><MVGR5/><SSTUF/><PFLKS/><LSTFL/><LSTVZ/><LSTAK/><PRAT1/><PRAT2/><PRAT3/><PRAT4/><PRAT5/><PRAT6/><PRAT7/><PRAT8/><PRAT9/><PRATA/><VAVME/><RDPRF/><MEGRU/><PMATN_EXTERNAL/><PMATN_VERSION/><PMATN_GUID/><SEGMENTPAD/></E2MVKEM002>-<E2MVKEM002><DATAHEADERCOLUMN_SEGNAM>E2MVKEM002</DATAHEADERCOLUMN_SEGNAM><DATAHEADERCOLUMN_MANDT>120</DATAHEADERCOLUMN_MANDT><DATAHEADERCOLUMN_DOCNUM>0000000000433844</DATAHEADERCOLUMN_DOCNUM><DATAHEADERCOLUMN_SEGNUM>000013</DATAHEADERCOLUMN_SEGNUM><DATAHEADERCOLUMN_PSGNUM>000001</DATAHEADERCOLUMN_PSGNUM><DATAHEADERCOLUMN_HLEVEL>03</DATAHEADERCOLUMN_HLEVEL><MSGFN/><VKORG/><VTWEG/><LVORM/><VERSG/><BONUS/><PROVG/><SKTOF/><VMSTA/><VMSTD/><AUMNG/><LFMNG/><EFMNG/><SCMNG/><SCHME/><VRKME/><MTPOS/><DWERK/><PRODH/><PMATN/><KONDM/><KTGRM/><MVGR1/><MVGR2/><MVGR3/><MVGR4/><MVGR5/><SSTUF/><PFLKS/><LSTFL/><LSTVZ/><LSTAK/><PRAT1/><PRAT2/><PRAT3/><PRAT4/><PRAT5/><PRAT6/><PRAT7/><PRAT8/><PRAT9/><PRATA/><VAVME/><RDPRF/><MEGRU/><PMATN_EXTERNAL/><PMATN_VERSION/><PMATN_GUID/><SEGMENTPAD/></E2MVKEM002>-<E2MVKEM002><DATAHEADERCOLUMN_SEGNAM>E2MVKEM002</DATAHEADERCOLUMN_SEGNAM><DATAHEADERCOLUMN_MANDT>120</DATAHEADERCOLUMN_MANDT><DATAHEADERCOLUMN_DOCNUM>0000000000433844</DATAHEADERCOLUMN_DOCNUM><DATAHEADERCOLUMN_SEGNUM>000014</DATAHEADERCOLUMN_SEGNUM><DATAHEADERCOLUMN_PSGNUM>000001</DATAHEADERCOLUMN_PSGNUM><DATAHEADERCOLUMN_HLEVEL>03</DATAHEADERCOLUMN_HLEVEL><MSGFN/><VKORG/><VTWEG/><LVORM/><VERSG/><BONUS/><PROVG/><SKTOF/><VMSTA/><VMSTD/><AUMNG/><LFMNG/><EFMNG/><SCMNG/><SCHME/><VRKME/><MTPOS/><DWERK/><PRODH/><PMATN/><KONDM/><KTGRM/><MVGR1/><MVGR2/><MVGR3/><MVGR4/><MVGR5/><SSTUF/><PFLKS/><LSTFL/><LSTVZ/><LSTAK/><PRAT1/><PRAT2/><PRAT3/><PRAT4/><PRAT5/><PRAT6/><PRAT7/><PRAT8/><PRAT9/><PRATA/><VAVME/><RDPRF/><MEGRU/><PMATN_EXTERNAL/><PMATN_VERSION/><PMATN_GUID/><SEGMENTPAD/></E2MVKEM002></E2MARAM007GRP></idocData></Receive>

    Edit
  • Output XML:

    productRequest> <sender>SAPGT</sender> <receiver>MDI</receiver> <messageId>1000000233_0000000000433844-d19f25</messageId>

    -<product> <action>U</action> <partId>1000000233</partId> <partDescription>CRO SRV GASKET NICKEL</partDescription> <unit/> <netWeight/> <grossWeight/> <scheduleB/> <notes/> <pcoo1/> <eccnum/> <htsId/> <siteId/> <flexCharacterAttr1/> <flexCharacterAttr2/> <flexCharacterAttr3/> <flexCharacterAttr4/> <flexCharacterAttr5/> <flexCharacterAttr9/> <sourceSystem/> <docDisplay/> <exportValidation/> <importValidation/> -<productCountry> <action>U</action> <countryCode>CL</countryCode> <partDescription>CRO SRV GASKET NICKEL</partDescription> <countryOfOrigin>IN</countryOfOrigin> <notes/> <unitOfMeasure1>EA</unitOfMeasure1> <flexCharacterAttr1>HALB</flexCharacterAttr1> <flexCharacterAttr2>EA</flexCharacterAttr2> <flexCharacterAttr3>1000000233</flexCharacterAttr3> <flexCharacterAttr4/> <flexCharacterAttr5>BFVRAWRAWRAW</flexCharacterAttr5> <flexCharacterAttr9>1000000233</flexCharacterAttr9> <sourceSystem>SAPED1</sourceSystem> <eccnum/> <hts>85030090</hts> </productCountry> </product> </productRequest>

    CountryCode suggests CL (means its Chile) so we need to pass dummy values to <Product>

    Edit
  • Need to look at the project as how have you implemented the mapping for first 2 scenarios.

    Have you created 3 different maps for 3 scenarios or a single map to handle all scenarios?

    How it is decided if its scenario 1 or 2 or 3 from the input XML?

    Regards,
    NISHIL
    MCT,MCTS | Freelance BizTalk Consultant.
    biztalkconnect.blogspot.com

    • Top 10 Contributor
Page 1 of 1 (7 items)