joins

[Former Member]

hi

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 .

[Former Member]

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

[Former Member]

Hi,

let me know your selection screen fields.

[Former Member]

selection screen fields are

lfb1-lifnr

lfb1-bukrs

[Former Member]

selection screen fields are

lfb1-lifnr

lfb1-bukrs

[Former Member]

selection screen fields are

lfb1-lifnr

lfb1-bukrs

[Former Member]

selection screen fields are

lfb1-lifnr

lfb1-bukrs

[ThomasZloch]

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.

[Former Member]

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