Skip to Content
avatar image
Former Member

How to list all the rows from the table VBAK

Friends ,

How to list all the rows from the table VBAK.select query and the output list is appreciated.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

5 Answers

  • Best Answer
    Sep 01, 2008 at 12:07 PM

    Are you looking only for sales order?

    than pls go for VA05 transaction it will generates a linst for you.cause am worried about select * from vbak without any condiation!

    Add comment
    10|10000 characters needed characters exceeded

  • Sep 01, 2008 at 12:05 PM

    Hi

    tables :
       VBAK.
    data :
       t_vbak type standard table of VBAK,
       w_vbak like line of t_vbak
    select
        *
    from vbak
    into t_vbak.
    
    loop at t_vbak into w_vbak.
       write :
        / all fields
    endloop.

    Regards

    Pavan

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 12:06 PM

    Hi,

    IF you want to select all the rows for VBAK-

    Write-

    Data:itab type table of VBAK,

    wa like line of itab.

    SELECT * FROM VBAK into table itab.

    Itab is the internal table with type VBAK.

    Loop at itab into wa.

    Write: wa-field1,

    ..........

    ..........

    endloop.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 12:27 PM

    Thanks.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Sep 01, 2008 at 12:33 PM

    You can do this just go to pattern . click on structured data object give the table name as vbak a screen will be displayed there just select all the fields of vbak and click on copy it will ask you the structure name give it as wa_vbak. You will all the fields populated with wa_vbak-mandt to last field. after that you can remove data. hope this will help you.

    Add comment
    10|10000 characters needed characters exceeded