How does table conversion work?

[apoeran]

Hello List,

I am totally new in JD Edwards. My first assignment in JDE is to do a table conversion. I have created two tables for test purposes. One is called F56TEST and the other F56TEST2.
Both consists of 12 fields. F56TEST has got data. F56TEST2 is empty.
All I want to do is to put the values of the first field of F56TEST (first field is the key) into the fourth field of F56TEST2 (fourth field is the key). This is a String field
I´ve followed the Table Conversion Director step by step
1. selected Data Conversion
2. no external data
3. selected the wright input and output environments; dv7333
4. input = F56TEST
5. no sequencing
6. no data selection
7. output = F56TEST2
8. no changes for Table options
9. The only mapping i´ve done is on the event `Process begin`
map; F56TEST2.Field4 = F56TEST.Field1
10. no logging

And when I run my batch and look in the UTB I can´t see anything in F56TEST2.

What am I doing wrong? Or is it best not to use TC and just use a regular UBE?

Plz help....
Amar

 

[got_to_love_jde]

Amar,
I have always found regular UBE's to have less problems than the table conversion. Try simply setting up a business view over the first table and then do an insert in the DO section of your UBE.
Regards,
Dave

 

[dgreen]

Do you mapping in the Row Fetched event. Take your mapping of the other. The Process Begin event is a one time event prior to reading the records. The Process End event is a one time event at the end of the reads. Once you have done your mapping, click Advanced ER and see if the code it generated looks good to you and has the write at the end of the code.