general reporting

[Former Member]

1:what is a parralel cursor method how it can replace the nested looping .

2: what we have to take care about when we r using for all entries clause .

3:how do we validate the screen inputs ina module pool screen .

[Former Member]

1) - Look at the last form in <a href="/people/rob.burbank/blog/2006/02/07/performance-of-nested-loops weblog.</a>

2) - Make sure the table you are using for all entries is not empty. Instead of picking up zero entries, it will pick up all entries from the table.

3) - In the PAI of the program, use the FIELD statement for a single field or CHAIN for multiple fields. Put your cursor on each of these statements and press F1 (help) for more documentation.

Rob

[Former Member]

Hai 3rd Question Answer

3)a)Automatic Field Checks :

1) Required Entry Validation : Here If it is a required field we are not giving any value and press enter the system will gives an error message

2) Format --> Data Type

3) Check Table Validations

3)b)Field Validations in Flow Logic

field <fieldname> values ('A', 'B', 'C').

anything other than these values the system gives error message

field <fieldname> values (Between 'A' and 'M').

3)c) Field validations in ABAP(SE38) Program

select single werks from marc where werks = v_werks

if sy-subrc <> 0.

message E001 'Invalid Input'.

endif.

Validate Single Field :

Field <fieldname> Module <Module Name>.

Validate Multiple Fields :

chain

field <marc-matnr>, <marc-werks> module <Module name>.

endchain.

thanks & regards

Sreenivas P

[hymavathi_oruganti]

2. DRIVER TABLE(FIRST INT TABLE) SHOULD NOT BE EMPTY

[Former Member]

hi

good

Time for unindexed select : 00:06:09 Number of BKPF entries: 5,863 Number of BSEG entries: 17,683 Time for nested loop : 00:00:53 Number of BKPF reads : 5,863 Number of BSEG reads : 17,683 Time for indexed loop : 00:00:00 Number of BKPF reads : 5,863 Number of BSEG reads : 17,683 Time for parallel cursor : 00:00:00 Number of BKPF reads : 5,863 Number of BSEG reads : 17,683

Second run –

Time for unindexed select : 00:21:07 Number of BKPF entries: 55,777 Number of BSEG entries: 205,285 Time for nested loop : 02:16:21 Number of BKPF reads : 55,777 Number of BSEG reads : 205,285 Time for indexed loop : 00:00:01 Number of BKPF reads : 55,777 Number of BSEG reads : 205,285 Time for parallel cursor : 00:00:01 Number of BKPF reads : 55,777 Number of BSEG reads : 205,285

This is the example of a parallel cursor.

Thanks

mrutyun

[Former Member]

Hi rohit,

2. what we have to take care about when we r using for all entries clause

Just that we are linking all the fields

which are common to

internal table <----

---

> and dbtable.

2.

how do we validate the screen inputs ina module pool screen .

We have to use these commands or

combination of them to

implement the required validations.

FIELD fieldname.

CHAIN .------ ENDCHAIN.

MESSAGE

Please see F1 help on them get detailed information.

For obligatory, we can just

make the field obligatory in screen painter.

regards,

amit m.