IDOC To XML using JCOIDOC

[Former Member]

Hi Experts,

IS it possible to know from a field of segment in XML format IDOC coming from SAP system to JCO that whether that transaction is a new record (create) or change pointer record , so that i can either Insert the data or Update in to the Database respectively.

specifically saying am using MATMAS05 and am not able to figure it out for new or change pointer.

Edited by: anil@1234 on Nov 12, 2010 6:09 AM

[Former Member]

Hi,

Check the Field MSGFN(Message Function) of the segment E1MARAM...which will have the ids.(009/003...).details about the New/delete/change...

Hope this helps ..

As per the format posted by you I think the value 004 000000000000000029 of second line where the id 004 tells you the needed details (looks like this is a change to material 29...)

Regards

Rajesh

Edited by: Rajesh on Nov 12, 2010 11:07 AM

[Former Member]

Thanks for your quick reply,

We have MSGFN in a higher segment E1MARAM, But now am getting confused of by the inner segments of E!MARAM and all the other segmants has MSGFN , so what do we conclude, can we go with the higher segmant MSGFN or is that a problem considering nly that.

[former_member472138]

Hello Anil,

Is it possible for you to add XML over here?

Regards

Pothana

[Former Member]

<?xml version="1.0" ?>

- <MATMAS05>

- <IDOC BEGIN="1">

- <EDI_DC40 SEGMENT="1">

<TABNAM>EDI_DC40</TABNAM>

<MANDT>100</MANDT>

<DOCNUM>0000000000222146</DOCNUM>

<DOCREL>700</DOCREL>

<STATUS>30</STATUS>

<DIRECT>1</DIRECT>

<OUTMOD>2</OUTMOD>

<EXPRSS />

<TEST />

<IDOCTYP>MATMAS05</IDOCTYP>

<CIMTYP />

<MESTYP>MATMAS</MESTYP>

<MESCOD />

<MESFCT />

<STD />

<STDVRS />

<STDMES />

<SNDPOR>SAPB60</SNDPOR>

<SNDPRT>LS</SNDPRT>

<SNDPFC />

<SNDPRN>B60CLNT100</SNDPRN>

<SNDSAD />

<SNDLAD />

<RCVPOR>A000000016</RCVPOR>

<RCVPRT>LS</RCVPRT>

<RCVPFC />

<RCVPRN>ICONLS</RCVPRN>

<RCVSAD />

<RCVLAD />

<CREDAT>20101111</CREDAT>

<CRETIM>162912</CRETIM>

<REFINT />

<REFGRP />

<REFMES />

<ARCKEY />

<SERIAL>20101111162909</SERIAL>

</EDI_DC40>

- <E1MARAM SEGMENT="1">

<MSGFN>004</MSGFN>

<MATNR>000000000000000029</MATNR>

<ERSDA>20080305</ERSDA>

<ERNAM>Material03</ERNAM>

<LAEDA>20101104</LAEDA>

<AENAM>anil</AENAM>

<PSTAT>KSLEBDP</PSTAT>

<LVORM />

<MTART>ROH</MTART>

<MBRSH>M</MBRSH>

<MATKL>01</MATKL>

<BISMT />

<MEINS>EA</MEINS>

<BSTME />

<ZEINR />

<ZEIAR />

<ZEIVR />

<ZEIFO />

<AESZN />

<BLATT />

<BLANZ>000</BLANZ>

<FERTH />

<FORMT />

<GROES />

<WRKST />

<NORMT />

<LABOR />

<EKWSL />

<BRGEW>0.000</BRGEW>

<NTGEW>0.000</NTGEW>

<GEWEI />

<VOLUM>0.000</VOLUM>

<VOLEH />

<BEHVO />

<RAUBE />

<TEMPB />

<TRAGR />

<STOFF />

<SPART />

<KUNNR />

<WESCH>0.000</WESCH>

<BWVOR />

<BWSCL />

<SAISO />

<ETIAR />

<ETIFO />

<EAN11 />

<NUMTP />

<LAENG>0.000</LAENG>

<BREIT>0.000</BREIT>

<HOEHE>0.000</HOEHE>

<MEABM />

<PRDHA />

<CADKZ />

<ERGEW>0.000</ERGEW>

<ERGEI />

<ERVOL>0.000</ERVOL>

<ERVOE />

<GEWTO>0.0</GEWTO>

<VOLTO>0.0</VOLTO>

<VABME />

<KZKFG />

<XCHPF />

<VHART />

<FUELG>0</FUELG>

<STFAK>0</STFAK>

<MAGRV />

<BEGRU />

<QMPUR />

<RBNRM />

<MHDRZ>0</MHDRZ>

<MHDHB>0</MHDHB>

<MHDLP>0</MHDLP>

<VPSTA>KSLEBDP</VPSTA>

<EXTWG />

<MSTAE />

<MSTAV />

<MSTDE>00000000</MSTDE>

<MSTDV>00000000</MSTDV>

<KZUMW />

<KOSCH />

<NRFHG />

<MFRPN />

<MFRNR />

<BMATN />

<MPROF />

<PROFL />

<IHIVI />

<ILOOS />

<KZGVH />

<XGCHP />

<COMPL>00</COMPL>

<KZEFF />

<RDMHD />

<IPRKZ />

<PRZUS />

<MTPOS_MARA />

<GEWTO_NEW>0.0</GEWTO_NEW>

<VOLTO_NEW>0.0</VOLTO_NEW>

<WRKST_NEW />

<AENNR />

<MATFI />

<CMREL />

<SATNR />

<SLED_BBD>B</SLED_BBD>

<GTIN_VARIANT />

<GENNR />

<SERLV />

<RMATP />

<GDS_RELEVANT />

<MCOND />

<RETDELC />

<LOGLEV_RETO />

<NSNID />

<WEORA />

<_-CWM_-TOLGR />

<_-CWM_-TARA />

<_-CWM_-TARUM />

- <E1MAKTM SEGMENT="1">

<MSGFN>018</MSGFN>

<SPRAS>E</SPRAS>

<MAKTX>bolt</MAKTX>

<SPRAS_ISO>EN</SPRAS_ISO>

</E1MAKTM>

- <E1MARCM SEGMENT="1">

<MSGFN>004</MSGFN>

<WERKS>0001</WERKS>

<PSTAT>SLEBDP</PSTAT>

<LVORM />

<BWTTY />

<MAABC />

<KZKRI />

<EKGRP />

<AUSME />

<DISPR />

<DISMM>PD</DISMM>

<DISPO>001</DISPO>

<PLIFZ>0</PLIFZ>

<WEBAZ>0</WEBAZ>

<PERKZ>M</PERKZ>

<AUSSS>0.00</AUSSS>

<DISLS>DY</DISLS>

<BESKZ>X</BESKZ>

<SOBSL />

<MINBE>0.000</MINBE>

<EISBE>0.000</EISBE>

<BSTMI>0.000</BSTMI>

<BSTMA>0.000</BSTMA>

<BSTFE>0.000</BSTFE>

<BSTRF>0.000</BSTRF>

<MABST>0.000</MABST>

<LOSFX>1</LOSFX>

<SBDKZ />

<LAGPR>1</LAGPR>

<ALTSL />

<KZAUS />

<AUSDT>00000000</AUSDT>

<NFMAT />

<KZBED />

<MISKZ />

<FHORI>000</FHORI>

<PFREI />

<FFREI />

<RGEKZ />

<FEVOR />

<BEARZ>0.00</BEARZ>

<RUEZT>0.00</RUEZT>

<TRANZ>0.00</TRANZ>

<BASMG>0.000</BASMG>

<DZEIT>0</DZEIT>

<MAXLZ>0</MAXLZ>

<LZEIH />

<KZPRO />

<GPMKZ />

<UEETO>0.0</UEETO>

<UEETK />

<UNETO>0.0</UNETO>

<WZEIT>0</WZEIT>

<ATPKZ />

<VZUSL>0.00</VZUSL>

<HERBL />

<INSMK />

<SSQSS />

<KZDKZ />

<UMLMC>0.000</UMLMC>

<LADGR />

<XCHPF />

<USEQU />

<LGRAD>0.0</LGRAD>

<AUFTL />

<PLVAR />

<OTYPE />

<OBJID>00000000</OBJID>

<MTVFP>KP</MTVFP>

<PERIV />

<KZKFK />

<VRVEZ>0.00</VRVEZ>

<VBAMG>0.000</VBAMG>

<VBEAZ>0.00</VBEAZ>

<LIZYK />

<BWSCL />

<KAUTB />

<KORDB />

<STAWN />

<HERKL />

<HERKR />

<EXPME />

<MTVER />

<PRCTR />

<TRAME>0.000</TRAME>

<MRPPP />

<SAUFT />

<FXHOR>000</FXHOR>

<VRMOD />

<VINT1>000</VINT1>

<VINT2>000</VINT2>

<STLAL />

<STLAN />

<PLNNR />

<APLAL />

<LOSGR>0.000</LOSGR>

<SOBSK />

<FRTME />

<LGPRO />

<DISGR />

<KAUSF>0.00</KAUSF>

<QZGTP />

<TAKZT>0</TAKZT>

<RWPRO />

<COPAM />

<ABCIN />

<AWSLS />

<SERNP />

<STDPD />

<SFEPR />

<XMCNG />

<QSSYS />

<LFRHY />

<RDPRF />

<VRBMT />

<VRBWK />

<VRBDT>00000000</VRBDT>

<VRBFK>0.00</VRBFK>

<AUTRU>X</AUTRU>

<PREFE />

<PRENC />

<PRENO />

<PREND>00000000</PREND>

<PRENE />

<PRENG>00000000</PRENG>

<ITARK />

<PRFRQ>0</PRFRQ>

<KZKUP />

<STRGR />

<LGFSB />

<SCHGT />

<CCFIX />

<EPRIO />

<QMATA />

<PLNTY />

<MMSTA />

<SFCPF />

<SHFLG />

<SHZET>00</SHZET>

<MDACH />

<KZECH />

<MMSTD>00000000</MMSTD>

<MFRGR />

<FVIDK />

<INDUS />

<MOWNR />

<MOGRU />

<CASNR />

<GPNUM />

<STEUC />

<FABKZ />

<MATGR />

<LOGGR />

<VSPVB />

<DPLFS />

<DPLPU />

<DPLHO>0</DPLHO>

<MINLS>0.000</MINLS>

<MAXLS>0.000</MAXLS>

<FIXLS>0.000</FIXLS>

<LTINC>0.000</LTINC>

<COMPL>00</COMPL>

<CONVT />

<FPRFM />

<SHPRO />

<FXPRU />

<KZPSP />

<OCMPF />

<APOKZ />

<AHDIS />

<EISLO>0.000</EISLO>

<NCOST />

<MEGRU />

<ROTATION_DATE />

<UCHKZ />

<UCMAT />

- <E1MPOPM SEGMENT="1">

<MSGFN>009</MSGFN>

<VERSP />

<PROPR />

<MODAW />

<MODAV>2</MODAV>

<KZPAR />

<OPGRA />

<KZINI>X</KZINI>

<PRMOD>D</PRMOD>

<ALPHA>0.00</ALPHA>

<BETA1>0.00</BETA1>

<GAMMA>0.00</GAMMA>

<DELTA>0.00</DELTA>

<EPSIL>0.00</EPSIL>

<SIGGR>4.000</SIGGR>

<PERKZ>M</PERKZ>

<PRDAT>00000000</PRDAT>

<PERAN>60</PERAN>

<PERIN>0</PERIN>

<PERIO>0</PERIO>

<PEREX>0</PEREX>

<ANZPR>12</ANZPR>

<FIMON>0</FIMON>

<GWERT>0.000</GWERT>

<GWER1>0.000</GWER1>

<GWER2>0.000</GWER2>

<VMGWE>0.000</VMGWE>

<VMGW1>0.000</VMGW1>

<VMGW2>0.000</VMGW2>

<TWERT>0.000</TWERT>

<VMTWE>0.000</VMTWE>

<PRMAD>0.000</PRMAD>

<VMMAD>0.000</VMMAD>

<FSUMM>0.000</FSUMM>

<VMFSU>0.000</VMFSU>

<GEWGR />

<THKOF>0.00</THKOF>

<AUSNA />

<PROAB />

</E1MPOPM>

</E1MARCM>

</E1MARAM>

</IDOC>

</MATMAS05>

[Former Member]

Hi Pothana,

I posted the XMl but i think this forum doesn accept the XML format, it changes the format and displays for u i think so.