Special Posting Period

Q: How to enter posting in the special posting period lets say "13"

A: We use special posting period to post make adjustment entries. This is how to post in "Special Period" in system : 

 

1. Go to F-02

2. Enter desired dates in date field.

3. In period field enter " Special Period Number e.g 13"

4. And proceed with normal postings and save the document.

 

For posting in special period you have to enter special period explicitly, and your Posting Date should fall in Last Actual Period say March or December. In below example date is in March 2014.

 

 

Please find below screenshot for your help and reference.

FB03

FS10N

​

I hope this will help you to understand functionality, and solve your issue as well. Just try F-02 in your system and see what happens - see results in FS10N as well.

Line Item Display

Scenario: How can we see line item for a GL Account who line item display is not active?

Solution: The procedure would be to create an interim account, transfer the balances of your original account to this interim account, block the original account, activate line item display, Run a program called RFSEPA01, unblock the original account and get the balances populated again through a transfer from the interim account and then block the balance less interim account. If this had been done then you could view line items for your original account retro-actively also. 

Message no. KI 760 "Revaluation of actual prices not possible in version 0, fiscal year 2014"

Hi Team, We are facing a problem when running Tcode: CON2, the error messages was Message no. KI 760 "Revaluation of actual prices not possible in version 0, fiscal year 2014"

Solution:

 

IMG Menu Path: - IMG > Controlling > General Controlling > Organization > Maintain Versions

 

Transaction Code: - OKEQ

 

Step 1:- Enter T Code OKEQ in the SAP Command field and press enter

Step 2:- In the next General Version Definition screen, select the Version 0 and double click on the Controlling Area Settings

Step 3:- Update the Controlling area

 

Step 4:- Double click on Settings for each Fiscal year under controlling area settings and update the values

Step 5:- Double Click on Year 2014

Step 6:- Click on price Calculation Tab

 

 

Step 7:- You will see the following screen

Step 8:- And change the following fields to show it as 

This will resolve above given error.

Tables Identification

There are two types of Data in SAP

 

1. Master data (GL accounts, customers, vendors, assets, cost elements, cost centers, profit centers etc.)

 

2. Transactional Data (Open Items for customers and vendors, GL line items, Cost Center planning, profit center plan data load etc.)

 

Therefore the tables are also different to store value.

 

For Master Data, the data is stored in

 

·       A ->   Chart of Accounts

·        B -> Company Code

·         K -> Denotes Customer in Master Data

·         L-> Denotes Vendor in Master Data

·         S-> Denotes General in Master Data

 

KNA1 -> Customer Master Data in Chart of Account

KNB1-> Customer Master Data in Company Code

 

LFA1-> Vendor Master Data in Chart of Account

LFB1-> Vendor Master Data in Company Code

 

SKA1-> GL Master Data in Chart of Account

SKB1->GL Master Data in Company Code

 

For Transactional Data, the source structures are

 

·         BKPF – It stores Document header information

·         BSEG – It stores line item level information

 

BS -> This is common across all transactional Documents.

 I-> This is used for all open item.

A-> This is used for all cleared Item.

 

BSID -> Table for open item for Debtor

BSIA -> Table for open item for Assets

BSIS -> Table for open item for General Ledger

BSIK -> Table for open item for Vendor

 

BSAD -> Table for cleared items for Debtor

BSAS -> Table for cleared items for General Ledger

BSAK -> Table for cleared items for Vendor

 

To check any table, you should check SE11

Hope it helps

Multiple Choice - Basic Questions - Part 1

Error : Create Account as a Cost Element in Controlling Area xxxx

Solution: Every account which falls in the nature of expense and Liability, System will ask for the cost element. You have to also define the category in each cost element and its validity period 

Tcode 

KA01 ---Create, 

KA02 --Change, 

KA03 ---Display 

Using KA01

Hope this helps.

Name Change in FSV

My company has been sold out. I wish to do a name change for the company in Financial Statement Version. Attached is the screen shot.

Solution: 

SPRO-> General Ledger Accounting(New) -> Master Data -> G/L Accounts -> Define Financial Statement Versions.

Pick up the financial statement version which you want to edit and change the name as requested. 

We picked Acid India to be renamed to Tata Chemcials.

Hope it helps

“Maintain the Chart of Accounts in company code VANI”

While using Tcode -> OBY2 to copy GL Accounts, from Company Code SKC1 to VANI, it is throwing an error "Maintain the Chart of Accounts in company code VANI"

Reason for this situation

Chart of Account has not been populated here.

 

We need to create Chart of Account.

 

SAP Menu Path: - IMG –> Financial Accounting –> General Ledger Accounting –> G/L Accounts –> Master Data –> Preparations –> Edit Chart of Accounts List.

 

Transaction Code: - OB13

 

Step 1:- Enter the Transaction code SPRO in the SAP commend field to get the Implementation Guide

Step 2:- Click on SAP Reference IMG

Step 3:- Navigate the below Path and click on Edit Chart of Accounts List to create new Chart of Accounts

Step 4:- The Existing Chart of Accounts which is already created is displayed below, Click on New entries button to create new Chart of Accounts in SAP

And enter the details for your company chart of accounts

1. Chart of Accounts: - Enter the 4 digit alphanumeric code of the Chart of Accounts

2. Description: - Enter the Description of the Chart of Accounts

3. Maintain Language: - Select the language of the Chart of Accounts

4.  Length of G/L Account Number: - Update the length of Gal Account Number

5. Integration: - We can have controlling Integration Manual creation of cost of elements or Automatic creation of cost of elements. It is advisable to have Manual creation of elements in SAP

 

Profit center not appearing

Please note that profit centers  are not appearing in customer collection account .  This is causing difficulty in cash-flow report generation. Please see screen shot below.

Solution:

Profit Center information is not entered in Vendor and Customer in line item.

It is only entered in the expense/income line items from where this information is derived at the AP/AR level.

If you click on , you will be able to see the profit centers.

Hope it helps.

Difference between F-03 Balance & FBL3N Open Item Balances

Situation:  One of the issue is when we seeing open items for three GL accounts which is related to bank account such as main, deposit & issue account in FBL3N, system showing the balance which is correct. Now my client clearing these deposit and issue account balances to main account in F-03 on a particular date where system showing different balance, also main account does not have any balance in FBL3N but don't know why system showing different amount in F-03.

Kindly request you to provide solution on this issue.

Solution:  Open FBL3N; Select Open Items, Open at key date -> 31.03.2014

This will lead to this screen, where you can see balance in local currency considering the valuation of foreign currency.

Now, go To f-03 screen and check the clearing GL Account. Open the GL with clearing date as of  31.03.2014.

This will give you Balance as per screen

Now you can see there is difference between the balance. Now to check this click on the 

 button and this will give you following screen if you toggle by pressing the 

Now you need to move the differential balance as per your company policy. We moved the balance to Valuation Gain/ Loss account. Hope it helps.

Regards

Vanisha

How to check if Document splitting is active for your company code

How to check if Document splitting is active for your company code

You can check also check by looking at the entry in table FAGL_ACTIVEC:

How to toggle between the Field name and Field Label in Table view

How to toggle between the Field name and Field Label in Table view

Go to SE16, Data Browser Screen

Now, click on   --> 

And toggle with the keyword

This will be the output