Type conflict in join PTREQ_ITEMS-ITEM_INS = PTREQ_ATTABSDATA-ITEM_ID

[Former Member]

Is it possible PTREQ_ITEMS and PTREQ_ATTABSDATA in a view? PTREQ_ITEMS-ITEM_INS is Raw 16 and PTREQ_ATTABSDATA-ITEM_ID is Char 32. I'm getting a type conflict error. I tried using the "Mod" check box but all the data elements I can choose have the wrong domain.

Is there some trick to doing this or is it not possible?

Thanks,

Dale

[Former Member]

Hi Dale,

Were you able to resolve this issue ? If so, could you please share ?

Regards

Aditi

[Former Member]

I have not been able to resolve this issue.

Thanks,

Dale

[Former Member]

Hi Dale,

If we use the work area of PTREQ_ATTABSDATA and pass the value of ITEM_ID to PTREQ_ITEMS-ITEM_INS , it does not result in type conflict.

Try the following code :

TYPES : BEGIN OF ty_ptreq_absdata,

item_id TYPE ptreq_attabsdata-item_id,

begin_time TYPE ptreq_attabsdata-begin_time,

end_time TYPE ptreq_attabsdata-end_time,

attabs_hours TYPE ptreq_attabsdata-attabs_hours,

subty TYPE ptreq_attabsdata-subty,

begda TYPE ptreq_attabsdata-begda,

endda TYPE ptreq_attabsdata-endda,

END OF ty_ptreq_absdata.

TYPES : BEGIN OF ty_ptreq_item,

item_list_id TYPE tim_req_item_id,

item_ins TYPE OS_GUID,

END OF ty_ptreq_item.

DATA : lt_ptreq_absdata TYPE TABLE OF ty_ptreq_absdata,

ls_ptreq_absdata TYPE ty_ptreq_absdata.

DATA : lt_ptreq_item TYPE TABLE OF ty_ptreq_item,

ls_ptreq_item TYPE ty_ptreq_item.

LOOP AT lt_ptreq_absdata INTO ls_ptreq_absdata.

SELECT SINGLE item_list_id item_ins FROM ptreq_items

INTO ls_ptreq_item

WHERE item_ins = ls_ptreq_absdata-item_id.

IF sy-subrc EQ 0.

APPEND ls_ptreq_item TO lt_ptreq_item.

ENDIF.

ENDLOOP.

Regards

Aditi