Skip to Content
0
Former Member
Jan 29, 2008 at 05:11 AM

Mis match in Types Conversion.

35 Views

Hi All,

I'm stuck at this following logic implementation.

The fields For Action reason and Text, In Query Sheet it was mention to use the following Logic.

1) from table /BI0/SEMPLOYEE, input the employee number and output the SID

2) from table /BI0/D0PA_C011, input the SID( extracted above) and output the DIMID

3) from table /BI0/D0PA_C01T, input the DIMID(extracted above) and output the SID_0CALYEAR.

4) from table /BI0/F0PA_C01, input the KEY_0PA_C011 = /BI0/D0PA_C011-DIMID

and KEY_0PA_C01T = /BI0/D0PA_C01T-SID_0CALYEAR output all the rows for the field KEY_0PA_C012.

5) from table /BI0/D0PA_C012, input DIMID = /BI0/F0PA_C01-KEY_0PA_C012 output all the rows for the field SID_0ACTIONREAS SID_0ACTIONTYPE.

6) from table /BI0/TACTIONREAS, input ACTIONREAS and output all the rows of ACTIONTYPE and TXTMD into the output file

But there is mismatch happening when we come to Step 5 and 6.

SID_0ACTIONREAS , SID_0ACTIONTYPE of Table /BI0/F0PA_C01 and ACTIONREAS ,ACTIONTYPE of Table /BI0/TACTIONREAS are having different Type declarations.

So hence I’m not able to validate the Action Type and TXTMD .

But I'm not able to handle this exception.

can any plz let me know how to handle this conversion.

Thank Q

Rohini.