This is possible as all views can be created as persistent in SAP HANA. You need to get XMS representation creating attributeview, .analyticview, .calculationview file and activate it.In your case I think you need to check details of your Analytic view and if there is some path that you need ... Read More

You need to pass browser identification string otherwise Web Dynpro application won’t take browser and will show an error message as mentioned by you.You can refer below link for more details:Apple NSURL Link

You can perform varchar casting using following query:SELECT TO_ALPHANUM(col) FROM ......

This can be performed using Change and Transport system CTS. CTS can be used to move ABAP objects, Java objects in your SAP system landscape.Transport management is one of the key components in SAP system landscape and is used to perform the following activities −Defining Transport Domain Controller.Configuring the SAP ... Read More

Instead of using StandardListitem, you should use CustomListitem. With use of CustomListitem, you can add any kind of content.As per SAP documentation, CustomListitem has following use:This control with a content aggregation can be used to customize standard list items that SAP doesn't provide. List mode and ListItem type are applied ... Read More

You need to login to XM interface and there is different BAPI’s that you can use to read CCMS data.Function Module:BAPI_SYSTEM_ALERT_ACKNOWLEDGEBAPI_SYSTEM_ALERT_GETDETAILSBAPI_SYSTEM_MON_GETLISTBAPI_SYSTEM_MON_GETTEMPLATEBAPI_SYSTEM_MON_GETTREE You can refer this documentation to know more about Function Modules:SAP XM Interface Read More

As per my understanding, CUID is a 35 characters and normally starts with A, B, C, F, K and M. To know formatting of different ID types, you can refer to this:SAP Note: 1285103: What are the different types of IDs used in the BusinessObjects Enterprise repository?CUID: CUIDs are Globally ... Read More

Note that you can’t access Pooled tables directly and it should be accessed via Application server. When a pooled table is created, it involves creation of a suitable transparent table with a suitable delivery class and then it is changed to a pooled table.A pooled table can be flagged as ... Read More

BELNR is not required however it is useful. Let us say a customer place an order and as he is not sure he place the order again. Now there are 2 orders you are not sure if there are two IDocs for same order.With BELNR, it has order number of ... Read More

As per my knowledge, SAP PI Messaging Server 7.4 AEX is compatible with JMS 1.02 and JMS 1.1. Using Java Messaging Service, you can connect messaging systems to the Integration Engine.You can refer to SAP Note: 856346 - J2EE JMS AdapterThis note says common FAQ’s about JMS and I have ... Read More

Note that when you perform an insertion using an ABAP program, there is no check on foreign key constraint.  Even when you define checks in data dictionary SE11 still there is no check at database level.When you execute using an ABAP code, this checks consistency at application level and not ... Read More

Note that IN statement in SQL doesn’t accept a wild character. You have to use OR/AND to make it work as mentioned below:select *from Test1 t INNER JOIN Test2 s ON t.ID = s.RIDwhere t.sdate >= ?1AND t.edate <= ?2AND t.id LIKE ?3AND ('%' = ?4 OR t.afdeling IN (?4))AND ... Read More

I thought it can be done using a script in SM69 T-code defined as a call to sh with parameters of -c 'cd <dir> && /path/to/command.However it doesn’t accept wildcards and && is converted to & and script is not working. As per SAP Note 401095 - Wildcards in external ... Read More

In Business Objects 4.1, this can be done by following below steps in Universe:Navigate to Parameters and LOVNext is to go Edit SQL option -> write query with order by to get the order.

As per my knowledge, Oracle Bus Service has a SAP adapter that you can use to get data via queries. With 10.3.1 release of the Oracle Service Bus, you have the following adapters for use within Oracle Service Bus:Oracle AQDatabaseOracle ApplicationsSAPJ.D. Ewards OneWorldSiebelPeopleSoftYou can refer to this link to know ... Read More