SAP for Utilities Discussions
Connect with fellow SAP users to share best practices, troubleshoot challenges, and collaborate on building a sustainable energy future. Join the discussion.
cancel
Showing results for 
Search instead for 
Did you mean: 

Get all billing documents for a specific contract

Former Member
0 Kudos

Hi,

does anyone know of a way to retreive all billing documents for a specific contract without going through all bills of the contract account ?

When we go through the contract account we must retrieve all bills to check if they are associated to that contract or not. This causes performance problems for contract accounts that have many contracts (and many bills). We have certain cases where a contract has 30 bills but the contract account has over 350 bills.

Thanks

Thierry

1 ACCEPTED SOLUTION

Former Member
0 Kudos

Hi,

Check in the table DBERLDB.

Entry the Contract number in the field vertrag

and look for the field billdoc.

This will display all the billing documents for that particular contract.

Regards,

Vinay

View solution in original post

2 REPLIES 2

Former Member
0 Kudos

Hi,

Check in the table DBERLDB.

Entry the Contract number in the field vertrag

and look for the field billdoc.

This will display all the billing documents for that particular contract.

Regards,

Vinay

0 Kudos

Thanks,

I'm just wondering about this table , I have much (3 000 000) less contracts than in table EVER and I'm sure that all contracts were at least billed once.

Thierry