abap dictionary

[Former Member]

Can anybody tell me the one scenario to the need of creating ztable?

Thanks in advance

[Former Member]

Hi,

IF WE HAVE CUSTOMIZED DATA TO STORE IN DATABASE , WE CREATE A TABLE.

rgds,

bharat.

[paruchuri_nagesh]

hi

its depends on the client requirement

reward for use ful answers

regards

Nagesh.Paruchuri

[Former Member]

Hi Anil,

There may be cases where you might develop a report to calculate some complex formulae and you might also require to store the calculated / derived data for further use globally to many users using this package. In such cases you are required to create a custom table to hold such calculated / derived data.

<b>

Reward points if this helps,</b>

Kiran

[Former Member]

hi

good

when the customer wants any customizing table for his own requirement that time generally we create the ztable.

thanks

mrutyun^

[Former Member]

hi,

I m giving u one real time example.

One time in my company, one requirement arose to print the lable in which some cooling condition has to be printed.

At that time our sir has advised to our team to define a ztable in which store all the condition and in report fetch the condition acording to temeparature condition from that one.

Here we have declared the ztable.

thanks

Dharmishta

[Former Member]

Hi

here i am giving you the steps to creat atble , with all the functinalities

reward if usefull

1) Steps to create a Transparent Table

2) Steps to create a Data Element.

3) Steps to create a Domain

4) Steps to create a Database View

5) Steps to create an Elementary Search

Help

6) Steps to create a Collective Search Help

<b>Create transparent table</b>

Go to transaction SE11. Enter name of table you want to create (beginning with Y or Z) and click on create pushbutton

Enter the delivery class and the table maintenance criteria

The delivery class controls the transport of table data when installing or upgrading, in a client copy and when transporting between customer systems .

The display/maintenance indicator specifies whether it is possible to display/maintain a table/view using the maintenance tools Data Browser (transaction SE16) and table view maintenance (transactions SM30 and SM31).

Enter the name of the table field and the data element. The

System automatically populates the technical details for

existing data elements.

So far as possible it is advisable to use existing data elements which befit the business requirements.

However, we may create data elements if need be. The same is shown in the next slide.

To create a data element simply double click on it.

Alternately create a data element by simply choosing the

data type radio button on SE11 initial screen.

<b>Create data element</b>

The system prompts you to create a new data element.

Choose the Yes pushbutton.

Under the data type tab enter the domain name which

determines the technical characteristics of the field.

Further characteristics tab: Allows you to specify a search help assigned to the data element.

It also allows you to specify a parameter id which helps you populate a field from SAP memory.

Field label: Can be assigned as prefixed text to a screen field referring to the ABAP Dictionary. The text is displayed on the screen in the logon language of the user (if the text was translated into this language).

<b>Create domain</b>

If the domain does not exist in the data dictionary the

system prompts you to create one.

Give the technical characteristics under the definition

tab. Value range allows you value restriction at domain

level.

Value range tab:

As explained in the section Consistency through input checks one can restrict the possible values for a field at domain level itself by either entering fixed values or by specifying a value table under the tab Value range.

<b>Currency/Quantity fields in a table</b>

A currency or a quantity field must be assigned a reference field from a reference table containing applicable qty unit or currency unit.

Field of the reference table, containing the applicable quantity unit or currency

A field containing currency amounts (data type CURR) must be assigned a reference field including the currency key (data type CUKY).

A field containing quantity specifications (data type QUAN) must be assigned a reference field including the associated quantity unit (data type UNIT).

<b>Create transparent table</b>

Maintain the technical settings of the table by clicking on the tab

<b>Create database view</b>

Enter the name of the view on in the initial screen and say ‘create’.

Choose database view as the view type.

Enter the table names and the join conditions for the

database view.

Under the tab View Flds, specify the names of the fields

from either table whose data you want to access using the

view.

The system allows you to enter data restricting conditions

under the tab Selection conditions.

Finally enter the maintenance status.

<b>Elementary Search Help</b>

Enter the search help name and click on create.

Choose elementary search help radio button option as the search help type.

Enter the search help parameters, the selection method and activate the search help.

Enter the search help name and click on create.

Choose Collective search help radio button option as the search help type.

Enter the search help parameters.

Note that there is no selection method to be entered for a collective search help.

<b>Collective Search Help</b>

Instead of the selection method, we enter the included

search helps for the collective search help.

We need to assign parameters for each of the included

search helps.

Complete the parameter assignment by clicking on the push button

Collective search help offers the user to obtain F4 help

using any of the included search helps.

<b>Reward if usefull</b>