The basic principle for performance is that there should be minimal data transferred between application server and database.For your first question, I would suggest to select only the fields that are required. So, don’t use SELECT * in case you don’t require all the fields. But in specific scenarios, if you have multiple SELECT statements at various parts of your program querying the same table but different columns, it is advisable to use SELECT * as the output is stored in a buffer till your program execute. In that case, when you come to subsequent select, the system uses the ... Read More

The Y-namespace is meant to be used for centrally developed solutions or also known as head office while the Z-namespace is used for local developed solutions or also known as branch office. But at the end of day, it all depends on the developer how he uses it.

You can find the current client in sy-mandt.ExampleHere is the code you can write for same.IF sy-mandt = ‘001’. *do A. ELSE. *Do B. ENDIF.

you can use a READ statement in combination with TRANSPORTING NO FIELDS. This will skip the values to be transferred to the work area and avoid the loop. Here is an example:READ TABLE itab WITH KEY FIELD = 'ABC' TRANSPORTING NO FIELDS. IF SY-SUBRC = 0. "Field Match.” ENDIF.

I think there is a syntax problem in your code. The colon in the first statement adds multiple following statements and hence updating all records in the first statement.Remove the colon in the first line and comma between SET specifiers.ExampleTry using the following statement after update:UPDATE zemployee_jat    SET prijs = zemployee_jat-prijs       naam = zemployee_jat-naam WHERE employeeid = zemployee_jat-motorid.

You can fix this issue by adding Global before all calls giving the error. This has happened cos of system namespace in BAPI and Windows.ExampleAnother possible solution of this is by adding an alias for System.XML and change System.XML with SysXml as below:using SysXml = System.Xml; /// [System.Xml.Serialization.XmlElementAttribute(Form=SysXml.Schema.XmlSchemaForm.Unqualified)] public string Type {    get {       return this.typeField;       set {          this.typeField = value;       }    } }

As per my understanding of your question, the better option for you will be to code the selection in ABAP. Then you can wrap this selection in a function module which will be remote function call enabled. Then go ahead and use this module.But let’s say you are not able to use it, then only remaining option for you will be ‘RFC_READ_TABLE’ but it has got its own problems.

I am wondering why you are planning to opt for SSIS for this. It would not be that easy and compatible. Instead, I will suggest you to for any of the below two optionsUse SAP BW standard anyDB source systemBO Data servicesBoth of the options are well compatible and do the data load well and in a native manner.

To get the server name of SAP HANA server, you need to check the virtual machine (VM) list.You can find this list under Virtual machine details of your corresponding HANA SPS5 server’s External Address property.Usually, the port number is 30015.For the problem that you are facing regarding the connection set up, you can refer below link for more details.https://blogs.sap.com/2013/06/17/connecting-to-your-hana-database-from-php-using-odbc/

I think you knew the answer beforehand as you already mentioned it in your question. You need to set an SAP user for every user to work the SAP prescribed way otherwise you are violating the service agreement of SAP and hence support will be void.