Hi All,
I'm having an annoying problem.
I've created a table for Z_EMPL_CAT "Employee category" (Fields: CLIENT, CATEGORY(CHAR10) and DESCR(CHAR20).
I've created a domain for Z_M_CATEGORY and I've set table Z_EMPL_CAT it's "Value Table".
I've also created a Search Help "Z_H_CATEGORY" and configured it as follows:
- Selection Method: Z_EMPL_CAT
- FIELD CATEGORY - IMPORT(X), EXPORT(X), LP(1), SP(1)....
- FIELD DESCR - IMPORT( ), EXPORT( ), LP(2), SP(2)....
I've also created a data element Z_D_CATEGORY (based on domain Z_M_CATEGORY) and I set search help Z_H_CATEGORY with parameter CATEGORY.
I've created a maintenance view for table Z_EMPL_CAT. As for now - everything is ok - if i press F4, search help popup is displayed showing both; category and description - as below:
-
Category Description
-
TEMP Temporary employee
FULL Full time employee
HALF Half time employee
-
I created another table Z_EMPL_CAT_PARM (Employee category parameters) Fields: (CLIENT, CATEGORY, WORK_DAYS, WORK_HOURS). (This table defines how many work days per week is per category and how many work hours per work day).
When I generated maintenance view and run it through SM 30, upon pressing F4 for CATEGORY field, I get nice popup with both fields again
-
Category Description
-
TEMP Temporary employee
FULL Full time employee
HALF Half time employee
-
Now, PROBLEM starts. I had to create Z_EMPLOYEE table: (Fields CLIENT, EMPL_ID, NAME, AGE, CATEGORY). It's pretty simple but customer asked me to display category description next to CATEGORY field automatically, when someone enters the data. So what I did, is i created a new maintenance view Z_V_EMPLOYEE and joined tables Z_EMPLOYEE with Z_EMP_CAT on CATEGORY field. Now , my maintenance view has following fields (EMPL_ID, NAME, AGE, CATEGORY and DESCR (from table Z_EMPL_CAT - set as read only).
When I generated Maintenance view, I found out that view itself is working perfectly and Description is automatically filled upon CATEGORY field data entry. PROBLEM is with search help for CATEGORY field, now, when I press F4 for it, my search help popup shows only one field - CATEGORY.
-
Category
-
TEMP
FULL
HALF
-
I don't know how to solve this as this Search help is obviously correct as it's working fine if I'm using it with table Z_EMPLPARM. When i use it with MAINTENANCE view Z_V_EMPLOYEE - search help data are incomplete.
Any ideas?