topic Re: tables in Application Development and Automation Discussions

tables

Former Member — Mon, 06 Feb 2006 07:10:31 GMT

Hi Friends

what is the diff b/w check table and value table.

& why the abap/4 programs name start with y & z

give me the proper reason.

Re: tables

Former Member — Mon, 06 Feb 2006 07:16:57 GMT

Hi surekha,

1. what is the diff b/w check table and value table.

This concept comes into picture

where we want to use FOREIGN KEY concept.

2. Suppose we create two TAbles

and on second table,

and on some field,

we want to define foreign key.

3. When we do that,

we need to select the

CORRESPONDING TABLE AND ITS FIELD NAME,

manually.

4. If we have ALREADY DEFINED

VALUE TABLE (on the corresponding domain)

then ,

Its value is AUTOMATICALLY PROPSOED

BY THE SYSTEM, when we want to

define the foreign key.

*----

why the abap/4 programs name start with y & z

BCOS,

all customer developments,

start with Y,Z

(this is as per SAP guidelines.

b) so that

SAP creates programs from A-X,

and customer crates from Y-Z.

c) Therefore there is a DISCIPLINE followed

and no OVER-LAAPING is done.

regards,

amitm.

Message was edited by: Amit Mittal

Re: tables

hymavathi_oruganti — Mon, 06 Feb 2006 07:17:07 GMT

value table: u will give in domain.

the value table will not show u f4 help if there is no foreign key relationship.

check table: when u want to create a foreign key relation ship between A and B,

A is the primary table, B is the table for which i want to create a foriegn key relation ship with table A.

u click on the foreign key relation ship icon for a particular field, it will ask u to enter the "CHECK TABLE" name.

note: if already in table A , if u have defined a value table, now it will suggest the name of the value table as the check table. if no value table is there , it will suggest nothing.

SO, WITH CHECK TABLE U CAN GET F4 HELP FOR THE FIELD.

WITH VALUE TABLE U CANT GET F4 HELP UNLESS U HAVE A CHECK TABLE TOO FOR THE FIELD AND THE CHECK TABLE NAME AND VALUE TABLE NAME ARE SAME.

Re: tables

abdul_hakim — Mon, 06 Feb 2006 07:24:02 GMT

>>what is the diff b/w check table and value table.

Check table contains set of permitted value for foreign table key fields.Check table is also called as referenced table.

Value table contains set of allowed values for a particular field.Check against the value table only take effect if the foreign key has been defined..

>>why the abap/4 programs name start with y & z

Name y to z are given for customer developments and other names are reserved by SAP for their own developments..

Regards,

Abdul

Re: tables

Former Member — Mon, 06 Feb 2006 07:30:06 GMT

thank u all.