table link

[Former Member]

Hi all,

I have invoice(VBELN) no and i want accounting document no(BELNR).

Table name VBRP and BSIM.

Does anyone tell me link between these two tables?

here, vbrp has belnr but, it is always comming blank.

Thanks in advance

Parag

[Former Member]

Hi,

if it is a customer invoice then you can get the acc. doc. in tables BSID and BSAD. The link will be on VBELN. If not vbeln then VBRK-VBELN = BSID-ZUONR.

Also in your case what u r talking about, the VBRK-VBELN = BSIM-BELNR might also be possible if the accounting document no. is configured that way. There is a provision in config. where for a no. range a checkbox EXT has to be checked.

Just check if it is like that.

regards,

Satya

[FredericGirod]

Use transaction ST05 to make a SQL trace.

You could use the BKPF-AWKEY field. And a lot of links between documents (SD) are in the VBFA table.

Frédéric