topic Re: table-link in Application Development and Automation Discussions

table-link

Former Member — Fri, 10 Mar 2006 11:52:10 GMT

guy's can any one help me regarding table linking, if you

go for ko03 transcation ,enter order number ,and go for investment

tab,you can see Position ID ,now i want to know how i can

fetch Position ID using order number.pls provide me table linking

,i tried my best ,but unable to apply any logic.

Re: table-link

andreas_mann3 — Fri, 10 Mar 2006 11:54:56 GMT

can'get your problem complete:

you mean table <b>AUFK</b> (Order master data)?

example:

SELECT  aufnr kostv akstl FROM  AUFK into table itab
         WHERE  AUART  = p_auart
         AND    BUKRS  = b_bukrs.

Message was edited by: Andreas Mann

Re: table-link

Former Member — Fri, 10 Mar 2006 11:57:05 GMT

1. Open up another SAP Session

2. Execute transaction ST05

3. Activate SQL Trace

4. In other session lauch KO03 and go to investment tab

5. Go back to deactivate and display the SQL Trace.

All tables that the transaction has accessed should be displayed in order that they were accessed. Therefore the table you need should be close to the end. Start looking through this table list to find the correct table.

Chris

Re: table-link

Former Member — Fri, 10 Mar 2006 12:06:40 GMT

yes but i want to fetch posid using aufnr

Re: table-link

Former Member — Fri, 10 Mar 2006 12:32:53 GMT

Check the table IMZO...

OBJNR should be the order number...

Thanks,

Renjith

Re: table-link

Former Member — Fri, 10 Mar 2006 12:35:07 GMT

Check the table IMZO...

OBJNR should be the order number...selct the posnr here and then search on table IMPR with posnr to get the posid.

Thanks,

Renjith.

Message was edited by: Renjith Andrews

Re: table-link

Former Member — Fri, 10 Mar 2006 12:37:10 GMT

U can use the FM to get the values for position id.

You need to pass the follwoing to the FM

i_objnr = order number concatenated with OR e.g OR000004000162.

i_aktyp = 'A'.

Hope this helps.

Abhijit

Re: table-link

andreas_mann3 — Fri, 10 Mar 2006 13:04:27 GMT

try:

select <b>objnr</b> from aufk into objnr
   where aufnr = itab-aufnr.

and with objnr you can fetch oth.tabl. like imzo, cosp,rpsco,...

Andreas