regarding joins

hi experts,

i am sending you the code.i have used the following join conditions.but it is not fetching any data.plz check it once.make the corrections if required or suggest me what else i can do...

PARAMETER CMP_CD LIKE BKPF-BUKRS.

SELECT-OPTIONS VENDOR FOR BSIK-LIFNR.

SELECT-OPTIONS P_DATE FOR BKPF-BUDAT.

DATA: BEGIN OF STRUCT,

BELNR LIKE VBRK-BELNR,

LIFNR LIKE BSIK-LIFNR,

BUDAT LIKE BKPF-BUDAT,

VBELN LIKE VBRK-VBELN,

ORT01 LIKE LFA1-ORT01,

ORT02 LIKE LFA1-ORT02,

PSTLZ LIKE LFA1-PSTLZ,

STRAS LIKE LFA1-STRAS,

END OF STRUCT.

DATA ITAB LIKE STRUCT OCCURS 0 WITH HEADER LINE.

AT SELECTION-SCREEN.

CASE SY-UCOMM.

WHEN ' '.

SELECT A_{VBELN B}LIFNR A_{BELNR C}BUDAT D_{ORT01 D}ORT02 D_{PSTLZ D}STRAS

INTO CORRESPONDING FIELDS OF TABLE ITAB

FROM BKPF AS C INNER JOIN VBRK AS A ON ( C_{BUKRS = A}BUKRS ) AND (

C_{BELNR = A}BELNR ) INNER JOIN BSIK AS B ON ( A_{BUKRS = B}BUKRS ) AND (

A_{BELNR = B}BELNR ) INNER JOIN LFA1 AS D ON ( B_{LIFNR = D}LIFNR )

WHERE C_{BUDAT IN P_DATE AND B}LIFNR IN VENDOR AND C~BUKRS = CMP_CD.

regards,

raman