FI - MM Integration

FI-MM Integration

Material Management

 

 

Material Master

Accounting view

Need to enter

 

Valuation class           This is link between MM & FI

                                    Ex: RM-3000

In the Regular process MM People Create: -

(1)   Purchase Requisition

ME51N

(2)   Purchase Order

ME21N

(3)   Purchase Order Release

ME28

For Goods Receipt

                                                            (MIGO)

                        (101 Movement type)

                        RM Inv a/c Dr

                        To GR/IR a/c

           

            [* We cannot directly post transactions to RM Inv a/c]

            There is dummy entry with GR/IR

OBYC

---à

RM A/C Dr To Party A/C

For valuation class 3000 we need to specify GL A/C. System does not know whether it is RM/Packing etc.

If we assign GL A/C then it understands.

BSX

In this process GL A/C will be assigned system takes GL A/C from BSX Process.

WRX

---à

GR/IR A/C

We need to specify one more GL A/C to give Dr & Cr

Invoice verification:

MIRO

Final invoice

GR/IR A/C or To vendor A/C

Vendor No à system takes from P.O

With need to P.O. invoice verification is created.

Goods Issue:

MB1A

There are no of ways

            To -à  product order

                        Internal order

                        Sales order

¨         262 is for goods return

¨         261 Movement type à create this entry internally.

Production order à system understands through Movement type

                                    We are issuing RM to production.

                                    RM consumption a/c Dr To RM a/c

261 à RM Consumption a/c Dr to RM a/c

System takes from BSX process

*. GBB process/VBR (Here we need to specify GL a/c)

MM Head ---à Purchase organization

Basic configuration steps:

(1)          Define / create plant

(2)          Define / Create storage location

(3)          Define / create purchase organization

(4)          Assign plant to company code

(5)          Assign purchase organization to company code

(6)          Assign purchase organization to company code

(7)          Create plant parameters

(8)          Assign company code for material master module

(9)          Valuation group assignments

(10)       Purchase order tolerance Group

(11)       Goods Receipt Tolerance Group

(12)       Vendor specific Tolerance Group

(13)       Table 169P configuration

(14)       Table 169E configuration

(15)       Vendor Master creation (centrally)

(In FI we created vendor account)

Here we need to create keeping in view both MM & FI)

(16)       Material Master creation

Step 1

(1)  Define / Create plant

SPROà Entire. Structureà Definitionà logistics à Generalà Define, coping, Delete, Check plant

Define plant

New entries

Plant 1111

Name         NJ Plant

Address

Title           company

Name         this is for company code

Country     IN

à   SAVE

Each plant has specific calendar. Based on that calendar factory people work on that plant.

      Calendar         101

--à SAVE

(2) Define / Create Storage location             OX09

            SPROàENT. Structureà Definitionà Material Managementà Maintain Storage location

Plant    1111

New entries

            Storage location                                 Description

1000                                                      This is for plant 1111

Enter

1000

Address of storage location

            New entries

                        No

                        99

            Enter

            Title                 company

            Name               for plant 1111

            Country           IN

 SAVE

(3) Maintain Purchase Organization

            SPROà ENT. Structure à Definition à Material Management à Maintain purchase orgn.

New entries

            Purchase orgns                       Desc

1010                                      For co code 1010

Save

(4) Assignment plant to co. code       OX18

            SPROà ENT.Structureà assignment à logistics à General à Assign plant to co. code

            Assign

            NJ Plant

            Save

(5) Assign purchase orgn to co. code:

            SPROà ENT. Structureà Assignment à MMà Assign PO to co. code

Keep cursor on PO

√ Assign

Co. code

Enter save

(6) Assign Purchase Orgn to plant: -

SPROà ENT. Structure à Assignment à MMà Assign P. orgn to plant

Keep cursor on P. orgn

√ Assign

√NJ Plant

Enter Save

(7) Creation of plant parameters.      OM18

SPROà MMà Consu based planningà plant parametersà carrying out overall maintain of plant parameters

Take copy from 0001 plant

Copy

From plant 0001

To plant 1111 & select continue

(8) Assign co code to MM:-

            SPROà Logistics General à MMà Basic settings à Maintain Co. code for Material Management

1010    SAP India 2004           1[enter here 1 allow only April validates only server date]

Enter

In Real Time:-

                        MM PERIOD                                        FI PERIOD

            EVERY MONTH THEY CLOSE

ABP Based on organization requirement. We have to select

If we select this then will allow for back period entries also

i.e. if we are in April we can post March also.

DBP if not required back dated postings tick here.

(9) VALUATION GROUP                      OMWD

SPROà Material Management à Valuation & a/c assign à A/C determination à acct determination with wizard à Group together valuation

            1111                1010                SAP India        1010

Valuation class defining                     à         OMSK

All are inbuilt we need not do anything

Define valuation class

Valuation class                                   a/c category ref

3000                                                                      0001

Material Type A/C      Category:-

            Material type              a/c category

            3 ROH                                      0001

We need to specify Raw Material Type

(10) Define a/c Group for Movement Type: -

            Movement                               a/c Modification

101                                                        press F1 we will get all info

Valuation string WF06

TE KEY

WRX                GR/IR CL.A/C

(Assign as TE key & Val. String)

(11) Movement Type              OMJJ

E.g.: Take 101

We can see the links to various transactions 101 MIGO goods movement

If we select MIGO system understands through this configuration that movement type is 101

(12) PURCHASE ORDER TOLERANCE GROUP:-

SPROà Mat. Management à purchasingà purchase order

Select tolerance limit for price variance

Copy à 0001  PE

            0001    SE

ENTER

CO.CODE.        ……

 

ENTER

CO.CODE         ……

SAVE

(13) GR Tolerance Group: -               OMC0

            SPROà Mat. Management à Inv. Management and physical inventoryà Goods Receipt à Set Tolerance Group

            Copy

1000                      B1

B2

V3

For B1, B2, B3 entry

            Save

(14) Vendor specific TR. Group

            SPROà MMàlogistics Invoice verificationsà incoming invoiceà configure vendor specific Tolerance

1000      Copy

Enter co. code

Enter save

(15)       Table 169P configuration:-

SPROà MMà logistic invoice  verification à invoice verification back groundà define automatic status change

            0001                copy

            Co. code

            Save

(16) 169V configuration: -

            SPROà MMà Logistics invoice verificationà incoming invà maintain default values for tax codes

            Copy

            0001

            Enter co. code

            ……

            Enter save

            Vendor Master

(17) Define Attributes for Material Type: -

            SPROà Logistic General à MM basic settings à Material typesà Define Attributes for Material type

[In live by default it should come]

If we select 3ROH at the time of material master

√3ROH Raw Material

Qty value updation

Valuation area in plant.          Qty updation                           value reqd

            1111                                        √                                             √

Valuation area = plant

(First   √         Material type  (Here 3ROH)

Then    √         Qty / value updation

Then go to plant 1111

Plant √ √ for qty and value updation

From MM

(18) Vendor Master Record Creation                        XK01

SAP EASY Access        à logistics à material management à purchasing à master dataà vendorà centrallyà create XK01

            Vendor                                    Reliance

            Co code                       1010

            Purchase Orgn            1010

            Acct group                   0002

            Enter

            Title                 company

            Name               Reliance

            Country           IN

            ENTER

            ENTER

            ENTER

            Re conciliation a/c     900000

            Cash Management      A1

            Order Currency           INR

            [In real time we should make it mandatory]

           

            Enter

            Enter

            Save

(19) Creating Material Master Record

                                    MM01

SAP Easy Accessà Logistics à Material Managementà Material Master à Materialà create Generalà Immediately   MM01

Industry                      pharmacy

Material type              3ROH RM

√ Select views

            Since RM no sales views available

            If FIG à sales views also available

√ Select all buttons

            A/c      1

            A/c      2

            Costing            1

            Costing            2

            Plant                1111

            Storage location 1010

            Enter

            Material          Raw Material

            Base unit         each                material group            ……

            In Real time 500 to 600 measurements are there.

            Enter

            √   next Screen

(note : Where condition mandatory enter)

            √  MRP1

            VD no planning (within con no RM is Mfg)

            Enter

            Enter

            Forecast Model           constant

Value data

            Enter

            Enter

            Enter

                        Link is established here

Valuation class           3000

Moving price   √  for RM

            ENTER

            ENTER

           

            SAVE

Creation of GL account’s in FI

FS00

(1)  Raw material              a/c no

700000

(2)  RM Consumption

(3)  GR/IR A/C                  700100

RM:

            B/S  a/c

√         post automatically

√         line item

            Sort key          001

 Field status variant G006     Mat a/cs

            Save

GR/IR              A/C:-   B/S      A/C

√ Post Automatically

√ Line item

            Sort key          001

            F.status variant          G045

RM Consumption a/c:-

            P & L a/c

            √ post automatically

            √ line item display.                Sort key          001

            FST.Varient     G003

           

            SAVE

Assignment of BSXGL a/c for MM:                OBYC

SPROà Fin a/cà GL a/cà Business Transactionsà Integrationà Material Managementà Define A/c’sà for Material Management

√ BSX

Chart of a/c’s             ….

Valuation class           √  

            Save

√ accounts

            Enter

Valuation class                       a/c Number

3000                                                      700000

Enter

Save

√  WRX

            [No need to select valuation class. For all Material type à one GR/IR a/c is enough. If client asks we have to create]

                        700100

GR/IR

√  GBB

            General modification  √  

            Valuation Modification √  

            Valuation class           √  

            Save

Value Modification                  Gen Mod          Value class                  a/c

            0001à(defined UR m/m)  VBR          3000                            700200

                        SAVE

Creation of purchase order: -            ME21N

            SAP Easy Accessà logisticsà Material Managementà Purchasingà POà Create

(Up to 4.6c version ME21)

                                   

WE=49             WI=51             WL=50             WN=40

For group        001      vendor Reliance

Purchase Orgn            1010

Co code           1010

Item overview

            Material          Per Qty            Price                Currency

            854                  1                      100                  INR

            ENTER

            PLANT

            Storage location         …..

√ check

To see PO.       ME23

Give     PO no  …..

To see Price: -                        OMX1

√ Line items

SPROàCOà Prod. Costingà Actual costingà activate Material Ledger

If √   not active

Don’t √ then active

Creation of Goods Receipt

MIGOàGOàGR for purchase Order (MIGO)

SAP Easy Accessà Logisticsà Material Managementà Env. Managementà Goods Movementà GR for POà For PO

√ Goods Receipt

√ Purchase Order      ….

            Enter

            Storage location                     for plant

√ Item Ok

√ check

√ post

FBN1

Co code           1010

Change Intervals

Intervals

            No                    Year                From                To

            50                    2004                900000            999999

                                    Save

50        à         No. Range for Doc. Type

            OBA7

Doc no

To see doc

MB03   à         DOC NO           …..

            ENTER

We can see the material document

To see a/c Doc

Put cursor line item

√   a/c Doc

RM A/C           Dr

To GR/IR         A/C

Like this values comes to FI

            MIRO

We can enter GR/IR no PO NO

INVOICE Date             …

            Amt                  1

            PO No              …

            Enter

No range for 51 we have to create

Co code           …

√   ch. interval

            No                    year

            S1                    2004                800000            900000

           

            ENTER

            Save

            Base line date                        immediately

            OBCL

Taxes

            Input Tax code            v0

            Output Tax code         A0

FI-MM:

Link Tax codes is required. There should be an interlink between purchase pricing procedure and Tax Procedure

Invoice Verification:

Only simulated but not saved . Since Tax problem is there

            GR I     A/C      Dr

            To vendor a/c

Issue   of Goods to Order/Cost centers

            Production Order

Goods Issue    MB1A

SAP Easy Accessà logisticsàMaterial Mgmt-à Inv. Managementà Goods Movementà Goods issue

            Movement Type          201

            Plant                            1111

            Storage location         1000

            Enter

            GL A/C                        SAME EXP       à since issue is to cost center

            Cost center     Prod 99          

It will take from our GL

Mat                  Qty                  S.loc

854

create No ranges for 49

MB03

            We can see Doc

20        à Reversal type

To Bring opening Stock:

            Bring balance from legacy to SAP

            (Create same Legacy No 700300)

            B/s a/c

            G006

            √ PO automatically

OBYC

√  GBB

0001    BSA      3000    700300

           

            SAVE

MB1C

            Mov type         501

Enter

            Mat                  Qty

            854

            Save

           

To see Doc

MB03

SAVE

Once pp is activated i.e. settings are made we can issue material to production order

                                    ******************************

FI-SD Settings:

Basic Configuration:

(1)          Create / Define sales organization

(2)          Create / Define Distribution channels

(3)          Create / Define Divisions

(4)          Assign sales organizations to company code

(5)          Assign Distribution channels à Sales Organization

(6)          Assign Division à sales organization

(7)          Setup sales area

(8)          Assign sales organization company code, plant combination

(9)          Create shipping points

(10)       Create loading points

(11)       Assign loading points in Material Master

(12)       Assign shipping points in Customer Master

End user Transactions

(1)       Create customer Master Centrally    XD01

(2)       Create Material Master finished good           [MM01]

(3)       Create sales order      [VA01]

(4)       Create delivery           [VC01]

(5)       Create packing

(6)       Create post goods Issue        [VL02]

            We are issuing finished goods. Cost of Goods sold a/c (GBB/VAX) Dr

(7)       Billing Doc       [VF01]

            To Finished goods from BSX a/c

Need to assign cost of goods sold a/c in OBYC in GBB/VAX

From PO to VL02 only goods Movement

BILLING DOC:

            Separate setting with VKOA

            Here journal entry comes

            VKOA is purely SD configuration

            OBYC is purely MM configuration

Entry for Sales:

            Customer A/c Dr

            To sales a/c

SAP is providing 5 processes in VKOA.

** Need to verify first KOFI for combination, if not found verify KOFK

*******4^th and 5^th pages are not available

(1)  Creation of Sales organization:

SPROà ENT. Structureà Definitionà sales & Distributionà Define, copy, Delete, Check sales orgn.

            √ Define sales orgn

            New entries

            Sales organization      2345

(2)       Define, copy, delete, check Distribution channel

           

            √Define Distribution channel

            New entries

            77                    Save

(3)       Create Division:

            SPROà ENT. Structureà Definitionà Logistics Generalà Define, copy, Delete, Division

            √Define Division

            √New Entries

(4)       Assign Sales orgn to Co code: -

            SPROà ENT. Structureà Assignmentà S & D à Assign sales orgn to Co code

            √ 1010            SAP India

            Assign             2345    sales orgn

                                    √Copy

(5) Assign Dist. Channel to sales orgn: -       DBXK

            SPROà ENT’Sà Assignà Sales & Distà Assign D’ Channel to sales orgn

            Sales orgn       2345

            Assign

            √77 Dist Channel

(6) Assign Division to sales orgn:                  OBXA

            SPROà ESTà Assignà S & Dà Assign Division to sales orgn

(7) Setup sales Area               OBXG

            Config of sales orgn, Dist. Channel, Division

            & Sales area

            SPROà ENT. Structureà Assignà S & Dà Setup sales area

            √2345

            Assign

            √77     D. channel

            √Assign

            √Division

(8)       Assign sales orgn, Dist. Channel and plant: -

            SPROà ENT. Structureà Assignà S&Dà Assign sales orgn, Dist channel, plant

            √ sales orgn

            √ Assign

            √ plant

(9)       Shipping points: -

            SPROà ENT. Structureà Definitionà logistics Executionà Define, copy, Delete, Check shipping à Point.

            Define

            √shipping point

            √New entries

(10) Loading points: -

            SPROà ENT. Structureà Definitionà logistics Execution à Maintain loading point

            Shipping point 1010

            Enter

            New entries

            Loading point

                        20

                        Enter

                        Save

(11)     Assign loading point in Material Master: -

                        MM01

            Material type              finished goods

Enter account information. Once we enter loading group line is established to Material Master & Loading Group.

                        Billing Doc

A/C

            ACC. Assign Group

(12)     Creating sales order               VA01

SAP Easy Accessà Logistics Generalà Logisticsà S & Dà salesà Create

            Order type      …

            Enter

(13) Delivery:             VL01N

            SAP Easy Accessà Logisticsà S & Dà Shipping & Transportationà Outbound deliveryà create single DOC

With

            Packing & packing:                 VL02

(Once we pickup material from stores then packing)

            √post Goods issue

Post the entry

            Cost of goods sold a/c Dr

            To finished Goods a/c

Billing:

            SAP Easy Accessà Logistics à S & D à Billingà Billing Docà Create

            Here we need to enter Delivery Doc.

(** For delivery we need to enter P.O Number)

------------------------****END OF DOCUMENT***------------------------------------------

PP-SETTINGS

(1)          Create order type dependent parameters

(2)          Create BOM

(3)          Create persons for Responsibility in Cost Centers

(4)          Create work center

(5)          Create Routing

(6)          OPJGà Configuration

(7)          OPJKà Configuration

(8)          Create / Define à Scheduling

(9)          Create schedule parameters

(10)       Create confirmation parameters

USER STEPS:

(1)       Creation of production order CO01   à No A/c Entry

(2)       Release production order       CO02   à No A/c Entry

(3)       Issue of Material to production order

            RM consumption A/c Dr (GBB/VBR) to RM A/c (From BSX) 

(4)       Confirmation of production Order      C015

            Once we confirm there is A/c Entry

            Finished goods A/c Dr [BSX]

            To cost of production GBB/AUF [include Material & Material 0H]

(5)       Technically completed production order       C012

(6)       Goods Receipt from shop floor to stores

                        MIGO

(1)          Create Order Type Dependent Parameters: -

SPROà Productionà Shop floorà Master Dataà Orderà Define order types Dependent parameters

      OPL8

Copy          0001

      (All)

√0001

Enter

Plant 1111

Order type                        PP01

      SAVE

(2)          Creation of BOM: -

In BOM we need to specify for the Finished Good à what are the Raw Material req

Create Raw Material              857

MM01

            √Views

            Plant    1111

            Storage 1000

            Enter

            Material 858               Raw Material 2

            Base amt         CA        Material Group           001

            Material class

            MRP     Type    NO

            Fore casting Model     0

            Valuation class           3000

            Save

            Material finished. Finished goods

            √views

            √all

            Plant    1111

            Material Group           001

            Value Check                up

            Valuation class           7920

            Price control   S

            SAVE

Stock: -           to see stock MM03

            Mat No                        854

We can see stock is there or not in stores. We can get no of units, moving avg price

T.C

MBK

Movement type           561

Plant                1111

Enter

1 Mat   858.     100

Enter

Save

Creation of BOM: -                 CS01

SAP Easy Accessà Logisticsà Productionà Master Dataà BOMà Bill of Material à Material BOMà Create             CS01

Material type              FIGNO

Plant    1111

BOM Usage     1          production

                                    Components                Qty

            0010    L          854                              1

            0020    L          858                              1

            Enter

            Save

Creation of personnel for Responsibility in work center: -

SPROà Plant maintain and customer servicesà maintenance plants, work centers, cost lists and PRTsà Work Centerà General Dataà Define Employee Responsible for work Center

            √New entries

Plant                Name

1111                ABC     (Person for 1111)

                        SAVE

One center can have no of work centers.

Creation of work center                     CR01

SAP Easy Accessà Logisticsà Production à Master Dataà Work Centersà Work centerà create

            Plant                1111

            Work center name      ABC

            Work center category            Labor

            Enter

                        Labor Hrs

            Person Responsible    ABC

            Usage  001

            Std value         SAP1

            ENTER

            √Costing

            Cost centers                Prd 99

Setup

Mach. Hrs

Labor Hrs

[** Useful in product costing]

            Save

First create activity type        KL01. Then in activity type mention secondary cost element.

ROUTING        CA01

SAP Easy Access à Logisticsà Productionà Master Dataà Routingsà Routingsà standard Routingsà create

Here we need to give link how many hours required for that plant

                        FINISHED

            Plant    1111

Work center                plant                control key

                                                            PP01

ENTER

√Work center

√√operation

                        √comk             allocation

                        Mat1                Qty

                        Mat2                Qty

                        Save

Create Secondary cost element:

            Sec. Cost Element       77777

            Valid from                   1.4.2004

            Name                           Lab.Hrs

            Cost element category           43

Through this cost element we need to create link between cost centerà cost elementà Routing

                                    ------------------------------

TC        OPJG

WORK CENTER             & ORDER TYPE

Plant    1111

√continue

Control key     PP01

Task list          PC

Usage              1

Dr                    1

Nr                    1

Base qty          1

Work center    ABC LINK and Order type

            Operation        0010

            Save

√         OPJK

Link: Order Type, Material availability check, plant

√ Position

Plant 1111

Need to form link between plants 1111. To different controls. I.e. diff production, process, order types

We need to concentrate on PPO1

Copy from Existing one

√0001

√Copy

Plant 1111

Create / Define Scheduler     (OPK2)

SPROà Productionà Shop floor controlà Master Dataà Define Production scheduling profile

Copy Existing (Minimum 3)

Define Production Scheduler             OPJ9

SPROà Productionà Shop Floor controlà Master Dataà Define Production Scheduler

Plant    1111

Copy Standard 000001

Profile

100

101

depend as client Requirement we need to attach links

Production order & Plant link

Define scheduling parameter for production order

                        OPU3

SPROà Productionà Shop floor controlà operationà schedulingà Define scheduling parameters for production order

Plant    1111

Enter

We need to attach PPO1 Link between plant & standard production order

Define confirmation parameters                    OPK4

SPROà Productionà Shop floor controlà operationsà confirmationà Define confirmation parameters

            Plant                1111

Link between plant and order types for configuration of production order

Otherwise it will not allow for confirming production order

                        New entries

Creation of production order: -

SAP Easy Accessà Logisticsà productionà production controlà Orderà Createà

            COO1  With material

(Verify whether OBYC link is there or not GBB/VBR for RM)

Finished goods            Finished

Plant                            1111

Planning plant 1111

Order type                  PP01

ENTER

Total Quantity             Units               ea

Finish date      …

Enter

Save

[*** There are types of production order.

Co production orderà without quantity

PP Production orderà with quantity

Without giving for production module order can be raised in CO area]

Release Production order: -               Co 02

SAP Easy Accessà Logisticsà Productionà Production controlà Orderà Change

Enter

Order No         …

Enter

Release Button

Save

Issue of Material to Production Order: -                   MB1A

Movement type           261

Plant                            1111

Storage location         …

Enter

Order No         …

Item                Material                      Quantity

1                      858                              1

1                      854                              1

Enter

[Issuing Raw Material to production order]

Save

RM consumption A/c Dr

To RM a/c

Material Doc with above quantity is generated

To see Mat Doc No

                        MB03

Mat Doc No     …

Enter

We can see that Doc. To see a/c Doc

Put cursor on line item

            √√ a/c Doc

            RM consumption A/c Dr

            To RM a/c

OBYC              à GBBà Specified Raw Material Consumption

Confirmation of Production Order: -

SAP Easy Access à Logisticsà Production à production controlà confirmationà Enterà for order     CO15

            Order no          …

√ Final confirmation

Enter

Yet to confirm             5 units

Enter

Save

i.e.       production is completed and a value on shop floor.

In OBYC we need to attach one cost of production a/c

Create cost of production a/c in FS00

P & L A/C

Field status group is               G003

√post automatically

            Save

OBYC

0001                            3000                Cost of production a/c

SPROà Mat mgmtà valuation Assignmentà Acct Determinationà without wizardà Define a/c groups for             typesà acct Determination à Production

We can see/give off setting entries

---------------------------THE END--------------------------------------------------------------