Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

creation ztable

Former Member

‎2009 Apr 06 5:28 AM

0 Likes
1,569

hai all,

my table name is zbatch.

contains 3 fields.

fields dataelement

zbatch charg

zmax charg

zmin charg

save and check the syntax.

raise the errors like,

1) field zbatch : structured type charg cannot be used in db table zbatch

2) field zmax : structured type charg cannot be used in db table zbatch

3) field zmin : structured type charg cannot be used in db table zbatch

4) error in code generation for creating table zbatch in the db

5) table zbatch(statements could not be generated).

please solve the errors

hai all,

my table name is zbatch.

contains 3 fields.

fields dataelement

zbatch charg

zmax charg

zmin charg

save and check the syntax.

raise the errors like,

1) field zbatch : structured type charg cannot be used in db table zbatch

2) field zmax : structured type charg cannot be used in db table zbatch

3) field zmin : structured type charg cannot be used in db table zbatch

4) error in code generation for creating table zbatch in the db

5) table zbatch(statements could not be generated).

please solve the errors

Reply
11 REPLIES 11
Read only

Former Member

‎2009 Apr 06 5:32 AM

0 Likes
1,458

plese check the dataelement

Read only

GauthamV
Active Contributor

‎2009 Apr 06 5:32 AM

0 Likes
1,458

Charge is a structure, use some other data element in your table.

Read only

Former Member
In response to GauthamV

‎2009 Apr 06 5:34 AM

0 Likes
1,458

yes my requirement dataelement is charg.

Read only

Former Member

‎2009 Apr 06 5:34 AM

0 Likes
1,458

Hi,

You cannot use the Structure as data element in the trasparent table.

Read only

Former Member

‎2009 Apr 06 5:34 AM

0 Likes
1,458

CHARG is a structure and you are trying todeclare a field of structure type and this is incorrect way. If you want CHARG structure just include it in your ZBATCH.

Give .INCLUDE as field name and give CHARG as dataelement... it will give all the fields copied into your table..

Read only

Former Member
In response to Former Member

‎2009 Apr 06 5:37 AM

0 Likes
1,458

actuvally my table contains fields like,

batch,max,min.

all fields are exisist in charg structure.

Read only

Former Member
In response to Former Member

‎2009 Apr 06 5:39 AM

0 Likes
1,458

If you include the structure, all the fields will be included in your table.

And if you want to add only those 3 fields in your table, then take the datalements of those 3 fields from the CHARG structure and add...

Hope this helps...

Read only

Former Member
In response to Former Member

‎2009 Apr 06 6:10 AM

0 Likes
1,458

solve my problem.

Read only

Former Member

‎2009 Apr 06 5:35 AM

0 Likes
1,458

use CHARG_D as data element......

as CHARG is itself a structure so it is showing this type of error

Read only

Former Member

‎2009 Apr 06 5:36 AM

0 Likes
1,458

CHARG is a structure , u cannot use the structure as data element

in data element use CHARG_D

field name will be as per ur requirements

Read only

Former Member

‎2009 Apr 06 6:12 AM

0 Likes
1,458

thanks