topic Re: Select query not working in Application Development and Automation Discussions

Select query not working

Former Member — Wed, 03 Mar 2010 13:27:36 GMT

The below code is not selecting the data though the table has value for this selection criteria

REPORT ZTEST_EZHIL.

Tables : AUSP.

data: atwrt like ausp-atwrt.

Select atwrt from AUSP into ausp-atwrt

where OBJEK = '000000000000888143' AND ATINN = 'ZYMER' and MAFID = 'O'.

Endselect.

Write: ausp-atwrt.

Can you tell me why because?

Thanks,

Ezhil.

Re: Select query not working

Former Member — Wed, 03 Mar 2010 13:32:17 GMT

Hello

Use FM CONVERSION_EXIT_ATINN_INPUT for convert 'ZYMER' into internal format and pass this into select query.

Re: Select query not working

manthanraja — Wed, 03 Mar 2010 13:33:32 GMT


REPORT ZTEST_EZHIL.
Tables : AUSP.
data: atwrt like ausp-atwrt.
Select atwrt from AUSP into ausp-atwrt <=== Declaration of the said object missing 
where OBJEK = '000000000000888143' AND ATINN = 'ZYMER' and MAFID = 'O'.
Endselect.
Write: ausp-atwrt.

Re: Select query not working

Former Member — Wed, 03 Mar 2010 13:37:29 GMT

Sorry.

REPORT ZTEST_EZHIL.

Tables : AUSP.

data: atwrt like ausp-atwrt.

Select atwrt from AUSP into atwrt

where OBJEK = '000000000000888143' AND ATINN = 'ZYMER' and MAFID = 'O'.

Endselect.

Write: atwrt.

But still its not working

Re: Select query not working

manthanraja — Wed, 03 Mar 2010 13:48:08 GMT

guess you should try

Dzed Maro''s solution ..

in this way


CALL FUNCTION 'CONVERSION_EXIT_ATINN_INPUT'
                 EXPORTING
                   input         =
*                IMPORTING
*                  OUTPUT        =

Might work ...

Manthan Raja

Re: Select query not working

Former Member — Wed, 03 Mar 2010 14:11:31 GMT

Hi,

"Please note

if you are using the FM as mentioned above 
most of the cases this conversion is used with in a loop.
this becomes performance issue.
so you can get all the corresponding ATINN outside the loop from CABN table
Just check the FM it also gets the ATINN against the ATNAM from CABN Table only
" Hope this would help in your future issues/Requirements

Tables : CABN.
DATA : WA_CABN TYPE CABN.
SELECT ATINN FROM CABN INTO WA_CABN-ATINN WHER ATNAM = 'ZYMER'.
IF SY-SUBRC = 0.

Select atwrt from AUSP into ausp-atwrt <=== Declaration of the said object missing 

where OBJEK = '000000000000888143' AND ATINN = WA_CABN-ATINN and MAFID = 'O'.
else.
message 'ZYMER is not maintained' type 'E' " or any other type
ENDIF.

Cheerz

Ram