Current Position:Home > Save More than 1000 chars in a field of (Z) Database Table?

Save More than 1000 chars in a field of (Z) Database Table?

Update:11-30Source: network consolidation
Advertisement
Hi Friends,
I created a database table with few fields. In the table, one field is REMARKS which should save more than 1000 characters for every record. For that field,  I created domain & data element of char with 2000 length. But system gives an error representing that "Should not be more than 255 chars ".
Even, select statement is also retrieving 132 chars only, if remarks are less than 255 and greater than 150 chars.
Could you please provide me solution?
Thanks
Sarayu

The Best Answer

Advertisement
Hi,
The Most simple solution for it can be that Divide the field REMARKS of size 1000 in multiples of 200 characters like REMARK1, REMARK2....REMARKn.
Now you can create two FMs :
zset_data:  To Store 1000 char long data in Table
Here you will divide the data of Variable (type char1024) in multiples of 200 and will store in REMARK1, REMARK2.....
zget_data: To Get 1000 char long data back from Table
Here you will concatenate REMARK1, REMARK2..... and will store in Variable of Type char1024.
This is the best solution if Table is not going to be maintained by Table Maintenance Generator.
Thanks
Ajay
  • Save More than 1000 chars in a field of (Z) Database Table? Update:11-30

    Hi Friends, I created a database table with few fields. In the table, one field is REMARKS which should save more than 1000 characters for every record. For that field,  I created domain & data element of char with 2000 length. But system gives an er

  • Extracting Values of a Field from a Database Table in SAP ECC System Update:10-11

    Hi, I downloaded Extracting Values of a Field from a Database Table in SAP ECC System Using MII 12.0 senario from sdn. I'm trying to do that senario in MII 12.05. But I have problem with section 6 in page 7 (you can supply senario from sdn) "6- Under

  • To replace values of one of the field in the database table Update:10-11

    How to replace values of one of the field in the database table with a new values? Pls help to solveHi You can use the UPDATE command to update one of the field value in a table see the UPDATE syntax and use it but in real time you should not do like

  • How to delete data from single field in a database table? Update:10-11

    Hi guys,      Plz suggest me How to delete data from single field in a database table? thnks, pavanhi in addition to abv details..chk this: http://help.sap.com/saphelp_nw2004s/helpdata/en/fc/eb3aef358411d1829f0000e829fbfe/content.htm http://dev.mysql

  • To modify a field in a database table based record identification by primar Update:10-11

    hi i want to to modify a field in a database table based record identification by primary key filed and two more fields ie customer (primary key i want to modify record from intenal table the record existing with primary key field customer the status

  • How to Find the Data Type of the Field In a Database Table Update:10-11

    Hi Experts, I'm currently working on a program which needs to find out the data type of the given field in a database table. In addition to accessing DD03L directly, is there any other workaround such as function module to help me achieve this? It wo

  • How to modify or put entry in a particular field of a database table Update:10-11

    i want to to modify a field in a database table record identification by primary key fileds the situatio is like this there are two primay key in database table customer number PK status PK date and third field which i want to modify is customer part

  • How to find the structure fields data in database tables? Update:11-30

    how to find the structure fields data in database tables?Your question doesn't appear to be Web Dynpro ABAP related. Please only post questions in this forum if they are directly Web Dynpro ABAP related.  There are several other more general ABAP rel

  • Mapping the CMP Fields with the Database Table using Websphere??? Update:11-30

    Hi, How to Map the CMP Fields with the Database Table using Websphere thru ejb.jar.xml??? Thanks, JavaCrazyLoverHi, How to Map the CMP Fields with the Database Table using Websphere thru ejb.jar.xml??? Thanks, JavaCrazyLoverRead other 14 answers

  • Do you know of a standard tool to compare the fields of 2 database tables? Update:11-30

    do you know of a standard tool to compare the fields of 2 database tables? please note i dont want to compare data just the fields. ~SureshHi, I am not aware any standard tool but you can write custom report to use FM DDIF_FIELDINFO_GET to get fields