Automate Sybase ASE Backups using DBA Cockpit (Sybase:v15.7.0.021+)

Automating Database Dumps in SAP ASE

This blog post guides you through automating database and transaction log backups for your SAP system using DBACockpit in SAP Sybase ASE version 15.7.0.021 or higher. We'll focus on using the local file system for intermediate storage.

Prerequisites:

1. Administrative access to the SAP ASE server.

Understanding of SAP ASE utilities like dump database and dump transaction.

A Quick Guide To ABAP Debugger

While the SAP BTP platform has witnessed significant progress and adoption, offering numerous development tools for SAP platforms, it's noteworthy that SAP GUI for ABAP continues to be widely utilized in many organizations and projects. This document aims to deliver succinct information about the SAP GUI ABAP debugger, specifically catering to SAP functional consultants and ABAP newcomers.

Note that certain features are also accessible during debugging in Eclipse ADT. Personally, I favor using the Eclipse IDE.

Breakpoint: A breakpoint is a specific point in your program where the execution of instructions comes to a halt. In ABAP, there are four ways to interrupt the execution of your program:

SQVI Reporting | Easiest and Fastest Way to Create Reports Without Technical Skills.

Although ABAP programmers are typically credited with creating custom reporting, this may not necessarily be the case for straightforward and general reporting that isn’t heavily dependent on calculations.

SAP has a robust reporting tool that anyone, regardless of technical proficiency, may utilize to easily create reports.

Go to transaction SQVI

• Give Viewname anything you want
• Click on Create
• Give the Title
• Provide data source as Tabel Join
• Click on Tick to move to the next step

How to Copy Table Entries from One System to another using Adjustment Process?

Introduction

In every Project you work on there will be cases where you need to copy data from One System to another. This can be QA System to Prod system or the much awaited SAP ECC To S/4HANA. This is a life saver provided all the data related to Check tables are already maintained in the Destination System. Most of the time we create Program for each table and that can add up to a lot. This blog should be used only for Custom Table not Customized.

Solution

Go to SM30 Transaction Code

Schedule Background Job with Last Execution Date and Time or with a Time Window

Owing to various business scenarios, we might come across requirements where background jobs must be scheduled. Now, the most common way to schedule batch job is through the TCode SM36. Especially, in case of Interfaces through which SAP receives huge volumes of data from Third Party and must process them in one batch run, nightly in most cases, Background Jobs are critical.

However, few cases arise where SM36 does not meet our requirements sufficiently. For example, if the requirements are such that, the job must only run within a specific timeframe or the job should have a last execution date, SM36 fails to accommodate those cases.

How to Manage and Move Transport Request in S/4HANA Public Cloud in 3 System Landscape

Purpose of this Document

This document helps you understand moving transport request from Development to Q system and Q system to Production system in 3 System Landscape. Transports for business configuration, key user extensibility, and developer extensibility are of the different categories and that is why these are separated. So, we need to understand all of three.

Where-Used List for NAST output types

If the current system already has dozens or even hundreds of NAST output types, one day must adapt all those forms if related to one group of specific criteria like sales organization, then how to identify which output type has been used by the sales organization?

It’s well known that general NAST output determination and configuration are maintained with various key combinations and stored at multiple condition record tables just like pricing determination processing.

Automate printing of PDF documents received as email attachments in SAP

In this blog, we will see how we can enable auto print functionality for PDF documents on dedicated physical printer or on local printer (LP01) in spool.

Additional Business requirement : All the PDF documents (if there are multiple attachments in e-mail) should get generated as one PDF in spool and in case of two-sided printing, one documents shouldn’t get printed on back side of another one.

As per previous article, we have already implemented the two methods of Interface IF_INBOUND_EXIT_BCS in inbound Exit(Z-class : ZCL_BILLING_EMAIL_IN).

Quick check when IDOC not generated for FIDCC2

Once IDOC has not been generated correctly for message types like FIDCC2, especially for new company code at rollout project. The quickest way to check this:

Easy way to disable creation, modification & deletion of sales order item text ids in VA02

Introduction

In certain cases, you need to disable text ids of the Sales order item in VA02 under the Texts tab to restrict the user from deleting, changing, or creating texts.

This can be complex based on your approach. So, for the easy solution, I am writing this blog post.

This solution is to convert the type( V -> A ) of the transaction in the include: MV45AF0C_CUA_SETZEN by doing an explicit enhancement.

How to Find the Table/CDS Name by giving field Name in SAP ECC and SAP S/4 HANA

I experienced, this is a common issue for beginners and seniors to find a table where they can see the records most of the time they found structure normally structure field’s name and table field’s name is common if you know that field’s technical name then this blog will help you.

Get the technical name of the field which normally we can find with the F1 help key in technical information you can find your table and CDS by using this Customized program.

Selection Screen: (You can enter up to 4 different fields )

Read data from attachment List

1. Introduction

Normally, we use READ_TEXT to read data text from header or item. But in some case, specially in Fiori app, text data will be saved in attachment list.

So, how to read data from attachment List?

Don’t worry, I will show you step by step to get data by using abap program

Avoid Hardcoding in SAP by TVARVC or SETLEAF

At the time of discussing client’s pain points and challenges which they are facing or reviewing the ABAP codes we have noticed that many variables are hardcoded or many Z-tables are present in the SAP system for maintenance of data to use in user exits, BADI’s, Reports, Forms, etc.

Due to Hardcode, code changes is required every time for addition/modification/deletion in the data which requires additional technical efforts along with functional for inputs & testing. Due to Z-table creation also Additional ABAP efforts are required for DDIC creation, table maintenance generator, domains creation or assignment, etc.

Upload Variant table using transaction CU60E – RCU_UPLOAD_EXCEL_TO_VTAB

Learn about how to upload variant table contents from excel in .csv format using transaction CU60E.

Business requirement: In general , in Variant configuration module it is always require to upload the values to Variant table as a content from excel file. It will be always challenging for the functional consultants to load the data from excel file to SAP particularly in project implementations.

When we have a characteristics values being filled in excel sheet we can upload via transaction CU60E with .csv format.

Making columns and rows in proper manner (Length, Height and Width) in SAP Adobe form.

This blog used to save more and more time and give efficient output in a single execution, when  required to design multiple columns and row fields.

Aim: When you design columns and rows in adobe form, length of the field, width and height calculations are important for each and every column.

Whenever we use columns and row fields in an adobe form drag and drop, below following are the common issues will be faced:

Switching the entry of a Business Partner last name to optional

Override  Business Partner validation as save event via BDT

The BDT (Business Data Toolset) is a central control tool for maintaining master data and simple transaction data. In addition to dialog maintenance, it also supports maintenance with direct input and/or function modules.

Enhancing the screen to make BP last name optional is a common requirement however known to be quite tedious if correct steps are not known.

ABAP Tricks for Functionals | Trick #1 – Edit Table Values in S/4 HANA using SE16 Debug Edit

Introduction –

We come across situations where we need to edit values in standard/custom tables. There could be many reasons why you want to edit values in standard/custom tables, some reasons are listed below.

1. You are performing testing, and want to simulate a test scenario without changing a lot of test data

2. You do not have a table maintenance transaction available to edit table value

3. You have found a data inconsistency and want to change table value to fix it

Automate Master Data Vendor Extension Process to Purchase Organization with Approval Workflow

Introduction

In every Project or Customer you worked for, you will have the scenario where some Master Data will not be extended to Company Code/Purchase organization and in those scenarios you have to send an email to that Team and wait when this will get extended so that you can create your Business Document. In this Blog we are considering a case where a Vendor/Supplier is not extended to a Purchase Organization. We will show how we can create a Simple Workflow for the Approval of this Master Data Extension and it is Auditable as everything is inside SAP. This will help you achieve the following Business Goals

How to Send Email from SAP ABAP Query Report ?

Introduction

In SAP most of the time when we create a ABAP Query report we do it to download it to our Local file and then we need to send it to a bunch of Recipient. This Blog will help you in taking some of this Steps reduced by Sending email directly from the ABAP Query Report.

Solution

First we go to Transaction Code SQVI.

Select your ABAP Query.

Navigation from SAP S/4 HANA to SAP ECC 6.0 to view the replicated sales order

Recently I was assigned an interesting development, the requirements was to have a button “View legacy Sales Order” on standard sales order screen (VA03) on SAP S/4 HANA system if user clicks that button the system should open VA03 – display sales order that got replicated in the legacy ECC system using a RFC – single sign on (Different system).

Below are the step by step development that I did to accomplish the same.