Select Single * is not fetching all Data

[Former Member]

Hi,

I have a peculiar problem, when i am extending the customer to a new company code, we are getting Dump saying 'ASSERTION_FAILED'

when i debugg i am geeting issue with following Code of a FM 'KNA1_SINGLE_READER'

IF NOT i_bypassing_buffer IS INITIAL.

*SELECT SINGLE * FROM kna1*

INTO o_kna1

WHERE kunnr = i_kunnr.

IF sy-subrc <> 0.

MESSAGE e300(vs) WITH 'KNA1' RAISING not_found.

ENDIF.

i am passing customer number (i_kunnr), this code is executed 2 times first time it is fetching all columns but second time it is only fetching customer number and no other information regarding customer. But in data base all information is present. Can any one help me in this.

Thanks a lot...

Reddy

Edited by: JAGAN MOHAN REDDY on Jun 2, 2010 11:30 AM

[Former Member]

Hi,

I have a peculiar problem, when i am extending the customer to a new company code, we are getting Dump saying 'ASSERTION_FAILED'

when i debugg i am geeting issue with following Code of a FM 'KNA1_SINGLE_READER'

IF NOT i_bypassing_buffer IS INITIAL.

*SELECT SINGLE * FROM kna1*

INTO o_kna1

WHERE kunnr = i_kunnr.

IF sy-subrc <> 0.

MESSAGE e300(vs) WITH 'KNA1' RAISING not_found.

ENDIF.

i am passing customer number (i_kunnr), this code is executed 2 times first time it is fetching all columns but second time it is only fetching customer number and no other information regarding customer. But in data base all information is present. Can any one help me in this.

Thanks a lot...

Reddy

Edited by: JAGAN MOHAN REDDY on Jun 2, 2010 11:30 AM

[Former Member]

Hi!

There is an else statement in the FM. Have u used it if sy-subrc ne 0. ?

also check what value you are passing in i_bypassing_buffer.

[Former Member]

Issue solved

[Former Member]

Hi Jagan,

It'll be helpful to others if you can please post how and what was done to resolve the issue.

Thanks!

Sandeep