topic Re: SELECT-OPTIONS error in output in Application Development and Automation Discussions

SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 08:05:26 GMT

Dear all;

I am having an issue with the output for my code.

what i want to see as an output the Delivery Quantity and Order Quantity (lips-lfimg and vbap-kwmeng) after the user selects the Reference document (lips-vgbel)

when i run the code i get empty output

please can you tell me what is the mistake i am doing in my code.

===================================================================================

REPORT ZDEMO_SELECTION_SCREEN.

DATA: VGBEL TYPE LIPS-VGBEL,

BEGIN OF wa,

KWMENG TYPE VBAP-kwmeng,

LFIMG TYPE LIPS-LFIMG,

END OF wa,

itab LIKE SORTED TABLE OF wa WITH NON-UNIQUE KEY LFIMG KWMENG.

SELECT-OPTIONS: S_VGBEL FOR VGBEL.

SELECT f~LFIMG q~kwmeng INTO CORRESPONDING FIELDS OF TABLE itab

FROM VBAP AS q LEFT OUTER JOIN LIPS AS f ON f~vgbel = q~vbeln AND f~VGPOS = q~POSNR.

WRITE: /10 'Delivery Quantity', 40 'Order Quantity'.

AT SELECTION-SCREEN OUTPUT.

LOOP AT itab INTO wa.

WRITE: /10 wa-LFIMG, 40 wa-KWMENG.

ENDLOOP.

========================================================================================

Re: SELECT-OPTIONS error in output

gouravkumar64 — Sat, 04 Aug 2012 08:14:49 GMT

hi madam,

can u comment this line & write like this?

*AT SELECTION-SCREEN OUTPUT.
LOOP AT itab INTO wa.

WRITE: /10 wa-LFIMG, 40 wa-KWMENG.

ENDLOOP.

let me know output is coming or not.

gourav.

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 08:16:15 GMT

1.check the value are present or not in SE11 ans also check it is partialy active or fully active

2. Through debugging you can retrieve the error are transferring of values through F5

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 08:21:08 GMT

Dear gourav;

I comment the AT SELECTION-SCREEN OUTPUT as you recommended. i am getting now an output but the values are wrong. now it is giving me the delivery quantity, and the order quantity the same value as you can see in the following image:

how can i get the correct output?

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 08:30:29 GMT

I think the issue i am having is that the output is not connected to the selction input.

what i need as anoutput is only the Delivery Quantity and Order Quantity that corresponds to the sales document

Best Regards

~Amal

Re: SELECT-OPTIONS error in output

dhruv_mehta — Sat, 04 Aug 2012 08:44:46 GMT

Yes How Can you get output connected to your selection input. As you have not passed S_VGBEL to anywhere. Have you consider checking that? Kindly Debug your select query you will get your answers.

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 08:52:00 GMT

Dear Mehta;

I will check the debugger, but can you tell me how can i connect the selection input to the output.

Re: SELECT-OPTIONS error in output

gouravkumar64 — Sat, 04 Aug 2012 08:52:20 GMT

try like this

SELECT kwmeng INTO table wa FROM vbap
WHERE vgbel in s_vgbel.
SELECT lfimg INTO table wa2 FROM lips"declare another internal table

for all entries in wa
WHERE vgbel in s_vgbel .

then read table .

instead of join use for all entries .it is good.

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 11:42:51 GMT

Dear Kumar;

is this is how it should be?

REPORT ZDEMO_SELECTION_SCREEN.

DATA: VGBEL TYPE LIPS-VGBEL.

TYPES: BEGIN OF wa,

KWMENG TYPE VBAP-kwmeng OCCURS 0,

END OF wa.

TYPES: BEGIN OF wa2,

LFIMG TYPE LIPS-LFIMG occurs 0,

END OF wa2.

SELECT-OPTIONS: S_VGBEL FOR VGBEL.

SELECT kwmeng INTO table wa FROM vbap for all entries in wa WHERE vgbel in s_vgbel.

SELECT lfimg INTO TABLE wa2 FROM lips FOR ALL ENTRIES IN wa2 WHERE vgbel in s_vgbel.

WRITE: /10 'Delivery Quantity', 40 'Order Quantity'.

LOOP AT itab INTO wa.

WRITE 10 wa-KWMENG.

ENDLOOP.

LOOP AT itab INTO wa2.

WRITE 40 wa1-LFIMG.

ENDLOOP.

Re: SELECT-OPTIONS error in output

gouravkumar64 — Sat, 04 Aug 2012 12:18:44 GMT

Hi madam,

forget this report,

some simple thing i want to tell you now before this,

always go for some coding standard like now i am writing one small report here & explaning you the whole process,

1)imagine report name is zdemo,

2)vbap is master table & lips is secondary table,

3)there will be some common primary key field or selection screen field,

at first declare internal table

tables : vbap,lips. "useful to write all table name used in program.

types: begin of ty_vbap,

vbeln type vbap-vbeln,

kwmeng type kwmeng,"refer to data element directly is good practice

vgbel type vgbel,

end of ty_vbap.

types: begin of ty_lips,

vbeln type lips-vbeln,

lfimg type lfimg"refer to data element directly is good practice

vgbel type vgbel, " i forget the sequence but try to declare sequentially from table

end of ty_vbap.

types : begin of ty_final,"table for final o/p display

kwmeng type kwmeng,"maintain sequence

lfimg type lfimg,

end of..............

data: it_vbap type table of ty_vbap,"internal table

wa_vbap type ty_vbap,"work area

like this declare the others.

then selection screen

select-options: s_vb for vbap-vbveln,

s_vg for vbap-vgbel.

now select

select vbeln kwmeng from vbap into table it_vbap "into table is keyword

where vbeln in s_vb

vgbel in s_vg.

now come to for all entries it is better than inner or other join for good perormance

so see here

select vbeln lfimg vgbel into table it_lips

for all entries in it_vbap "comparing with it_vbap like join

where vbeln in s_vb

and vgbel in s_vg.

here selection screen matching but sometimes not matching then for all entries is best

>>>>>

loop will on master table here &

now read table from table to work area & displying the data in final tbale

loop at it_vbap into wa_vbap.

wa_final-kwmeng = wa_vbap-kwmeng.

read table it_lips into wa_lips with key vbeln = s_vbeln vgbel = s_vgbel " with key for simple tbale

wa_final-lfimg = wa_lips-kwmeng.

endloop.

>>>>>

1) do not use occurs , inner join it is costly & time consuming

AT LAST write Your write statement for values or you can write in alv also this report.

ALL the best for next report.

any confusion u can tell me.

Gourav.

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 13:05:31 GMT

occurs !!! you should not use,,, missing coding standards!..

Re: SELECT-OPTIONS error in output

gouravkumar64 — Sat, 04 Aug 2012 13:14:30 GMT

occurs 0 !!!!

there are many like this.

select endselect,

into corresponding fields of table ,

but sometimes occurs 0 have to use..

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 13:47:48 GMT

ofcourse but it is not recommended by SAP right?

Re: SELECT-OPTIONS error in output

gouravkumar64 — Sat, 04 Aug 2012 13:50:39 GMT

yes surya,

in new version of abap occurs 0 obsolete,types declaration is new way to declare. but there are rare case have to use occurs 0. as per my little knowledge.

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 13:53:00 GMT

hmm.. yeah.. i am working with 4.5b, all the code is written with occurs 0, have nothing to do.. agreed

Re: SELECT-OPTIONS error in output

gouravkumar64 — Sat, 04 Aug 2012 13:54:10 GMT

yes u r right in 4.5 but i am working in ecc 6.0 where this keyword is obsolete.

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 13:58:45 GMT

btw hello, where do u work?

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 14:01:50 GMT

Organisation? and Experience in SAP?

Re: SELECT-OPTIONS error in output

Former Member — Sat, 04 Aug 2012 14:02:57 GMT

ur mail?

Re: SELECT-OPTIONS error in output

gouravkumar64 — Sat, 04 Aug 2012 14:03:46 GMT

why u required my mail?