Key Values for the Objects in SAP HR

[former_member568294]

Hi Friends,

In an incident, we have an excel sheet with objects like Function, Directorate & Cluster etc.,We need the Key Values for all those objects instead of Text Description for loading the data from SAP  to Excel Sheet. In SAP System where do we find those key values for the above said objects? We have some 25 Objects in the excel sheet.

Kindly let me know the solution for this.

Thanks & Regards,

Sreekanth

[former_member568294]

Hi Kedhar,

you mean key value is the length of field like for Emp Group-Length 1 & for Start Date & End Date-Length 8 etc. Is it right?

[Former Member]

Yes & also the data type of field (like char/num/datum).

[former_member568294]

In my query, they want the key values for the fields mentioned in the excel sheet. They dont want the textual description like Start Date, End Date, First Name & Last Name etc.

Thanks & Regards,

Sreekanth

[former_member568294]

Hi Kedhar,

Thanks for your timely response on the issue. I just want to know what is the Key Value for a Field like Start Date & End Date, Emp Group etc.,?

[Former Member]

For Start date it is in date format & for End date also & for Emp group it is any one CHAR,

like this you need to find out in se11.

Hope this clarifies you. Other wise you just try to make entry in field for knowing what is key value for it.

If you want the drop down list of those one's then you need go for config for those value & like in org unit these are system generated number ranges as per config.

:Kedhar         

[former_member568294]

Hi Rajesh,

Thanks for responding the issue. My query is how to get the numerical values(key values) from SAP System for the fields Start Date, End Date, Emp Group , Org Unit etc., F.E:- Org Unit-Key value is 10002776 etc., Where do we get these key values for the fields that I have in the excel sheet?

[former_member182306]

Find in SE11 giving fields PERNR for employee no

[Former Member]

Hi

You can check that structure field value in se11, for ex for info type 0001, go to se11 & take P0001 and under org unit  you will find the Field length & data type based on that you need to find.

[former_member182306]

To Load the objects in an excel You will find an icon to save it as excel sheet on the top left corner of SAP Screen