SQ02 ABAP Coding

[former_member355038]

Hi All,

I am new to ABAP and am using SQ02 to add coding to select data from a table here is what I have so far:

Select single KNUMH from KONV

into Z_KONV_COND

where

KNUMV = EKKO-KNUMV

and

KPOSN = EKPO-EBELP

and

KSCHL='XX00'

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

The problem is in table KONV, there are some records where the field KNUMH is blank I do not want these records to show in the query, what additional code do I need to add to the above section?

thanks

Joe

[former_member355038]

Hi All,

I am new to ABAP and am using SQ02 to add coding to select data from a table here is what I have so far:

Select single KNUMH from KONV

into Z_KONV_COND

where

KNUMV = EKKO-KNUMV

and

KPOSN = EKPO-EBELP

and

KSCHL='XX00'

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

The problem is in table KONV, there are some records where the field KNUMH is blank I do not want these records to show in the query, what additional code do I need to add to the above section?

thanks

Joe

[sacconipaolo]

add the following in the where condition of the select statement

and

KNUMH ne ' '.

Select single KNUMH from KONV

into Z_KONV_COND

where

KNUMV = EKKO-KNUMV

and

KPOSN = EKPO-EBELP

and

KSCHL='XX00'

and

KNUMH ne ' '.