topic Re: SQVI in Application Development and Automation Discussions

SQVI

Former Member — Sat, 14 Feb 2009 05:37:18 GMT

HI ALL

i need to create a report on and selection critera is

plant: from / to

date : from /to

wbs element : from / to

fields to be displayed on the screen are

material

plant

good reciept

value

unit price

data to be fetched is based on this critera

select mblnr from mseg where BWART EQ 101,105,501,561 and SOBKZ EQ Q.

*i need to prepare this through tcode SQVI so pelase tell me can i write this query in sqvi and how to give selection critera *

Re: SQVI

Former Member — Sat, 14 Feb 2009 06:08:52 GMT

Hi,

for u requirement no coding is needed in sqvi, u can achieve ur requirement in se11 also.

since ur fetching all the details from single table.

sqvi procedure.

go to sqvi

give quick view name(any)

go for create

give title name,

data source : table

table/view : give table name (mseg) as per ur reqirement,

enter

u will see new screen

there select selection fields tab

move the filed which u want in selection screen., press enter

then go for list fiels selected ( give which fiels u want for out put )

then save

then execute.

in the selection screen give the selection criterial u can get the output desire.

for tcode.

execute the report.

go for system status , note program name crete tcode for this program name.

regards

siva.

Re: SQVI

Former Member — Sat, 14 Feb 2009 06:14:03 GMT

this i am already aware of but tell me how to give selection cirtera

Re: SQVI

Former Member — Sat, 14 Feb 2009 06:35:18 GMT

there is another check box next to list one enlarege the screen and mark that check box

Re: SQVI

former_member585060 — Sat, 14 Feb 2009 06:42:06 GMT

Hi,

In a Report program do the coding and create a tcode for it. NO-DISPLAY will not display the selection screen, but INITIALIZATION event sets the selection field values.

TABLES : MSEG.

SELECT-OPTIONS : s_bwart FOR mseg-bwart NO-DISPLAY.

PARAMETERS : p_sobkz TYPE mseg-sobkz NO-DISPLAY.


INITIALIZATION.

s_bwart-sign = 'I'.
s_bwart-option = 'EQ'.
s_bwart-low = '101'.
APPEND s_bwart.

s_bwart-sign = 'I'.
s_bwart-option = 'EQ'.
s_bwart-low = '105'.
APPEND s_bwart.

s_bwart-sign = 'I'.
s_bwart-option = 'EQ'.
s_bwart-low = '501'.
APPEND s_bwart.

s_bwart-sign = 'I'.
s_bwart-option = 'EQ'.
s_bwart-low = '561'.
APPEND s_bwart.

p_sobkz = 'Q'.

START-OF-SELECTION.

"SELECT query and output.

Regards

Bala Krishna