cancel
Showing results for 
Search instead for 
Did you mean: 

How to display table dynamically

Former Member
0 Kudos

Hi ,

I need to call a RFC from VC and if the returned table contains records then i need to display the result table ..if not i just need to display message telling that there are no matching records .. how can we do this in VC .. please help

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

You can add an export parameter to your rfc e.g. table entries as an integer. Then add a visibility condition to your table if the parameter is not 0 then display the table.

Best Regards,

Marcel

former_member209575
Contributor
0 Kudos

Hi

u can control the visibility of the table by taking one of the feild and writing formula BOOL(IF(field=="", false,true)). for showing the message u need to place one textbox in form and use this formula to control the visibility BOOL(IF(field=="", true,false)). right click on table and select configure element to get visibility condition.

Regards

Pradeep P N

Former Member
0 Kudos

HI Pradeep,

Thanks for your reply .. I know we can control the visibility of the table using the formula .. but my question is how to know if the result table returned by the RFC is empty or not.

Former Member
0 Kudos

Hi,

You can compare any mandatory column value(always data will be there for that column) with NULL .

Thanks

sreeni

Former Member
0 Kudos

I want to check if the number of rows in the result table is 0 .

Former Member
0 Kudos

But I don't think so you have the option to get the Size of the table.

If that is possible you can proceed.

But the workaround is to check any mandatory column value with NULL.

Thanks

sreeni

Former Member
0 Kudos

but by doing that how can i fulfill my requirement ??

Former Member
0 Kudos

Hi,

For the visibility property of the table put the Condtion like

Col_Value is NOT NULL -> data is there in the table, so display the table.

Thanks

Sreeni

Former Member
0 Kudos

Hi,

just try to use the Group operator with a Count on one of the field.

This will give as result the number of values returned.

Rgds,

Karim