topic Re: SQ02 ABAP Coding in Application Development and Automation Discussions

SQ02 ABAP Coding

former_member355038 — Tue, 28 Jan 2014 22:12:08 GMT

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

Re: SQ02 ABAP Coding

sacconipaolo — Tue, 28 Jan 2014 23:38:16 GMT

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 ' '.