Skip to Content
0
Former Member
Nov 10, 2008 at 07:27 PM

Select Query fields

28 Views

Hi,

I have a select query like this.

select vbakvbeln posnr vkorg vbakauart kunnr matnr edatu kdgrp

kvgr3 kvgr4 bsark

from ztsddelividx

inner join vbak on ztsddelividxvbeln = vbakvbeln

inner join tvak on vbakauart = tvakauart

into table rt_delividx

where spart_i = rp_spart and

edatu in ro_date and

vkorg in ro_vkorg and

werks in ro_werks and

matnr in ro_matnr and

ztsddelividx~auart in ro_auart and

kunnr in ro_kunnr and

stgak = c_stgak.

This select query is from a program in production and is working fine. But I want to know from which tables this select query is fetching the fields posnr vkorg kunnr matnr edatu kdgrp kvgr3 kvgr4 bsark .

I checked the Z table ztsddelividx. But to my surprise the fields vkorg kunnr kvgr3 kvgr4 bsark are not there in this Z table.

I want to know from which tables this select query is fetching the fields posnr vkorg kunnr matnr edatu kdgrp kvgr3 kvgr4 bsark .

Thanks in advance.

Brahma Reddy