topic Re: diff in Application Development and Automation Discussions

diff

Former Member — Mon, 23 Jul 2007 10:23:55 GMT

what i sthe diffrence b/w check table & match code?

Re: diff

Former Member — Mon, 23 Jul 2007 10:26:29 GMT

Hi,

Check Table

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

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.

MATCH CODE

The MATCH CODE is nothing but a DDIC search help. If you want to assign a search help to a PARAMETERS or SELEC-OPTIONS in your report program you can use MATCH CODE followed by name of the DDIC search help. Make sure that the DATA ELEMENTS are matched when you make the assignment.

Have a look on the link:

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

Regards,

Priyanka.

Re: diff

seshatalpasai_madala — Mon, 23 Jul 2007 10:26:43 GMT

Hi,

Check table is the table that will be used to make a proposal for the Foreign key relation ship.

When you create a foriegn key for a field of a table its domains CHECK Table will be given in the proposal.

Where as Matchcode is a search help object, which can be based on a table or a help view.

Check table values will come in F4 only if there is a valid Foriegn key relation ship.

But once you assign a matchcode you will always get F4 help.

Regards,

Sesh

Re: diff

Former Member — Mon, 23 Jul 2007 10:29:10 GMT

Difference between a check table and a value 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.

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.

Matchcodes and Search helps are the SAP provided search engine like tool to search the values for a field

see the doc of search helps which is similar to match codes

1) Elementary search helps describe a search path. The elementary search help must define where the data of the hit list should be read from (selection method), how the exchange of values between the screen template and selection method is implemented (interface of the search help) and how the online input help should be defined (online behavior of the search help).

2) Collective search helps combine several elementary search helps. A collective search help thus can offer several alternative search paths.

3)An elementary search help defines the standard flow of an input help.

4) A collective search help combines several elementary search helps. The user can thus choose one of several alternative search paths with a collective search help.

5)A collective search help comprises several elementary search helps. It combines all the search paths that are meaningful for a field.

6)Both elementary search helps and other search helps can be included in a collective search help. If other collective search helps are contained in a collective search help, they are expanded to the level of the elementary search helps when the input help is called.

CREATION:

Go to SE11 Tcode

select search help

give the 'z' search help name and create

select the selection method ur table name eg : 'mara'

dialog module 'display value immediately'.

add the field whatever u want and lpos = 1 and spos = 1 and check import and export parameter.

where left position when displaying and spos = search position

and then save and activate ..

See the links:

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

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

https://forums.sdn.sap.com/click.jspa?searchID=3173469&messageID=2176485

https://forums.sdn.sap.com/click.jspa?searchID=3173469&messageID=3601619

pls go through this for search help creation

http://help.sap.com/saphelp_nw2004s/helpdata/en/41/f6b237fec48c67e10000009b38f8cf/content.htm

Search Help Exits:

Reward points for useful Answers

Regards

Anji

Re: diff

Former Member — Mon, 23 Jul 2007 10:30:08 GMT

Hi,

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.

Match code is nothing but a search help in SE11.

Check this link for how to create a search help..

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

Regards

Re: diff

Former Member — Mon, 23 Jul 2007 10:31:04 GMT

Hi ,

check table........

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

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.

If useful reward me with points.

Thanks

Sanket.

Match code.....

use this link,

Re: diff

Former Member — Mon, 23 Jul 2007 10:31:30 GMT

The Check Table is the dependent table to which the relationship is defined using foreign keys. The contents of the check table field are shown in the input help for the referenced field.

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.

Matchcodes are an SAP technique to help users find information, normally in

connection with the F4 key on an input field. Information from one or more

tables can be combined and queried on using various search criteria: for

example, all companies whose name starts with "TATA" and whose location is

"INDIA."

Traditionally, matchcodes were implemented as redundant collections of data

in pool tables, as illustrated in the following:

Company header table Company detail table Matchcode pool table

(TAB1) (TAB2) (M_POOL)

Reward all helpfull answers

Regards

Pavan

Re: diff

Former Member — Mon, 23 Jul 2007 10:42:02 GMT

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.

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.

matchcode

Match Code is a tool to help us to search for data records in the system. Match codes are an efficient and user-friendly search aid where key of a record is unknown.

A matchcode is a tool to search for data records in the system. Matchcodes are an efficient and user-friendly search aid for cases where the key of a record is unknown.

It consists of two stages one is Match code object and the other is Matchcode ID.A matchcode object describes the set of all possible search paths for a search term.Matchcode ID describes a special search path for a search term.

maximum number of match code Id's that can be defined for one Match code object is 36.

Re: diff

Former Member — Mon, 23 Jul 2007 12:01:43 GMT

Hi,

Check Table:- Check Table is for Field level Validation. This table is used to check whether data is existing or not. While creating new tables if data is existing then we can give the table as check table.

MATCH CODE:- it will work as search help in data dictionary. We will use these match codes in reports. while using the select-options we will apply this match codes. first we need to create the search help in data dictionary that search help name only we will use in program.

Syn:- Match code <search help name>.

This will work as F4 function key in SAP.

Reward points!!

Thanks & Regards,

Vasudeva Rao