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
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

EAC Time Slice

Former Member

‎09-07-2010 1:27 PM

0 Kudos

Hi Experts,

In EG71, the time slice data is available for each Installation.

Now, a report we are working on, has a requirement that we capture these Time Slice Data in that.

We have checked that the time slices are actually populated based on changes in several tables (EASTE, EASTS, EGERR, ETDZ etc etc.), and hence we are unable to find a single table which store this Time Slice data.

In Table EASTE ,we do get the Time Slices but the BIS (To Date) in this table is defaulted to 1 year from the (AB) From Date.

Thus our validations fail here, as the the BIS (From Date) does not match with the actual dates in the EG71 Time Slice.

We have checked EASTS Table also, but it does not solved our purpose.

We checked in Debugging also, that the BIS date is AB Date -1 for the next time slice, and hence tried to implement that logic also, but it also fails in certain cases.

Has anyone of you worked on similar requirement / know which table I can get the actual Time Slice data ?

Kindly provide any information on the same.

Thanks

1 REPLY 1

Former Member

‎09-09-2010 10:35 AM

0 Kudos

Hi,

As you have mentioned correctly , it is indeed a combination of multiple tables.

Try using this below logic :



DATA: ieaste TYPE TABLE OF easte WITH HEADER LINE,
      ieastl TYPE TABLE OF eastl WITH HEADER LINE,
      ieasts TYPE TABLE OF eastl WITH HEADER LINE,

      x_tmp   TYPE isu07_timepoint_tab ,
      y_tms   TYPE isu07_timeslice_tab ,
      lwa_tmp TYPE isu07_timepoint,
      lwa_ref TYPE d.

****
*SELECTS.....
* INTO ieastl..ieasts...ieaste
****

LOOP AT ieastl.

  lwa_tmp-base = ieastl-ab.
  lwa_tmp-type = 'A'.
  COLLECT lwa_tmp INTO  x_tmp.

  lwa_tmp-base = ieastl-bis.
  lwa_tmp-type = 'B'.
  COLLECT lwa_tmp INTO  x_tmp.
ENDLOOP.


LOOP AT ieasts.

  lwa_tmp-base = ieasts-ab.
  lwa_tmp-type = 'A'.
  COLLECT lwa_tmp INTO  x_tmp.

  lwa_tmp-base = ieasts-bis.
  lwa_tmp-type = 'B'.
  COLLECT lwa_tmp INTO  x_tmp.
ENDLOOP.


SORT x_tmp BY base.
READ TABLE x_tmp INTO lwa_tmp INDEX 1.
lwa_ref = lwa_tmp-base.

LOOP AT ieaste WHERE ab GE lwa_ref .
  lwa_tmp-base = ieaste-ab.
  lwa_tmp-type = 'A'.
  COLLECT lwa_tmp INTO  x_tmp.
ENDLOOP.


CALL FUNCTION 'ISU_CONSTRUCT_TIMESLICE'
  TABLES
    tx_timepoint = x_tmp
    ty_timeslice = y_tms.

  • Not tested for all the scenarios ....

Regards,