SAP SD to FI Intergration

SD to FI Integration

Insert regions:

SPRO à general settings àset countries àInsert regions

Select new entries button

Give the country: IN (India)

Region: AP;    Description: Andhra Pradesh

Save

Define sales organization

SPRO à Enterprises structure àDefinition àsales & distribution à define, copy, delete check sales organization

Double click on define sales organization

Select new entries button

Sales organization: AMLS

Description: Hyderabad sales organization

Statistics currency: INR

Save (or) (Ctrl + s)

Ignore the warning message, press enter

Name: Hyderabad sales organization

Country: IN (India)

Enter

Select create request button

Short description: SD Customization for AML

Enter

Press enter to saving the request

Define distribution channel

Same path

Double click on define distribution channel

Select new entries button

Distribution channel: AD

Description: Direct sales

Save

Save in your request

Define shipping point:

SPRO à enterprises structure àdefinition àlogistics execution à define, copy, delete, check shipping point.

Double click on define shipping point

Select new entries button

Give the shipping point: AMSH

Description: Hyderabad shipping point

Save

Give the name: Hyderabad shipping point

Country: IN (India)

Enter

Press enter to save in your request

Assign sales organization to company code

SPRO à enterprises structure àAssignment àsales and distribution à Assign sales organization to company code

Select final button

Give the company code: AML

Enter

Select company code: AML

Select assign button

Select: AMLS check box

Enter

Save (or) (Ctrl + s)

Save in your request

Assign distribution channel to sales organization

Same path

Select find button

Give: AMLS

Enter

Select: AMLS

Select: Assign button

Select: AD check box (Direct sales)

Enter & Save

Save in your request

Assign division to sales organization

Same path

Select find button

Give: AMLS

Enter

Select: AMLS

Select: Assign button

Select: A1 (Cement division)

Enter & Save

Save in your request

Set up sales area:

Path:same path

Select find button

Give: AMLS

Enter

Select: AMLS

Select: Assign button

Select: AD check box (Direct sales)

Enter

Keep the cursor on AD

Select: assign button

Select: A1 (Cement division check box)

Enter & Save

Save in your request

Assign sales organization – Distribution channel – plant

Select find button

Give: AMLS

Enter

Select: AMLS

Select assign button

Select AMLP check box

Enter & Save

Save in your request

Define rules by sales area:

SPRO à enterprises structure àAssignment àSales and distribution à Business area account assignment àdefine rules by sales area

Select position button

Give the sales organization: AMLS

Enter

For AMLS select rule 001 (Business area determination from plant/division

Save

Save in your request

Assign shipping point to plant

SPRO à enterprises structure àassignment àlogistics execution à assign shipping point to plant

Select find button

Give: AMLP

Enter

Select: AMLP

Select: Assign button

Select: AMSH (Hyderabad shipping point) check box

Enter & save

Define pricing procedure determination

SPRO à sales & distribution àBasic functions àpricing àpricing control àdefine & Assign pricing procedures

Double click on define pricing procedure determination

Select new entries button

Sales organization: AMLS

Distribution channel: AD (Direct sales)

Division: A1 (Cement division)

Document procedure: A (Standard)

Customer pricing procedure: Select 1 (Standard)

Pricing procedure: Select RVW01 (Standard)

Condition type: Select PRO0 (Price)

Save

Save in your request

Define tax determination rules:

SPRO à Sales & distribution àBasic functions àTaxes àdefine tax determination rules

Select new entries button

Tax country: select IN (India);           sequence: 1

Tax category: Select MWST (Output tax)

Save

Creation of G/L master, sales local own goods (FS00)

Give the G/L account No: 300001

Company code: AML

Select with template button

G/L account No: 300000 (Sales account)

Company code: AML

Enter

Change short text & G/L account long text to: Sales local own goods

Select create/bank/interest tab

Field status group: G029 (Revenue accounts)

Save

Select edit cost element button

Valid from date: 01.04.2006 to 31.12.9999

Enter

Cost element category: 11 (Revenues)

Save

Assignment of accounts for automatic postings:

SPRO à sales & distribution àBasic functions àaccounts assignment/costing à Revenue account determination àAssign G/L accounts (T. Code: VKOA)

Double click on table: 001

Select new entries button

Application area: Select V (Sales & distribution)

Condition type: Select KOFI

Chart of accounts: AML

Sales organization: AMLS

Account assignment group for customer: select 01 (Domestic revenues)

Account assignment group for materials: Select 03 (finished goods)

Account key: select ERL (Sales revenues)

G/L account No: 300001 (Sales local own goods)

Save

Save in your request

Set up partner determination:

            4 types of partners:

SP – Sold to party – fixed – Net modifiable

SH – Ship to party

BP – Bill to party

PY – Payee

Path:SPRO àsales & distribution à Basic functions à partner determination àset up partner determination

Double click on set up partner determination for customer master

Double click on partners function folder

Select: SP (Sold to party)

Double click on account groups – function assignment folder

Select new entries button

Partner function: SP (Sold to party), enter: SH (AML); BP (AML2), PY (AML2)

Account group: AML2 (SD customers for AML)

Enter & Save

Save in your request

Double click on partner’s determination procedures folder

Select new entries button

Give the partner determination procedure: AML

Name: AML (Partner determination procedure)

Save

Ignore the message, press enter

Select: AML

Double click on partner functions in procedure folder

Select new entries button

Give the partner function: SP (Sold to party)

Select not modifiable check box

Select mandatory function check box

Partner function: SH (Ship to party)

Select mandatory function check box

Select: BP (Bill to party); select mandatory function check box

Select: PY (Payee); select mandatory function check box

Save (or) (ctrl + s)

Select back arrow 2 times

Select: AML

Double click on partner determination procedure assignment folder

Select position button

Account group: AML2

Enter

For AML2: Assign AML

Save

Assign shipping points:

SPRO à logistics execution àshipping àBasic shipping functions à shipping point & goods receive point determination àassign shipping points

Select new entries button

Shipping condition: 01 (As soon as possible)

Loading group: 0003 (Manual)

Plant: AMLP

Proposed shipping point: AMSH

Save, save in your request

Creation of customer master: (XD01)

Account group: Select SD customers for AML

Company code: AML

Sales organization: AMLS

Distribution channel: AD

Division: A1

Enter

Give the customer name: VBC Industries Ltd

Country: IN (India)

Region: AP

Select company code data button

Reconciliation A/C: 200110 (Sundry debtors)

Sort key: 031

Select payment transactions tab

Terms of payment: 0001

Select sales area button

Customer pricing procedure: Select 1 (standard)

Select: shipping tab

Delivery priory: Select 02 (Normal)

Shipping conditions: Select 01 (As soon as possible)

Select: Billing document tab

Select: Price determination check box

Inco terms: select EXW (From plant)

Account assignment group: Select 01 (Domestic revenues)

Output tax classification: select 1 (Liable for tax)

Save

Creation of finished goods material master: (MM01)

Give the material no: AMLFG

Industrial sector: Mechanical engineering

Material type: Finished product

Press: select views button

Select: Basic data

Select: Sales: sales Org data1

Select: sales: sales org data2

Select: Sales: general/plant data

Select: MRP

Select: General/plant/data/storage

Select: accounting 1

Select organization levels button

Give the plant: AMLP

Storage location: Hyd

Sales organization: AMLS

Distribution channel: AD

Enter

Give the description: Finished product

Base unit of measurement: Kg

Gross weight: 1000 Grams

Select: Sales: sales organization data1 tab

Division: A1

Tax classification: Select1 (Full tax)

Select: Sales: sales organization to tool tab

Account assignment: select 03 (Finished goods)

Select: sales: general/plant

Availability check: Select KP (No check)

Transportation group: 0003 (Container)

Loading group: 0003 (Manual)

Select: MRP1 tab

MRP Type: Select ND (No planning)

Select: accounting 1 tab

Valuation class: AML2 (Finished products)

Price control: Select S (Standard price)

Standard price: 400/-

Select save button (or) (Ctrl + s)

 Creation of condition types:

Logistics à sales & Distribution àMaster Data àconditions àselect using condition type à Create (VK11)

Give the condition type: PR00 (Price)

Select: Key combination button

Select: Material with release status radio button

Enter

Give the material No: AMLFG

Amount: 500/-

Valid on: 01.04.2006 to 31.03.2007

Save (or) (ctrl +s)

Select back arrow

Give condition type: MWST (Output tax)

Select key combination button

Select domestic taxes radio button

Enter

Give the country: IN (India)

Valid on 01.04.2006 to 31.12.9999

Tax classification customer: 1 (Liable for Tax)

Tax classification for material: 1

Tax code: Select AO

Save

Ignore the message, press enter

Read More

SAP MM- Integration

MM – Integration step

1. Define plant

Path:SPRO àEnterprises structure à definition à logistics àgeneral àdefine, copy, delete, check plant

Double click on define plant

Select new entries button

Give plant: AMLP

Assign factory calendar: A2 (AML Hyderabad factory calendar)

Save

Give the name: AML Hyderabad factory plant

Give the country: IN (India)

Enter

Select create request button

Give the short description: MM Customization for AML

Enter

Press enter to save in your request

Define copy, delete, check division:

Path:same path

Select define, copy, delete, check division

Double click on define division

Select new entries button

Division A1 à Name: Cement division

Save

Save in your request

Maintain storage location:

Path:SPRO àenterprises structure à Definition à Materials management àMaintain storage location

Give the plant: AMLP

Enter

Select new entries button

Give the storage location: Hyd

Give the description: Hyderabad storage location

Save

Save in your request

Maintain purchasing organization:

Path:same path

Select new entries button

Give the purchase organization: AMLR: Raw Material of purchase order

Save

Save in your request

Assign plant to company code:

Path:SPRO àenterprises structure à assignment à Logistics àgeneral àassign plant to company code

Select find button

Give company code: AML

Enter

Select: AML

Select assign button

Select: AMLP check box

Enter

Save (or) (ctrl + s)

Save in your request

Assign business area to plant/valuation area and division:

Path:same path

Select plant/valuation area – Division button

Select new entries button

Plant: AMLP

Division: A1

Give the business area: AMH

Select save (or) (ctrl + s)

Save in your request

Assign purchasing organization to company code:

SPRO à enterprises structure àassignment àmaterials management à assign purchasing organization to company code

Select find button

Give the company code: AML

Enter

Select company code: AML

Select assign button

Select: AMLR check box

Enter

Save (or) (ctrl + s)

Save in your request

Creation of Material group:

Path:SPRO àlogistics general à Material group à create material group

Material group: CHEMICAL

Give the material group description: Chemicals

Save

Creation of purchasing group:

Path:SPRO àmaterials management à purchasing à create purchasing groups

Select new entries button

Purchase group: AML

Description: Raw material purchase group

Save

Save in your request

Maintain company codes for materials management:

Path:SPRO àlogistics àgeneral àmaterial master àbasic settings àmaintain company codes for materials management

Select position button

Give the company code: AML

Enter

For the company code: AML

Give the year: 2006

Give the period: 7

Select ABP check box

ABP à Allow back period postings

Select save button (or) (ctrl + s)

Ignore the warning message

Press enter

Press enter to save in your request

Define attributes of material types:

SPRO à logistics general àmaterial master àbasic settings àmaterial types àdefine attributes of material types

Select material type: ROH (Raw material)

Double click on qty/value updating folder

Select position button

Give the valuation area: AMLP

Enter

For AMLP: select qty updating check box & value updated check box

Save

Save in your request

Select back arrow

Select material type: FERT (Finished product)

Double click on qty/value updating folder

Select position button

Give the plant: AMLP

Enter

For AMLP: select qty updating check box & value updated check box

Save

Set tolerance groups for purchase orders:

Path:SPRO àmaterials management à purchasing à purchase order àset tolerance limits for price variance.

Select: Tolerance key PE & Tolerance key: SE

For company code: 1000

Select copy as button

Change the company code: AML

Press enter

Once the company code to AML for SE

Enter & Save

Save in your request

Set tolerance limits for goods receipt:

Path:SPRO àmaterials management à inventory management & physical inventory àgoods receipt àset tolerance limits

Select tolerance key: B1, B2, &VP for company code 1000

Select copy as button

Change the company code to AML for B1

Enter

Change the company code: AML for B2

Enter

Change the company code: AML for VP

Enter & save

Save in your request

Plant parameters:

Path:Up to inventory management & physical inventory path is same

Plant parameters

Select plant: 1000

Select copy as button

Give the plant: AMLP

Enter & Save

Save in your request

Maintain default values for tax codes:

Path:SPRO àmaterials management à logistics invoice verification àincoming invoice àmaintain default values for tax codes

Select new entries button

Company code: AML

Select tax code: VO

Save (or) (ctrl + s)

Set Tolerance limits for invoice verification:

Path:SPRO àmaterials management à Logistics invoice verification àinvoice block àset tolerance limits.

Select tolerance key BD

Select tolerance key ST for company code 1000

Select copy as button

Change the company code: AML

Enter

Once again change the Co code to AML for ST

Enter & Save

Save in your request

Define automatic status change

Up to logistics invoice verification the path is same

Invoice verification in back ground àDefine automatic status

Change

Select new entries button

Give the company code: AML

Save

Save in your request

Creation of GL master (FS00)

1.      Inventory raw material local under current assets, loans advance.

2.      In         finished good under current assets, land & advances

3.      GR/IR clearing raw material local under current liabilities & provisions

4.      Increase/decrease finished goods under the group increase/decrease the stocks

5.      Raw material consumption local under raw material consumption group

Use the transaction code: FS00

Give the G/L account No: 200121

Company code: AML

Select with template button

Give the G/L account No: 200120 (Inv. Raw material)

Company code: AML

Enter

Change short text & long text to: Inventory raw material local

Select create/bank/interest tab

Field status group change to G006 (Material accounts)

Select post automatically only check box

Save (or) (ctrl + s)

2)G/L account No: 200122

Company code: AML

Select with template button

Give the G/L account No: 200121

Enter

Change short text & G/L long text to: Inventory finished goods

Save

 3)G/L account No: 100510

Company code: AML

Select with template button

Give the G/L account No: 100500 (Out standing expenses)

Company code: AML

Enter

Change short text & G/L long text to: GR/IR clearing raw material local

Select control data tab

Tax category: * (All tax types allowed)

Select posting with out tax allowed check box

Select create/bank/interest tab

Field status group: G045

Save

4)G/L account No: 300200

Company code: AML

Select with template button

Give the G/L account No: 300100 (Exchange gain)

Company code: AML

Enter

Change the account group to: Increase/decrease in stocks

Change short text & G/L long text to: Increase/decrease in stocks finished goods

Select create/bank/interest tab

Field status group: G030 (Change in stock accounts)

Save

G/L account No: 400000

Company code: AML

Select with template button

Give the G/L account No: 400100 (Salaries account)

Enter

Change the account group to:  Raw material consumption

Change short text & G/L long text to: Raw material consumption local

Select create/bank/interest tab

Field status group: G003

Save

Select edit cost element button

Valid from date: 01.04.2006 to 31.12.9999

Enter

Cost element category: 1

Save

Group together valuation areas:

Path:SPRO àmaterials management à valuation & account assignment àaccount determination à account determination with out wizard àgroup together valuation areas

Select position button

Give the valuation area: AML1

Enter

For valuation area: AMLP – valuation grouping code: X

Save

Save in your request

Define valuation classes:

Path:same path

Select valuation class button

Select valuation class 3000 raw material

Select copy as button

Change the valuation class, class to AML1

Change the description to Raw materials local

Enter

Select valuation class: 7920 (Finished product) check box

Select copy as button

Change the valuation class to AML2

Change the description: finished goods

Enter & save

Save in your request

Configure automatic postings:

Path:same path

Select cancel button

Select account assignment button

Transaction code: 0BYC

Double click on BSX (Inventory postings)

Give the chart of accounts: AML

Enter

Select valuation modifier check box

Select valuation class check box

Save

Valuation modifier: X

Valuation class: AML1

Give the account No: 200121 (Inventory raw material local)

Valuation modified: X

Valuation class: AML2

Account No: 200122

Save

Save in your request

Select back arrow

Double click on WRX (GR/IR clearing)

Select valuation modifier check box

Select valuation class check box

Save

Valuation modifier: X

Valuation class: AML1

Account No: 100510 (GR/IR raw material)

Save

Save in your request

Select back arrow

Double click on GBB (offsetting entry for Inventory postings)

Select general modification check box

Valuation modifier check box

Valuation class check box

Save

Valuation modifier: X

General modification: VBR

Valuation class: AML

Account No: 400000

Valuation modifier: X

General modification: AUF

Valuation class: AML2

Account No: 300200 (Increase/decrease in stock)

Valuation modifier: X

General modification: Z0F

Valuation class: AML2

Account No: 300200

Valuation modifier: X

General modification: VAY

Valuation class: AML2

Account No: 300200

Valuation modifier: X

General modification: VAX

Valuation class: AML2

Account No: 300200

Save

Save in your request

Document types & number ranges: (OBA7)

Select position button

Select document type: WE (Goods receipt)

Select details button

Note down the number range: 50

Select No. range information button

Give the company code: AML

Select change intervals button

Select interval button

No. range: 50;             year: 2006

From no: 800001 to 900000

Enter & Save

Select back arrow 3 times

Select type: WA (goods issue)

Select details button

Note down the number range: 49

Select No. range information button

Give the company code: AML

Select change intervals button

Select interval button

No. range: 49              year: 2006

From no: 900001 to 1000000

Enter & Save

Select back arrow 3 times

Select type: RE (Gross invoice receipt)

Select details button

Note down the number range: 51

Select No. range information button

Give the company code: AML

Select change intervals button

Select interval button

No. range: 51              year: 2006

From no: 1000001 to 1100000

Enter & Save

Creation of vendor master in MM (Path: XK01)

Give the company code: AML

Purchase organization: AMLR

Account group: AML2

Enter

Give the name of the vendor: Reliance industries

Country: In (India)

Select next screen button 3 times

Reconciliation account: 100501

Sort key: 012

Select next screen button

Payment terms: 0001

Select next screen button 3 times

Order currency: INR

Select GR based invoice verification check box

Save

Material master creation:

Path:Logistics àmaterials management à material master à material àcreate (General) àImmediately (MM01)

Give the material No: AMLRM!

Industry sector: Mechanical Engineering

Material type: Raw material

Press select views button

Select: Basic data 1

Select: purchasing

Select: General plan data/storage/ accounting1

Select organization levels button

Give the plant: AMLP

Storage location: Hyd

Enter

Give the description: Raw material 1

Base unit of measurement: Kg

Material group: Chem (Chemical)

Select purchasing tab

Purchasing group: AML (Raw material purchase group)

Select accounting 1 tab

Division: A1 (Cement division)

Valuation class: AML1 (Raw materials local)

Price control: V (Moving average price)

Moving price: 50/-

Total stock: 0

Total value: 0

Save

To open material periods:

Path:Logistics àmaterials management à Material master à other àClose period (T. code: MMPV)

Give the from company code: AML

Period: 8

Fiscal year: 2006

Select check & close period radio button

Execute

Select back arrow

From company code: AML

Period: 9

Fiscal year: 2006

Select check & close period radio button

Execute

Purchase order creation:

Path:Logistics àMaterials management à Purchasing à Purchase order àCreate àVendor/supplying plant known (T. Code: ME21N)

Give the vendor number: 6400001

Purchasing organization: AMLR

Company code: AML

Purchasing group: AML

Item: 10

Material: AMLRM1

P. O. quantity: 100

Net price: 75/-

Plant: AMLP

Save

Note down the P. O. No: 4500014522

Goods receipts:

Logistics à materials management àinventory management à goods movement à Goods receipt àfor purchase order à P. O. No known (T. Code: MIGO)

Give the purchase order No: 4500014522

Enter

Select quantity tab

Quantity in delivery note: 100 Kegs

Select item OK check box

Select where tab

Storage location: Hyd

Save

Display material document:

Path:Logistics àmaterials management à Inventory management à Material document àDisplay (T. Code: MB03)

Enter

Select accounting documents button

Select accounting document number

            Inventory RM local     7500 – AMLRM1 – AML1 (BSX0

             To GR/IR RM local     7500 – AMLRM1 – AML1 (WRA)

Qty in GR * rate as per PO 100 * 75 = 7500

 Invoice verification:

Path:logistics àMaterials management à logistics à Invoice verification àDocument entry àenter invoice (MIRO)

Invoice date: 25.11.2006

Reference party bill no: 5678

Amount: 7500/-

Text: Invoice verification

Select payment tab

Give the base line date: 02/12/2006

Payment terms: 0001

Give the purchase order No: 4500014522

Enter

Save

Ignore the warning message, enter

From the menu select invoice document àdisplay

Select follow on documents button

Double click on accounting document No:

            Reliance industries A/C   Dr   7500 (From purchase order)

                To GR/IR clearing RM local           7500 à AMLRM1 – AML1 (WRX)

Goods issue for consumption:

Path:Logistics àmaterials management à inventory management à goods movement àGoods issue (MB1A)

Give the movement type: 201

Plant: AMLP

Storage location: Hyd

Enter

Give the cost centre: Dept A

Material number: AMLRM1

Qty: 10 kegs

Save

From the menu select goods issue àDisplay

Enter

Select accounting documents button

Select accounting document No

            Inventory RM local 750 (AMLRM1 – AML1 (BSX0

            RM consumption à750 àAMLRM1 – AML1 àGBBVBR

To view material ledger:

Logistics à Materials management àInventory management à environment à stock àstock for posting date (MB5B)

Give the material No: AMLRM1

Company code: AML

Plant: AMLP

Select date: 01.04.2006 to 31.03.2007

Select: value added stock radio button

Execute

Read More