topic Re: Please tell the differences in Application Development and Automation Discussions

Please tell the differences

Former Member — Tue, 19 Sep 2006 13:56:15 GMT

wt is the difference between value table and check table?

wt is the diff between standard report and classical report?

wt is the diff b/w classical report & interactive report?

wt is load-of-program?

Re: Please tell the differences

Former Member — Tue, 19 Sep 2006 13:57:43 GMT

thanx in advance and I promise to Reward.Kindly answer this

Re: Please tell the differences

Former Member — Tue, 19 Sep 2006 14:00:10 GMT

standard report is the SAP developed programs.

Classical reports : just we will display the user some output(list).no further selection is possible.

interactive list: users can select a value from the first output and go further.that means,first we will display some output to the user. based on his need,he will select one of the row of that output and we will display further info related to that selection of that row. this we call it as interactive list.

Regards

srikanth

Message was edited by: Srikanth Kidambi

Re: Please tell the differences

Former Member — Tue, 19 Sep 2006 14:00:49 GMT

wt is the difference between value table and check table?

No Real difference in technical terms.

wt is the diff between standard report and classical report?

Two names for the same.

wt is the diff b/w classical report & interactive report?

NO user action possible in classical report. Just display purpose. But in interactive ones, you can double click on the lines to navigate to other lists /transactions(User action possible)

wt is load-of-program

Check sap documentation:

Syntax Diagram

LOAD-OF-PROGRAM

Basic form

LOAD-OF-PROGRAM.

Effect

Event keyword:

Triggers the associated event in an internal session after loading a program of type 1, M, F, or S. Also runs the associated processing block once and once only for each program and internal session.

The processing block LOAD-OF-PROGRAM has roughly the same function for an ABAP program of type 1, M, F or S as a constructor has for classes in ABAP Objects.

Programs of type 1, M, F or S can be loaded into an internal session in one of two ways:

Call program

When you call a program using the SUBMIT statement or a transaction code, the system opens a new session and triggers the LOAD-OF-PROGRAM for each call .

External procedure calls

The first time the system calls an external procedure (subroutine or function module), it loads the main program belonging to the procedure called in the internal session of the called program. It also triggers a LOAD-OF-PROGRAM event and runs the associated processing block, before running the called procedure. Whenever a procedure belonging to the same main program is called after that, the system does not trigger a LOAD-OF-PROGRAM event.

REgards,

Ravi

Re: Please tell the differences

Former Member — Tue, 19 Sep 2006 14:01:28 GMT

hi,

<b>value table</b>

In some cases you can see when you define a domain that all the table fields or structure

components referring to this domain should be checked against a certain table. This information

can be stored in the domain by entering a value table.

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

A check is not implemented by simply entering a value table! The check against the value table

only takes effect when a foreign key has been defined.

<b>check table</b>

An input check for the field can be defined with a foreign key. This input check appears on all the screens in which the field is used.

Value table is maintained in the domain where as checkbox is specified in the data element of a field.

Regards,

Sailaja.

Re: Please tell the differences

Former Member — Tue, 19 Sep 2006 14:03:54 GMT

HI Anurag,

• Check table will be at field level checking.

• Value table will be at domain level checking

thanks

sony

Re: Please tell the differences

Former Member — Tue, 19 Sep 2006 14:04:07 GMT

1. Check Table means if you define a field in a table based on the any other table. In this case the other table becomes check table to this field. It means once you creat any entries in to this field first it will check with the fields in the check table, if the field which u entered exists in that table then only u can save that entry. It means this field is based on that table.

3. Classical report is a report which will display u all the details only in one list, where as interactive report means based on the first list you can go to other lists. Like this u can go till 21 interactive lists.

Regards

Haritha.

Re: Please tell the differences

former_member404244 — Tue, 19 Sep 2006 14:08:16 GMT

Hi anurag,

1>yes there is difference.value table is done for domain level checking and chek table is for field level checking.Also value table is nothing but default check table which the system proposes for the domain which has value table .u can see it in the domain level ,in the last tab.

2>The two names for the same.

3>User interaction is not possible in classical report,but it is possible in interactive report,where u can navigate from basic list to several secondary lists.maximum seconadry lists are 20.

4>It triggers the associated event in an internal session after loading a program of type 1, M, F, or S.

regards,

Nagaraj

Re: Please tell the differences

Former Member — Tue, 19 Sep 2006 14:14:30 GMT

Hello,

VALUE TABLE becomes the CHECK TABLE only after defining the foreign key. But both the table name are the same.

Regs,

Venkat Ramanan N

Re: Please tell the differences

Former Member — Tue, 19 Sep 2006 14:43:04 GMT

HI Anurag,

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.

In ABAP, there are a total of 6 types of reports. They are:

Classical

Interactive

Logical Database

ABAP query

Report Writer

Report Painter

drill down reports

Classical ReportsEdit section

These are the most simple reports. Programmers learn this one first. It is just an output of data using the Write statement inside a loop.

Classical reports are normal reports. These reports are not having any sub reports. IT IS HAVING ONLY ONE SCREEN/LIST FOR OUTPUT.

Events In Classical Reports.

INTIALIZATION: This event triggers before selection sreen display.

AT-SELECTION-SCREEN: This event triggers after proccesing user input still selection screen is in active mode.

START OF SELECTIONS: Starrt of selection screen triggers after proceesing selection screen.

TOP-OF-PAGE: It provides header for abap reports.

END-OF-PAGE: It provides footer for page.

AT PF: For predefined function keys................

END-OF-SELECTION////////////////////////////

AT USER-COMMAND : IT provides user functions keys.

Interactive ReportsEdit section

As the name suggests, the user can Interact with the report. We can have a drill down into the report data. For example, Column one of the report displays the material numbers, and the user feels that he needs some more specific data about the vendor for that material, he can HIDE that data under those material numbers. And when the user clicks the material number, another report (actually sub report/secondary list) which displays the vendor details will be displayed.

We can have a basic list (number starts from 0) and 20 secondary lists (1 to 21). Events associated with Interactive Reports are: 1. AT LINE-SELECTION 2. AT USER-COMMAND 3. AT PF<key> 4. TOP-OF-PAGE DURING LINE-SELECTION. HIDE statement holds the data to be displayed in the secondary list. sy-lisel : contains data of the selected line. sy-lsind : contains the level of report

http://help.sap.com/saphelp_nw2004s/helpdata/en/c5/aa575426ad11d2954d0000e8353423/content.htm

Regards,

Laxmi.