topic Re: link bkpf_vbak in Application Development and Automation Discussions

link bkpf_vbak

naveen_inuganti2 — Wed, 21 May 2008 06:39:18 GMT

hi...

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

Thank you,

Naveen

Re: link bkpf_vbak

Former Member — Wed, 21 May 2008 06:47:01 GMT

please reward points if useful

Re: link bkpf_vbak

Former Member — Wed, 21 May 2008 06:56:47 GMT

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

Re: link bkpf_vbak

Former Member — Wed, 21 May 2008 07:00:46 GMT

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.

Re: link bkpf_vbak

Former Member — Wed, 21 May 2008 07:10:50 GMT

hi,

go through this:

u can link bkpf and vbak with company code.

BKPF-BUKRS = VBAK-BUKRS_VF.

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.

Re: link bkpf_vbak

naveen_inuganti2 — Wed, 21 May 2008 07:27:20 GMT

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

iam not understand... that sentence...