topic Re: INTERNAL TABLE FILL in Application Development and Automation Discussions

INTERNAL TABLE FILL

Former Member — Tue, 26 Sep 2006 12:59:00 GMT

hi,

i am posting the select part of my code and would like to ask someone to look trough it and to check why my internal table isn't filling up???

thanx so much in advance!!!

code:

SELECT vbeln fkart fktyp vbtyp waerk vkorg vtweg knumv

fkdat gjahr poper zterm netwr kunrg mwsbk

zuonr kunag

INTO CORRESPONDING FIELDS OF TABLE it_hd

FROM vbrk

WHERE vbeln IN so_vbeln AND

erdat IN so_erdat.

IF vbrk-vbtyp = 'H' OR

vbrk-vbtyp = 'K' OR

vbrk-vbtyp = 'N' OR

vbrk-vbtyp = 'O' OR

vbrk-vbtyp = 'T' OR

vbrk-vbtyp = '6'.

wa_hd-bsart = 'CRME'.

ELSE.

wa_hd-bsart = 'INVO'.

IF sy-subrc <> 0.

WRITE: / 'Wrong IF statement'.

ENDIF.

Maja

Re: INTERNAL TABLE FILL

former_member189629 — Tue, 26 Sep 2006 13:01:11 GMT

append the table and clear the header

Re: INTERNAL TABLE FILL

ibrahim_u — Tue, 26 Sep 2006 13:02:00 GMT

Because of


INTO CORRESPONDING FIELDS OF TABLE it_hd

you must use


loop at it_hd.
IF vbrk-vbtyp = 'H' OR
it_hd-vbtyp = 'K' OR
it_hd-vbtyp = 'N' OR
it_hd-vbtyp = 'O' OR
it_hd-vbtyp = 'T' OR
it_hd-vbtyp = '6'.
wa_dhd-bsart = 'CRME'.
ELSE.
wa_hd-bsart = 'INVO'.
IF sy-subrc <> 0.
WRITE: / 'Wrong IF statement'.
ENDIF.
ENDIF.
endloop.

ibrahim

Message was edited by: Ibrahim UGUR

Re: INTERNAL TABLE FILL

Former Member — Tue, 26 Sep 2006 13:02:22 GMT

paste the declaration part of ur internal table.

Regards

Re: INTERNAL TABLE FILL

Former Member — Tue, 26 Sep 2006 13:03:02 GMT

Hi maja,

1. Ideally it should fill the data.

2. Just make sure of the following things :

a) it_hd has got the SAME FIELD Names

b) so_vbeln , so_erdat are select options

regards,

amit m.

Re: INTERNAL TABLE FILL

Former Member — Tue, 26 Sep 2006 13:03:53 GMT

here it is:

DATA: BEGIN OF wa_hd,

vbeln TYPE vbrk-vbeln,

gjahr TYPE vbrk-gjahr,

poper TYPE vbrk-poper,

fkart TYPE vbrk-fkart,

fktyp TYPE vbrk-fktyp,

vbtyp TYPE vbrk-vbtyp,

kunrg TYPE vbrk-kunrg,

fkdat TYPE vbrk-fkdat,

zterm TYPE vbrk-zterm,

invdue_date TYPE sy-datum,

vkorg TYPE vbrk-vkorg,

vtweg TYPE vbrk-vtweg,

waerk TYPE vbrk-waerk,

netwr TYPE vbrk-netwr,

mwsbk TYPE vbrk-mwsbk,

knumv TYPE vbrk-knumv,

zuonr TYPE ordnr_v,

kunag TYPE kunag,

bsart TYPE bsart ,

END OF wa_hd,

it_hd LIKE TABLE OF wa_hd.

Re: INTERNAL TABLE FILL

Former Member — Tue, 26 Sep 2006 13:12:45 GMT

It should work.

1.Check the names of fields of internal table and database table are same.

2.Check wether data exists for that particular conditio.

If still problem exists,

try checking by selecting all the records in that table without any conditions at the end.

Please check and let me know.

Regards

Re: INTERNAL TABLE FILL

Former Member — Tue, 26 Sep 2006 13:13:40 GMT

<b>WHERE vbeln IN so_vbeln AND

erdat IN so_erdat.</b>??

check with the values present in these 2 select-options in SE16 VBRK table.

i hope those 2 are SELECT-OPTIONS.

for testing purpose,dont give any values to those fields & test the SELECT return code in DEBUG ?

Regards

srikanth