SD- FI Table link

[Former Member]

Hi,

I am unable to find any BELNR(FI document no) entry in VBRK table. The field is blank in the VBRK table though the document has been posted to accounting and I am able to see the accounting document in VF02.

Can any body help me?

Regards

[Former Member · Accepted solution]

Hi,

Customer master to sales order sold-to party

KNA1-KUNNR = VBAK-KUNNR.

Sales order line item to delivery.

LIPS-VGBEL = VBAK-VBELN

LIPS-VGPOS = VBAP-POSNR.

Billing document line item to delivery

VBRP-VGBEL = LIPS-VBELN.

VBRP-VGPOS = LIPS-POSNR.

Billing document to accounting document.

VBRK-VBELN = BKPF-AWKEY & BKPF-AWTYP = 'VBRK'

Regards,

Rajesh Banka

Edited by: Rajesh Banka on Feb 19, 2008 8:20 PM

[Former Member]

VBRK-XBLNR = BKPF-XBLNR

Check this. This should meet your requirement.

Regards,

Rajesh Banka

[Former Member]

Hi,

Frist confirm whether it is posted to accounting.

T.code .Vf02 can check through document flow. ( if there it is not posted it shows here)

Use t.code VF02 try releasing to accounting once again from Menu Bar----Billing document --- Release to accounting or click on the Flag tab next to document flow icon. ( if u face any error during release then follow as below:

Use T.code Vf02 enter into the intial screen

Menu bar---Enivornment -Accounting document analysis revenue account.

check here whether accounting determination took place.

or if the error is something else related to FI can check with FI consultant.

kinldy Reward points if usefull

Regards

vK