topic Re: Retrieving records in Application Development and Automation Discussions

Retrieving records

Former Member — Fri, 13 Jul 2007 11:10:54 GMT

Hi,

How to retrieve all the customers where country key is u.s

display all the records where customer name starts with 'A'.

Re: Retrieving records

Former Member — Fri, 13 Jul 2007 11:15:37 GMT

select *

from KNA1

into table it_kunnr

where LAND1 = 'US'.

loop at it_kunnr.

if it_kna1-name1 cp 'A*'.

Display record....

endif.

endloop.

Re: Retrieving records

Former Member — Fri, 13 Jul 2007 11:17:34 GMT

HI,

u can write like this.

tables:lfa1.

select * from lfa1 where land1 = 'IN'.

if lfa1-name1 Cp 'C*'.

write:/5 lfa1-kunnr,20 lfa1-name1.

endif.

ENDSELECT.

rgds,

bharat.

Re: Retrieving records

Former Member — Fri, 13 Jul 2007 11:18:04 GMT

use the below code

select * from <table> into table <it> where country key = 'US' and kunnr = 'A%'.

Reward points if USEFUL

Re: Retrieving records

Former Member — Fri, 13 Jul 2007 11:20:01 GMT

hi,

try like this.

SELECT * FROM KNA1 INTO TABLE IT_KNA1 WHERE NAME1 LIKE 'A%'

retrieves all records starting with A----

SELECT * FROM KNA1 INTO TABLE IT_KNA1 WHERE NAME1 LIKE 'A_'

retrives all record starting with A------

if helpful reward some points.

with regards,

Suresh.A

Re: Retrieving records

Former Member — Fri, 13 Jul 2007 11:23:56 GMT

Hello,


DATA: BEGIN OF itab OCCURS 0,
        lifnr TYPE lifnr,
      END OF itab .

DATA: wa_itab LIKE LINE OF itab.

SELECT lifnr FROM kna1
       INTO TABLE itab
       WHERE land1 = 'US'.

IF sy-subrc = 0.

  LOOP AT itab INTO wa_itab WHERE lifnr+0(1) eq 'A'.
    WRITE:/ wa_itab-lifnr.
  ENDLOOP.

ELSE.

  WRITE:/ 'No data found' .

ENDIF.

Regards,Deepu.k

Re: Retrieving records

Former Member — Fri, 13 Jul 2007 11:44:35 GMT

HI,

I wrote the program like this.

DATA:

FS_EMP TYPE KNA1,

IT_EMP TYPE TABLE OF KNA1,

KUNNR TYPE KUNNR.

SELECT KUNNR FROM KNA1 INTO FS_EMP WHERE LAND1 = 'US'.

APPEND FS_EMP TO IT_EMP.

ENDSELECT.

Now i want to check the result when i execute. plz let me know.

Re: Retrieving records

seshatalpasai_madala — Fri, 13 Jul 2007 12:11:53 GMT

Hi,

DATA:

FS_EMP TYPE KNA1,

IT_EMP TYPE TABLE OF KNA1,

KUNNR TYPE KUNNR.

<b>SELECT KUNNR FROM KNA1 INTO CORRESPONDING FIELDS OF TABLE IT_EMP WHERE LAND1 = 'US'.

IF IT_EMP IS NOT INITIAL.

LOOP AT IT_EMP INTO FS_EMP.

WRITE: FS_EMP-KUNNR.

ENDLOOP.

ELSE.

WRITE: 'Nothing Found'.</b>

ENDIF.

Regards,

Sesh

Re: Retrieving records

Former Member — Fri, 13 Jul 2007 12:18:19 GMT

SELECT *

FROM KNA1

INTO TABLE ITAB

WHERE KNA1-KUNNAR =

AND KNA1-LAND1 = 'US.

YOU WILL GET RETRIVE DATA FROM DTABLE

Re: Retrieving records

Former Member — Fri, 13 Jul 2007 12:18:24 GMT

Hi Ram,

try this out,

DATA:

FS_EMP TYPE KNA1,

IT_EMP TYPE TABLE OF KNA1,

KUNNR TYPE KUNNR.

SELECT * FROM KNA1 INTO FS_EMP WHERE LAND1 = 'US'.

APPEND FS_EMP TO IT_EMP.

ENDSELECT.

CLEAR FS_EMP.

LOOP AT IT_EMP INTO FS_EMP.

IF FS_EMP-KUNNR+0(1) EQ 'A'.

WRITE:/ FS_EMP-KUNNR.

ENDIF.

ENDLOOP.

<b>

Reward points if this helps,</b>

Kiran