Is it possible to let user restrict the number of the records in OVS?

[Former Member]

is it pissible ?

For example a user can input 500 record .....

Then when we search and we can get the value set by the user '500' so we can restrict our record in our application.

Best regards,

Anders

[shaik_sajid · Accepted solution]

Dear Anders Hejlsberg

for OVS, u will be writing ur code in a method...

in this method u can write

select ....from <table> upto 500 rows into ...where........

Regards

Sajid

[Former Member · Accepted solution]

Dear Sajid,

if the user want to set 200 as the number, does he has change the code so he can change the max count from 500 to 200?

Best regards,

Anders.

[shaik_sajid · Accepted solution]

Dear Anders,

u can have an i/p field (say var) for the user where he can specify the no. of records and u can use the following logic.

TYPES: BEGIN OF ST_BOQ,
          ITEMNO       TYPE ZITEMNO,
          MATNR        TYPE MATNR,
          MAKTX_P      TYPE ZPOTEXT,
           SRNO         TYPE ZSERIALNO,

       END OF ST_BOQ.

DATA: IT_BOQ TYPE TABLE OF ST_BOQ,
      WA_BOQ LIKE LINE  OF IT_BOQ.

data: var1 type i.

var1 = 10.

        SELECT * FROM ZBOQ_ITEM UP TO var1 rows INTO CORRESPONDING FIELDS OF TABLE IT_BOQ .

Regards

Sajid

[Former Member]

Hi,

Yes, its possible with OVS. Check out the below bolg on how to implement OVS step by step.

[https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/9502] [original link is broken] [original link is broken] [original link is broken];

Regards,

Manne.