05-28-2008 7:57 AM
Hi Experts,
I have to find out consumption of meter and check meter in a particular month/period please give me table of FM which give details of consumption.
Any help will be highly rewarded.
Regards
Bikas
05-29-2008 10:51 AM
Hi,
Usually the consumption is stored at register level and hence not at the device/meter level....
Hence check out the tables for register data...
EASTS or EASTL
Also to find the corresponding FM, try : <Table> you may get the related FM that fetched/udpates data in these tables.
some of them can also be useful to you:
Meter reading document for Equipment/Device
ISU_DB_EABL_SELECT_EQUNR
ISU_DB_EABL_SELECT_EQUNR_ENT
ISU_DB_EABL_SELECT_EQUNR_PRE
ISU_DB_V_EABL_SELECT_EQUNR_ALL
EASTS : Billing data: Installation Structure at Reg. Level
ISU_DB_EASTS_FORALL
ISU_DB_EASTS_FORALL_ANLAGE
ISU_DB_EASTS_FORALL_LOGIKZW
ISU_DB_EASTS_RATETYPE_SELECT
ISU_DB_EASTS_SELECT
ISU_DB_EASTS_SINGLE
ISU_DB_EASTS_UPDATE
Reward if useful
Regards
Shiva
05-29-2008 11:15 AM
Hi Shiva,
I can you please give me the logic how to Retrive consuption from these tables.
Actually i have to design a report which will show the consumption of device for a selected period.
Regards
Bikas
05-29-2008 1:51 PM
Hi,
You can use the Table DBERCHV for history consumption.
This table usualy used in reports for history consumtion.
regards,
Deepak.
05-30-2008 7:07 AM
Hi Deepak,
Thanx for your reply, but in our organization they r not maintaining/using table DBERCHV
Can you please suggest some other table of FM from where Consuption report can be prepared.
Regards
Bikas
05-30-2008 10:07 AM
Hi Bikas,
Try the Table ETTIFN and ETTIFB , I think it will solve your problems.
regards
Deepak