Skip to Content
author's profile photo Former Member
Former Member

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

3 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 05:44 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 05:20 AM

    Use this Function Module to Retrieve the text:

     
    CATS_GET_LOGISTIC_TEXT
    

    Hope That Helps

    Anirban M.

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Sep 19, 2008 at 05:28 AM

    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

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.