Skip to Content
author's profile photo Former Member
Former Member

doubt in Internal table

Hi All.

I have one internal table like itab.

data:itab like ekpo with header line.

i have to delete some records from Itab which records have EKPO_WERKS is blank.

help me.

Thanks.

jay

Add a comment
10|10000 characters needed characters exceeded

Related questions

6 Answers

  • Best Answer
    Posted on May 30, 2007 at 03:19 PM

    Hi Jay,

    Please try this.

    DELETE ITAB WHERE ( WERKS IS INITIAL OR WERKS EQ SPACE ) AND
                      ( AUFNR IS INITIAL OR AUFNR EQ SPACE ).
    

    Regards,

    Ferry Lianto

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on May 30, 2007 at 03:00 PM

    Hi,

    Please try this.

    DELETE ITAB WHERE WERKS IS INITIAL OR
                      WERKS EQ SPACE.
    

    Regards,

    Ferry Lianto

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Ferry.

      I have one internal table it has number of field referd from diffrent table .

      data:begin of wa,

      EBELN type EKPO-EBELN

      BUKRS type EKPO-BUKRS

      WERKS type EKPO-WERKS

      AUFNR type EKKN-AUFNR

      end of wa.

      data:itab like WA with header line.

      now i need to delete records from itab which records with blank in EKPO_WERKS

      and records with blank in EKKN_AUFNR.

      please help me.

      Thanks.

      Jay

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2007 at 02:52 PM

    delete itab where werks is initial.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2007 at 02:55 PM

    Try

    Delete <internal table> where WERKS IS initial.

    Regards

    Tushar Mundlik

    Message was edited by:

    Tushar Mundlik

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2007 at 02:55 PM

    hi,

    do this way ..

     delete it_marc where werks = SPACE. 

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on May 30, 2007 at 03:41 PM

    Hi Ferry.

    I have one more doubt.I have one internal table.i need to find number of records .if it has more then one ,i need fetch that record based on EBELN.

    please help me.

    Thanks.

    Jay

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.