Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

How to retreive data from a table and a structure

Hi experts,

I have a requirement to create an ALV report. I have to include fields from two tables 'PA0001' and 'CATSDB' and from one structure 'CATSAPPR'. I am able to retrieve data from tables using INNERJOIN. But i have no idea how to deal with Structure.

I know that structure does not contain any data.

But i am not able to find any transparent table which has field 'ORDERTEXT' . I found field 'ORDERTEXT' only in structure 'CATSAPPR'.

So please anyone tell me, either any transparent table which has field 'ORDERTEXT' or please tell me how to deal with structure, in this case.

Please help me,

Thanks in advance

Anu

Tags:
replied

ordertext = aufnr-ktext.

select single ktext from aufk into ordertext where aufnr eq catsd-raufnr.

use dis in ur code.

hope it helps.

deepika.

0 View this answer in context

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question