Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

common matnr

Former Member
0 Kudos

in MSKU,MSEG,MBEW,KNMT,MAKT

for the above tables i want to common matnr valu plzzzzzzzzzzzzz

5 REPLIES 5

former_member188685
Active Contributor
0 Kudos

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
0 Kudos

hi,

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

0 Kudos

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

former_member125931
Active Participant
0 Kudos

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
0 Kudos

okey