M_SYSTEM_LIMITS view provides the system capabilities. For example MAXIMUM_NUMBER_OF_JOIN_TABLES_IN_STATEMENT, this setting is for Number of joined tables in an SQL statement or view and the default is 255.Is there any way to change this default valu...

All,I have a situation where I want to join two tables say Customer and Genders. a) Customer Left Join with Genders ( Get all Customers if no Gender exist in Genders table)b) Customer INNER JOIN with Genders ( Get Customers whose Gender matching in G...

I am trying to generate PDF content using XSJS. Following is the code. THe PDF is generating but when I try to ope, it says failed to load the file. When I try it on IE, it says its corrupted. Pl. suggest what I am missing in this code.try {    //$.r...

I have enabled change recording using Hana ALM. I have the following sys. priveleges and however I am unable to delete a change as its disabled. I can do the rest like creating a change, approving a change, add a contributor, etc...I have most of lm ...

I have a type declared in CDS like:   type AuditT {         CreatedBy : sMedDesc;        CreatedDt : UTCDateTime;        UpdatedBy : sMedDesc;        UpdatedDt : UTCDateTime;   };I want to set default date to CreatedDt as current datetime so that whe...