Community
Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Read only

check tables

Former Member

‎2007 Dec 08 4:22 PM

0 Likes
409

what is check table and value table?diff between check and value table

what is foriegn key?define

difference between runtime analysis and runtime error

what is check table and value table?diff between check and value table

what is foriegn key?define

difference between runtime analysis and runtime error

Reply
2 REPLIES 2
Read only

former_member195698
Active Contributor

‎2007 Dec 08 4:40 PM

0 Likes
384

Check table vs value table

Foreign Key

http://help.sap.com/saphelp_nw70/helpdata/en/cf/21ea77446011d189700000e8322d00/content.htm

Runtime analysis - Is used to check the analyse your program for performance, memory usage etc.

http://help.sap.com/saphelp_nw04/helpdata/en/c6/617cafe68c11d2b2ab080009b43351/content.htm

Runtime Error - Errors which are found only when the program is executed. These are the errors not caught during the syntax check. SAP will raise error of type A (abort) and the program will end. The reason for the error can be seen in the transaction ST22.

Read only

Former Member

‎2007 Dec 08 7:37 PM

0 Likes
384

<b>Value Table</b>

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.

<b>Check table</b>

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.

<b>Differences:</b>

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.

<b>Foriegn key</b>

A foreign key is a field in a relational table that matches the primary key column of another table. The foreign key can be used to cross-reference tables.

<b>Runtime analysis</b>

This runtime analysis tools allows the ABAP/4 programmer to trace the tables used by the SAP dialog/reports programs

SE30 ABAP Objects Runtime Analysis

<b>Runtime error analysis</b>

A long running batch job failed with a runtime error. The error is hard to debug.

Therefore only the dump is available for the analysis.

ST22 ABAP Runtime Error Analysis