Comprehensive SAP Query User Guide

This paper makes an expedition to the electric data repository of the company, the data warehouse, possessing an objective to extract the desired, hidden data from the system and finally represent it on a single report. A specific focus will be on the SAP Query-tool; blessing for those you do not have the talent to utilise the complicated ABAP-coding.SAP Query tools enable the end-user to select desired data from the system, make simple calculations and then present this data on a report. But is the Query tool powerful enough to correspond to the demanded requirements?

Illustrated by a case study and screenshots, the paper explains how, when and by whom the query-function is used, what possibilities it offers, what other options it has and finally evaluates the pros and cons of the tool. The acquired information will later be applied to other processes, possessing an objective to speed up the evaluation of the duration of the processes, calculations of their costs, and to further provide the customers more accurate information.

Read more

Inter Company Billing Tutorial: Automatic Posting To Vendor Account in SAP

Automatic posting to vendor account is done by EDI in SAP. In our case where both companies are proccessed in the same system (& client), it is sufficient to create Idoc.

This document covers following steps for this process

  1. Creating a Customer to represent the receiving Company.
  2. Creating a Vendor to represent the supplying company.
  3. Creating a Port
  4. Maintain an Output Type
  5. Creating a Logical Address
  6. Creating a Partner Profile for both Customer & Vendor
  7. The relevant MM customizing is maintained.
  8. The relevant FI customizing is maintained.

Read more

Definition, Integration and Advantages of BAPI

The SAP Business Objects held in the Business Object Repository (BOR) encapsulate their data and processes. External access to the data and processes is only possible by means of specific methods – BAPIs (Business Application Program Interfaces). A BAPI is defined as a method of a SAP Business Object. For example, the functionality that is implemented with the SAP Business Object type “Material” includes a check for the material’s availability. Thus, the Business Object type “Material” offers a BAPI called “Material.CheckAvailability”.

Read more

LSMW Tutorial: Step by Step Guide to Update Customer Master Records

As a part of reorganization and to better serve the customer needs, you are regrouping many of the customers. In SAP terms, you are changing the Sales Office, Sales Group and Customer Groups for specific Customer Master Records. Typically, you would maintain customer records with transaction XD02 to update ‘Sales View’. You would enter Customer Key (Customer No, Sales Organization, Distribution Channel, and Division) and update relevant fields on Sales View screen.

This document contains Step-by-step instructions to use LSMW to update Customer Master Records. It has two demonstration examples – one using Batch Recording and another using standard SAP Object.

Read more

Batch Data Communication (BDC) in SAP R/3

The early versions of R/3, SAP has been providing batch interfacing techniques. Among these techniques, Batch Data Communication (BDC) is the oldest one. BDC is not bi-directional; it is an integration tool in its typical form. It can only be used for uploading data into RJ3. BDC works through an ABAP program and works on the principle of simulating user input for transactional screen.

The purpose of the Batch Data Communication is to transfer data. The BDC can transfer data from one SAP System to another SAP System or can transfer data from non-SAP System to SAP System too. To transfer data BDC uses normal transaction codes. Two methods are provided to BDC to do this work.

Read more