SAP Reports / Programs | Financial Accounting | Travel Management | Travel Planning(FI-TV-PL) SAP FI

RFARHTP14 SAP ABAP Report - AMADEUS offline synchronisation using queue mechanism







RFARHTP14 is a standard Executable ABAP Report available within your SAP system (depending on your version and release level). Below is the basic information available for this SAP report including which OBJECTS it interacts with such as TABLES, FUNCTION MODULES, INCLUDES ETC. Also check out the submitted Comments related to this SAP report or see any standard documentation available.

If you would like to execute this report or see the full code listing simply enter RFARHTP14 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

TP14 - Travel Plan Synchronization (Queue)


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 RFARHTP14. "Basic submit
SUBMIT RFARHTP14 AND RETURN. "Return to original report after report execution complete
SUBMIT RFARHTP14 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: S_TNSTA = Start date of travel plan
Selection Text: S_TNEND = End date of travel plan
Selection Text: S_REINR = Trip number
Selection Text: S_RECLOC = Record locator
Selection Text: S_PERNR = Personnel number
Selection Text: S_CHGON = Changed on
Selection Text: P_QUEUE = Get record locators from queue
Selection Text: P_NEWTRP = Create new plan if overlap
Selection Text: P_LIST = Select record locators
Selection Text: P_HIDWRN = Do not output warning messages
Selection Text: P_HIDINF = Do not output info messages
Title: AMADEUS offline synchronisation using queue mechanism
Text Symbol: T04 = Selection criteria
Text Symbol: T03 = Execution date/time:
Text Symbol: T02 = List of record locators
Text Symbol: T01 = Queue processing
Text Symbol: L04 = SUCCESSFUL:
Text Symbol: L03 = INFORMATION:
Text Symbol: L02 = WARNING:
Text Symbol: L01 = ERROR :
Text Symbol: I16 = &1 PNRs were successfully processed
Text Symbol: I15 = Updating PNR &1 to add trip number (TN) element &2. Please wait...
Text Symbol: I14 = Synchronising PNR &1 and NVS booking &2. Please wait...
Text Symbol: I13 = Retrieving details of PNR &1. Please wait...
Text Symbol: I12 = Building the execution report. Please wait...
Text Symbol: I11 = Moving PNR &1 back to the queue &2 &3
Text Symbol: I10 = Retrieving top-list PNR from the queue &1 &2. Please wait...
Text Symbol: I09 = Returning the number of PNRs in the queue &1 &2
Text Symbol: I08 = Updating travel plan with PNR &1. Please wait...
Text Symbol: T05 = at
Text Symbol: T06 = Trip activity type (TT)
Text Symbol: T07 = Pers. number (PID)
Text Symbol: T08 = Trip number (TN)
Text Symbol: T09 = &1 PNRs processed, &2 warnings and &3 errors
Text Symbol: T10 = NVS rail booking ID (NVS)
Text Symbol: T11 = Processing options
Text Symbol: T12 = Output options
Text Symbol: W01 = Trip activity type (TT) found in PNR does not match an existing trip activity type





Text Symbol: W02 = Could not create the travel plan. No active itinerary in PNR
Text Symbol: W03 = PNR rejected: system and/or client number do not match current system
Text Symbol: W04 = An error occurred while recording the trip number in the PNR
Text Symbol: W05 = &1 is missing in the PNR
Text Symbol: W06 = An error occurred while moving the PNR back to the queue
Text Symbol: W07 = Could not synchronise the PNR and the NVS booking
Text Symbol: W08 = Travel plan contains LCC bookings. Flight segments of PNR cannot be uploaded
Text Symbol: W09 = Rail booking ID (NVS) found in PNR does not match the one of travel plan
Text Symbol: W10 = Trip number recorded in PNR but PNR could not be placed in queue
Text Symbol: I07 = Creating travel plan for PNR &1. Please wait...
Text Symbol: E11 = Cannot determine if update of travel plan or pers. number is allowed
Text Symbol: E10 = Cannot update the travel plan. No valid infotype "0017" found for the pers. number
Text Symbol: E09 = No authority to update the travel plan or the pers. number
Text Symbol: E08 = PNR rejected: missing &1 in the PNR
Text Symbol: E07 = An error occurred while synchronising the PNR and the NVS booking
Text Symbol: E06 = PNR rejected: missing system or client number
Text Symbol: E05 = PNR rejected: duplicate &1 element in the PNR
Text Symbol: E04 = No PNRs could be read from the queue
Text Symbol: E03 = Pers. number (PID) found in PNR does not match an existing pers. number
Text Symbol: E02 = Could not get the number of PNRs in queue
Text Symbol: E01 = No queue parameters defined for synchronisation
Text Symbol: C12 = Rail booking ID
Text Symbol: C11 = Message
Text Symbol: C10 = Itinerary
Text Symbol: C09 = End date
Text Symbol: C08 = Start date
Text Symbol: C07 = Trip type
Text Symbol: C06 = Traveller name
Text Symbol: C05 = Action
Text Symbol: C04 = Trip number
Text Symbol: C03 = Pers. number
Text Symbol: C02 = Record locator
Text Symbol: C01 = Msg type
Text Symbol: E12 = PNR rejected: the trip does not belong to the pers. number
Text Symbol: I06 = Checking authority to maintain travel plans for pers. number &1
Text Symbol: I05 = Checking required information in PNR &1
Text Symbol: I04 = The travel plan has been successfully created
Text Symbol: I03 = The travel plan has been successfully updated
Text Symbol: I02 = No PNRs have been processed





Text Symbol: I01 = Limit number of PNRs to max defined in 'TA20SWITCH'
Text Symbol: E29 = Creation of the travel plan failed. No personnel number found
Text Symbol: E28 = Too many PNRs retrieved. Change 'TA20SWITCH'
Text Symbol: E27 = Too many PNRs in queue. Change 'TA20SWITCH'
Text Symbol: E26 = Creation of the travel plan failed. No trip number was allocated
Text Symbol: E25 = No details of the travel request available
Text Symbol: E24 = The travel plan or the pers. number are locked for edit
Text Symbol: E23 = An error occurred while checking the travel plan dates
Text Symbol: E22 = The travel plan overlaps an existing travel plan
Text Symbol: E21 = An error occurred while displaying the execution report
Text Symbol: E20 = PNR rejected: &1 should be numeric
Text Symbol: E19 = Update of the travel plan failed
Text Symbol: E18 = No PNR or travel plan not modifiable
Text Symbol: E17 = Could not get details of the travel plan
Text Symbol: E16 = Creation of the travel plan failed
Text Symbol: E15 = An error occurred while retrieving the PNR
Text Symbol: E14 = PNR rejected: no multi-passenger PNRs allowed
Text Symbol: E13 = PNR rejected: the trip does not have the record locator of the PNR


INCLUDES used within this REPORT RFARHTP14

INCLUDE RFARHTP14_TOP.
INCLUDE RFARHTP14_F1.
INCLUDE RFARHTP14_F2.
INCLUDE RFARHTP14_F3.
INCLUDE RPC1TE00.
INCLUDE FITP_GENERAL_PORTAL_DATA.
INCLUDE FITP_GENERAL_READ_TRVOF_TRVUS.
INCLUDE FITP_GENERAL_READ_TRVCC.
INCLUDE RPR_TRIP_ENQUEUE_DEQUEUE.
INCLUDE MFITPF_LOCKING.


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:

PTRA_UTIL_MEM_CLEAR_ALL CALL FUNCTION 'PTRA_UTIL_MEM_CLEAR_ALL' EXCEPTIONS error_occurred = 1 OTHERS = 2.

PTRM_UTIL_MESSAGES_DELETE CALL FUNCTION 'PTRM_UTIL_MESSAGES_DELETE' EXPORTING i_all_only_once_messages = 'X'.

PTRA_SCREEN_MEM_CLEAR_ALL CALL FUNCTION 'PTRA_SCREEN_MEM_CLEAR_ALL' EXCEPTIONS error_occurred = 1 OTHERS = 2.

FITP_SET_PNR_LINENUMBER CALL FUNCTION 'FITP_SET_PNR_LINENUMBER' EXPORTING sync_fare = true trvof = lio_office_find sw_portal = true "Simulate an execution of the "function module from the "portal to disallow returning "any popup message TABLES t_plan = itg_plan item = itg_item flight = itg_flight flight_pref = itg_flight_pref flight_leg = itg_flight_leg flight_fare = itg_flight_fare flight_tst = itg_flight_tst hotel = itg_hotel hotel_pref = itg_hotel_pref car = itg_car car_pref = itg_car_pref pnr = itg_pnr pnr_phone = itg_pnr_phone pnr_address = itg_pnr_address pnr_remarks = itg_pnr_remarks pnr_osi = itg_pnr_osi pnr_ssr = itg_pnr_ssr fare_comp = itg_fare_comp fare_note = itg_fare_note info = itg_var_info t_advisories = itg_advisories head = itg_head perio = itg_perio train = itg_train sync_data = itg_sync_data other = itg_other user = user CHANGING plan = psio_plan variant = psio_variant EXCEPTIONS service_for_line_not_found = 1 line_for_service_not_found = 2 no_entry_in_table = 3 OTHERS = 4.

PTRA_SCREEN_MEM_CLEAR_ALL



* CALL FUNCTION 'PTRA_SCREEN_MEM_CLEAR_ALL' * EXCEPTIONS * error_occurred = 1 * OTHERS = 2.

FITP_CREATE_TRIP_FROM_PLAN CALL FUNCTION 'FITP_CREATE_TRIP_FROM_PLAN' EXPORTING morei = lio_morei IMPORTING wa_head = stl_head wa_perio = stl_perio TABLES t_plan = itg_plan t_item = itg_item t_variant = itg_variant t_fare_comp = itg_fare_comp t_fare_note = itg_fare_note t_flight = itg_flight t_flight_leg = itg_flight_leg t_flight_pref = itg_flight_pref t_flight_fare = itg_flight_fare t_flight_tst = itg_flight_tst t_hotel = itg_hotel t_hotel_pref = itg_hotel_pref t_car = itg_car t_car_pref = itg_car_pref t_train = itg_train t_train_pref = itg_train_pref t_other = itg_other t_pnr = itg_pnr t_pnr_name = itg_pnr_name t_pnr_osi = itg_pnr_osi t_pnr_address = itg_pnr_address t_pnr_remarks = itg_pnr_remarks t_pnr_ssr = itg_pnr_ssr t_pnr_phone = itg_pnr_phone t_info = itg_var_info t_req_head = itg_req_head t_request = itg_request t_req_reason = itg_req_reason t_req_account = itg_req_account t_req_advance = itg_req_advance t_user = user CHANGING wa_plan = stl_plan wa_req_head = stl_req_head EXCEPTIONS creation_failed = 1 enqueue_failed = 2 no_entry_in_table = 3 infotype_not_found = 4 error_synchro = 5 OTHERS = 6.

FITP_READ_PLAN_REQUEST_DATA CALL FUNCTION 'FITP_READ_PLAN_REQUEST_DATA' EXPORTING pernr = po_person_id reinr = po_trip_id hdvrs = '99' "Not Used plannr = c_plannr only_newest = true IMPORTING number_of_variants = lio_nb_variants wa_req_head = stl_req_head wa_plan = stl_plan wa_head = stl_head wa_perio = stl_perio TABLES t_variant = itg_variant t_item = itg_item t_fare_comp = itg_fare_comp t_flight = itg_flight t_flight_leg = itg_flight_leg t_flight_pref = itg_flight_pref t_flight_fare = itg_flight_fare t_flight_tst = itg_flight_tst t_fare_note = itg_fare_note t_hotel = itg_hotel t_hotel_pref = itg_hotel_pref t_car = itg_car t_car_pref = itg_car_pref t_train = itg_train t_train_pref = itg_train_pref t_other = itg_other t_pnr = itg_pnr t_pnr_name = itg_pnr_name t_pnr_osi = itg_pnr_osi t_pnr_phone = itg_pnr_phone t_pnr_address = itg_pnr_address t_pnr_remarks = itg_pnr_remarks t_pnr_ssr = itg_pnr_ssr t_tm_memo = itg_tm_memo t_info = itg_var_info t_sync_data = itg_sync_data t_req_head = itg_req_head t_request = itg_request t_req_advance = itg_req_advance t_req_account = itg_req_account t_req_reason = itg_req_reason t_user = user EXCEPTIONS no_variant_found = 1 OTHERS = 2.

FITP_REQUEST_TABLES_READ CALL FUNCTION 'FITP_REQUEST_TABLES_READ' EXPORTING pernr = psio_plan-pernr reinr = psio_plan-reinr plan_request = lio_is_plan_or_request change_to_p = lio_change_request_to_plan IMPORTING wa_req_head = psio_req_head wa_head = psio_head wa_perio = psio_perio TABLES t_req_head = pt_req_head t_request = pt_request t_req_advance = pt_req_advance t_req_account = pt_req_account t_req_reason = pt_req_reason t_user = pt_user.

FITP_SYNCHRONIZE_REQUEST_PLAN CALL FUNCTION 'FITP_SYNCHRONIZE_REQUEST_PLAN' EXPORTING morei = psio_head-morei TABLES t_req_head = pt_req_head t_request = pt_request t_plan = itl_plan t_item = itl_item CHANGING wa_req_head = psio_req_head wa_plan = psio_plan EXCEPTIONS no_entry_in_table = 1 infotype_not_found = 2 error_synchro = 3 OTHERS = 4.

FITP_SAVE_TRIP_FROM_PLAN CALL FUNCTION 'FITP_SAVE_TRIP_FROM_PLAN' EXPORTING morei = psio_head-morei TABLES t_plan = itg_plan t_item = itg_item t_req_head = itg_req_head t_request = itg_request t_req_account = itg_req_account t_req_advance = itg_req_advance t_user = user CHANGING wa_plan = psio_plan wa_req_head = psio_req_head wa_head = psio_head wa_perio = psio_perio EXCEPTIONS overlapping_error = 1 update_failed = 2 no_entry_in_table = 3 infotype_not_found = 4 error_synchro = 5 OTHERS = 6.

FITP_UPDATE_REQUEST CALL FUNCTION 'FITP_UPDATE_REQUEST' EXPORTING wa_request_head = psio_req_head TABLES request_head = itg_req_head request = itg_request account = itg_req_account advance = itg_req_advance reason = itg_req_reason EXCEPTIONS database_error_request = 1 OTHERS = 2.

FITP_UPDATE_PLAN CALL FUNCTION 'FITP_UPDATE_PLAN' EXPORTING wa_head = psio_head wa_perio = psio_perio wa_plan = psio_plan TABLES t_variant = itg_variant t_item = itg_item t_fare_comp = itg_fare_comp t_flight = itg_flight t_flight_leg = itg_flight_leg t_flight_pref = itg_flight_pref t_flight_fare = itg_flight_fare t_flight_tst = itg_flight_tst t_fare_note = itg_fare_note t_hotel = itg_hotel t_hotel_pref = itg_hotel_pref t_car = itg_car t_car_pref = itg_car_pref t_train = itg_train t_train_pref = itg_train_pref t_pnr = itg_pnr t_pnr_name = itg_pnr_name t_pnr_osi = itg_pnr_osi t_pnr_address = itg_pnr_address t_pnr_remarks = itg_pnr_remarks t_pnr_ssr = itg_pnr_ssr t_pnr_phone = itg_pnr_phone t_tm_memo = itg_tm_memo t_info = itg_var_info t_sync_data = itg_sync_data t_other = itg_other EXCEPTIONS database_error_plan = 1 database_error_head_perio = 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 RFARHTP14 or its description.