Issue with Reference table/ALV

[Former Member]

Hi All,

I am facing a weird issue in Table -> ALV.

In ALV I am using VNAME: Joint Venture, Table: T8JV..., EGRUP: Equity Group, table: T8JF.

For both the table, I am passing a dummy values for Joint Venture and Equity group. But in ALV, when I pass the Joint Venture as 100000 and Equity group as L01 (these values I am passing to the table.) When i click on F4 of Equity group field, I am getting error as
NO INPUT HELP IS AVAILABLE.

Please check the screenshot.

Let me know where I am missing.

Regards,

Kiran

[Former Member]

Hi Ethan ;

You can check EGRUP field with BSEG table , if you add L01 you will see with search help button.

Regards.

Özgün

[Former Member]

Hi,

For EGRUP in BSEG table,its check table is T8JF, I already added an entry in T8JF table.

Please check my 1st screenshot.

Regards,

EH

[Former Member]

Pls use T8JFT table for adding EGRUP field to the ALV.I think you can display the search help with this table.

[Former Member]

I used that T8JFT table also, Same error as mentioned in 3rd Screenshot. And that`s why I mentioned this issue as WEIRD .

[Former Member]

Hi,

Have you passed values for field -Joint venture in fieldcatalog fields -> ' REF_FIELDNAME ' and  ' REF_TABNAME'.

This might be a conversion exit issue.

[Former Member]

I did that as well in ALV field catalog. Still the same error.

Regards,

EH

[Former Member]

HI,

Kindly share the code where the fieldcatalog is built for the fields BUKRS, VNAME & EGRUP.

Based on the error message we guess the company code is not passed to the input parameters that is reason why you must be getting the error as in 3rd screenshot.

Regards,

Vasanth

[Former Member]

HI Kumar,

You are right on BUKRS is giving trouble. I do not know how to find it because I am not getting any error from BUKRS side.

Here is the piece of code I am using in fieldcat.

  g_fcat-coltext    = text-f92.

  g_fcat-fieldname  = 'VNAME'.

  g_fcat-ref_table  = 'T8JV'.

  g_fcat-coltext    = text-f93.

  g_fcat-fieldname  = 'EGRUP'.

  g_fcat-ref_table  = 'T8JF'.

  g_fcat-coltext    = text-f94.

  g_fcat-fieldname  = 'RECID'.

  g_fcat-ref_table  = 'Custom table of mine'.

[Former Member]

Hi Ethan,

If you don't have field BUKRS in the our ALV table. You can add that field as an hidden field and populate the value as per the requirement. your search help and validation will be based on the combination of BUKRS VNAME and EGRUP always.

Regards,

Vasanth

[Former Member]

I am sorry Vasath. We do have BUKRS column in ALV

   g_fcat-coltext    = text-f22.

   g_fcat-fieldname  = 'BUKRS'.

*  g_fcat-f4availabl = 'X'.

   g_fcat-ref_table  = 'Custom table'.

Let me know what I can next.

[Former Member]

Hi Ethan,

I don't have any test data for this table to check immediately.

try the below options in the field catalog

fcat-coltext = 'Bukrs'.

fcat-fieldname = 'BUKRS'.

fcat-ref_table = 'T8JF'

fcat-ref_field  = 'BUKRS'.

fcat-coltext = 'Joint venture'.

fcat-fieldname = 'VNAME'.

fcat-ref_table = 'T8JF'.

fcat-ref_field  = 'VNAME'.

fcat-coltext = 'Equity group'.

fcat-fieldname = 'EGRUP'.

fcat-ref_table = 'T8JF'.

fcat-ref_field   = 'EGRUP'.

Regards,

Vasanth

[Former Member]

No Vasanth. I used your codes in field Catalog, I am getting No Input Available popup when i click on F4 help.

[Former Member]

HI Ethan,

Try using the ref table in the above field catalog code to T8JFT instead for all the fields. just checked the field T8JF-EGRUP has no Search help so it should have said no input available.

If still not working kindly show the screen shot of values in all the three fields which you are passing and also code of any events and the call to method SET_TABLE_FOR_FIRST_DISPLAY.

Regards,

Vasanth

[ipravir]

Hi,

Have you written the code for F4 help for the respective column by using ONF4 event of cl_gui_alv_grid class?

and is there any CHECKTABLE information maintained in LVC_S_FCAT for the same?

Regards,

Praveer,

[Former Member]

Hi,

We have CHECKTABLE in LVC_S_FCAT structure. And I am not maintaining any F4 event.

But does it helps to resolve my issue?

Regards,

EH

[ipravir]

Hi Ethan,

In cl_gui_alv_grid, you have to write code for the F4 help, then only you will get the proper data in F4 selection.

You can refer : BCALV_EDIT_08 demo program for more information about F4 help in ALV grid.

Regards,

Praveer.

[Former Member]

Hi Praveer,

Apart from your solution of using OOPS, couldnt it possible to do by passing reference table/check table to ALV`s field catalog?

Regards,

EH

[ipravir]

Hi Ethan,

You can refer BCALV_TEST_FULLSCREEN_EDIT program, which is having same kind of solution.

While execute select editable option.

In output, you will get option to select airline in F4 option.

And by selection of any value, the same will set in respective fields.

Regards,

Praveer.

[Former Member]

I am getting as program does not exist

[ipravir]

What is your ECC and Netweaver version.

You can check with below programs.

BCALV_FULLSCREEN_GRID_EDIT

BCALV_TEST_FULLSCREEN_EDIT 

BCALV_TEST_GRID_EDIT2 

All above program are contains the same kind of solution.

Regards,

Praveer.