topic Re: Syntax SQL in Application Development and Automation Discussions

Syntax SQL

Former Member — Thu, 24 Apr 2008 15:06:18 GMT

Simple request.

I want to write a program, ie

SELECT * FROM tbl1

OUTPUT TO SCREEN.

What is the ABAP syntax.

Thanks

Re: Syntax SQL

Former Member — Thu, 24 Apr 2008 15:07:15 GMT

Hi Abu,

SELECT * 
  FROM table1
  INTO TABLE itab.

LOOP AT itab.
  write:
    / 'Field 1 : ', itab-field1,
      'Field 2 : ', itab-field2,
      'Field 3 : ', itab-field3.
ENDLOOP.

Regards,

Sunil

Re: Syntax SQL

Former Member — Thu, 24 Apr 2008 15:11:04 GMT

whats the syntax for declaring itab.

Thanks

Re: Syntax SQL

Former Member — Thu, 24 Apr 2008 15:11:12 GMT

hi,


 SELECT * FROM tbl1 into table itab where <conditions>.
 if sy-subrc = 0.
 endif.

 loop at itab.
    write: itab-fld1,
            itab-fld2,
............. 
 endloop.

Re: Syntax SQL

Former Member — Thu, 24 Apr 2008 15:12:14 GMT

hi,

data : itab type standard table of tbl1.

Re: Syntax SQL

Former Member — Thu, 24 Apr 2008 15:13:30 GMT

Hi Abu,

The Syntax for declaring itab is;

DATA:
  BEGIN OF itab OCCURS 0,
     Field1      TYPE i,
     Field2(10) TYPE c,
     Field3(5)   TYPE n,  
  END OF itab.

DATA:
     itab TYPE TABLE OF table1.

Regards,

Sunil

Re: Syntax SQL

Former Member — Thu, 24 Apr 2008 15:17:45 GMT

Hi,

types declaration

types: begin of ty_mara,

matnr type mara-matnr,

mbrsh type mara-mbrsh,

end of ty_mara.

*data declaration

data : it_mara type table of ty_mara, "body

wa_mara type ty_mara. " workarea

start-of-selection.

SELECT matnr mbrsh

FROM mara

INTO TABLE it_mara.

end-of-selection.

LOOP AT it_mara into wa_mara.

write:

/ 'Matnr : ', wa_mara-matnr,

'Mbrsh : ', wa_mara-mbrsh.

ENDLOOP.

Reward points if helpful.

thanks and regards.

Re: Syntax SQL

Former Member — Thu, 24 Apr 2008 15:17:45 GMT

hi check this..

tables: mara .

data: itab like mara occurs 0 with header line .

select * from mara into table itab .

if sy-subrc = 0.

loop at itab .

write:/ itab-matnr ,

itab-meins,

itab-mtart .

endloop.

endif.

regards,

venkat.

Re: Syntax SQL

Former Member — Thu, 24 Apr 2008 16:06:39 GMT

I wrote this:

DATA:

itab TYPE STANDARD TABLE OF HRHAP,

wa_hap type itab.

SELECT *

FROM HRHAP

INTO TABLE itab.

LOOP AT itab INTO wa_hap.

write:

/ 'Field 1 : ', wa_hap-APPRAISAL_ID,

'Field 2 : ', wa_hap-AP_START_DATE,

'Field 3 : ', wa_hap-AP_END_DATE,

'Field 2 : ', wa_hap-AP_STATUS,

'Field 3 : ', wa_hap-AP_STATUS_SUB,

'Field 2 : ', wa_hap-AP_OBJ_DATE_SET.

ENDLOOP.

Error: The data object WA_HAP does not have a component called 'APPRAISAL_ID'.

APPRAISAL_ID is a component of HRHAP.

Thanks

Re: Syntax SQL

Former Member — Thu, 24 Apr 2008 16:12:37 GMT

hi check this...

tables : hrhap .

DATA:

itab TYPE STANDARD TABLE OF HRHAP with header line,

wa_hap type hrhap.

SELECT *

FROM HRHAP

INTO TABLE itab.

LOOP AT itab into wa_hap .

write:

/ 'Field 1 : ', wa_hap-APPRAISAL_ID,

'Field 2 : ', wa_hap-AP_START_DATE,

'Field 3 : ', wa_hap-AP_END_DATE,

'Field 4: ', wa_hap-AP_STATUS,

'Field 5 : ', wa_hap-AP_STATUS_SUB,

'Field 6 : ', wa_hap-OBJ_DATE_SET.

ENDLOOP.

regards,

venkat