How to list all the rows from the table VBAK

[Former Member]

Friends ,

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

[bpawanchand]

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

[Former Member]

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.

[former_member181995]

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!

[Former Member]

Friends,

Thanks for your replies.Its a general question. As vbak has many fields is there a way to extract all the fields of the table without manualy entering from our end in the Write Statement. such as w_vbak-vbeln etc....we may required to write all the fields in the table.

or is there any way to extract complete rows from the table Vbak.

[bpawanchand]

Hi

well you can download the list of all fields from se11

goto se11-->VBAk->F7-> CTRLSHIFTF10->EDIT---> DOWNLOAD

it will ask you in which format you need to download select it and press enter

Regards

Pavan

[Former Member]

Thanks.

[Former Member]

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.