New age ALV on HANA. IDA used us to achieve pagination in ALV i.e load records as per window size in chunks thereby improving the performance.
Association is conceptually Adhoc join or Join on demand. It helps us to achieve better performance and better navigation. Very useful from Fiori apps perspective.
Pooled tables schema can have tables in different places.
Clustered schema has tables together.
Clustered schema has tables together.
Status 51(document not posted), 53(posted sucessfully),02(Failed to transfer data to port),03(Data transfer to port OK),41(Application document generated in the target system)
It is a combination of multiple Elementary search helps
Host variable(data from the application server) also know as Escape variable is used in new age Open SQL for inline declaration. It imposes strict code check while doing syntax check in the editor.
Code pushdown is concept to push the data intensive logic to DB level. CDS, AMDP can be used to achieve this.
"Use of Order BY cluase while selecting data from tables.
Use of Inline declaration.
Use of Inner join on tables compared to For all entries. Use of data calculation related functions while selecting the data to reduce further roundtrip from DB.
All cluster and some pooled tables are converted to transparent tables in HANA. Hence queries on Cluster/pooled tables returns results sorted by primary keys is no more true here. Any custom coding which accesses physical table cluster/pool has to be changed so that the program reads from tables directly"
Use of Inline declaration.
Use of Inner join on tables compared to For all entries. Use of data calculation related functions while selecting the data to reduce further roundtrip from DB.
All cluster and some pooled tables are converted to transparent tables in HANA. Hence queries on Cluster/pooled tables returns results sorted by primary keys is no more true here. Any custom coding which accesses physical table cluster/pool has to be changed so that the program reads from tables directly"
Shared Lock - Multiple users can access data in display mode. New change mode requests will be rejected is an object is SHARED LOCK
Exclusive Locks - Restrict other users to put any kind of lock on the same object
Exclusive but not cumulative lock - It is same as Exclusive lock except the fact that even the lock requests from the same transaction will also be rejected
Exclusive Locks - Restrict other users to put any kind of lock on the same object
Exclusive but not cumulative lock - It is same as Exclusive lock except the fact that even the lock requests from the same transaction will also be rejected
There might not be any need of indexes and secondary indexes in S/4 HANA as the whole table fields act like the index. But standard sap tables are delivered with indexes and we can define and use secondary indexes as well.