Jumat, 16 Maret 2012

ABAP - Holiday Table

THOLU - Dates of movable public holidays (Holiday Transaction)
* FTGID : Public hol. ID
* JAHR : Year stored
* MONAT : Month
* TAG : Day

THOL - Public Holidays (Holiday Master)
* FTGID : Public hol. ID
* SORT : Sort criterion

THOLT - Public holiday texts
* FTGID : Public hol. ID
* SPRAS : Language
* LTEXT : Holidays long text

Join table: 
JOIN THOLU-FTGID = THOL-FTGID
JOIN THOL-FTGID = THOLT-FTGID
Condition:
WHERE THOLU-JAHR = <year transaction>
AND THOLU-MONAT = <month transaction>
AND THOLU-TAG = <day transaction>
AND THOL-SORT = 'ID'
AND THOLT-SPRAS = 'EN'
Get:
THOLT-LTEXT 


Holiday Function
Data: it_iscalday TYPE STANDARD TABLE OF iscal_day WITH HEADER LINE.


CALL FUNCTION 'HOLIDAY_GET'
        EXPORTING
          holiday_calendar = 'ID' <Indonesia>
          factory_calendar = 'ID'  <Indonesia>
          date_from           = <date from>
          date_to               = <date to>
        TABLES
          holidays              = it_iscalday.


*Get holiday name
it_iscalday-txt_long