Thursday, September 25, 2008
reconcilliation account
Areconcilliation account is created by t code FS01.
When creating a reconciliation account ,remmeber tht the account must be a balance sheet account ,the account group must be selected as a reconciliation account and the reconciliation account type filed must be entered as vendor.
Ques.Hello Consultants I have a doubt in Reconciliation account. Client has a vendor who is a material vendor as well as service provider Only one reconciliation account is assigned to vendor master and now clients wants to maintain another reconciliation account for Services provided by that vendor (including all service providers) Pls suggest me how i can go for diffrent reconciliation account in one master record.
I would like to know that how we can assign or post multiple recon account to a single vendor code like one vendor has provided services for capex & opex as well as provided material for both category. All categories have different GL (recon account) for balance sheet purpose. For the same we have a option1. That create different vendor codes for different Recon account for a single vendor but Problem in this scenerio: The users have a problem with reconcilliation and unnecessary data in system. 2. If we create a single vendor code, we need to define all the recon account (all four categories) as a alternative recon account butProblem In this: At the time of MIRO we can't change/put the recon account.
Please sugget that how would we customising the same (a single vendor code).
Ans> There are two configurations you need to make. Firstly if you donot have a reconciliation account for services provided, please create one. The only additional setting that you would have to make is that in the GL account master for both your reconciliation accounts you would have to add a tick for the field - "Recon. acct ready for input" in the create/bank/interest tab.Then you need to make a configuration setting in SPRO. Define alternative reconciliation account. The path is below.SPRO->Financial Accounting->Accounts Receivable and Accounts Payable->Business Transactions->Postings with Alternative Reconciliation Account->Define Alternative Reconciliation AccountsThe alternative GL account you should have the Recon account for services. So when you are making a posting (non enjoy transaction) you will see that the reconciliation account appears in the screen and you would be able to choose the recon account you need.
There are two configurations you need to make. Firstly if you donot have a reconciliation account for services provided, please create one. The only additional setting that you would have to make is that in the GL account master for both your reconciliation accounts you would have to add a tick for the field - "Recon. acct ready for input" in the create/bank/interest tab.Then you need to make a configuration setting in SPRO. Define alternative reconciliation account. The path is below.SPRO->Financial Accounting->Accounts Receivable and Accounts Payable->Business Transactions->Postings with Alternative Reconciliation Account->Define Alternative Reconciliation AccountsThe alternative GL account you should have the Recon account for services. So when you are making a posting (non enjoy transaction) you will see that the reconciliation account appears in the screen and you would be able to choose the recon account you need. Hope this helps. Let me know.Also just see if this link helps. I have not seen it but some one forwarded this to me when I gave them a similar solution. May be it will help you.http://www.sap-basis-abap.com/sapfi024.htm.
-In case of vendor i have done the configuration suggested, functionality work perfect in FB60 but in MIRO the G/L account field is still display only. So effectively i am not able to change the account
Wednesday, September 24, 2008
serial number data
A serial number is given to a unique item to identify it and to record information about it.The serial number is differnt from the batch number.Whule ,a batch number is given to a number of items ,a serial number is unique to one.
Serial number profile:- Is created to define an attributes for the serial number.
T code:-OIS2
What is the procedure to implement serial number at the time of doing GR.I want to capture information of quality.For example i ordered a 100kg material and then making a GR in 4 different lots of 25 kg each.For each lot i want to capture packing information which is specific to each lot via serial number.Please guide and what configuration is required
ANS Following are the configuration settings for serial number management in MM.
1. Defining serial number profile(Tcode: OIS2)
2. define default equipment categories for serial numbers(SPRO)
3. Settings for physical inventory
4.deactivate lock for internal number assignment for serial numbers(path: spro/PM and customer service/master data in PM and customer service/ technical objects/serial number management/ deactivate lock for internal number assignment for serial numbers)
Following transactions are useful in the SAP Easy Access:
1. create a material (MM01)
2.Enter a serial number profile in the General plant/data storage 2 view in MM02
3.At time of GR, serial numbers tab appear in the item details of GR.SELECT create serial numbers automatically check box.
4. maintain & display serial number master data (Tcode: IQ08 & IQ09)try with this procedure.
Q. have Created a Finished Product and 2 Raw Materials with the Serial Profile ( Serial Number Management) Activated . Goods issue of Raw material is done for the finished product against a particular production and serial numbers for the raw materials are generated. Serial Numbers for the Finished Product is generated while Goods receipt is done.I Wanted to know whether there is any report to see the rawmaterial (serial Number wise) used to produce the finished product(Serial Number wise). ie Which serial numbered raw material is used for producing a particular serial numbered finished product.
IQ09 gives you the Material & Serial Number Combination..You need to create a SAP query through SQVI. or Z-Report for your requirement, serial numbered raw material is used for producing a particular serial numbered finished product.Using serial numbers, one can very well track their history. It is stored in IQO3. If a material is serially managed, its stock can be seen in MMBE (header data has the option of showing the serial numbers). Using MB03, you can obtain the list of documents & only once u enter those documents you can view the serial numbers. These also get stored in SAP tables.The same can be retreived & reports can be developed.
Some useful table for serial numbers
SER00 Generic table for serial numbers
SER01 Serial numbers assigned to a delivery
SER02 Serial numbers assigned to a guarentee
SER03 Serial numbers assigned to a material document
SER04 Serial numbers assigned to an inspection lot
SER05 Serial numbers for a production order
SER06 Serial numbers for Handling Units
SER07 Serial numbers for Stocktaking
SER08 serial numbers for Orders (SD)
Table EQSE. This is the table for Serial number records.When GR is done serial number is updated in table OBJK u can use this table with relation to GR document then You can see the table SER03 for the material document (field MBLNR). Here you will obtain the object number (SER03-OBKNR). With this number you can check now the table OBJK for the serial numbers
have a scenario where we purchase mobile prepaid cards.These prepaid cards are to be managed by Serial Numbers.I had maintained the Serial number profile for these materials.While doing the GR,it asks for serial number to be entered.We buy prepaid cards in thousands and cant define all individual serial numbers.Is there anyway to maintain the ranges for serial numbers while doing the GR.For ex: 100000000 to 100008000.
Ans.Tcode IQ04
Saturday, September 20, 2008
Material Management Tables
EINA purchasing Info record.
EINE Purchasing Info Record Purchasing Data.
MAKT Material description.
MARA General Material Data.
MARC Plant data for material
MARD Storage location Data for material.
MAST Material to BOM Link.
MBEW Material valuation
MKPF Header Material Document
MSEG Document segment material.
MVER Material consumption.
MVKE Sales data for material.
PKPF document header Reservation
TO23 Material Groups .
TO24 Purchasing groups .
T156 Movement Type
MAKT - Material Text
MSPR - Project Stock
PGMI - Planning material
MPRP - Forecast profiles for Materials
MDTB - MRP table
PROP - Forecast parameters
MSKA - Sales order stock
MDKP - Header data for MRP document
MARM - Units of measure
MAPR - Link MARC PROPMEAN - International article number
MVER - Material consumption
MLGN - Material / Warehouse number
MLGT - Material / Storage type
MTQSS - Material master view Quality Management
MLAN - Tax data material master
Purchasing Tables
EBAN Purchasing requisition.
EBKN Purchase requisition account assignment.
EKBE History per purchasing document.
EKET Scheduling agreement schedule lines.
EKKN Account assignment in purchasing document.
EKKO Purchasing document header.
EKPO Purchasing document Item.
IKPF Header Physical inventory document.
ISEG Physical inventory document items.
LFA1 Vendor master general data.
LFB1 Vendor Master (company Code)
RESB Reservation/Dependent requirement
MARD Storage location data for material.
( Important Fields)
MATNR Material Number (18C CT-MARA).
WERKS Plant (4C CT-MARC)
LGORT Storage location (4C)
LABST Valuated stock with unrestricted use (13 QUAN).
VMLHE Stock in transfer (from one storage location 2
another) (13 QUAN).
VNSHE Stock in quality inspection (13 QUAN)
MSEG Document segment material
(Important Fields)
MBLNR Number of matrial document (10C)
MJAHR Material document year.
ZEILE Item in material document.
MATNR Material number (18C CT-MARA).
WERKS Plant (4C CT-T001W).
KDPOS Item number is sales order(6C).
KDEIN Delivery schedule for sales order.
BUKRS Company code.
T001W Plant /Branches.
(Important Fields)
WERKS Plant
ANME1 NAme (30C).
EKORG Purchase organization (4C CT-T024E).
VSTEL Shipping /Rekieving port (4C).
EKKO Purchasing document header
( Important Fields)
EBELN Purchasing document number.
BUKRS Company code.
BSTYP Purchasing document category (1C).
BSART Purchasing document type (4C).
EKORG Purchasing organiation (4C CT-T024E).
EKGRP Purchasing group (3C CT-T024).
ANGNR Quotation number.
LLIEF Supplying Vendor (10C CT-LFA1).
KUNNR Customer number (10C CT-KNA1).
MEMORY Purchase Order not yet complete(1C).
T001L Storage Locations
(Important Fields)
WERKS Plant .
LGORT Storage location (4C) .
VSTEL Shipping /Recieving point (CT-TVST) .
VKORG SAles Organization (CT-TVKO).
VTWEG Distribution channel (CT-TVTW).
SPART Division (CT-TSPA).
MARC : Plant Data for material.
(Important Fields)
MANDT Client
MATNR Material Number
WERKS Plant
DISPR Material MRP Profile (4C).
DISMM MRP TYpe (2C) .
DISPO MRP Controller (3C).
PRCTR Profit center (10C).
TRAME Stock in transit (QUAN-13).
STLAN BOM Usage (1C).
Material numbering
1)Create their own Naming system
2)System generated
T code :-OMSL
IMG:-Logistics-General . Material master . basic settings. define output format for material Number.
Configuration screen has:-
1)Maximum number length
2) Tempelate field:-If customer decide for automtaic assignment of number than template can be defined in
3)Lexicographical:-Indicator is only relevant for numberic material number,either externally or internally defined.
If indicator are not set than :-12345678 number entered will become 000000012345678 with leading zeroes.
SAP Material Numbers – What, When and Why?
What
The SAP Material Number (8 digits) is the primary master data element of the SAP MM module. It is used to both describe and record history of purchases made. Material Groups (represented by a 4 digit code) are the hierarchical grouping of like materials. The Material numbers, for each unique material, is generated by the SAP system.
Materials are linked to an account code, vendor, price, description and other information needed for the execution of a structured PO using this number.
When creating a purchasing document a material can be searched by its material number, descriptive name or selected from drill down from Material Group name (A wild card character/s can be used in each case). Once selected the Material short text can be amended to more precisely describe the item and unlimited long text is also available.
Material Number
Technical name: 0MATERIAL
Use
The material number uniquely identifies a material in the SAP System.
As a rule, a material master record must exist for each material subject to inventory management within a firm. This record is stored under the material number.
Why do we need these?:
A structured Purchase Order (PO) is the most efficient use of the SAP materials management system. A structured SAP PO is one in which a vendor is identified and an outline agreement is in place within SAP. The material number is the primary linking mechanism within SAP MM. It can reference multiple data sources within SAP and link them to the PO for reference, agreements, vendors, terms, BOM, etc. Setting up a material number is not a simple task, since it can link into a significant number of data sources. The links also must be maintained and the links updated as things change.
Use of materials allows us to get a better picture of what we are purchasing thus allowing strategic purchasing decisions to be taken to get leverage for better prices, terms and conditions from our suppliers by concentrating CP Chems' s purchasing power. Without a material number, the systems allow us merely to report on who we are buying from (who we are paying), it provides no information about what we are buying. Each department will have access to purchasing reports to allow determination of spending patterns of their Purchasing Groups or against Suppliers and Material Groups and materials.
SAP provides the ability to link Supplier Master data to Material Master data through a mechanism SAP calls The Info Record. Literally this contains all the information and history about purchases from a supplier for a specified material. When set up it can be used to evaluate suppliers in terms of price and delivery as well as other defined criteria. It can also be used to hold preferred supply arrangements and can be used for automatic sourcing of requirements.
When
An item should have a material number (and be set up in the system with all the associated data) if the answer is yes to any of the questions below.
Stocked? – is it an item that is kept on hand as per plant policy?
SAP Consignment? – is this item owned by a vendor (often kept at a vendor site) and paid for when used?
BOM? – is it an item or service associated with a piece of equipment, a PM activity or an area Bill of Material (BOM)?
Tracking Needed? – does the detailed purchase history have to be tracked for later analysis?
Critical spare? – is this an item that is critical to the operation?
Capital Spare? – is this a spare part kept in stock but purchased by a capital project.
If the answer to all of these questions is no, then the item should not be set up within SAP with a material number.
Source: SAP Library – Characteristics in Supply Chain Management. http://help.sap.com/saphelp_nw04/helpdata/en/92/b0d3380ea82162e10000000a11402f/frameset.htm
Friday, September 19, 2008
Master Data in MM
-The material Master &
-Vendor master files
These are at the core of procurement,Inventory management and invoice verification.
Material master Tables
The material master transaction is structured so that there are entry screens for different functional information such as purchasing ,sales ,or accounting,but there is also an organizational dimmesnsion to data entry,the material information can be entered at each level of the organization eg at the levels of plant ,storage location or sales organization.
Key Org structure objects used by Materials Management are:
Company (FI)
Plant
Storage Location
Purchase Organisation

(the red crosses indicate links that are not allowed -- see notes below)
Q: Why do we set up SAP Organisational Structures (or SAP Hierarchy)?
It roughly mimic the actual structure of the organisation
Use for reporting purposes, examples:
"What are the current stock levels at storage location 0001?"
"I want to have a Balance Sheet for company 1000?"
Use for authorisation purposes, examples:"We don't want people in plant 1000 to receipt goods related to plant 2000"
Master data is stored per organisational object, example:- Valuation is on plant level, so if same material is in two plants the material will have two accounting views (one per plant)- If the same vendor is used by multiple purchase organisations it will have multiple purchasing views To keep it simple you want minimum amount of SAP Hierarchy objects (companies, plants, storage locations, ...). Example: Don't just create a lot of plants -- always ask why, why, why?
Company Code
Set up on the FI side of SAP.Required if we need to do external financial reporting.All companys must have different codes (company code is 4 characters)
Questions to ask business:
What are the legal entities of the business?
Plant
Used by all Logistics modules (MM, PM, PP, QM, PS,...)Must be link to a company code. (only one)All plants must have different numbers (plant number is 4 characters)
Questions to ask business:
Where are the physical places (storage locations, distibution centres, ..) where materials are handled?
If using SAP PP, where are all the factories?
How does the valuation (prices) of material differ between all these places?
Reporting and authorisation requirements?
Storage Locations
Used by Inventory Management (and Warehouse Management)Part of one Plant.Storage locations within the same plant must have unique number (4 characters)
Questions to ask:
Where are all the physical storage places (warehouses, tanks, ...)
Purchase Organisation:-
A plant must have a purchase organisation (one or more)The link to company code is optional. If a Purchase Organisation is link to a company code, it can only be used by plants within that one company code.
-Contracts / Pricing are done in the purchase organisation.It consists of people (purchasing groups) that manage the purchasing function.Purchasing views in vendor master is per Purchasing Organisation
Questions to ask:
What is company structre of contract negotiators and buyers?
Is the same vendor used by only some buyers? Plants can also be linked to a default Purchase Organisation. This is used for example in "Auto PO create (when doing GR)" functionality, so that the system knows what P.Org to use. This link is only required if these functionalies are used.
