Friday, 29 September 2017

Some useful SAP abbreviations


Some use full SAP abbreviations 

AAS   
Additional Application Server
ACC  
Adaptive Computing Controller
ALE 
Application Link Enabling
ALM 
Alert Management
ByD 
Business by Design
CCMS
Computing Center Management Systems
CPH 
Central Performance History
CTS 
Change and Transport System
CUA
Central User Administration
E2E 
End-toEnd
eCATT
extended Computer Aided Test Tool
EWA 
EarlyWatch Alert
GRC 
Governance Risk and Compliance
GRMG 
Generic Request and Message Generator
GSPS 
Global Security and Positioning System
HANA 
High-Performance Analytic Appliance
ICE 
In-Memory Computing Engine
ICM 
Internet Communication Manager
IGS 
Internet Graphics Service
ITS 
Internet Transaction Server
LVM 
Landscape Virtualization Management
MCOD 
Multiple Components in One Database
MDMP
Multi Display Multi Processing
MTE 
Monitoring Tree Element
PAL 
Printing Assistant for Landscapes
PAS 
Primary Application Server
RFC 
Remote Function Call
SAP
Systems,Applications,Products in data processing
SCM 
Supply, Chain and Management
SCS 
SAP Central Services
SMO 
Solution Manager Optimization Services
SNC 
Secure Network Communication
SOA 
Service-Oriented Architecture
SSM 
SAP Strategy Management
SUM 
Software Update Manager Tool
TDMS
Test Data Migration Server
UME 
User Management Engine


Thursday, 28 September 2017

How to find all the table in SAP


How to find the list of all the tables in SAP:

Goto Tcode --> SE16 and enter.

Table Name      Description

D010TAB       All SAP Table with Report Name
DD02L           All SAP tables
DD02T          All SAP table texts

Example :

Enter the  D010TAB select Number of Entries.






Wednesday, 27 September 2017

How to configure Early Watch Alert (EWA) in SAP Solution manager

Tags



How to configure Early Watch Alert (EWA) report in solution manager.

                To configure EWA some specific settings to be done at managing system (Solution system) and satellite system or managed the system  for which EWA report to be generated Following are the steps to configure EWA in a satellite system

  • Check whether latest versions of ST-A, ST-PI, ST-A/PI packages are installed in the Managed System and Satellite System


  • If they are installed, execute Report  RTCCTOOL in Tcode SE38 from the satellite system.

          Check the output of the report. If there are some errors or warnings in the output of the report.

  • Setup RFC connection between your satellite system and the SOLMAN System

             An RFC connection can be made between 2 systems using Tcode SM59

  • Setup RFC connection between your solution manager and the SAP service market place


  •  Assign the solution monitoring roles to the users, Setup your satellite system in a solution landscape of the solution manager(SMSY)


  • Make sure SLD is configured and working fine for satellite system (using Rz70 and SLDCHECK Tcode)


  • Activation of SDCCN in satellite system then confirm for SDCC_OSS destination creation


  •   In the satellite system, goto SDCCN tcode and navigate to Goto -> Settings -> Task-specific.

           In the resulted screen, select RFC destination and provide the solution manager RFC from
           The satellite system and set solution manager RFC as the master system.

  •  Addition of satellite system in solution manager system in SDCCN :


         Click on add system button to add the new SDCC to the solution manager. When prompted,                please select the respective system and client from the resulting screen and confirm

  •  Early watch service session activation for satellite system:

           In the solution manager system, execute transaction code solution_manager  and navigate to operations -> Earlywatch Alert and press create button. This prompts you to confirm the date and time to run the report. Please provide the details and confirm to trigger the generation of                the report

  • Login to the satellite system, go to transaction code SDCCN and press create a button which displays a screen to select a task to be executed. Select request session data task and click continue. You will be prompted to enter the scheduled time to run the report. Click now to execute it immediately. After that, you can see an early watch session running in SDCCN.


  •  After completion of this session run successfully, an Earlywatch Alert will be generated and this can be viewed in Solution_manager of Solution manager system.



Tuesday, 26 September 2017

How to Configuration ADS in Netweaver 7.5

As ADS are running on an AS Java  Stack and form processing is performed in an ABAP Stack environment, we have to configure the communication between the Form Processing Framework running on AS ABAP and the ADS running on Java.

Note: More details refer SAP Note 925741

AS ABAP side  configuration:

Log on to the ABAP system, call transaction SM59, and select ‘ADS’ from ‘HTTP connection to ext. server’.

Specify the server name and HTTP port number of the additional stand-alone AS Java.
You also need to update the corresponding user and password information on the ‘Logon/Security’ tab.

Make sure that create the user ADS_AGENT with the
corresponding role SAP_BC_FP_ICF and SAP_BC_FPADS_ICF exist in AS ABAP. If this
user does not exist, create it according to the steps in ADS Configuration
Guide.

Note:
When you do connection test for ADS destination RFC in SM59 the result can be “HTTP
response: (405) Method not allowed”. Error is normal.

Execute Tcode  SICF.

Choose default_host →  sap  → bc →  fp in the tree.
Choose Service/Virt.Host  →  Activate.

If AS ABAP and AS Java (with ADS) are installed in different systems, and you want to bundle your forms to
     improve performance, you also have to activate the fpads ICFservice.


AS Java configuration:       

Log on to the NetWeaver Administrator of your additional standalone AS Java.
Select Server ; Service destination HTTP.
Create an entry ‘FP_ICF_DATA_XX’,   where is the ABAP backend System ID.
Enter the ABAP HTTP port (http://:) in the ‘URL’ field.
Enter the user ‘ADS_AGENT’ in the Username field, and the corresponding password of ABAP backend system.

Save your entries.

Note: When
you do ping test for the destination the result can be “Error 404: Not found”.
This is normal.

As Java configuration for WebDynpro Application:

1.    Log on to the NetWeaver Administrator of your additional standalone AS Java.

2.    Select SOA Management  and  Technical Configuration Destination Template

3.    Management

4.    Select’Create Destination’ and Enter following entry:

5.    Destination Type: WSIL

6.    Destination Name: ConfigPort_Document

7.    URL:http://:/inspection.wsil

8.    SecurityTab

9.    Select Authentication ‘HTTP Authentication’ and ‘User ID/Password (Basic)’

10.  Select ‘Details’ and enter the user ADSUser and the corresponding password.

11.  Select ‘Save'

Testing ADS Configuration:

·       Checking ADS Configuration in an ABAP Environment

1.  Log on to the AS ABAP system.

2.  Start the transaction SA38.

3.  Enter the program name FP_TEST_00.

4.  Choose Program and Execute it.
.

5.  Make sure, that the following default values are entered in the respective fields:

o  Form: FP_TEST_00

o  ADS Connection:

          ADS or the RFC Destination name specified in your system

6.  Choose Program and Execute it
.

7.  Enter the Output Device.

8.  Choose Print Preview.

9.  If the system displays a form containing several lines on two pages, the ADS configuration is       correct. Otherwise, perform the tests described below.


·       Checking the ABAP Connection to ADS

  1. Log on to your SAP system.
  2. Start the transaction SA38.
  3. Enter the name of the test report FP_PDF_TEST_00.
  4. Enter the name of the connection. Enter the default name ADS, or, if you have specified another name, the one you are using in your system.
  5. Choose Execute (F8).
  6. If the configuration is correct, the system displays the version number of the Adobe Document Services.

        ·       Checking the Destination Service and the ICF Service

  1. Log on to your SAP NetWeaver AS ABAP system.
  2. Call transaction SA38.
  3. Enter the name of the test report
  4. FP_CHECK_DESTINATION_SERVICE.
  5. Execute the test without choosing the option With
  6. Destination Service.
  7. The system renders a test form in the background
  8. without using the destination service and displays the size of the created PDF.
  9. Execute the test again. Now select the option With
  10. Destination Service.
  11. If the settings of the destination service are
  12. correct, the system displays the same message as before (see step 5).


Monday, 25 September 2017

what is Core Data Services CDS in SAP S/4 HANA

Tags

Core Data Services  in SAP S/4 HANA

                A data model represents the framework of what relationships are in a database. Data models are the foundation of software development. They provide a standardized method for defining and formatting database contents consistently across systems, enabling different applications to share the same data.

Professional data modeling tools provide a way to generate SQL from a modeled ER diagram although some developers often prefer writing SQL directly. Below is a look of a data model.

Virtual Data Model
             The concept of the Virtual Data Model (VDM) was introduced with HANA Live three years ago. SAP HANA Live is a Virtual data model on top of suite tables which uses native SAP HANA SQL views called Calculation views for real-time operational Reporting. This came with certain issues:

  • This model didn’t support hierarchies properly. Hierarchies help businesses to analyze their data in a tree structure through different layers with drill-down capability. For example, a time hierarchy consists comprises of levels such as fiscal year, fiscal quarter, fiscal month and so on
  • Since the HANA Live virtual data models were defined in the HANA database layer itself as HANA calculation views it led to duplication of security roles between Business Suite for transactional processing and HANA database for operational reporting.


                  With S/4HANA, SAP launched S/4HANA Analytics as an upgrade to HANA Live. S/4HANA supports a new data model by providing a ready-to-use content using CDS view. The CDS data model used by SAP S/4HANA can be considered a successor to the virtual data model used by SAP HANA Live as the new CDS provides certain advantages over VDM which are discussed later in this blog.

 As for our customers, which are the current users of HANA Live nothing changes unless they migrate to S/4 HANA. The existing virtual data models will continue to be supported by SAP. Once customers migrate to S/4HANA, the new CDS-based views can be used and upgraded against the simplified data model in S/4HANA.

Core Data Services

        With the availability of the SAP HANA platform, there has been a paradigm shift in the way business applications are developed at SAP. The rule-of-thumb is: Do as much as you can in the database to get the best performance.

To take advantage of SAP HANA for application development, SAP introduced a new data modeling infrastructure known as core data services. With CDS, data models are defined and consumed on the database rather than on the application server. CDS also offers capabilities beyond the traditional data modeling tools, including support for conceptual modeling and relationship definitions, built-in functions, and extensions

Technically, CDS is an enhancement of SQL which provides a Data Definition Language (DDL) for defining semantically rich database tables/views (CDS entities) and user-defined types in the database. Some .of the enhancements are:

  • Expressions used for calculations and queries in the data model
  • Associations on a conceptual level, replacing joins with simple path expressions in queries
  • Annotations to enrich the data models with additional (domain specific) metadata

CDS Value Proposition for Customers

               CDS offers a SQL based layer that extends the SQL-92 standard with features that bridge and unify the traditional OLTP and OLAP models of data definition, data query, and data manipulation. Supported natively in both ABAP and SAP HANA, the data models are expressed in data definition language (DDL) and are defined as CDS views, which can be used in ABAP programs via Open SQL statements to enable access to the database. CDS provides a range of advantages for businesses and developers, including:

Semantically rich data models
            CDS builds on the well-known entity-relationship model and is declarative in nature, very close to conceptual thinking.

Compatibility across any database platform
             CDS is generated into managed Open SQL views and is natively integrated into the SAP HANA layer. These views based on Open SQL are supported by all major database vendors

Efficiency
            CDS offers a variety of highly efficient built-in functions — such as SQL operators, aggregations, and expressions for creating views.

Support for annotations.
            The CDS syntax supports domain-specific annotations that can be easily evaluated by other components, such as the UI, analytics, and OData services.

Support for conceptual associations
            CDS helps you define associations that serve as relationships between different views. Path expressions can be used to navigate along relations. Introducing an abstraction of foreign key relationships and joins, associations make navigation between entities consumable

Extensibility.
       Customers can extend SAP-defined CDS views with fields that will be automatically added to the CDS view along with its usage hierarchy.

VDM to CDS Migration
           In order to ensure a smooth migration from HANA Live VDM Model to S/4 HANA VDM CDS Model, SAP provides a migration roadmap tailored for the Customer businesses. In the past, a lot of effort was spent to define and implement the HANA Live Virtual Data Model based on HANA Calculation Views. This is used as a starting point for the definition and implementation of the CDS Data Model. CDS views are generated for the Calculation views. Please note, after the generation additional effort is necessary to adapt the generated views to the new approach (CDS). Typical tasks which might be necessary are:

  • Adding needed CDS annotations for analytical or other scenarios. Annotations allow enhancing the core Metamodel with consumer-specific vocabularies.
  • Restructuring or renaming the views to support the higher level of reuse which shall be reached with the new approach (Using naming convention like I view for public view, P for Private and C for Consumption views).
  • Adapting the views that as part of the original functionality could not be migrated due to missing or different features in CDS. 
  • Adapting the views to changed view behavior (if on running the view, a different result for the views is displayed).








Sunday, 24 September 2017

Types Schema in SAP HANA database

Tags

A database schema is a way to logically group objects such as tables, views, stored procedures etc. Also schema as a container of objects. 

Types of Schemas :

1.User Defined Schema
2.System Defined Schema
3.SLT Derived Schema

User Defined Schema:  

These are created by user (HANA DBA or System Administrator

SLT Derived Schema:  

When SLT is configured, it creates the schema in SAP HANA system. All the tables replicated into SAP HANA system are contained in this schema 
System Defined Schema:
These schemes are delivered with the SAP HANA database and contain HANA system information. There are system schemas like _SYS_BIC, _SYS_BI, _SYS_REPO, _SYS_STATISTICS etc. 



Saturday, 23 September 2017

How to check history views in SAP hana database

Tags

SAP HANA database history views are very useful for checking the detail about the database.

When SAP HANA database is not restarted after the performance downgrade, the "System Information" views can be checked further. If the performance issue is resolved without a database restart, then it indicates that the database was not in a hang situation, but the database performance was temporarily decreased.

If HANA database has been restarted after a hang situation, the history of database status can be found in "_SYS_STATISTICS" SAP HANA schema:

  • HOST_LONG_RUNNING_STATEMENTS
  • HOST_LONG_SERIALIZABLE_TRANSACTION
  • HOST_LONG_IDLE_CURSOR

  • HOST_UNCOMMITTED_WRITE_TRANSACTION
  • HOST_MEMORY_STATISTICS
  • HOST_RESOURCE_UTILIZATION_STATISTICS

  • HOST_SAVEPOINTS
  • HOST_MVCC_OVERVIEW 
  • HOST_VOLUME_IO_PERFORMANCE_STATISTICS


Friday, 22 September 2017

how to check Memory Usage in SAP HANA DATABASE

Tags

How to check Memory Usage detail in hHANA database using SQL query.

1- How to find out the top 100 memory usage in SAP HANA database between a specified time.

select top 100 round(TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as
"Used Memory GB", HOST, SERVER_TIMESTAMP  from _SYS_STATISTICS.HOST_SERVICE_MEMORY where SERVER_TIMESTAMP between '11.02.2017 02:00:00' and '19.06.2017 19:00:00' order by TOTAL_MEMORY_USED_SIZE desc

2- How to check the peak memory usage.

select top 1 HOST, SERVER_TIMESTAMP, round(TOTAL_MEMORY_USED_SIZE/1024/1024/1024, 2) as "Used Memory GB" from _SYS_STATISTICS.HOST_SERVICE_MEMORY where SERVICE_NAME = 'indexserver'
order by TOTAL_MEMORY_USED_SIZE desc

3- How to find the schema name, current memory usage, max memory usage (if all tables and all their columns were loaded into memory simultaneously) and record count in each schema .

select schema_name, round(sum(memory_size_in_total/1024/1024/1024),1) as "Current MEM GB", 
round(sum(estimated_max_memory_size_in_total/1024/1024/1024),1) as "MAX MEM GB", 
sum(record_count)  from "SYS"."M_CS_TABLES"  group by schema_name  order by "Current MEM GB" desc 

4- How to get the total table count in a HANA  schema.

SELECT  count(*) "TABLE_NAME" FROM "SYS"."M_TABLES" where "SCHEMA_NAME" = 'SAPABAP1'

5- How to get the total memory usage of a HANA schema.

Column tables details 

SELECT TABLE_NAME AS "Table",sum(round(MEMORY_SIZE_IN_TOTAL/1024/1024, 2)) as "MB" FROM  M_CS_TABLES WHERE SCHEMA_NAME = 'SAPABAP1'

Row tables details.

select round(sum(USED_FIXED_PART_SIZE + USED_VARIABLE_PART_SIZE)/1024/1024) as "Row Tables MB Used" from M_RS_TABLES where "SCHEMA_NAME" = 'SAPABAP1'




Thursday, 21 September 2017

Types of License keys in SAP HANA

Tags

Types of License keys in SAP HANA :

  •  Temporary
  •  Permanent 


Temporary License Key 

  A temporary license key is installed by default when you install the HANA database. These keys are valid only for 90 days and upon expiration, the HANA system is locked down .

Permanent License Key

  SAP provides this license upon customer request, known as a permanent license. Permanent License keys are valid only till the predefined expiration date.Once expiration date period is over the license will get expired and a temporary license will be installed automatically for 28 grace period and During this period, you have to install a permanent License key again.

Two types of Permanent license keys in SAP  HANA system :
  • Unenforced 
  • Enforced 


Unenforced 

  If the unenforced license key is installed Then the system will issue a warning message upon over usages of SAP HANA licensed memory amount but it will not get locked down.

Enforced 

  This HANA license is based on the memory usage and If the Enforced license key is installed and consumption of HANA system exceeds the license amount of memory, 

Example
     If you can install a 1 TB memory HANA system but can only license it for 256 GB usage.If the system usage is increased over licensed amount then the system will be locked down.

Wednesday, 20 September 2017

Explorer does not list activated HANA Analytical Views

Tags

Symptom:

         Opening "Manage Spaces" in Explorer does not list any Analytical Views under the SAP HANA data sources, even if they are activated and working in HANA Studio.
Run the following statement in SQL editor in HANA Studio: MDX select * from bimc_cubes > no results are returned.

Reproducing the Issue:

Login to SAP BusinessObjects Explorer.
Open "Manage Spaces"
expand SAP HANA datasources > no Analytical Views are listed.

Resolution
  • Edit the properties of the Analytical View in HANA Studio and set "Multidimensional Reporting" to enabled.
  • Save and activate the Analytical View.





Tuesday, 19 September 2017

How to solve error rabax during sapgui logon


Symptom:

You can not login to the system due to following error popup:



Solution:

To solve the error, you need to figure out which short dump is happening at first, then solve it.

Following two ways can help you identify the short dump:

1. Eliminate the "rabax during sapgui logon" popup and display the dump (recommended):

  •   Set profile parameter "login/quiet_mode" to 0.
  •   Restart the system so that profile parameter changes take effect.
  •   Reproduce the issue (logon to the system).
  •   The popup "rabax during sapgui logon" should disappear now and you are able to:


       - see the dump directly.

       or

       - get more information about the short dump from corresponding dev_w* trace.

2. Increase trace level (for example "rsdisp/TRACE=2") and try to log on again. The information of the short dump is then written in the corresponding dev_w* trace.

After the dump is identified, please try solve it or create an incident under corresponding component.

SAP Note 1824283 for more details.