topic Re: Getting syntax error in Table creation in Application Development and Automation Discussions

Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 11:37:44 GMT

Hi All,

After creating and activating the table, I select utilities->table contents->create entries to enter data into table. But I got a Syntax error.

" Syntax error in Program : SAPLALDB

in include : LALDBCLS

in line : 9

The type "CL_GUI_ALV_GRID" is unknown. "

Can anyone help me out.

Thanks,

Sasi.

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 11:41:33 GMT

Hi,

If u get any syntax error the table will not get activated..just check out the whether table is in active state or not and let me know....

Regards

Kiran

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 11:43:15 GMT

Hi,

No, it was in active status only.

Thanks.

Re: Getting syntax error in Table creation

SuhaSaha — Wed, 11 Feb 2009 11:46:58 GMT

Hello,

Which version of SAP are you using? Plz check in SE24 if you have the class "CL_GUI_ALV_GRID" available.

BR,

Suhas

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 11:49:31 GMT

SAP 4.6 . Yes, CL_GUI_ALV_GRID is available in SE24 and in active status.

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 11:59:19 GMT

Hi,

provide your table name.

Ragards

Arani Bhaskar

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 12:00:01 GMT

hi,

go to se14..if u dont have authorization..

from se11, in utilities-> database utility.-> click on it..

then u can see some buttons.. click on activate and adjust database...

then try to pass the entries..

it should work..

Rgds.,

subash

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 12:03:57 GMT

Table name - ZFIRST_TABLE.

From se14 also it showing syntax error.

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 12:07:39 GMT

hi,

then try to open it in se16 , is it showing the same error..

just check once..

Rgds.,

subash

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 12:10:33 GMT

From SE11, SE16, SE 38,SE14 , SE24 it is showing the same error.

Can u plz tell me the procedure to create the table?

Re: Getting syntax error in Table creation

GauthamV — Wed, 11 Feb 2009 12:13:15 GMT

use this.

[http://help.sap.com/saphelp_erp2004/helpdata/en/cf/21eb6e446011d189700000e8322d00/content.htm]

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 12:15:36 GMT

Dear Sasi,

try this help link to create table ::http://help.sap.com/saphelp_nw70/helpdata/EN/cf/21eb6e446011d189700000e8322d00/content.htm

Let me know still you are struggling.

Regards

Arani Bhaskar

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 12:20:37 GMT

Still same. I too followed those similar steps.

Do I need to do anything with Buffering and Buffering type in Technical settings?

Re: Getting syntax error in Table creation

Former Member — Wed, 11 Feb 2009 12:29:12 GMT

Hi,

Refer following steps for database table creation.

1 . Enter table name to be created. Then press Create .
  2 . Enter short text
  3 . In Delivery and Maintenance tab 
                
uF0D8	Delivery Class : It controls the transport of table data when installing or upgrading, in a client copy and when transporting between customer systems. The delivery class is also used in the extended table maintenance.
       Delivery Classes :
     A :  Application table ( master and transaction data ).
     C :  Customer table , data is maintained by the customer only.
     L :  Table for storing temporary data
     G : Customer table , SAP may insert new records.
     E :  System table of its own namespaces for customer entries.

uF0D8	Data Browser/Table View Maintenance tab:  This specifies whether it is possible to display/maintain a table/view using the maintenance tools data browser (SE16) and table view maintenance (SM30 and SM31).
uF0D8	The values will be 
Display/Maintenance not allowed  : all three are not possible
Display/Maintenance allowed : SE16 SM30 SM31
      Display/Maintenance allowed to limited extent : SE16 

4 . Technical settings : 
uF0D8	Data Class : It defines the physical area of the database, in which the table is logically stored.
   Important data classes are :
   
uF0D8	APPL0   Master data
uF0D8	APPL1  Transaction data
uF0D8	APPL2  Organizational and customizing data

For user development purpose there are another 2 data classes
uF0D8	USR
uF0D8	USR1

uF0D8	Size Category :  It determines the approximate space requirement for a table in the database.

uF0D8	We can select from 0 to 8 for table.
uF0D8	Each will be assigned a specific fixed storage area value in the database.


Buffering Status :  Buffering status specifies whether table may be buffered or not.

We should therefore select

uF0D8	Buffering not allowed :  if a table may not be buffered.
uF0D8	Buffering allowed but switched off : if buffering is allowed for a table, but at the   moment no buffering  should be active
uF0D8	Buffering allowed :  if the table should be buffered. In this case a buffering type must be specified .


Buffering types:  This defines how the table should be buffered.

There are 3 ways

uF0D8	Single record buffering : one record at a time is buffered.
uF0D8	Generic area buffering
uF0D8	Full buffering : all contents of the table or none of the contents are buffered.
 
Logging Changes : 
uF0D8	The logging flag defines whether changes to the data records of a table should be logged. If logging is activated, every change (with UPDATE,  DELETE) to an existing data record by a user or an application program is recorded in a log table in the database.

5 . Fields : 
uF0D8	Enter field name .
uF0D8	In Key field specify whether it is key field or not.
uF0D8	Initialization check u2013 It will assign initial value to that field. When no records present.
uF0D8	Data Element: Enter the data element for that perticular field.
uF0D8	Data Element contains perticular domain ( type and length of field )