SAP Knowledge Base Article - Preview

2595621 - Rate Table Excel Upload gives error 'Excel sheet &1, line &2: Inconsistent validity'

Symptom

  1. When columns such as Start/End Date are edited in the Rate Table Excel, this excel upload gives an error: 'Excel sheet &1, line &2: Inconsistent validity'
  2. This occurs when date format for the user is changed to mm/dd/yyyy or mm-dd-yyyy


Read more...

Environment

SAP TM - Transportation Management 9.1
SAP TM - Transportation Management 9.2
SAP TM - Transportation Management 9.3
SAP TM - Transportation Management 9.4

Product

SAP NetWeaver 7.4 ; SAP Transportation Management 9.1 ; SAP Transportation Management 9.2 ; SAP Transportation Management 9.3 ; SAP Transportation Management 9.4

Keywords

/SCMTMS/TC_RATES769, Format cells, unprotect excel, Rate Validity Split, month, day, year, SU3 , KBA , TM-MD-CM-RA-XL , Rate Excel Integration , TM-MD-CM , Charge Management , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.