
Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Found 1039 Articles for SAP

269 Views
In SAP HANA, geospatial data types are not defined as such and you need to use scalar values like a.ST_X().You can create a table like this −CREATE COLUMN TABLE MYSCHEMA.SpatialShapes_GEOMETRIES ( ShapeID integer, SHAPE1 ST_Point, SHAPE2 ST_GEOMETRY );SAP provides a complete guide to handle Geospatial data in applications. You can refer this link for more details:https://help.sap.com/doc/PRODUCTION/9db42d044f8e415180d4a4475873b50a/2.0.00/en-US/SAP_HANA_Spatial_Reference_en.pdf

407 Views
In SAP HANA, you don’t have a concept of creating multiple databases in one container. To create a separate container for your database objects, you can create the schema in HANA db.To create a schema, you can use below SQL query −CREATE SCHEMA schema nameYou can also define as owner name while defining a schema.CREATE SCHEMA [OWNED BY ]If it is not defined, the system takes the current user as the owner of the schema.

127 Views
Many companies have an on-premise solution that contains master data, customer and product information, and pricing data. Details from SAP ECC system is required when opportunities are won and the sales order is generated.Following are the key reasons why an integration is required with SAP ERP and CRM system −To provide an organization level solution for all sales, marketing and service activities including all subsidiaries, sales offices.Many companies prefer as SAP Cloud solution for customer user experience that helps sales representatives to provide outstanding customer experience and SAP CRM as back-end system to support key activities.An organization wants to extend ... Read More

1K+ Views
An open document URL is constructed as follow −http://:/OpenDocument/opendoc/?&&...&With use of SAP Business Objects API, you can query each prompt- single value or multiple value. When you build URL, you may have to include parameter types.You can join parameters with the ampersand (&) and you shouldn’t use space with & ampersand. Example − sType=wid&sDocName=Sales2003https://URL_path/BOE/OpenDocument/opendoc/openDocument.jsp?sIDType=CUID&sType=wid&sRefresh=Y&iDocID=AUcrjvCCPOVHtSvXJV9Qs0k&lsMYBO_BU=B;B&lsSYBO_CALYEAR=201710&lsSYBO_CRNCY=USDIn this URL, you can see single value variable YBO_CALYEAR and value is passed in YYYYMM format&lsSYBO_CRNCY=USD, you can see single value variable and I am passing value “USD”When you run the report, you can define a report level variable or use report-level function to capture multiple ... Read More

9K+ Views
To check if a user has authorization for T-code or not you can use Transaction SUIM. You can manage user permissions using different ways like profile assignment via a single role, collective roles that contain single roles, etc. Below shows SUIM transaction that opens User Information System as below:You can also join tables: AGR_USERS and AGR_1251AGR_USERS is a standard SAP Table which is used to store Assignment of roles to user information. This is available within R/3 SAP systems depending on the version and release level.AGR_1251 is a standard SAP Table which is used to store Authorization data for the activity ... Read More