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

*******4th and 5th 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--------------------------------------------------------------

9 comments:

  1. Training in SAP FICO THE CREATING EXPERTS is the one place to get trained and choose your career in SAP courses.

    To take a glance at it click the link provided below

    http://thecreatingexperts.com/sap-fico-training-in-chennai/

    ReplyDelete
  2. yeah, 4/6 weeks/month industrial training in Noida then you should follow this link

    ReplyDelete
  3. yeah great blog about T code on ERP.. if any one looking for Java Android Training in Noida then you can follow the links https://goo.gl/maps/Xvj621YDBuw

    ReplyDelete
  4. It's so nice article thank you for sharing a valuable content. If you are looking for Best sap training institute in hyderabad

    ReplyDelete
  5. Thank you for taking the time to provide us with your valuable information. We strive to provide our candidates with excellent care
    http://chennaitraining.in/solidworks-training-in-chennai/
    http://chennaitraining.in/autocad-training-in-chennai/
    http://chennaitraining.in/ansys-training-in-chennai/
    http://chennaitraining.in/revit-architecture-training-in-chennai/
    http://chennaitraining.in/primavera-training-in-chennai/
    http://chennaitraining.in/creo-training-in-chennai/

    ReplyDelete
  6. I want to learn sap fico can anybody help me out

    ReplyDelete

Most Popular Posts