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 .