expertsask994@gmail.com
My Account
  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • SAP FICO Course
  • About
  • Contact Us
  • My account
General SAP
Home General SAP Page 2

Category: General SAP

General SAP

SAP ECC & S4 Server Access

S4HANA 2021 & ECC EHP7 Functional & ABAP Server Access with all authorizations related functional & technical transactions, customization and tables. With 24*7 support to system access and authorization related queries.

System access time: 24*7

Support: 24*7

Installation: Can provide software (Installation not included)

Follow this tutorial to install SAP GUI

For any queries reach out to us on: expertsask994@gmail.com

Submit your order below:

https://forms.gle/i6GDKyzvcT9YW5Z79

Read More
ERP College March 16, 2023 0 Comments
ABAPGeneral SAP

ST05 Database Trace: How it is helpful to Functional consultant

You can trace the database using ST05 transaction to find out what tables / structures underlying program is using. It is extremely great tool to have when you want to analyze any transaction and there is just not enough information available over internet.

ST05 is used to analyze performance of programs majorly.

There are five important types of trace we can perform using ST05 and each is very important in specific context.

Note: This blogpost is a piece of eBook: Learn how to debug ABAP Programs. You can get the book by clicking on the link.

So let’s see how to use ST05

ST05

This is how ST05 screen looks like.

Here we have multiple options to filter trace of any program:

  • SQL Trace: this trace helps to find out all tables and structures used by any program/transaction for performing statements like select, insert, delete and update
  • Buffer Trace: to check table buffer (helpful to decide performance tuning opportunity area)
  • Enqueue Trace: enqueue function is used to lock object at the time of updating data and then unlocking it after data update is finished. Many times, you receive errors like ‘xyz table is locked by user’ these errors are issued because of this enqueue function.
  • RFC Trace: this is useful to find out if program is making any remote calls to another system. (useful when analyzing interfaces)
  • HTTP Trace: to trace HTTP requests from program/application.
  1. SQL Trace

First we need to activate trace from ST05 transaction

There are two options to activate trace, you can see highlighted in above screenshot

One should always select activate trace with filter option

Get ECC & S4 Server access here.

In the next prompted screen (above) you should enter your username, transaction name and program name if possible for which you want to activate trace. In lower side you also have include and exclude options to narrow down the trace criteria.

Activating trace is a big deal. Because system collects huge data for analysis purpose, so be mindful while activating trace.

Now after entering filter criteria press enter and trace will be activated.

We are trying to trace FB03 transaction

Open FB03 transaction in other screen

Enter document details and press enter. You can keep going on like opening line item of journal entry or exploring various options from menu, system will keep recording trace of each and every activity. For this e.g. to keep it simple, we will just open journal enter and then close FB03 transaction.

Now go back to ST05 screen and deactivate trace

Then click on display trace option and execute report

And here you go, you got list of programs and objects (tables/structures) along with how much time it took.

You can double click on program name and system will take to that program statement.

To simplify this list further and we are also only interested table checked by FB03, hence we will go to aggregate trace option and select access to table (as displayed in below screenshot)

In next screen you will only see the list of tables that are used.

Let’s make it more simpler to understand, as we can see there are multiple tables that we might not be aware of.

Click on component hierarchy and select level 0 (as shown in below screenshot)

Read blogpost: Everything about FEBKO & FEBEP tables in SAP (EBS)

You can double click on table name to check table details.

In next screen you will see tables are segregated based on their modules

You can notice first BASIS tables are displayed under Basis Component head. Next Financial account tables are displayed. This will help you to check on right tables.

This was about SQL Trace.

Similarly you can use other trace to find out is there any RFC calls made or HTTP request in application. Many times you will come across multiple scenarios where you would like to know what this Z transaction do at that time instead of checking program line by line. You can simply activate all trace in ST05 and then analyze each trace separately.

This will save hours of time for you.

As discussed earlier this blogpost is taken from eBook Learn to read ABAP programs for functional consultants. If you found the blogpost useful then you can get your copy of eBook.

Stay tuned and connected with us on below platforms:

YouTube

LinkedIn FICO Page

LinkedIn ABAP Page

LinkedIn Logistics Page

Instagram

Thanks for reading.

Read More
ERP College October 28, 2022 0 Comments
General SAP

Configure company code for all FICO sub modules

In this blogpost we will see how to configure company code in all FICO sub modules. This blog will be a collection of SAP College YouTube videos, where all sub modules configuration steps explained in sequence.

Setup FI-GL module (Create Company code)

Company code configuration step by step guide in 14 steps. Configure usable company code in 15 minutes. Ready to post documents.

Download free document of configuration steps to setup FI GL AP AR AA CO module:

Configuration steps to setup new company code

Below is the video content:

00:01 Introduction

00:45 Create company code OX02

01:38 Create company OX15

02:24 Assign company to company code OX16

02:58 Create Chart of Account OB13

04:00 Create Account groups OBD4

05:05 Define posting period variant OBBO and maintain post period OB52

07:08 Define field status variant OBC4

07:39 Set Global Parameter OBY6

09:09 Tolerance group OBA4

10:10 Define tolerance group for GL OBA0

10:52 Define additional currencies for Company code OB22

12:50 Define number range FBN1

15:20 Define retained earning account OB53

17:01 Create GL Master record FS00

19:10 Post Document FB50

24:45 Conclusion

Accounts Payable and APP configuration steps

Complete Accounts Payable and Automatic Payment program setup in SAP. Configure AP & APP setup to successfully post AP Invoice and run Automatic payment program (F110).

Accounts Receivable and Dunning setup

What are the mandatory steps to follow for new company code to extend it in SAP AR Module. A brief overview and to the point action items in 10 minute.

Asset Accounting and Controlling Area Setup

Complete setup of Enterprise Asset Management in SAP. Extend your company code to asset accounting in few steps. In this video we have extended our company code to Asset Accounting and Controlling submodule. To test the configuration, we have created asset master data, acquisition of asset and posted depreciation on same asset.

eBook: Classic vs New Asset accounting

What has been changed in New Asset Accounting

Project System Setup

Coming Soon.. on SAP College YouTube Channel, Subscribe to stay tune

Read More
ERP College April 19, 2022 0 Comments
General SAP

How to Install SAP GUI in Windows and Mac?

For Windows:

Install SAP GUI from below link

SAP GUI

Watch below video for installation guide

For MAC M1

Follow this link guide

For MAC

Follow this link guide

Read More
ERP College April 19, 2022 0 Comments
General SAP

Material price calculation in PO, GR, and Invoice

In this blogpost we will see how material price is calculated in procure to pay process

Price determination at purchase order

At purchase order, material price gets determined automatically. So how does it determine?

Material price is determined in below sequence:

If material is maintained with standard price (S)

  • Then PO will have price from material master

If material is maintained with Moving average price (V), then it will be determined in below sequence:

  • Price from contract
  • From info record
  • Condition record
  • Last PO price (depends on parameter maintained)

Price determination at GR

When goods receipt (GR) is performed, the purchase order price is used in posting corresponding accounting document.

Let’s understand amount calculation in good GR:

When good receipt (GR) is performed, below accounting document gets generated (In case of moving average price):

When good receipt (GR) is performed, below accounting document gets generated (In case of Standard price):

In this case price difference will be posted to transaction key PRD (To assigned GL in OBYC)

Inventory account is always posted with standard price of material maintained in material master.

GR/IR clearing account is always posted with PO price.

When invoice receipt (IR) is performed, below accounting document gets generated (In case of moving average price):

Any price difference will be booked on inventory account (material)

Also Read: Useful reports in Material Management

When invoice receipt (IR) is performed, below accounting document gets generated (In case of standard price):

Any price difference will be booked on PRD transaction key (to GL assigned in OBYC)

So in conclusion, GR/IR prices are always influenced through PO except when material is maintained with standard price control.

When material is maintained with standard price control it causes price difference and then that is posted on price difference account which is maintained in OBYC transaction.

Get SAP Server Access – ECC & S4HANA

Read this SAP Help post on same topic for more information.

Hope you enjoy this short post on PO pricing. If so then do sign up with our newsletter below to get notification of new blogposts.

Read More
ERP College March 18, 2022 0 Comments
  • 1
  • 2
  • 3
  • 4
  • …
  • 6
  • Home
  • About
  • Contact
Categories
  • ABAP 8
  • FICO 23
  • General SAP 29
  • MM 1
  • SD 2
Products
  • SAP FICO (Finance and Controlling) Comprehensive Training
    Rated 4.50 out of 5
    ₹7,999.00 ₹6,999.00
  • What has been changed in New Asset Accounting
    Rated 4.00 out of 5
    ₹151.06 ₹119.00
  • Learn to Debug ABAP Programs
    Rated 4.33 out of 5
    ₹499.00 ₹449.00
  • SAP Accounts Receivable (AR) Training ₹999.00 ₹699.00
Sign Up to get update of latest Blogs

Find Us

Address
123 Main Street
New York, NY 10001

Hours
Monday–Friday: 9:00AM–5:00PM
Saturday & Sunday: 11:00AM–3:00PM

About This Site

This may be a good place to introduce yourself and your site or include some credits.

Contacts
Website: https://erpcollege.co/
Email: expertsask994@gmail.com
Terms & Condition

Copyright © 2020 ERP College by Smarksys Technologies. All Rights Reserved.