How to use for all entries with two fields of db table

[ram_sahoo]

Hi Experts,

I have a requirement to use for all entries for table FMFMOAEOD02000132 fields SOUR1_FROM and SOUR1_TO with internal table ITAB with field SAKNR, I want to use SAKNR internal table field in where condition.

Example:

SELECT *

FROMFMFMOAEOD02000132

INTO table ITAB2

FOR ALL ENTRIES IN ITAB

WHERE sour1_from EQ ITAB-saknr AND

sour1_to EQ ITAB-saknr.

If i use same code getting error 'No component exists with the name "SAKNR". "SAKNR".

Anybody can help me on this.

Thanks,

[MateuszAdamus]

Hello ram.sahoo

Check the definition of your ITAB. Seems like it's missing the SAKNR field.

Kind regards,
Mateusz

[ram_sahoo]

Now error resolved but my confusion is, how i can read from and to field value with SAKNR, Please help me on this

[MateuszAdamus]

I don't understand the question. What is it that you'd like to do?

Kind regards,
Mateusz

[ram_sahoo]

My question is table FMFMOAEOD02000132 fields sour1_from and sour1_to i wants to use in where condition with SAKNR for all entries, Is it possible?

[MateuszAdamus]

Yes. It is possible, but you need to fix the ITAB SAKNR field issue, which the error you showed points to.

If this is fixed and you still have an issue, please share your code and the error message.

Kind regards,
Mateusz

[Sandra_Rossi]

ram sahoo maybe you mean that ITAB is a formal parameter declared generically? (and so, the compiler is not aware of the actual components at run time)

METHODS method IMPORTING ITAB TYPE ANY TABLE. " generic declaration

(TYPE ANY TABLE or also TYPE { STANDARD | INDEX | SORTED | HASHED } TABLE)

[RaymondGiuseppi]

How is ITAB defined: as a structure or a single field, in second case there is no subfield SAKNR use pseudo-component table_line and not SAKNR.