Skip to Content
avatar image
Edvard Samec

Importing business partners (Excel file) to Transportation Management

Mar 22, 2017 at 12:36 PM | 145 Views | Last edit Jul 12, 2017 at 05:38 AM 2 rev.

Hello!

Is there a way of importing business partners to TM via Excel?

I did try this: https://help.sap.com/saphelp_erp60_sp/helpdata/en/48/a3c6535e601e4be10000000a174cb4/content.htm

The system returns an error stating:

"No file could be determined from . Termination of EDT

Message No. GD218

Diagnosis

The system was unable to determine an output file.

System Response

An output file is used with each transfer. This is determined from the logical output file, or the physical output file is used directly. No files can be described on the local presentation server.

The transfer run is terminated. No records were processed."

I don't know if I have the Excel file configured right or something else is wrong... I'm new to TM, so any help would be gladly appreciated.

Thank you.

B/R

E

SAP Transportation Management
APP PLATFORM Business Partner | CRM Business Partner
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Edvard Samec
    Mar 29, 2017 at 12:08 PM

    No one tried this in TM?

    What is the purpose of an output file when importing data?

    Add comment
    10|10000 characters needed characters exceeded

    • Edvard Samec
      Jul 25, 2017 at 07:26 AM

      Hi Gurbhej,

      I know, but not all potential TM customers use SAP ERP. I did try LSMW and it works, but I would still like to import BP data directly.

      I have succesfully transferred one BP directly via KCLJ (and KCLL) transaction - but only general data, fields such as BP number, BP Role, BP type, BP Name, Address (all data mapped in KCLL and written in a single line in the .csv file).

      Hovewer, when I tried the same with multiple lines in the .csv file, short dump occured (although the test run was succesfull with all lines correctly written), because the system found problems importing the BP address data - it didn't know where the first line ends and the second starts.

      We opened an OSS note regarding this issue - will post the solution when SAP resolves it. :)

      But note that this imports only BP data. There is no direct input method for locations (as you know, they are a separate object in TM). I hope SAP provides us with a mass direct upload for locations also (including connection to BP data).