Table with out Data element

[Former Member]

Hi,

While creating a table we need dataelement and domain.

Can we create a database table with data element?

If so wht are the advantages?and wht are the disadvantages we will get..

Thanks.

Sri

[Former Member]

hi,

Data elements are semantic attributes of a field and domains are technical attribute of a field . We can also create dictionary tables without data element and domains. The advantage of using domain is, we can have unique field attribute through out our application. Consider the field Matnr in Mara table which has the domain MATNR with char 18 and data element MATNR. MATNR field occurs in more than one table, if suppose you are not using domain you have to give technical attributes separately, which will not be compatible for future enhancement. Moreover a single domain can have more than one data element in different table, this gives the flexibility of having the same technical attributes of different fields to have different semantic attributes (Data element).

[Former Member]

Hi,

We can also create data elements or domains without having reference to any standard domain or data element. For eg: if you require a field of char 50,

then define FIELD1 as type CHAR50.

But every field should have some characteristics attached to it and these characteristics are defined through data elment and doman.

Regards

Subramanian

[Former Member]

hi,

In case you dont want to use data elements, you can use Built in type as an alternative. There is a tab that flips between BUILT IN TYPE and DATA ELEMENT.

Basic differences are:

1) Data elements can be reused in other Dic. tables

2) Search for Built in type is not possible.

There are many other diff....

Reward points if helpful.

Bijal

[seshatalpasai_madala]

Hi,

There is no disadvantage if you use Dataelements in your table definition. But you have lots of advantages.

You can use your table fields for screen fields. This will automatically give you F1 help for the fields and also labels for the fields.

You can assign Search help's to the table which have the same Dataelement, this is very useful if you are transferring more values from the search help to the screen since you do the field assignment in the table itself.

Also once you have the search help assigned at the table level or at the dataelement level all the screen fields will inherit the attributes of the dataelemt like short text medium text, alv ccolumn headers, F1 help etc.

Regards,

Sesh

Message was edited by:

Seshatalpasai Madala