How to use /SCMTMS/RATE_EXCEL07 - Rate Excel Integration (Excel 07)

/SCMTMS/RATE_EXCEL07 - Overview

• Transaction Code: /SCMTMS/RATE_EXCEL07

  Description: Rate Excel Integration (Excel 07)

  Release: S/4HANA only

• • Program: /SCMTMS/TCC_RATES_EXCEL_NEW

    Screen: 1000

    Authorization Object:

  • Development Package: /SCMTMS/FE_TCC_CONF

    Package Description: Foundation Engine Transportation Charge Calc. Customizing

    Parent Package: /SCMTMS/FE_TCC_CORE

  • Module/Component: TM-MD-CM

    Description: Charge Management

/SCMTMS/RATE_EXCEL07 - Details

• SAP Tcode: /SCMTMS/RATE_EXCEL07 - Rate Excel Integration (Excel 07)

  
  Overview:
  The SAP transaction code /SCMTMS/RATE_EXCEL07 is used to integrate rate information from an Excel file into the SAP Transportation Management System (TMS). This transaction code is specifically designed for Excel 2007 and later versions. 
  
  Functionality: 
  This transaction code allows users to upload rate information from an Excel file into the TMS. This includes rate information such as freight rates, surcharges, and discounts. The rate information can then be used to calculate shipping costs in the TMS. 
  
  Step-by-step How to Use: 
  1. Open the SAP Logon screen and enter the transaction code /SCMTMS/RATE_EXCEL07. 
  2. Select the “Upload” button to upload the Excel file containing the rate information. 
  3. Select the “Validate” button to validate the rate information in the Excel file. 
  4. Select the “Save” button to save the rate information in the TMS. 
  5. Select the “Activate” button to activate the rate information in the TMS. 
  6. Select the “Logoff” button to log off from the SAP system. 
  
  Other Recommendations: 
  It is recommended that users check for any errors or warnings before uploading and activating rate information in the TMS. Additionally, users should ensure that they are using an Excel file compatible with version 2007 or later before attempting to upload rate information into the TMS.