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: 

Billing Tables Relationship -

Former Member
0 Kudos

Hi ALL

Could any one tell ISU Billing tables relationships like Header- line items - consumption history

some of tables not updated, how to update these tables

for ex: DBERCHV Consumption history, DBERCHZ line items.

Thanks in ADVANCE............KK

Edited by: KK on Dec 15, 2008 1:41 PM

3 REPLIES 3

Former Member
0 Kudos

Hi,

The header table for billing related information is stored in ERCH and all line items are stored in tables DBERCHZ(1 to 8). I do not have any idea as to why DBERCHZ and DBERCHV are not filled whenever billing is done. But you can use tables ERCH and DBERCHZ1, DBERCHZ2 .... DBERCHZ8 to get all billing document relevant information.

Else there are standard FMs like BAPI_BILLINGDOC_GETDETAIL and BAPI_BILLINGDOC_GETLIST to get all billing relevant information.

Thank you,

Binno Don Thomas

0 Kudos

Binno Don Thomas,

Hi,

As you have mentioned these tables are used to fetch billing related information. can you also suggest, what if these tables are not being updated. As there is no data in DBERCHZ table, but we are able to find data in DBERCHZ1...DBERCHZ8.

There was a program developed for our client during implementation. This FM Fetches data from Table DBERCHZ. currently there is no data in this table and ticket was raised.

Please help so that we could resolve this query.

I would appreciate your help and look forward to maintain healthy contact.

Former Member
0 Kudos

Thank You