Importing business partners (Excel file) to Transportation Management

[former_member391671]

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

[former_member391671]

No one tried this in TM?

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

[gurbhejsingh]

Hi Edvard,

Yes i believe no one tried this because as per my knowledge , Business partners are supposed to be CIFed from Source systems ( Such as ERP ) , to keep the master data consistency . or using LSMW when importing from Non SAP system

I am not aware of the story behind uploading BP's directly , Could you please shed some more light on this .

Best Regards,

GS

[former_member391671]

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).