topic Re: problem with select in Application Development and Automation Discussions

problem with select

Former Member — Sun, 11 Jun 2006 09:55:38 GMT

SELECT RSEG_{BELNR RSEG}EBELN RSEG_{GJAHR RSEG}LFBNR

RSEG_{LIFNR RSEG}SHKZG RSEG_{WERKS RSEG}WRBTR

RBKP_{BLART RBKP}RMWWR RBKP~STBLG

RBKP_{VGART RBKP}WAERS

INTO table itab_j

FROM ( RSEG

INNER JOIN RBKP

ON RBKP_{BELNR = RSEG}BELNR

AND RBKP_{GJAHR = RSEG}GJAHR )

WHERE RSEG~lfbnr = '10000040'.

why i dont get data into itab_j and in abapquery i get?

i declare itab_j same as the field in the select.

Re: problem with select

Manohar2u — Sun, 11 Jun 2006 10:15:18 GMT

Try with packing RSEG~lfbnr with '0010000040'

Use conversion FM to suffice the above requirement if it works.

Regds

Manohar

Re: problem with select

Former Member — Sun, 11 Jun 2006 10:40:32 GMT

Hi Rani,

Use the following conversion exit on LFBNR before processing SELECT query.

<b>CONVERSION_EXIT_ALPHA_INPUT</b>.

If you specify same value at SELECTION-SCREEN through PARAMETERS/SELECT-OPTIONS with defintion RSEG-LFBNR then conversion exits will automatically trigger and the conversion exit values will be processed in SELECT query.

If you hardcode directly in SELECT statement, it wont perform any CONVERSION EXITs.So we need to handle it through CONVERSION EXITS.

<b>Note: Plz reward points to all helpful answers and close thread if is solved</b>

Thanks,

Vinay

Re: problem with select

Former Member — Sun, 11 Jun 2006 11:02:00 GMT

data: begin of itab_j occurs 0,

belnr like RSEG-BELNR,

ebeln like RSEG-EBELN,

gjahr like RSEG-GJAHR,

lfbnr like RSEG-LFBNR,

lifnr like RSEG-LIFNR,

shkzg like RSEG-SHKZG,

werks like RSEG-WERKS,

wrbtr like RSEG-WRBTR,

blart like RBKP-BLART,

rmwwr like RBKP-RMWWR,

stblg like RBKP-STBLG,

vgart like RBKP-VGART,

waers like RBKP-WAERS,

end of itab_j.

loop at itab assigning <ls_itab>.

data: z_lblni like essr-lblni.

call function 'CONVERSION_EXIT_ALPHA_INPUT'

exporting

input = <ls_itab>-lblni

IMPORTING

OUTPUT = z_lblni.

SELECT RSEG_{BELNR RSEG}EBELN RSEG_{GJAHR RSEG}LFBNR

RSEG_{LIFNR RSEG}SHKZG RSEG_{WERKS RSEG}WRBTR

RBKP_{BLART RBKP}RMWWR RBKP~STBLG

RBKP_{VGART RBKP}WAERS

INTO table itab_j

FROM ( RSEG

INNER JOIN RBKP

ON RBKP_{BELNR = RSEG}BELNR

AND RBKP_{GJAHR = RSEG}GJAHR )

WHERE RSEG~lfbnr = z_lblni.

i treis and it's not work????

Re: problem with select

Former Member — Sun, 11 Jun 2006 11:04:10 GMT

i get sydbcnt = 2 but i dont see the data in the itab

Re: problem with select

Manohar2u — Sun, 11 Jun 2006 11:13:10 GMT

Rani,

Is this select statement is in loop?

or does this field z_lblni is only a variable for your select?

Regds

Mnaohar

Re: problem with select

Former Member — Sun, 11 Jun 2006 11:19:50 GMT

in loop.

Re: problem with select

Manohar2u — Sun, 11 Jun 2006 11:23:58 GMT

Try using this type of select if the select is in loop.

SELECT ... INTO|<b>APPENDING</b> [CORRESPONDING FIELDS OF] TABLE <itab>

Regds

Manohar