Application Development and Automation 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: 
Read only

common matnr

Former Member
0 Likes
817

in MSKU,MSEG,MBEW,KNMT,MAKT

for the above tables i want to common matnr valu plzzzzzzzzzzzzz

in MSKU,MSEG,MBEW,KNMT,MAKT

for the above tables i want to common matnr valu plzzzzzzzzzzzzz

5 REPLIES 5
Read only

Former Member
0 Likes
776

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

Read only

Former Member
0 Likes
776

hi,

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

Read only

0 Likes
776

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

Read only

former_member125931
Active Participant
0 Likes
776

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.

Read only

Former Member
0 Likes
776

okey