Skip to Content
0
Former Member
Dec 20, 2006 at 09:38 PM

if the connecting fields are missing the data from knvh should be u00BBnullu00AB

52 Views

Could you help me I would like to have all fields from kna1 (if the connecting fields are missing the data from knvh should be »null«)in following code

select * from kna1 .

select * from knvh where kunnr = kna1-kunnr and vkorg = '0200'.

itab-mandt = kna1-mandt.

itab-stceg = kna1-stceg.

.

itab-hkunnr = knvh-hkunnr.

itab-datab = knvh-datab.

itab-datbi = knvh-datbi.

append itab. clear itab.

endselect.

endselect.