Solved: Help in logic UDF in XI

Hello All,

Can you please help me to write the UDF for below logic.

in Material Master IDOC.

need to check MEINH value from E1MARMM segment and compare with VRKME from E1MVKEM, if both are equal pass corresponding GTIN_VARIANT.

if we dont find E1MVKEM segment in IDOC, then check value PAL is available in MEINH for any segment in E1MARMM and send corresponding GTIN_VARIANT

if we have multiple E1MVKEM then pick first segment to check the logic.

thanks

SAP Managed Tags:
SAP Process Integration

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

Accepted Solutions (1)

Hi Chinna,

Can you give us a screenshot of the source fields? We'd like to know their hierarchy and cardinality.

Regards,

Mark

You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.

Comment

IDOC

E1MARAM 1---999

E1MARMM 1---999

E1MVKEM 1---999

Hi Chinna,

Can you click the filter icon and then show us all the fields?

Regards,

Mark

Hi,

can you give any inputs how to write the UDF..

Hi Mark,

can you help me to write UDF for the logic.

The same logic i want to write UDF, only reason for UDF is i am not able to handle context using standard mapping.

DOC

E1MARAM 1---999

E1MARMM 1---999

E1MVKEM 1---999

Help in logic UDF in XI

Hi Chinna,

Which is the parent node for GTIN_VARIANT?

Regards,

Mark

Hello Mark,

GTIN_VARIANT will come under E1MARMM node.

Thanks

Hi Chinna,

Last, can you give us a sample input/output xml?

Regards,

Mark

Hello Mark,

Hope this will help me to get the UDF from you.

INPUT XML:

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

<_-AMS_-RUSX_MATMAS05>

<EDI_DC40 SEGMENT="1">

<IDOCTYP>MATMAS05</IDOCTYP>

<CIMTYP>/AMS/RUSX_MATMAS05</CIMTYP>

<MESTYP>/AMS/RUS_MATMAS</MESTYP>

<SNDPOR>SAPPR7</SNDPOR>

<RCVPOR>US_NPIVBSM</RCVPOR>

<RCVPRN>USENPIVBSM</RCVPRN>

</EDI_DC40>

<ERNAM>JOBRUN</ERNAM>

<PSTAT>KDEALBVQGSC</PSTAT>

<VPSTA>KDEALBVQGZXSC</VPSTA>

<MTPOS_MARA>NORM</MTPOS_MARA>

<GEWTO_NEW>0.0</GEWTO_NEW>

<VOLTO_NEW>0.0</VOLTO_NEW>

<SLED_BBD>B</SLED_BBD>

<GTIN_VARIANT>00</GTIN_VARIANT>

<_-AMS_-RUS_ZYAMARA2 SEGMENT="1">

<_-AMS_-YYCBR>C00001</_-AMS_-YYCBR>

<_-AMS_-YYRBR>R000036</_-AMS_-YYRBR>

<_-AMS_-YYDBR>D999999</_-AMS_-YYDBR>

<_-AMS_-YYBAI>9999</_-AMS_-YYBAI>

<_-AMS_-YYPTC>9999</_-AMS_-YYPTC>

<_-AMS_-YYAG5>BR</_-AMS_-YYAG5>

<_-AMS_-GTIN_VARIANT>00</_-AMS_-GTIN_VARIANT>

<_-AMS_-HUTYP>P01</_-AMS_-HUTYP>

<_-AMS_-MATSW>565.000</_-AMS_-MATSW>

<_-AMS_-UOMSW>KG</_-AMS_-UOMSW>

<_-AMS_-MATSDM>Y</_-AMS_-MATSDM>

<_-AMS_-YYIMSP_SHARED>S</_-AMS_-YYIMSP_SHARED>

<_-AMS_-IMNW>0.000</_-AMS_-IMNW>

<_-GLB_-SUBID>004700000030</_-GLB_-SUBID>

<Z_GDA_PRDAT>00000000</Z_GDA_PRDAT>

<Z_NUTRI_COMP_PRDAT>00000000</Z_NUTRI_COMP_PRDAT>

<Z_BEYOND_LBL_PRDAT>00000000</Z_BEYOND_LBL_PRDAT>

<Z_SRVSZ_SOLD>0.00</Z_SRVSZ_SOLD>

<Z_SRVSZ_PRDAT>00000000</Z_SRVSZ_PRDAT>

</_-AMS_-RUS_ZYAMARA2>

<_-AMS_-XAM_LOGSYS SEGMENT="1">

<LOGSYS>USENPIVBSM</LOGSYS>

</_-AMS_-XAM_LOGSYS>

<MAXC_TOL>0.0</MAXC_TOL>

</E1MARA1>

<MAKTX>CRUNCH Single Chocolate 10(36x1.55 oz)US</MAKTX>

<SPRAS_ISO>EN</SPRAS_ISO>

</E1MAKTM>

<MAKTX>ｸﾗﾝﾁｼﾝｸﾞﾙ 44GX36X10</MAKTX>

<SPRAS_ISO>JA</SPRAS_ISO>

</E1MAKTM>

<MAKTX>CRUNCH Single Chocolate 36x44g XI</MAKTX>

<SPRAS_ISO>PT</SPRAS_ISO>

</E1MAKTM>

<MAKTX>CRUNCH Single Chocolate 10(36x1.55 oz)US</MAKTX>

<SPRAS_ISO>ES</SPRAS_ISO>

</E1MAKTM>

<PSTAT>DEALBSVQG</PSTAT>

<QMATA>ZDEFLT</QMATA>

<_-AMS_-RUS_Z1MARCM SEGMENT="1">

<_-AMS_-YYDBM>00</_-AMS_-YYDBM>

<_-AMS_-YYDBS>225</_-AMS_-YYDBS>

<_-AMS_-YYMHDRZ>0</_-AMS_-YYMHDRZ>

<_-AMS_-YYMHDHB>0</_-AMS_-YYMHDHB>

<_-AMS_-YYREP>EA</_-AMS_-YYREP>

<_-AMS_-YYRWK>0</_-AMS_-YYRWK>

<_-AMS_-YYQAA>1</_-AMS_-YYQAA>

<_-AMS_-YYPYN>Y</_-AMS_-YYPYN>

<_-AMS_-YYPLD>10800</_-AMS_-YYPLD>

<_-AMS_-YYSTC>A</_-AMS_-YYSTC>

<_-AMS_-YYSTD>1.0</_-AMS_-YYSTD>

<_-AMS_-YYSTK>1</_-AMS_-YYSTK>

<_-AMS_-YYPAL>0</_-AMS_-YYPAL>

<_-AMS_-YYPKF>1.00</_-AMS_-YYPKF>

<_-AMS_-YYPLH>0.00</_-AMS_-YYPLH>

<_-AMS_-YYNDY>000</_-AMS_-YYNDY>

<_-AMS_-YYFCC>0.00</_-AMS_-YYFCC>

<_-AMS_-YYSUD>0.00</_-AMS_-YYSUD>

<_-AMS_-YYHUM>0.00</_-AMS_-YYHUM>

<_-AMS_-YYIPKRZ_PAL>00000000</_-AMS_-YYIPKRZ_PAL>

<_-AMS_-MATVD>0.00</_-AMS_-MATVD>

<_-AMS_-FICOMREL>N</_-AMS_-FICOMREL>

<_-AMS_-RTCOMREL>N</_-AMS_-RTCOMREL>

<_-AMS_-FIN_FACT01>1.00000</_-AMS_-FIN_FACT01>

<_-AMS_-FIN_FACT02>1.00000</_-AMS_-FIN_FACT02>

<_-AMS_-FIN_FACT03>1.00000</_-AMS_-FIN_FACT03>

<_-AMS_-FIN_FACT04>1.00000</_-AMS_-FIN_FACT04>

<_-AMS_-FIN_FACT05>1.00000</_-AMS_-FIN_FACT05>

</_-AMS_-RUS_Z1MARCM>

<_-AMS_-XAM_WERKS SEGMENT="1">

<WERKS_DESC>US PL SOLON</WERKS_DESC>

</_-AMS_-XAM_WERKS>

</E1MARDM>

</E1MPGDM>

</E1MARCM>

<GTIN_VARIANT>00</GTIN_VARIANT>

<NEST_FTR>0</NEST_FTR>

<MAX_STACK>0</MAX_STACK>

</E1MEANM>

</E1MARMM>

<GTIN_VARIANT>00</GTIN_VARIANT>

<NEST_FTR>0</NEST_FTR>

<MAX_STACK>0</MAX_STACK>

</E1MEANM>

</E1MARMM>

<NEST_FTR>0</NEST_FTR>

<MAX_STACK>0</MAX_STACK>

</E1MARMM>

<NEST_FTR>0</NEST_FTR>

<MAX_STACK>0</MAX_STACK>

</E1MARMM>

<NEST_FTR>0</NEST_FTR>

<MAX_STACK>0</MAX_STACK>

</E1MARMM>

<NEST_FTR>0</NEST_FTR>

<MAX_STACK>0</MAX_STACK>

</E1MARMM>

<GTIN_VARIANT>00</GTIN_VARIANT>

<NEST_FTR>0</NEST_FTR>

<MAX_STACK>0</MAX_STACK>

</E1MEANM>

</E1MARMM>

<NEST_FTR>0</NEST_FTR>

<MAX_STACK>0</MAX_STACK>

</E1MARMM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MBEWM>

</E1MLGNM>

</E1MLGNM>

</E1MLGNM>

</E1MLGNM>

</E1MLGNM>

</E1MLGNM>

</E1MLGNM>

</E1MLGNM>

</E1MLGNM>

</E1MLGTM>

</E1MLGNM>

<_-AMS_-RUS_MVKEM SEGMENT="1">

<ZYYPROD_SEQ>00000</ZYYPROD_SEQ>

<Z_GLB_CRDT_NF>00000000</Z_GLB_CRDT_NF>

<Z_GLB_CRDT_NCA>00000000</Z_GLB_CRDT_NCA>

<Z_GLB_CRDT_60_40>00000000</Z_GLB_CRDT_60_40>

<Z_GLB_CRDT_NN>00000000</Z_GLB_CRDT_NN>

<Z_GLB_AGE_DT>00000000</Z_GLB_AGE_DT>

<Z_PG_PERDT>00000000</Z_PG_PERDT>

</_-AMS_-RUS_MVKEM>

<_-AMS_-XAM_PRODH SEGMENT="1">

<BUSID_DESC>USA</BUSID_DESC>

<BUSI_DESC>US RETAIL CONFECTIONS</BUSI_DESC>

<SALESCATEG_NO>C1</SALESCATEG_NO>

<SALESCATEG_NAME>US IMPULSE</SALESCATEG_NAME>

<SUBCATEG_NO>C103</SUBCATEG_NO>

<SUBCATEG_NAME>US IMPULSE CHOC SINGLES</SUBCATEG_NAME>

<SEGNAME>US IMPLS CHOC SNGL OPEN STOCK</SEGNAME>

</_-AMS_-XAM_PRODH>

<_-AMS_-XAM_MAT_GROUP1 SEGMENT="1">

<BEZEI>US IMPLS CHOC SNGL OPEN STOCK</BEZEI>

</_-AMS_-XAM_MAT_GROUP1>

</E1MVKEM>

<_-AMS_-RUS_MVKEM SEGMENT="1">

<ZYYPROD_SEQ>00000</ZYYPROD_SEQ>

<Z_GLB_NN>02</Z_GLB_NN>

<Z_GLB_NPPT>03</Z_GLB_NPPT>

<Z_GLB_CRDT_NF>00000000</Z_GLB_CRDT_NF>

<Z_GLB_CRDT_NCA>00000000</Z_GLB_CRDT_NCA>

<Z_GLB_CRDT_60_40>00000000</Z_GLB_CRDT_60_40>

<Z_GLB_CRDT_NN>20090517</Z_GLB_CRDT_NN>

<Z_GLB_AGE_DT>00000000</Z_GLB_AGE_DT>

<Z_PG_PERDT>00000000</Z_PG_PERDT>

</_-AMS_-RUS_MVKEM>

<_-AMS_-XAM_PRODH SEGMENT="1">

<BUSID_DESC>Nestle Nutrition</BUSID_DESC>

<BUSI_DESC>Infant Nutrition - Formulas</BUSI_DESC>

<SALESCATEG_NO>F5</SALESCATEG_NO>

<SALESCATEG_NAME>Formulas Soy</SALESCATEG_NAME>

<SUBCATEG_NO>F501</SUBCATEG_NO>

<SUBCATEG_NAME>Formulas Soy Premium</SUBCATEG_NAME>

</_-AMS_-XAM_PRODH>

<_-AMS_-XAM_MAT_GROUP1 SEGMENT="1">

</_-AMS_-XAM_MAT_GROUP1>

</E1MVKEM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MLANM>

</E1MARAM>

</IDOC>

</_-AMS_-RUSX_MATMAS05>

output xml:

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

<ns0:MT_MATMAS xmlns:ns0="http://us.ams.nestle.com/tp"><Recordset><MATERIAL>000000000000414169</MATERIAL><PRODUCT_DESC>CRUNCH Single Chocolate 10(36x1.55 oz)US</PRODUCT_DESC><SALESORG>US03</SALESORG><DISTCHNL>06</DISTCHNL><DIV>00</DIV><ATTR1>C00001</ATTR1><ATTR1_DESC> </ATTR1_DESC><ATTR2>R000036</ATTR2><ATTR2_DESC> </ATTR2_DESC><ATTR3>?</ATTR3><ATTR3_DESC> </ATTR3_DESC><ATTR4> </ATTR4><ATTR4_DESC> </ATTR4_DESC><ATTR5>5004</ATTR5><ATTR5_DESC> </ATTR5_DESC><PRODHIER1>US</PRODHIER1><PRODHIER1_DESC>USA</PRODHIER1_DESC><PRODHIER2>C</PRODHIER2><PRODHIER2_DESC>US RETAIL CONFECTIONS</PRODHIER2_DESC><PRODHIER3>C1</PRODHIER3><PRODHIER3_DESC>US IMPULSE</PRODHIER3_DESC><PRODHIER4>C103</PRODHIER4><PRODHIER4_DESC>US IMPULSE CHOC SINGLES</PRODHIER4_DESC><PRODHIER5>C103D8</PRODHIER5><PRODHIER5_DESC>US IMPLS CHOC SNGL OPEN STOCK</PRODHIER5_DESC><CURRENT_COST_PER_UOM>0.20</CURRENT_COST_PER_UOM><GROSS_WEIGHT>0.000</GROSS_WEIGHT><WEIGHT_UOM>?</WEIGHT_UOM><ZVRKME>ZZC</ZVRKME><ZPLMATST>Z3</ZPLMATST><PROD_HIER_0>USCC1C103C103D8</PROD_HIER_0><GTIN_VARIANT>00</GTIN_VARIANT><LOCAL_ATTR2>US38</LOCAL_ATTR2><MATERAIL_GROUP1>3D8</MATERAIL_GROUP1></Recordset></ns0:MT_MATMAS>

Hi Chinna,

Can you try this one:

MEINH and VRKME context set to E1MARAM

Here's the code:

Regards,

Mark

Hello Mark,

thanks for the UDF, there is small change we need to do.

UDF we need to check VRKME value with all MEINH values. if it fail then we need to look for MEINH = ZZC.

check the screen shot. based on the screen shot

VRKME = ZZC and fist context we have ZZC in MEINH and so we need to pass 00 in output. but we are passing empty.

Hi Chinna,

Can you try this code


boolean found = false;
String gtin = inp3[0]; //gets the value of GTIN
String vrkme = inp2[0]; //gets the first value of VRKME


for(int a=0;a<inp1.length;a++){ //for cases when MEINH = VRKME
  if(inp1[a].equals(vrkme)){
  result.addValue(gtin);
  found = true;
  break;
  }
}
if(found == false){
  result.addValue("");
}

Regards,

Mark

Thanks Mark you are Awesome.

Answers (0)

Ask a Question

Top Q&A Solution Author

User

Count

Help in logic UDF in XI

Accepted Solutions (1)

Accepted Solutions (1)

Answers (0)

Custom Fields for Goods Receipt Label

Re: Struggling with Filters on Select - Fiori App

Re: Struggling with Filters on Select - Fiori App

Re: Struggling with Filters on Select - Fiori App

Re: Struggling with Filters on Select - Fiori App