Skip to Content
0
Former Member
Feb 11, 2011 at 03:40 AM

Different Search help behaviour if run for table and for maintenace view

70 Views

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?