Display Text in table when no matching records found...

[dhruv_shah3]

Hi,

I am fetching the records from the R/3 to VC using a Bapi.

Now i want that if no records are fetched from the R/3 then "No Birthday Today" should be displayed in the Table.

Pls guide me..

Thanks & Regards,

Dhruv Shah

[Former Member · Accepted solution]

Dhruv,

please can you explain in more detail.

points should have already been rewarded !

[Former Member]

Dhruv,

test the bapi from transaction se37, check the return table there is a field called Message number, what message number you get when the table is empty and what message number do you get when the the table is full ?

Regards,

Ahmed Salah

Please reward points if usefull

[dhruv_shah3]

Hi,

I have appended the Message my self in the RETURN Table.

And now i have achieved this, but now problem is that when i am clicking on the iview then another view is opened which i have kept.

So i think that some visibility condition is violated.

So can you pls guide me now.

Points will be rewarded.

Thanks & Regards,

Dhruv Shah

[Former Member]

Dhruv,

Where are you returning the result of this function you mentioned and in which format.

Regards,

Ahmed

[dhruv_shah3]

Hi,

BAPI is returning the message if no records found in the RETURN Table as return parameter.

And if records are found then its displaying it successfully.

[Former Member]

Dhruv,

Youcan use the following formulae :

if the field name is Birthday.

IF(ISNULL(@Birthday),’No Birthday Today’, @Birthday)

Regards,

Ahmed Salah

Please Reward Points if Usefull

[dhruv_shah3]

HI,

When i am fetching the data from the R/3 there is no field name like Birthday.

I am checking the User ID of the Portal Login and based on that my BAPI searches for the Record of the employees who are in that user company and shows the birthday of the employees.

And if i select all company then display all the employees who has birthday which matches the Application Server Date.

So, now my question is for E.g Today in company nobody has birthday, then in table it should display the Message. "No Birthday Today".

Thanks & Regards,

Dhruv Shah