topic Re: inner join in Application Development and Automation Discussions

inner join

Former Member — Thu, 04 Feb 2010 14:40:11 GMT

hi,

i have select statement like this. now i found out that matnr stored in vbrp is 72341 whereas matnr in mbew is with leading zero 000000000000072341. may i know how can i use FM 'CONVERSION_EXIT_ALPHA_INPUT' below as no way i can insert this FM within inner join.

any advice?

SELECT vbrp~matnr vbrp~werks vbrp~fkimg vbrp~vrkme
                 mbew~vprsv mbew~verpr mbew~stprs mbew~peinh
                 marm~umrez marm~umren 
            INTO TABLE itab
                  FROM vbrp
            INNER JOIN mbew
                    ON vbrp~matnr EQ mbew~matnr
                   AND vbrp~werks EQ mbew~bwkey
            INNER JOIN marm
                    ON mbew~matnr EQ marm~matnr
                   AND vbrp~vrkme EQ marm~meinh.

thanks

rgds

Moderator message - Please use code tags to format your code

Edited by: Rob Burbank on Feb 4, 2010 10:03 AM

Re: inner join

Pawan_Kesari — Thu, 04 Feb 2010 14:56:56 GMT


> i found out that matnr stored in vbrp is 72341 whereas matnr in mbew is with leading zero 000000000000072341.

This seems unlikely as both field are defined using same data element MATNR.

Is your select statement not working?

Re: inner join

Former Member — Thu, 04 Feb 2010 15:00:22 GMT

hi,

i think matnr stored with leading zero after further check. guess matnr not causing the problem.

the select statement is not fetching any data to my internal table. but i check all relevant table, data is in the table and it should be able to map.

any wrong with the select statement?

thanks

Re: inner join

Pawan_Kesari — Thu, 04 Feb 2010 15:25:01 GMT

Start with query

SELECT ....
            INTO TABLE itab
                  FROM vbrp
            INNER JOIN mbew
                   AND vbrp~werks EQ mbew~bwkey

if above works add more condition

SELECT ...
            INTO TABLE itab
                  FROM vbrp
            INNER JOIN mbew
                    ON vbrp~matnr EQ mbew~matnr
                   AND vbrp~werks EQ mbew~bwkey

and more..

SELECT ..
            INTO TABLE itab
                  FROM vbrp
            INNER JOIN mbew
                    ON vbrp~matnr EQ mbew~matnr
                   AND vbrp~werks EQ mbew~bwkey
            INNER JOIN marm
                    ON mbew~matnr EQ marm~matnr
                   AND vbrp~vrkme EQ marm~meinh.

result will help you understand the problem