Results 1 to 1 of 1

Thread: HR - TRAVEL MANAGEMENT -- New Data Types

  1. #1
    Admin_attu is offline Admin
    Join Date
    Aug 2006
    Posts
    231
    Rep Power
    10

    HR - TRAVEL MANAGEMENT -- New Data Types

    If your organization uses the Travel Management portion of the HR module, then you may want to add some or all of the data types listed below to your Gold Client configuration. To view the details about creating these data types, view the series of screen captures that follow below.
    This topic updated in Oct 2014 with additional details such as new tables and new Data Type linkages
    HR - QUICKTRIP TRAVEL
    HR - TRAVEL MASTER DATA
    HR - TRAVEL PLANS
    HR - TRAVEL REQUEST
    HR - TRIP DETAILS
    LINK - TRIP RESULTS TO FI DOCS

    Creating Data Types (defining table and field relations)
    Data type: HR – TRIP DETAILS

    Name:  Capture19.PNG
Views: 132
Size:  37.0 KB

    The tables below all use common fields PERNR-PERNR as seen in the following screen capturePTRV_ADMIN
    PTRV_BTRGSUM
    PTRV_CCC_RUNS
    PTRV_KMSUM
    PTRV_ME_CCC_RUN

    Name:  Capture20.PNG
Views: 69
Size:  24.3 KB
    The tables below all use common fields PERNR-PERNR and REINR-REINR as seen in the following screen capture
    PTRV_ARCHIVE
    PTRV_HEAD
    PTRV_NOT_CH_TR
    PTRV_TRIPCHN_46C
    PTRV_TRIP_DELETE

    Name:  Capture21.PNG
Views: 77
Size:  34.0 KB
    The tables below all use common fields PERNR-PERNR, REINR-REINR, and PERIO-PERIO as seen in the following screen capture
    FITV_HINZ_WERB_B
    FITV_HINZ_WERB_S
    PTRV_SADD
    PTRV_SBACKLOG
    PTRV_SCOS
    PTRV_SHDR
    PTRV_SREC
    PTRV_TRIP_CHAIN

    Name:  Capture22.PNG
Views: 79
Size:  42.3 KB

    The tables below all use common fields PERNR-PERNR, REINR-REINR, and HDVRS-HDVRS as seen in the following screen capturePTRV_ARCH_HEAD

    Name:  Capture23.PNG
Views: 71
Size:  3.5 KB
    The tables below all use common fields PERNR-PERNR, REINR-REINR, PDVRS-PDVRS, and PERIO-PERIO as seen in the following screen capture
    PTRV_ARCH_PERIO
    PTRV_PERIO

    Name:  Capture24.PNG
Views: 85
Size:  52.6 KB

    Data type: LINK - TRIP RESULTS TO FI DOCS

    Name:  Capture25.PNG
Views: 83
Size:  11.0 KB

    Table PTRV_ROT_AWKEY uses the common fields below:

    Name:  Capture26.PNG
Views: 76
Size:  6.0 KB

    Data type: HR - TRAVEL MASTER DATA

    Name:  Capture27.PNG
Views: 87
Size:  21.7 KB

    Common field relations for table PA0017-PA0017 are:

    Name:  Capture28.PNG
Views: 71
Size:  62.5 KB

    All other table relations use only PERNR as seen in this screen capture:

    Name:  Capture29.PNG
Views: 71
Size:  22.2 KB

    Data type: HR - TRAVEL REQUEST

    Name:  Capture30.PNG
Views: 91
Size:  15.7 KB

    Common field relations for table FTPT_REQ_HEAD are:

    Name:  Capture31.PNG
Views: 73
Size:  47.1 KB

    All other table relations use only PERNR and REINR as seen in this screen capture:

    Name:  Capture32.PNG
Views: 72
Size:  31.8 KB

    Data type: HR - TRAVEL PLANS

    Name:  Capture33.PNG
Views: 97
Size:  49.7 KB

    The tables below all use common fields PERNR-PERNR and REINR-REINR as seen in the following screen captureFTPT_TM_MEMO
    FTPT_VARIANT

    Name:  Capture34.PNG
Views: 77
Size:  3.0 KB

    The tables below all use common fields PERNR-PERNR, PLANNR-PLANNR, and REINR-REINR as seen in the following screen captureFTPT_PLAN
    FTPT_PLANHISTORY

    Name:  Capture35.PNG
Views: 75
Size:  3.2 KB

    The tables below all use common fields PERNR-PERNR, PLANNR-PLANNR, REINR-REINR, VARIANT-VARIANT, and VARIANTVRS-VARIANTVRS as seen in the following screen capture. Note: some fields will use VARIANTE-VARIANT and that is okayFTPT_CAR
    FTPT_CAR_PREF
    FTPT_FARE_COMP
    FTPT_FARE_NOTE
    FTPT_FLIGHT
    FTPT_FLIGHT_FARE
    FTPT_FLIGHT_FCMP
    FTPT_FLIGHT_LEG
    FTPT_FLIGHT_PREF
    FTPT_FLIGHT_TST
    FTPT_FLIGHT_TSTK
    FTPT_HOTEL
    FTPT_HOTEL_PREF
    FTPT_ITEM
    FTPT_OTHER
    FTPT_PNR
    FTPT_PNR_ADDRESS
    FTPT_PNR_NAME
    FTPT_PNR_OSI
    FTPT_PNR_PHONE
    FTPT_PNR_REMARKS
    FTPT_PNR_SSR
    FTPT_SERVICE
    FTPT_SYNC_DATA
    FTPT_TRAIN
    FTPT_TRAIN_PREF
    FTPT_VAR_INFO

    Name:  Capture36.PNG
Views: 148
Size:  28.1 KB

    Common field relations for all tables are QTNR as seen in this screen capture:

    Name:  Capture37.PNG
Views: 74
Size:  28.2 KB

    Creating Data Type Links

    From HR - TRIP DETAILS, add any of the data type links in the screen capture below that your organization may require

    Name:  Capture38.PNG
Views: 86
Size:  13.9 KB

    Linkage details can be seen in the screen capture below for linking to data type HR – PAYROLL CLUSTER (PCL1). Notice that a concatenation of fields PERNR, REINR, PERIO, and PDVRS is required for passing a value to PCL1-SRTFD (when the RELID = 'TE'; this is not necessary for RELID = 'TC').

    Name:  Capture39.PNG
Views: 97
Size:  29.3 KB

    Linkage details can be seen in the screen capture below for linking to data type LINK – TRIP RESULTS TO FI DOCS

    Name:  Capture40.PNG
Views: 96
Size:  21.4 KB

    Linkage details can be seen in the screen capture below for linking to data type FI - FINANCE DOCUMENTS

    Name:  Capture41.PNG
Views: 96
Size:  17.3 KB

    Linkage details can be seen in the screen capture below for linking to data type LINK TO WORKFLOW. Notice that a concatenation of fields PERNR and REINR is required for passing a value to SWW_WI2OBJ-INSTID.

    Name:  Capture42.PNG
Views: 95
Size:  30.0 KB

    In addition to the linkages above, the various HR data types can be linked together so that they are part of the same data export. Our standard config has them linked using this flow: HR - TRAVEL PLANS > HR - TRAVEL REQUEST > HR - TRIP DETAILS; however this flow could be changed to match your organization's specific requirements. The linkage details for this specific flow are visible in the screen captures below.

    Name:  Capture43.PNG
Views: 123
Size:  37.3 KB
    Last edited by Admin_attu; 11-07-2017 at 05:11 AM.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •