Hide 0EMPLOYEE_ATTR Field in Employee

[Former Member]

Dear Gurus,

Problem :

I'm trying to load 0EMPLOYEE data from 0EMPLOYEE_ATTR  , but there's Arabic language also coming and it's displaying junk (??? , ### ) once the data is loaded.

Solution I'm looking for:

I want to hide these filed while loading the data

"SNAME" coming from 0EMPLOYEE_ATTR  datasource in R3       and connecting to 0EE_SNAME in the 0EMPLOYEE.

Is there any routine or any logics to apply so that I can avoid loading Arabic data into the 0EMPLOYEE ??

any tips will be appreciated.

Regards,

-Neha

[RamanKorrapati · Accepted solution]

Mean for some records only you need to hide, permanently you don't need SNAME data at info object level.

if you don't need SNAME data in bw then you can delete the mappings between SNAME--->0EE_NAME. or You can remove 0EE_NAME attribute from 0employee.

If you need to remove sname data for some fields then its not possible.

You need ask source  to mdoify the arabic data.

later you can relaod the data.

[Former Member · Accepted solution]

Hi Raman,

I need to hide or don't need it permanently !!

I tried to remove the mapping but that didn't work.

I will try removing the 0EE_NAME attribute from 0EMP.

I think that should work.

will update , let me try

Regards,

[former_member185177 · Accepted solution]

Hi Neha,

Don't remove any existing standard attributes.  Try with the below mention option.  I think your issue will resolve.

Regards,

Krishna Chaitanya.

[RamanKorrapati · Accepted solution]

Even at data source level also you can hide SNAME field.

at ECC side RSA6 , you can select hide option for SNAME field.

later replicate data source and activate your whole data flow.

Lets try info object level,if that didn't work then later you can try at data source level.

Note: Please do changed dev and test it. later you can do transport.

[Former Member]

Hi Neha A,

Please use this Routine and remove the invalid Characters.

DATA A

TYPE /BIC/OIGTXDESCIT

.

DATA : L_LEN TYPE i,
      L_TIME TYPE i.
CONSTANTS: c_40 TYPE I VALUE 40.
MOVE SOURCE_FIELDS-DESTINATIONCITY TO A.
TRANSLATE A TO UPPER CASE.
MOVE c_40 TO L_LEN.
DO L_LEN TIMES.

   IF A+L_TIME(1) CN
     ',<>?/\:;"''ABCDEFGHI JKLMNOPQRSTUVWXYZ!%^&*()__+=1234567890'.
A+L_TIME(1) = '~'.

   ENDIF.

L_TIME = L_TIME + 1.

ENDDO.

  REPLACE ALL OCCURRENCES OF '~' IN a WITH space.
CONDENSE A.
MOVE A TO RESULT.

Regards,

Abdul Rawoof Syed.

[Former Member]

Hi Syed / Raman / Krishna,

Ok I'll try all the solutions and update

Appreciate your response.

Regards,

[former_member185177]

Hi Neha,

Create error stack DTP when you are loading the data from PSA to 0EMPLOYEE.  All the junk data along with any inconsistency in the time interval of the employee will not load.  So that you can check which records are not updated and those records you can share with your business people to rectify/modify/delete from the source.

Regards,

Krishna Chaitanya.