cancel
Showing results for 
Search instead for 
Did you mean: 

Total number of bills for Contract

devashish_bhattacharya
Active Participant
0 Kudos

Hello Experts,

Is it possible to get the total number of bills that get generated for a contract in ECC?

If yes, please let me know in which table should I root to.

I think this can be seen in DMR. But I need to get the total count.

Regards,

Dev

Accepted Solutions (0)

Answers (5)

Answers (5)

Former Member
0 Kudos

Hi Devashish ,

As Told by Jose, you can get the Invoice number against the contract from VBFA table by placing the input as Contract number, Since your requirement is to get the Invoices according to USER ID for the respective contract, Take all those Invoices from VBFA table which has document category 'M' and place the same in VBRK table with the user ID  VBRK-ERNAM and  execute.

Now You will get the invoices which are created by respective user against your service contract.

Please let me know if any clarifications are required.

Thanks&Regards,

Raghavendra.K

Former Member
0 Kudos

Hi,

Please use this FM 'RV_ORDER_FLOW_INFORMATION' which gives all the details about document flow.

Regards

SD

devashish_bhattacharya
Active Participant
0 Kudos

Hi,

I want like how many bills have been generated for the user for a service contract ( 2,3,5) like that.

Is there any table which stores it so that I can fetch it using Contract ID?

Regards,

Devashish

jobis
Contributor
0 Kudos

Hi Devashish,

I dont think, you will get it from a single table.

As suggested in the first post, VBFA table will give you the invoice nos . Then use VBRK for other details of the invoice.

Use an ABAP Query for the custom report.

Thanks

Jobi

Lakshmipathi
Active Contributor
0 Kudos

Go to SE16, input table VBAK, user id, document type and click on "Number of entries" on top.  It will show the cumulated figure.

G. Lakshmipathi

ravi_kumar100
Active Contributor
0 Kudos

Hi,

You are referring to Quantity /Value or Service Contract in SAP ?

Regards,

SRK

joseantonio_martinez
Active Contributor
0 Kudos

Dear Devashish:

Try with table VBFA:

VBFA-VBELV Contract

VBFA-VBTYP_N = M for invoice document.

VBFA-VBELN = Invoices

Check it and revert.

Jose Antonio