Tuesday, August 18, 2009

Transfer posting and Stock transfer


What is Transfer Posting?

When there is a change is stock category or stock number of a material then that change is called as transfer posting.
Example of transfer posting : Unrestricted Stock to Quality Inspection Stock, Material to material.
Transfer posting may or may not involve a physical goods movement.

What is Stock Transfer?

When there is a movement of stock like plant to plant, company code to company code then that movement of stock is called as Stock transfer.

Example of Stock Transfer: Storage location to storage location stock transfer, Plant to plant stock transfer, Company code to company code stock transfer, warehouse to warehouse stock transfer.

Difference between transfer posting and stock transfer:-
The main difference between transfer posting and stock transfer is for stock transfer there is always a goods movement.

Transfer Posting:
Stock to stock
Depending on the usability of a Stock there is three types of stock
1. Unrestricted –use
2. Quality Inspection
3. Blocked




When we need to change the stock type of a material we do the transfer posting. For example at the time of goods receipt the goods may go for a quality inspection. For that period the stock type of that much of material is Quality Inspection. After the quality inspection depending on the quality we post the material to unrestricted stock or blocked stock.

Material to material
In industries like chemical and pharmaceutical it is often needed that we need to transfer the material no. to another because of some changes of the original material master records.




During material to material transfer posting we need to keep some basic things in mind.
1. Basic unit of measure: For both the material the BOM should be same otherwise system does not allow the transfer posting.
2. The transfer posting in done in one step.
3. For posting both the issuing and receiving material must be in unrestricted use.


Business example of transfer posting and solution:-
Example 1: In Plant 0001, storage location 0001 there are Material XYZ in quality inspection stock .The inspection is done and now the business need the stock as unrestricted use stock.
Solution:

Prerequisite – You must have enough stock of material XYZ in your storage location as Quality Inspection stock.

1. Type MIGO in the command field and press enter.
2. In the first dropdown choose transfer posting.
3. In the second dropdown choose other and press enter.
4. Check the movement type at the right corner .If it is not 321 make it 321 as 321 movement type is used to transfer stock form block to unrestricted.
5. In the transfer tab under Dest in material field give material no XYZ, in Plant field give plant 0001, in storage location field give 0001 and press enter.
6. Select the quantity tab by clicking on quantity.
7. In Qty in unit of entry field give the quantity
8. Check the Item Ok check box
9. Now press F7 or click on Check Box in the upper left of the screen .If the document is ok you will get a message in the bottom part of the screen like “Document is O.K”
10. Click on Post button right beside the check button.

Now to check your stock
1. Type MMBE in the command field and press enter.
2. Give XYZ in material field, 0001 in plant filed and 0001 in Storage Location field.
3. Press F8.


Exercise of transfer posting:
1. In one of your material some defects have been found. Transfer some of the material to Quality Inspection stock.
2. You have two materials with same unit of measure. One is a good quality material (material A) and another is a poor quality material (material B).After some time 10 of good quality materials become poor due to some defects . Now you have to transfer those 10 good quality materials to poor quality material.
(Hint: Create two material, use movement type 309)

Stock Transfer
In stock Transfer we transfer some material from one organizational level to another .So for that we have two procedures.
• Two step procedure: Here we issue the goods from one organizational level in 1st step and in 2nd step we receive the goods in another organizational level.
• One step procedure: Here issue and receipt is done at once.

Storage location to storage location – one step
Few facts about storage location to storage location stock transfer
1. It is done within the same plant.
2. One material document is generated.
3. Generally no accounting document is generated. Accounting document is only generated if the material is split valuated and valuation type changes in the process of stock transfer.

Storage location to storage location –Two step
1. Goods are first issued in the issuing plant.
2. As soon as goods issue is done from issuing storage location instead of going to unrestricted stock of receiving storage location it goes to Stock in transfer.
3. In the second step goods receipt is done in the receiving storage location to transfer the stock from stock in transfer to unrestricted use.

Plant to plant stock transfer
1. Material Document is created during plant to plant transfer.
2. Accounting document is only created if the plants are assigned to different valuation areas.
3. If the plants belongs to different company codes then two accounting document is generated.

Plant to Plant stock transfer: One step procedure
Only one material document is generated.

Plant to Plant stock transfer: Two step procedure
1. Two material documents are generated.
2. Material is issued from one plant to another plant. After issuing the material it comes to the receiving plant as stock in transit material.
3. After issuing the material goods receipt is done and the material in stock in transit becomes unrestricted stock in receiving plant.

Business example of transfer posting and solution:-
Example 1: In your plant 1000 material XYZ exists in both 0001 and 0002 storage location. In storage location 0001, 100 quantity of material XYZ exists. Business needs to transfer 10 of those 100 materials from storage location 0001 to 0002.

Solution: one step procedure
1. Type MB1B in the command field and press enter.
2. Fill the fields as Movement Type : 311 , Plant 1000 , Storage Location : 0001
3. Press enter
4. In Recv. SLoc field enter 0002
5. In the 1st line item in material field give material no XYZ , in quantity field give 10 , enter basic unit of measure in BUN field and press enter .
6. Save the document. Note down the generated Material document no.
Optional:
1. Check the Material document using TCODE MB03
2. Check the stock using TCODE MMBE .

Exercise of Stock Transfer:
Exercise 1: In your Company code 1000 material XYZ exists in both 0001 and 0002 plants. In plant 0001, 100 quantity of material XYZ exists. Business needs to transfer 10 of those 100 materials from plant 0001 to 0002.
(Hint : For one step use movement type 301 , for two step procedure 1st issue the goods from issuing plant using Movement type 303 and then receive the goods in receiving plant using movement type 305 )











Monday, August 17, 2009

SAP Tables - Plant maintenance (PM)


12 Plant maintenance (PM)
IHPA Plant Maintenance: Partners
OBJK Plant Maintenance Object List
ILOA PM Object Location and Account Assignment
AFIH Maintenance order header
Human resources
12.1 Settings
T582A Infotypes: Customer-Specific Settings
12.2 Master data
T527X Organizational Units
T528T Position Texts
T554T Attendance and Absence Texts
T501 Employee group
T503 Employee group, subgroup
T503K Employee subgroup
T510N Pay Scales for Annual Salaries (NA)
T549A Payroll Accounting Areas
T750X Vacancy
12.3 Infotypes
PA0001 Org. Assignment
PA0002 Personal Data
PA0006 Addresses
PA0007 Planned Working Time
PA0016 Contract elements
PA0008 Basic pay
PA0105 Communications
PA1007 Vacancies
PA1035 Training
PA2001 Absences

SAP Tables - Project system (PS)

11.1 Basic data
PRHI Work Breakdown Structure, Edges (Hierarchy Pointer)
PROJ Project definition
PRPS WBS (Work Breakdown Structure) Element Master Data
RPSCO Project info database: Costs, revenues, finances
MSPR Project stock
11.2 Equipment
EQUI Equipment master data
EQKT Equipment short text
EQUZ Equipment time segment

SAP Tables - Production Planning (PP)

10.1 Work center
CRHH Work center hierarchy
CRHS Hierarchy structure
CRHD Work center header
CRTX Text for the Work Center or Production
CRCO Assignment of Work Center to Cost Center
KAKO Capacity Header Segment
CRCA Work Center Capacity Allocation
TC24 Person responsible for the workcenter
10.2 Routings/operations
MAPL Allocation of task lists to materials
PLAS Task list - selection of operations/activities
PLFH Task list - production resources/tools
PLFL Task list - sequences
PLKO Task list - header
PLKZ Task list: main header
PLPH Phases / suboperations
PLPO Task list operation / activity
PLPR Log collector for tasklists
PLMZ Allocation of BOM - items to operations
10.3 Bill of material
STKO BOM – header
STPO BOM - item
STAS BOMs - Item Selection
STPN BOMs - follow-up control
STPU BOM - sub-item
STZU Permanent BOM data
PLMZ Allocation of BOM - items to operations
MAST Material to BOM link
KDST Sales order to BOM link
10.4 Production orders
AUFK Production order headers
AFIH Maintenance order header
AUFM Goods movement for prod. order
AFKO Order header data PP orders
AFPO Order item
RESB Order componenten
AFVC Order operations
AFVV Quantities/dates/values in the operation
AFVU User fields of the operation
AFFL Work order sequence
AFFH PRT assignment data for the work order(routing)
JSTO Status profile
JEST Object status
AFRU Order completion confirmations
DRAW Document Info Record
TDWA Document Types
TDWD Data Carrier/Network Nodes
TDWE Data Carrier Type
10.5 Planned orders
PLAF Planned orders
10.6 KANBAN
PKPS Kanban identification, control cycle
PKHD Kanban control cycle (header data)
PKER Error log for Kanban containers
10.7 Reservations
RESB Material reservations
RKPF header
10.8 Capacity planning
KBKO Header record for capacity requirements
KBED Capacity requirements records
KBEZ Add. data for table KBED (for indiv. capacities/splits)
10.9 Planned independent requirements
PBIM Independent requirements for material
PBED Independent requirement data
PBHI Independent requirement history
PBIV Independent requirement index
PBIC Independent requirement index for customer req.


SAP Tables - Quality Management (QM)

9.1 Inspection lot / info record
QALS Inspection lot record
QAMB Link inspection lot - material document
QAVE Inspection usage decision
QDPS Inspection stages
QMAT Inspection type - material parameters
QINF Inspection info record (vendor - material)
QDQL Quality level
QDPS Inspection stages
9.2 Quality notification
TQ80 Notification types
QMEL Quality notification
QMFE Quality notification – items
QMUR Quality notification – causes
QMSM Quality notification – tasks
QMMA Quality notification – activities
QMIH Quality message - maintenance data excerpt
9.3 Certificate profile
QCVMT Certificate profile characteristic level: texts
QCVM Certificate profile characteristic level
QCVK Certificate profile header

SAP Tables - Warehouse Management (WM)

8.1 Transfer requirement
LTBK Transfer requirement - header
LTBP Transfer requirement - item
8.2 Transfer order
LTAK Transfer order - header
LTAP Transfer order - item
8.3 Master data - stock positions
LQUA Quants
8.4 Inventory documents in WM
LINK Inventory document header
LINP Inventory document item
LINV Inventory data per quant

SAP Tables - Material Management (MM)

7.1 Material document
MKPF material document
MSEG material document (item level)
7.2 Purchasing
EKKO Purchase document
EKPO Purchase document (item level)
EKPV Shipping-Specific Data on Stock Tfr. for Purch. Doc. Item
EKET Delivery schedule
VETVG Delivery Due Index for Stock Transfer
EKES Order Acceptance/Fulfillment Confirmations
EKKN Account assignment in purchasing
EKAN Vendor address purchasing
EKPA Partner functions
EIPO Item export / import data
EINA Purchase info record (main data)
EINE Purchase info record (organisational data)
EORD Source list
EBAN Purchase requisition
EBKN Purchase Requisition Account Assignment

SAP Tables - Sales and Distribution (SD)


6 Sales and Distribution (SD) :
VBFA Document flow (alg.)
VTFA Flow shipping documents
6.1 Sales order :
VBAK Header data
VBAP Item data
VBPA Partners in sales order
VBKD Sales district data
VBEP Data related to line items, delivery lines
6.2 Billing document :
VBRK header data
VBRP Item data
6.3 Shipping :
VTTK Shipment header
VTTP Shipment item
VTTS Stage in transport
VTSP Stage in transport per shipment item
VTPA Shipment partners
VEKP Handling Unit - Header Table
VEPO Packing: Handling Unit Item (Contents)
6.4 Delivery :
LIKP Delivery header
LIPS Delivery item
6.5 Pricing :
KONH Conditions header
KONP Conditions items
KONV Procedure ( billing doc or sales order)
KOND
6.6 contracts :
VEDA Contract data





Saturday, August 15, 2009

SAP Tables - FI/CO

5.1 FI :
5.1.1 Master data
• SKA1 Accounts
• BNKA Bank master record
5.1.2 Accounting documents
• BKPF Accounting documents
• BSEG item level
• BSID Accounting: Secondary index for customers
• BSIK Accounting: Secondary index for vendors
• BSIM Secondary Index, Documents for Material
• BSIP Index for vendor validation of double documents
• BSIS Accounting: Secondary index for G/L accounts
• BSAD Accounting: Index for customers (cleared items)
• BSAK Accounting: Index for vendors (cleared items)
• BSAS Accounting: Index for G/L accounts (cleared items)
5.1.3 Payment run
• REGUH Settlement data from payment program
• REGUP Processed items from payment program
5.2 CO :
• TKA01 Controlling areas
• TKA02 Controlling area assignment
• KEKO Product-costing header
• KEPH Cost components for cost of goods manuf.
• KALO Costing objects
• KANZ Sales order items - costing objects
5.2.1 Cost center master data
• CSKS Cost Center Master Data
• CSKT Cost center texts
• CRCO Assignment of Work Center to Cost Center
5.2.2 Cost center accounting
• COSP CO Object: Cost Totals for External Postings
• COEP CO Object: Line Items (by Period)
• COBK CO Object: Document header
• COST CO Object: Price Totals

SAP Tables - Characteristics

4.1 Characteristics
• CABN Characteristics ( o.a. batch/vendor)
• CABNT Characteristics description
• CAWN Characteristics ( o.a. material)
• CAWNT Characteristics description
• AUSP Characteristic Values
4.2 Class types and objects
• TCLAO Several class types for object
• TCLA Class types ( vb. lfa1 => v10 en 010)
• TCLAT Class type text
• TCLT Classifiable objects
• TCLC Classification status
4.3 Links
• INOB Link between Internal Number and Object
• KLAH Class header data
• KSSK Allocation Table: Object (vb.matnr) to Class
• KSML Characteristics for a class (internal number)

SAP Tables -Mater Data

3.1 Material master
• MARA Material master
• MAKT Material text
• MARC Material per plant / stock
• MVKE Material master, sales data
• MARD Storage location / stock
• MSKA Sales order stock
• MSPR Project stock
• MARM Units of measure
• MEAN International article number
• PGMI Planning material
• PROP Forecast parameters
• MAPR Link MARC <=> PROP
• MBEW Material valuation
• MVER Material consumption
• MLGN Material / Warehouse number
• MLGT Material / Storage type
• MPRP Forecast profiles
• MDTB MRP table
• MDKP Header data for MRP document
• MLAN Tax data material master
• MTQSS Material master view: QM
3.1.1 Basic data text (sap script)
• STXB SAPscript: Texts in non-SAPscript format
• STXH STXD SAPscript text file header
• STXL STXD SAPscript text file lines
3.1.2 Batches
• MCHA Batches
• MCH1 Batches
• MCHB Stock : batches
3.2 Customer master data
• KNA1 Customer master
• KNB1 Customer / company
• KNVV Customer sales data
• KNBK Bank details
• KNVH Customer hierarchy
• KNVP Customer partners
• KNVS Shipment data for customer
• KNVK Contact persons
• KNVI Customer master tax indicator
3.3 Vendor
• LFA1 Vendor master
• LFB1 Vendor per company code
• LFB5 Vendor dunning data
• LFM1 Purchasing organisation data
• LFM2 Purchasing data
• LFBK Bank details
3.4 Customer – material info record
• KNMT Customer material info record
3.5 Bank data
• BNKA Master bank data

SAP Tables - Basic data / administration

2.1 Workbench related tables
2.1.1 Data dictionary tables
• DD02L Tables in SAP
• DD02T Tables description
• DD03L Field names in SAP
• DD03T Field description in SAP
2.1.2 Workbench
• TADIR Directory of R/3 Repository Objects
• TRDIR System table TRDIR
• TFDIR Function Module
• TLIBG Person responsible for function class
• TLIBT Function Group Short Texts
• TFTIT Function Module Short Text
• TSTC Transaction codes in SAP
• TSTCT Transaction codes texts
• T100 Message text (vb e000)
• VARID Variant data
• D020T Screen texts
• TDEVC Development class
• TDEVCT Texts for development classes
2.2 Administration
2.2.1 User administration
• USR01 User master
• USR02 Logon data
• USR03 User address data
• USR04 User master authorizations
• USR11 User Master Texts for Profiles (USR10)
• UST12 User master: Authorizations
• USR12 User master authorization values
• USR13 Short Texts for Authorizations
• USR40 Prohibited passwords
• TOBJ Objects
• TOBC Authorization Object Classes
• TPRPROF Profile Name for Activity Group
• DEVACCESS Table for development user
2.2.2 Batch input queue
• APQD DATA DEFINITION Queue
• APQI Queue info definition
2.2.3 Job processing
• TBTCO Job status overview table
• TBTCP Batch job step overview
2.2.4 Spool
• TSP02 Spool: Print requests
2.2.5 Runtime errors
• SNAP Runtime errors
2.2.6 Message control
• TNAPR Processing programs for output
• NAST Message status
• NACH Printer determination
2.2.7 EDI
• EDIDC Control record
• EDIDD Data record
• EDID2 Data record 3.0 Version
• EDIDS EDI status record
• EDPAR Convert External < > Internal Partner Number
• EDPVW EDI partner types
• EDPI1 EDI partner profile inbound
• EDPO1/2/3 EDI partner profile outbound
2.2.8 Change documents
• CDHDR Change document header
• CDPOS Change document positionen
• JCDS Change Documents for System/User Statuses (Table JEST)
2.2.9 Reporting tree table
• SERPTREE Reporting: tree structure
2.2.10 LIS structure/control tables
• TMC4 Global Control Elements: LIS Info Structure

Monday, August 10, 2009

SAP Tables - Customising

1.1 General settings
1.1.1 Countries
• T005 Countries
1.1.2 Currency
• TCURC Currency codes
• TCURR Wisselkoersen
• TCURT Currency name
• TCURX Decimal places for c
1.1.3 Unit of measure
• T006 Units of measure
1.1.4 Calendar functions
• T247 Month names
• TFACD Factory calendar definition
• T015M Month names
• TTZZ Time zones
• TTZD Summer time rules
• TTZDF Summer time rules (fixed annual dates
• TTZDV Summer time rules (variable dates)
• TTZDT Summer time rules texts
• TTZ5 Assign Time Tones to Countries
• TTZ5S Assign time zones to regions

1.2 Enterprise structure
1.2.1 Definition
• FI
• T880 Company
• T001 Company code
• CO TKA01 Controlling area
LO
• T001W Plant / sales organisation
• T499S Locations
• TSPA Division
• SD
• TVKO Sales organisation / company code
• TVTW Distribution channel
• TVBUR Sales office
• TVKBT Sales office text
• TVKGR Sales group
• TVGRT Sales group text
• T171T Sales district text
• MM
• T001L Storage locations
• T024E Purchasing organization
• T3001 Warehouse number
• TVST Shipping point
• TVLA Loading point
• TTDS Transportation

1.2.2 Assignment
CO
• TKA02 Assign company code to controlling area
LO
• T001K Assign plant (valuation area) to company code
SD
• TVKO Sales organisation / company code
• TVKOV Distribution channel / sales organisation
• TVKOS Division to sales organization
• TVTA Sales aria
• TVKBZ Sales office to sales area
• TVBVK Sales group to sales office
• TVKWZ Plants to sales organization
• MM
• T024E Purchasing organization / company code
• T024W Plant to Purchase organization
• T001K Link plant ( = valuation area) / company code
• TVSWZ Shipping point to plant
• T320 Assignment MM Storage Location to WM Warehouse
1.3 Financial accounting
1.3.1 Company code
• T004 Chart of accounts
• T077S Account group (g/l accounts)
• T009 Fiscal year variants
• T880 Global company data
• T014 Credit control area
1.3.2 Fi document
• T010O Posting period variant
• T010P Posting Period Variant Names
• T001B Permitted Posting Periods
• T003 Document types
• T012 House banks
1.4 Not categorized
• T007a Tax keys
• T134 Material types
• T179 Materials: Product Hierarchies
• T179T Materials: Product hierarchies: Tex
• TJ02T Status text
• TINC Customer incoterms
• TVFK Billing doc types
• T390 PM: Shop papers for print control

Creating Purchasing Group

1. Follow the path Materials Management--> Purchasing--> Create Purchasing Groups
2. Click on New Entries, Give purchasing Group No. , Description and other details like telephone no. , Fax No.

Assigning Purchase Organization to Plant

1. Follow the path Enterprise Structure--> Assignment--> Materials Management--> Assign purchasing organization to plant
2. Here assign your Purchasing Organization to your Company Code

Assigning Purchase Organization to Company Code

1. Follow the path Enterprise Structure--> Assignment--> Materials Management--> Assign purchasing organization to company code.
2. Here assign your Purchasing Organization to your Company Code

Creating Purchasing Organization

1. Follow the path Enterprise Structure--> Definition--> Materials Management--> Maintain purchasing organization.
2. Now click on New Entries, Give Purchasing Organization number and description.

Creating Storage Location

1. Follow the path Enterprise Structure--> Definition--> Materials Management--> Maintain storage location.
2. Give your plant number (A storage location can not exist without a Plant. Its why at the time of creation of storage location it will ask the plant for which you want to create the storage location )

Assigning Plant to Company Code

1. Type SPRO in command field and press enter.
2. Click on SAP Reference RMG or press F5
3. Follow the path Enterprise Structure--> Assignment--> Logistics – General--> Assign plant to company code.
4. Here assign the Plant to the intended Company Code

Creating a Plant

1. Type SPRO in command field and press enter.
2. Click on SAP Reference RMG or press F5
3. Follow the path Enterprise Structure --> Definition-->Logistics – General-->Define, copy, delete, check plant-->Copy, delete, check plant
4. Click on Copy as – In From Plant give any standard plant and in To Plant give your Plant number. It will copy all data from standard plant .So you don’t have to maintain much data. But if you don’t want to copy all data from the Standard Plant follow the following path IMG--> Enterprise Structure -->Definition-->Logistics – General-->Define, copy, delete, check plant-->Define Plant. Here you can change your Plant details also , like plant address.

Sunday, August 2, 2009

Creating a Company Code in SAP

1 ) Type SPRO in Command Field and press enter
2 ) Now Click on Sap Reference IMG
3 ) Now goto Enterprise Structure -->Definition-->Financial Accounting--> Edit, Copy, Delete, Check Company Code and click on it .
4 ) Now click on Copy,Delete,Check Company Code.
5 ) Now Click on Copy As and in From Company code field give 0001 (Its a Standard Company Code in SAP ) and in To Company Code field give Z001 , and press enter . Your company code Z001 will be automatically created .