SAP MM Training - What it got to do with SAPS/4 HANA

 

I found this one good training in Youtube for SAP MM Training, It's quite complete and interesting and thanks to the author who prepared it. 

The video covers, The are various authors that I have included the link below which you might want to explore. For those whom want to explore SAP MM, it's never too late to start from youtube video or from SAP Help menu to get started. 

SAP Material Management topic is very intersting. Even Udemy also have some knowledge corner about SAP MM on S/4 Hana

Learn SAP MM With Functional Changes in S/4 HANA

1. Overview of Procurement

2. Procurement Process

Basic Procurement

Basic procurement is the process of acquiring goods or services in the right quantity, at the right price, and at the right time. However, it is critical to maintaining the right balance between quantity, price, and time. You can read more by clicking the link 

3. Procurement Cycle

Creating Purchase Order

Purchase order is the formal and final confirmation of the requirements that is sent to the vendor to supply material or services - You can click the procurement cycle to read more ....

As for the following you can also visit SAP help link here to understand more indepth from SAP themselves about MM Topics

4. Transfer Order

5. What is Sub Contracting Vendor

6. ESPE Navigation

7. Procure to Pay

8. Well watch the video continuously to learn more 

How to change SAP Hana Sql Output results are limited to 5000 Records

How to change SAP Hana Sql Output results are limited to 5000 Records

These are quick fixes that are often overlooked because the products come with standard configurations.

The SAP Hana SQL Output results in ECLIPSE, for example, have a limit of 5000 records.

With the following setup, you can change this number to a higher one.

Windows Tab - > Preference -> General - > Runtime - > Result -> Maximum number of rows displayed in results. 

2147483647 is usually the maximum record that can be achieved.

How to Start and Stop SAP Hana Tenant Database - Its too simple

 

How to Start and Stop SAP Hana Tenant Database - Its too simple 

The easiest way for a startup to get started with HANA and explore the administrative side of a Basis career is to use it. Start by learning the basics, for example 

- SAP Hana Studio - What is that?

- SAP Hana DBAcockpit - What is the difference between SAP Hana Studio?

- What is the use of  SAP Hana DB and where it's being used?

What we need to know right now is how to start and stop. Customer Relationship Management (CRM) SAP 

Also, get to know your surroundings

1. HANA DB Cockpit 

2. HANA Studio 

3. HDBSQL 

Please try the simplest or most direct approach. SAP Basis who have worked in Oracle administration would be able to see the parallels.

1. Login to SAP HANA Studio

2. Open SQL Console on the SID by right click

3. To Start Hana Tenant DB - Just execute 

 Alter System Start Database [ your tenant DB ]

4. To Stop Hana Tenant - Just execute 

Alter System Stop Database ( your tenant DB) 

Inactive objects in SAP - SE80 / SE11

The inactive objects in SAP sometimes cause issues if you don't have practice in housekeeping them. from the system.

This is a quick way to check inactive objects

1. Execute t-code SE80 and navigate to Repository Browser , explan the tab and and select inactive objects. 

You may decide what you plan to do with the listed objects if its required for certain cases for example : - 

1. Future use of a change development that was never executed in Production system

2. Error left unattended without cleaning up by poor development work

3. Part of abandon objects during projects or after migrating a system where one of the pre-steps are forgetten.

4. During transport error developer forgets to correct and remove or mark in STMS unlocked objects.

Where this inactive object topic arises - 

1. During migration of SAP system

2. During upgrade actvity

3. Not required but sometimes its part of Database upgrade checklist

4. Applicable during Homogenous & Hetrogeneous system copy or refresh

5. System migration

6. Upgrade to Hana

What happens if you left it hanging and don't bother: - 

1. Potential issues arises during Upgrade when one of the phases will detect issue and cause problem.

2. Future critical transport to production during an important event get stopped, it could be that clean was only done in DEV but developer forgets to perform the clean up right up to production system.

3. During system migration, it can garbase such as invalid objects are being brought over to new system, this confuses the future owner of the system just in case issues arises,

 SAP Tables for inactive objects you may click here

There are also ABAP Report to access to these invalid objects

RSSHOW_INACTIVE_OBJECTS SAP ABAP Report - Display Inactive Objects

While exploring the above it's always good to explore SAP Note for further information by following the note 

The below is just some reference points.

2486685 - WARNING: INVALID_SAP_OBJECTS during pre_upgrade_checks.sql

How to kill SAP Hana session - It is easy to end or kill SAP Hana session - Quick Tips

How to kill SAP Hana Session

Do you know if it's simple to locate SAP HANA's IDLE connection session? If so, why do you need to do so? It's most likely because of a zombie session or a procedure where the session is no longer in use.

There's also an intriguing technique that I typically employ when dealing with such difficulties -

2092196 - SAP HANA How-To: Terminating Sessions

You may also use keywords like - SAP HANA terminate session connection disconnect cancel kill hang stuck, KBA, HAN-DB-ENG, SAP HANA DB Engines, HAN-DB, SAP HANA Database, HAN-DB-ENG, SAP HANA DB Engines, HAN-DB, SAP HANA Database, HAN-DB-ENG, SAP HANA DB Engines, HAN-DB, SAP HANA Database, The simplest approach to find out your IDLE session is to do the following: -

SELECT CONNECTION_ID, IDLE_TIME FROM M_CONNECTIONS WHERE CONNECTION_STATUS = 'IDLE' AND CONNECTION_TYPE = 'Remote'  ORDER BY IDLE_TIME DESC

Therefore once finding out the session then execute the following ALTER command to end it.

ALTER SYSTEM DISCONNECT SESSION   '{connection_id}'

These checks are necessary if any suspicious jobs, sessions, or remote calls are initiated, and the system is left orphaned.

Are you getting this error 1563748 – memory_no_more_paging dumps

You can find this common dump in ST22 the abap dump memory no more paging.

Commonly the rdisp\PG_MAXFS got to do with this dump appearing, I mean not that because of this parameter wrongly setup the dump is appearing but rather it relates directly to your filesystem where the paging file is located and its became full at the moment a program that was executed caused surge in the utilization of paging space.

You also want to directly visit SAP Note as below to gain more indepth information 

1563748 – memory_no_more_paging dumps

Please also use suggested keyword to search for your SAP memory dumps related to paging space.

PAGFIL<NR>.DAT Windows  Unix Linux ST02  rdisp/PG_MAXFS rdisp/PG_SHM  page area max usage  in memory  on disk, MEMORY, DUMP, ST22, Paging, Performance , KBA , BC-CST-MM , Memory Management , Problem

Issue – Most cases if it’s a customize program then it 50% or more relates to coding issue however within the customization of the program execution, variant selection are maybe set to * to certain field causing such issues.

 While exploring further i notice some bloggers also wrote up similar contents

In other context on a SAP standard program , which could also cause such issues similar to the above where variant selection are not filtered.

Solution ( out of the box )

1.     Fix your program if its customized one

2.     Teach the end user on proper usage of either standard or customize programs

Standard solution:

Mostly Basis are required to check ST02 buffer to find out and analyse the proper requirement of the paging space, however again that assumption can’t be blindly used as there are many aspects to consider, such as if ST02 only relates to 1 program then it’s a NO to tweak paging space but rather the program.

 

 

 

Prince 2 Agile approach on SAP enterprise projects

 It's strange that in SAP projects, SAP Activate are the content to be used in a guided way to conduct,engage into a project or execute BAU activity that are similar to a project. 

However there's always this craving where Programme Manager whom is in charge of the project managers and would always wants to report to the board or rather the PM itself would like to report to the Board / Stakeholders using Prince 2 framework, reporting structure and its methodology. Although since prince 2 carries Agile word in it, that does not differ so much on SAP Activate. But on a broader audience the world outside SAP  likes Prince 2 Agile approach and mostly merging them with SAP Activate approach. 

This also could be because the board or stakeholder might not live or use SAP, since SAP is mostly related to IT projects. However Prince 2 are applicable broadly on any non IT projects as well. that's the reason why such preference are adapted. 

Having said such , SAP Activate is always the key for running SAP projects regardless implementation, migration, BAU and others. 

In a single word SAP Activate methodology in Agile meaning flexibility to deliver your projects and not getting locked into waterfall methodology.

How to change - Enabling Virtual Background on Zoom

How to change Google Zoom Virtual background

Google Zoom using Canva background creation

In order to create a customised virtual background for your Zoom meeting, you can use the Canva tool. As a result, let's dive deeper into how you can do it below, along with potential problems and solutions.

Virtual backgrounds can be changed before, during and after sessions, meetings etc. OR they can be set up in the background image settings.

We have the option of choosing our own image or one of Zoom's defaults. If you want to look professional, this is for you. If you want to look unprofessional, this is for you as well.

Some steps to do it

To enable the Virtual Background feature for all users in the account:

1. To edit account settings, you must be logged in as an administrator on Zoom's website.
2. Click Account Management and then Account Settings in the navigation menu.
3. The Virtual Background option (under the Meeting (Advanced) section) can be found in the Meeting tab. Make sure it is turned on in the Meeting tab.
4. The toggle switch must be clicked to enable the setting. Verify the change by selecting Turn On if a verification dialogue appears.
5. By clicking the lock icon and clicking Lock, you can make this setting mandatory for all users in your account.
6. Check this box if you want to. Assign videos as background videos, then click Save to confirm the change. Your users will now have access to video background videos.
7. Check this box if you want to. Add the option for users to upload their own virtual backgrounds, then Save the change to confirm. This will allow your users to upload their own virtual backgrounds in addition to the ones already uploaded.
8. By clicking on "Manage Virtual Background", you have the option of uploading a user-friendly default background.
9. Client/app version 5.1.1 or higher is required for users to see the background images you upload on their computer or device.

Troubleshooting virtual background issues

Problems with Virtual Background can be resolved by following these troubleshooting tips:

• If the Virtual Background tab does not appear in your desktop client settings after enabling it, sign out and sign back in.
• Make sure you manually select the background colour to ensure that it's the right shade of blue. This option is only available after you have clicked on an image and selected a green screen.
• Check to see if the background is a solid colour with minimal shadows before you start your project. A uniformly lit background is also a must. It's best to use a three-point lighting setup.
• Check that the colour of your green screen does not match your shirt, hair, or eye colour before you start filming.
• As a VDI user, you may find that some plugins do not support virtual backgrounds, and less powerful thin client machines may not be able to take advantage of the feature either. Support for additional VDI platforms is in the works, and customers are encouraged to check with their sales representative for the latest information.

SAP Patch day August 2021

Insight on SAP Patch day release, applying it and some methods based on my opinion.

Normally in any organization there will be a policy governance to apply security notes supplied by SAP. Sometimes a threshold is being set to only apply CVSS level 9 and above. While other organization will apply all of it. 

You can click the CVSS below to find out the scores and why some organization set to certain standard.  --> Common Vulnerability Scoring System Version 3.0 Calculator

The last time its always difficult to match if the note is applicable, however now SAP patch day states the product version as well. That eases the entire thinking of applying patch.

Just to share  there are two ways or more in applying security notes in an easier way.

1 . Using the conventional way that is by DEV -> snote t-code and follow with the standards

2. Using solution manager 

3. It's also highlighted in your EWA  or TPO that some security notes that are required but not highlighted in SAP patch day, yet those on TPO or EWA report are mainly not for threats but more of a fix DB and SAP or OS related fix. 

But there are more towards it. What if you miss the August Patch and then review somewhere in Dec Patch day release. 

Few options as well,

1. Mostly minor kernel update will overcome almost 50 - 60% secuity patches and some support package update might populate the rest of the released security notes.

2. If you have missed security note for more than a yeear then the easy way out is by quarterly support package update, database update.

3. OR if you are lucky and if your organization practices limited CVSS level patch update for example 9 and obove then its even easier but becomes complicated as testing need to be done if the system is 24/7 and run critical operations. 

Well folks thats all - enjoy with you SAP notes and methods and ways to handle it. 

SAP Note Not Available - Very common issue

SAP Note Not Available - Very common issue

Use of SAP notes SNOTE, one to view instructions on the note and one to apply a SAP notes-provided fix.

1. In the first place, you should be aware that there are at least two ways to view SAP notes.

By entering your SID, you can access SAP OSS.

SAP note can be found by searching on Google. Assuming it's a hot sap note, I have no doubt that some blogger will screen shot the note.

Click here to download and view the SNOTES t-code

2.As soon as you apply the fix provided in the note, please try it again.

As soon as you log in to the SAP OSS development system, verify that the OSS1 screen configuration is correct for your region.

As a matter of fact, you can configure OSS1 in any of the following systems: DEV (development), QAS (quality assurance), REG (registration), and PRD (production).

If you can't find the relevant notes in SAP TPO or EWA reports, then it's possible that the note is new and you'll need to update your SAP TPO or EWA reports.

1. Drop a OSS message requesting for the note ( if available via SNOTE through DEV)

2. OR system that are intended are not relevant to the note therefore SAP note does not show in the repository ( this sometimes happens) 

3. Login to OSS website to get it.

4. Unless its an internal use only meant for SAP internal consultant or certifiied consultant.

Cheers..

SAP Hana DB restore and Progress details

SAP Hana DB restore and Progress details 

Finding out the progress of the restore and other relevant details may be of interest in SUSE Linux.

It was easy to check the status of backups in previous SAP ERP solutions, regardless of whether we were using third-party tools in the cloud or on-premise....

Your might remember commands like this  # ps -ef * backup*

and most of the time ending it is easily done if its on oracle 

&> alter database end backup; or view the backup log

Hana, on the other hand, doesn't really change much.

All you need to do is cd or change directories to the drive location and view the backup.

Backup and restore activity is recorded in a log file from beginning to end.

#cd /hana/shared/SID/HDB00/HOSTNAME/trace/DB_SID #ls -lrt *backup*  backup.log

Using SAP Activate Agile Approach for SAP Hana Implementation

Using SAP Activate Agile Approach for SAP Hana Implementation

Although it was anounced during one of the SAP SAPhire in 2015 that some or rather ASAP will be replaced with SAP Activate practise, well that's true. Many of the organization are utilizating the best approach and qualities that are coming through from the SAP Activate agile approach. 

However on the limelight that are many organization also still encompasses in waterfall methodology approach as well, that is because of the process flow which are some or rather unable to bend due to complexity and user requirement and testing purposes. 

While does SAP Activate works? To answer in broad manner yes it does, because of the ROI and reduction of cost and flexibility in implementation does make the situation much more arising to its previous competitor ASAP. 

It compromises of 3 main component atleast of what i personally always endeavor in my projects and implementation.

1. Best practises

In this segment they provide readily available scenario for SAP hana implementation

Also touching integration topics and best practices.

2. Guiided Configuration

The tools that are available for example for SAP hana implementation or integration are quite good actually. If you have chance to actually check and experience it, then you will know what I'm trying to say.

3. Methodology 

keep it simple - its all about agile in otherwords being flexible in running a project. 

Waterfall methodology requires strictly steps 1-2-3-4-5 till finihs or restart from 1st step

while agile you also have the same as waterfall steps but you can revisit or restart any steps that you want or possibly explore.

Well keep it simple on SAP activate, it is not a new rocket science to master. Just in my opinion it helps alot and eases alot of operational manners. 

Of course you can go through SAP Content sites for more information but I'm writting based on my experience on a broader perspective. 

SAP Hana Numeric Error Codes

There's no doubt that SAP Hana will be A large number of numeric error codes, which I thought might be helpful, appeared on my screen. Simple select statements will now be used to extract these codes.

select * from M error codes order by asc;