topic Re: Not getting proper output in Application Development and Automation Discussions

Not getting proper output

pooja08 — Sat, 29 Jul 2023 14:10:13 GMT

Hi experts, A simple code wrote, but i am not getting proper output...Please let me know where i did mistake.

DATA : IT TYPE STANDARD TABLE OF ST, WA TYPE st.

PARAMETERS : p_aufnr type aufk-aufnr.
SELECT equnr FROM afih INTO TABLE it WHERE aufnr = p_aufnr.
loop AT IT INTO WA.
write : / wa-equnr,
wa-aufnr.
ENDLOOP.

Re: Not getting proper output

Sandra_Rossi — Sat, 29 Jul 2023 14:11:28 GMT

"not getting proper output"

What do you get?

What do you expect?

Re: Not getting proper output

pooja08 — Sat, 29 Jul 2023 14:19:08 GMT

Output for equnr is something like 2**********.

but receiving only 20.

Re: Not getting proper output

Sandra_Rossi — Sat, 29 Jul 2023 14:23:21 GMT

because you declare ST with EQUNR with only 2 characters.

It should be

equnr TYPE afih-equnr,

probably you have used another type...

Also be careful to have exactly the same columns and same order both after SELECT and in the type of ST. NB: the names of the components are not important.

Re: Not getting proper output

pooja08 — Sat, 29 Jul 2023 14:31:10 GMT

TABLES : AFIH,AUFK.
TYPES : BEGIN OF ST,
AUFNR TYPE Afih-aufnr,
EQUNR TYPE AFIH-equnr,

END OF ST.

I did the declaration part

Re: Not getting proper output

Abhishek_10 — Sat, 29 Jul 2023 14:34:26 GMT

Can you modify your first line of code from

DATA : IT TYPE STANDARD TABLE OF ST, WA TYPE st.

DATA : IT TYPE STANDARD TABLE OF afih, WA TYPE afih.

This will fix your size issue.

Re: Not getting proper output

Sandra_Rossi — Sat, 29 Jul 2023 14:43:42 GMT

I said: "the same columns and same order"

But you did:

TYPES : BEGIN OF ST,
AUFNR TYPE Afih-aufnr,
EQUNR TYPE AFIH-equnr,
END OF ST.

and SELECT is missing AUFNR:

SELECT equnr

So, do:

SELECT aufnr equnr

Re: Not getting proper output

Sandra_Rossi — Sat, 29 Jul 2023 14:44:09 GMT

By the way, please edit your question (Actions>Edit), select your code and press the button [CODE], which makes the code appear colored/indented, it'll be easier for people to look at it. Thanks!

Re: Not getting proper output

Sandra_Rossi — Sat, 29 Jul 2023 14:45:56 GMT

No, it won't fix the issue, because "SELECT equnr" would then transfer to WA-MANDT, truncated at 3 characters.

Re: Not getting proper output

pooja08 — Sat, 29 Jul 2023 16:59:57 GMT

Thank you sandra , Got output

Re: Not getting proper output

Abhishek_10 — Sat, 29 Jul 2023 17:12:29 GMT

Ok then into corresponding fields of table it can be used.

Re: Not getting proper output

Sandra_Rossi — Sat, 29 Jul 2023 17:47:23 GMT

This is an answer to let visitors know that it's solved. Your buggy code:

TYPES : BEGIN OF ST,
          AUFNR TYPE Afih-aufnr,
          EQUNR TYPE AFIH-equnr,
        END OF ST.
DATA : IT TYPE STANDARD TABLE OF ST, 
       WA TYPE st.
PARAMETERS : p_aufnr type aufk-aufnr.
SELECT equnr                                "<========== don't correspond to IT
    FROM afih 
    INTO TABLE it 
    WHERE aufnr = p_aufnr.
loop AT IT INTO WA.
  write : / wa-equnr, wa-aufnr.
ENDLOOP.

Be careful to have exactly the same columns and same order both after SELECT and in the type of ST.

SELECT contains only EQUNR, it's missing AUFNR as you can see in ST (components AUFNR and EQUNR):

SELECT equnr

So, do:

SELECT aufnr equnr