• No results found

st Scenario (Statistical orders) Define order type:

In document 144387809 Sap Controlling Sap Fico (Page 48-83)

Cross company code postings in F

STATISTICAL ORDERS: Example: Telephone orders:

1 st Scenario (Statistical orders) Define order type:

SPRO  Controlling  Internal orders  order master data  define order types (T.

Code: K0T2 _ FUNCAREA)

Select new entries button

Order category: 01 (Internal order (Controlling)) Enter

Give the order type: AMLT

Description: Telephone orders for AML

Planning profile: 000001 (General budget/plan profile) Object class: Select overhead costs

Select release immediately check box Save

It gives the message No. range not processed Ignore the message, press enter

Save in your request

Select Assign/change intervals button beside No. range intervals Double click on AMLT

Select Motor pool A – ZZZZZZZZZZZZ (External check box) From the menu select edit  Assign element group

Creation of field status group making cost centre and internal order mandatory: (T. code: OBC4)

Select field status variant (AML)

Double click on field status groups folder Select G004 cost Accounts

Select copy as button

Change the field status group to G002

Change text to: Cost Accounts (CC & IO) required CC. cost centre & IO (Internal order) Enter & Save

Save in your request

Select G002 and double click

Double click on additional account assignments Select CO/PP order: required entry field

Save

Creation of G/L Account – Telephone expenses: (FS00)

Give the G/L Account No: 400305 Company code: AML

Select with template button

Give the G/L Account No: 400300 (Rent A/C) Company code: AML

Enter

Select create/bank/interest tab

Change the field status group to: G002 Save

Select edit cost element button Valid from 01.04.2006 to 31.12.9999 Enter

Cost element category: 1 Save

Creation of Internal order:

Path: Accounting  Controlling  Internal orders  master data  Special functions

 order  Create (KO01) Give the order type: AMLT Enter

Order: TEL 66626246 (Telephone No) Short text: Telephone No: 66626246 Company code: AML

Business area: AMH Select control data tab

Select statistical order check box Save

One more order type: AMLT Enter

Give the order: TEL 66626247 Company code: AML

Business area: AMH Select control data tab

Save

Creation of order group:

Path: Accounting  Controlling  Internal orders  Master data  Order group 

create (KOH1)

Give the order group name: AML HYD TEL Enter

Give the description: Hyderabad Telephones for AML Select insert order button

Select: TEL 66626246 & TEL 66626247 Save

Posting of transaction in FI: (F – 02)

Give the document date: 13.11.2006 Type: SA

Company code: AML Posting key: 40

Account No: 400305 (Telephone expenses) Enter

Give the amount: 25000 Select cost centre: Dept A

Give the order No: TEL 66626246 Text telephone expenses

Posting key: 50

Account No: 200105 (SBI Current Account) Enter

Amount: ‘*’

Document  Simulate & Save

To view order wise report:

Accounting  Controlling  Internal orders  information system  Reports for Internal orders  line items  Orders: Actual time items (KOB1)

Give the order No: TEL 66626246 Execute

Select the line items Select document button

Planning order wise:

Accounting  Controlling  Internal orders  Planning  Cost and activity inputs  Change (KPF6)

Give the version: 0 From period: 8 To period: 8 Fiscal year: 2006 Order: TEL 66626246

Cost element: 400305 (Telephone expenses) Select from based radio button

Select overview screen button Total plan cost: Enter20000 Save (or) (Ctrl + s)

To variance report order wise:

Path: Accounting  Controlling  Internal orders  Information systems  Reports

for internal orders  Plan/actual comparisons  orders: Actual/plan/variance

(S _ ALR _ 87012993)

Give the controlling area: AML Fiscal year: 2006

From period: 8 To period: 8 Plan version: 0

Give the order value: TEL 66626246 Execute

Real orders:

Creation of secondary cost element called settlement cost element (T. Code: KA06) Give the cost element: 1000001

Valid from: 01.04.2006 to 31.12.9999 Enter

Give the name: Settlement cost element Give the description: settlement cost element

Cost element category: select 21 (Internal Settlement) Save

Creation of field status group making order required

Use the transaction code: OBC4 Select field status variant: AML

Double click on field status groups button Select G002 (Cost Account CC & IO required) Select copy as button

Change the field status group to: G010 Change the text: cost accounts IO required Enter & Save

Save in your request

Select G010 and double click

Double click on additional account assignments Cost centre: make it optional entry

Save

Creation of G/L Account: Petrol expenses (FS00)

Give the G/L Account No: 400306 Company code: AML

Select with template button

Give the G/L Account No: 400300 Company code: AML

Enter

Change short text & Long text to: Petrol expenses Select: Create/bank/interest tab

Field status group: Select G010 Save

Select edit cost element button Enter

Save

Maintain allocation structures:

Path: SPRO  Controlling  Internal orders  Actual postings  settlement 

Maintain allocation structures. Select new entries button Allocation structure: A5

Text: Co allocation structure for AML Save, save in your request

Select: A5

Double click on assignments folder Select: New entries button

Give the assignment: AML Text: Vehicle order settlement Save

Select: AML

Double click on source folder From cost element: 400306 Save

Double click on settlement cost elements folder Select new entries button

Receiver new entries button

Receiver category: Select CTR (Cost centre) Settlement cost element: Select 1000001 Save

Maintain settlement profiles:

Same path

Double click on maintain settlement profiles Select: New entries button

Give the settlement profile name: AML Description: settlement profile for AML Select: To be settled in full radio button Allocation structure: A5

Default object type: CTR (Cost centre) Select: % settlement check box

Select: equalance No. check box Select: Amount settlement check box Under valid receivers

For cost centre: Select settlement required Max No. of dist trials: 999

Residence time: 12

Save & Save in your request

Maintain number ranges for settlement documents Same path: (T. Code: SNUM)

Select maintain groups’ button Double click on AML

Select standard accounting document check box From the menu select edit  Assign element group

Save (or) (ctrl + s)

Define order type: (T. code: KOT2 _ FUNCAREA) Select new entries button

Order category: select 01 (Internal order controlling) Enter

Give the order type: AMLV (Vehicle order type for AML) Settlement profile: Select AML

Budget profile: 000001 (General budget profile) Object class: Select over head costs

Select release immediately check box Save (or) (ctrl + s)

It gives the message No. range not processed Ignore the message, press enter

Save in your request

Select Assign/change intervals button Double click on AMLV

Select Motor pool A – ZZZZZZZZZZZZ check box From the menu select edit  Assign element group Save (or) (ctrl + s)

Assign Co. number range interval for the process KOAO (Actual settlement) Use the T. Code: KANK)

Give the controlling area: AML Select maintain groups button

Double click on KOAO (Actual settlement)

Save

Creation of vehicle order: (T. Code KOO1)

Give the order type: AMLV Enter

Give the order: AP9A1234

Short text: Vehicle No: AP9A1234 Give the company code: AML Business area: AMH

Select control data tab

Deselect statistical order check box Select settlement rule button

Category: Select CTR (Cost centre)

Settlement receiver: Dept A – Percentage: 70% Category: CTR (Cost centre)

Settlement receiver: Dept B – Percentage: 30% Save

Ignore the warning message, press enter

Posting of transaction in FI (F – 02)

Give the document date: 15.11.2006 Type: SA

Company code: AML Posting key: 40

Give the G/L Account No: 400306 (Petrol expenses) Enter

Give the amount: 100000 Give the order: AP9A1234 Text: Petrol expenses Posting key: 50

Account No: 200105 (SBI current account) Enter

Amount: ‘*’

Business area: AMH Text: ‘+’

Document  Simulate & Save

Settlement of internal order to cost centers:

Path: Accounting  Controlling  Internal orders  period end closing  Single

functions  Settlement  Individual processing (K088) Give the order No: AP9A1234

Settlement period: 8 Fiscal year: 2006

Deselect test run check box

Select check transaction data check box Execute

Budgeting and availability control SAP given 2 types of Budget

Plan Budget 1. Plan period wise 1. Budget for year wise 2. We can plan each element

wise 2. Budget for the whole order

3. Micro level 3. Macro level

4. Called availability control

When you posting actual

1. If the budget cross more than 90% of budget a. It gives warning message (or)

b. It gives warning message and inform to budget lead (or) c. Give error message

Number range interval: 04 (Hot coded) Number range is at client level (Client wise)

Define number range intervals for budgeting

SPRO  Controlling  Internal orders  Budgeting & Availability control  Maintain No. ranges for budgeting (T. Code: OK11)

Select change intervals button Select intervals button: No: 04 From: 4000000000 to 4999999999 Enter

Define tolerance limits for availability control Same path

Select new entries button Give the controlling area: AML

Profile: 000001 (General budget profile)

Transaction group: Select ++ (All activity groups)

Action: select 2 (warning with maid to person responsible) Give the usage: 90%

Save (or) (ctrl + s) Save in your request

Specify exempt cost element from availability control (Exempted cost elements from budget)

Same path:

Select new entries button Give the controlling area: AML

Give the C/C No: 400100 (Salaries A/C) Save in your request

Maintain budget manager Same path:

Select new entries button Give the controlling area: AML Order type: AMLV

Object class: Select OCOST (over head) Give the user ID: SAPUSER

Save (or) (ctrl + s) Save in your request

Budgeting:

Accounting  Controlling  Internal orders  Budgeting  Original budget  Change (KO22)

Give the order No: AP9A1234 Select original budget button Give the budget amount: 200000 Enter

From the menu select extras  Availability control  Activate Save

Posting of Transaction in FI (F – 02)

Give the document date: 15.11.2006 Type: SA

Company code: AML Posting key: 40

Give the A/C No: 400306 (petrol expenses) Enter

Give the amount: 90000 Give the order No: AP9A1234 Text: Petrol expenses

Posting key: 50 Account No: 200105 Enter

Amount: ‘*’

Business area: AMH Text: ‘+’

Ignore the message, press enter

To view the inbox of the budget head

SAP menu  Office  Work place (T. code SBWP) Select inbox folder

Double click on the message It gives the message

Capital work in progress line item settlement CWIP _ M/L Freight charges

Installation charges

Define settlement profile

SPRO  Financial accounting  Asset accounting  Transactions  Capitalization of assets under construction  define/assign settlement profile

Double click on define settlement profile

The transaction code is (OK07)

Select settlement profile A1 (settlement assets under construction) Select details button

Select to be settled in full radio button Allocation stock: A1 Co. allocation structure Default object type asset type: FXA

Select percentage settlement check box Select equalance No’s check box Select amount settlement ‘check box’ Under valued receivers for fixed assets Select settlement required

Max No. of distribution rules: 999 Residence time: 12

Save

Select back arrow 2 times

Double click of assign settlement profile to company code Select for company code: AML assign settlement profile A1 Enter & Save

Save in your request

Creation of capital work in progress (Asset master) (T. Code: AS01)

Give asset class: AML 4000 (Capital work in progress) Company code: AML

Enter

Description: C. W. P general Capitalization: 15.06.2006 Select time dependant tab Business area: AMH Select depreciation area tab Dep. Key: 0000

Machinery purchase postings: (T. Code (F – 90)

Give document date: 01.08.2006 Posting date: 01.08.2006

Type: KR

Company code: AML Posting key: 31 Vendor No: 8700001 Enter

Ignore the warning message, press enter Give the amount: 200000

Business area: AMH

Text: Machinery purchase posting

Posting key: 70 Account No: 500000 – 0 Transaction type: 100 Enter Remove TDS codes Enter Amount: ‘*’ Text: ‘+’

Fright payment: (F -02)

Document date: 10.09.2006 Posting date: 10.09.2006 Type: SA

Company code: AML Posting key: 70 Account: 500001 – 0 Transaction type: 100 Enter

Ignore the warning message, press enter Give amount: 25000

Text: Fright payment Posting key: 50

A/C No: 200105 (SBI Current A/C) Enter

Amount: ‘*’

Business area: AMH Text: ‘+’

Creation of machinery asset master (AS01)

Give asset class: AML 2000(Dept A) Company code: AML

Enter

Give description: Machine No: 40 Capitalized on: 14.11.2006

Select time depended tab Business area: AMH Select description area tab Give description key: AML1 Useful life: 20 years

Period: 4

Ordinary depreciation start: 17.11.2006 Save

Settlement of capital work in progress to Asset

Path: Accounting  Financial accounting  Fixed assets  Capitalized asset under

construction  Distribute (T. Code: AIAB) Give company code: AML

Asset: 500001

Sub no: 0  Execute

From the menu select edit  Select  Select all Select enter button

Settlement receiver: 200004 – 0 Give percentage: 100

Select back arrow Save

Select settlement button

Give the asset value dated: 17.11.2006 Text: asset settlement

Deselect test run check box Execute

Go and see the document FB03 Enter

Profit Centre Accounting

- To view profitability product group wise/product wise/location wise/ If business area is not used in FI

1) One location – No. of product groups

Hyderabad

| | | Cement Steels Pharma

In that case you can get profitability. 2) Each location different product group

Hyderabad Bangalore Mumbai ↓ ↓ ↓

Cement Steel Pharma Profitability as well as balance sheet

The advantage of profit centre will be derived through derivation rules.

Revenues – Automatic account assignment In case of balance sheet items through business area We have to create a dummy profit centre

- Transfer to respective profit centre

- We create derivation rules. Future transaction will not go to dummy profit centre.

Set controlling area:

SPRO  Controlling  Profit centre accounting  Basic settings  Set Controlling area

Give controlling area: AML Enter

Maintain controlling area settings:

SPRO  Controlling  Profit centre accounting  Basic settings  controlling area settings  maintain controlling area settings (T. code: OKE5)

Standard hierarchy: AML

Select elimination of internal business volume check box Profit centre local currency type

Select 20 (i.e. controlling area currency) Select confirm button

Select store transactions currency check box Save

Creation of dummy profit centre:

Path: SPRO  controlling  Profit centre accounting  Master data  Profit centre 

create dummy profit centre (T. code: KE59) Double click on create dummy profit centre Give dummy profit centre: AML dummy

Select basic data button Give the name: AML dummy

Description: Dummy profit centre for AML Profit centre group: AML

Save

Set control parameters for actual data

Path: SPRO  Controlling  Profit centre accounting  Basic settings  controlling

area settings  Activate direct postings  set control parameters for Actual data

(T. Code: 1KEE)

Select new entries button From year: 2006

Select line item check box Select on line transfer check box Save

Maintain plan versions

Path: SPRO  Controlling  Profit centre accounting  basic settings  controlling

area settings  activate direct postings  plan versions  maintain plan versions Select version: 0

Double click on settings for profit centre A/C folder Select new entries button

Year: 2006

Select on line transfer check box Select line item check box

ER (Exchange rate): Type: B (Bank setting) Select save button

Save in your request

Define number ranges for local documents

Path: SPRO  Controlling  Profit centre accounting  actual postings  Basic

setting actual  define number ranges for local documents (T. Code GB02) Select maintain groups button

Select actual document from direct posting with GB01 check box From the menu select intervals maintain

Give your company code: AML Enter

Select interval button Year: 2006

From No: 1 to 100000 Enter & Save

Select back arrow

Select planned document from direct posting with GB01 check box From menu select interval maintain

Give your company code: AML Enter

Select interval button Year: 2006

From: 100001 to 200000 Enter & Save

Creation profit centre:

Path: Accounting  Controlling  Profit centre accounting  Master data  profit

centre  individual processing  create KE51 Give the profit centre: Cement

Select master data button

Analysis period 01.04.2006 to 31.12.9999 Give the name: Cement

Long text: Profit centre cement Person response: A

Profit centre group: AML Select activate button Profit centre: STEEL Select master data button Name: Steel

Long text: profit centre steel Person response: B

Profit centre group: AML Select activate button

Assign profit centre in cost centre

Accounting  Controlling  Cost centre accounting  Master data  cost centre  Individual processing  change (T. code: KS02)

Give the cost centre: Dept A Enter

Select save button

Ignore the warning message, press enter Cost centre: Dept B

Enter

Give profit centre: Steel Select save button

Ignore the warning message, press enter

Creation of revenue element – (FS00)

G/L account No: 300000 (Sales account0 Company code: AML

Enter

Select edit cost element button Enter

Cost element category: Select 11 (Revenues) Save

Maintain automatic account assignment of revenue elements

Path: SPRO  Controlling  Profit centre accounting Actual postings  Maintain

automatic assignment of revenue elements (T. Code: OKB9) Select new entries button

Give the company code: AML Cost element: 300000

Account assignment detail

Select AML and then double click on detail per business area/select new entries button

(1)

Hyderabad

| | | Cement Steel Pharma

300000 – Sales cement Hyd  Cement 300001 – Sales steels Hyd  Steels 300002 – Sales Pharma Hyd  Pharma

(2) Hyderabad Bangalore Mumbai Cement Steel Pharma

300000 – Sales

Hyderabad - cement Bangalore – Steel Mumbai – Pharma Give the business area: AMH Give the profit centre: Cement Give the business area: AMB Give the profit centre: Steel Save

Choose additional balance sheet & Profit & Loss A/C

It is applicable only second scenario

Path: Same path

Select choose accounts

Transaction code: 3KEH

Account from: 100000 to 299999 Default profit centre: Cement Save & Save in your request Select profit centre detail button Select create step button

Give the step description: Profit centre derivation for item through Business area Under define name: GSBER (Business area)

Save

Select maintain rule values button Select source field interval on/off button

Note down A/C No: 100000 to A/C No: 299999 Business area: AMH

Give the up due profit centre: Cement From A/C: 100000 to A/c: 299999 Business area: AMB

Profit centre: Steel

Creation of Accounts group

Path: Accounting  Controlling  Profit centre accounting  Master data  Account

group  Create (T. Code KDH1) Give the account group: PL items Enter

Profit & Loss account for AML Select insert accounts button Give account 300000 – 499999

Select back arrow

Next A/C group: BS items Enter

Give the description: Balance sheet account for AML Select insert account button

Give the range 100000 to 299999 Save

Planning profit centre wise for P&L items

Path: Accounting  Controlling  Profit centre Accounting  planning 

Cost/revenues  Change (T. Code 7KE1) Version: 0

From period: 8 to period: 8 Fiscal year: 2006

Company code: AML Profit centre: Cement Account group: PL items Select from based radio button Select overview screen button For A/C No: 300000(Sales)

Profit centre reporting currency: 500000 For A/C No: 400100 (salaries)

Profit centre reporting currency: 400000 Save

Planning for Balance sheet Accounts profit centre wise

Path: Accounting  Controlling  Profit centre accounting  Planning  Balance

sheets accounts  change (T. code: 7KE3) Version: 0

From period: 8 to period: 8 Fiscal year: 2006

Company code: AML Profit centre: Cement A/C group: BS items

Select from based radio button Select overview screen button

For A/C No: 100300 (SBI rupee term loan) Plan: 100000

For account No: 200105 Plan: 100000

Save

Credit sales posting in FI (F – 22)

Give document date: 20.11.2006 Type: DR

Company code: AML Posting key: 01 Account No: 6200001 Enter

Give the amount: 450000 Business area: AMH Text: Credit sales postings Posting key: 50

Account No: 300000(Sales A/C) Enter

Amount: ‘*’

Business area: AMH Text: ‘+’

Document  Simulate

Ignore the warning message, press enter Save (or) ctrl+s

Expenditure posting (F – 02)

Document date: 20.11.2006 Document type: SA

Posting key: 40

Account No: 400100 (salaries A/C) Enter

Give amount: 425000 Cost centre: Dept A Text: Salary payment Posting key: 50

Account No: 200105 (SBI Current account) Enter

Amount: ‘*’

Business area: AMH Text: ‘+’

To view various reports profit centre wise for P&L items

Path: Accounting  Controlling  Profit centre accounting  Information system 

Reports for profit centre accounting  Interactive reporting  Profit centre group  plan/actual/variance

Transaction code: S _ ALR _ 87013326

From period: 8 to period: 8 Fiscal year: 2006

Plan version: 0

Profit centre values: Cement

Profit & Loss account group: PL items Execute

To view variance report profit centre wise for Balance sheet accounts Path: Same path

Transaction code: S _ ALR _ 87013336

From period: 8 to period: 8 Fiscal year: 2006

Plan version: 0

Profit centre values: Cement

Balance sheet account group: BS items Execute

Transfer values from one profit centre to another profit centre

Path: Accounting  Controlling  Profit centre accounting  Actual posting  Profit

centre document  enter (T. Code: 9KE0) Select layout: 8A – 001

Execute

Give the company code: AML Select entry screen button Give profit centre: Cement

Account No: 400100 (salaries A/C) In profit centre local currency: 200000 Save

Integration

Organization structure

Company ↓

In SD: combination of sales organization, distribution channel & division they call at as one sales area.

Movement types: Posting keys in FI

101  Material receipt against purchase order/production 102  Reversal of 101

201  Issue to cost centre (stores of all departments) 202  Reversal of 201

261  Issue to orders (Raw material shows) 262  Reversal of 261

521  Material receipt with out production order 522  Reversal of 521

562  Reversal of 561 601  Delivery 602  Reversal of 601

Process key (Transaction key)

These are system defined keys 1) BSX  Inventory postings

2) WRX  GR/IR clearing (G.R – Goods receipts) (I.R – Invoice receipts) 3) PRD  Price difference/production order differences 4) GBB  Offsetting entry for inventory posting

a) VBR – consumption

In document 144387809 Sap Controlling Sap Fico (Page 48-83)

Related documents