Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

how to get a data from a table

Former Member
0 Likes
1,003

hi

i want to know how to retrive a data from table

for example in b/s sundry liabilities is there then how to write or refere to any table that balance will retrive

thanks in advance

hi

i want to know how to retrive a data from table

for example in b/s sundry liabilities is there then how to write or refere to any table that balance will retrive

thanks in advance

6 REPLIES 6
Read only

Former Member
0 Likes
933

Hi Santosh,

To retrive data from a table you can use the 'SELECT' statement. You can check with F4 over the command the help manual from abap editor.

Regards,

Paulo Sousa

Read only

0 Likes
933

use - Select keyword..

press F1 on select keyword ..

e.g -

tables zgill_main.

data: begin of itab occurs 0.

include structure zgill_main.

data end of itab.

SELECT * FROM zgill_main INTO TABLE itab .

Read only

Former Member
0 Likes
933

Hello,

Use SELECT statement to get the data from a table.

data: itab like mara occurs 0 with header line.

select * from mara into table itab.

If useful reward

Vasanth

Read only

Former Member
0 Likes
933

hi Santosh,

welcome to SDN ..

use <b>Select</b> statment for data retrival read help to know more ..

data: lt_vbfa   type standard table of ly_vbfa
                initial size 0 with header line.

types: begin of ly_vbfa,
         vbeln  type vbeln_nach,
         vbtyp  type vbtyp,
         vbelv  type vbeln_von,
         erdat  type erdat,
         erzet  type erzet,
       end of ly_vbfa.

    select vbeln vbtyp_v vbelv erdat erzet
      from vbfa
      into table lt_vbfa
      for all entries in c_t_data
     where vbeln = c_t_data-vbeln

Read only

Former Member
0 Likes
933

which report is that??

I guess u are talking about balance sheet report

try checking in BSEG table

Read only

Former Member
0 Likes
933

Thanks