topic Re: create querry from Structure in Application Development and Automation Discussions

create querry from Structure

Tolulope_O — Fri, 06 Nov 2009 08:57:50 GMT

Hello gurus,

Is it possible to create a query from SAP structures using TX:sqvi?

if it is possible, pls help out

Regards,

Tolulope

Re: create querry from Structure

SuhaSaha — Fri, 06 Nov 2009 09:01:44 GMT

Hello Tolulope,

Data can be extracted from DDIC tables(transperant, pooled & cluster types) & Database views only.

DDIC structure themselves donot contain any data & hence data cannot be extracted.

BR,

Suhas

Re: create querry from Structure

Former Member — Fri, 06 Nov 2009 09:06:26 GMT

Hi Tolulope OKUSAGA,

NO, You can not use Sturctures for creating query using SQVI T-Code.

You can use Transparent Tables like MARA , VBAK, VBAP, VBRP, VBRK etc

The reason is Structure does't hold data so writing Query on Structure is meaningless as well.

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Re: create querry from Structure

Former Member — Fri, 06 Nov 2009 09:06:29 GMT

Hi Tolulope OKUSAGA,

NO, You can not use Sturctures for creating query using SQVI T-Code.

You can use Transparent Tables like MARA , VBAK, VBAP, VBRP, VBRK etc

The reason is Structure does't hold data so writing Query on Structure is meaningless as well.

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Re: create querry from Structure

Tolulope_O — Fri, 06 Nov 2009 09:53:45 GMT

Thanx for the response!

I am trying to create a query and the all the relevant fields are in a structure (BSEG_ALV).

I have list the objects of the structure and i can find the related database tables.

If a create a query using al these tables would I be able to generate my report?

Regards,

Tolulope

Re: create querry from Structure

deepak_dhamat — Fri, 06 Nov 2009 10:12:12 GMT

I THINK YOU want only fileds which are used in structure for your report

create one work area of structure type

types : begin of w_test.

include structure BSEG_ALV.

types : end of w_test .

data : it_test type standard table of w_test with header line .

now your internal table of type structure is ready

select data according to your specification

step by step

and push data into internal table .

this will help you .

If purpose is different please explain .

Regards

Deepak .

Re: create querry from Structure

Former Member — Fri, 06 Nov 2009 12:38:08 GMT

Hi Tolulope OKUSAGA,

Sure..

If you try to access the data from the tables you can create the query and then create the report for it..

Note: You can not use Cluster Tables in SQVI Queries... and BSEG is cluster table...

So If you are looking for the data from BSEG then I would suggest you to use other tables like

BSAK

BSIK

BSAD

BSID and

other BS* Tables

I would like to suggest you to search on SCN for it... There are plenty of threads and you can get the information from it.

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7

ilesh Nandaniya

Re: create querry from Structure

Tolulope_O — Tue, 10 Nov 2009 14:47:26 GMT

Hi there!

I found a way to get the tables require to create my report; they include VBRK, BSIS, VBRP & MAKT.

I have tried creating a report from these tables and I don't get any data when I run the query.

I joined VBRK, BSIS and i did not get any data. i checked the individual tables using TX: se16 and I can find data.

I use al the tables together in one query and I also don't get data.

what could be wrong.

regards,

Tolulope

Re: create querry from Structure

Tolulope_O — Thu, 19 Nov 2009 07:21:28 GMT

Got in an ABAPer to create the report.