pegaga1979
8th June 2015, 07:36
Hi,

i would like to know, if i want to update status only for 1 field in the table, how i have to set in the Exchange?
for example, in table whwmd530, we have 84 fields, and i want to update only 1 field.
The rest i can't set as default as it already has data. so how i can do/update that one field?

mark_h
8th June 2015, 16:06
Just create an update exchange schema. In 4c4 I would generate it just like normal. Then I would remove all the excess fields except the index fields and the other field to be updated. So on the maintain table relationships I would set to no Add record and Delete record. For example we have one to update the order lead time on the item master. So the file it reads as two fields Item, order lead time. The ascii file on it also only has the item and leadtime also. About all there is to it.

pegaga1979
9th June 2015, 08:57
thank you.
i will try.