Reference billing date required for reference invoice

[Former Member]

Hi experts,

My requirement (In case of Return Invoice) is to get the reference invoice date of the reference billing document. Right now I am using VBRK to access the reference invoice number but I cannot find the billing date of the reference document.

E.g:

In case of credit for returns billing document:

Invoice document number.: 11111111 (VBRK-XBLNR)

Billing date : 01.01.2015 (Required?)

Credit for returns document number : 2222222 (VBRK-VBELN)

Billing date: 05.01.2015 (VBRK-FKDAT)

Any help in this regard will be highly appreciated.

Regards,

Moaz Ali

[moazzam_ali · Accepted solution]

Hi

Where do you require this number? In some report or routine or where?

Wherever you require this you have to pass the VBRK-XBLNR to VBRK again and get its billing date. System saves billing date with its document number in VBRK.

Thank$

[Former Member · Accepted solution]

I require this in a report (SAP Query), could you guide me as to how to get the reference billing date.

[moazzam_ali · Accepted solution]

Hi

In query report it would be difficult but not impossible. You have to make an additional report and write code in it. Take help of some ABAPER and tell him the logic. He'll write logic and can get the date. Logic I have already shared in my earlier post.

Thank$

[Former Member · Accepted solution]

Thanks! I will try it

[vijay_padmaraja]

Hi Mr.Ali,

I dint try your exact scenario, but I have used VBRK and VBRK (alias) and have tried a dummy query. Think it makes sense?

Regards

Vijay