Skip to Content
0

Is there any Performance issue with (Select * From Table) in S/4 HANA 1610??

Nov 20, 2017 at 11:50 AM

50

avatar image
Former Member

We developed one report in ECC 6.0 which having multiple queries With (select * from Table) and same report given to one of the client and the client server got UPGRADED to S/4 HANA 1610.

Post the up gradation we run the Code In-specter in Client S/4 HANA environment, which given the error for all Select * statements.

Is there any Performance issue with (Select * From Table) in S/4 HANA 1610.

currently i don't have the S/4 HANA Server to check every thing so kindly suggest on the above query that will helpful to me.

i will tel you one example query for your refernce.

SELECT * FROM BKPF INTO TABLE G_TAB_BKPF WHERE BUKRS = P_BUKRS
AND BELNR IN S_VBLNR
AND GJAHR = P_GJAHR.

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Frank Schuler
Nov 20, 2017 at 12:24 PM
0

Hello Satyanarayana,

Yes, there is a performance issue with SELECT * when retrieving data from columnar storage, because each row has to be reconstructed and therefore such statements have to be avoided. Fortunately, this is very easy. Just only select the columns that are in fact used in the subsequent code.

Best regards

Frank

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hi Frank,

Thanks for your Reply.

i can Accept your answer, but the problem is we have lot of select * queries followed by lot of read statements to the standard structures(like BKPF,BSAK,LFA1 etc). so as per the above reply, first i need to create the all custom structures/types for each table then i need to use the custom structures/types in the program.

But in my program nearly 100's of Select statements and more than 100 of read statements are there for max all FI Related tables like BKPF,BSEG,BSAK,BSIK,BSIS, etc and vendor master,customer master and GL master, bank master tables as well.

To modify all the above "Select *" queries with "select columns" queries will take long time. if any alternate solution/suggestion will help us because client is already in live and don't have that much time.

For your information yesterday (i.e 20.11.2017) i tested my program in client S/4 HANA Test server (Created test server with PRD backup) which is working fine and we did not notice that much of delay.

NOTE: Currently we don't have S/4 HANA server to test or to do R&D, except client server. so kindly give some suggestions on this that will help me to complete required changes ASAP.

Thanks & Regards,

Satya.

0

Hello Satyanarayana,

There are quite a few helpful links in the answers to this question:

Custom code Migration to SAP S4 HANA System

Best regards

Frank

0