topic Re: ERR: SIMPLE REPORT in Application Development and Automation Discussions

ERR: SIMPLE REPORT

vallamuthu_madheswaran2 — Tue, 04 Jul 2006 06:23:09 GMT

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.

Re: ERR: SIMPLE REPORT

Former Member — Tue, 04 Jul 2006 06:25:49 GMT

Hi Vallamuthu,

In the where condition

WHERE A~EBELN IN S_EBELN.

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

Re: ERR: SIMPLE REPORT

Former Member — Tue, 04 Jul 2006 06:26:01 GMT

You are using SELECT-OPTIONS.

WHERE A~EBELN IN S_EBELN.

Regards,

Ravi

Note : Please close the thread if the issue is resolved

Re: ERR: SIMPLE REPORT

Former Member — Tue, 04 Jul 2006 06:26:12 GMT

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 CORRESPONDING FIELDS OF IT_PURORDER

WHERE A~EBELN IN S_EBELN.

Thanks,

Vinay

Re: ERR: SIMPLE REPORT

aris_hidalgo — Tue, 04 Jul 2006 06:26:37 GMT

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

Regards!

Message was edited by: viraylab

Re: ERR: SIMPLE REPORT

Former Member — Tue, 04 Jul 2006 06:26:52 GMT

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 A~EBELN IN S_EBELN.

Re: ERR: SIMPLE REPORT

Former Member — Tue, 04 Jul 2006 06:27:22 GMT

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 IN S_EBELN.

hope this helps,

do reward if it helps,

priya.

Re: ERR: SIMPLE REPORT

Former Member — Tue, 04 Jul 2006 06:44:11 GMT

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

Re: ERR: SIMPLE REPORT

Former Member — Tue, 04 Jul 2006 07:10:02 GMT

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.