topic Re: List of Standard DataSources/Tables for IS Utility in SAP for Utilities Discussions

List of Standard DataSources/Tables for IS Utility

Former Member — Thu, 28 Apr 2016 14:49:34 GMT

Dear all,

I am working on a ISU implementation project for a company that sells water to different municipalities. This is my first ISU project.

I would like to know the names of standard Tables/DataSources in ECC that show Volume, REvenue and Tarrif fields. I need to develop a report that has the fields

Business Unit, Customer, System, Business Unit No., Object Account, Tariff, Volume and Revenue. I guess Revenue is a calculated field which is Volume * Tariff.

Please let me know if there is/are any standard tables/datasources that come with the fields mentioned above.

Thank you.

Regards,

Pavan.

Re: List of Standard DataSources/Tables for IS Utility

ivor_martin — Thu, 28 Apr 2016 15:52:55 GMT

This message was moderated.

Re: List of Standard DataSources/Tables for IS Utility

former_member199650 — Fri, 29 Apr 2016 05:13:17 GMT

Hi,

Following are some important tables in SAP IS-U:

FKKVKP - CA Data

EVER - Contract Data

DFKKKO (Header Data in Open Item Accounting Document) and DFFKOP (Items in contract account document) - Postings and Clearing information Data

DFKKZK and DFKKZP - Payment data

EANL - Installation Master Data

EANLH - Installation with Rate Category and MRU Data

ETTIFN - Installation Facts data

EASTS - Installation with Logical Register Data

ETDZ - Logical Register No. to Device Mapping Data

EGERH - Historical Data of ISU Device Master Record

With Best Regards

MP Vashishth

Re: List of Standard DataSources/Tables for IS Utility

william_eastman — Mon, 02 May 2016 20:20:54 GMT

Pavan:

Look at the standard datasources in RSA5.

regards,

bill.

Re: List of Standard DataSources/Tables for IS Utility

Former Member — Tue, 03 May 2016 11:30:46 GMT

Hello Pavan,

You can have a look at the enclosed screenshot to take an idea for the known IS-U tables in resume.

With kind regards,

Zerman

Re: List of Standard DataSources/Tables for IS Utility

Former Member — Sun, 08 May 2016 20:10:52 GMT

Hi William and Serkan,

Thanks a lot for your replies. I have looked at the data sources in RSA5 and also the ppt that has the list of all the ISU tables and could find these two data sources

0UC_SALES_STATS_01

0UC_SALES_STATS_02

that are similar to what I am looking for. But these 2 data sources do not have all the fields. For instance the fields Customer, Business Unit and B.Unit. No. are not there in these 2 data sources. I looked the the EVER table and that has the data related only to Customer. But I am unable to figure out the data source to which the table EVER is being loaded. I've checked the tables ROOSOURCE, ROOSFIELD, & ROOSGEN but could not get any help.

What I need now is, when I know the table/s in ECC, how do I locate its corresponding datasource in ECC from where I can extract the data? In other words the tables EVER, V_TESPT, EVBS and EANL are pointing to what data sources in ECC in RSA5? How can I figure this out?

Please advise.

Thank you.

Regards,

Pavan.

Re: List of Standard DataSources/Tables for IS Utility

Former Member — Tue, 10 May 2016 09:03:55 GMT

Hello Pavan,

I've just had a look at the data sources through RSA5 and found the ones in question.

When the cursor is on the expand button at the top, click on it or just use the following key combination (Ctrl+Shift+F11) then all the data sources will be shown.

When its done just search the data sources' name, you should be able to find them easily.

I hope the below screenshots help you a bit to find the data sources.

With kind regards,

Serkan Zerman