ERR: SIMPLE REPORT

[vallamuthu_madheswaran2]

hai friends

i got an error on the following report. please mention how to rectify the error

thanks & regards

vallamuthu

REPORT ZREP_PURCHASE_ORDER .

TABLES: EKKO, EKPO.

DATA: BEGIN OF IT_PURORDER,

EBELN LIKE EKKO-EBELN, "STO NUMBER

BEDAT LIKE EKKO-BEDAT, "DOCUMENT DATE

BSART LIKE EKKO-BSART, "DOCUMENT TYPE STO/PO.

LIFNR LIKE EKKO-LIFNR, "VENDOR NAME

WERKS LIKE EKPO-WERKS, "SUPPLYING PLANT

END OF IT_PURORDER.

SELECT-OPTIONS

S_EBELN FOR EKKO-EBELN.

START-OF-SELECTION.

SELECT A_{BEDAT A}BSART A_{LIFNR B}WERKS

FROM EKKO AS A INNER JOIN EKPO AS B ON A_{EBELN = B}EBELN

INTO ( IT_PURORDER-BEDAT, IT_PURORDER-BSART,

IT_PURORDER-LIFNR, IT_PURORDER-WERKS )

WHERE A~EBELN = S_EBELN.

[Former Member]

Hi Vallamuthu,

In the where condition

WHERE A~EBELN IN S_EBELN.

Send the error you are getting if this will not work.

[Former Member]

You are using SELECT-OPTIONS.

WHERE A~EBELN <b>IN</b> S_EBELN.

Regards,

Ravi

Note : Please close the thread if the issue is resolved

[Former Member]

Hi Vallamuthu,

Welcome to SDN...........

Change the code as follows.

SELECT A_{BEDAT A}BSART A_{LIFNR B}WERKS

FROM EKKO AS A INNER JOIN EKPO AS B ON A_{EBELN = B}EBELN

INTO <b>CORRESPONDING FIELDS OF IT_PURORDER</b>

WHERE <b>A~EBELN IN S_EBELN.</b>

Thanks,

Vinay

[aris_hidalgo]

your select-option. Please change it to IN in your select statement.

Regards!

Message was edited by: viraylab

[Former Member]

SELECT A_{EBELN A}BEDAT A_{BSART A}LIFNR B~WERKS

FROM EKKO AS A INNER JOIN EKPO AS B ON A_{EBELN = B}EBELN

INTO TABLE ITAB WHERE <b>A~EBELN IN S_EBELN</b>.

[Former Member]

hi vallamuthu,

I dont know what is the error you are getting?

but there is correction...

SELECT A_{BEDAT A}BSART A_{LIFNR B}WERKS

FROM EKKO AS A INNER JOIN EKPO AS B ON A_{EBELN = B}EBELN

INTO ( IT_PURORDER-BEDAT, IT_PURORDER-BSART,

IT_PURORDER-LIFNR, IT_PURORDER-WERKS )

WHERE A~EBELN <b>IN</b> S_EBELN.

hope this helps,

do reward if it helps,

priya.

[Former Member]

1. There should be no space between the "(" and the "IT_PURORDER-BEDAT" and between the ")" and IT_PURORDER-WERKS.

2. A_{EBELN = S_EBELN should be A}EBELN IN S_EBELN

3. Your program will still have an error because IT_PURORDER is not a table with header line.

- better declare it as an internal table and use into corresponding fields

[Former Member]

you can do it this way...

TABLES: ekko, ekpo.

types: BEGIN OF it_purorder,

ebeln LIKE ekko-ebeln, "STO NUMBER

bedat LIKE ekko-bedat, "DOCUMENT DATE

bsart LIKE ekko-bsart, "DOCUMENT TYPE STO/PO.

lifnr LIKE ekko-lifnr, "VENDOR NAME

werks LIKE ekpo-werks, "SUPPLYING PLANT

END OF it_purorder.

data: it type table of it_purorder,

wa type it_purorder.

SELECT-OPTIONS: s_ebeln FOR ekko-ebeln.

START-OF-SELECTION.

SELECT ekko_{bedat ekko}bsart

ekko_{lifnr ekpo}werks

FROM ekko

INNER JOIN ekpo

ON ekko_{ebeln EQ ekpo}ebeln

INTO corresponding fields of table it

WHERE ekko~ebeln = s_ebeln.