‎2007 Jul 20 6:38 AM
Hi Experts ,
Please tell me how to get some field from cluster table like" KONV with transparent table like "VBAP, VBAK" IN same internal table.
thanks & regards,
Ashish
‎2007 Jul 20 6:40 AM
Hi
Decalre the internal table with those fields and fill that internal table by fetching the data from those table.
Regards,
Sree
‎2007 Jul 20 9:50 AM
Hi sree ,
ya i have done it .but it is a Cluster table so inner join will not work .
Thanks & Regards,
Ashish
‎2007 Jul 20 6:41 AM
Hi
Welcome to SDN
<b>Pass the VBAK-KNUMV and VBAP-POSNR fields
to KONV-KNUMV and KONV-KPOSN</b> fields and fetch the data from KONV table
<b>Reward points for useful Answers</b>
Regards
Anji
‎2007 Jul 20 6:44 AM
Hi,
Welcome to SDN.
Try doing this ....
1). Goto se12 and display the table BSEG
2). Click on the Delivery & Maintenanace tab
3). Double click on the Pool/Cluster field
4). On the next screen do a where used list
You will find all the related tables.
Regards
‎2007 Jul 20 12:33 PM
first apply inner join on vbak and vbap and get the desired fields in the main internal table( itab ) and then use select.......for all entries in itab....to get the value from konv...