Balance in local currency issue

 Balance in local currency

My user create new bank G/L but forget to tick Only balances in local crcy in Account control in company code (FS00). so the result when the G/L XXXX01 using for transaction in foreign currency (USD), and want to clearing by tcode FEBAN error (use local currency in FEBAN) red light show up.

finally my user want to clearing manual by F-03 error showup

i think its because G/L XXXX01 not tick on balanced in local curency.

in G/L G/L XXXX01 there is already transaction, it is allowed to chance by tick on balanced in local curency ? is it will efect to all transaction that already happen to this G/L ?

Solution:-

1. Maintain the exchange rate accounts under OB09

or

2. Clear the documents in foreign currency

or

3. Check whether both documents are posted to same Business area /Business place.

Internal Order settlement issue - G/L account cannot be created as a cost element

 Pls check the below error i am getting while settling the internal order.

Gl account 40101001 is created as cost element.

Solution :-

Please go to transaction code OKG8 (define posting rules for settlement to FA), against the RA category WIPR/RUCR for your company code, under P&L account, you have assigned a GL account which is created as cost element, which is not correct.

The GL account that you assign under P&L account for RA should not be created as cost element. So, if no postings are done, delete cost element for the GL account. If already postings are done to the respective GL accounts, you are not allowed to delete its cost element. So, assign another GL account which is not created as cost element (it should be of P&L account nature only, not B/S account)

Cost Center budget upload:-

 Cost center budget upload:

A.      Define budget planning profiles

b.       Maintain Budget availability control profile for cost center

c.        Maintain categories for planning.

d.       Define budget check for categories

e.       Cost center budget planning changes tcode-KPZ2

 Configuration step:-

1.       Define budget planning profiles

It is applicable for annual value or period value

                  2.       Maintain Budget availability control profile for cost center

                                                    

3.       Maintain categories for planning.

4.       Define budget check for categories

5.       In FIORI Manage center master Tile - center master budget availability control should be active

6.       Cost center budget planning changes tcode-KPZ2

 

Cost Center Planning through EXCEL upload.

 

                                Excel Planning In Cost Center Accounting

what is cost center planning?

cost center planning includes entering plan figure of cost, activity, price for a particular cost center and particular planning period. later you can determine the variance from these figures when you come to compare these plan value with the actual cost incurred.  

KP26- Activity type/ price planning

KP64- Create Screen layout

KP34- Create planner profile

Purpose

This content was created to clarify how to use excel in cost center planning.

Overview

SAP offers the option to use Planning with Excel integrated into the user interface of the SAP System, this enable you to plan using the function of planning screen or Excel.

Planner profile

You can create or change a planner profile on transaction KP34. In this example I will create a planner profile to upload data in transaction
KP26 (Change activity Type/Price Planning: Initial Screen).

- Create a profile name and description in KP34

  
Transaction KP34

- Click on 'General Controlling'
- Here you will enter the area in Controlling where you carry out planning. I will use Cost centers: activities/prices on this example.

 
- Select the planning area and click on 'Layouts for Controlling'
 

 

Here you can choose an existing layout. To create a layout go to transactions KP65/KP75/KP85.
 
- To use excel select the Indicator for activating integrated Excel in planning.
- Click on 'Default parameters'
 

 
- Enter default planning data in the selection screen the click on overview
 

 
SAP will create a file layout and generate the file description
 

 
To save the layout press 'Save Excel Layout', you can click on 'generic file' button to create a generic file name.
 

 

Upload Data

Go to KP04 to enter your planner profile.

To upload data with excel at least one line of plan data must be entered manually using standard planning. Once this has been entered then excel planning may continue.  

 In KP26 go to Extras->Excel Planning->Upload

Transaction KP26

Select the file location and the file description and execute

 
If any error occurs or the upload finished without any errors will be presented on the next screen.

 

 
Clink on the line to see more information or errors if presented :
 

Report RFWT0020

 

Purpose

Program for Subsequent Creation of and Changes to Withholding Tax Data with Withholding Tax Rate 0%

The user posted 15 invoices he was not updated the withholding tax code for that line items now the user wants to update? then how?

It can be update by using program RFWT0020 using transaction code SE38.

Prerequisites

- The company code selected is relevant for withholding tax.

- The vendor selected is liable for withholding tax for a withholding tax category with a withholding tax rate of 0 %, or the customer is eligible for withholding tax deduction (in each case, only one withholding tax category is defined in the corresponding master records).

- Accumulation, central invoice, certification and formulas are not activated at the withholding tax type level (extended withholding tax),

- The corresponding withholding tax types are relevant for posting payments.

 

Example:

Transaction FK01 You will create the vendor example: 100298 not Withholding Tax relevant:

You will post an invoice without Withholding Tax data:

You create a WT code with the WT rate 0%, without a Formula:

And a relevant WT Type VA with the following settings:

You run transaction FK02 to insert the relevant WT type VA and WT code VA, into the vendor master data 100298.

Now You run the report RFWT0020, using the following details, first in Test mode then live

Following the result of the report:

The invoice will contain the WT data after running the report

Report RFWT0010

 

Purpose

Extended withholding tax is active in your company code (field T001-WT_NEWWT is set) and you have open vendor or customer items in your system.

The "relevant withholding tax types" change, for example, as a result of legal changes. 

Overview

1. By FK01, You create the Vendor number 100320, with the following WT information

2. You post an invoice by FB01, and the System will report, into the WT pop up, the WT type defined into the master data

3. For legal reason, You have to change the relevant WT type from SE to SS

5.The report RFWT010 will change the WT type SE, adding the new WT type SS

6. The final result will be:

The report RFWT0010 will insert, into the “Note” of the WT pop up, that the WT type SE is no longer relevant.

Therefore You can pay the invoice with the correct relevant WT type SS

Migrate your data with DMC Tools : successor of LTMC & LSMW

 

Migrate your data with DMC: successor of LTMC & LSMW

Data Migration Cockpit (DMC) in SAP is a tool within the SAP system that is used to migrate data from Legacy data system into the SAP S/4 HANA system.

The DMC in SAP S/4HANA offers a user-friendly interface for managing various aspects of the data migration process, including data mapping, upload, and error handling. It aims to simplify and accelerate the migration of business data.

Users can use the DMC to define mapping rules, execute data migration activities, monitor the progress of migrations, and handle any errors that may occur during the process.

Evolution of Data Migration tool over time by SAP

LSMW (Legacy System Migration Workbench) - In S/4 HANA, LSMW was redundant and was not be used anymore. Instead, LSMON (Migration Object Modeler) and LTMC functionality was Introduced.

LTMC (Legacy Transfer Migration Cockpit) -Here ready-made templates were available to upload the data. later, Transaction LTMC was deprecated and now can no longer be used to migrate data to SAP S/4HANA.

DMC (Data Migration Cockpit) - DMC is advanced Version of LTMC in S/4 HANA, SAP came up with this New Tool using Fiori Application to Migrate Data.

Scenario :

Let's try to create the below G/L Accounts in mass for Company Code ADD1.

G/L Text	A/c Type	Account Group	Co.Element	Field Status
Bank Account	X	ASST(100000)	​	YB05
Share Capital	X	LIAB (200000)	​	YB01
Asset Sale	X	REVN(300000)	​	YB29
Salaries Paid	P	EXPN(400000)	01	YB04

Steps to Migrate G/L Master data into SAP system :

( DMC tool in S/4 HANA work with Fiori Application)

STEP 1: To open FIORI launchpad, use Transaction code ui2/flp in SAP GUI screen.

STEP 2: Log on to Fiori with user credentials in the Web Browser.

STEP 3: Search for keyword "Data Migration Cockpit " Application in the Search bar.

STEP 4: Click on create and select Migrate Data using Staging Table to create Migration Project.

STEP 5: Provide name to Create New Project.

STEP 6: Select as Local Package and proceed to Step 3.

STEP 7: Choose the migration object based on the data you want to migrate (e.g., customers, vendors, materials) and move the "Migration Objects" to right side which is to be migrated(or to be created) in SAP System and click on Review.

STEP 8: After Review, click on Create Project to Save your New Project.

STEP 9: Go back to the DMC screen, select the New Project and click on arrow below.

Process of DMC Project -

STEP 10: Click on "Download Template" to download Sheet of your Migration Objects fields. The template file with predefined column headers and structures for a specific migration object serves as a guide for organizing data in the correct format before uploading it into the system

STEP 11: Select File type in XML File and click OK (to fill values in Excel Sheet)

STEP 12: Select the Download file and open in MS Excel.

STEP 13: Fill the required fields of Migration object data in the sheets which you want to migrate into system and save.

STEP 14: Click on "Upload file" to Upload the prepared data files to the Data Migration Cockpit.

STEP 15: Click on upload to select the Saved Excel file.

STEP 16 : Select your Excel file and click on open.

STEP 17 : Click on "Prepare" to create Staging tables.

STEP 18: Select Prepare Staging Tables and bring the data from source tables of migration Objects. Prepare Staging Tables is setting up temporary database tables where data can be initially loaded before being transferred to the final production tables

STEP 19: Select "Mapping Tasks" which shows all values to check & confirm your Data before you migrate it into SAP System.

STEP 20: If no Error or no Changes to be made, Select all Mapping values and Confirm.

STEP 21: Click on OK to proceed to next Step.

STEP 22 : Select "Simulate" to run a simulation to check for any errors or issues that might occur during the actual data load.

STEP 23: Click on Start Simulation

STEP 24: Review the simulation results in monitoring screen and If simulation is successful without errors then proceed to click on "Migrate", last Step of Migration Process where Data Actually gets uploaded into System.

STEP 25: Click on "Start Migration" .

Migration Project "Monitoring" is a screen which shows the Progress and status of project.

The below Project progress show 100% Completed.

Check in S/4 system, as you can see below, the G/L Accounts in screen FS00 is successfully created.

Similarly, you can also migrate any master data and transactional data of other SAP Modules.

.

Thanks