internal table work area

[devrajsingh]

hello frds i hav i doubt in internal table work area

TYPES: BEGIN OF tab,

retriving LIKE zdv_empgui-empid,

empname LIKE zdv_empgui-empname,

dept LIKE zdv_empgui-department_code,

sal LIKE zdv_empgui-salary,

sex LIKE zdv_empgui-sex,

END OF tab.

DATA: itab TYPE tab OCCURS 10,

ITAB_WA TYPE TAB.

*==============================================

SELECT empid empname department_code salary sex

FROM zdv_empgui

INTO ITAB_WA.

this is giving rit result.

*============================================

SELECT empid empname department_code salary sex

FROM zdv_empgui

INTO CORRESPONDING FIELDS OF ITAB_WA.

In this case value of dept is not retriving and sal is coming as value 0.

rest all value is ok.

is there any diff make by adding CORRESPONDING FIELDS OF ?

[devrajsingh]

HI,

When using INTO CORRESPONDING FIELDS OF the field names of database table and internal table has to be same for correct results as said by Sudheer....

refer

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/select.htm

Regards,

Santosh

Message was edited by:

Santosh Kumar Patha

[Former Member]

Hi,

When you write the INTO CORRESPONDING FIELDS statment, the field name of the Database table and the Internal table shoulb be same.

Regards

Sudheer

[Former Member]

HI,

When using INTO CORRESPONDING FIELDS OF the field names of database table and internal table has to be same for correct results as said by Sudheer....

refer

http://www.sts.tu-harburg.de/teaching/sap_r3/ABAP4/select.htm

Regards,

Santosh

Message was edited by:

Santosh Kumar Patha

[devrajsingh]

ya thanks a lot

i m getting rit result by both

but y dis is

is there any reason?

[Former Member]

Along with the above suggestions, also make the highlighted change:

SELECT empid empname department_code salary sex

FROM zdv_empgui

INTO CORRESPONDING FIELDS OF <b>TABLE</b> ITAB_WA.

( If the names are same in the itab and the dbtab)

Regards,

Ravi

[Former Member]

Hi,

Also please try this instead of using CORRESPONDING FIELDS OF .

SELECT empid empname department_code salary sex
FROM zdv_empgui
INTO TABLE ITAB_WA
WHERE <your condition>.

Regards,

Ferry Lianto

[devrajsingh]

SELECT empid empname department_code salary sex

FROM zdv_empgui

INTO CORReSPONDING FIELDS OF ITAB_WA2

where salary = 123.

hi i tried the above exmple its working fine

y is there any <b>concept</b> of internal table?

[Former Member]

Hi,

SELECT empid empname department_code salary sex

FROM zdv_empgui

INTO (ITAB_WA-retriving,itab_wa-empname,itab_wa-dept,itab_wa-sal,itab_wa-sex).

Then u will get the answer. plz try it.

Rgds,

P.Suryanagi Reddy