Rate Table Creation and Update (SAP TM) TM 8.1
I have problem when creating rate table and need solve this asap . I need to create a rate table with the fields(scales) 1) Source location 2)Destination location and 3) Means of transport. I have created 3 scales 1sth one 1000 records sorce location, 2nd one 800 Destination location and last one 2 means of transport when rate table it self populated by the system there will be 1000*800*2= 1.600.000 records but I have only 100.000 transportation lane connection with 2 means of transport which is 200.000 records. I need to update 200.000 records but it gives me 1.6 million records which is not possible to map these two as VLOOKUP will not be completed. Is there any way to upload only 200.000 records to may rate table.(I checked lots of ways for upload it does not allow this) I guess there can be a BAPI or CLASS but I could not find anything. Please let me know if you have a way for this.
Thanks in advance .