topic select stmt in Application Development and Automation Discussions

select stmt

Former Member — Tue, 15 Apr 2008 02:40:18 GMT

i am getting sy-subrc eq 4 after this stmts

TABLES: VBRP.

types: begin of tab,

posnr like vbrp-posnr,

matnr like vbrp-matnr,

fkimg like vbrp-fkimg,

vrkme like vbrp-vrkme,

netwr like vbrp-netwr,

end of tab.

parameters: invoice like vbrp-vbeln.

*select-options: INVOICE FOR VBRP-VBELN.

data: i_itab type standard table of tab with header line.

data: up type p decimals 2 value 0.

START-OF-SELECTION.

*CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'

EXPORTING
INPUT = invoice
IMPORTING
OUTPUT = invoice

select posnr matnr fkimg vrkme netwr from vbrp INTO TABLE I_ITAB where

vbeln eq invoice.

if sy-subrc <> 0.

message i000(z00) with 'invoice does not exist'.

leave list-processing.

endif.

Thanks,

Re: select stmt

Former Member — Tue, 15 Apr 2008 02:42:50 GMT

then invoice number provided by you is not same as vbeln


if sy-subrc ne 0.
message i000(z00) with 'invoice does not exist'.
leave list-processing.
endif.

Re: select stmt

Former Member — Tue, 15 Apr 2008 02:47:27 GMT

i am slecting the invoice from vbrp table only and i am checking this in vbrp table only

Re: select stmt

venkat_o — Tue, 15 Apr 2008 02:52:46 GMT

Hi Kumar, 1.goto SE11 table and check the table entries by giving Invoice number what u give on Selection-screen. 2.Program seems to be ok . Only thing is data may be not there in the database table VBRP. Regards, Venkat.O

Re: select stmt

Former Member — Tue, 15 Apr 2008 02:54:41 GMT

sry guys

solved

Re: select stmt

Former Member — Tue, 15 Apr 2008 02:55:21 GMT

solved