topic Not getting data in Application Development and Automation Discussions

Not getting data

Former Member — Tue, 06 May 2008 09:23:17 GMT

Hi all ,

Not getting Data in interman table i_konv.

Tell me the solution.

start-of-selection.

select a_{vbeln a}fkart a_{knumv a}fkdat a_{belnr a}ktgrd a~mwsbk

b~ktgrm

from ( vbrk as a inner join vbrp as b on

a_{vbeln eq b}vbeln )

into corresponding fields of

table vbrk_vbrp

Regards

Aastha

WHERE ( a~fkart eq billtype ) and

( a~fkdat in billdate ) and

( a~ktgrd eq acgrpd ) and

( b~ktgrm eq acgrpm ) .

select konts mwskz

from t030k

into table i_t030k

where mwskz eq taxcode .

if vbrk_vbrp[] is not initial .

select knumv kschl mwsk1 kwert

from konv

into corresponding fields of table i_konv

for all entries in vbrk_vbrp

where knumv = vbrk_vbrp-knumv

AND ( KSCHL = 'JIN1' OR kschl = 'JIN6' )

and mwsk1 = i_t030k-mwskz.

endif.

Re: Not getting data

Sm1tje — Tue, 06 May 2008 09:51:37 GMT

Aashta,

the last select, don't think this will work.

if vbrk_vbrp[] is not initial .

select knumv kschl mwsk1 kwert

from konv

into corresponding fields of table i_konv

for all entries in vbrk_vbrp

where knumv = vbrk_vbrp-knumv

AND ( KSCHL = 'JIN1' OR kschl = 'JIN6' )

and mwsk1 = i_t030k-mwskz.

endif.

You are using i_t030k-mwskz, but the field is probably empty, since you are using this statement:

select konts mwskz

from t030k

into table i_t030k

This will fill the internal table, but not the header which you are using as comparison in the select statement.

Re: Not getting data

Former Member — Tue, 06 May 2008 09:57:26 GMT

as ur using inner join make sure ur tables have data according to where condition u used in SELECT statement ,

coz this query will display data only which will fullfill all where conditions.

select statements r rite.

reward if helpful.