topic Re: select statement in Application Development and Automation Discussions

select statement

Former Member — Mon, 26 Feb 2007 06:20:35 GMT

hi all,

this select statement unable to get any data. any select syntax issue? no compilation error.

thanks

SELECT DISTINCT mara_{spart ztab}werks mbew_{bklas ztab}lgtyp

ztab_{dldat ztab}lgpla

INTO CORRESPONDING FIELDS OF TABLE ltab

FROM ztab

INNER JOIN mbew ON mbew_{matnr = ztab}matnr AND

mbew_{bwkey = ztab}werks

INNER JOIN mara ON mara_{matnr = ztab}matnr

WHERE ztab~werks IN so_werks AND

ztab~dldat IN so_dldat AND

ztab~lgtyp IN so_lgtyp AND

ztab~lgnum IN so_lgnum AND

ztab~lgpla IN so_lgpla AND

mbew~bklas IN so_bklas AND

mbew~bwtar = p_bwtar.

Re: select statement

Former Member — Mon, 26 Feb 2007 06:25:25 GMT

Might be its not meeting the seletion criteria...

first have a look into the data in Datasbase tables through se16 for that perticular criteria....

If u r getting the data for that seletion criteria... can have llok into this select statement again.

Regards,

Sujatha.

Re: select statement

Former Member — Mon, 26 Feb 2007 06:32:26 GMT

Use n the order mara, mbew and then ZTAB

SELECT DISTINCT mara~spart mbew~bklas ztab~werks ztab~lgtyp
ztab~dldat ztab~lgpla
INTO CORRESPONDING FIELDS OF TABLE ltab
FROM mara
INNER JOIN mbew ON mara~matnr = mbew~matnr 
INNER JOIN ztab ON ztab~matnr = mara~matnr
WHERE ztab~werks IN so_werks AND
ztab~dldat IN so_dldat AND
ztab~lgtyp IN so_lgtyp AND
ztab~lgnum IN so_lgnum AND 
ztab~lgpla IN so_lgpla AND 
mbew~bklas IN so_bklas AND 
mbew~bwtar = p_bwtar.

Make sure taht u have used all teh key fields in WHERE condioton for checking.

CHeck whetehr the tabel has entries. take vales from mara and teh pass it to mbew and then to ztab and check the tabel entries.

Re: select statement

Former Member — Mon, 26 Feb 2007 06:35:33 GMT

i think select query is correct just check whether data are present there or not for your select query and where condition you have specified and give the data in p_bwtar because it is parameter you must have to specify value here.

regards

shiba dutta

Re: select statement

Former Member — Mon, 26 Feb 2007 07:43:26 GMT

hi,

Well dont use into corresponding field of table

into table.

Re: select statement

sreeramkumar_madisetty — Mon, 26 Feb 2007 07:55:49 GMT

First check in the tables whether data is avialble or not with the specified criteria.

Check for sy-subrc value after select statement.

Regards,

kumar