topic Re: REGARDING FIELDS & tables in Application Development and Automation Discussions

REGARDING FIELDS & tables

ashish_gupta11 — Fri, 20 Jul 2007 05:38:33 GMT

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

Re: REGARDING FIELDS & tables

sreeramkumar_madisetty — Fri, 20 Jul 2007 05:40:53 GMT

Decalre the internal table with those fields and fill that internal table by fetching the data from those table.

Regards,

Sree

Re: REGARDING FIELDS & tables

Former Member — Fri, 20 Jul 2007 05:41:46 GMT

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

Re: REGARDING FIELDS & tables

Former Member — Fri, 20 Jul 2007 05:44:48 GMT

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

Re: REGARDING FIELDS & tables

ashish_gupta11 — Fri, 20 Jul 2007 08:50:49 GMT

Hi sree ,

ya i have done it .but it is a Cluster table so inner join will not work .

Thanks & Regards,

Ashish

Re: REGARDING FIELDS & tables

Former Member — Fri, 20 Jul 2007 11:33:30 GMT

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...