topic Re: internal table work area in Application Development and Automation Discussions

internal table work area

devrajsingh — Tue, 03 Apr 2007 15:00:27 GMT

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 ?

Re: internal table work area

Former Member — Tue, 03 Apr 2007 15:09:55 GMT

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

Re: internal table work area

Former Member — Tue, 03 Apr 2007 15:13:52 GMT

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

Re: internal table work area

Former Member — Tue, 03 Apr 2007 15:18:06 GMT

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

Re: internal table work area

devrajsingh — Tue, 03 Apr 2007 15:30:39 GMT

ya thanks a lot

i m getting rit result by both

but y dis is

is there any reason?

Re: internal table work area

ferry_lianto — Tue, 03 Apr 2007 15:35:12 GMT

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

Re: internal table work area

devrajsingh — Wed, 04 Apr 2007 02:43:10 GMT

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?

Re: internal table work area

Former Member — Wed, 04 Apr 2007 05:20:39 GMT

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