Birthday Field in User Window

[Former Member]

Hi all,

When i Run the Query "Select * From OUSR", i can see the Field Birthday present in the Result.

But when i See the User Table in SAP , i could not find the Birthday Field.

Where could be that Field present ?

Thanks

Gopi Krishnan

[Former Member]

Hi Gopi,

Not all fields in user tables have UI exposure. Birthday is only one of them.

Thanks,

Gordon

[Former Member]

Hi Gopi,

You will get this feild in OHEM table you need to create user and link the user code to the OHEM and fill the master (Employee Master data) then may u wil get the desired result.

Regards,

Bhushan verma

[kothandaraman_nagarajan]

Hi,

There are few more fields from OUSR table does not appeared in user window like Maximum discount etc.

In general all B1 tables are related with each other. Link OUSR and OHEM table to get birthday of user.

[Former Member]

[former_member184146]

Hi Gopi,

               in SAP the birthday column should come as empty column as it has no data.

--Manish

[former_member205766]

Hi

Check the below link 

With Regards

Balaji

[former_member188586]

HI Gopi

Try This Query

SELECT T0.[Birthday] FROM OUSR T0

[former_member184146]

Hi,

     can you post your SQL query result??

Regards,

Manish