topic Re: Error in Application Development and Automation Discussions

Error

Former Member — Mon, 16 Jul 2007 08:54:42 GMT

Hi,

I had the following error in my program.

TYPES:

BEGIN OF TY_OUTPUT,

KUNNR TYPE VBAK-KUNNR,

VBELN TYPE VBAK-VBELN,

AUDAT TYPE VBAK-AUDAT,

VBTYP TYPE VBAK-VBTYP,

MATNR TYPE VBAP-MATNR,

ZMENG TYPE VBAP-ZMENG,

NETPR TYPE VBAP-NETPR,

NETWR TYPE VBAP-NETWR,

MAKTX TYPE MAKT-MAKTX,

END OF TY_OUTPUT.

DATA:

ST_OUTPUT TYPE TY_OUTPUT,

IT_OUTPUT TYPE TABLE OF TY_OUTPUT.

SELECT-OPTIONS SKUNNR FOR ST_OUTPUT-KUNNR.

SELECT-OPTIONS SAUDAT FOR ST_OUTPUT-AUDAT.

SELECT-OPTIONS SVBTYP FOR ST_OUTPUT-VBTYP.

SELECT VBAK_{KUNNR VBAK}VBELN VBAK_{AUDAT VBTYP VBAK}VBTYP VBAP_{MATNR VBAP}ZMENG VBAP_{NETPR VBAP}NETWR MAKT~MAKTX INTO TABLE

IT_OUTPUT FROM VBAK INNER JOIN VBAP ON VBAK_{VBELN EQ VBAP}VBELN INNER JOIN MAKT ON VBAP_{MATNR EQ MAKT}MATNR

WHERE VBAK_{KUNNR IN SKUNNR VBAK}AUDAT IN SAUDAT VBAK~VBTYP IN SVBTYP.

error is Incorrect expression "VBAK~AUDAT" in logical condition.

this is in the last line

Re: Error

Former Member — Mon, 16 Jul 2007 08:57:26 GMT

hi,

U forgot to give AND befor VBAK~AUDAT.

SELECT VBAK_{KUNNR VBAK}VBELN VBAK_{AUDAT VBTYP VBAK}VBTYP VBAP_{MATNR VBAP}ZMENG VBAP_{NETPR VBAP}NETWR MAKT~MAKTX INTO TABLE

IT_OUTPUT FROM VBAK INNER JOIN VBAP ON VBAK_{VBELN EQ VBAP}VBELN INNER JOIN MAKT ON VBAP_{MATNR EQ MAKT}MATNR

WHERE VBAK_{KUNNR IN SKUNNR AND VBAK}AUDAT IN SAUDAT AND VBAK~VBTYP IN SVBTYP.

Message was edited by:

Roja Velagapudi

Re: Error

gopi_narendra — Mon, 16 Jul 2007 08:58:21 GMT

SELECT VBAK~KUNNR VBAK~VBELN VBAK~AUDAT VBTYP VBAK~VBTYP VBAP~MATNR VBAP~ZMENG VBAP~NETPR VBAP~NETWR MAKT~MAKTX 
INTO TABLE IT_OUTPUT 
FROM VBAK INNER JOIN VBAP ON VBAK~VBELN EQ VBAP~VBELN 
                     INNER JOIN MAKT ON VBAP~MATNR EQ MAKT~MATNR
           WHERE VBAK~KUNNR IN SKUNNR 
                 AND VBAK~AUDAT IN SAUDAT 
                 AND VBAK~VBTYP IN SVBTYP

AND is missing

Regards

Gopi

Re: Error

Former Member — Mon, 16 Jul 2007 08:59:29 GMT

Hi...,

SELECT VBAK~KUNNR

VBAK~VBELN

VBAK~AUDAT

VBTYP

VBAK~VBTYP

VBAP~MATNR

VBAP~ZMENG

VBAP~NETPR

VBAP~NETWR

MAKT~MAKTX

INTO TABLE IT_OUTPUT

FROM VBAK INNER JOIN VBAP

ON VBAK_{VBELN EQ VBAP}VBELN INNER JOIN MAKT ON VBAP_{MATNR EQ MAKT}MATNR

WHERE VBAK~KUNNR IN SKUNNR

and VBAK~AUDAT IN SAUDAT

and VBAK~VBTYP IN SVBTYP.

regards,

sai ramesh

reward all helpful answers !!

Re: Error

Former Member — Mon, 16 Jul 2007 08:59:32 GMT

Hi,

u have to put "AND" between each term in the condition WHERE

WHERE VBAK~KUNNR IN SKUNNR

and VBAK~AUDAT IN SAUDAT

and VBAK~VBTYP IN SVBTYP.

Bye enzo

Re: Error

Former Member — Mon, 16 Jul 2007 08:59:54 GMT

Hi Ram,

U've missed AND between conditions.

Please go plant that and yep its all done.

Reward points if this helps,

Kiran

Re: Error

S0025444845 — Mon, 16 Jul 2007 09:03:12 GMT

use AND in between where conditions.

SELECT VBAK_{KUNNR VBAK}VBELN VBAK_{AUDAT VBTYP VBAK}VBTYP VBAP_{MATNR VBAP}ZMENG VBAP_{NETPR VBAP}NETWR MAKT~MAKTX INTO TABLE

IT_OUTPUT FROM VBAK INNER JOIN VBAP ON VBAK_{VBELN EQ VBAP}VBELN INNER JOIN MAKT ON VBAP_{MATNR EQ MAKT}MATNR

WHERE VBAK~KUNNR IN SKUNNR

ANDVBAK~AUDAT IN SAUDAT

AND VBAK~VBTYP IN SVBTYP.

Re: Error

Former Member — Mon, 16 Jul 2007 09:03:28 GMT

Here is your Code .......

report  zasdaer.

TYPES:
BEGIN OF TY_OUTPUT,
KUNNR TYPE VBAK-KUNNR,
VBELN TYPE VBAK-VBELN,
AUDAT TYPE VBAK-AUDAT,
VBTYP TYPE VBAK-VBTYP,
MATNR TYPE VBAP-MATNR,
ZMENG TYPE VBAP-ZMENG,
NETPR TYPE VBAP-NETPR,
NETWR TYPE VBAP-NETWR,
MAKTX TYPE MAKT-MAKTX,
END OF TY_OUTPUT.

DATA:
ST_OUTPUT TYPE TY_OUTPUT,
IT_OUTPUT TYPE TABLE OF TY_OUTPUT.

SELECT-OPTIONS SKUNNR FOR ST_OUTPUT-KUNNR.
SELECT-OPTIONS SAUDAT FOR ST_OUTPUT-AUDAT.
SELECT-OPTIONS SVBTYP FOR ST_OUTPUT-VBTYP.

SELECT VBAK~KUNNR
VBAK~VBELN
 VBAK~AUDAT
VBAK~VBTYP
VBAP~MATNR
VBAP~ZMENG
VBAP~NETPR
VBAP~NETWR
MAKT~MAKTX INTO TABLE
IT_OUTPUT FROM VBAK INNER JOIN VBAP ON VBAK~VBELN EQ VBAP~VBELN
                    INNER JOIN MAKT ON   MAKT~MATNR  EQ VBAP~MATNR
WHERE VBAK~KUNNR IN SKUNNR  AND  VBAK~AUDAT IN SAUDAT AND  VBAK~VBTYP IN SVBTYP.


LOOP AT it_output  INTO  ST_OUTPUT.
WRITE   :/
ST_OUTPUT-KUNNR ,
ST_OUTPUT-VBELN ,
ST_OUTPUT-AUDAT ,
ST_OUTPUT-VBTYP ,
ST_OUTPUT-MATNR ,
ST_OUTPUT-ZMENG ,
ST_OUTPUT-NETPR ,
ST_OUTPUT-NETWR ,
ST_OUTPUT-MAKTX.
ENDLOOP.

Reward points if it is usefull....

Girish