link between invoice no and payment clearing document no

[Former Member]

Hi sap gurus,

in a reoprt i have to show the payment receive date against the invoice no. i can have the invoice no by customer no (KUNNR) and date range. now i am facing problem how to link invoice document no with payment clearing document no. Because while receiving payment from customer (t code F-28) we are receiving against a invoice. But i checked in BSEG,BSID BSAD but nowhere i was able to track the linkage. Please help.

regards,

BKR

[Lakshmipathi · Accepted solution]

In billing document at header level, you can see two fields, viz.

a) XBLNR Reference Document Number and

b) ZUONR Assignment number

These two fields you can see in FBL5N. Whatever copy control you set in VTFL at header level for these two fields, based on that values will be populated in billing document which will then be passed on to FI just for information.

But these two fields are not stored in any table but in structure. However, you can check in BKPF with field XBLNR which will have link between VBRK (billing document ) and BKPF (Accounting document)

thanks

G. Lakshmipathi