Best Practice SAP connection

[Former Member]

Hello All

I am just starting creating reports with CR2008 connected to SAP ECC 6.0. I am suffering some performance issues when trying to create a report on tables VBAK, VBAP and LIPS. Report performance is extremely slow. I have a few questions on this:

1. Can anyone point me to some documentation that would help me set up SAP and CR2008 for improved performance when reporting directly on tables.

2. Performance wise Is it better to report on an Classic Infoset rather than directly on a table in CR2008

Any other tips would be greatly appreciated.

Thanks

Phillip

[Former Member · Accepted solution]

Hello Philip,

we are currently having the performance problem too. The situation is that we have a join between record from BW and R/3 table in Crystal Report. And after analyzing, we notice that there is more or less 4 seconds being spend to retrieve one entry from R/3 table. The record from R/3 table contain a LCHR field with 32000 characters. The reason why we did this join because BW can't contain data with 32000 characters.

Do you have any solution or workaround already from SAP regarding the slow performance?? I really appreciate your help.

Kind Regards,

Erick Prajogo

[IngoH · Accepted solution]

Hi Erik,

what kind of data source are you using from the ERP system ?

thanks

Ingo

[IngoH]

Hi,

could you provide some more details on the data volumes and the type of linkage you created ?

thanks

Ingo

[Former Member]

Hello

The links within CR2008 are as follows:

VBAK (VBELN) -> VBAP (VBELN)

VBAP (VBELN & POSNR) Full Outer Join -> LIPS (VGBEL & VGPOS)

LIPS (VBELN) -> LIKP (VBELN)

The tables are small 37000 lines.

Performance Timing

-

---

Open Document: 0 ms

Run the Database Query: 201834 ms

Read Database Records: 899 ms

Format First Page: 206589 ms

Number of pages formatted: 1

Average time to format a page: 206589 ms

Number of Charts formatted: 1

Time to format all charts: 0 ms

When running the same report via a classic infoset perfomance is as follows:

Open Document: 0 ms

Run the Database Query: 27135 ms

Read Database Records: 462 ms

Format First Page: 29507 ms

Number of pages formatted: 1

Average time to format a page: 29507 ms

Number of Charts formatted: 1

Time to format all charts: 0 ms

I hope this sheds more light on the topic

Phillip

[IngoH]

Hi,

so which part are you worried about ? the data retrieval or the "format first page" ?

ingo

[Former Member]

I am most interested in the speed of data retrieval.

Phillip

[IngoH]

which is pretty much the same between the Infoset and the table access.

ingo

[Former Member]

Is there anything to improve the speed of Run the Database Query as this is 10 times slower than on an infoset.

Phillip

[IngoH]

ok - and you are using the same linking and you are using the exact same fields ?

Ingo

[Former Member]

Yes everything is the same, linking fields etc. I just made a Straight copy.

Thanks for your help

Phillip

[IngoH]

Hi,

so you configured the same linking in CR like you did in the Infoset ?

Could you run a RFC Trace to see the details ?

ingo

[Former Member]

Hello Ingo

Thanks for your help. Here is the RFC Trace as requested. Please let me know if you need any more details.

Phillip

Transaction ? Work process no 0 Proc. Type DIA Client 400 User P.LAYCOCKTransGUID 60F595DE7442F10AB937000C29E5C1BC Date 31.08.2009

Duration Obj. name Op. Recs. RC Statement

0 ? Client 2 0 cham-vm1_CV1_00 ? Client ? 0 0

9.035.613 notebook_  Client 4 0 cham-vm1_CV1_00 notebook_pl Client 26962E745D0B79D65F2G 774.114 430

0 ? 5 0 cham-vm1_CV1_00 ? /CRYSTAL/OSQL_EXECUTE_INTERNAL 0 12.166

Edited by: P. Laycock on Aug 31, 2009 9:47 AM

[Former Member]

RFC Statement

Function module name

Source IP Address 192.168.3.220

Source Server cham-vm1_CV1_00

Destination IP Address

Destination Server

Client/Server Client

Conversation ID

RFC Trace Rec. Status 2

Sent Bytes 0

Received Bytes 0

Total Sent Bytes

Total Received Bytes

ABAP program name %_T002S0

RFC Time 0

Function module name /CRYSTAL/OSQL_EXECUTE_INTERNAL

Source IP Address

Source Server cham-vm1_CV1_00

Destination IP Address 192.168.3.220

Destination Server

Client/Server

Conversation ID

RFC Trace Rec. Status 5

Sent Bytes 0

Received Bytes 12.166

Total Sent Bytes

Total Received Bytes

ABAP program name

RFC Time 364328.935

[Former Member]

Function module name 26962E745D0B79D65F2G

Source IP Address 192.168.3.220

Source Server cham-vm1_CV1_00

Destination IP Address 192.168.4.25

Destination Server notebook_pl

Client/Server Client

Conversation ID

RFC Trace Rec. Status 4

Sent Bytes 774.114

Received Bytes 430

Total Sent Bytes

Total Received Bytes

ABAP program name %_T002S0

RFC Time 9.035.638

[IngoH]

Hi,

doesn't help very much here. Would suggest you open a case with Support so that they can take a look directly in the system.

ingo

[Former Member]

Will do thanks for your help anyway much appreciated.

Phillip

[former_member192142]

Hi,

Do you by any chance have the required data loaded into BW? If so, I highly recommend that you create your Crystal Report against your BW system instead of ECC. The tables you are trying to create your report on can potentially contain large amount of data (SD linie items). Your ECC system is not intended/designed for retreiving data, but for entering data. BW on the other hand is designded specifically for it.

Hth.,

Jacob

[Former Member]

Thanks Jacob

The work I am doing is for a small company using SAP All in One that does not have BW. I agree with the recomendation to report if possible through BW, but BW does come with a price tag and a development time that not all companies can afford to take on. CR2008 is then a useful and cost effective alternative for these companies, so in my situation I really just need to know what the best method is for linking to SAP via the tables or via an classic info set (or other alternatives if this is better.)

Thanks Jacob for your input it is much appreciated.

Phillip

[former_member11696]

moving to SAP integration kits forum

[Former Member]

Hello , Could you please let me know how both the system talking to each other.

Are you using SAp Integration Kit ?

[Former Member]

Yes the connection is made via the SAP integration kit. Further technical details I am not sure of. If you need more information please let me know I will then approach our Basis consultant. Thanks for your help.

Phillip

Edited by: P. Laycock on Aug 20, 2009 9:28 AM