Mapping Help

[Former Member]

Hi Experts,

I am doing an interface(Idoc to file) where I am sending work orders to a file.The criteria here is to pull only work orders which have level equal to 5 and STATUS equal to I0046.To be more clear,there will be multiple E1BP2054_MASTERDATA_ALE nodes which will have LEVEL 1,2....5.So I need to pick only level 5.There will be muliple E1BP2054_OBJECTSTATUS_ALE nodes and will have to pick only STATUS=I0046.So both these conditions need to be met for each Idoc.I have done the mapping for the LEVEL which is shown in the screen shot,but I need to know how to add STATUS field to it.I have tried some ways but no luck.Please help me.Let me know if you need more info.Plz find the screen shot attached.

http://www.flickr.com/photos/25513325@N05/2468754794/sizes/o/

Thanks

[Former Member]

Hi,

1) Use 2 Equals functions from Text category.

2) one for level equal to 5 and 2nd one for STATUS equal to I0046.

3) whatever u did for level 5 same do for STATUS after that use AND function.

4) Put context of both LEVEL and STATUS on PROJECT01.

5) If you want to display particular data then use IfWithOutElse then use SplitByValue.

6) If you want just create node then use CreateIf Function as u used earlier. then use RemoveContext.

Implement either step 5 or 6 not both.

Hope this will help you.

Regards,

Rohit.

Reward points if helpful.

[Former Member]

Thanks for your replies guys,I have done the mapping as you said,but only E1BP2054_MASTERDATA_ALE node is being created in the target with the fields .The node E1BP2054_OBJECTSTATUS_ALE does not appear.Let me know if you have any questions.

http://www.flickr.com/photos/25513325@N05/2472155148/sizes/o/

Source msg

<?xml version="1.0" encoding="UTF-8"?>

<PROJECT01>

<IDOC BEGIN="">

<EDI_DC40 SEGMENT="">

<TABNAM/>

<MANDT/>

<DOCNUM/>

<DOCREL/>

<STATUS/>

<DIRECT/>

<OUTMOD/>

<EXPRSS/>

<TEST/>

<IDOCTYP/>

<CIMTYP/>

<MESTYP/>

<MESCOD/>

<MESFCT/>

<STD/>

<STDVRS/>

<STDMES/>

<SNDPOR/>

<SNDPRT/>

<SNDPFC/>

<SNDPRN/>

<SNDSAD/>

<SNDLAD/>

<RCVPOR/>

<RCVPRT/>

<RCVPFC/>

<RCVPRN/>

<RCVSAD/>

<RCVLAD/>

<CREDAT/>

<CRETIM/>

<REFINT/>

<REFGRP/>

<REFMES/>

<ARCKEY/>

<SERIAL/>

</EDI_DC40>

<E1BP2054_PROJDEFINITION SEGMENT="">

<PROJECT_DEFINITION/>

<DESCRIPTION/>

<CREATED_BY/>

<CREATE_DATE/>

<CHANGED_BY/>

<CHANGE_DATE/>

<MASK_ID/>

<RESPONSIBLE_NO/>

<APPLICANT_NO/>

<COMP_CODE/>

<BUS_AREA/>

<CONTROLLING_AREA/>

<PROFIT_CTR/>

<PROJECT_CURRENCY/>

<PROJECT_CURRENCY_ISO/>

<NETWORK_ASSIGNMENT/>

<START/>

<FINISH/>

<PLANT/>

<CALENDAR/>

<PLAN_BASIC/>

<PLAN_FCST/>

<TIME_UNIT/>

<TIME_UNIT_ISO/>

<NETWORK_PROFILE/>

<PROJECT_PROFILE/>

<BUDGET_PROFILE/>

<AUTHKEY_PROJECT/>

<AUTHKEY_WBS/>

<AUTHKEY_COST/>

<AUTHKEY_BUDGET/>

<PROJECT_STOCK/>

<OBJECTCLASS/>

<STATISTICAL/>

<TAXJURCODE/>

<INTEREST_PROFILE/>

<WBS_SCHED_PROFILE/>

<INVEST_PROFILE/>

<CSH_BDGT_PROFILE/>

<PLAN_PROFILE/>

<INTEGRATED_PLANNING/>

<DELETION_FLAG/>

<VALUATION_OF_STOCK/>

<GROUPING_INDICATOR/>

<LOCATION/>

<LOGSYSTEM/>

<JOINT_VENTURE/>

<RECOVERY_IND/>

<EQUITY_TYPE/>

<JV_OBJECT_TYPE/>

<JV_JIB_CLASS/>

<JV_JIB_SUB_CLASS_A/>

<FUNC_AREA/>

</E1BP2054_PROJDEFINITION>

<E1BP2054_MASTERDATA_ALE SEGMENT="">

<WBS_ELEMENT>545454</WBS_ELEMENT>

<PROJECT_DEFINITION/>

<DESCRIPTION>trftrfrf</DESCRIPTION>

<SHORT_ID/>

<CREATED_BY/>

<CREATE_DATE>54545454</CREATE_DATE>

<CHANGED_BY/>

<CHANGE_DATE/>

<RESPONSIBLE_NO/>

<APPLICANT_NO/>

<COMP_CODE/>

<BUS_AREA/>

<CO_AREA/>

<PROFIT_CTR/>

<PROJ_TYPE/>

<LEVEL>5</LEVEL>

<PLANNING_INDICATOR/>

<ACCOUNTING_INDICATOR/>

<BILLING_INDICATOR/>

<NETWORK_ASSIGNMENT/>

<REQUEST_CO_AREA/>

<REQUEST_CCTR/>

<RESPONSIBLE_CO_AREA/>

<RESPONSIBLE_CCTR/>

<CALENDAR/>

<PRIORITY/>

<EQUIPMENT/>

<FUNCTIONAL_LOCATION/>

<CURRENCY/>

<CURRENCY_ISO/>

<PLANT>t5</PLANT>

<USER_FIELD_KEY/>

<USER_FIELD_CHAR20_1/>

<USER_FIELD_CHAR20_2/>

<USER_FIELD_CHAR10_1/>

<USER_FIELD_CHAR10_2/>

<USER_FIELD_QUAN1/>

<USER_FIELD_UNIT1/>

<USER_FIELD_UNIT1_ISO/>

<USER_FIELD_QUAN2/>

<USER_FIELD_UNIT2/>

<USER_FIELD_UNIT2_ISO/>

<USER_FIELD_CURR1/>

<USER_FIELD_CUKY1/>

<USER_FIELD_CUKY1_ISO/>

<USER_FIELD_CURR2/>

<USER_FIELD_CUKY2/>

<USER_FIELD_CUKY2_ISO/>

<USER_FIELD_DATE1/>

<USER_FIELD_DATE2/>

<USER_FIELD_FLAG1/>

<USER_FIELD_FLAG2/>

<OBJECTCLASS/>

<STATISTICAL/>

<TAXJURCODE/>

<INT_PROFILE/>

<INVEST_PROFILE/>

<CHANGE_NUMBER/>

<SUBPROJECT/>

<INTEGRATED_PLANNING/>

<DELETION_FLAG/>

<VALUATION_OF_STOCK/>

<CLOSE_TECH_DATE/>

<INV_REASON/>

<SCALE/>

<ENVIR_INVEST/>

<REQUEST_COMP_CODE/>

<GROUPING_WBS_ELEM/>

<LOGSYSTEM/>

<LOCATION/>

<JOINT_VENTURE/>

<RECOVERY_IND/>

<EQUITY_TYPE/>

<JV_OBJECT_TYPE/>

<JV_JIB_CLASS/>

<JV_JIB_SUB_CLASS_A/>

<FUNC_AREA/>

<PSPNR_LOGS/>

<WBS_CCTR_POSTED_ACTUAL/>

</E1BP2054_MASTERDATA_ALE>

<E1BP2054_MASTERDATA_ALE SEGMENT="">

<WBS_ELEMENT>545454</WBS_ELEMENT>

<PROJECT_DEFINITION/>

<DESCRIPTION>trftrfrf</DESCRIPTION>

<SHORT_ID/>

<CREATED_BY/>

<CREATE_DATE>54545454</CREATE_DATE>

<CHANGED_BY/>

<CHANGE_DATE/>

<RESPONSIBLE_NO/>

<APPLICANT_NO/>

<COMP_CODE/>

<BUS_AREA/>

<CO_AREA/>

<PROFIT_CTR/>

<PROJ_TYPE/>

<LEVEL>5</LEVEL>

<PLANNING_INDICATOR/>

<ACCOUNTING_INDICATOR/>

<BILLING_INDICATOR/>

<NETWORK_ASSIGNMENT/>

<REQUEST_CO_AREA/>

<REQUEST_CCTR/>

<RESPONSIBLE_CO_AREA/>

<RESPONSIBLE_CCTR/>

<CALENDAR/>

<PRIORITY/>

<EQUIPMENT/>

<FUNCTIONAL_LOCATION/>

<CURRENCY/>

<CURRENCY_ISO/>

<PLANT>t5</PLANT>

<USER_FIELD_KEY/>

<USER_FIELD_CHAR20_1/>

<USER_FIELD_CHAR20_2/>

<USER_FIELD_CHAR10_1/>

<USER_FIELD_CHAR10_2/>

<USER_FIELD_QUAN1/>

<USER_FIELD_UNIT1/>

<USER_FIELD_UNIT1_ISO/>

<USER_FIELD_QUAN2/>

<USER_FIELD_UNIT2/>

<USER_FIELD_UNIT2_ISO/>

<USER_FIELD_CURR1/>

<USER_FIELD_CUKY1/>

<USER_FIELD_CUKY1_ISO/>

<USER_FIELD_CURR2/>

<USER_FIELD_CUKY2/>

<USER_FIELD_CUKY2_ISO/>

<USER_FIELD_DATE1/>

<USER_FIELD_DATE2/>

<USER_FIELD_FLAG1/>

<USER_FIELD_FLAG2/>

<OBJECTCLASS/>

<STATISTICAL/>

<TAXJURCODE/>

<INT_PROFILE/>

<INVEST_PROFILE/>

<CHANGE_NUMBER/>

<SUBPROJECT/>

<INTEGRATED_PLANNING/>

<DELETION_FLAG/>

<VALUATION_OF_STOCK/>

<CLOSE_TECH_DATE/>

<INV_REASON/>

<SCALE/>

<ENVIR_INVEST/>

<REQUEST_COMP_CODE/>

<GROUPING_WBS_ELEM/>

<LOGSYSTEM/>

<LOCATION/>

<JOINT_VENTURE/>

<RECOVERY_IND/>

<EQUITY_TYPE/>

<JV_OBJECT_TYPE/>

<JV_JIB_CLASS/>

<JV_JIB_SUB_CLASS_A/>

<FUNC_AREA/>

<PSPNR_LOGS/>

<WBS_CCTR_POSTED_ACTUAL/>

</E1BP2054_MASTERDATA_ALE>

<E1BP_WBS_HIERARCHIE SEGMENT="">

<WBS_ELEMENT/>

<PROJECT_DEFINITION/>

<UP/>

<DOWN/>

<LEFT/>

<RIGHT/>

</E1BP_WBS_HIERARCHIE>

<E1BP2054_STATUSHEADER_ALE SEGMENT="">

<WBS_OBJECTID/>

<OBJECT_TYPE/>

<STATUS_PROFILE/>

</E1BP2054_STATUSHEADER_ALE>

<E1BP2054_OBJECTSTATUS_ALE SEGMENT="">

<WBS_OBJECTID/>

<OBJECT_TYPE/>

<STATUS>I0046</STATUS>

<INACTIVE/>

</E1BP2054_OBJECTSTATUS_ALE>

<E1BP2054_OBJECTSTATUS_ALE SEGMENT="">

<WBS_OBJECTID/>

<OBJECT_TYPE/>

<STATUS>I0047</STATUS>

<INACTIVE/>

</E1BP2054_OBJECTSTATUS_ALE>

</IDOC>

</PROJECT01>

[Former Member]

Hi,

If your target field is same for both structure and your logic also same for both structures then,

Duplicate the target field map both structures with same logic or make occrence of target field 0..unbounded now it is 1..1

Try this.

Regards,

Rohit.

Reward points if helpful.

[nisarkhan_n]

Expand the same logic and use the AND function which is checking both

LEVEL == 5 AND STATUS==I0046 then map result to createif & then to target......

in NODE wise:

check the status field==10046 whose output is send to AND along with the LEVEL = 5 and send the AND output to CreateIF