link bkpf_vbak

[naveen_inuganti2]

hi...

IAM GOING JOIN THE TABLES BKPF AND VBAK WHAT IS THE LINK????

Thank you,

Naveen

[Former Member]

please reward points if useful

[Former Member]

Hi,

There is no direct realation b/w vbak and bkpf.

First from vbak to vbap>lips>then link vbrp-VBELN = bkpf-awkey.

Regards

Kiran Sure

[naveen_inuganti2]

can you againd send this link... clearly..

iam not understand... that sentence...

[Former Member]

hi naveen the relation b/w bkpf and vbak is:

u can link with company code.

like BKPF-BUKRS = VBAK-BUKRS_VF.

bkpf-bukrs --> company code and

vbak-bukrs_vf --> comp code to be billed.

points if satisfied,

Rgds,

sudeer.

[Former Member]

hi,

go through this:

u can link bkpf and vbak with company code.

BKPF-BUKRS = VBAK-BUKRS_VF.

like

SELECT a~bukrs

a~belnr

a~gjahr

b~vbeln

b~objnr

b~bukrs_vf

FROM bkpf AS a INNER JOIN vbak AS b

into TABLE itab WHERE ( a_{bukrs = b} bukrs_vf ).

( or )

into CORRESPONDING FIELDS OF TABLE itab

WHERE ( a_{bukrs = b} bukrs_vf ).

Rewards for usful help,

Rgds,

sudharsan.