What is the maximum limit on characters that can be stored in a text field.
Is it maintained in some master table? Or is it dependent on the database of the user?

For storing texts there is no limit. Texts are, if needed, split in multiple table rows in tttxt010. But there may be limits for printing or showing texts.