Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Importing UserText (extra description) for Items

Hi All,

In previous versions on DTW I was able to import long text into the OITM.UserText field displayed on the remarks tab. Whilst this field is still available within the oItems template the SDK help file indicates its a 10 character field and it does not accept long descriptions. Can any provide an alternative solution for importing the UserText? I have about 2000 items to update and I don't want to do it manually and I will not import straight into the SQL table.

I have used the DI Commander tool (Very useful) in the past and I was hoping to use that. Details of the DI commander can be found in this blog if you are unfamiliar with it

I'm unsure what code to type in to import the files.

Basically I have a spreadsheet containing Item Number and User Text (no header rows but I can add rows as per DTW templates if required) and I've called it c:itemdesc.txt (can be xls or csv if need be).

Can anyone please advise either the code that i need to type in the DI Commander or offer an alternative solution to update the field? The client is on SAP 2005a SP01 PL46 (SQL2005 database) and DTW is installed from that patch also.

Many thanks,

Adrian

Helpful Answer

by
Not what you were looking for? View more on this topic or Ask a question