debit memo request to accounting document report

[Former Member]

Hello,

Our client wishes to be able to see, on one report, the debit memo request number as well as the resulting accounting document number at the end of the transaction flow.  I haven't been able to fulfill the request yet.  I am wondering if there is some way to work through linking two reports through DMR = invoice and then invoice = accounting document.  I can get the latter, but the DMR = invoice number in report form is tripping me up.  Any suggestions would be appreciated!

[Former Member]

Hi Anthony

You have to fetch the data from VBFA . VBFA document flow always creates Performance issue while filtering proceeding and follow on documents .   Please speak to your abaper.There are functional module available which will help to get the VBFA data fast .

   Please go though the below link

It will help you .

Regards

Santosh Verma

[Former Member]

Hi Anthony,

You can contact to your ABAPer and ask him/her to create a report on the logic given below.

Pass the DMR number to table VBFA --> You will get DMR (VBELV) and Debit Memo (VBELN)

Now Take the Debit Memo (VBELN) Number

Pass it in the table BKPF in the field AWKEY --> You will get Account doc (BELNR)

Hope it helps

MT

[former_member184701]

did you check the relevant entries in VBFA ?

try VBFA-VBTYP_N = 'L'