topic Re: Fetching data based on Dynamic internal in Application Development and Automation Discussions

Fetching data based on Dynamic internal

Former Member — Tue, 26 Oct 2010 14:09:44 GMT

Hi All,

I have a requiement of creating an internal table dynamically. once this is dynamic table is loaded with values, i need to fetch the data from EKKO based on this dynamic internal table

I'm getting " the specified type has no structure and therefore no component called 'EBELN'" error when I'm trying with below code

SELECT EBELN BSART FROM EKKO INTO TABLE LT_EKKO

FOR ALL ENTRIES IN <all_table>

WHERE EBELN = <all_table>-EBELN.

please help me in to fetch the data based on this dynamic internal table

Thanks

Lucky

Re: Fetching data based on Dynamic internal

Former Member — Tue, 26 Oct 2010 14:24:46 GMT

Hello ,

Why you cant use LOOP based argumans. Check this ,


FIELD-SYMBOLS : <EBELN>.
DATA: LF_FIELD(30).

LOOP AT <DYN_TAB> INTO <DYN_WA>.

    CLEAR LF_FIELD.
    MOVE '<dyn_wa>-ebeln' TO LF_FIELD.
    ASSIGN (LF_FIELD) TO <EBELN>.

SELECT SINGLE EBELN BSART FROM EKKO INTO TABLE LT_EKKO
WHERE EBELN = <EBELN>.

....

I think it would be a little more slowly. But it will work.

I'll hope its help you,

Best Regards,

İrfan MATAK

Re: Fetching data based on Dynamic internal

kesavadas_thekkillath — Tue, 26 Oct 2010 14:46:14 GMT

Our friend Suhas once asked the same question. You can go through it