- This topic has 6 replies, 1 voice, and was last updated 5 years, 5 months ago by
.
-
Posts
-
-
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%ufeffBusiness
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
-
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
-
Can you post the input and expected output xml for scenario 3?.
I think you achive it by using Logical Existence/Value mapping functoid.
-
Can you post the input and expected output xml for scenario 3?.
I think you achive it by using Logical Existence/Value mapping functoid.
-
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>
-
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>
-
-
-
-
-
- The forum ‘BizTalk 2004 – BizTalk 2010’ is closed to new topics and replies.