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

Fill Internal table

Former Member — Fri, 04 Aug 2006 10:29:14 GMT

Hello,

in my program i can't fill and send contents of my internal table. my code looks like this:

...

TABLES:

MKPF,

MSEG.

TYPES: BEGIN OF ST_2,

F_1 LIKE MKPF-MANDT, " For MKPF~MANDT,

F_2 LIKE MKPF-MBLNR, " For MKPF~MBLNR,

F_18 LIKE MSEG-ZEILE, " For MSEG~ZEILE,

F_19 LIKE MSEG-LINE_ID, " For MSEG~LINE_ID,

END OF ST_2.

DATA: it_1 TYPE TABLE OF ST_2,

wa_it LIKE LINE OF it_1.

FORM get_data.

SELECT

MKPF~MANDT

MKPF~MBLNR

*etc

MSEG~ZEILE

MSEG~LINE_ID

*etc

INTO wa_it

FROM

MKPF AS MKPF

INNER JOIN

MSEG AS MSEG

ON MKPF_{MANDT = MSEG}MANDT AND

MKPF_{MBLNR = MSEG}MBLNR AND

MKPF_{MJAHR = MSEG}MJAHR

WHERE

MKPF~CPUDT >= '20060301' AND

MSEG~BUKRS = 'M' AND

MSEG~BWART IN ('601', '602').

ENDSELECT.

so, where should i put:

INSERT wa_it INTO TABLE it_1.

CLEAR wa_it.

to append my internal table with data?

please help me!!!!

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:30:41 GMT

only help to put that data to my internal table, later i'll figure how to send data...

pls!

hlp!

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:31:58 GMT

SELECT
MKPF~MANDT
MKPF~MBLNR
*etc
MSEG~ZEILE
MSEG~LINE_ID
<b>INTO corresponding fields of table itaB</b>
FROM
MKPF AS MKPF
INNER JOIN
MSEG AS MSEG
ON MKPF~MANDT = MSEG~MANDT AND
MKPF~MBLNR = MSEG~MBLNR AND
MKPF~MJAHR = MSEG~MJAHR
WHERE
MKPF~CPUDT >= '20060301' AND
MSEG~BUKRS = 'M' AND
MSEG~BWART IN ('601', '602').

so ITAB contains all the which meets the requiment.

regards

prabhu

Re: Fill Internal table

naimesh_patel — Fri, 04 Aug 2006 10:32:08 GMT

SELECT

MKPF~MANDT

MKPF~MBLNR

*etc

MSEG~ZEILE

MSEG~LINE_ID

*etc

INTO table it_1

FROM

MKPF AS MKPF

INNER JOIN

MSEG AS MSEG

ON MKPF_{MANDT = MSEG}MANDT AND

MKPF_{MBLNR = MSEG}MBLNR AND

MKPF_{MJAHR = MSEG}MJAHR

WHERE

MKPF~CPUDT >= '20060301' AND

MSEG~BUKRS = 'M' AND

MSEG~BWART IN ('601', '602').

Regards,

Naimesh

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:33:18 GMT

Hi,

i`ve made the necessary changes to your code :

SELECT MKPF_{MANDT MKPF}MBLNR MSEG_{ZEILE MSEG}LINE_ID

INTO wa_it FROM MKPF AS MKPF INNER JOIN MSEG AS MSEG

ON MKPF_{MANDT = MSEG}MANDT AND

MKPF_{MBLNR = MSEG}MBLNR AND

MKPF_{MJAHR = MSEG}MJAHR

WHERE

MKPF~CPUDT >= '20060301' AND

MSEG~BUKRS = 'M' AND

MSEG~BWART IN ('601', '602').

append wa_it to it_it.
clear wa_it.

ENDSELECT.

reward points if helpful.

Regards

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:34:08 GMT

Hi Maja,

Just put append itab from wa inbetween Select and Endselect statement.

No need of of Insert statement.

This would work.

Regards,

Prashanth

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:34:54 GMT

SELECT

MKPF~MANDT

MKPF~MBLNR

*etc

MSEG~ZEILE

MSEG~LINE_ID

*etc

INTO wa_it

FROM MKPF INNER JOIN MSEG

into table it_1

ON MKPF_{MANDT = MSEG}MANDT AND

MKPF_{MBLNR = MSEG}MBLNR AND

MKPF_{MJAHR = MSEG}MJAHR

WHERE

MKPF~CPUDT >= '20060301' AND

MSEG~BUKRS = 'M' AND

MSEG~BWART IN ('601', '602').

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:35:38 GMT

SELECT

MKPF~MANDT

MKPF~MBLNR

*etc

MSEG~ZEILE

MSEG~LINE_ID

*etc

*INTO wa_it <--not required

into TABLE <ITAB_NAME> <-This will be added

FROM

MKPF AS MKPF

INNER JOIN

MSEG AS MSEG

ON MKPF_{MANDT = MSEG}MANDT AND

MKPF_{MBLNR = MSEG}MBLNR AND

MKPF_{MJAHR = MSEG}MJAHR

WHERE

MKPF~CPUDT >= '20060301' AND

MSEG~BUKRS = 'M' AND

MSEG~BWART IN ('601', '602').

* ENDSELECT. <-- NOT REQURIED if you use INTO TABLE.

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:35:46 GMT

Do it like this way

SELECT

MKPF~MANDT

MKPF~MBLNR

*etc

MSEG~ZEILE

MSEG~LINE_ID

*etc

INTO table IT1

FROM

MKPF AS MKPF

INNER JOIN

MSEG AS MSEG

ON MKPF_{MANDT = MSEG}MANDT AND

MKPF_{MBLNR = MSEG}MBLNR AND

MKPF_{MJAHR = MSEG}MJAHR

WHERE

MKPF~CPUDT >= '20060301' AND

MSEG~BUKRS = 'M' AND

MSEG~BWART IN ('601', '602').

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:41:28 GMT

o.k.

1. try - when i put append between select and endselect nothing happens when i go to debugg mode...

my Table it_1 is Table[Initial]

2. try - when i put my it_table after INTO statement i get this error:

it_1 cannot be a table, a reference, a string, or contain any of these objects...

please help!

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:42:08 GMT

SELECT

MKPF~MANDT

MKPF~MBLNR

*etc

MSEG~ZEILE

MSEG~LINE_ID

*etc

*INTO wa_it <--THIS IS NOT REQUIRED

INTO TABLE <ITAB_NAME> <--ADD THISFROM

MKPF AS MKPF

INNER JOIN

MSEG AS MSEG

ON MKPF_{MANDT = MSEG}MANDT AND

MKPF_{MBLNR = MSEG}MBLNR AND

MKPF_{MJAHR = MSEG}MJAHR

WHERE

MKPF~CPUDT >= '20060301' AND

MSEG~BUKRS = 'M' AND

MSEG~BWART IN ('601', '602').

*ENDSELECT. <--this is not required if you use INTO TABLE

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:45:43 GMT

hi,

i found two points in your code,

1. where is the perform statement, without perform statement the form..will not work,use perform get_data.

2. check the data in the table,using sy-dbcnt,

if sy-dbcnt is initial.

message i121(zxxx).

endif.

regards,

kcc

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:52:35 GMT

o.k. i've done it like this:

INTO wa_it

*etc

*ENDSELECT

but in debugging, my table is first Initial and then it accepts good fields but still no data...

when i previously putted it into wa_it that one was filled with some acctual data..

pls help

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:53:39 GMT

hi,

i have my perform statement, code is too big to post it all... so.

Re: Fill Internal table

Former Member — Fri, 04 Aug 2006 10:55:50 GMT

hey,

if you use JUST WA_IT , then you should use ENDSELECT & BEFORE THAT USE append WA_IT into ITAB.

select...

into WA_IT

...

WHERE ....

APPEND WA_IT INTO ITAB.

ENDSELECT.

Regards

srikanth