Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Employee Master Data

hi!

The problems as follow:

1. How I can create a View Child button in the Personal tab ?

2. After clicking View Child button, how the system only can display the 1-1 employee information ( Employee No 1à only show his/her child not show all Employeeu2019s child in the company)

3. Which method or SQL command to use for ADD NEW & UPDATE button in the List Childu2019s Employeesu2019 Form?

[[IMG]http://img402.imageshack.us/img402/8409/huynhhf3.png[/IMG] | http://imageshack.us]

[[IMG]http://img402.imageshack.us/img402/huynhhf3.png/1/w1019.png[/IMG] | http://g.imageshack.us/img402/huynhhf3.png/1/]

Edited by: Huynh Nguyen on Oct 2, 2008 11:36 AM

replied

Hello,

1.Set the property FromPane and ToPane Item as 4 for the View Children Button when adding it in the form load

2.Draw the children form with grid binding with the DataTable. Filter the grid by condition of parent

Set oDataTable = oForm.DataSources.DataTables.Item(m_DataTableUid)
'replace the U_**** and 88888 accordingly
queryStr = "Select U_***, U_**** from [@MY_UDT] WHERE U_parent='88888' "
oDataTable.ExecuteQuery queryStr

3.It is up to you.

Insert or Update SQL

Hope it helps. Thanks.

Kind Regards

-Yatsea

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question