intrv questions

[Former Member]

Hi all,

few questinos

1) what is diff between check table and value tabel?

2) how exactly cluster table contains record(please no link)?

3) if search help is associated with data-element and value table is given in the domein used by that dataelement then which will be called in F4??

4) in NACE we have program name and routine name what exaclty are those???

thanks in advance

[Former Member · Accepted solution]

1) check table is used to validate your entries , valuye table is used to ensure the main table for a perticular field.

Exmple: MARA is check table for MARC . The materials you can enter in MARC should be there in MARA .

alos MARA is value table defined in Domain . It means that you can check for master entries in MARA table.

some times check table and value table may not be unique.

Value table does not validate your entries in a table.

2) For cluster table check CDHDR and CDPOS

Table Cluster :

Database table in the database that contains the data of several cluster tables.

Cluster Table :

Database table defined in the ABAP Dictionary, whose version on the database is not only assigned to one table defined in the ABAP Dictionary. Several cluster tables are assigned to a table cluster in the database. The intersection of the key fields of the cluster tables forms the primary key of the table cluster. The other columns of the cluster tables are stored in compressed form in a single column VARDATA of the table cluster. You can access cluster tables only via Open SQL, and only without using joins.

also get some more info from following link.

Even you mentioned not to give the link ............. it will be useful for you you will get more info right in the link. because it will be difficult for ones to type all the information. and some information cant be explained in words but thru diagrams.

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21f083446011d189700000e8322d00/content.htm

3) I dont think value table will be used for F4 help. Only search help.

4)NACE configuration is mainly used to link your FORM to out put type. In the output you will be defining the print medium.

and when you copnfigure messages in the transaction with the medium . The corresponding output will be triggered with the liked putput medium.

Reward points if useful

Regards,

Nageswar

[Former Member · Accepted solution]

thankx for ur answers..

could you tell me some thing about NACE tcode.

how to excute my smartform instead of MEDRUCK that is given in NACE??

can we debug SMARTFORMS if ys then how???

[Former Member · Accepted solution]

You mean to ask that script is already configured against the putput type and now you want to change the script to smartform in the debug mode to check the output. Am I right?

Or tell me your exact requirment then I can explain you accordingly.

Smartform Debug:

) You can write the code in smartform in program lines or in subrotines right . there you can hard code break point

break-point. or break <username>

2) when you activate form function moldule will be generated right? take that function moldule name and go to SE38

let us say FM is /1BCDWB/SF00000109

then add SAPL after second slash /1BCDWB/SAPLSF00000109 and say display

now you can put soft break points wherever you need.

3) your FM is /1BCDWB/SF00000109 go to se 37 and put soft break points in the function module.

Reward points if useful

Regards,

Nageswar

[Former Member · Accepted solution]

ys script is already configured against the oputput type and now to change the script to smartform in the debug mode to check the output?

[Former Member · Accepted solution]

In debug you need to change both print program and form name. Because program coding is different for both . So only changing the formname wont give you the output . Instead you will get dump.If you have both then do as follows.

Go to program RSNAST00 and put break point at line number 792 . The line may vary form version to version . But this dies not matter.

and when you execute script change below parameters

tnapr-fonam------Delete this name ( This is scrfipt name)

tnapr-ponam----change print program

tnapr-sform -- give smartform name.

and execute.

Thats it.

Regards,

Nageswar

[Former Member]

1.Check this info.

Check Table is for Field level Validation whereas Value table is for Domain Level Validations.

Value Table proposes table for check table.

I think you are clear with this.

more elaborate.

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

Check Table

The Check Table is the table used by system to check if a data exist or not exist.

While creating a table if you want to be sure that a field can have some values

and these are in a certain table, you can give IT this table as CHECK TABLE.

Value Table

This is maintained at Domain Level.

When ever you create a domain , you can entered allowed values. For example you go to Domain SHKZG - Debit/credit indicator.

Here only allowed values is H or S.

When ever you use this Domain, the system will forces you to enter only these values.

This is a sort of master check . .

To be maintained as a customization object.

This mean that if you want to enter values to this table you have to create a development request & transport the same.

Differences:

1)check table will carry out the check for input values for the table field being entered in any application

and value table will provide values on F4 help for that table field.

2)The check table defines the foreign keys and is part of the table definition.

The value table is part of the domain definition.

Also Check this info.

CHECK TABLE----

---

VALUE TABLE

1. It works at table level.----

---

1. It works at a domain level.

2. It is a master table

-

---

2. It provides a list of values

with a valid set of values.----

---

which will be automatically

-

---

proposed as a check table

-

---

while creating a foreign key

-

---

relationship.

3. The contents of this table----

---

3. It is a sort of master check.

will be used for input help----

---

for which the check table is

-

---

assigned.----

---

4. It is called as foreign key----

---

4. It may also be maintained

table in DBMS.----

---

as a customization object,

-

---

which may require to

-

---

transport development request.

Value Table

The system proposes the value table as check table when you try to define a foreign key for the field or component. This proposal can be overridden.

https://www.sdn.sap.com/irj/sdn/advancedsearch?cat=sdn_help&query=value+table&adv=false&sortby=cm_rn...

Refer

Hope this resolves your query.

2.Cluster Tables:

Hi,

Table pools (pools) and table clusters (clusters) are special table types in the ABAP Dictionary. The data from several different tables can be stored together in a table pool or table cluster. Tables assigned to a table pool or table cluster are referred to as pooled tables or cluster tables.

A table pool or table cluster should be used exclusively for storing internal control information (screen sequences, program parameters, temporary data, continuous texts such as documentation). Data of commercial relevance is usually stored in transparent tables.

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

A cluster key consists of a series of freely definable key fields and a field (Pageno) for distinguishing continuation records. A cluster also contains a long field (Vardata) that contains the contents of the data fields of the cluster tables for this key. If the data does not fit into the long field, continuation records are created. Control information on the structure of the data string is still written at the beginning of the Vardata field.

The records of all cluster tables with the same key are stored under one key in the assigned table cluster. The values of the key fields are stored in the corresponding key fields of the table cluster. The values of all data fields of the assigned cluster tables are written as a string to the Vardata field of the table cluster. Besides the actual data values, the data string contains information on the structure of the data and which table it comes from. If the string exceeds the maximum length of the Vardata field, a continuation record is written with the same key values. The continuation records for a key are distinguished by their value in field Pageno. The actual length of the string in the Vardata field is stored in the Pagelg field by the database interface.

You need the structural information stored in the ABAP Dictionary to read the data from a pooled table or cluster table correctly. These tables can therefore only be processed using Open SQL with the cluster interface, and not with Native SQL directly in the database.

3.We can use the data given in the Value table of the domain also as tha search help for that field.

4.Program Name:

It is the name assigned to particular code in ABAP.I t is given for convenience for the future use.we can also include the code again in another program by giving the name of the program neede to be used.

Routine Name:

It is the name given to the subrutine .Subroutine is reusuable ABAP code ,which can be called and can be used anywhere in the program any number of times.

Reward Points if found helpfull..

Cheers,

Chandra Sekhar.

[Former Member]

Hi,

Value Table

This is maintained at Domain Level.

When ever you create a domain , you can entered allowed values. For example you go to Domain SHKZG - Debit/credit indicator. Here only allowed values is H or S.

When ever you use this Domain, the system will forces you to enter only these values.

This is a sort of master check . To be maintained as a customization object. This mean that if you want to enter values to this table you have to create a development request & transport the same.

Check table

For example you have Employee master table & Employee Transaction table.

When ever an employee Transacts we need to check whether that employee exists , so we can refer to the employee master table.

This is nothing but a Parent & Child relationship . Here data can be maintained at client level , no development involved.

As per DBMS what we call foregin key table, is called as check table in SAP.

There is 1 more important Difference in Value Table and Check Table is that:

1. The contents of the check will be used as an input help(F4 Help) for a particular field on which a check table is assigned.

But the contents of Value Table are never used in Input Help.

The Heirarchy which decides from where to used the Input Help is:

1. Input help defined explicitly in ABAP Program or Dialog Module.

2. Input Help Attached to the referenced Database Table field.

3. Using the contents of Check Table as an input help if neither (1) or (2) help are there.

4. Input help from Fixed value or Value range given in Domain.

A cluster provides an optional method of storing table data. A cluster is made up of a group of tables that share the same data blocks. The tables are grouped together because they share common columns and are often used together. For example, the emp and dept table share the deptno column. When you cluster the emp and dept tables (see Figure 18-1), Oracle Database physically stores all rows for each department from both the emp and dept tables in the same data blocks.

Because clusters store related rows of different tables together in the same data blocks, properly used clusters offer two primary benefits:

Disk I/O is reduced and access time improves for joins of clustered tables.

The cluster key is the column, or group of columns, that the clustered tables have in common. You specify the columns of the cluster key when creating the cluster. You subsequently specify the same columns when creating every table added to the cluster. Each cluster key value is stored only once each in the cluster and the cluster index, no matter how many rows of different tables contain the value.

Therefore, less storage might be required to store related table and index data in a cluster than is necessary in non-clustered table format. For example, in Figure 18-1, notice how each cluster key (each deptno) is stored just once for many rows that contain the same value in both the emp and dept tables.

After creating a cluster, you can create tables in the cluster. However, before any rows can be inserted into the clustered tables, a cluster index must be created. Using clusters does not affect the creation of additional indexes on the clustered tables; they can be created and dropped as usual.

You should not use clusters for tables that are frequently accessed individually.