Send XLSX file with multiple tabs in zip format via E-mail

Objective

To send ‘.XLSX’ file type with multiple sheets in single excel file as attachment via E-mail

Context

Using OLE logic, we can achieve this requirement and the attachment will be an ‘.XLS’ file. But our client system has some trust center setting enabled in their system which exempts them from opening .XLS file. So, we have to send the file in .XLSX file format for them to open. Although, we have abap2xlsx to deal with such requirements, this blog tries to achieve this without using abap2xlsx, and the attachment will be sent in ZIP format with one single .XLSX file as attachment in E-mail.

How To Create A Rest Api With SAP Abap And Apply MVC1 Routing

In this blog post, I would like show how to create Rest api and how to apply MVC1 routing to handle different request simply from a controller class.

For that, first we will create handler and controller class for rest structure. Then we will add mvc1 controller class and model class to process business logic.

And finally we will create a service to handle rest requests.

Displaying the signature of a method in ADT permanently

I’m sure you often have the situation that you are implementing a method in ABAP with ADT and you need information about the signature and the types that are used in the signature.

The standard answer for this is the Element info (Shortcut F2) on the method name.

How to use Side Effects in ABAP RAP (Restful Application Programming) Model

In this beginner blog post we are going to see how we can use Side Effects in ABAP Restful Application Programming Model.

What is Side Effects:

When user makes a change to a field on UI, and this change effect the content of other field, this behavior is called Side Effect.

Annotation to Implement Side Effects:

Some more annotation properties are available but for this demo we are only using below 2 Annotations properties.

Send ZIP File Filled with PDF Files in OData, Media Handling in OData

Introduction

Recently I got a request for getting multiple PDFs from the service that was already in use, and I was already using ‘ GET_STREAM ‘ method to return a single PDF. Facing this request, the most quick and usable solution I thought was why not I am adding multiple PDFs into a single ZIP File, and then here we are.

ABAP Units with Test Data Container

Introduction – Test Data Container

A Test Data Container (hence its is referred as TDC) is an E-CATT Test Object. It is defined in the test repository. It has the following:

– Technical Attributes – Information about the container like description, package assignment etc.

– Parameters – Name of the variable through which test data is passed to test the ABAP object.

– Variants – Different combinations of the test data/values to be used for parameters

How to Change Screen Field Properties in Purchase Requisitions

In this post blog, I will show you how to change screen field properties and how to hide screen fields/tabs on purchase requisitions screens.(ME51N, ME52N, ME53N)

This blog post specifically will cover showing, hiding fields which can not be customized by using SPRO customizing settings.

In additional, it works on S/4HANA Cloud too.

In our example, I’ll show you, hiding the fields which are ‘Expected Value’ and ‘Overall Limit’ fields.

Eclipse ADT & SAP NetWeaver AS ABAP Developer Edition Connection

In this post, I would like to show how to connect Eclipse ADT to SAP NetWeaver AS ABAP Developer Edition 7.52 SP04 on Ubuntu, which is running on Oracle Virtual box.

For Eclipse ADT installation you check that link.

With steps below you can connect to SAP from Eclipse;

Step 1 – Check your SAP GUI connection

How to Configure Legal Numbering for Customer Invoices for a Non-Localized Country

This blog outlines Configuring Legal ID in Cloud Application Studio at detailed level over the existing model in SAP Business ByDesign.

Configuration of Legal ID in SAP Business ByDesign solution is outlined as following.

1. The Fine-Tuning activity to maintain “Document Numbering Formats for Customer Invoicing” is accessible in the SAP Business ByDesign, Business Configuration WorkCentre

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: