how to get rid of

[Former Member]

Hi,

I am using standard program SD70AV3A for a report.

but because of huge data in my Nast table.i am getting dump where the data is getting from Nast.

i had requested the user to get the report with minimising the selections.

but he need the total report for all the output types he is using nearly 150.

we had indexed the table also. but no use.

any one please help me from the technical view point i can do most for that report to run.

Thank You,

Best Regards,

Ravi.

[former_member181966]

Check OSS Note # 353518

FYI

Symptom

You use Transaction VF31 'Output from billing' or program SD70AV3A to process billing outputs.

It takes much time before the output list of the billing outputs to be processed is displayed. In addition, the long-running selection process may lead to a termination.

This termination can occur both after the call of program SD70AV3A in a background job and via the 'Output from billing' transaction.

Other terms

Output processing, billing document print, SD70AV3A, VF31, NAST, print, billing document, performance

Reason and Prerequisites

In the standard system, program SD70AV3A selects all records of output control table NAST first (according to output type and so on) and filters the suitable documents (according to sales organization and so on) of table VBRK of the billing documents from this selection.

Depending on which selection information you provide to the program, the reverse selection method may be faster that is, if the program searches for suitable documents first and only then for entries in table NAST.

Examples

1. You select with the following information:

Processing mode: 2

Billing date: December 17th, 2002 - December 18th, 2002

The conventional selection method selects all NAST records first, then reads the corresponding VBRK entry for each NAST entry and then filters the correct documents.

The alternative selection method listed below selects the correct documents from table VBRK first and then reads table NAST with this relatively small quantity.

Under these selection prerequisites, the alternative method is more favorable.

1. You select with the following information:

Output type: RD00

Processing mode: 3

The conventional selection method selects all incorrect NAST records of output type RD00 first and then reads the corresponding VBRK record per NAST record (to check the authorization).

The alternative selection method reads all VBRK records first and then searches for incorrect RD00-NAST records in this quantity (processing mode 3).

Under these selection prerequisites, the conventional method is more favorable.

Solution

With the following solution, you have the option to select either the alternative selection method (first table VBRK is read, then table NAST) fix or to leave it to the user to decide which of the two selection options he/she wants to use - depending on which selection information is selected.

Up to and including Release 4.5B, it may be required to implement the attached source code. Then the source code is included in the standard system. However, you always have to consider the following solution description since the source code alone does not change the system response of the standard system.

You can use parameter F_SELECT to control the selection of the selection method.

You have three options to set the parameter:

1. First, the program reads table NAST, then table VBRK (standard system).

F_SELECT(1) TYPE C DEFAULT ' ' NO-DISPLAY.

2. First, the program reads table VBRK, then table NAST (alternative)

F_SELECT(1) TYPE C DEFAULT 'X' NO-DISPLAY.

3. The user controls which selection method should be selected. In this case, an additional checkbox is displayed on the selection screen. If the checkbox is not selected, the standard selection method is used. If the checkbox is checked, the alternative selection method is used.

F_SELECT(1) TYPE C DEFAULT ' '.

The options specified under 2. and 3. are only possible with a small modification of parameter F_SELECT in standard program SD70AV3A. If you want to avoid a modification, you can also copy program SD70AV3A to the customer namespace and change the copied program.

Consider that it makes sense for both selection methods to provide as much information as possible and to keep the selection intervals as small as possible. In particular, you should try to include information on the document number. For example, it is always more favorable to include information on a document number range than a billing date range.

Hope this’ll give you idea!!

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

[Former Member]

no use.....

Thnak You,

Ravi

[former_member181966]

Also look at OSS Note # 601106

FYI

Symptom

In Transaction 'Output from Billing' (VF31) you want to display outputs that have been processed incorrectly (processing mode = 3).

This may cause a very long selection time.

Other terms

VF31, invoice, RD00, output processing, billing document

Reason and Prerequisites

The system imports all entries of output table NAST that correspond to the selection conditions of the billing document numbers, the output types and the transmission media.A query whether these entries have been processed incorrectly is only run afterwards in a loop.

Depending on how wide the ranges are, this can cause long runtimes.

Solution

If you implement the attached correction, the system only selects incorrectly processed outputs when you search for incorrectly processed outputs.If you have not specified any billing documents as a selection criterion, the system uses secondary index A of table NAST.

<b>OSS Note # 641142</b>

Symptom

The selection of outputs using Transaction VF31 'Outputs from billing' takes very long.

The user can also process outputs for which he/she has no authorization (aurthorization for billing type and sales organization).

Other terms

Performance, duration, output, print, RD00, processing, query of authorization, function,

Reason and Prerequisites

You carried out the modifications according to Note 353518.

Solution

Implement the attached corrections. Consider that the corrections only correct the symptoms if you implemented the modifications according to Note 353518. Otherwhise, consider the related notes.

Hope this’ll give you idea!!

<b>P.S award the points.</b>

Good luck

Thanks

Saquib Khan

"Some are wise and some are otherwise"

[Former Member]

Make sure the user doesn't use 'NE' or (E)xclude or 'BT' for the select option for output types. The selection will be quickest when checking for equality against single values. Ranges should also be fairly quick.

See if you can get all of the individual output types in a file and upload it into the select-option.

Rob

[Former Member]

I tried..... no use.

Thank You,

Ravi