[email protected]
My Account
  • Home
  • Blog
  • eBooks
  • ECC/S4 system Access
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • ECC/S4 system Access
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • ECC/S4 system Access
  • About
  • Contact Us
  • My account

No products in the cart.

  • Home
  • Blog
  • eBooks
  • ECC/S4 system Access
  • About
  • Contact Us
  • My account
General SAP
Home Archive by Category "General SAP"

Category: General SAP

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
SAP 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
SAP 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
SAP 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
SAP College March 18, 2022 0 Comments
General SAP

SAP College weekly Newsletter

Get notified with the new blogpost every Friday!

“Live as if you were to die tomorrow. Learn as if you were to live forever.”

-Mahatma Gandhi.

“People hate spending time & money on boring transactions and love to spend more time & money on interesting transaction, with the simple hack, you can reverse this fact and get ahead of 99%”

-Kunal Shah

With this two insightful quotes, we invite you to join our free Newsletter where every week, we explore new topics of SAP world, we explore new technologies that are developing around the ERP world and bring our learnings to you.

In this world of abundant information, it is very hard to cut the noise and focus on quality information, skillset. This is where we would like to help you..

Join the community of thousand plus readers

Read More
SAP College March 14, 2022 0 Comments
  • 1
  • 2
  • 3
  • …
  • 5
  • Home
  • About
  • Contact
Categories
  • ABAP 8
  • FICO 18
  • General SAP 23
  • MM 1
  • SD 2
Products
  • S4HANA 2021 – BASIS & Security Server ₹1,849.00 – ₹11,999.00
  • Placeholder ECC 6.0 EHP8 - EWM Server ₹1,499.00 – ₹2,499.00
  • S4HANA 2021 – ABAP Server ₹1,849.00 – ₹11,999.00
  • Learn to Debug ABAP Programs ₹499.00 ₹449.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

SAP College is a knowledge portal for all of those who wants to learn SAP. This is a one-stop reference for your entire SAP needs.

sap_college

Few insights about Brexit from the SAP's latest we Few insights about Brexit from the SAP's latest webinar. Brexit is still open with all the possibilities and still everything is clear... as said... they are very close to the deal and yet too far from the deal.

#SAP #ERP #SAPERP #brexit #sapcommunity #s4hana
To read full blog and more like this one visit the To read full blog and more like this one visit the website mentioned in bio.... 
@sap_college 

#sap #saphana #SAPUI5 #saperp #sapcommunity #S4 #s4hana
End-User Manual - Asset Accounting in S4 In this f End-User Manual - Asset Accounting in S4
In this free document, you will get a broader picture of how end-user transactions are changed/affected with New Asset Accounting.
All the information about new transactions and obsolete transactions in S4.

You will learn the newly introduced topics in below areas:

1. Asset Master data
2. Asset Accounting business transactions
3. Month-End closing activities
4. Year-End closing activities
5. Asset Accounting - Information System

Download this free book now from the link in bio

https://lnkd.in/gtvPz-U

#SAP #s4hana #sapcommunity #erp #sapfico #saperp #fico #accounting #assetaccounting #s4 #HANA
Follow SAP College on LinkedIn and stay up to date Follow SAP College on LinkedIn and stay up to date with SAP's new releases. New blog post everyday. eBooks review. Free books. Documents. And many more....

#SAP #S4 #SAPCOMMUNITY #S4HANA #ERP #SAPUI5 #SAPERP
Follow on Instagram
This error message is only visible to WordPress admins

Error: API requests are being delayed for this account. New posts will not be retrieved.

Log in as an administrator and view the Instagram Feed settings page for more details.

Contacts
Website: https://sapcollege.co/
Email: [email protected]
Facebook Page
Terms & Condition

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