SAP FICO AND HANA - by Ashik: May 2014

NOTICE:

We go about our lives trying to become good...but that is not the point is it...the eternal journey of life is to move from good to great!! - ARUN SHARMA

Its a pleasure for me to be writing this SAP Blog. I am not offending anyone/company by this blog. If anyone is offended, I request to please refrain from viewing this blog as content in this blog cannot be copied and What I write here is all mine!! Anyone who wants to make a conversation will have my full co-operation in FORUM page. FORUM page loads perfectly in Google CHROME but not in Mozilla Firefox, I don't know any exact reason. So, THIS BLOG MUST BE VIEWED IN CHROME.

This blog is for studying SAP modules like FI, CO and HANA. This is a tutorial blog which is created with lot of enthusiasm and interest. Posts are divided in to labels 'FICO' and 'HANA'. Please refrain from bringing outside stuff beyond SAP world into this blog as part of your comments.SAP is an OCEAN and I would like to suggest that reader must have blood levels not just litres or buckets but OCEANS to learn SAP.

Labels are done as per the following:
FI - Financial Accounting Basic Concepts
FICO - SAP FICO COnfiguration and Implementation
FICO SUPP - Supporting documents on SAP Configuration
HANA - SAP HANA Tutorial


Wednesday, May 14, 2014

Adjusting the Accounts

In this Unit, we need to understand and work on one of the basic financial equation

NET INCOME = REVNEUES - EXPENSES

And sometimes most companies will find it difficult to determine the time period of a transaction as some transactions will go on and on and some transactions will not happen at right time. This gives nightmare to value the transaction and at what time period to report the transaction. Due to this type of transactions, accountants must adjust some of important things like postings, trial balance etc. while preparing financial statements

WHAT ARE TIMING ISSUES?

Once, all the transactions are finished then it will be easy to prepare financial statements. But, in real scenario, transaction will not end and sometimes management wants monthly financial statements and also to file tax returns interim financial statements are required. For this complexity, accountants divide the economic life of business into artificial time periods. This is called as time period assumption.

For example, the airplanes purchased by Southwest Airlines five years ago are still in use today. We must determine the relevance of each business transaction to specific accounting periods. (How much of the cost of an airplane contributed to operations this year?)

HOW TIME PERIOD IS DIVIDED AND USED?

Both small and large companies prepare financial statements periodically in order to assess their financial condition and results of operations. Accounting time periods are generally a month, a quarter, or a year. Monthly and quarterly time periods are called interim periods. Most large companies must prepare both quarterly and annual financial statements. An accounting time period that is one year in length is a fiscal year. A fiscal year usually begins with the first day of a month and ends twelve months later on the last day of a month. Most businesses use the calendar year (January 1 to December 31) as their accounting period, some do not. In India, April to March is commonly followed along with many other countries.

WHAT IS DIFFERENCE IN ACCRUAL VS CASH BASIS ACCOUNTING?

Under the accrual basis, companies record transactions that change a company’s financial statements in the periods in which the events occur. For example, using the accrual basis to determine net income means companies recognize revenues when earned (rather than when they receive cash). It also means recognizing expenses when incurred (rather than when paid). So, in Accrual basis accounting companies update the transactions when they recognise expenses or revenues before when they receive or pay the actual cash.

An alternative to the accrual basis is the cash basis. Under cash-basis accounting, companies record revenue when they receive cash. They record an expense when they pay out cash. The cash basis seems appealing due to its simplicity, but it often produces misleading financial statements. It fails to record revenue that a company has earned but for which it has not received the cash. Also, it does not match expenses with earned revenues. Cash-basis accounting is not in accordance with generally accepted accounting principles (GAAP). It is mostly used in small enterprises.

HOW DO COMPANIES RECOGNISE THE VALUE OF SUCH REVENUES AND EXPENSES?

It can be difficult to determine the amount of revenues and expenses to report in a given accounting period when the transaction is not yet finalised. Two principles help in this task: the revenue recognition principle and the expense recognition principle.

REVENUE RECOGNITION PRINCIPLE

The revenue recognition principle requires that companies recognize revenue in the accounting period in which it is earned. In a service enterprise, revenue is considered to be earned at the time the service is performed. To illustrate, assume that Dave’s Dry Cleaning cleans clothing on June 30 but customers do not claim and pay for their clothes until the first week of July. Under the revenue recognition principle, Dave’s earns revenue in June when it performed the service, rather than in July when it received the cash. At June 30, Dave’s would report a receivable on its balance sheet and revenue in its income statement for the service performed.

EXPENSE RECOGNITION PRINCIPLE

Accountants follow a simple rule in recognizing expenses: “Let the expenses follow the revenues.” Thus, expense recognition is tied to revenue recognition. In the dry cleaning example let us consider salaries are paid daily, this means that Dave’s should report the salary expense incurred in performing the June 30 cleaning service in the same period in which it recognizes the service revenue. The critical issue in expense recognition is when the expense makes its contribution to revenue. This may or may not be the same period in which the expense is paid. If Dave’s does not pay the salary incurred on June 30 until July, it would report salaries payable on its June 30 balance sheet.

clip_image001

WHY IS THE NEED FOR ADJUSTING ENTRIES?

The need for adjusting entries is high and depends on the way expense or revenue is being recognised. To make trial balance up to date, adjusting entries must be done for various reasons like below,

  1. Some events are not recorded daily because it is not efficient to do so. Examples are the use of supplies and the earning of wages by employees.
  1. Some costs are not recorded during the accounting period because these costs expire with the passage of time rather than as a result of recurring daily transactions. Examples are charges related to the use of buildings and equipment, rent, and insurance.
  1. Some items may be unrecorded. An example is a utility service bill that will not be received until the next accounting period.

WHAT ARE THE TYPES OF ADJUSTING ENTRIES?

Adjusting entries are classified as either deferrals or accruals. each of these classes has two subcategories.

Deferrals:

  1. Prepaid expenses: Expenses paid in cash and recorded as assets before they are used or consumed.
  2. Unearned revenues: Cash received and recorded as liabilities before revenue is earned.

Accruals:

  1. Accrued revenues: Revenues earned but not yet received in cash or recorded.
  2. Accrued expenses: Expenses incurred but not yet paid in cash or recorded.

HOW ADJUSTING IS DOINE FOR DEFERRALS?

To defer means to postpone or delay. Deferrals are costs or revenues that are recognized at a date later than the point when cash was originally exchanged. Companies make adjusting entries for deferrals to record the portion of the deferred item that was incurred as an expense or earned as revenue during the current accounting period. The two types of deferrals are prepaid expenses and unearned revenues.

Before going into any more inner details let us consider we are using company named PIONEER ADVERTISING COMPANY (PAA) for now.

clip_image002

PREPAID EXPENSES:

Companies record payments of expenses that will benefit more than one accounting period as assets called prepaid expenses or prepayments. When expenses are prepaid, an asset account is increased (debited) to show the service or benefit that the company will receive in the future. Examples of common prepayments are insurance, supplies, advertising, and rent. In addition, companies make prepayments when they purchase buildings and equipment. But as time goes on, the prepaid amount will expire just like monthly rent where at start of each month the previous rent expires. There is no need to write down the expiry of the prepaid amount as an entry unless required.

The Basic rule for adjusting an entry for prepaid expenses results in an increase (a debit) to an expense account and a decrease (a credit) to an asset account.

clip_image003

SUPPLIES::

The purchase of supplies, such as paper and envelopes, results in an increase (a debit) to an asset account. During the accounting period, the company uses supplies. Rather than record supplies expense as the supplies are used, companies recognize supplies expense at the end of the accounting period. At the end of the accounting period, the company counts the remaining supplies. The difference between the unadjusted balance in the Supplies (asset) account and the actual cost of supplies on hand represents the supplies used (an expense) for that period.

On our Example of PAA company, We can see that company purchased supplies costing $2,500 on October 5. Pioneer recorded the purchase by increasing (debiting) the asset Supplies. This account shows a balance of $2,500 in the October 31 trial balance. An inventory account at the close of business on October 31 reveals that $1,000 of supplies are still on hand. Thus, the cost of supplies used is $1,500 ($2,500 - $1,000). This use of supplies decreases an asset, Supplies. It also decreases owner’s equity by increasing an expense account, Supplies Expense. This is shown below,

clip_image004

After the adjustment posting the asset account Supplies shows a balance of $1,000, which is equal to the cost of supplies on hand at the statement date. In addition, Supplies Expense shows a balance of $1,500, which equals the cost of supplies used in October. If Pioneer does not make the adjusting entry, October expenses will be understated and net income overstated by $1,500. Moreover, both assets and owner’s equity will be overstated by $1,500 on the October 31 balance sheet.

INSURANCE:

Companies purchase insurance to protect themselves from losses due to fire, theft, and unforeseen events. Insurance must be paid in advance, often for more than one year. The cost of insurance (premiums) paid in advance is recorded as an increase (debit) in the asset account prepaid insurance. At the financial statement date, companies increase (debit) Insurance expense and decrease (credit) Prepaid insurance for the cost of insurance that has expired during the period.

In our Example of PAA as per the main trial balance shown, Company paid insurance of $600 for an year, if calculated for each month its $50 ($600/12). By the end of each month prepaid insurance decreases by $50 and Insurance expense increases by $50. By the end of year, Insurance Expense covers full amount $600.

clip_image005

DEPRECIATION:

There will be lot of assets in the company and every asset will depreciate. When any tangible object like building, computers, cars, etc are acquired, they are recorded as assets on the acquiring date. Being assets, they will be used until their useful life. By the end of asset's useful life, the value of asset must become zero. This reduction of asset's value periodically is called DEPRECIATION.

The acquisition of long-lived assets is essentially a long-term prepayment for the use of an asset. An adjusting entry for depreciation is needed to recognize the cost that has been used (an expense) during the period and to report the unused cost (an asset) at the end of the period. One very important point to understand: Depreciation is an allocation concept, not a valuation concept. That is, depreciation allocates an asset’s cost to the periods in which it is used. Depreciation does not attempt to report the actual change in the value of the asset. So, an Asset's useful life is normally extended by re-investment and this changes its valuations again. This is why, there is a need for adjustment postings for every asset's depreciation and change in valuation. REMEMBER: CONTRA-ASSET ACCOUNTS ARE TYPE OF ASSET ACCOUNTS BUT IT MUST SHOW THE REDUCTION IN VALUE OF AN ASSET, THIS IS WHY THE ADJUSTMENTS ARE POSTED ON CREDIT SIDE.

For Pioneer Advertising, assume that depreciation on the equipment is $480 a year, or $40 per month. As shown in Illustration 3-7 below, rather than decrease (credit) the asset account directly, Pioneer instead credits Accumulated Depreciation— Equipment. Accumulated Depreciation is called a contra asset account. Such an account is offset against an asset account on the balance sheet. Thus, the Accumulated Depreciation—Equipment account offsets the asset Equipment. This account keeps track of the total amount of depreciation expense taken over the life of the asset. To keep the accounting equation in balance, Pioneer decreases owner’s equity by increasing an expense account, Depreciation Expense.

clip_image006

There are different type of contra asset accounts for each type of asset as shown below are some examples:

  • For Asset: Plant and equipment
    • Contra-asset: Accumulated depreciation (depreciation expense goes to income statement)
    • Contra-asset: Accumulated impairment losses (impairment losses go to income statement)
  • For Asset: Accounts receivables
    • Contra-asset: Allowance for doubtful accounts (bad debts expense goes to income statement)
  • For Asset: Inventory
    • Contra-asset: Allowance for obsolescence (obsolescence expense goes to income statement directly or via COGS)
  • For Asset: Intangible assets (e.g. patents)
    • Contra-asset: Accumulated amortisation (amortisation expense goes to income statement)

Accumulated Depreciation—Equipment is a contra asset account. It is offset against Equipment on the balance sheet. The normal balance of a contra asset account is a credit. A theoretical alternative to using a contra asset account would be to decrease (credit) the asset account by the amount of depreciation each period. But using the contra account is preferable for a simple reason: It discloses both the original cost of the equipment and the total cost that has expired to date. Thus, in the balance sheet, Pioneer deducts Accumulated Depreciation—Equipment from the related asset account, as shown below

clip_image007

In the above illustration $4,960 is called Book Value which is giving the value still left on the asset as per our books. Coming to Valuations, there are 2 types Book Value and Fair Value. We will discuss them later.

UNEARNED REVENUES:

Companies record cash received before revenue is earned by increasing (crediting) a liability account called unearned revenues. Items like rent, magazine subscriptions, and customer deposits for future service may result in unearned revenues. Airlines such as United, American, and Delta, for instance, treat receipts from the sale of tickets as unearned revenue until the flight service is provided. Unearned revenues are the opposite of prepaid expenses. Indeed, unearned revenue on the books of one company is likely to be a prepaid expense on the books of the company that has made the advance payment. For example, if identical accounting periods are assumed, a landlord will have unearned rent revenue when a tenant has prepaid rent. When a company receives payment for services to be provided in a future accounting period, it increases (credits) an unearned revenue (a liability) account to recognize the liability that exists. But, subsequently the company earns revenue by providing the service.

Company will post this payment as Unearned Revenue(liability) in credit section to increase the liability. This liability is the obligation of service the company must give. Once the service is given, the expenses are calculated and remaining amount is transferred to Earned Revenue Account. But, posting daily revenues is not the professional way of Accounting as it will create a mess of account entries daily. In adjustment process, the present value of Liability will be calculated by dividing whole liability as per activity, stage-of-service or time-period. Once liability is calculated up to the present accounting period then posting is done. Posting is done at the end of present accounting period so that it makes easy to do a group of transactions rather than a single transaction daily.

clip_image008

So, directly even though the unearned revenue is turned to revenue in this accounting period, the posting is delayed to end of this accounting period. Typically, prior to adjustment, liabilities are overstated and revenues are understated. The adjusting entry for unearned revenues results in a decrease (a debit) to a liability account and an increase (a credit) to a revenue account.

Pioneer Advertising received $1,200 on October 2 from R. Knox for advertising services expected to be completed by December 31. Pioneer credited the payment to Unearned Service Revenue, and this liability account shows a balance of $1,200 in the October 31 trial balance. From an evaluation of the service Pioneer performed for Knox during October, the company determines that it has earned $400 in October. The liability (Unearned Service Revenue) is therefore decreased, and owner’s equity (Service Revenue) is increased.

clip_image009

At the same time, Service Revenue shows total revenue earned in October of $10,400. Without this adjustment, revenues and net income are understated by $400 in the income statement. Moreover, liabilities are overstated and owner’s equity is understated by $400 on the October 31 balance sheet.

clip_image010

ACCOUNTING ENTRIES FOR ACCRUALS:

The meaning of 'accrue' word is to sum up the money. The second category of adjusting entries is accruals. Prior to an accrual adjustment, the revenue account (and the related asset account) or the expense account (and the related liability account) are understated. Thus, the adjusting entry for accruals will increase both a balance sheet and an income statement account. Talking about Accruals there are Accrued Revenues and Accrued Expenses.

Accrued Revenues:

Revenues earned but not yet recorded at the statement date are accrued revenues. Accrued revenues may accumulate (accrue) with the passing of time, as similar to interest revenue. These are unrecorded because the earning of interest does not involve daily transactions. Companies do not record interest revenue on a daily basis because it is often impractical to do so. Accrued revenues also may result from services that have been performed but not yet billed nor collected, as in the case of commissions and fees. These may be unrecorded because only a portion of the total service has been provided and the clients won’t be billed until the service has been completed. An adjusting entry records the receivable that exists at the balance sheet date and the revenue earned during the period. Prior to adjustment, both assets and revenues are understated. An adjusting entry for accrued revenues results in an increase (a debit) to an asset account and an increase (a credit) to a revenue account.

clip_image011

In October, Pioneer Advertising earned $200 for advertising services that were not billed to clients on or before October 31. Because these services are not billed, they are not recorded. The accrual of unrecorded service revenue increases an asset account, Accounts Receivable. It also increases owner’s equity by increasing a revenue account, Service Revenue, as shown below

clip_image012

The asset Accounts Receivable shows that clients owe Pioneer $200 at the balance sheet date. The balance of $10,600 in Service Revenue represents the total revenue Pioneer earned during the month ($10,000 1 $400 1 $200). Without the adjusting entry, assets and owner’s equity on the balance sheet and revenues and net income on the income statement are understated.

On November 10, Pioneer receives cash of $200 for the services performed in October and makes the following entry.

clip_image013

The company records the collection of the receivables by a debit (increase) to Cash and a credit (decrease) to Accounts Receivable.

clip_image014

ACCRUED EXPENSES:

Expenses incurred but not yet paid or recorded at the statement date are called accrued expenses. Interest, taxes, and salaries are common examples of accrued expenses. Companies make adjustments for accrued expenses to record the obligations that exist at the balance sheet date and to recognize the expenses that apply to the current accounting period. Prior to adjustment, both liabilities and expenses are understated. Therefore, as Illustration 3-16 shows, an adjusting entry for accrued expenses results in an increase (a debit) to an expense account and an increase (a credit) to a liability account.

clip_image015

Let's look at different types of Accrued Expenses

Accrued Interest:

Pioneer Advertising signed a three-month note payable in the amount of $5,000 on October 1. The note requires Pioneer to pay interest at an annual rate of 12%. The amount of the interest recorded is determined by three factors: (1) the face value of the note; (2) the interest rate, which is always expressed as an annual rate; and (3) the length of time the note is outstanding. For Pioneer, the total interest due on the $5,000 note at its maturity date three months in the future is $150 ($5,000 X 12% X 3/12—), or $50 for one month.

clip_image016

the accrual of interest at October 31 increases a liability account, Interest Payable. It also decreases owner’s equity by increasing an expense account, Interest Expense. Interest Expense shows the interest charges for the month of October. Interest Payable shows the amount of interest the company owes at the statement date. Pioneer will not pay the interest until the note comes due at the end of three months. Companies use the Interest Payable account, instead of crediting Notes Payable, to disclose the two different types of obligations—interest and principal—in the accounts and statements. Without this adjusting entry, liabilities and interest expense are understated, and net income and owner’s equity are overstated.

clip_image017

Accrued Salaries and Wage:

Companies pay for some types of expenses, such as employee salaries and wages, after the services have been performed. Pioneer paid salaries and wages on October 26 for its employees’ first two weeks of work; the next payment of salaries will not occur until November 9. As shown below,

clip_image018

three working days remain in October (October 29–31). At October 31, the salaries and wages for these three days represent an accrued expense and a related liability to Pioneer. The employees receive total salaries and wages of $2,000 for a five-day work week, or $400 per day. Thus, accrued salaries and wages at October 31 are $1,200 ($400 X 3). This accrual increases a liability, Salaries and Wages Payable. It also decreases owner’s equity by increasing an expense account, Salaries and Wages Expense, as shown below;

clip_image019

Pioneer Advertising pays salaries and wages every two weeks. Consequently, the next payday is November 9, when the company will again pay total salaries and wages of $4,000. The payment consists of $1,200 of salaries and wages payable at October 31 plus $2,800 of salaries and wages expense for November (7 working days, as shown in the November calendar X $400). Therefore, Pioneer makes the following entry on November 9.

clip_image020

This entry eliminates the liability for Salaries and Wages Payable that Pioneer recorded in the October 31 adjusting entry, and it records the proper amount of Salaries and Wages Expense for the period between November 1 and November 9.

clip_image021

WHAT IS THE USE OF ACCRUAL ACCOUNTING?

It gives a clear and simple picture to know/forecast the revenues and expenses before they are paid/received. The Chinese government, like most governments, uses cash accounting. It was therefore interesting when it was recently reported that for about $38 billion of expenditures in a recent budget projection, the Chinese government decided to use accrual accounting versus cash accounting. It decided to expense the amount in the year in which it was originally allocated rather than when the payments would be made. Why did it do this? It enabled the government to keep its projected budget deficit below a 3% threshold. While it was able to keep its projected shortfall below 3%, China did suffer some criticism for its inconsistent accounting. Critics charge that this inconsistent treatment reduces the transparency of China’s accounting information. That is, it is not easy for outsiders to accurately evaluate what is really going on. Budget Deficit is a macro-economic subject which connects all the money, markets, and regulations under a single boundary.

WHAT ARE THE RELATIONSHIPS IN ADJUSTING ENTRIES?

Each adjusting entry affects one balance sheet account and one income statement account.

clip_image022

WHAT ARE THE ADJUSTMENT ENTRIES MADE UP TO OCTOBER 31 IN PAA COMPANY?

clip_image023

clip_image024

Once, the trial balance is finalised after the adjustments then adjusted financial statements are produced using trial balance sheet. The Debit and Credit adjustments of the trial balance is shown below,

clip_image025

clip_image026

ARE THERE ANY ALTERNATIVE TREATMENT FOR UNEARNED REVENUES AND PREPAID EXPENSES??

In the case of prepaid expenses, the company debited the prepayment to an asset account. In the case of unearned revenue, the company credited a liability account to record the cash received. Some companies use an alternative treatment: (1) When a company prepays an expense, it debits that amount to an expense account. (2) When it receives payment for future services, it credits the amount to a revenue account.

Prepaid Expenses

Prepaid expenses become expired costs either through the passage of time (e.g., insurance) or through consumption (e.g., advertising supplies). If, at the time of purchase, the company expects to consume the supplies before the next financial statement date, it may choose to debit (increase) an expense account rather than an asset account. This alternative treatment is simply more convenient.

Assume that Pioneer Advertising expects that it will use before the end of the month all of the supplies purchased on October 5. A debit of $2,500 to Supplies Expense (rather than to the asset account Supplies) on October 5 will eliminate the need for an adjusting entry on October 31. At October 31, the Supplies Expense account will show a balance of $2,500, which is the cost of supplies used between October 5 and October 31. But what if the company does not use all the supplies? For example, what if an inventory of $1,000 of advertising supplies remains on October 31? Obviously, the company would need to make an adjusting entry. Prior to adjustment, the expense account Supplies Expense is overstated $1,000, and the asset account Supplies is understated $1,000. Thus, Pioneer makes the following adjusting entry.

clip_image027

clip_image028

After adjustment, the asset account Supplies shows a balance of $1,000, which is equal to the cost of supplies on hand at October 31. In addition, Supplies Expense shows a balance of $1,500. This is equal to the cost of supplies used between October 5 and October 31.

UNEARNED REVENUE:

Unearned revenues become earned either through the passage of time (e.g., unearned rent revenue) or through providing the service (e.g., unearned service revenue). Similar to the case for prepaid expenses, companies may credit (increase) a revenue account when they receive cash for future services. To illustrate, assume that Pioneer Advertising received $1,200 for future services on October 2. Pioneer expects to perform the services before October 31.1 In such a case, the company credits Service Revenue. If it in fact earns the revenue before October 31, no adjustment is needed.

However, if at the statement date Pioneer has not performed $800 of the services, it would make an adjusting entry. Without the entry, the revenue account Service Revenue is overstated $800, and the liability account Unearned Service Revenue is understated $800. Thus, Pioneer makes the following adjusting entry.

clip_image029

And After posting the entry, the accounts looks like,

clip_image030

So, the complete way of entering Adjustment entries are

clip_image031

Monday, May 12, 2014

UNIT-5 (FICO) LSMW


In this Unit, we will look in to LSMW as theory and practise. Theory will be given by slides while Practise will be given by screenshots.

THEORY: 



PRACTISE:

This post is from a famous SAP Consultant, Ravi Shankar Venna. He described whole LSMW process in a very detailed view in one of SCN blog. I just copied it because, no one can give LSMW in any more detailed way. THANKS TO RAVI SHANKAR VENNA for this information.
Legacy System Migration Workbench (LSMW) is handy tool for data uploads. In most of the big projects there is a separate development / data migration team is available. However, at times, it would be responsibility of the functional consultant to load the data such as vendor master, customer master and asset master etc. It would be real handy for a functional consultant to know LSMW (at least recording method) and it would help them to successfully complete the task. Hope this document would help many of our functional consultants, as I am seeing number of questions around LSMW. The simple rule is: Follow this document and practice is for number of times possible, then you will become master.
Go to Transaction Code "LSMW" and follow the following steps:
LSMW_1.png
Give some Unique name for Project, Subproject and Object. Click Create (Shift+F1). Now execute or press CTRL+F8.
LSMW_2.png
Give the description for Project, Sub Project and Object and say OK. Now execute or press CTRL+F8.
LSMW_3.png
Select Maintain Object Attributes and Execute (CTRL+F8)
LSMW_4.png
Click Display / Change (it will make you to change). Select the Radio Button Batch Input Recording. Now click on  “Goto” –
Recordings Overview. Click on Create Recording (Ctrl+F1).
LSMW_5.png
Click OK
LSMW_6.png
Give Required Transaction Code (In this case it is FK01)
LSMW_7.png
Create Vendor or Make changes for Entering Withholding tax details in the Vendor.
LSMW_8.png
Press Enter
LSMW_9.pngC
Press Enter
LSMW_10.png
Click on Save Button.
LSMW_11.png
Recording is saved now. Click on “Default All” Button.
LSMW_12.png
Click
Ctrl+Y, a + will come. With this, you can drag and copy whatever you want.  In case if any field is appearing twice you
need to change the field name by double clicking on that. Otherwise, your uploading will get failed.
Copy
the fileds to an excel file. 
LSMW_13.png
Remove the Blank Rows.
LSMW_14.png
Now the field name and descriptions are in one Column. I.e., “A”. You need to
segregate that. To do that, select Column “A” and Select in Excel “Data” – Text
to Column as shown in the following graph.
LSMW_15.png
Now Select the fixed with and say “Next”.
LSMW_16.png
Select Fixed Width and click next.
LSMW_17.png
Keep columns wherever you want by clicking.
Now say Next and then again say “Finish”. Now all fields and texts are divided into two Columns.
LSMW_18.png
Now copy the fields and texts as shown in the Sheet1 (Ctrl+C)
LSMW_19.png
Go
to Sheet2
Keep
the cursor in the Sheet 2 (A1) and then
Edit,
Paste
Special
Check
in Transpose as shown below and say OK.
LSMW_20.png
Now all your rows will become your columns as shown in the blow Screen.
LSMW_21.png
Now
fill the required details exactly as shown below. You should note that you have
to enter ‘0001 for payment method instead of 0001, since if you straight enter
0001 it will become 1, therefore you must ensure whenever it is starting with
“0” should be preceded with ‘.
LSMW_22.png
Now
select the whole sheet2.
Remove
all grids.
No colors should be there in the sheet.
No letter should be typed in different colors. All are in normal color only.
Keep the columns to “LEFT” Margin.
Now,
Format
=> Cells => Number => General as shown in the following screenshot.
LSMW_23.png
Now say OK.
Now copy the whole Sheet2 and paste it in the Sheet3. Then
delete the header rows as shown below:
LSMW_24.png
Save
this file to your Hard Disk with a simple name. In this case I saved as Vendor.
Now
go to “SAVE AS” in Excel, and
Save
as Text (Tab Delimited) as shown in the above screen shot.
LSMW_25.png
Click on OK button as shown below.
LSMW_26.png
Click on "YES" button as shown below.
LSMW_27.png
Now, Click on "NO" button as shown below.
LSMW_28.png
Press F3 or Click on Back Button.
LSMW_29.png
Now, Click on "YES" to save.
LSMW_30.png
You will reach the below screen.
Again, press F3 or click on back Button.
LSMW_31.png
Click
F4 in the Recording Button, your structure will be populated. In this case it
is “VENDRECO”.
Now click on Save on Ctrl+S to save your recording.
After saving your recording click Back button or press Ctrl+F3 to go back.
LSMW_32.png
Now you will observe that few steps have been disappeared. Only few steps are left
out. This is because of the recording mode that you have been selected. Ideally
there should not be any Idoc related steps should be visible.
Now Step1 is being completed and the system automatically takes you to second step.
Now press CTRL+F8 or Executed.
LSMW_33.png
Click on Display / Change Button or press Ctrl+F1
LSMW_34.png
Now create a Structure by clicking “Create Structure” or Ctrl+F4.
LSMW_35.png
Give Source Structure Name and Description
LSMW_36.png
Your Source Structure Name and Description is shown. Click on Save button
LSMW_37.png
Now Press F3 or Click back button to go back.
Now the second step is completed and system automatically takes you to third step.
Click CTRL+F8 or Press Execute Button, which will take to maintain source fields.
LSMW_38.png
Click on Display / change as shown above OR press Ctrl+F1.
LSMW_39.png
Now press on Table Maintenance as shown above by keeping your cursor on the Source
Structure (in blue color in the above screen shot).
LSMW_40.png
Copy those Fields from Sheet1 and copy it here. (from your excel file)
LSMW_41.png
In case if your fields are came twice in recording, none of the field should be
similar. As already advised that change the field names to different field
names. Whatever, field names that you have changed in the structure should also
appear here. Meaning that in case these fields does not map with your changed
fields in your Structure, uploading will fail.
LSMW_42.png
Enter the Field Type as “C” – Characteristic and Length as 60. If you know the length
enter the exact length. If you do not enter the maximum length 60. You should
not enter the length less than the actual length of the field.
Say “Save”.
LSMW_43.png
Press "Enter". Save the results and Press
F3 or Click on back button to go back.
LSMW_44.png
Now Click Save in this screen and again press F3 to go back.
LSMW_45.png
Now system will automatically takes you to fourth screen.
Click CTRL+F8 or Click on Execute Button.
LSMW_46.png
Select the Structure and click on Display / change button or press Ctrl+F1
LSMW_47.png
Click on Relationship (Ctrl+F4)
LSMW_48.png
Though
it is customary step, you should go to this step. And say OK for the message
that the system has issued. “A source structure is already assigned to target
structure VENDRECO”.
Now press Save and PressF3 or Click on back button to go back.
It will take you to the next screen automatically.
LSMW_49.png
Press CTRL+F8 or Click on Execute Button.
LSMW_50.png
In the above screen, select the structure and then click display / change or (Ctrl+F1).
Again Select the Structure,
LSMW_51.png
Go select the auto filed mapping as showing above in the above screen shot.
LSMW_52.png
Say “OK” with this 50 number screen. Do not make any changes.
LSMW_53.png
Keep on Pressing “Accept Proposal” for all the proposal as shown above.
LSMW_54.png
Your entire field mapping should appear as above. Each field should have four rows as above.
Once it is being completed the system issues a statement that “Auto Field Mapping is completed”
LSMW_55.png
Click Save (Ctrl+S) and go back (F3).
LSMW_56.png
Nothing to do with “Maintain Field Values, Transactions, User Defined Routines”
LSMW_57.png
Now Go to “Specify Files” Screen Manually and press “Ctrl+F8” or Execute Button.
LSMW_58.png
Select the first row and click on Display / change Button.
LSMW_59.png
Now Click on Add Entry “Ctrl+F2” as shown above.
LSMW_60.png
Select the “TEXT (Tab Delimited)” file that you have already created and say Open.
LSMW_61.pngLSMW_62.png
Your file has come and Enter some relevant “Name”
Select “Tabulator” Radio Button and say OK.
LSMW_63.png
Now Save (Ctrl+S) and press F3 or Back Button to go back.
LSMW_64.png
Now the system will take you to next step i.e., “Assign Files”. Press Ctrl+F8 or
press Execute Button.
LSMW_65.png
Select Source Structure (as shown in blue colour above) and press Display / Change
Button (Ctrl+F1).
LSMW_66.png
Click on Assignment  (Ctrl+F2)
Though it is a customary step, you need to visit this step compulsory. The system will
issue a message stating that “A file has already been assigned to source
structure “VENDOR_RECORDING”. Say Ok.
Click on Save (Ctrl+S) and Press F3 or click on back button.
LSMW_68.png
The system will take you to next step i.e., “Read Data”. Click on Execute or Press Ctrl+F8.
LSMW_69.png
Remove the Checks for
Value
Fields -> 1234.56
Date
Value -> YYYYMMDD as shown above. There should not be any check in the above
two check boxes.
Now
Click on Execute (F8)
LSMW_70.png
The system will tell that total 8 records are being read.
Now Click on Back Button or press F3 TWICE, which will take you to initial screen.
LSMW_71.png
Now the system takes you to next step “Display Read Data”
Click on Execute or Press Ctrl+F8.
LSMW_72.png
Here you give the number of lines in your text file and say OK.
LSMW_73.png
Click on Any one row and see whether the fields in SAP and columns in your Text File
are matching.
LSMW_74.png
Once you are satisfied that everything is matching and going fine, press F3 or Click
on Back button TWICE, which will take you to initial screen.
LSMW_75.png
Now you are automatically in “Convert Data” Screen.
PressCtrl+F8 or Click on Execute Button.
LSMW_76.png
Just press F8 or Execute Button.
LSMW_77.png
The following screen will appear. See the screen and press Back Button (F3) twice,
which will take you to initial screen.
LSMW_78.png
Now the system will automatically takes you to “Display Converted Data”.
Press Ctrl+F8 or Click on Execute Button.
LSMW_79.png
Enter the number of lines From 1 to 8 in this case, to see how it is showing in
Converted Data and Say Ok. (Click on Rite Tick).
LSMW_80.png
Click on any one of the converted data line and see how the data is going.
LSMW_81.png
If you are satisfied that everything is going fine, then Click on Go back button
(F3) TWICE, which will take you to initial screen.
LSMW_82.png
You will be automatically taken to “Create Batch Input Session”.
Click Ctrl+F8 or press “Execute” Button.
LSMW_83.png
Select "Keep Batch input Folder(s)?
Just Click on Execute Button (F8).
LSMW_84.png
One Batch input session will be created. The system will state that “1 batch input
folder with 8 transactions created” will be issued. Say OK. (Click Right),
which will take you to initial screen.
LSMW_85.png
Click Ctrl+F8 or Press on Execute Button.
LSMW_86.png
Now you are in SM35 Screen. Select the line that is being created to upload and
press Execute (F8) button as shown above.
LSMW_87.png
Select “Background” Radio Button.
Check in:
Extended log
Expert Mode
Dynpro Standard Size
As shown above and the click on “Process” button.
LSMW_88.png
See the log and click on Line, if there are any problems in your log.
Click on back button (F3) to come out of the session FOUR TIME, which will take you
to Easy Access Screen.
LSMW_89.png
Go to Report
“S_ALR_87012086”
Now You are Viewing the vendor records that you are uploaded. You can also follow
the same steps for Change also.
LSMW_90.png
Please let me know if you have any doubts.