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

Purchase Order Email with PDF Attachment On Approval

The article will let you go through purchase order email when an approval workflow is triggered at the time of release purchase order.

This article will include following:

1. Purchase Order PDF Conversion

2. Create HTML Content of Purchase Order Email

3. Send Purchse Order Email with Purchase Order Document in PDF format

Material Characteristics Batch View Report

I’m starting the SAP blog page with a report. In this report, we will try to show the characteristic values entered under the material class in the material master data to the user in the form of a report.

I am working as an ABAP developer in a company that uses SAP. The reason why we need this report is that our production planning department wants to see the characteristics they defined for the materials collectively. Material characteristics can be obtained with the CLAF_CLASSIFICATION_OF_OBJECTS function. Since we will query the materials collectively, we will read directly from the tables to gain performance.

Display Material Picture in Material Master Screens MM01/MM02/MM03

Introduction:

This blog post will guide you to create a custom sub screen in the basic data tab of the material master transactions.which displays the picture of the corresponding material stored in the DMS.

Requirement:

The requirement is to create a sub screen in the basic data tab of the material master transactions.The custom screen is used to display its corresponding image from DMS.

With the help of custom function group and SPRO configuration to the screens,we will be able to achieve this.

Custom MIGO: Transfer postings & Reservation/Unreservation against Sales Order

Introduction:

This blog will be helpful for any Manufacturing industries, either Make to Order or Make to Stock this scenario works and this could be requirement for most FMCG industries.

Standard MIGO screen in SAP has multiple functionalities whereas very few functionalities only have auto population of line items like GR against Purchase order, GR against Production Order etc., only have this functionality.

Alternative to MD_STOCK_REQUIREMENTS_LIST_API to get Item in MRP document (MDPS), Individual lines of the MRP elements (MDEZ) for multiple materials / plant combination

Introduction

Normally there is a need to get stock requirements information for certain selected materials and plants. After scouting through various answers in sap forums and blogs we knew we had to use the FM MD_STOCK_REQUIREMENTS_LIST_API or BAPI_MATERIAL_STOCK_REQ_LIST to get results similar to MD04 transaction.

Step-by-Step Archiving of Material Documents

1. Step by Step Archiving Procedure for Material Documents Archiving:

Archiving Object MM_MATBEL is used for the archiving of Material Documents.To perform data archiving in the SAP system, SARA transaction code is used. This is the standard method for executing the Archival.

Physical Inventory with respect to WM

Overview Guide For Physical Inventory

Considering you have basic understanding of the process as discussed above let us jump in to the functional and technical process of the same.

Physical Inventory process varies with respect to MM and WM, in the upcoming steps we will show the same cycle with respect to WM Module.

Getting an image from material master data and adding it into an adobe form

This post shows how to get an attachment, in this case an image, linked to a material that was uploaded to the material master data through Generic Object Services (or was archived), and add it on an adobe form.

The business object for Material is BUS1001006.