How can i change length of DSC1 (F4101 Table) column up to 300 ??? is it possible ?

Kevin Jung

Member
My client ask to me want to input more informaion into DSC1 and DSC2 column of ITEM Master Table ( F4101 ).

If there is a way... Please help me.
Thanks.
 

jdedwardsuser

Active Member
No the vanilla DD item cannot be changed . It is never recommended . In our case , there was such requirement to have some large fields like Marketing description , allergy information etc (in food business ) , so we create custom item tag and it has item # and other custom fields of larger description sizes as needed by business , custom application and reports .Our ecommerce gets info from there for web customers and mobile too

Custom UBE to see everyday using outbound interoperability in F4101Z1 to see new items added and create entries in the custom tag to keep in synch always . Mass update application with grid given to business to update the records what they want .
 

RussellCodlin

Reputable Poster
As others have said, the short answer is no. It has been tried before and always ends in tears (very expensive tears).

As is mentioned, you can look at text attachments or a tag table mod. Another option to consider is AMS (https://amseam.com/) have an OVI extension that provides searchable 3000 character description fields for the item master.
 

rival

Active Member
Don't even think about it. I uderstand the need and I think almost everyone want more positions in DSC1 but it will be a disaster now and in the future when you get esu's etc..
 

BOster

Legendary Poster
I've done it before, but I have to quote my favorite post on jdelist every time the subject of changing the size of a DD item comes up.

If created by JDE, changing the size is equivalent to pointing a gun at your head and pulling the trigger.

If created by you, changing the size is only equivalent to pointing the gun at your foot and pulling the trigger.

- Larry Jones
 
Top