topic Re: joins in Application Development and Automation Discussions

joins

Former Member — Thu, 03 Jan 2008 12:59:36 GMT

i need to get the data from LFB1 table, fields are lifnr , bukrs, erdat

where this lifnr should not be in BSIK and BSAK TABLE

Can anyone help me how to get that data.

do i need to use joins,

please help me if any one as code .

Re: joins

Former Member — Thu, 03 Jan 2008 13:03:23 GMT

u need to use outer join for this purpose

u try with this

SELECT a_{lifnr a}bukrs a~erdat

INTO TABLE <internal table>

FROM lfb1 as A LEFT OUTER JOIN bsik as B

ON A_{lifnr = B}lifnr and A_{bukrs = B}bukrs

left outer join bsak as c

ON A_{lifnr = c}lifnr and A_{bukrs = c}bukrs.

madhavi

Re: joins

Former Member — Thu, 03 Jan 2008 13:03:40 GMT

Hi,

let me know your selection screen fields.

Re: joins

ThomasZloch — Thu, 03 Jan 2008 13:07:35 GMT

out of my head...but try yourself.

SELECT ... INTO TABLE ...
FROM LFB1
LEFT JOIN BSIK ON LFB1~BUKRS = BSIK~BUKRS
              AND LBF1~LIFNR = BSIK~LIFNR
LEFT JOIN BSAK ON LFB1~BUKRS = BSAK~BUKRS
              AND LFB1~LIFNR = BSAK~LIFNR
WHERE BSIK~BUKRS = SPACE
   AND BSAK~BUKRS = SPACE.

Re: joins

Former Member — Thu, 03 Jan 2008 13:50:09 GMT

selection screen fields are

lfb1-lifnr

lfb1-bukrs

Re: joins

Former Member — Thu, 03 Jan 2008 13:50:22 GMT

selection screen fields are

lfb1-lifnr

lfb1-bukrs

Re: joins

Former Member — Thu, 03 Jan 2008 13:50:24 GMT

selection screen fields are

lfb1-lifnr

lfb1-bukrs

Re: joins

Former Member — Thu, 03 Jan 2008 13:50:26 GMT

selection screen fields are

lfb1-lifnr

lfb1-bukrs

Re: joins

Former Member — Thu, 03 Jan 2008 14:02:06 GMT

Hi hema latha,

SELECT LFB1_{LIFNR LFB1}BUKRS LFB1~ERDAT into corresponding fields of table ITAB

FROM LFB1 WHERE BSIK_{LIFNR EQ BSAK}LIFNR .

IF THIS DOESNOT WORK SEND ME YOUR CODE I WILL SEE IN TO IT.

rEWARD IF USEFULL

THANKS,

SWAROOP