Find Work Schedule Based on DWS

Report HR ini di gunakan untuk menemukan work schedule rule based on daily work schedule.

Berikut tampilan reportnya :

Report Query :

Report result :

Double click work schedule rule then u’ve got this connection to TCODE PT03

Table yang digunakan :

T550a – daily work schedule
T552a – monthly work schedule
T508S – Text Table for Work Schedule Rules

R/3 HR Module : Get Organizational Unit

Table T527X dipakai jika ada enterprise yang tidak implementasi
module organizational management, tabel ini isinya organization short text
sedangkan bila implementasi module management gunakan function dibawah ini untuk mengambil long text dari organization unit and description

*———————————————————————————————–*
* Program       : ZFM_GET_ORGANIZATIONAL_UNIT                                  
* Desription    : Get Organization Unit and Description 
*———————————————————————————————–*
FUNCTION zfm_get_organization_unit
*”———————————————————————————————–
*”*”Local Interface:
*” IMPORTING
*” VALUE(P_PLANS) TYPE PLANS
*” VALUE(P_ENDDA) TYPE ENDDA DEFAULT SY-DATUM
*” EXPORTING
*” VALUE(ORGEH) TYPE ORGEH
*” VALUE(ORGEHDES) TYPE HRLINE79

  DATA : m_plvar TYPE plvar,
         m_sobid TYPE sobid.

  CALL FUNCTION ‘RH_GET_ACTIVE_WF_PLVAR’
    IMPORTING
      act_plvar       = m_plvar
    EXCEPTIONS
      no_active_plvar = 1
      OTHERS          = 2.

  m_sobid = p_plans.
  SELECT SINGLE objid
    INTO orgeh
    FROM hrp1001
    WHERE otype = ‘O’ AND plvar = m_plvar AND rsign = ‘B’ AND relat = ‘003′ AND
          sobid = m_sobid AND sclas = ‘S’.
  SELECT SINGLE d~tline
         FROM hrp1002 AS h INNER JOIN hrt1002 AS d ON
                         h~mandt = d~mandt AND
                         h~tabnr = d~tabnr
         INTO orgehdes
         WHERE h~plvar = m_plvar AND h~otype = ‘O’ AND
               h~objid = orgeh AND h~endda >= p_endda.