How to retreive data from a table and a structure

[Former Member]

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

[Former Member · Accepted solution]

Hi,

The field that you are looking can be find in the table

You can goto structure click on Component type AUFTEXT. Goto data element screen click on where used list(icon with rectangular and outside facing arrows), select table fields and check all the tables displayed. According to your requirement select the most appropriate. Most probably the table that you need is AUFK- KTEXT Order master data.

Regards,

Prashant.

[Former Member · Accepted solution]

ordertext = aufnr-ktext.

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

use dis in ur code.

hope it helps.

deepika.

[Former Member · Accepted solution]

thank you all!! my problem is solved.

[Former Member]

check this

Table-Fields Short descriptn

AUFK- KTEXT Order master data

COCH- KTXT Process Management: Control Recipe Header

COCHP- KTXT PI sheet: Control Recipe Header

COMPHDR- KTEXT OCM: Comparison results, indiv. records for order headers

HIKO- KTEXT Order master data history

MAAVC_MDO- KTEXT MPO: Individual Master Data for Orders

MCHPVS- AUFTEXT Batch Record: Shadow Table for Link to Archive

OCMHOMO_ARCH- KFELD Backup Table of Homogeneity List in Case of Archiving

PSJHIEDATA- KTEXT Hierarchy data to test LDB PSJ

TEWOCODEST- DESCRIPTION Order Codes (Texts)

TEWOCODET- KTEXT Allocation of Message Codes to Order

VLCSMORDER- KTEXT VELO : Service Order

VSAUFK_CN- KTEXT Version: Order master data

Yogesh N

[former_member480923]

Use this Function Module to Retrieve the text:

 
CATS_GET_LOGISTIC_TEXT

Hope That Helps

Anirban M.