Skip to Content
0
Former Member
Mar 28, 2006 at 01:54 PM

Need help in report

20 Views

hi friends

iam doing a report, which has to display the list of material number and descrption and vendor

number and name which have unrestricted stock as on today and the material which have transaction

done in last year .

and i dont have specs only i have table names ,,mkpf and mseg can anybody help me in this how ro do

it.....

i am creating a itab

TYPES: BEGIN OF T_OUT,

MATNR LIKE MARD-MATNR,

WERKS LIKE MARD-WERKS,

LGORT LIKE MARD-LGORT,

LABST LIKE MARD-LABST,

MTART LIKE MARA-MTART,

MAKTX LIKE MAKT-MAKTX,

END OF T_OUT.

by using inner joinn retriving matnr but ..how to go in mkpf and what field should i take

SELECT MARD~MATNR

MARD~WERKS

MARD~LGORT

MARD~LABST

MARA~MTART

FROM MARD

INNER JOIN MARA ON

MARAMATNR = MARDMATNR

INNER JOIN MAKT ON

MAKTMATNR = MARDMATNR

INTO TABLE ITAB

WHERE MARD~MATNR IN S_MATNR

AND MARA~MTART IN S_MTART

AND SPRAS = SY-LANGU.

i think iam wrong... this is the first report i got .

thks

regards

farukh