Technical Articles
Text Types Usage
With the 1811 release you will see a warning message in SAP Cloud Applications Studio like the one below.
This warning is shown when you use the ‘Text’ data type for field definition. It’s an unlimited text data type and allows you to save as much text as you want. Because of the unlimited nature of the data type, certain users save binary content like PDF files or XML or images in this field. The data type is not designed to save such content and because of this it affects the database performance.
In such cases where you want to save PDF files, images etc. its recommended to AttachmentFolder (refer section 7.2.2.12 in the SDK Help Documentation for more on AttachmentFolder). Further, if you wish to store unlimited text then its recommended to use to use the TextCollection DO (refer section 7.2.2.12 in the SDK Help Documentation for more on TextCollection).
We also support text data types with limited character length. It highly recommended that when you define the text fields you one of the following data types.
Field Definition in Custom Objects
Field Definition in Extension Objects
Field Definition in Custom Nodes of an Extension Object
Hello Gaurav,
Thank you very much for the valuable information.
I've tried on "LongText" on extension BO and it seems unlimited.
But when I use that in absl logic, it showing the warning message ["Please ensure the value doesn't exceed 120 characters, otherwise it will be cut off at runtime."]. But although I insert over 300 characters in logic (get the value from TextCollection and put to this), seems no problem on screen and showing all chars.
So it is OK to assume that "LongText" can be used as unlimited in XBO?
Regards,
May
Hello Gaurav,
Thank you very much for the valuable information.
I’ve currently tried what May Thitsa Oo mentioned and I is not (anymore?) possible to insert more than 120 characters for LongText.
Apparently there is also a problem with field definition of extension objects. It is not possible to adjust the field size, ReadOnly and/or DisplayType. So the fields look unpleasant (huge).
I’ve created an incident 499641/2019
Regards,
Chris
SAP answered the following to my incident:
Regards
How can I copy the value of an internal note that is an unlimited field and then be able to show it in the sales order summary?
Regards
Hello Guarav,
if I try to add a field with the types ShortText, MediumText or LongText I get the following error:
Definition of data type 'ShortText' not found; Add an import statement for the missing namespace or use a fully qualified name.
I am not able to find these datatypes in the Repository Explorer and also not in the SDK Help Documentation.
Could you give me a hint how to use these datatypes?
Kind regards
Peter
Hello Guarav,
it was my fault because these datatypes are not available in my extenstion node... as you mentioned it above.
The text datatypes starting with LANG... are not visible in the resultlist when pressing STRG+Space.
space
space
Kind regards
Peter