Skip to Content
avatar image
Former Member

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Jul 08, 2009 at 09:09 AM

    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

    Add comment
    10|10000 characters needed characters exceeded

    • 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

  • avatar image
    Former Member
    Jul 08, 2009 at 09:12 AM

    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.

    Add comment
    10|10000 characters needed characters exceeded