create querry from Structure

[Tolulope_O]

Hello gurus,

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

if it is possible, pls help out

Regards,

Tolulope

[SuhaSaha]

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

[Former Member]

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

[Former Member]

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

[Tolulope_O]

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

[deepak_dhamat]

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 .

[Former Member]

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

[Tolulope_O]

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

[Tolulope_O]

Got in an ABAPer to create the report.