topic Re: Internal table population in Application Development and Automation Discussions

Internal table population

Former Member — Tue, 19 Dec 2006 13:09:21 GMT

Here in this code the internal table it_mseg and it_mbew

are not being populated in the following code.Can anybody please tell me what the reason.

Thanks and regards

jyoti

SELECT mblnr

bwart

matnr

INTO TABLE it_mseg

FROM mseg.

IF it_mseg IS NOT INITIAL .

SELECT mblnr

bldat

INTO TABLE it_mkpf

FROM mkpf

FOR ALL ENTRIES IN it_mseg

WHERE mblnr = it_mseg-mblnr.

ENDIF.

IF it_mseg IS NOT INITIAL.

SELECT matnr

bwkey

bwtar

lbkum

INTO TABLE it_mbew

FROM mbew

FOR ALL ENTRIES IN it_mseg

WHERE matnr = it_mseg-matnr.

ENDIF.

Re: Internal table population

SantoshKallem — Tue, 19 Dec 2006 13:12:20 GMT

check at the bold one

SELECT mblnr

bwart

matnr

INTO TABLE it_mseg

FROM mseg.

IF it_mseg[ ] IS NOT INITIAL .

SELECT mblnr

bldat

INTO TABLE it_mkpf

FROM mkpf

FOR ALL ENTRIES IN it_mseg

WHERE mblnr = it_mseg-mblnr.

ENDIF.

IF it_mseg[ ] IS NOT INITIAL.

SELECT matnr

bwkey

bwtar

lbkum

INTO TABLE it_mbew

FROM mbew

FOR ALL ENTRIES IN it_mseg

WHERE matnr = it_mseg-matnr.

ENDIF.

Re: Internal table population

Former Member — Tue, 19 Dec 2006 13:12:45 GMT

try these..

1. use INTO CORRESPONDING FIELDS OF TABLE

2. use IF it_mseg[] IS NOT INITIAL

thx

pavan

Re: Internal table population

Former Member — Tue, 19 Dec 2006 13:14:47 GMT

Hi Jothi,

Can you check whether there exist data on the database through se16.

Regards,

Satya.

Re: Internal table population

Former Member — Tue, 19 Dec 2006 13:15:55 GMT

Please check if there exists some data in your table.

santhosh

Re: Internal table population

Former Member — Tue, 19 Dec 2006 13:16:54 GMT

Hi Jyoti,

Can you also mention the internal table definitions for it_mseg and it_mkpf and it_mbew...

Regards,

Biju

Re: Internal table population

Former Member — Tue, 19 Dec 2006 13:17:47 GMT

Use "F it_mseg[]S NOT INITIAL" in place of "IF it_mseg IS NOT INITIAL".

If u declared the itabs with all fields....include "into corresponding fields of table it_mkpf" in place of "INTO TABLE it_mkpf".

repeat the same for all select statements and if statements.

Cheers.

Re: Internal table population

Former Member — Tue, 19 Dec 2006 13:31:39 GMT

Hi,

Syntax of IF it_mseg IS NOT INITIAL is wrong

Please check this code.

DATA:it_mseg LIKE MSEG OCCURS 0 WITH HEADER LINE,

it_mkpf LIKE MKPF OCCURS 0 WITH HEADER LINE,

it_mbew LIKE MBEW OCCURS 0 WITH HEADER LINE.

SELECT mblnr bwart matnr

INTO CORRESPONDING FIELDS OF TABLE it_mseg

FROM mseg.

IF NOT it_mseg[] IS INITIAL .

SELECT mblnr

bldat

INTO CORRESPONDING FIELDS OF TABLE it_mkpf

FROM mkpf

FOR ALL ENTRIES IN it_mseg

WHERE mblnr = it_mseg-mblnr.

ENDIF.

IF not it_mseg IS INITIAL.

SELECT matnr

bwkey

bwtar

lbkum

INTO CORRESPONDING FIELDS OF TABLE it_mbew

FROM mbew

FOR ALL ENTRIES IN it_mseg

WHERE matnr = it_mseg-matnr.

ENDIF.