Skip to Content
avatar image
Former Member

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

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.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Nov 20, 2017 at 12:24 PM

    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

    Add comment
    10|10000 characters needed characters exceeded