Hi Prabin,
copying from PartMtl -> ECOMtl?
If that doesn't work, you can try a post process BPM like:
for each partmtl where
partmtl.Company = cur-comp and
partmtl.PartNum = ipPartNum and
partmtl.RevisionNum = ipRevisionNum:
{lib/findtbl.i &QFind = first
&QLock = Exclusive-lock
&QTableName = ECOMtl
&QWhere = "ecomtl.Company = partmtl.Company and
ecomtl.MtlPartNum = partmtl.MtlPartNum and
ecomtl.RevisionNum = partmtl.RevisionNum"}
if avail ecomtl then do:
assign ecomtl.Character01 = partmtl.Character01.
assign ecomtl.Character02 = partmtl.Character02.
assign ecomtl.Character03 = partmtl.Character03.
assign ecomtl.Character04 = partmtl.Character04.
assign ecomtl.Character05 = partmtl.Character05.
assign ecomtl.Character06 = partmtl.Character06.
assign ecomtl.Character07 = partmtl.Character07.
assign ecomtl.Character08 = partmtl.Character08.
assign ecomtl.Character09 = partmtl.Character09.
assign ecomtl.Character10 = partmtl.Character10.
assign ecomtl.Number01 = partmtl.Number01.
assign ecomtl.Number02 = partmtl.Number02.
assign ecomtl.Number03 = partmtl.Number03.
assign ecomtl.Number04 = partmtl.Number04.
assign ecomtl.Number05 = partmtl.Number05.
assign ecomtl.Number06 = partmtl.Number06.
assign ecomtl.Number07 = partmtl.Number07.
assign ecomtl.Number08 = partmtl.Number08.
assign ecomtl.Number09 = partmtl.Number09.
assign ecomtl.Number10 = partmtl.Number10.
assign ecomtl.Number11 = partmtl.Number11.
assign ecomtl.Number12 = partmtl.Number12.
assign ecomtl.Number13 = partmtl.Number13.
assign ecomtl.Number14 = partmtl.Number14.
assign ecomtl.Number15 = partmtl.Number15.
assign ecomtl.Number16 = partmtl.Number16.
assign ecomtl.Number17 = partmtl.Number17.
assign ecomtl.Number18 = partmtl.Number18.
assign ecomtl.Number19 = partmtl.Number19.
assign ecomtl.Number20 = partmtl.Number20.
assign ecomtl.Date01 = partmtl.Date01.
assign ecomtl.Date02 = partmtl.Date02.
assign ecomtl.Date03 = partmtl.Date03.
assign ecomtl.Date04 = partmtl.Date04.
assign ecomtl.Date05 = partmtl.Date05.
assign ecomtl.Date06 = partmtl.Date06.
assign ecomtl.Date07 = partmtl.Date07.
assign ecomtl.Date08 = partmtl.Date08.
assign ecomtl.Date09 = partmtl.Date09.
assign ecomtl.Date10 = partmtl.Date10.
assign ecomtl.Date11 = partmtl.Date11.
assign ecomtl.Date12 = partmtl.Date12.
assign ecomtl.Date13 = partmtl.Date13.
assign ecomtl.Date14 = partmtl.Date14.
assign ecomtl.Date15 = partmtl.Date15.
assign ecomtl.Date16 = partmtl.Date16.
assign ecomtl.Date17 = partmtl.Date17.
assign ecomtl.Date18 = partmtl.Date18.
assign ecomtl.Date19 = partmtl.Date19.
assign ecomtl.Date20 = partmtl.Date20.
assign ecomtl.CheckBox01 = partmtl.CheckBox01.
assign ecomtl.CheckBox02 = partmtl.CheckBox02.
assign ecomtl.CheckBox03 = partmtl.CheckBox03.
assign ecomtl.CheckBox04 = partmtl.CheckBox04.
assign ecomtl.CheckBox05 = partmtl.CheckBox05.
assign ecomtl.CheckBox06 = partmtl.CheckBox06.
assign ecomtl.CheckBox07 = partmtl.CheckBox07.
assign ecomtl.CheckBox08 = partmtl.CheckBox08.
assign ecomtl.CheckBox09 = partmtl.CheckBox09.
assign ecomtl.CheckBox10 = partmtl.CheckBox10.
assign ecomtl.CheckBox11 = partmtl.CheckBox11.
assign ecomtl.CheckBox12 = partmtl.CheckBox12.
assign ecomtl.CheckBox13 = partmtl.CheckBox13.
assign ecomtl.CheckBox14 = partmtl.CheckBox14.
assign ecomtl.CheckBox15 = partmtl.CheckBox15.
assign ecomtl.CheckBox16 = partmtl.CheckBox16.
assign ecomtl.CheckBox17 = partmtl.CheckBox17.
assign ecomtl.CheckBox18 = partmtl.CheckBox18.
assign ecomtl.CheckBox19 = partmtl.CheckBox19.
assign ecomtl.CheckBox20 = partmtl.CheckBox20.
assign ecomtl.ShortChar01 = partmtl.ShortChar01.
assign ecomtl.ShortChar02 = partmtl.ShortChar02.
assign ecomtl.ShortChar03 = partmtl.ShortChar03.
assign ecomtl.ShortChar04 = partmtl.ShortChar04.
assign ecomtl.ShortChar05 = partmtl.ShortChar05.
assign ecomtl.ShortChar06 = partmtl.ShortChar06.
assign ecomtl.ShortChar07 = partmtl.ShortChar07.
assign ecomtl.ShortChar08 = partmtl.ShortChar08.
assign ecomtl.ShortChar09 = partmtl.ShortChar09.
assign ecomtl.ShortChar10 = partmtl.ShortChar10.
end. /* avail ecomtl */
end. /* avail PartMtl */
Best,
Mark W.
> Thank you for the suggestion. I have done custom field mappings (ecorev <-> partrev) but in this scenario, I am not copying from one table to other. It is more like copying  the fields of the table to the same fields and same table, just like creating a new record. So, not sure how custom field mapping would help.If you're doing a GetDetails from a PartRevision, are you not actually
>
copying from PartMtl -> ECOMtl?
If that doesn't work, you can try a post process BPM like:
for each partmtl where
partmtl.Company = cur-comp and
partmtl.PartNum = ipPartNum and
partmtl.RevisionNum = ipRevisionNum:
{lib/findtbl.i &QFind = first
&QLock = Exclusive-lock
&QTableName = ECOMtl
&QWhere = "ecomtl.Company = partmtl.Company and
ecomtl.MtlPartNum = partmtl.MtlPartNum and
ecomtl.RevisionNum = partmtl.RevisionNum"}
if avail ecomtl then do:
assign ecomtl.Character01 = partmtl.Character01.
assign ecomtl.Character02 = partmtl.Character02.
assign ecomtl.Character03 = partmtl.Character03.
assign ecomtl.Character04 = partmtl.Character04.
assign ecomtl.Character05 = partmtl.Character05.
assign ecomtl.Character06 = partmtl.Character06.
assign ecomtl.Character07 = partmtl.Character07.
assign ecomtl.Character08 = partmtl.Character08.
assign ecomtl.Character09 = partmtl.Character09.
assign ecomtl.Character10 = partmtl.Character10.
assign ecomtl.Number01 = partmtl.Number01.
assign ecomtl.Number02 = partmtl.Number02.
assign ecomtl.Number03 = partmtl.Number03.
assign ecomtl.Number04 = partmtl.Number04.
assign ecomtl.Number05 = partmtl.Number05.
assign ecomtl.Number06 = partmtl.Number06.
assign ecomtl.Number07 = partmtl.Number07.
assign ecomtl.Number08 = partmtl.Number08.
assign ecomtl.Number09 = partmtl.Number09.
assign ecomtl.Number10 = partmtl.Number10.
assign ecomtl.Number11 = partmtl.Number11.
assign ecomtl.Number12 = partmtl.Number12.
assign ecomtl.Number13 = partmtl.Number13.
assign ecomtl.Number14 = partmtl.Number14.
assign ecomtl.Number15 = partmtl.Number15.
assign ecomtl.Number16 = partmtl.Number16.
assign ecomtl.Number17 = partmtl.Number17.
assign ecomtl.Number18 = partmtl.Number18.
assign ecomtl.Number19 = partmtl.Number19.
assign ecomtl.Number20 = partmtl.Number20.
assign ecomtl.Date01 = partmtl.Date01.
assign ecomtl.Date02 = partmtl.Date02.
assign ecomtl.Date03 = partmtl.Date03.
assign ecomtl.Date04 = partmtl.Date04.
assign ecomtl.Date05 = partmtl.Date05.
assign ecomtl.Date06 = partmtl.Date06.
assign ecomtl.Date07 = partmtl.Date07.
assign ecomtl.Date08 = partmtl.Date08.
assign ecomtl.Date09 = partmtl.Date09.
assign ecomtl.Date10 = partmtl.Date10.
assign ecomtl.Date11 = partmtl.Date11.
assign ecomtl.Date12 = partmtl.Date12.
assign ecomtl.Date13 = partmtl.Date13.
assign ecomtl.Date14 = partmtl.Date14.
assign ecomtl.Date15 = partmtl.Date15.
assign ecomtl.Date16 = partmtl.Date16.
assign ecomtl.Date17 = partmtl.Date17.
assign ecomtl.Date18 = partmtl.Date18.
assign ecomtl.Date19 = partmtl.Date19.
assign ecomtl.Date20 = partmtl.Date20.
assign ecomtl.CheckBox01 = partmtl.CheckBox01.
assign ecomtl.CheckBox02 = partmtl.CheckBox02.
assign ecomtl.CheckBox03 = partmtl.CheckBox03.
assign ecomtl.CheckBox04 = partmtl.CheckBox04.
assign ecomtl.CheckBox05 = partmtl.CheckBox05.
assign ecomtl.CheckBox06 = partmtl.CheckBox06.
assign ecomtl.CheckBox07 = partmtl.CheckBox07.
assign ecomtl.CheckBox08 = partmtl.CheckBox08.
assign ecomtl.CheckBox09 = partmtl.CheckBox09.
assign ecomtl.CheckBox10 = partmtl.CheckBox10.
assign ecomtl.CheckBox11 = partmtl.CheckBox11.
assign ecomtl.CheckBox12 = partmtl.CheckBox12.
assign ecomtl.CheckBox13 = partmtl.CheckBox13.
assign ecomtl.CheckBox14 = partmtl.CheckBox14.
assign ecomtl.CheckBox15 = partmtl.CheckBox15.
assign ecomtl.CheckBox16 = partmtl.CheckBox16.
assign ecomtl.CheckBox17 = partmtl.CheckBox17.
assign ecomtl.CheckBox18 = partmtl.CheckBox18.
assign ecomtl.CheckBox19 = partmtl.CheckBox19.
assign ecomtl.CheckBox20 = partmtl.CheckBox20.
assign ecomtl.ShortChar01 = partmtl.ShortChar01.
assign ecomtl.ShortChar02 = partmtl.ShortChar02.
assign ecomtl.ShortChar03 = partmtl.ShortChar03.
assign ecomtl.ShortChar04 = partmtl.ShortChar04.
assign ecomtl.ShortChar05 = partmtl.ShortChar05.
assign ecomtl.ShortChar06 = partmtl.ShortChar06.
assign ecomtl.ShortChar07 = partmtl.ShortChar07.
assign ecomtl.ShortChar08 = partmtl.ShortChar08.
assign ecomtl.ShortChar09 = partmtl.ShortChar09.
assign ecomtl.ShortChar10 = partmtl.ShortChar10.
end. /* avail ecomtl */
end. /* avail PartMtl */
Best,
Mark W.