03-14-2009 6:26 AM
Hi All,
I have a small question regaridng the creation of Table type.
Let us suppose I am creating Table type for a custom table zsample which is having 5 fields. I am generally creating a structure similar to custom table and using that structure as line type for the table type. Let us suppose if there are any changes in the custom table like change in the order of fields or if new fields are added the table type will give dump.
My question is If I use the custom table itself as a line type, will there be any effect in the performance or some thing or I can go ahead and use it..
Thanks,
Ravee
03-14-2009 7:47 AM
U can create the table type with custom table , it will not affect the performance in any way .
03-14-2009 7:47 AM
U can create the table type with custom table , it will not affect the performance in any way .
03-14-2009 10:07 AM
If you are creating custom table type with Standard table as line type as LINE TYPE will not create any performance issue because it is just a reference for creating internal table.
If you are using custom table type and change the order of field of the Table type you avoid Dump if you use INTO CORRESPONDING FIELDS OF TABLE but again it hampers performance.
Regards,
Gurpreet
03-14-2009 11:22 AM
i think it does not bother for the custom or standard table type in a program....this is for the global definition
03-14-2009 4:04 PM
What dump are you expecting ???
It is idea behind the creation with reference to get structures and tables which always look like
the tables they refer to.
I can not see a possibilty for a dump as long as you create only an internal table.
A dump could appear, if the internal table is later used to update another db-table. But there it should be clear that the structure of an internal should be created with reference to the tables which they change.
Siegfried
03-15-2009 6:21 AM
Hello Siegfried,
I am also talking about the same dump when we try to create internal table with that table type and try to update the table.
Thanks for your reply..
03-15-2009 9:16 PM
I don't really understand, please write carefully, whether you refer to internal tables or db-tables and were you get a dump and what kind of dump.
Simple dumps as time-out and memory shortage are always possible.
Siegfried