Report!

[Former Member]

Dear All,

I need to developed one report in SD.

Where selection screen will be like that only:-

MATERIAL GROUP (MARA-MATKL)

and SELECTION DATE (MKPF-BUDAT)

Apart from this I want my output should be displayed in the format of

like :-

PRODUCT| UNIT| OPE STOCK| PURCHASE| SALES| CLO. STOCK|

-

---

|--

---

|

---

|

---

|

---

|

---

|--

---

QTY VLU QTY VLU QTY VLU QTY VLU QTY VLU QTY VLU

based on:-

MARA-MATKL

MKPF-BUDAT

How I will do that anybody can help me out. If anybody has any problem in understanding the problem. Do let me know once again.

Thanks & Regards,

Abhay.

[hymavathi_oruganti · Accepted solution]

select the fields from mara as a inner join fields from mkpf as b into itab where

a_{matnr = b}mblnr and a_{matkl = p_matkl and b}budat = p_budat.

Message was edited by:

Hymavathi Oruganti

[Former Member]

Hello Abhay,

There should be always some key fields which are connecting all relevent tables.

You can see this connection between tables: Open MARA table and press Graphics button (CntrlShiftF11). Then one graphics window will be displayed and there you can see the connection between tables.

I can provide you one .exe file which is having relationships between all tables of SAP- all modules.

Provide your mail id.

Reward If Helpful.

Regards

--

Sasidhar Reddy Matli.

[Former Member]

Thanks,

sap.abhaysingh@gmail.com