topic internal table in Application Development and Automation Discussions

internal table

Former Member — Sun, 27 Jan 2019 07:08:55 GMT

if i write statement

SELECT SINGLE *
* FROM mara
* INTO wa_mara
* WHERE matnr = a_matnr.

then what will be the write statement.

Re: internal table

matt — Sun, 27 Jan 2019 07:47:38 GMT

Whatever you want it to be. Your question is unclear. Your title is about internal tables, the content is a select single, and you're asking about a write statement.

I can appreciate that not everyone's first language is English, but I can't make any sense of your post.

Re: internal table

aliimran_uppal — Sun, 27 Jan 2019 17:22:58 GMT

You can show the work area fields by writing

wa_mara-"FieldName"

example:

wrtie: wa_mara-matnr.

Re: internal table

BaerbelWinkler — Sun, 27 Jan 2019 18:03:40 GMT

If you write the statement exactly as shown, then you should get a syntax error as lines 2 to 4 start with an '*' and are therefore treated as comments leaving the first line hanging in limbo as it's not even a complete statement. But, as Matt already mentioned, it's not even clear what you want to ask and/or achieve.

Re: internal table

former_member596005 — Mon, 28 Jan 2019 10:58:21 GMT

HI Anand Mokashi ,

Please be clear with your question , Anyway if you want your output then change according to sample code suggested below.

SELECT *
FROM mara
INTO it_mara
WHERE matnr = a_matnr.

loop at it_mara into wa_mara.

write : / wa_mara-matnr , ............your req fields.

endloop.

Moreover you have to remove * in your select query before starting of line as sap treats it as comment .

If you want to write select query only like you mentioned in your question then write as below.

SELECT single *
FROM mara
INTO wa_mara
WHERE matnr = a_matnr.

*and for output :

write : / wa_mara-matnr , wa_mara-mtart ,wa_mara-meins,........ and so on.