SAP Reports / Programs | Payroll(PY) SAP PY

RPCTRXT0 SAP ABAP Report - Medium creation for ISCP Trexima







RPCTRXT0 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). It is used for Trexima program for making ISCP files Trexima program for making ISCP files It necessary to set following options for a proper functioning: - settings of table T5T47N (Types of labour relation CZ) of employment status (in compliance with CZ-ICSE classification)...see full standard documentation available for this report. Also check out the submitted Comments related to this SAP report and the details below to see which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC.

If you would like to execute this report or see the full code listing simply enter RPCTRXT0 into the relevant SAP transactions such as SE38 or SE80


Transaction Code(s):

Below is a list of transaction codes which are relevant to this SAP report

PC00_M18_TREXIM - Medium for ISCP Trexima


ABAP code to call this SAP report using the submit statement

This report can be called from another progam/report simply by using the ABAP SUBMIT statement, see below for example ABAP code snipts of how to do this.






SUBMIT RPCTRXT0. "Basic submit
SUBMIT RPCTRXT0 AND RETURN. "Return to original report after report execution complete
SUBMIT RPCTRXT0 VIA SELECTION-SCREEN. "Display selection screen of submitted report to user
    See more syntax options for the ABAP SUBMIT statement


Text pool values


Selection Text: A_ULICE = Street
Selection Text: DATNAST = Hire date from IT0041
Selection Text: FINKONT = Fin.control (majority owner)
Selection Text: ICO = ICO
Selection Text: KOLSML = Collective agreement
Selection Text: KVART = Quarter
Selection Text: LAU1 = Region (like LAU1)
Selection Text: L_ECLOFS = Evaluation class
Selection Text: NAZEV = Name
Selection Text: OKEC = OKEC
Selection Text: OKRES = Region (like CZ-NUTS)
Selection Text: PAVGH202 = Hours for PRUMVYD from WT /202
Selection Text: PA_ASC = Output file TXT
Selection Text: PA_DBF = Output file DBF
Selection Text: PA_XML = Output file XML
Selection Text: PFORMA = Organization unit legal form
Selection Text: P_ABCX = 'X' - paid holidays from ABC
Selection Text: P_CODEP = Code page
Selection Text: P_DWNAS = To application server
Selection Text: P_DWNPC = To PC
Selection Text: P_EVID = 'X'- only EEs with EVIDDNY > 0
Selection Text: P_FONDRT = 'X' - edit FOND by RT
Selection Text: P_FONDSJ = 'X'- only EEs with FONDSJE > 0
Selection Text: P_FONDST = 'X'- only EEs with FONDSTA > 0
Selection Text: P_FPSP = 'X ' - FONDSTA,FONDSJE by PPD
Selection Text: P_MP2011 = 'X' - generate MP file always
Selection Text: P_ORGPR = 'X' - Org.ass.WPBP/' ' fr. IT1
Selection Text: P_PRUMV = 'X' - Aver.income from /T11
Selection Text: ROK = Year
Selection Text: SHRT = Reduction of long-term revenue
Selection Text: ZAKONODM = Law for remuneration in org.
Selection Text: ZEROMZDA = 'X'- only EEs with income > 0
Selection Text: A_PSC = Postal code
Selection Text: A_MISTO = Place of organization
Selection Text: A_CP = House number
Title: Medium creation for ISCP Trexima
Text Symbol: 001 = Data download to the file/floppy disk failed !
Text Symbol: 002 = Period sel.





Text Symbol: 003 = Other parameters
Text Symbol: 010 = Processed period :
Text Symbol: 011 = Averag.for period:
Text Symbol: 012 = Number of records:
Text Symbol: 013 = Registrat. status:
Text Symbol: E01 = Incorrect entry!!! Allowed are only values:
Text Symbol: E02 = 'SHRT', 'SHTT', 'SHRP', SHTP, ' '.
Text Symbol: ER0 = Calender was not generated for pers.number:
Text Symbol: PHM = M
Text Symbol: PHZ = Z
Text Symbol: S00 = Entry "Educat."
Text Symbol: S01 = Complete educat.
Text Symbol: S02 = Educ.est.t
Text Symbol: S03 = KKOV
Text Symbol: STT = Key date: dd.mm.yy
Text Symbol: T00 = Ent."Pay scale level"
Text Symbol: T01 = Infotype 0008
Text Symbol: T02 = Table T5T10
Text Symbol: T03 = Code KZAM form 6 to 5 places
Text Symbol: T04 = left
Text Symbol: T05 = right
Text Symbol: V01 = Execute download
Text Symbol: V02 = to PC
Text Symbol: V03 = to appl.server
Text Symbol: V04 = Code page for download
Text Symbol: ZRM = Evaluation period: dd.mm.yy to dd.mm.yy


INCLUDES used within this REPORT RPCTRXT0

INCLUDE RPC2CD00.
INCLUDE RPC2RX01.
INCLUDE RPC2RX02.
INCLUDE RPC2RTT0.
INCLUDE RPPPXD00.
INCLUDE RPPPXD10.


TABLES used within REPORT and the associated SELECT statement:

No SAP DATABASE tables are accessed within this REPORT code!


Function Modules used within report and the associated call statement:

HR_CZ_HIRE_FIRE CALL FUNCTION 'HR_CZ_HIRE_FIRE' "XI/07 IMPORTING "XI/07 hire_date = hire "XI/07 fire_date = fire "XI/07 TABLES "XI/07 pphifi = pphifi "XI/07 pp0000 = p0000 "XI/07 pp0001 = p0001 "XI/07 . "XI/07

HR_CZ_REGISTRATION_STATUS_EMPL CALL FUNCTION 'HR_CZ_REGISTRATION_STATUS_EMPL' EXPORTING PERNR = PERNR-PERNR FROM_DATE = PN-ENDDA TO_DATE = PN-ENDDA IMPORTING SEX = P_SEX LAST_DAY = P_LAST_DAY P_P_ERA = P_P_P_ERA VPP = P_VPP MASSG = P_MASSG TABLES OUT_STATUS = E_STATUS ERR_TAB = ERROR_GET P0000 = P0000 P0001 = P0001 P0002 = P0002 P0007 = P0007 P0016 = P0016 P0031 = P0031 P0121 = P0121 P0153 = P0153 EXCEPTIONS PERNR_NO_CALENDAR = 1 OTHERS = 2.

HR_CZ_REGISTRATION_STATUS_EMPL





CALL FUNCTION 'HR_CZ_REGISTRATION_STATUS_EMPL' EXPORTING PERNR = PERNR-PERNR FROM_DATE = PN-ENDDA TO_DATE = PN-ENDDA IMPORTING SEX = P_SEX LAST_DAY = P_LAST_DAY P_P_ERA = P_P_P_ERA VPP = P_VPP MASSG = P_MASSG TABLES OUT_STATUS = E_STATUS ERR_TAB = ERROR_GET P0000 = P0000 P0001 = P0001 P0002 = P0002 P0007 = P0007 P0016 = P0016 P0031 = P0031 P0121 = P0121 P0153 = P0153 * OUT_STATUS1 = E_STATUS "csbs210405 EXCEPTIONS * PERNR_NO_MONTH_RESULT = 1 "csbs210202 PERNR_NO_CALENDAR = 1 "csbs210202 OTHERS = 2.

HR_CZ_REGISTRATION_STATUS_EMPL CALL FUNCTION 'HR_CZ_REGISTRATION_STATUS_EMPL' EXPORTING PERNR = PERNR-PERNR * FROM_DATE = avgbegda1 "csbs060406 * TO_DATE = avgendda1 "csbs060406 FROM_DATE = PN-BEGDA "csbs060406 TO_DATE = PN-ENDDA "csbs060406 IMPORTING SEX = P_SEX LAST_DAY = P_LAST_DAY P_P_ERA = P_P_P_ERA VPP = P_VPP MASSG = P_MASSG TABLES OUT_STATUS = E_STATUS ERR_TAB = ERROR_GET P0000 = P0000 P0001 = P0001 P0002 = P0002 P0007 = P0007 P0016 = P0016 P0031 = P0031 P0121 = P0121 P0153 = P0153 * OUT_STATUS1 = E_STATUS "csbs210405 EXCEPTIONS * PERNR_NO_MONTH_RESULT = 1 "csbs210202 PERNR_NO_CALENDAR = 1 "csbs210202 OTHERS = 2.

HR_CZ_HIRE_FIRE *CALL FUNCTION 'HR_CZ_HIRE_FIRE' * TABLES * PPHIFI = PPHIFI * PP0000 = P0000 * PP0001 = P0001 * .

RP_LAST_DAY_OF_MONTHS CALL FUNCTION 'RP_LAST_DAY_OF_MONTHS' EXPORTING day_in = mes_beg IMPORTING last_day_of_month = mes_end EXCEPTIONS day_in_no_date = 1 OTHERS = 2.

DOWNLOAD

GUI_DOWNLOAD * CALL FUNCTION 'DOWNLOAD' "DBE Uni CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING * FILENAME = 'C:\mp.dbf' "csbs180405

DOWNLOAD * CALL FUNCTION 'DOWNLOAD' * EXPORTING * FILENAME = 'C:\mp.dbf'

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'DBF' CODEPAGE = p_codep TABLES DATA_TAB = WORKTAB_2005 FIELDNAMES = IHEADER.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'DBF' TABLES DATA_TAB = WORKTAB_2006 FIELDNAMES = IHEADER.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'DBF' CODEPAGE = p_codep TABLES DATA_TAB = WORKTAB_2006 FIELDNAMES = IHEADER.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'DBF' TABLES data_tab = worktab_2011 fieldnames = iheader.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'DBF' codepage = p_codep TABLES data_tab = worktab_2011 fieldnames = iheader.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'DBF' TABLES data_tab = worktab_2012 fieldnames = iheader.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'DBF' codepage = p_codep TABLES data_tab = worktab_2012 fieldnames = iheader.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'DBF' TABLES * data_tab = worktab_2006 nt1325935(del) data_tab = worktab_2009 "nt1325935(ins) fieldnames = iheader.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'DBF' codepage = p_codep TABLES * data_tab = worktab_2006 nt1325935(del) data_tab = worktab_2009 "nt1325935(ins) fieldnames = iheader.

DOWNLOAD * CALL FUNCTION 'DOWNLOAD' "DBE Uni if p_codep eq space. "csbs270306

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING * FILENAME = 'C:\mi.dbf' "csbs180405

DOWNLOAD * CALL FUNCTION 'DOWNLOAD' * EXPORTING * FILENAME = 'C:\mi.dbf'

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'DBF' CODEPAGE = p_codep TABLES DATA_TAB = HDRTAB_2005 FIELDNAMES = IHEADER.

GUI_DOWNLOAD



CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'DBF' TABLES DATA_TAB = HDRTAB_2006 FIELDNAMES = IHEADER.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'DBF' codepage = p_codep TABLES DATA_TAB = HDRTAB_2006 FIELDNAMES = IHEADER.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'DBF' TABLES data_tab = hdrtab_2009 fieldnames = iheader.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'DBF' codepage = p_codep TABLES data_tab = hdrtab_2009 fieldnames = iheader.

DOWNLOAD

GUI_DOWNLOAD * CALL FUNCTION 'DOWNLOAD' "DBE Uni CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING * FILENAME = 'C:\mi.txt' "csbs180405

DOWNLOAD

GUI_DOWNLOAD * CALL FUNCTION 'DOWNLOAD' "DBE Uni CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING * FILENAME = 'C:\mp.txt' "csbs180405

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'ASC' codepage = p_codep TABLES DATA_TAB = HT2.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'ASC' codepage = p_codep TABLES DATA_TAB = WT2.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'ASC' TABLES DATA_TAB = HT2_2006.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'ASC' TABLES DATA_TAB = WT2_2006.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'ASC' codepage = p_codep TABLES DATA_TAB = HT2_2006.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' "DBE Uni EXPORTING FILENAME = i_filename FILETYPE = 'ASC' codepage = p_codep TABLES DATA_TAB = WT2_2006.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' TABLES data_tab = ht2_2009.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' TABLES data_tab = wt2_2009.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' codepage = p_codep TABLES data_tab = ht2_2009.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' codepage = p_codep TABLES data_tab = wt2_2009.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' TABLES data_tab = ht2_2009.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' TABLES data_tab = wt2_2011.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' codepage = p_codep TABLES data_tab = ht2_2009.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' codepage = p_codep TABLES data_tab = wt2_2011.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' TABLES data_tab = ht2_2009.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' TABLES data_tab = wt2_2012.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' codepage = p_codep TABLES data_tab = ht2_2009.

GUI_DOWNLOAD CALL FUNCTION 'GUI_DOWNLOAD' EXPORTING filename = i_filename filetype = 'ASC' codepage = p_codep TABLES data_tab = wt2_2012.

HR_CZ_REGISTRATION_STATUS_EMPL CALL FUNCTION 'HR_CZ_REGISTRATION_STATUS_EMPL' EXPORTING PERNR = PERNR-PERNR FROM_DATE = EV_BEGDA TO_DATE = EV_ENDDA IMPORTING SEX = P_SEX LAST_DAY = P_LAST_DAY P_P_ERA = P_P_P_ERA VPP = P_VPP MASSG = P_MASSG TABLES OUT_STATUS = E_STATUS ERR_TAB = ERROR_GET P0000 = P0000 P0001 = P0001 P0002 = P0002 P0007 = P0007 P0016 = P0016 P0031 = P0031 P0121 = P0121 P0153 = P0153 EXCEPTIONS PERNR_NO_CALENDAR = 1 OTHERS = 2.

RP_BUILD_PSP CALL FUNCTION 'RP_BUILD_PSP' EXPORTING INPUT = PTPRG BEGDA = PN-BEGDA ENDDA = PN-ENDDA ERROR = '0' IMPORTING OUTPUT = PTPRG TABLES I550AN = I550AN I550AO = I550AO I550PN = I550PN I550PO = I550PO PP0000 = P0000 PP0001 = P0001 PP0002 = P0002 PP0007 = P0007 PP2001 = P2001 PP2002 = P2002 PP2003 = P2003 PPSP = MXPSP.

RP_BUILD_PSP CALL FUNCTION 'RP_BUILD_PSP' EXPORTING input = ptprg begda = d_from endda = d_to error = '0' IMPORTING output = ptprg TABLES i550an = i550an i550ao = i550ao i550pn = i550pn i550po = i550po pp0000 = p0000 pp0001 = p0001 pp0002 = p0002 pp0007 = p0007 pp2001 = p2001 pp2002 = p2002 pp2003 = p2003 ppsp = my_psp.

DOWNLOAD CALL FUNCTION 'DOWNLOAD' EXPORTING bin_filesize = lv_xml_size filename = lv_fname filetype = 'BIN' filetype_no_change = 'X' filetype_no_show = 'X' TABLES data_tab = lt_xml_table EXCEPTIONS invalid_filesize = 1 invalid_table_width = 2 invalid_type = 3 no_batch = 4 unknown_error = 5 OTHERS = 6.

HR_CZ_REGISTRATION_STATUS_EMPL CALL FUNCTION 'HR_CZ_REGISTRATION_STATUS_EMPL' EXPORTING pernr = pernr-pernr from_date = ev_begda to_date = ev_endda IMPORTING sex = p_sex last_day = p_last_day p_p_era = p_p_p_era vpp = p_vpp massg = p_massg TABLES out_status = e_status err_tab = error_get p0000 = p0000 p0001 = p0001 p0002 = p0002 p0007 = p0007 p0016 = p0016 p0031 = p0031 p0121 = p0121 p0153 = p0153 EXCEPTIONS pernr_no_calendar = 1 OTHERS = 2.

FILE_GET_NAME CALL FUNCTION 'FILE_GET_NAME' EXPORTING logical_filename = p_fil_sd IMPORTING FILE_NAME = lv_asnam1 EXCEPTIONS FILE_NOT_FOUND = 1 OTHERS = 2 .

FILE_VALIDATE_NAME CALL FUNCTION 'FILE_VALIDATE_NAME' EXPORTING logical_filename = p_fil_sd changing physical_filename = lv_asnam1 EXCEPTIONS LOGICAL_FILENAME_NOT_FOUND = 1 VALIDATION_FAILED = 2 OTHERS = 3 .

RZL_READ_DIR_LOCAL * CALL FUNCTION 'RZL_READ_DIR_LOCAL' * EXPORTING * name = lv_asname * TABLES * file_tbl = lt_file_tbl * EXCEPTIONS * argument_error = 1 * not_found = 2 * OTHERS = 3.



Contribute (Add Comments)

Although this basic information may have limited use it does provide an easy to find location to store any knowledge about this program/report.

The contribute/comments section below therefore offer's an opportunity for anyone to add additional information. This can be anything from useful hints, tips and screen shots to relevant SAP notes or anything else you feel is relevant to this report.

This will then be available for everyone to easily find by simply searching on the report name RPCTRXT0 or its description.