Storing GUID in CHAR 32 format from RAW 16
I'm trying to get Ext Ref No from a table CRMD_SALES (field PO_NUMBER_SOLD) and add it to the extract structure crmt_bw_complaints_i.
The join should be on the field GUID of the CRMD_SALES table. Unfortunately, neither of guid from the extract structure or table crmd_link will match the GUID from CRMD_SALES table.
How can I store a GUID from CRMD_SALES or CRMD_LINK table into crmt_bw_complaints_i.-GUID field?
Reward point Guranteed