topic Re: common matnr in Application Development and Automation Discussions

common matnr

Former Member — Wed, 16 Jul 2008 08:23:22 GMT

in MSKU,MSEG,MBEW,KNMT,MAKT

for the above tables i want to common matnr valu plzzzzzzzzzzzzz

Former Member — Wed, 16 Jul 2008 08:25:47 GMT

You can use SAP Query (or using SQVI) Create the Joins between the above tables and Get the common matnrs and download the information.

Former Member — Wed, 16 Jul 2008 08:30:01 GMT

hi,

can i have detail of your requierment so that i can try to help u out in report.

Former Member — Wed, 16 Jul 2008 08:32:45 GMT

im testing one RFC in that the requirement is there so that im asking

former_member125931 — Wed, 16 Jul 2008 08:39:36 GMT

select matnr from MSKU into table itab1

if itab1[] is not initial.

select matnr from MSEG into table itab2

for all entries in itab1

where matnr = itab1-matnr.

endif.

if itab2[] is not initial.

select matnr from MBEW into table itab3

for all entries in itab2

where matnr = itab2-matnr.

endif.

if itab3[] is not initial.

select matnr from KNMT into table itab4

for all entries in itab3

where matnr = itab3-matnr.

endif.

loop at itab3.

write itab3-matnr.

endloop.

Former Member — Thu, 17 Jul 2008 06:22:41 GMT

okey