join two tables BKPF and VBRK

[Former Member]

I need a report that will join two tables BKPF and VBRK in QuickViewer. The only field with the right character length is XBLNR but when creating the join no records are dispalyed beacuse the values of this field in both tables are not the same.

There are also other fields available in BKPF but the char length is not the appropriate.

Does anyone have any idea how I can link these two tables?

Thank you

[iklovski · Accepted solution]

Hi,

Try connecting ZUONR in VBRK with BELNR in BKPF. Alternatively, connect AWKEY in BKPF with VBELN in VBRK.

Regards,

Eli

[Former Member · Accepted solution]

Neither of these combinations is possible with QuickViewer because the fields need to have the same length of characters in order to create the join.

VBRK - VBLEN char(10) and BKPF - AWKEY char(20)

VBRK -ZUONR char(18) BKPF- BELNR char (10)

Any other idea?

Thank you, JP

[Former Member · Accepted solution]

Hi,there field BELNR in BKPF and VBRK. Also use BUKRS and GJAHR

[Former Member · Accepted solution]

Hi,

You are right field BELNR could do the job but there are no records for it in table VBRK ( it is empty).

So even though I can create the join fine no data is produced.

[iklovski · Accepted solution]

Hi,

The data format is indeed different (because the reference fields are multipurposal). But if you look at the tables directly, you will see that this is the link that exist.

Regards,

Eli

[Former Member]

Hii..

Try to use XBLNR-BKPF & XBLNR-VBRK.they have same character lenght.

Regards,

Aakash

[Former Member]

These ( XBLNR) fields that you suggested don't have the same value ( in both tables) in our business solution, meaning in table BKPF it gets the value of the serial of the invoice after it is printed.

Is there any other table despite BKPF where I can get Financial Accounting data?

Thank you any way