Select Query fields

[Former Member]

Hi,

I have a select query like this.

select vbak_{vbeln posnr vkorg vbak}auart kunnr matnr edatu kdgrp

kvgr3 kvgr4 bsark

from ztsddelividx

inner join vbak on ztsddelividx_{vbeln = vbak}vbeln

inner join tvak on vbak_{auart = tvak}auart

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

[former_member212653]

Go for a ST05 trace and check out the select statement that is being executed and built from ABAP open SQL. I hope you will get the solution. By the way, whats the SAP version you are using?