Define table

[Former Member]

Hello Expert's,

i created one zreport in this report i used ekpo and mara table ,but i don't define the tables .

But i excuted this report all the records come my out put screen.

so sir which tables are define in a reports please tell me. I am very confuse.

Thanks

Ratnesh Ghursaria

[Former Member]

could you post the code you have written..

Thanks,

Adi

[Former Member]

Hi Ratnesh,

TABLES statement creates a structure with the same data type and the same name as a database table, a view, or a structure from the ABAP Dictionary.

TABLES statement is used if you want to define input/output fields on a screen with reference to database tables, views, or ABAP Dictionary structures .

Regards,

Goutham.

[Former Member]

Hi Ratnesh,

Not able to understand ur question can u explain it a bit more clearly and if possible provide the code along wid tht.

кu03B1ятu03B9к

[former_member191735]

Simply, Unless you want to use the fields of table on selection screen you dont have to use tables statement.

It is not required to define tables statement. if you want to define the table statement you can also define them using tables statement. Press F1 for help.

You can also define like: TYPES: MARA TYPE MARA. This statement also works in the same way that as tables statement

[Former Member]

Hi ,

To use an SAP database table for manipulation in your program you dont have to define the table in your program ..So, in ur case..the system recognises the two standard database tables and fetches the data from the tables.

Regards

Vasavi Kotha

[Former Member]

Hi Ratnesh ,

Tables decleration is not necessary if you want to select data from the tables . What the decleration tables does is that it creates a work area for that table in your program which can be accessed with the same name as the table .

Now a days tables decleration is used when you need to declare select options , this also can be avoided , but in that case you will have to provide F4 help for the select options in the program.

Regards

Arun

[nkr1shna]

Hi Ratnesh,

When you use select statement using INTO clause there is NO need to define tables statement in the program.

In your case you must have created internal tabe containing fields from two SAP tabes and must be using "select field1 field2 into <interna table> from .... construct.

In this case there is no need to define "Tabes" statement in the report.

Regards

Krishna

[Former Member]

Hi Ratnesh,

It is not at all necessary to get output from ekpo and mara table that you should declare these table through tables statement.

Tables Statement is required when you are using Select-Options or Parameters statement refering database field and fetching data from database table where <Tablename> = value entered in selection screen.

By declaring Tables you are telling runtime environment that you will be using a structure same as of type mara or ekpo.

For eg. for the following piece of code to work, a declaration Tables: mara is must

data: v_mtart type mtart.

select-options v_matnr for mara-matnr.

select mtart

from mara

into v_mtart

where matnr in v_matnr.

endselect.

Regards

Vinod

[Former Member]

Hi,

Tables decleration is not necessary if you want to select data from the tables . What the decleration tables does is that it creates a work area for that table in your program which can be accessed with the same name as the table .

When you use select statement using INTO clause there is NO need to define tables statement in the program.

TABLES statement creates a structure with the same data type and the same name as a database table, a view, or a structure from the ABAP Dictionary.

TABLES statement is used if you want to define input/output fields on a screen with reference to database tables, views, or ABAP Dictionary structures .

Regards,

Jyothi CH.