DDIC

[Former Member]

1. What is definiton for Data dictionary

2.Difference b/w pool table and clustered table?

3. If the table contain CLIENT field whether it is a client dependent or independent?

4.What is the reference field and reference table name for CURRENCY AND QUANTITY field.

[Former Member]

hi,

1) Data dictionary describes the logical structures of the objects used in application development and shows how they are mapped to the underlying relational database in tables/views.

2) Pooled Table : Pooled tables are logical tables that must be assigned to a table pool when they are defined. Pooled tables are used to store control data. Several pooled tables can be cominied in a table pool. The data of these pooled tables are then sorted in a common table in the database.

Cluster Table : Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation.

Transparent Table : Exists with the same structure both in dictionary as well as in database exactly with the same data and fields

3)If the table contain CLIENT field it is a client dependent.

4) Reference table for currency is PA0009 and the Reference field is 'WAERS'.

hope it solves ur problem,

please reward if it is useful

regards,

sri.

[Former Member]

data dictionary holds the metadata ( data about the data) mainly the defenations of global structures, domain, tables, search help, lock object etc.

The ABAP/4 Data Dictionary is the central component of ABAP/4 Repository.

It is centralised and structured source of information for business applications

It is the source of every every definition with in R/3 system.

It is totally integrated with other tools of Dev. environment like Screen painter etc.,

Management of data definitions (Select, Insert, Update and Delete)

Preserve data integrity.

Information about the defined relationship between two tables or even dictionary tells whether table is active or empty

2 The difference between pooled and clustered tables is

Cluster tables and Pooled tables have many to one relationship with the underlying database.

A table pool corresponds to a table in the database in which all records from the pooled tables assigned to it are stored.

Several logical data records from different cluster tables can be stored together in one physical record in a table cluster.

• A pooled table cannot have the name having more than 10 characters.

• All the key fields of the pooled table must be of character data type.

• In pooled tables, the maximum length of the key field/data fields should not exceed the length of varkey/vardata of the pool respectively.

• In cluster table the records having the same key are stored in a single key in the cluster.

• If there is an overflow of the data records a continuation record is created with the same table key.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f0d1446011d189700000e8322d00/frameset.htm

3 In table if the first field is CLNT then we call it as client dependent otherwise we call it as client independent

4 Check table VBAK and VBRK

[Former Member]

here is some info about your query

DATA DICTIONARY

Data definitions (metadata) are created and managed in the ABAP Dictionary. The ABAP Dictionary permits a central description of all the data used in the system without redundancies. New or modified information is automatically provided for all the system components. This ensures data integrity, data consistency and data security.

You can create the corresponding objects (tables or views) in the underlying relational database using these data definitions. The ABAP Dictionary therefore describes the logical structure of the objects used in application development and shows how they are mapped to the underlying relational database in tables or views.

The ABAP Dictionary also provides standard functions for editing fields on the screen, for example for assigning a screen field an input help.

What Information is Stored in the ABAP Dictionary?

The most important object types in the ABAP Dictionary are tables, views, types, domains, search helps and lock objects.

Tables are defined in the ABAP Dictionary independently of the database. A table having the same structure is then created from this table definition in the underlying database.

Views are logical views on more than one table. The structure of the view is defined in the ABAP Dictionary. A view on the database can then be created from this structure.

Types are used in ABAP programs. The structure of a type can be defined globally in ABAP programs. Changes to a type automatically take effect in all the programs using the type.

Lock objects are used to synchronize access to the same data by more than one user. Function modules that can be used in application programs are generated from the definition of a lock object in the ABAP Dictionary.

Different fields having the same technical type can be combined in domains. A domain defines the value range of all table fields and structure components that refer to this domain.

The ABAP Dictionary also contains the information displayed with the F1 and F4 help for a field in an input template. The documentation about the field is created for a data element that describes the meaning of the contents of a table field. The list of possible input values that appears for the input help is created by a foreign key or a search help.

http://help.sap.com/saphelp_webas610/helpdata/en/cf/21ea31446011d189700000e8322d00/content.htm

POOL AND CLUSTER TABLE

Check this link

[http://www.sap-img.com/abap/the-different-types-of-sap-tables.htm]

Pooled Tables:

A pooled table in R/3 has a many-to-one relationship with a table in the database .The table in the database has a different name than the tables in the DDIC, it has a different number of fields, and the fields have different names as well. Pooled tables are an SAP proprietary construct.

Pooled and cluster tables are not usually used to hold application data but instead hold system data, such as system configuration information, or historical and statistical data.

A table pool is a database table with a special structure that enables the data of many R/3 tables to be stored within it. It can only hold pooled tables. R/3 uses table pools to hold a large number (tens to thousands) of very small tables (about 10 to 100 rows each).

Cluster Tables:

A cluster table is similar to a pooled table. It has a many-to-one relationship with a table in the database. Many cluster tables are stored in a single table in the database called a table cluster.

A table cluster is similar to a table pool. It holds many tables within it. The tables it holds are all cluster tables.

Table clusters contain fewer tables than table pools and, unlike table pools, the primary key of each table within the table cluster begins with the same field or fields. Rows from the cluster tables are combined into a single row in the table cluster. The rows are combined based on the part of the primary key they have in common. Thus, when a row is read from any one of the tables in the cluster, all related rows in all cluster tables are also retrieved, but only a single I/O is needed.

Restrictions on Pooled and Cluster Tables :

Secondary indexes cannot be created.

You cannot use the ABAP/4 constructs select distinct or group by.

You cannot use native SQL.

You cannot specify field names after the order by clause. order by primary key is the only permitted variation.

CURRENCY AND QUANTITY FIELDS

Hi

Declare the Qty and Currency fields TYPE similar to their data element

EKPO-NETPR --- QUANTITY

WAERS - CURRENCY

CLIENT

client (mandt field)

There are two types of objects in SAP, client dependent and client independent. Objects used in several clients are called client independent while objects used in a specific client is called client dependent. To identify if a table is client dependent, one can use tcodes SE11 or SE12. In the table field attributes, if the MANDT field is present that table is client dependent.

client specific means that you have to copy the script form client to client.

For example: you have a SAP system with 2 clients 000 and 001

You have created a Script in 000 you want to use it in client 001. To use it in 001 you have to copy it from 000.

Actually the concept of client dependent and client independent comes in Dictionary tables.

Where If we create any Ztable and if we specify field MANDT then it is said to be client dependent.

if we dosent specify field mandt in any table it is called as Client independent table.

MANDT is the field which differenciates the table from Client Dependent and Client Independent Tables.

reward point sif helpful

Rohan Malik

[Former Member]

Hi,

1.

Dictionary

The ABAP/4 Data Dictionary is the central component of ABAP/4 Repository.

It is centralised and structured source of information for business applications

It is the source of every every definition with in R/3 system.

It is totally integrated with other tools of Dev. environment like Screen painter etc.,

Some of the main available functions in the ABAP/4 Dict.

Management of data definitions (Select, Insert, Update and Delete)

2.

Transparent Table:

Exists with the same structure both in dictionary as well as in database exactly with the same data and fields.

Pooled Table:

Pooled tables are logical tables that must be assigned to a table pool when they are defined. Pooled tables are used to store control data. Several pooled tables can be cominied in a table pool. The data of these pooled tables are then sorted in a common table in the database.

Cluster Table:

Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation.

A transparent table is a table that stores data directly. You can read these tables directly on the database from outside SAP with for instance an SQL statement.

Transparent table is a one to one relation table i.e. when you create one transparent table then exactly same table will create in data base and if is basically used to store transaction data.

A clustered and a pooled table cannot be read from outside SAP because certain data are clustered and pooled in one field.

One of the possible reasons is for instance that their content can be variable in length and build up. Database manipulations in Abap are limited as well.

But pool and cluster table is a many to one relationship table. This means many pool table store in a database table which is know as table pool.

All the pool table stored table in table pool does not need to have any foreign key relationship but in the case of cluster table it is must. And pool and cluster table is basically use to store application data.

Table pool can contain 10 to 1000 small pool table which has 10 to 100 records. But cluster table can contain very big but few (1 to 10) cluster table.

For pool and cluster table you can create secondary index and you can use select distinct, group for pool and cluster table. You can use native SQL statement for pool and cluster table.

A structure is a table without data. It is only filled by program logic at the moment it is needed starting from tables.

A view is a way of looking at the contents of tables. It only contains the combination of the tables at the basis and the way the data needs to be represented. You actually call directly upon the underlying tables.

http://www.datamanagementgroup.com/Resources/Articles/Article_0106_2.asp

more info

http://help.sap.com/saphelp_erp2004/helpdata/en/81/415d363640933fe10000009b38f839/frameset.htm

http://cma.zdnet.com/book/abap/ch03/ch03.htm

Check this links.

http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm

http://www.techinterviews.com/?p=198

3.You should be knowing that the configurations you are doing are getting updated in soem database tables finally.

The database tables will have one field called MANDT which is the client number. If a database table has this field, then it is called client dependent tables. Any transports updating such tables are called as Client dependent transports.

Most of the configuration(functional) changes are client dependent changes.

On the contrary, there are certain database tables which dont have this field. Hence in one Application server, if there are multiple client, the change done will be reflected in all the clients as the database table is same. Most of the development transports fall under client independent transports. Some of the functional transports like condition table are also client independent transports.

If there are multiple clients in an Application server, a client dependent transport needs to be moved to all the clients by means of a client copy for that particular object through t.code SCC1. For client independent transport, this is not needed. Once a change is done, it will be reflected in all clients within that application server, and hence no transport is necessary.

Regards,

Omkaram.

Edited by: Omkaram Yanamala on Feb 7, 2008 12:08 PM

[Former Member]

hi

Pooled Table : Pooled tables are logical tables that must be assigned to a table pool when they are defined. Pooled tables are used to store control data. Several pooled tables can be cominied in a table pool. The data of these pooled tables are then sorted in a common table in the database.

Cluster Table : Cluster tables are logical tables that must be assigned to a table cluster when they are defined. Cluster tables can be used to strore control data. They can also be used to store temporary data or texts, such as documentation

A clustered and a pooled table cannot be read from outside SAP because certain data are clustered and pooled in one field.

One of the possible reasons is for instance that their content can be variable in length and build up. Database manipulations in Abap are limited as well.

But pool and cluster table is a many to one relationship table. This means many pool table store in a database table which is know as table pool.

All the pool table stored table in table pool does not need to have any foreign key relationship but in the case of cluster table it is must. And pool and cluster table is basically use to store application data.

Table pool can contain 10 to 1000 small pool table which has 10 to 100 records. But cluster table can contain very big but few (1 to 10) cluster table.

For pool and cluster table you can create secondary index and you can use select distinct, group for pool and cluster table. You can use native SQL statement for pool and cluster table.

3. If the table contain CLIENT field whether it is a client dependent or independent?

the table is client dependent.

4.What is the reference field and reference table name for CURRENCY AND QUANTITY field.

currency feild

reference table---tcurr

refernce feild---tcurr

quantity feild

refernce table-----EKPO

refernce feild----MEINS

Edited by: Jyothsna M on Feb 7, 2008 7:54 AM

[Former Member]

Hi,

***Data Dictionary*****

-It is the definition of data base.

-U can say it as the image of the data base.Whatever the data that is appearing the DDIC

it is just a replica of the data that presents in the data base.

• Diff b/w Pooled table and cluste table*******

- There is a vey miner difference between the both that make s them differ from each other.

*

pooled tables: these r small small tables having 100

records in each of them!but, these tables were used for

storing the system data!in these tables there will be no

keys!these tables r having many - to - one relationship!

these tables r having different names which doesnt match

with database tables.

cluster tables: these r very large tables so many records

in each of them!but, these tables were used for storing the

system data!in these tables atleast one primary key will be

present to find the record!these tables r having many - to -

one relationship!

these tables were used by basis people to calculate the

system performance!

*******

cluster tables :

>maintains prinary key reationship.

>these are less no of cluster table which had large no of

records

pooled tables :

> doesnt maintain any primary key relationship

>these are more no of pooled table which had less no of

records

*********

***********CLIENT**************

--If the table contain CLIENT field whether it is a client dependent.

************

CURR n Quan.....

Regards.