Table that contains GESCH data

[Former Member]

Hi,

How can I find gender(GESCH) of the employee and also the description for the gender value in SAP table?

Thank you in advance,

Sunny

[Former Member · Accepted solution]

Gender Key may have the following Values

1 = Male

2 = Female

initial = unknown.

Check in table PA0002 or PB0002 (Personal Data).

Message was edited by: SBX

Message was edited by: SBX

[Former Member]

Hi there:

1. Use table PA0002 (HR Master Record: Infotype 0002 (Personal Data)) to get the gender of an employee.

2. Use domain GESCH (gender key) to get the possible values and description. For example, get the value of GESCH from table PA0002 for the employee that you are interested in. Store that value in variable L_GESCH. Exceute following function module call and you will get the description for it (assuming you are storing description in L_DESCRIPTION):

CALL FUNCTION 'GET_TEXT_DOMVALUE'

EXPORTING

domname = 'GESCH'

domvalue = L_GESCH

langu = 'EN' (for English)

IMPORTING

TXT = L_DESCRIPTION

EXCEPTIONS

NOT_FOUND = 1

OTHERS = 2.

I think it should solve your problem. Feel free to ask me if you have any question.

Regards,

Chetan Singh