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 Im 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.