topic Re: Issue with Reference table/ALV in Application Development and Automation Discussions

Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 06:26:55 GMT

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

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 06:53:40 GMT

Hi Ethan ;

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

Regards.

Özgün

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 07:02:21 GMT

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,

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 07:13:31 GMT

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

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 07:20:22 GMT

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

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 09:14:53 GMT

Hi,

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

This might be a conversion exit issue.

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 09:21:01 GMT

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

Regards,

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 09:43:00 GMT

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

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 10:00:27 GMT

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'.

Re: Issue with Reference table/ALV

ipravir — Mon, 10 Aug 2015 10:03:08 GMT

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,

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 10:06:35 GMT

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,

Re: Issue with Reference table/ALV

ipravir — Mon, 10 Aug 2015 10:13:59 GMT

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.

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 10:29:27 GMT

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

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 10:33:57 GMT

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.

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 11:11:57 GMT

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,

Re: Issue with Reference table/ALV

ipravir — Mon, 10 Aug 2015 12:12:07 GMT

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.

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 12:24:17 GMT

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

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 13:08:37 GMT

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

Re: Issue with Reference table/ALV

Former Member — Mon, 10 Aug 2015 13:10:02 GMT

I am getting as program does not exist

Re: Issue with Reference table/ALV

ipravir — Mon, 10 Aug 2015 14:02:42 GMT

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.