In Business Partner Master Data>General Tab>Click on Activity button then the activity screen appears in that-->Content Tab, when you enter some values in the content it shows that it accepts 64000 characters and when add button is pressed it gets added in the database and where only 256 characters gets stored in the database. What should be done for this as it gets stored in the demo database.
When I enter in the activity type remarks (64000 Chrs) ,it accepts as it is. When I put the formatted search for the existing record with existing values (while inserting date, user name, contact person) then the old values, if more than 255 characters it cuts off. Not when I enter directly in the field.
In BP mastrer - Activity Screen : Activity Contact Person
The formatted search query is as follows:
DECLARE @DT Varchar(10)
SET @DT = (SELECT CONVERT(VARCHAR(10), GETDATE(), 104) AS [dd/MM/yy])
SET @DT = (SELECT LEFT(@dt,6) + right(@dt,2))
SELECT T0.Name + ' / ' + @DT + ' / ' + (Select T2.U_Name FROM OUSR T2 where T2.Internal_k
= $[USER]) + CHAR(13) + $[$25.1.0]
FROM OCPR T0 WHERE T0.CntctCode = $[$17.1.N] and T0.cardcode=$[$9.1.0]
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.