topic Re: Some help with sm30 table. in Application Development and Automation Discussions

Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 11:19:08 GMT

i'm trying to insert some lines into table whice i crated

but always it give me one line although the shipment number have more than one line.

this is the code i write in the screen of the table:

SELECT *

FROM VTTK JOIN vttp ON VTTK_{TKNUM = vttp}TKNUM

JOIN likp ON vttp_{vbeln = likp}vbeln

Join KNA1 ON likp_{kunnr = KNA1}kunnr

INTO CORRESPONDING FIELDS OF Zplatform

WHERE vttk~TKNUM = Zplatform-TKNUM .

endselect.

Zpaltform is the name of the table and the code above give one line.

i even try with internal table but it give me nothing.

i'll be more then happy the get some help here.

thanks.

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 11:24:34 GMT

Change your SELECt to this

SELECT *

FROM VTTK JOIN vttp ON VTTK_{TKNUM = vttp}TKNUM

JOIN likp ON vttp_{vbeln = likp}vbeln

Join KNA1 ON likp_{kunnr = KNA1}kunnr

INTO CORRESPONDING FIELDS OF Zplatform

WHERE vttk~TKNUM = Zplatform-TKNUM .

append zplatform.

endselect.

SELECT *

FROM VTTK JOIN vttp ON VTTK_{TKNUM = vttp}TKNUM

JOIN likp ON vttp_{vbeln = likp}vbeln

Join KNA1 ON likp_{kunnr = KNA1}kunnr

INTO CORRESPONDING FIELDS OF table Zplatform

WHERE vttk~TKNUM = Zplatform-TKNUM .

Your values are not getting appended to the table.

Regards,

Ravi

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 11:30:10 GMT

first break the Join and check .

regards

Prabhu

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 11:48:22 GMT

Well the code you gave me didn't help,

Zplatform is the table i've created in se11 with maintenance (sm30) now when write this one

SELECT *

FROM VTTK JOIN vttp ON VTTK_{TKNUM = vttp}TKNUM

JOIN likp ON vttp_{vbeln = likp}vbeln

Join KNA1 ON likp_{kunnr = KNA1}kunnr

INTO CORRESPONDING FIELDS OF Zplatform

WHERE vttk~TKNUM = Zplatform-TKNUM .

append zplatform.

endselect.

the abap editor tell me that : "TO itab." expected after "ZPLATFORM".

any idea plz...

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 11:49:55 GMT

1) u have to select data into internal table.

2) after this insert data into ztable from internal table using insert or modify command.

u cant directly use select statement to insert data into dbtab.

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 11:53:15 GMT

Whichever program you are writing this select statement, you will have to declare a internal table like this

DATA ZPLATFORM TYPE TABLE OF ZPLATFORM WITH HEADER LINE.

Then it will NOT give a syntax error.

Regards,

Ravi

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 11:57:01 GMT

Hi,

Use This

SELECT *
FROM VTTK JOIN vttp ON VTTK~TKNUM = vttp~TKNUM
JOIN likp ON vttp~vbeln = likp~vbeln
Join KNA1 ON likp~kunnr = KNA1~kunnr

INTO CORRESPONDING FIELDS OF TABLE Zplatform
WHERE vttk~TKNUM = Zplatform-TKNUM .

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 12:19:26 GMT

well i tryng anything ( or maybe not) and still it's not work.

this is the last code i write :

SELECT *

FROM VTTK JOIN vttp ON VTTK_{TKNUM = vttp}TKNUM

JOIN likp ON vttp_{vbeln = likp}vbeln

Join KNA1 ON likp_{kunnr = KNA1}kunnr

INTO CORRESPONDING FIELDS OF table WA_Zplatform

WHERE vttk~TKNUM = lv_tknum.

INSERT INTO zplatform VALUES WA_Zplatform.

Zplatform is the table i created in se 11.

WA_Zplatform i declare like this:

BEGIN OF wa_Zplatform occurs 0,

wa_Zplatform like Zplatform,

END OF wa_Zplatform.

plz help...

Re: Some help with sm30 table.

Laxmana_Appana_ — Wed, 28 Jun 2006 12:25:32 GMT

Hi,

if you want to store table of values , change the insert statement like this:

Data : WA_Zplatform like Zplatform occurs 0 with header line.

INSERT (dbtabname) FROM TABLE itab.

INSERT zplatform FROM TABLE WA_Zplatform

Laxman

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 12:33:43 GMT

OK but my itab don't fill with data and this is stange.

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 12:33:45 GMT

Try this

CHANGE YOUR INSERT STATEMENT TO

INSERT ZPLATFORM FROM TABLE WA_ZPLATFORM.

Regards,

Ravi

Re: Some help with sm30 table.

RichHeilman — Wed, 28 Jun 2006 12:38:59 GMT

This should work.



data: izplatform type table of zplatform.

SELECT * INTO CORRESPONDING FIELDS OF table iZplatform
    FROM VTTK 
        inner JOIN vttp 
            ON VTTK~TKNUM = vttp~TKNUM
        inner JOIN likp 
            ON vttp~vbeln = likp~vbeln
        inner Join KNA1
            ON likp~kunnr = KNA1~kunnr
                     WHERE vttk~TKNUM = lv_tknum.

loop at izplatform.
insert zplatform from izplatform.
endloop.

Regards,

Rich Heilman

Re: Some help with sm30 table.

Former Member — Wed, 28 Jun 2006 14:38:18 GMT

Rich Heilman your post was very helpful.

one litttle thing is how can i refersh the sm 30 table

so after i type shipment number and then enter the records that was added in the background will be visible to the user.

no after i use the code of Rich Heilman the records are visible just if i exit the sm 30 and enter again.

thanks very much.

Re: Some help with sm30 table.

Former Member — Thu, 29 Jun 2006 05:35:09 GMT

Somebody know how to refresh sm30 table???