topic Re: Correct this report. in Application Development and Automation Discussions

Correct this report.

Former Member — Fri, 15 Feb 2008 11:34:19 GMT

Hi Frds,

im not geting the output for this report ...kindly correct my mistake and give me..

REPORT Z_CONS_STOCK_ROL5 .

data : Mat_no like mara-matnr,

Plant1 like ekpo-werks,

com_co like mseg-bukrs,

store like mseg-lgnum.

SELECTION-SCREEN: BEGIN OF BLOCK 01.

SELECTION-SCREEN: BEGIN OF BLOCK 02 WITH FRAME TITLE text-001.

SELECT-OPTIONS MATERIAL FOR mat_no.

SELECT-OPTIONS Plant FOR plant1.

SELECT-OPTIONS COMPANY FOR COM_CO.

SELECT-OPTIONS STROAGE FOR STORE.

SELECTION-SCREEN: END OF BLOCK 02.

SELECTION-SCREEN: END OF BLOCK 01.

Data : begin of itab occurs 0,

matnr like mara-matnr,

maktx like makt-maktx,

meins like mara-meins,

minbe like marc-minbe,

lgnum like mseg-lgnum,

ebeln like ekpo-ebeln,

menge like ekpo-menge,

banfn like eban-banfn,

meng1 like eban-menge,

mblnr like mseg-mblnr,

end of itab.

select a~ebeln

a~menge

a~werks

b~banfn

b~menge

c~matnr

c~meins

d~maktx

e~minbe

f~lgnum

f~mblnr

f~bukrs

f~lgort

INTO CORRESPONDING FIELDS OF TABLE ITAB FROM EKPO as a

inner join EBAN as b on a_{BANFN = b}BANFN

inner join MARA as c on c_{MATNR = a}MATNR

inner join MAKT as d on d_{MATNR = c}MATNR

inner join MARC as e on e_{MATNR = c}MATNR

inner join MSEG as f on f_{MATNR = c}MATNR

where c_{matnr in MATERIAL and a}werks in PLANT and f~bukrs in

COMPANY and f~lgort in STROAGE.

write : / itab-matnr, itab-maktx, itab-meins, itab-minbe, itab-lgnum,

itab-ebeln, itab-menge, itab-banfn, itab-menge.

thanks

PARI VENDHAN.R

Re: Correct this report.

Former Member — Fri, 15 Feb 2008 11:38:47 GMT

Put the wirght statement in loop of ITAB.


REPORT Z_CONS_STOCK_ROL5 .

data : Mat_no like mara-matnr,
Plant1 like ekpo-werks,
com_co like mseg-bukrs,
store like mseg-lgnum.

SELECTION-SCREEN: BEGIN OF BLOCK 01.
SELECTION-SCREEN: BEGIN OF BLOCK 02 WITH FRAME TITLE text-001.

SELECT-OPTIONS MATERIAL FOR mat_no.
SELECT-OPTIONS Plant FOR plant1.
SELECT-OPTIONS COMPANY FOR COM_CO.
SELECT-OPTIONS STROAGE FOR STORE.

SELECTION-SCREEN: END OF BLOCK 02.
SELECTION-SCREEN: END OF BLOCK 01.

Data : begin of itab occurs 0,
matnr like mara-matnr,
maktx like makt-maktx,
meins like mara-meins,
minbe like marc-minbe,
lgnum like mseg-lgnum,
ebeln like ekpo-ebeln,
menge like ekpo-menge,
banfn like eban-banfn,
meng1 like eban-menge,
mblnr like mseg-mblnr,
end of itab.

select a~ebeln
a~menge
a~werks
b~banfn
b~menge
c~matnr
c~meins
d~maktx
e~minbe
f~lgnum
f~mblnr
f~bukrs
f~lgort

INTO CORRESPONDING FIELDS OF TABLE ITAB FROM EKPO as a
inner join EBAN as b on a~BANFN = b~BANFN
inner join MARA as c on c~MATNR = a~MATNR
inner join MAKT as d on d~MATNR = c~MATNR
inner join MARC as e on e~MATNR = c~MATNR
inner join MSEG as f on f~MATNR = c~MATNR

where c~matnr in MATERIAL and a~werks in PLANT and f~bukrs in
COMPANY and f~lgort in STROAGE.

loop at itab.
write : / itab-matnr, itab-maktx, itab-meins, itab-minbe, itab-lgnum,
itab-ebeln, itab-menge, itab-banfn, itab-menge.

clear: itab.
endloop.

Re: Correct this report.

Former Member — Fri, 15 Feb 2008 11:38:53 GMT

HI,

REPORT Z_CONS_STOCK_ROL5 .

data : Mat_no like mara-matnr,

Plant1 like ekpo-werks,

com_co like mseg-bukrs,

store like mseg-lgnum.

SELECTION-SCREEN: BEGIN OF BLOCK 01.

SELECTION-SCREEN: BEGIN OF BLOCK 02 WITH FRAME TITLE text-001.

SELECT-OPTIONS MATERIAL FOR mat_no.

SELECT-OPTIONS Plant FOR plant1.

SELECT-OPTIONS COMPANY FOR COM_CO.

SELECT-OPTIONS STROAGE FOR STORE.

SELECTION-SCREEN: END OF BLOCK 02.

SELECTION-SCREEN: END OF BLOCK 01.

Data : begin of itab occurs 0,

matnr like mara-matnr,

maktx like makt-maktx,

meins like mara-meins,

minbe like marc-minbe,

lgnum like mseg-lgnum,

ebeln like ekpo-ebeln,

menge like ekpo-menge,

banfn like eban-banfn,

meng1 like eban-menge,

mblnr like mseg-mblnr,

end of itab.

select a~ebeln

a~menge

a~werks

b~banfn

b~menge

c~matnr

c~meins

d~maktx

e~minbe

f~lgnum

f~mblnr

f~bukrs

f~lgort

INTO CORRESPONDING FIELDS OF TABLE ITAB FROM EKPO as a

inner join EBAN as b on a_{BANFN = b}BANFN

inner join MARA as c on c_{MATNR = a}MATNR

inner join MAKT as d on d_{MATNR = c}MATNR

inner join MARC as e on e_{MATNR = c}MATNR

inner join MSEG as f on f_{MATNR = c}MATNR

where c_{matnr in MATERIAL and a}werks in PLANT and f~bukrs in

COMPANY and f~lgort in STROAGE.

loop at itab.

write : / itab-matnr, itab-maktx, itab-meins, itab-minbe, itab-lgnum,

itab-ebeln, itab-menge, itab-banfn, itab-menge.

endloop.

rgds,

bharat.

Re: Correct this report.

Former Member — Fri, 15 Feb 2008 12:16:22 GMT

Thanks for ur information..

im geting the output..

Re: Correct this report.

Former Member — Fri, 15 Feb 2008 12:46:04 GMT

REPORT Z_CONS_STOCK_ROL5 .

data : Mat_no like mara-matnr,

Plant1 like ekpo-werks,

com_co like mseg-bukrs,

store like mseg-lgnum.

SELECTION-SCREEN: BEGIN OF BLOCK 01.

SELECTION-SCREEN: BEGIN OF BLOCK 02 WITH FRAME TITLE text-001.

SELECT-OPTIONS MATERIAL FOR mat_no.

SELECT-OPTIONS Plant FOR plant1.

SELECT-OPTIONS COMPANY FOR COM_CO.

SELECT-OPTIONS STROAGE FOR STORE.

SELECTION-SCREEN: END OF BLOCK 02.

SELECTION-SCREEN: END OF BLOCK 01.

Data : begin of itab occurs 0,

matnr like mara-matnr,

maktx like makt-maktx,

meins like mara-meins,

minbe like marc-minbe,

lgnum like mseg-lgnum,

ebeln like ekpo-ebeln,

menge like ekpo-menge,

banfn like eban-banfn,

meng1 like eban-menge,

mblnr like mseg-mblnr,

end of itab.

select a~ebeln

a~menge

a~werks

b~banfn

b~menge

c~matnr

c~meins

d~maktx

e~minbe

f~lgnum

f~mblnr

f~bukrs

f~lgort

INTO CORRESPONDING FIELDS OF TABLE ITAB FROM EKPO as a

inner join EBAN as b on a_{BANFN = b}BANFN

inner join MARA as c on c_{MATNR = a}MATNR

inner join MAKT as d on d_{MATNR = c}MATNR

inner join MARC as e on e_{MATNR = c}MATNR

inner join MSEG as f on f_{MATNR = c}MATNR

where c_{matnr in MATERIAL and a}werks in PLANT and f~bukrs in

COMPANY and f~lgort in STROAGE.

write : / itab-matnr, itab-maktx, itab-meins, itab-minbe, itab-lgnum,

itab-ebeln, itab-menge, itab-banfn, itab-menge.

Hi Pari Vedhan Rajasekaran ,

Dont Mistake me, First you have to say yourself what kind of problem you face. You have mention your are not getting output thats it.

What I am saying , Whether you receive any error message , else like..

okay..

1) As others said LOOP is missing in the WRITE stmt.

2) In the SELECT OPTIONS , you can directly refer to the field.

no need for defining a DATA type stmt. and refering it again.

My suggestion is:

1) Modularise the code you developed.

2) Follow the EVENTS properly

3) Dont use Inner Joins as far as performance aspects are concerned.

4) Follow the naming conventions.

okay.. If any help need, please contact me.

Regards,

Sanjeev.