Subscribe

RSS Feed (xml)

Powered By

Skin Design:
Free Blogger Skins

Powered by Blogger

Thursday, July 23, 2009

SAP PP - Define the default components reservation movement type

During order creation, SAP will automatically creates reservations for the components that are kept in stock.

The reservations are assigned a movement type for the material issue with transaction OPKA.

You can control the material issue using the movement type.

Changes are only necessary if you do not wish to use the SAP default setting.

Movement types are predefined in the standard SAP R/3 System.

The default movement types used are:-

Dev. cl. GR GR-canc. GI GI canc. GI-by-prod GI-canc-by-prod

CO 101 102 261 262 531 532

IWO1 261 262
Bookmark and Share

PP Goods Receipt (101) for Process Order

We are currently working on SAP 4.7.
Currently experiencing a problem where the Goods Receipt (101) for Process order is taking place before a
confirmation is done. This causes a recon variance during month-end, meaning the 101 movement takes place
e.g. last month and the confirmation done in the current month.
Is there a way that I can customize/set the system NOT to process a 101 movement UNTIL a Process order
is confirmed? So, whatever quantity was confirmed, the 101 movement should take place for that quantity and not more.

Note: I have set the control key to NOT process an automatic 101 movement.

Thanks in advance for your suggestions.

Poobie

You have 2 options.

1. You can use User Statuses for this. You define the Confirmed user status and this user status lets goods receipt to be done. If not active, you don't let goods receipt. And you set this user status during confirmation, manually or you may use user exit to do this automatically. Settings for this option can be done in Customizing.

2. You should be careful for this option! You can edit the Standard statuses for this. The system has PCNF and CNF statuses for partially confirmed and fully confirmed. As far as you have explained, it seems that these statuses, when active, is configured that the system lets goods receipt done. You can edit these statuses, to not to allow goods receipt done, if inactive. Settings for this option is done throught Status Editing transactions, BS23 for display, and BS22 for edit. I repeat, you should be careful, and extra careful if this is the first time you are using these transactions.

Hope it helps,

Osman.

That is one good TYPICAL problem of Production Planning. I would suggest not to go for big developments which will take long time to validate (may take even 3 or 4 months) because all other process related to settlement is also involved for your RECONCILIATION.

Development for sake of adjusting the quantities that you have calculated in EXCEL/Lotus - Can be considered. That is : you will be actually trying to upload the EXCESS Production Quantities or REDUCE Production Quantities in the existing Production Orders. Because - You will definitely be doing a reconciliation outside SAP once. This data need to be punched in to SAP. Typically by 3rd or 4th day of the Month you will be doing this - I believe.

After your adjustment/reconciliation for the last month - you have to give clearance for running the SETTLEMENT process.
Bookmark and Share

SAP PP Goods receipt and goods issue through a PI sheet

Can anyone explain to me how the goods issue and goods receipt are done through a PI sheet. What's the logic behind calling the functional module.

Vasudha

Process instructions contain information on:

1. The individual processing steps to be carried out
2. The process data needed for further processing in process management such as process parameter,process data calculation formula,inspection results request etc. During maintenance of PI sheet, the material quantity consumed in each phases and the actual quantity produced are entered (confirmed). Based on the confirmed quantity the system generates GR
for the process order for the finished product and a goods issue for the material withdrawal as soon as the process messages are sent.

Hope this may clear your doubt.


Thanks Arulselvan, if the materials are warehouse managed, how does the goods receipt work, does it work as a normal transaction in the background...


In general scenerio of warehouse management, GR and GI takes in different stages. When you post the GR (both for purchased material and finshed goods) the material stored in entry storage type. Based on the transport order materials are picked and moved to the permanant storage type. This will be taken care by warehouse controller. After entering the material quantity in PI sheet and posting the process messages, transfer request will be generated and the warehouse controller then convert the transfer request into transfer order. Based on the transfer order material will be picked from the permanent storage type and moves to exit storage type and from there material moves to shop floor.I have no experience in this but this is the general procedure.

If this is not working, please reply.

Bookmark and Share

SAP PP Goods Movement Steps for Subcontracting

Like to share with you my Subcontracting Steps:

1. Define all the materials in your plant (subcontracting and packaging etc).

2. In the material master MRP 4 view there is one field in which you can mention that this material is not relevant to MRP planning, use this field for subcontracting material so that it will not be planned in MRP runs ( generally use this field for re-order point planning).

3. In the BOM for the subcontracting material put the special procurement key as Subcontracting and do not keep relevance for costing.

4. If you're using packaging material of your company and want to capture the cost of these materials in the subcontracting production order then put relevance for cost.

5. Define alternate BOMs for each customer.

6. Generally the routing will be the same but materials will change, define different prodcution versions for each alternate BOM and assign to the routing.

7. Define the activite types for packing and mixing in the work center and assign them to the cost center, use these for your routing.

8. Whenever you recive a sub-contracting order, use the relevant production version depending on the customer.

In my place all the palnts belong to the same client in sap and they want to use the same material code in both plants, so I think my subcontracting scenario might be different from yours but it give you some ideas to go about it.

Note: To Define Subcontracting Cost Center : Goto - ca02 - double click operation number. It is at the section call External Processing. (Subcontracting will be tick).

Bookmark and Share

SAP PP Goods Movement Stock in Transit - liquidation or remove the stock which is in transit

I am transfering a product from one plant (say 1000) to another plant (say 2000). By using MB5T, I could find the stock in transit. Unfortunately, the lorry met with a fire accident and all my goods destroyed. Now I have a scenario where I need to remove the stock which is in transit.

How do you wish to remove the stock? Are you going to scrap it or issue it to a specific GL account for insurance purposes?

It is for both scrap and for insurance purposes.

You have two options. Option number one being the simplest of the two. You will need to know the stock transport PO number or numbers. If you do not know them you can perform a search using transaction MB5T enter in the receiving plant, check the stock transfer order and the cross-company-code box and execute. All in transit PO's will be displayed for that plant. You can drill into document flow by double clicking on the PO number.

Option 1.

You complete the transactions into the intended plant and then perform the scrap transaction.

MB01 or MIGO (goods receipt against a purchase order) depending on which you use to perform goods receipts and LT06 bin put away,( if the plant is warehouse managed).

Scrap the goods using transaction MB1A movement type 551 or MB1A misc issue to a specific GL account. Use movement type 201. LT06 to remove the goods from the put away bin if the receiving plant is warehouse managed. If the receiving plant is not warehouse managed then MB1A is all that you need to do to complete the scrapping of the goods.

Option 2.

You wish to reverse the goods movement back into the supplying plant and then perform the scrap transaction.

VL09 reverse good movement. (You will need the delivery number in order to do this)
LT0G (if using warehouse management) to reverse the goods back into a bin.
VL02N to cancel the delivery
ME22N to cancel the PO.
MB1A choose the bin location in which you placed the goods when you performed the reversal. (again if you have warehouse management). If non warehouse managed MB1A is all that needs to be completed to remove the goods from inventory.

Bookmark and Share

Restricting Good Receipt Unless Production Order Confirmed

SAP Production Planning Ticket:

Restricting good receipt in MB31 unless the production order is confirmed.

My client uses CO11N for activity confirmation. They are not using auto goods receipt for this transaction. Instead they are using MB31, 101 movement type. This 2 transactions are independent of each other. Now the user wants that unless the order is confirmed there should not any goods receipt. Means the system should not allow MB31-101 movement against the order if it is not confirmed through CO11N.

1. Use Tcode BS02 ( Customising USer status profile).

2. Select the order type which you want to configure (eg:PP000001) and choose "Details" button.

3. In the User status table do the following:
a. In the status no field type"1" , status field "Sta1", short text"GR not allowed", lowest no "1", Highest No "2". Mark a tick in the initial stats check box.
b.Next line, type status no field "2" ,status field "sta2", short text"Gr allowed", lowest no "2" , highest no "2".

4. Select the STA1 line and choose details. select the "create"button.select the "GR for prod order", mark "forbidden
radio button" and "set radio button".

5. Select the STA2 line and choose details. Selct the "create"button. select "confirm order", mark "permitted radio button" and "set radio button". Next choose "GR for prod order" , mark "permitted radio button".

6.Save.
Create a prod order and check whether the required scenario is working.

Bookmark and Share

SAP BOM How to link BOM component to storage location?

If you have to issue a component for production order of main item always from a specific storage location (component is stored in multiple storage locations but for production of a top item reservations should be created only on a specific storage loc), where can you provide the link between BOM component and storage Loc??

Is it possible to provide that link in BOM? or while allocating BOM components to routing operations or else where?

You can use the issue storage location field on the MRP 2 screen in the material master

or

You have 3 ways of doing it - not including the material master since the components are stored in multiple locations.

1. BOM item - very flexible but very time consuming to maintain if you have lots of BOM's. In CS02 you can set st. loc. on each component, and SAP will take this st. loc. first.

2. from level above - you can set it up so that whatever st. loc. is the default prod. st. loc on the material master for the level above will be the issue st. loc for the components you choose, if the component exists in that st. loc. - kind of a champagne waterfall effect. If the st. loc. is not maintained on the component, it will take the material master default of the component.

3. using supply area and work center. create supply areas and link them to st. loc's. - then link the supply area to the work center on CR02. Then allocate components to operations going through those work centers.

Note:
Supply Areas are meant to be used in conjunction with Kanban. However you can just use them to link the work center to a storage location. You will never see an inventory balance in MMBE in a supply area. With Kanban you can set up automatic triggers to replenish stock to the supply areas from a main stock location.

Bookmark and Share

When is a Material BOM Not Exploded?

A BOM is not exploded in the following situations:

- No BOM is effective:
-- On the explosion date and in the given area of validity
For the given effectivity parameters

- The BOM has a deletion indicator.

- The BOM is a multiple BOM, and has no alternative that matches the lot size for your required quantity.

- No BOM matches the selection criteria of the BOM application you selected.

- This is possible in the following situations, for example:

-- The application does not take all BOM usages into account.
For example, the application only takes BOMs that are relevant to production into account, so a BOM that is relevant to sales and distribution is not exploded.

-- The application selects a specific alternative on the explosion date you require. The material master record supports alternative determination by Explosion date.
If the specified alternative is not valid on the explosion date, the BOM is not exploded.

-- The application takes production versions in the material master record into account, but no production version has a BOM that is valid on the explosion date you require. The material master record supports alternative determination by Production version.
The system only explodes the BOM defined for the production version that matches the alternative and/or usage entered on the explosion date required.

-- The application only takes BOMs with certain status indicators into account.
For example, the application for MRP only explodes BOMs that have at least the status Explosion for MRP.

Further checks:
- Do the proper Scheduling in Routing (Backward/forward). In md61 give the requirement in next month.check your in-house production, planned delivery time in md02 give MRP Control parameter Rexplode BOM and Routing.

- Check BOM explosion data in MRP4 view of material master view ( Individual/Coll data).
Bookmark and Share

Simple BOM & Group BOM

How to Create a Simple BOM?

Transaction code : CS01

Material : Your Material code

Plant : Your Plant

BOM Usage : 1

Item Category Componment Quantity

0010 L Your Material code Your required quantity

Save your entries

You can used CS02 to changed the BOM and CS03 to display the BOM.

What are the use of Group bom? - By Vikram

A bom WITHOUT A PLANT IS CALLED GROUP BOM.

Group BOM:
If you create a material BOM without reference to a plant, the BOM is valid throughout your company. To do this, you leave the Plant field blank. The system checks whether material masters exist. There are no system checks for plant data.

However, you can also create a group BOM, without reference to a plant. For example, a designer maintains a group BOM during the design phase of a product, then the BOM is allocated to one or more plants for production purposes.

For single BOM (one production line) do I need to do Production Version? Whats the purpose of using Prod. Version for single BOM?

It depends on your company needs as a production version determines the various production techniques that can be used to produce a material. It defines the following information:
- Alternative BOM for a BOM explosion
- Task list type, task list group, and group counter for assignment to task lists
- Lot-size restrictions and period of validity
A material can have one or more production versions.

During the process order creation system picks up the required version to produce the material.

Bookmark and Share

Explode SAP PP BOM

Transaction code :

CS11 to explode BOM level by level

CS12 to explode BOM Multi level

Material : Your Material code

Plant : Your Plant

Alternative BOM : if you have multiple BOMs

BOM application : PP01 if you follows SAP default for Production General

Valid from : date of BOM you want to change

Required qty : enter required quantity (optional)
Bookmark and Share

Where used list for SAP PP BOM

Transaction code : CS15

First screen :

Material : your material code

Type of where used list : Tick Direct

Valid from date : default system date (change if you want other dates)

Next screen :

Required qty : required qty of material

Resulting qty : resulting qty of the header material

Plant : restrict selection to a single plant
Bookmark and Share

SAP PP - Controlling data for your Bill of Materials

You define the default values for BOM in OS28.
- Based quantity
- BOM Status
- Size Unit
- Var-size item unit


You control the Material type allowed for the BOM header in transaction OS24.


In transaction OS27, you define the central settings for your BOM management system. This
are one-time settings for BOM management, which should not be change after production.

Low date
When you create or process BOMs, the default date is the date defined in your system as the
earliest processing date (01/01/1900 in the standard system).

BOM validity maintenance
Tick if want the user to specify a valid-from date when maintaining BOMs. If not tick the BOM
created as of the current date or the system low date (1/1/1990).

EC management active
Tick if you want to make historical changes to BOMs with reference to a change number.
(This means that the status of the BOM both before and after the change is stored in
the system.) In this step, you only specify whether engineering change management can be
used for maintaining bills of material. In transaction OS25, Configure history requirement
for BOMs, you define whether you want to make the use of engineering change management a
requirement in certain cases.

Hist. reqmt variant
Use this indicator to control when history requirement applies to new variants or
alternatives in a BOM group.

Sub-item documentn
You use the Sub-item documentation indicator to define whether changes to sub-items are
documented.

Header
Create BOM header with parameter validity

TECHINCAL TYPE
Mult. BOM inactive
Tick if no multiple BOMs can be maintained in this R/3 system.
Variant BOM inactive
Tick if no variant BOMs can be maintained in this R/3 system

BILL OF MATERIAL ITEM
BOM item explosion type
If you create a BOM item with reference to a change number and change the valid-from date
(in the change header or alternative date), then this can change the sequence of validity
periods of a BOM item. The indicator BOM item explosion type specifies whether and according to what rules,
the system determines a unique change status, when you display, evaluate or change a BOM to
a date in the overlap period.
Description variable-sized item
This indicator controls which text is displayed in BOM processing for a variable-sized item.

Repeated effectivity via external item ID
This indicator ensures that an item that already exists under an external item ID can be used.

General settings
Unit 'piece'
In the standard system, this field contains a unit of measure for "piece". You can change
this unit. This unit is the base unit of measure (BOM header) or the component unit of
measure.

Base unit of measure for:
Equipment BOM
Functional location BOM
Document structure
Standard BOM
Component unit of measure for:
Text item
Document item
Non-stock item without material master record

CAD active
If you want to maintain BOMs from a CAD system, set this indicator. This activates an
additional field in the BOM header and BOM item, which tells you whether the BOM header or
BOM item was maintained from a CAD system.



If you deactivate engineering change management, changes to bills of material are not
recorded.

The modification parameters defined here apply to all BOM categories.

The following settings are made in the standard R/3 System:

1. Validity date maintenance and engineering change management are active.
2. The current system date is the default valid-from date.
3. CAD is active.
4. Explosion type for BOM item: blank.
Bookmark and Share

Allocating PP BOM to Other Plant

Use Transaction CS07 to link this BOM to the other plants.

This shall make the BOM available in the other plants.
Bookmark and Share

SAP PP BOM Mass Change Bill of Materials

Use Transaction CS20 to mass change your BOM.

In this transaction code, you can :-

1. mass change item data
2. mass delete items
3. mass add materials etc.
Bookmark and Share

Multi-level configuration with variants PP BOM

Subject: Multilevelconfiguration with variants

Hi all,

Does anybody know a trick to use preconfigured
variants in mulitilevel configuration ?

According to OSS note, it is not possible becauce of
MRP and possible differences between sales order
configuration and material master data configuration.

thanks in advance.

-----Reply Message-----
Subject: Multilevelconfiguration with variants

If you got a some material variants that you would like to keep in stock,
the remaining variants are configurable materials.

If you only sell material variants and not configurable material's you can try
this solution.

Kmat structure.

Level A - - - - - -- Design level - Used to make
simulation/pricelist/deside which system the customer should use.
Level B - - - - Different systems depending on the selections
made in level A.
Level C - - - - - At this level I have got the material
variants and configurable mateial's all together.

Step 1:
To be able to select a material variant in level C, I use the
classefication system. ( class type 200 ).
This class has got one char. ( ref to table marc and field matnr ). It is
not nessesary to make the reference to a table. I have done this because I
hope to find a better solution at a later stage.
All my material varints are allocated to this class. Enter the material
number in the class using cl24N.
Remember to make the classefication of the material numbers.

Step 2:
Create a Variant table. ( V )
Enter the chars that you have got in the class ( 300 ). We have got many
configurable materials. I have created one class for each configurable
material.
In this class you should allocate the char marc_matnr. All chars except
from marc_matnr should be marked as key fields.
In the field marc_matnr you must enter the material variant according to
the classefication of the material variant. ( if the combination that you
have entered haven't got a material variant, you must / could enter the
configurable material number.
Enter all combinations that's nessesary to cover the material variants that
you have got in your system. The largest variant tables that I have got,
has aprox. 5000 positions.

Step 3:

Allocate the class(es) to the sales order bom. If you sell configurable
material's you must enter 2 positions. One with the class, and one with the
configurable material. This is because you can't allocate a configurable
material to a class. ( I could'nt make this work )
Then allocate a selection condition to the class. Level B component = 2000
Then allocate a procedure to the class.
table V ( a = $parent.a ,
b = $parent.b ,
c = $parent.c ,
d = $parent.d ,
marc_matnr = $self.marc_matnr )

This should do it you don't sell configurable materials.

Allocate this selection condition to the configurable material.

table V ( a = a ,
b = b ,
c = c ,
d = d ,
marc_matnr = '2000' )

This makes sure that you get a configurable material if there isen't a
materal variant.

The sales person don't have to worry about doing things right. In our case
it work very well. We have got a very good performances.
It is possible to configure 2 - 20 items at the same time as it takes for
our single level configurable materials.

I think SAP needs to implement a solution(this) so that we don't have to
find/develop our own solutions.

Other solutions out there??

Best regards

Bookmark and Share

SAP PP BOM What exactly is a Phantom item or Assembly means?

Can anyone plese tell me what exactly is a phantom item or assembly means?
How does it affect the MRP process?

A phantom assembly is used when you want to be able to structure a BOM so it is easy to understand, but don't want to create too many production orders.

Assume an auto Engine. There are hundreds of components. You might structure them as: Engine block and parts, camshaft and parts, and 6 piston assemblies. But you don't want to create 3 production orders, too much hassle. So you want to issue the components for the piston assembly in the same production order as the Engine block. So you create a new material number for the Piston assembly, but you mark it as a phantom assembly. That means that when you create the bom for the Engine assembly, you only have two assemblies, the Engine block and the Camshaft. You add the phantom assembly for the Piston Assembly to the Engine block BOM, saying it requires 8 of the phantom assembly. When the production order is created for the Engine block, the picklist will also include all of the components of the 8 piston assemblies.

1) When to use, or not use a phantom assembly?
If you need to do cost accounting on how many hours it takes to assemble a piston assembly, it cannot be a phantom assembly, because as a part of the Engine block assembly, the labor costs are included in the Engine block production order, and therefore in the standard cost.

2) Can the assembly people pick out the parts for the phantom assembly from the all of the components in the Kit?
If the guy assembling the Engine Block gets confused because of all of the components for the Piston assemblies are there, then it cannot be a phantom assembly. But if they can seperate them easily, go for it. A printed circuit board assembly should never be a phantom assembly, because all of those little parts for each type of PC board must be kept separate.

3) Do you usually build 100 piston assemblies, put them into stock, then issue 8 at a time to build an Engine Assembly?
If so, it is not a phantom assembly. If the Piston assembly is a phantom, you only build the 8 you need while you are building the Engine Block assembly. You normally do NOT store a piston assembly (phantom assembly) in stock.

4) However, sometimes a customer calls and wants you to send them all of the components for One Piston Assembly.
By having it set as a phantom assembly, even though you don't usually create seperate production orders, in this case you CAN create a production order for one, pull the components, close the PO, and send the parts off to your customer.

5) You complete a Engine Assembly.
As you are walking it back to the stockroom, you drop it on the floor, and it breaks! Damn, but you can still save the piston assemblies. Since they do have a SAP material number, you CAN put those back into stock. Most MRP systems WILL recognize that you happen to have 8 piston assemblies in stock, and will issue those whole assemblies to the next order for a Engine Block.

Bookmark and Share

Attachment Of Drawings in PP BOMs

How to attach a document to a BOM ?

Now one can attach a document to a BOM in one of the following three ways…
1) Attach document as an item in the item overview,
2) Attach document to an item and
3) Attach document to the header material.

1) Attaching document as an item in the item overview:
…go to the `General Item Overview' screen
…select the tab page `Document'
…enter item category `D'
…dropdown and select the document you want to attach
…the system automatically selects the respective document type, document part, document version and document description
…the system also enters component quantity `1' and component unit of measure as `PC' by default.

2) Attaching document to an item:
…go to the `General Item Overview' screen
…select the particular item by F2
…the item all data screen appears
…go to tab page `document assignment'
…dropdown and select the `document type' you want to attach …dropdown and select the document you want to attach
…the system automatically selects the respective document part, document version and document description

3) Attach document to the header material:
…go to header overview screen
…go to tab page `document assignment'
…dropdown and select the `document type' you want to attach
…the system automatically selects the respective, document part, document version and document description

Pre-requisites…
…create document by transaction CV01N
…Customizing settings…in document management customizing determines which objects can be assigned to documents per object type.
…go to IMG -> cross-application components -> document management -> control data -> define documents type
…select the document type for example `DRW'
…select the sub dialog `define object links'
…select new entries and enter following objects…
…'STPO_DOC' and screen `257'(linking document to BOM header) …'STKO_DOC' and screen `258'(linking document to BOM item) …now documents can be linked to BOM header as well as BOM item.

Bookmark and Share

Variant Configuration for an Order

You create a sales order in response to a customer inquiry. In the sales system, configuration is made at the highest level. When you maintain sales order BOMs, you can configure interactively at multiple levels and execute manual changes or characteristic valuations. The variant conditions can be attached directly to the characteristic values. The production order is processed in Production Planning (PP), dispatch occurs in Sales and Distribution (SD) and the resulting costs and revenues are monitored in Controlling (CO).

The object dependencies in the BOM are not evaluated until the BOM is exploded in material requirements planning (MRP).

You can find more information about this process under.

1. Creating a Sales Order
2. Maintaining the Order BOM
3. Requirements Planning
4. Checking Requirements Using MRP
5. Converting the Planned Order into a Production Order
6. Confirming the Production Order
7. Checking the Settlement of the Production Order
8. Creating a Delivery
9. Creating a Billing Document
Bookmark and Share

SAP BOM components never explode

4.6x

After executing MD02, you found that the components did not explode accordingly:

Checklist for checking :-

Material Type must be FERT - Finished products or HALB - Semi-finished products

MM02 - MRP View 2 - Procurement type ( X - Both procurement type or E - In-house production)

CS02 - Validity periods of Parents parts and Components

Bookmark and Share

Checking Costs and Revenues from the Sales Order

This report is used when you used transaction MD50 to convert the Sales Order to Produciton Planning.

On the Make-To-Order Planning - Multi-Level screen, enter the following data:

Field Data :- Sales order Your sales order number
Sales ord. item (The item number of your sales order)
Create pur.req. 2
Planning mode 3
Schedule lines 1
Scheduling 1

Also plan unchanged components Select
Display material list Select

Menu Path :-

Accounting -> Controlling -> Product Cost Controlling -> Cost Object Controlling -> Product Cost by Sales Order
-> Information System -> Reports for Product Costing by Sales Order -> Detailed Reports
-> For Sales Order -> Plan/Actual Comparison

Transaction code :- S_ALR_87013105

Enter your Sales Order Number

Choose :- The Plan/Actual Comparison and the selection screen will appears.

To display the various cost elements and revenues for one of the items, click the down arrow and you will see the report data.
Bookmark and Share

Production Planning - Extract data from MRP Table

*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
*
* A sample program to extract data from the MRP table.
*
*+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
REPORT ZMRPTABLE.

TABLES: MDKP, "Header Data for MRP Document
MDTB, "MRP table
MDTC, "Aggregated MRP table items
T457T. "Description of MRP elements

DATA: BEGIN OF MDTBX OCCURS 0.
INCLUDE STRUCTURE MDTB.
DATA: END OF MDTBX.

SELECT-OPTIONS: PLANT FOR MDKP-PLWRK OBLIGATORY,
MATNR FOR MDKP-MATNR OBLIGATORY.

CLEAR: MDKP, MDTB.
SELECT * FROM MDKP WHERE DTART EQ 'MD'
AND MATNR IN MATNR
AND PLWRK IN PLANT.
WRITE:/ MDKP-MATNR, MDKP-PLWRK.
IF MDKP-CFLAG EQ 'X'.
CLEAR MDTBX. REFRESH MDTBX.
IMPORT MDTBX FROM DATABASE MDTC(AR) ID MDKP-DTNUM.
LOOP AT MDTBX.
MOVE MDTBX TO MDTB.

SELECT SINGLE * FROM T457T WHERE SPRAS = 'E'
AND DELKZ = MDTB-DELKZ.

IF MDTB-PLUMI = '-'. MULTIPLY MDTB-MNG01 BY -1. ENDIF.

WRITE:/ MDTB-DAT00, T457T-DELB1, MDTB-VSTAT,
MDTB-MNG01, MDTB-LGORT.
ENDLOOP.
ELSE.
SELECT * FROM MDTB
WHERE DTNUM EQ MDKP-DTNUM
ORDER BY PRIMARY KEY.
SELECT SINGLE * FROM T457T WHERE SPRAS = 'E'
AND DELKZ = MDTB-DELKZ.

IF MDTB-PLUMI = '-'. MULTIPLY MDTB-MNG01 BY -1. ENDIF.

WRITE:/ MDTB-DAT00, T457T-DELB1, MDTB-VSTAT,
MDTB-MNG01, MDTB-LGORT.
ENDSELECT.
ENDIF.
ENDSELECT.
Bookmark and Share

ABAP Reports Production Order Quantity Change Daily Checklist PP

*
* Production Order Quantity Change Daily Checklist
*
* An 'Err' flag will be assigned to the 'Rmks' column if the Required
* components quantity does not equal to the calculated BOM components
* quantity.
*
* Submitted by : SAP Basis, ABAP Programming and Other IMG Stuff
*
*
REPORT ZPPORDER LINE-SIZE 180 NO STANDARD PAGE HEADING
LINE-COUNT 058(001).

TABLES: AUFK, "Order master data
AFKO, "Order header data PP orders
RESB, "Reservation/dependent requirements
MAST, "Material to BOM Link
STKO, "BOM Header
STPO. "BOM item

DATA: BEGIN OF WA,
AUART TYPE AUFK-AUART,
AUFNR TYPE AUFK-AUFNR,
AEDAT TYPE AUFK-AEDAT,
AENAM TYPE AUFK-AENAM,
WERKS TYPE AUFK-WERKS,
PLNBEZ TYPE AFKO-PLNBEZ,
GAMNG TYPE AFKO-GAMNG,
GASMG TYPE AFKO-GASMG,
MATNR TYPE RESB-MATNR,
POSNR TYPE RESB-POSNR,
BDMNG TYPE RESB-BDMNG,
BMENG TYPE STKO-BMENG,
MENGE TYPE STPO-MENGE,
END OF WA,
ITAB LIKE SORTED TABLE OF WA WITH NON-UNIQUE KEY AUFNR POSNR.
DATA: BEGIN OF ITAB2 OCCURS 0.

INCLUDE STRUCTURE WA.
DATA: END OF ITAB2.

DATA: BEGIN OF ITAB-AUFK OCCURS 0,
AUART LIKE AUFK-AUART,
AUFNR LIKE AUFK-AUFNR,
POSNR LIKE RESB-POSNR,
AEDAT LIKE AUFK-AEDAT,
AENAM LIKE AUFK-AENAM,
WERKS LIKE AUFK-WERKS,
PLNBEZ LIKE AFKO-PLNBEZ,
GAMNG(7) TYPE P DECIMALS 0,
GASMG(7) TYPE P DECIMALS 0,
MATNR LIKE RESB-MATNR,
BDMNG(7) TYPE P DECIMALS 0,
BMENG(7) TYPE P DECIMALS 0,
MENGE(7) TYPE P DECIMALS 3.
DATA: END OF ITAB-AUFK.

DATA: FDATE LIKE SY-DATUM,
LDATE LIKE SY-DATUM.

DATA: X_AUFNR LIKE AFKO-AUFNR,
X_MENGE(7) TYPE P DECIMALS 0,
X_ERR(3).

DATA: W_DATASET1(500) VALUE '/usr/sap/trans/data/'.

SELECT-OPTIONS T_WERKS FOR AUFK-WERKS OBLIGATORY.
SELECT-OPTIONS T_AUFNR FOR AUFK-AUFNR.
SELECT-OPTIONS T_AEDAT FOR AUFK-AEDAT.
PARAMETERS PDATA LIKE W_DATASET1.

CONCATENATE W_DATASET1 PDATA INTO W_DATASET1.

PERFORM F_COLLECT_DATA.

FORM F_COLLECT_DATA.
OPEN DATASET W_DATASET1 FOR INPUT IN TEXT MODE.
DO.
IF sy-subrc <> 0.
EXIT.
ENDIF.
READ DATASET W_DATASET1 INTO WA.
APPEND WA TO ITAB2.
ENDDO.
CLOSE DATASET W_DATASET1.

SELECT A~AUFNR A~AUART A~AEDAT A~AENAM A~WERKS
B~PLNBEZ B~GAMNG B~GASMG
C~MATNR C~BDMNG C~POSNR
INTO CORRESPONDING FIELDS OF TABLE ITAB
FROM ( AUFK AS A
INNER JOIN AFKO AS B ON B~AUFNR = A~AUFNR
INNER JOIN RESB AS C ON C~AUFNR = A~AUFNR )
WHERE A~AEDAT IN T_AEDAT
AND A~WERKS IN T_WERKS.

LOOP AT ITAB INTO WA.
CLEAR MAST.
SELECT SINGLE * FROM MAST WHERE MATNR = WA-PLNBEZ
AND WERKS = WA-WERKS.
CLEAR STKO.
SELECT SINGLE * FROM STKO WHERE STLNR = MAST-STLNR
AND STLAL = MAST-STLAL.
CLEAR STPO.
SELECT SINGLE * FROM STPO WHERE STLNR = MAST-STLNR
AND POSNR = WA-POSNR.
WA-BMENG = STKO-BMENG.
WA-MENGE = STPO-MENGE.

MODIFY ITAB FROM WA.

AT NEW AUFNR.
SKIP.
ENDAT.
LOOP AT ITAB2 WHERE AUFNR = WA-AUFNR
AND POSNR = WA-POSNR.
IF ITAB2-GAMNG <> WA-GAMNG OR
ITAB2-GASMG <> WA-GASMG OR
ITAB2-BDMNG <> WA-BDMNG.
CLEAR X_MENGE.
IF ITAB2-BMENG <> 0.
X_MENGE = ITAB2-GAMNG / ITAB2-BMENG * ITAB2-MENGE.
ENDIF.
CLEAR X_ERR.
IF ITAB2-BDMNG <> X_MENGE.
X_ERR = 'Err'.
ENDIF.
FORMAT COLOR COL_TOTAL.
WRITE: / ITAB2-AUART UNDER 'Type',
ITAB2-AUFNR UNDER 'Prod Order',
ITAB2-AEDAT UNDER 'Last Chg Dt',
ITAB2-AENAM UNDER 'Last Chg by',
ITAB2-WERKS UNDER 'Plant',
ITAB2-PLNBEZ UNDER 'Material',
(10) ITAB2-GAMNG UNDER 'Order Qty' DECIMALS 0,
(10) ITAB2-GASMG UNDER 'Scrap Qty' DECIMALS 0,
ITAB2-POSNR UNDER 'Item',
ITAB2-MATNR UNDER 'Component Req',
(10) ITAB2-BDMNG UNDER 'Req Qty' DECIMALS 0,
X_MENGE UNDER 'BOM Qty' COLOR COL_TOTAL,
ITAB2-BMENG UNDER 'BOM Base',
ITAB2-MENGE UNDER 'BOM Comp',
X_ERR UNDER 'Rmks' COLOR COL_TOTAL.
CLEAR X_MENGE.
IF WA-BMENG <> 0.
X_MENGE = WA-GAMNG / WA-BMENG * WA-MENGE.
ENDIF.
CLEAR X_ERR.
IF WA-BDMNG <> X_MENGE.
X_ERR = 'Err'.
ENDIF.
FORMAT COLOR OFF.
WRITE: / WA-AUART UNDER 'Type',
WA-AUFNR UNDER 'Prod Order',
WA-AEDAT UNDER 'Last Chg Dt',
WA-AENAM UNDER 'Last Chg by',
WA-WERKS UNDER 'Plant',
WA-PLNBEZ UNDER 'Material',
(10) WA-GAMNG UNDER 'Order Qty' DECIMALS 0,
(10) WA-GASMG UNDER 'Scrap Qty' DECIMALS 0,
WA-POSNR UNDER 'Item',
WA-MATNR UNDER 'Component Req',
(10) WA-BDMNG UNDER 'Req Qty' DECIMALS 0,
X_MENGE UNDER 'BOM Qty' COLOR COL_TOTAL,
WA-BMENG UNDER 'BOM Base',
WA-MENGE UNDER 'BOM Comp',
X_ERR UNDER 'Rmks' COLOR COL_TOTAL.
ENDIF.
ENDLOOP.
ENDLOOP.

LOOP AT ITAB2.
LOOP AT ITAB INTO WA WHERE AUFNR = ITAB2-AUFNR
AND POSNR = ITAB2-POSNR.
DELETE ITAB2.
ENDLOOP.

SELECT SINGLE * FROM AUFK WHERE AUFNR = ITAB2-AUFNR.
IF SY-SUBRC <> 0.
DELETE ITAB2.
ENDIF.
ENDLOOP.

OPEN DATASET W_DATASET1 FOR OUTPUT IN TEXT MODE.
LOOP AT ITAB INTO WA.
TRANSFER WA TO W_DATASET1.
ENDLOOP.
LOOP AT ITAB2 INTO WA.

TRANSFER WA TO W_DATASET1.
ENDLOOP.
CLOSE DATASET W_DATASET1.
ENDFORM.

TOP-OF-PAGE.
FORMAT COLOR COL_TOTAL.
WRITE: / SY-DATUM, SY-UZEIT, SY-REPID, SY-UNAME,
50 'Daily Qty Changed Checklist for Production Order',
120 SY-PAGNO.
SKIP.
WRITE: / 'Plant ', T_WERKS-LOW.
WRITE: ' Last Change Date ', T_AEDAT-LOW, ' to ', T_AEDAT-HIGH.
SKIP.
WRITE: /1 'Type',
6 'Prod Order',
17 'Last Chg Dt',
29 'Last Chg by',
42 'Plant',
49 'Material',
69 'Order Qty',
83 'Scrap Qty',
99 'Item',
105 'Component Req',
121 'Req Qty',
135 'BOM Qty',
149 'BOM Base',
163 'BOM Comp',
178 'Rmks'.
ULINE.
WRITE: / 'Previous data :- '.
FORMAT COLOR OFF.
WRITE: / 'Current data :- '.

INITIALIZATION.
LDATE = SY-DATUM.
LDATE = LDATE - 1.
FDATE = LDATE.
MOVE: FDATE TO T_AEDAT-LOW.

APPEND T_AEDAT.

PDATA = 'AE001'.

*--- End of Program
Bookmark and Share

SAP PP ABAP Reports Compare Production Confirmation against Planned by Work Centre

*
* Compare Production Confirmation against Planned by Work Centre
*
REPORT ZASSEMBLY_EFFICIENCY LINE-SIZE 255 NO STANDARD PAGE HEADING
LINE-COUNT 065(001).

TABLES: AFKO, "Order header data PP orders
AFPO, "Order item
AFRU, "Order completion confirmations
AUFM, "Goods movements for order
AFVV, "DB structure of the quantities/dates/values in the oper
MARA. "General Material Data

DATA: BEGIN OF INT_EFF OCCURS 100,
MATNR TYPE AFKO-STLBEZ,
MTART TYPE MARA-MTART,
AUFNR TYPE AFKO-AUFNR,
GSTRI TYPE AFKO-GSTRI,
GLTRI TYPE AFKO-GLTRI,
GAMNG(9) TYPE C,
MENGE(9) TYPE C,
PLN01(9) TYPE C,
ISM01(7) TYPE P DECIMALS 2,
DAUAT TYPE AFPO-DAUAT,
END OF INT_EFF.

DATA: FDATE LIKE SY-DATUM,
LDATE LIKE SY-DATUM.

DATA: YGAMNG(7) TYPE P DECIMALS 2,
YMENGE(7) TYPE P DECIMALS 2,
YPLN01(7) TYPE P DECIMALS 2,
XMENGE(7) TYPE P DECIMALS 0,
XSTDRATE(7) TYPE P DECIMALS 2,
XACTRATE(7) TYPE P DECIMALS 2,
XLINEEFF(7) TYPE P DECIMALS 2,
XUTILISA(7) TYPE P DECIMALS 2.

SELECT-OPTIONS XWERKS FOR AFRU-WERKS DEFAULT 'SAP'.
SELECT-OPTIONS XBUDAT FOR AFRU-BUDAT.
SELECT-OPTIONS XAUFNR FOR AFRU-AUFNR.

START-OF-SELECTION.
SELECT * FROM AFRU WHERE BUDAT IN XBUDAT
AND WERKS IN XWERKS
AND AUFNR IN XAUFNR.
CLEAR AFPO.
SELECT SINGLE * FROM AFPO WHERE AUFNR = AFRU-AUFNR.

CLEAR AFKO.
SELECT SINGLE * FROM AFKO WHERE AUFNR = AFRU-AUFNR.

CLEAR MARA.
SELECT SINGLE * FROM MARA WHERE LVORM = ''
AND MATNR = AFKO-STLBEZ.

CLEAR AFVV.
SELECT SINGLE * FROM AFVV WHERE AUFPL = AFRU-AUFPL
AND APLZL = AFRU-APLZL.

IF AFVV-VGE01 = 'MIN'.
AFVV-VGW01 = AFVV-VGW01 / 60.
ENDIF.

PERFORM GET_DATA_AUFM.
PERFORM GET_DATA.

ENDSELECT.

PERFORM LOOP_INT_EFF.
END-OF-SELECTION.

FORM GET_DATA.
* Reverse Confirmation
IF AFRU-STOKZ = 'X'.
MULTIPLY AFRU-LMNGA BY -1.
MULTIPLY AFRU-ISM01 BY -1.
MULTIPLY AFRU-ISM02 BY -1.
MULTIPLY AFRU-ISM03 BY -1.
MULTIPLY AFRU-ISM04 BY -1.
MULTIPLY AFKO-GAMNG BY -1.
MULTIPLY AFVV-BMSCH BY -1.
MULTIPLY AFVV-VGW01 BY -1.
MULTIPLY AFVV-VGW02 BY -1.
MULTIPLY AFVV-VGW03 BY -1.
ENDIF.
* Plan Activities
IF AFVV-BMSCH <> 0.
INT_EFF-PLN01 = ( AFKO-GAMNG / AFVV-BMSCH ) * AFVV-VGW01 * 60.
ENDIF.
* Actual Activities
INT_EFF-ISM01 = AFRU-ISM01.
* Material No.
IF AFKO-PLNBEZ = SPACE.
INT_EFF-MATNR = AFKO-STLBEZ.
ELSE.
INT_EFF-MATNR = AFKO-PLNBEZ.
ENDIF.
INT_EFF-MTART = MARA-MTART.
INT_EFF-AUFNR = AFKO-AUFNR.
INT_EFF-GSTRI = AFKO-GSTRI.
INT_EFF-GLTRI = AFKO-GLTRI.
INT_EFF-GAMNG = AFKO-GAMNG.
INT_EFF-MENGE = XMENGE.
INT_EFF-DAUAT = AFPO-DAUAT.

COLLECT INT_EFF.
CLEAR INT_EFF.

ENDFORM.

FORM GET_DATA_AUFM.
CLEAR XMENGE.
SELECT * FROM AUFM WHERE AUFNR = AFKO-AUFNR
AND BWART IN ('101', '102').
IF AUFM-SHKZG = 'H'.
MULTIPLY AUFM-MENGE BY -1.
ENDIF.
ADD AUFM-MENGE TO XMENGE.
ENDSELECT.
ENDFORM.

FORM LOOP_INT_EFF.
LOOP AT INT_EFF.
CLEAR: XSTDRATE, XACTRATE, XLINEEFF, XUTILISA.

IF INT_EFF-PLN01 <> 0.
XSTDRATE = INT_EFF-MENGE / INT_EFF-PLN01.
ENDIF.
IF INT_EFF-ISM01 <> 0.
XACTRATE = INT_EFF-MENGE / INT_EFF-ISM01.
XUTILISA = INT_EFF-PLN01 - INT_EFF-ISM01.
ENDIF.
IF XSTDRATE <> 0.
XLINEEFF = XACTRATE / XSTDRATE.
ENDIF.
YGAMNG = INT_EFF-GAMNG.
YMENGE = INT_EFF-MENGE.
YPLN01 = INT_EFF-PLN01.
WRITE:/ INT_EFF-MATNR UNDER ' Material',
INT_EFF-MTART UNDER ' Matl',
INT_EFF-AUFNR UNDER 'Production',
INT_EFF-GSTRI UNDER 'Start',
INT_EFF-GLTRI UNDER ' Finish',
YGAMNG UNDER 'Production Ord',
YMENGE UNDER ' Receipt Qty',
YPLN01 UNDER ' Plan Hr',
INT_EFF-ISM01 UNDER ' Actual Hr',
XSTDRATE UNDER ' Std Rate',
XACTRATE UNDER ' Actual Rate',
XLINEEFF UNDER 'Efficiency (%)',
XUTILISA UNDER 'Utilisation Typ',
INT_EFF-DAUAT UNDER 'PP Type'.
ENDLOOP.
ENDFORM.

TOP-OF-PAGE.
FORMAT COLOR COL_TOTAL.
WRITE: / SY-DATUM, SY-UZEIT, SY-REPID,
110 'Assembly Line Efficiency Report - Closed (Period)',
200 SY-UNAME, SY-PAGNO.

SKIP.
WRITE: /1 ' Material',
20 ' Matl',
25 'Production',
36 'Start',
47 ' Finish',
58 'Production Ord',
73 ' Receipt Qty',
88 ' Plan Hr',
103 ' Actual Hr',
118 ' Std Rate',
133 ' Actual Rate',
148 'Efficiency (%)',
163 'Utilisation Typ',
179 'PP Type'.

INITIALIZATION.
LDATE = SY-DATUM.
LDATE+6(2) = '01'.
LDATE = LDATE - 1.
FDATE = LDATE.
FDATE+6(2) = '01'.
MOVE: FDATE TO XBUDAT-LOW,
LDATE TO XBUDAT-HIGH.
APPEND XBUDAT.

*---End of Program
Bookmark and Share

ABAP Reports Customized Work Center List PP

*
* The standard SAP Work Center List - CR05 includes the flag for
* deletion work center. This customized work center list allows
* you to include or exclude those work center that have been flag
* for deletion. Those with a 'X' in the list are flag for deletion.
*
* Written by : SAP Basis, ABAP Programming and Other IMG Stuff
*
*
REPORT ZPPWORKCENTER
LINE-SIZE 120 NO STANDARD PAGE HEADING LINE-COUNT 058(001).

TABLES: CRHD, "Work Center Header
CRTX, "Text for the Work Center or Production Resource/Tool
CRCO. "Assignment of Work Center to Cost Center

SELECT-OPTIONS: S_WERKS FOR CRHD-WERKS DEFAULT 'XX',
S_LVORM FOR CRHD-LVORM.

SELECT * FROM CRHD WHERE LVORM IN S_LVORM
AND WERKS IN S_WERKS.
CLEAR CRCO.
SELECT SINGLE * FROM CRCO WHERE OBJTY = 'A'
AND OBJID = CRHD-OBJID
AND ENDDA => SY-DATUM.

CLEAR CRTX.
SELECT SINGLE * FROM CRTX WHERE OBJTY = 'A'
AND OBJID = CRHD-OBJID
AND SPRAS = 'E'.

WRITE: / CRHD-LVORM,
CRHD-WERKS UNDER 'Plnt',
CRHD-ARBPL UNDER 'Work Center',
CRCO-KOSTL UNDER 'Cost Center',
CRTX-KTEXT UNDER 'Description'.
ENDSELECT.

TOP-OF-PAGE.
WRITE: / SY-DATUM, SY-UZEIT, SY-REPID, SY-UNAME,
SY-PAGNO.
SKIP.
WRITE:/3 'Plnt',
8 'Work Center',
20 'Cost Center',
33 'Description'.

*-- End of Program
Bookmark and Share

Saturday, July 11, 2009

Tcodes used for SAP Plant Maintenance

IA07 Display General Task List
IA03 Display Equipment Task List
IA13 Display Functional Location Task List
IR03 Display Work Centre
KO88 Settle Order (Single)
IW32 Change Work Order
IW31 Create Work Order
IW33 Display Work Order
IW38 Work Order List Editing - Change
IW39 Work Order List Editing - Display
IW40 Work Order List Editing - Display Multi Level
ME21 Create Purchase Order (pre R4.6)
ME21N Create Purchase Order (R4.6 onwards)
IP41 Create Single Cycle Plan (R4 onwards)
IE02 Change Equipment
IE01 Create Equipment
IE03 Display Equipment
IE05 Equipment List Editing - Change
IE08 Equipment List Editing - Display
IW42 Overall Completion Confirmation
IW26 Create Notification
QS42 Display Catalog
ML81 Create Service Entry Sheet
MM03 Display Material
CS03 Display Material BOM
IW13 Material Where Used List
IW66 Change Notification List of Tasks
IW67 Display Notification List of Tasks
IW22 Change Notification
IW23 Display Notification
IH01 Display Functional Location Structure
MB11 Goods Movement
MB31 Goods Receipt
IW8W Goods Receipt for Refurbishment (R4 onwards)
IP02 Change Maintenance Plan
IP03 Display Maintenance Plan
IP10 Schedule Maintenance Plan
IP30 Deadline Monitoring
IP11 Change Maintenance Strategy
IP12 Display Maintenance Strategy
IP19 Maintenance Scheduling Overview Graphic
IP24 Maintenance Scheduling Overview List
IW28 Notification List Editing - Change
IW29 Notification List Editing - Display
IW30 Notification List Editing - Display Multi Level
IW64 Change Notification List of Activities
IW65 Display Notification List of Activities
IW68 Change Notification List of Items
IW69 Display Notification List of Items
IQ03 Display Serial Numbers
IW24 Create Notification
IP42 Create Strategy Maintenance Plan (from R4 onwards)
IW25 Create Notification
IL02 Change Functional Location
IL01 Create Functional Location
IL03 Display Functional Location
IL05 Functional Location List Editing - Change
IL06 Functional Location List Editing - Display
IW41 Time Confirmation - Indvidual Entry
IW48 Time Confirmation - Collective Entry with Selection
IW44 Time Confirmation - Collective Entry no Selection
IA11 Create Functional LocationTask Lists
IA12 Change Functional Location Task List
IL02 Change Functional Location
IA05 Create General Task List
IA06 Change General Task List
IA01 Create Equpment Task List
IA02 Change Equipment Task List
IE03 Display Equipment
IR01 Create Work Centre
IR02 Change Work Centre
CA85 Replace Work Centre
IP13 Strategy Package Sequence
IP14 Strategy Package Sequence
IP04 Create Maintenance Item
IP05 Change Maintenance Item
IP06 Display Maintenance Item
IP17 Maintenance Item List Editing - Change
IP18 Maintenance Item List Editing - Display
IP02 Change Maintenance Plan
IP03 Display Maintenance Plan
IP15 Maintenance Plan List Editing - Change
IP16 Maintenance Plan List Editing - Display
IK11 Create Measurement Documents
IK12 Change Measurement Documents
IK13 Display Measurement Documents
IK22 Measurement Documents List Editing - Create
IK21 Measurement Documents List Editing - Create
IK22 Measurement Documents List Editing - Create
IK18 Measurement Documents List Editing - Change
IK17 Measurement Documents List Editing - Display
IK41 Measurement Documents List Editing - Display Archive
IQ01 Create Serial Numbers
IQ02 Change Serial numbers
IQ04 Serial Numbers List Editing - Create
IQ08 Serial Numbers List Editing - Change
IQ09 Serial Numbers List Editing - Display
IK01 Create Measurment Point
IK02 Change Measurement Point
Ik03 Display Measurement Point
IK08 Measurement Point List Editing - Change
Ik07 Measurement Point List Editing - Display
Bookmark and Share

SAP TCode for SAP ArchiveLink: Link check

OACH
Bookmark and Share

Transparent Table Relate With PM Module

Like to know all transparent Table relate with PM module.

Try SE80 than fill the program related to PM transaction.
View Dictionary structures you'll get all table that related with PM
Trasaction code that used in PM eq. IW31, IW21, IW41

Try tcode DB15
Fill the object that related to PM Module
PM_EQUI Equipment
PM_IBASE IBase
PM_IFLOT Functional locations
PM_IMRG Measurement documents
PM_MPLAN Maintenance plans
PM_NET Object links, master data
PM_OBJLIST Serial Number History
PM_ORDER Service and maintenance orders
PM_PLAN Routings
PM_QMEL Maintenance Notifications

You can get all table that related to PM Object. *-- Nur Heri W

What is the table for FUNTIONAL LOCATION BOM?

Check for the following tables:

TPST Functional Location - BOM Link
STAS BOMs - Item Selection
STKO BOM Header
STPO BOM item
STPU BOM Subitem
STZU Permanent BOM data

Looking for a report which have Reservation No , material, posted quantity along with User ID of person who created the reservation in PM Order?

This is one report I am asked for at every business I work at and there isn't a standard SAP report for what you want. MB25 will give you what you want but the Username on the report is the person who picks the reservation not the person who created it. At one business I was at it reported as "Batch" because the picking run was done in the background.

The report I create is a query using SQVI Quick viewer and then I transport it to SQ01 SAP Query so everyone can see it. The tables you need to use are;

RESB - Reservation, Material number, Requirement date, Required Quantity, Quantity withdrawn, Work order number
RSADD - Date created, User ID of person who created the reservation
MAKT - Material Description
AUFK - Work Order description
AFIH - Revision (as a selection field)
MBEW - Total valuated stock (SOH)
USER_ADDR - The User ID first name & second name
RKPF - Reservation Header information if required.

How they are joined together is hard to explain but if you can use Quickviewer you should be okay.
Bookmark and Share

Effective SAP PM Implementation SAP

What the critical success factors for an effective PM implementation?

by :Alok

Succes of PM implementaion & use largely depends on user discipline. There are several ways to enforce business discipline:

1. Make a Plant maintenance KPI for the Head maintenance and his sub-ordinate

2. Training: People need to be trained to use SAP and more importantly in your business processes. If people understand why they need to do something they are more likely to do it.

3. Use of Workflow: Use workflow to automate the process. For example when a particular job is taken up by a planner group an email may be sent to the p[lanner.

4. System audit: carry out regular system audit and submit the report to the responsible maintenance engineer / Head.

5. Be Flexible: Be prepared to modify your business process. If you can deliver what the users want then definitely there would be lot of takers.

6. Discipline is the king: Make people aware of this fact through training and change mangement workshop.

Bookmark and Share

Deadline Monitoring for Maintenance Plans

Start deadline monitoring regularly (for example, using report variants). Deadline monitoring for a weekly strategy should ideally run every week.

For running the deadline monitoring, I got a simple solution:

Go to SM36,

- Enter the Job name. Select the Job Class. Click on

- Start Condition

- Select the Date/Time

- Enter the Start date and Time (Time at which the job has to be processed background automatically)

- Click on Periodic job.

- Click on Periodic Values and select the frequency - Daily

- Go to the Steps

- Enter the Program name and Variants (RISTRA20)

- Save the Transaction. Ensure the transaction (program)is released.

- Go to SM37.

- Select the job and job status and Execute

- The list of jobs will be displayed. The status should be released

For scheduling, the system converts all the on-hold maintenance calls, with a date that satisfies the call horizon , into a maintenance call object (for example, maintenance order)

The system also performs a complete rescheduling of the maintenance plan , and ensures that maintenance calls exist for the next n days (field Scheduling period in the Scheduling parameters screen). The system always generates at least one on-hold maintenance call.
Bookmark and Share

Scheduling function in SAP

What are the scheduling fuction in SAP - capacity planning for resources, leveling, producing a weekly/daily schedule, etc. Any help is appreciated.

Deesmith

First of all you have to create a maintenance plan via menu (Plant maintenance -> preventive Maintenance -> Maintenance planning -> Maintenance plans -> create -> Strategy plan.)

Or use transaction IP42

After creating the Maintenance plan you have allotted a Maintenance plan Number.

After that,

Go to Scheduling

Via Menu (Plant maintenance -> Preventive Maintenance -> Maintenance planning -> Scheduling for Maintenance plans -> Schedule.)

Or use transaction code IP10

In the initial screen of scheduling you have to enter the Maintenance plan Number that is required to be scheduled.

After selecting the relevant maintenance plan

Press Enter to continue

Pressing the start button or F9 starts scheduling.

An error can appear in case if counter is newly created and there is no reading exists. In this case, create a measuring document.

After you press start a dialog box will appear u have to enter the start date.

After entering the cycle start date the status is shown as NEW Start Save to call which means that Scheduling has started but on hold until saved.

You can save at this point. Enter the scheduling transaction again. Now press the schedule Overview list button, for scheduling overview. This shows current reading and next reading on which maintenance will be due. You can also enter any manuals calls in the manual calls tab. In the maintenance plan scheduling parameters tab, the call horizon percentage and scheduling period entered in the maintenance plan. In the Maintenance plan additional tab, some additional information is displayed. The next step is to save the current work done.

Bookmark and Share

Definition and Formula for PM terms SAP

Can somebody give me definition and it's formula for calculation of the following terms:
1. Equipment Uptime
2. Equipment Efficiency
3. Equipment Effectiveness

Vivek.K

The question is too vague to give a precise answer. Uptime, Efficiency and Effectiveness will depend on how you have defined these terms, what sort of plant/process you are measuring and how you measure them in practise.

Having said that, here is an attempt at answering your question

1. Uptime is the total time that a machine or process is available to perform its function.

UPTIME = Total Time Available - Downtime

Downtime consists of both planned and unplanned events.

2. Equipment Efficiency - What do see as the difference between 2&3?

3. Equipment Effectiveness as defined by Overall Equipment Effectiveness:

OEE = Availability Rate x Performance Rate x Quality Rate

Availability Rate = %Uptime of Total Time

Performance Rate in most cases is related to Mean Speed as a percentage of Max. Speed. Utilisation is also a concept that fits into this category.

Quality Rate is an expression of Good(conforming/saleable) products as a percentage of total products made.

A, P and Q are all efficiencies in their own right.

Hope this helps.
Bookmark and Share

SAP Plant Maintenance Assembly

Assemblies are not plant-specific. They are considered design/phantom/grouping type of materials. They aren't physical materials but rather a grouping of physical materials.

The idea is that you create an IBAU for each of these "groupings" of parts then you create a material BOM (or rather a maintenance assembly BOM) in CS01 like you would normally do for a typical material BOM except that the parent or source material is your new IBAU.

Next you would create an equipment BOM where you would add your IBAU as a component of that equipment BOM. Since maintenance assemblies (aka IBAUs) are not plant-specific you must add the IBAU to the equipment BOM as a PM Structure Element (BOM Item Category of "I").

If you want to go the route of using construction type then the idea here is that you would create a material BOM similar to the equipment BOM. The difference is that instead of an equipment BOM pointing to material BOMs you would have a material BOM pointing to other material BOMs where the master material of this whole BOM strcuture is actually a material representation of the equipment.

For example, let's say you have 5 pumps with identical BOM structures. You would create a material called PUMP then proceed to create the BOM structure for a typical pump. After this you would create your 5 pumps as equipment and assign them a construction type of the PUMP material. In this way your equipment will now inherit the PUMP BOM structure.

The benefit/drawback to using construction type is that your BOM structure remains the same for all equipments using that PUMP construction type.

Bookmark and Share

SAP Track New Plant Machine Installed at Customer Site

My business requirement is that the plant people will installed new machine at customer site.
So how can I track this scenario in SAP Customer Service module?

You can use functional location to describe in geographical sense the areas where customers are located.

Create Functional Locations based on the Structure indicator you define in IMG

Ensure that in strucutre tab "Equipment Installation Allowed " check box is checked.

Whenever you carry out the installation of equipment , ensure that the Equipment is installed in the Sturcture Tab in the Functional Location field.

Since you have created the functional location as that allows installation, you can install the equipment.

However note that the equipment category should be "S" Customer Equipment.

In case you use Customised category you will need to be maintain the same in IMG.

The path is:

Plant Maintenance & Customer Service - Master Data in PM & CS - Technical Objects - Equipment - Equipment Categories - Maintain Equipment Category.

Bookmark and Share

Questions Answers on Functional Locations SAP PM

Q: Is the functional location structure indicator unique across the system?
A: Across clients but not systems.

Q: What must you do if you have assets (functional locations) with the same number in several plants?
A: You must use the plant reference number as the first level of the functional location structure.

Q: Which functions can be executed with functional locations and reference locations
A: Function
Functional Location
Reference Location
Install Equipment
Yes
No
Create Order
Yes
No
Assign Measuring Point
Yes
No
Classification
Yes
Yes
Assign Documents
Yes
Yes
Enter Multilingual Texts
Yes
Yes

Q: What is the menu path for displaying the structure of a functional location in list form and as a graphic?
A: plant maintenance>technical objects>functional location>structual display

Q: Give five examples of functional location structures.
A: Chemical Process, Energy (power station), Property Management, Transport, Steelworks, Production line.

Q: What steps must be defined in customising for alternative labelling?
A: Activate alternative labelling and indicators for primary label. Create a new structure indicator, define labelling system.

Q: How do you define an own view for alternative label?
A: Activate alternative labelling, define labelling systems for functional locations, enter label internal view.

Q: What level of functional locations should be changed for alternative labelling?
A: Second level functional locations are to be changed, in changing master records extras>alternative labels>overview, change label ‘internal view’ choose structure indicator and press refresh.

Q: What is the menu path for creating a user profile?
A: Plant maintenance>technical objects>functional location>labels>user profile.

Q: What functions are determined by the category of the functional location?
A: Change documents, status profile, asset, object information key, partner determination, measuring point category.

Tips by : Bill

Differentiate between reference functional location and functional locatrion.

Reference Function location is a logical Function location its not a physical functional location like a functional location.

You can not install an equipment to an reference functional location since it is not a physical location.

Reference functional location is used when you want to create several similar functional location.

Assume our Structural indicator is xxxx-xxxx-xxxx If you need to create serveral functional location in the second hierarchy level like xxxx-ABCD, xxxx-EFGH, xxxx-IJKL etc (any no of FL)

You need not enter the details like structural indicator , location , plant, main work center, mainteanace plant etc everytime you create a new FL with these common datas.

Instead you create RFL like AAAA-BBBB give these common datas and use this RFL as reference for new FL you create.

This triggers horizontal data transfer for all the FL you created through reference to this RFL.

It save lots of time while giving data. Also if you need to modify a data, you can modified at only one level ie RFL it automatically gets copied to all the FL that has referenced. So data maintenance is global.

Bookmark and Share

SAP Questions Answers on PM Equipment

Equipment
Q: How do you create a new equipment category in customising?
A: IMG>plant maintenance>master data in plant maintenance>technical objects>equipment>equipment categories>maintain equipment category.

Q: What functions are determined by the category of the equipment?
A: In the IMG transaction for defining equipment categories, reference category, change documents, alphanumerical numbering, work flow event, object information key, view profile can also define additional business views and number ranges in other transactions.

Q: What settings in customising are available to create a view profile.
A: Using the transaction in the IMG >technical objects>general data>set view profiles for technical objects the following settings are possible:
Screen group by technical object (floc, equip), Tab number, description, active tab indicator, 4 possible sub screens per tab, 18 sub screens available for choice, icons and texts.

Q: Which business views can be activated in addition to the view profile?
A: PRT’s, SD data, Config, Serialisation, Other data.

Q: What transaction is used to allow the equipment category to be installed at the functional location also what transaction is used for the usage of equipment to be defined, what other settings are possible?
A: Transaction OIEP, define installation at functional location, indicator for install. OIEH for defining usage history, mark the time segment field with an X (yes).

Q: To review changes made to an equipment over a period of time what functionality is used, what settings are made in customising?
A: Extras>action log displays changes in the master data, change documents must be activated in customising.

Bills of Materials
Q: What is the usage type for BOMs in plant maintenance, where in customising is this defined, what usage indicators are available?
A: Usage 4 is for PM, transaction OICD ‘change BOM usage’ details the usage options, production, end/design, spare parts, pm, sales and costing.

Q: What other BOM usage types are available?
A: Production, Engineering Design, Spare Parts, Sales and costing.

Q: What default item categories are predefined in the system, what customising transaction is used?
A: Transaction OICK, define item categories in customising is used, D - document item, I – PM structure element, K – class item, L – stock item, M – intra material, N – son stock item, R – variable size item and T – text item.

Bookmark and Share

SAP PM Measuring Points Questions

Measuring Points:
Q: What predefined categories of measuring points are available?
A: Measuring point general and general usage. Each has a different uniqueness check.

Q: What settings are available in customising for measuring point categories?
A: Uniqueness check, catalogue type, message setting and tolerance period for measuring time in future for measurement document. Settings are made in transaction define measuring points categories.

Q: How is counter replacement shown in the system?
A: The counter replacement is shown by using (create) a measure document to enter the value of the new counter, the difference is 0. The menu path is edit>replace counter.

Additional Functions:
Q: Can an object link to a web address be created for a master record, how do you proceed?
A: plant maintenance>technical objects>equipment>change. Screen displayed: change equipment >system>links.

Q: Send the master record of equipment to another person using the office functions, how do you proceed?
A: plant maintenance>technical objects>equipment>change. Screen displayed: change equipment >system>workflow>send object with note

Q: What functions are defined in customising for partner determination, what transaction is used?
A: IMG>master data in plant maintenance>basic settings>partner data>define partner determination procedure, transaction VOP2, there are 13 different partner functions to choose

Q: How do you assign a partner determination procedure to a piece of equipment?
A: IMG>master date in plant maintenance>technical objects>equipment>assign partner determination procedure to equipment category, transaction OIEV. Select row and enter procedure, responsibilities for some determination procedures can be entered, i.e. ER for employee responsible etc.

Q: Display the user status procedures available in customising, what statuses are maintained, how is the status regulated, which business management operations are allowed for an example status?
A: IMG>master data in plant maintenance>basic settings>maintain user status, transaction OIBS. Select profile to view details, business transactions can be controlled via indicators for influence, allowed, warning, disabled and active etc. Where statuses have a status number, this means that the statuses mutually exclude one another, that is only one status can be set any one time. Statuses are allocated lowest and highest numbers which determines when the can be displayed, example: highest can only be switched upward.

Q: How do you assign the user status profile to a piece of equipment?
A: IMG>master data in plant maintenance>technical objects>equipment>assign user status profile to equipment category. Transaction OIEB.

Serial Numbers:
Q: To display the serial data view in the master record and what settings in customising to allow this are required?
A: To display serial data access transaction IE02 change equipment click serial data tab, define the additional business view for serialisation in customising transaction OIEG to activate serial data tab.

Q: What does the stock check of a serial number comprise?
A: During the stock check of a serial number, the stock batch, master batch, special stock, customer, and sales order are also checked in addition to the plant and storage location if a goods movement occurs. This ensures synchronisation of stock information in the serial number with that in materials.

Q: How is the stock check configured in customising?
A: IMG>master data in plant maintenance>technical objects>serial number management>define serial number profiles, OIS2 - the stock check is activated for each serial number profile in the column STKCK. You can also define how the system should respond in the event of inconsistencies, warnings, errors or no stock validation.

Q: What settings can be defined for the Serialisation of Equipment, what transaction in customising is used?
A: IMG>master data in plant maintenance>technical objects>serial number management>define serial number profiles, OIS2. The available settings are: existing requirement (created first indicator) equipment category assignment, stock check and serialisation procedures by usage and proposal type for equipment (on processing of procedure)

Bookmark and Share

Plant Maintenance Q & A - Rept & Analyses - Mgt of Task Lists

Reporting & Analyses
Q: What are the components of the maintenance history?
A: Completed notifications, completed and historical orders, usage lists.

Q: How can you display a list of install locations for a piece of equipment?
A: In transaction IE02, change equipment use the menu path >extras>usage list, ensure location field is displayed in the
current variant.

Q: What are the central modules for evaluations and analysis in the PMIS?
A: Information structures form the basis for standard analysis, they contain a combination of characteristics and key
figures with time base (period) The available information structures are: S016, S062, S063, S065, S115 and S116.

Q: What is standard analysis, what are available in SAP?
A: Standard analysis are complete predefined analysis that stop at one of the standard information structures. The
following are available: object class, manufacturer, location, planner group, damage analysis, object statistics, breakdown
analysis, cost analysis.

Management of Task Lists
Q: How is usage, status and increment controlled for the task list and how can these parameters be predefined for the user?
A: From within the transaction IA05, create general task lists, status and increment are defined by populating the user
profile with the parameter PIN and value of increment example 0000001.

Q: How does the control key come into the task list as default?
A: The control key is copied from the work centre default values screen

Q: What is the structure (main components) of a task list?
A: The task list comprises of a header containing default data, an operations screen containing details of tasks to be
performed during maintenance and there is an components screen containing spare part material information. There are also
functions for relationships, PRT’s and where applicable functions for inspection characteristics, service and maintenance
packages.

Q: What types of task lists are available?
A: Functional location, equipment and general task lists?

Q: What is different about general task lists?
A: Unlike functional location and equipment task lists, general task lists are maintained independent of a object, the
general task lists can be split by group, each group can have a maximum of 99 counters which can be regarded as individual
task lists. The functional location and equipment task lists are object dependent, the object acts as the group in this case and
there can be 99 task lists per object.

Q: Making a cost estimate for a task list, how would you proceed?
A: Use transaction IA16, evaluations>task list costing.

Q: What options are available for entry of task lists into a work order?
A: Direct entry, to reference object, general task lists for assembly, general task lists for object structure and general
task lists.

Q: Generate a where used list for a work centre, how do you proceed?
A: Evaluations>work centre where used, transaction CA82.

Q: How do you create a configuration profile for configurable task lists?
A: Plant maintenance>planned maintenance>maintenance task lists>task lists>general task lists>configuration
profile>create

Bookmark and Share

SAP PM Maintenance Planning Questions and Answers

Q: Create a single cycle plan, how do you proceed?
A: Planned maintenance>maintenance plans>create>single cycle plan, transaction IP41. The single cycle plan is used in the situation where you need to perform a singular frequency of maintenance. The plan contains data and functions similar to that of a normal strategy based plan but does not have a relationship with a strategy or maintenance packages.

Q: In a strategy based plan what scheduling parameter settings are available?
A: Early, late shift factors, early late +/- tolerances, cycle modification factor, factory calendar, call horizon, scheduling period, unit of scheduling period, requires confirmation indicator, scheduling indicators for time, time key date and factory calendar. Where a plan is created with relationship to a maintenance strategy the scheduling parameters in the strategy are copied as a default to the maintenance plan, the scheduling period, unit and requires confirmations are not active in the strategy. When creating the plan from scratch you can also specify a start date to prompt maintenance scheduling.

Q: What are the available standard maintenance plan categories, what is the purpose of the category?
A: The available maintenance plan categories are: MM for services which places a call object of a service entry sheet and PM for plant maintenance which calls a maintenance order, a notification can also be a call object. The category links the plan with the call object that is to be produced.

Q: How must the scheduling parameters in the maintenance plan be configured so that the call date falls exactly on the planned date?
A: The call horizon must be set to 100%. The call horizon dictates when the order should be called.

Q: To start scheduling a strategy maintenance plan what are the options?
A: Start @ recent or current date and start in cycle at last known maintenance package – start in cycle utilises an offset of number of days in starting the plan in cycle of maintenance package. When the maintenance plan is scheduled the option to restart is made available.

Q: Describe the process for attaching multiple notifications to one work order?
A: Plant maintenance>planned maintenance>maintenance planning>maintenance plans>change. Enter selection criteria as required and execute, select the required notifications and press the button create order.

Q: What function (transaction) schedules and generates orders for maintenance plans?
A: Deadline monitoring offers this facility, transaction IP30 can be used to schedule and generate orders for maintenance plans, this function can also be set as a automatic batch job.

Q: Define the structure and options of a maintenance strategy?
A: The strategy comprises of a header and contains the following scheduling parameters, early, late shift factors, early late +/- tolerances, cycle modification factor, factory calendar, call horizon, scheduling indicators for time, time key date and factory calendar. The strategy also has a relationship with maintenance packages; the maintenance packages are the cycle of frequencies at which maintenance inspections are required. The package options: cycle length; unit of cycle length; offset, prelim and follow up buffers and also in hierarchy that dictates when each is called.

Q: What is the purpose of the preliminary and subsequent buffers in the maintenance packages of a maintenance strategy?
A: The preliminary buffer is the lead float in a number of days that affects the order start date in the order. The subsequent buffer acts as the follow up float days again a number of days that you specify which will affect the finish date in the order. The calculated order start and finish date is a default value that can be overwritten by the ordering scheduling value, this is dependant on the setting for order dates in customising.

Q: In the scheduling of maintenance plans what options are available for the manipulation of calls placed on the scheduled call board (tab)?
A: The following options are available: release call (immediate release to create order) fix call (change date of call) skip call (cancel call) restart (restart scheduling of plan) manual call (place a manual cal)

Q: How can you lock a maintenance plan for scheduling?
A: Within the transaction IP02 change>maintenance plan, the function to make the make the plan inactive.

Q: What is the function of a cycle set?
A: The cycle set is used as a copy reference for cycles when creating a multiple counter plan. The cycles can be changed in the maintenance plan, without the cycle set being affected.

Q: What is the difference between a cycle set and a strategy?
A: The difference between a strategy and cycle set is that a strategy always has cycles of the same dimension, whereas a cycle set can have cycles of different dimensions.

Q: What transaction is used for creating a maintenance plan for services?
A: Plant maintenance>planned maintenance>maintenance planning>maintenance plans>create>create>for contract item. Also customer service>service agreements>environment>sales & distribution>service products for maintenance.

Bookmark and Share

SAP PM Support Problem Solution

How can I hide a tab page from equipment master. e.g I want to hide the tab page 'Classfication ' ?
How I can add new tab page say ' New Clasification' ?

You need to create/change view profile attached to the relevant equipment category. You can change add or hide any of the tabs present for usage and also set any tab title.

Plant Maintenance and Customer Services-> Master Data in Plant Maintenance and Customer Service
->Technical Objects ->General Data -> Set View Profiles for Technical Objects

Then assign this profile to the equipment category in :
Plant Maintenance and Customer Services-> Master Data in Plant Maintenance and Customer Service
->Technical Objects -> Equipment -> Maintain Equipment Category *-- Ravi Dixit

How to attach a word document as well as an excel file to an Equipment?

You can attach the Word or Excel file to the equipment,

1) Go to change mode of Equipment ( IE02) put the equipment no. for which you have to attach the file & enter.

2) On left hand side on top you will find the button, services for object click on it.

3) Go to Create --- Create attachment now the sytem will allow you to attach the file.

4) To view the attachment again click on same button & click on attachment list. *-- Hemant

Any one can give idea to attach , some document templet ( doc , htms , text etc.) to notification?
Our appliction entails WHY-WHY analysis sheet attachment to notification.
1) selecting notification type, why - why sheet should be attached automatically.
2) why why format will be a templet and will be fixed cutomer based format.
3) on notification display report, if document is attached the there should be visible link .

In the notification creation screen there is a button for "Services for Object". In that select "Create Attachment". Locate the file and attach it. The attachment list will be shown if you again click the same button and select "Attachment list". The list will show the documents attached and you can view by clicking them.

We also do Why-why analysis but in a different way. Instead of bothering with the existing format/template, we looked into the contents of the analysis. We found that the information actually was which part got damaged, what was the damage and the cause for the damage.

These information can easily be codified and included in the notification itself as 'object part', 'damage code' and 'cause code'. The user has to only select the relevant codes which pertains to the why-why analysis. Later on you can also conduct a search on the number of notifications pertaining to "how many times a "shaft of a pump" (object part) got "sheared" (damage)..." and know the causes for it.

The codes for these - object part, damage code and cause code can be created through the maintenance of Catalog profile.
*-- Sundar

What are Order Steps in Plant Maintenance?

Following are the steps:

1) There are 2 ways to create the order, you can create directly by using t-code IW31 or you can create through notification also.
2) Release the order.
3) Assign the operations, & components if required for that order.
4) Goods movement for order t-code MB11
5) Confirmation of order t-code IW41
6) Teco the order t-code IW32
7) Settlement of order t-code KO88
8) Closing of order t-code IW32
Bookmark and Share

Maintenance of FT Data in Purchasing Documents

Use

This function allows you to maintain foreign trade import data in purchase orders and shipping

notifications.

To maintain data in

Menu path

The purchase order header

In the purchase order, choose Header Foreign

Trade / Customs

A purchase order item

In the purchase order, select the item and choose

Item More functions Foreign Trade / Customs

The shipping notification header

In the shipping notification, choose Header Foreign

Trade / Customs

A shipping notification item

In the shipping notification, select an item and choose

Item Foreign Trade / Customs

Bookmark and Share

Friday, July 10, 2009

Control the SAP PM Order Type

Suppose you want to control the PM order types PM02 (preventive maintenance) to come only from the Preventive maintenance plans.

Also, you would like to control the creation of this type of orders via the orders creation option (transaction IW31).

Well, you can create two order types for preventive maintenance.

The first is used for orders that will be performed by internal personnel.

The second is for orders that will be performed by outside contractors (external).

You can then configured them so that internal orders are automatically released when the maintenance plan is called.

The external orders are configured so that they are created but not released when the plan is called. The planner then makes arrangements for the work to be done then he releases the order.

Order types in PM

Where can I define functions and settings for each order type? or at least look at the notification type for each order type.

SPRO --> PM CS --> Maintenance and Service Processing --> Maintenance and Service notifications --> Notification Creation --> Notification Types --> Assign Notification types to Order types.

Tcode: OMI3

This transaction is not in the S000 menu. This is a customizing transaction .... in the IMG menu.

Bookmark and Share

Maintenance Notifications Order Link

Generally the links between Maintenance Notifications and Order are :-

Assigning a Notification to an Existing Order
You can specify the number of an existing maintenance order in the maintenance notification while you are processing it.

Assigning a Notification to an Order
You can process an existing maintenance order and specify in it the number of the maintenance order that should be assigned to it.

Assigning many Notifications to an Single Order
This occurs when a series of Equipment that are in a pipe line have to maintained. ex. Shut down maintenance typical of a Refinery or a power plant.

You can combine several maintenance notifications that refer to a particular object in a single maintenance order. This could be the case if, for example, several defects are to be repaired at the object on one maintenance date.

When planning concrete tasks in an order, you can make reference to several maintenance notifications or technical objects. For this purpose you can use object lists, which contain all relevant maintenance notifications and technical objects.
Bookmark and Share

Work Order Cost Control SAP

I am trying to control costs on work orders that relate to a project that is approved for a set amount.
We havent implemented PS yet, so we are using PM06 work order types to segregate those project work
orders.

I am thinking to create a work order hiearchy that settles to an internal order. But, I am not sure exactly how internal orders work.

In each equipment master related to projects assign internal order number instead of cost center. In settlement profile give settlement receiver as order instead of cost center.

So whenever you will create order aginst that equipment system will create settlement rule for Internal order.

If don't want to maintain this way then at the time of creating order you have to modify the settlement rule
and assign receiver as ORD and provide internal order number.

Bookmark and Share

Impact on Business if PM Order Not Settled

What is the impact on business, if PM order is not settled. That is if settlement of the order is not done, what
is its impact on the business process.

Manoj

The cost will go to G/l account as soon as the goods movement is done or service entry sheet is accepted. Only thing is that the cost will not be reflected in the cost center.

Sharma Tarun

The work order is a PM cost object. It can hold costs. for example, when a time confirmation is done, and it is saved, the cost centre in the tech object is debited and the work order is credited with those costs.

What then should happen is settelment occurs and the work order is debited and the cost centre in the work order operation is credited

If settlement does not occur, those costs sit on the work order. The problem with this is that because the costs do not settle they are not transfered to the operation cost centre. In simple terms, this then means that the cost centre of the maintainers who did the work, does not get paid!

It also causes problems with reporting, and cost management from Controlling, and can significantly affect your maintenance budget (depending upon your business processes)

Bookmark and Share

SAP In PM how to Return Material Backflushed

Blackflushing does not mean returning of material to stores.

With backflush infact the component allocated in BOM get consumed at the time of operation/order confirmation.

If you set the backflush then all materials allocated to the Work Order will get issued from stores automatically. So there is no need to do a separate MB1A or MIGO Goods Issue.

To return item to store you will have to do a reversal from WO back to stores using Movement Type 262.

I want to issue spares in advance to engineers without a service work order....Later on the spares will get consumed or will get returned. How do I do it...and what is the Movement type to be used for issuing and reversing........can any one help.

Still I have problem in back flushing. Suppose I made the indicator of backflush in creation of order, then I completed technically, then the actual cost of material not updating, (Note I have not posted the material in MB1A) what is the problem, pls tell me.

Did you confirm your maintenance order? Unless you confirm it (IW41) your actual cost will not be updated. Backflushing is a tool so that during confirmation you will not anymore input your
materials. System will confirm your consumption base on the order (IW31) you have created.

I believe T-Code IW41 is used to confirm the operation and not for materials. When backflush indicator is set in the order for the components reserved then MB1A need not be done and when we say determine cost thru the main menu, the material cost should appear.

Actually IW41 works like CO11 (PP module), when you tick the backflush indicator in the order creation the system will automatically copy those materials when you confirm it.

Try doing these steps:

1. Create order (IW31)
2. Assign a component to the order and tick the backflush field. (make sure that the component you assign has stock and valuated in the material master - check it thru MM03, accounting and costing fields)
3. Check availability of material and release
4. Goto IW41, enter hours and tick the material icon on the tool bar (you would notice that the materials that was backflush are already copied in the confirmation, try unticking the backflush icon in IW31 and you would notice that the component field will be empty because no material are backflushed)
5. Save
6. Check cost and it would reflect the material consumed. Actually you don't need to go to the component field for it to confirm your consumption. It will automatically post all materials backflushed upon saving your confirmation in IW41. In short you still need to confirm your order, thru IW41, for the materials to be consumed. MB1A are actually used for set-up where in the one issuing the material to the order are not the same person who is confirming the maintenance order.

I hope this clarifies everything.

Thank you so much. Yes it works......thanks a ton.
But I have a suggestion. I did whatever you said....but what I noticed was once I reserve a component in the order thru IW31 trasanction and release the order and go to main function and say determine cost, the materials cost is automatically copied into the order....Yes the material should exist in the material master.......

I feel in the same order when we want to calculate the labour charges involved in particular operations we need to go thru IW41 and confirm the operations so that we can get the labour charges for the personnal involved in that order.(this will be done by way of calculating the Activity types).

Your right material cost is automatically copied into the order thru IW31 but these costs are only planned cost. Meaning no accounting documents is being created and no materials being consume to the order only reservations.

If you want to have the actual cost reflected you have to go thru IW41 first.

Bookmark and Share

Change Maintenance Strategy in General Task List

I want to change Maintenance Strategy in General Task List within Tasklist Group. E.g. Tasklist "T3" - Counter 3 with Maintenance Strategy

"A" to "B". Tasklist "T3" has been used for several times in scheduling.

I try to use IA06, Goto T3 Header - and found Maintenance Strategy at Header was Gray. I don't find this documentation in SAP Help.
Is it possible change Maintenance Strategy in Tasklist after created?

To change the strategy of a task list which has already been used, we should check the following conditions.

1. The task list should be removed from all maintenance items.
2. Then maintenance package ticks in the task list has to be removed.
3. Then system allows you to change the strategy.
4. Then assign the new maintenance packages (Tick marks).
5. Now assign the task list back to maintenance items.

Trust this shall be useful to you.

Once the Task list has been created with one maintenance strategy it is not possible to change it to another strategy type. You can delete the strategy provided you have not used it in maintenance items. But in your case it is not possible.

You cannot change a strategy as you know, Copy the task list you want to change, then create the new strategy on your new task list.
Then create a new maintenance item and allocation of the task list with the correct maintenance strategy.
Then create a new maintenance plan and link maintenance item.

Maintenance strategies if I am not using any calender

While creation of maintenance strategies if I am not using any calender, then system will use which calender days shedule plans?

Is it 365 days working?

This depends on the Scheduling indicator you choose for the Plan!

If you select "Time", then, it will be based on 365 days an year.
If you select "Factory Calender", you need to specify the FC.

Maintenance strategy.Transaction code-ip11

I entered following parameters in the strategy.

Scheduling indicator -Time
Strategy unit -MON
Shift factor for late confirmtion -60 %
Tolerence for late confirmation -100%
Factory calender w8.

All above parameters are getting transpered to Strategy Maintenance Plan (Tran.code ip42) except factory calender.

Can any body tell me what will be the cause of problem.

Scheduling indicator = Time factory calendar does not matter
If you want factory calendar to work choose
scheduling indicator = time-factory calendar.

Bookmark and Share

User Status Set Date in Maintenance order

Which table we can get the information about on which date a particular User status has been set in a maintenance order? We get that information in Order Log, but I want to know in which table that information is stored.

Table JEST gives the system /user status associated with an order, but it doesnot give any information about on which date a given status was set. I tried search infomation in table CDHDR/CDPOS but no success.

I found out the related table. Its JCDS.

I believe that’s user status of Equipment, not Maintenance order.

He is correct. JCDS is the change document or version history of JEST which is the primary status table.

Statuses are handled separately from the object in question since each object can have multiple statuses and since statuses can be applicable to more than one object type. That means that the status tables contain statuses for many different objects like equipment, work orders, functional locations, sales orders, etc.

The status tables are based on object numbers which are a concatenation of the object type and the table of that object. Order #816025 would be stored as "OR000000816025". Equipment 20701817 would be stored as "IE000000000020701817". Sales order item 10 of 5215 would be stored as "VB0000005215000010".

Here are some key status tables:
JEST - Object Status
JCDS - Change Documents for Statuses
JSTO - Status Object Information
JCDO - Change Documents for Status Objects
TJ02 - System Statuses
TJ03 - Object Types
TJ04 - Status Control for Object Type
TJ20 - Status Profiles
TJ30 - User Statuses

Just to add in your valuable info on table...
TJ02T - Text for system status
TJ30T - Text for user status.

Many "check" tables (like TJ02 and TJ03) also have text tables as you've mentioned. You can easily find a text table for another table by going to "goto --> Text table" (not to mention that they're usually suffixed with a "T" anyway).
Bookmark and Share

SAP to best handle Repeat Maintenance Jobs

Has anyone got a good idea or method how to use SAP to best handle repeat maintenance jobs?

Actually, we are in the process of trying to sort out repetative jobs from thousands of notifications from last few years, which is by itself an arduous task. After that maybe we can think of a way how to handle the process to reduce these jobs to make the system more efficient. Anyone done something like this before in your Company?

By analysing all of your equipment's and having a clear mapping about the frequencies from your task-lists, makes the process relatively simple. You can then group the same type of frequencies into one Maint. Plan for example.

We operate a sleek mechanism to ensure all orders are produced only on the week they're due, using IP30 - deadline monitoring (RISHTA20) as a scheduled job.

We customised the "Sort Code" used in the Maint.Plan, in a way that reflects the frequencies as mention above. So the scheduled jobs are then created in exact accordance with those sort codes (i.e. frequencies). The maint. planner only has to assign which "sort code" for new plans and the scheduled job is doing the rest.

You should think only of a Notification as a polite request for a further action, like to create a maint. order etc. For example in our company, we don't generate any notifications, as we see them as additional handling for no great benefit. We always create orders direct from the scheduled job. These orders then go to the maint. supervisor's "..workflow..", and they then distribute the orders at their discretion However, if your organisation is huge with many divisions, then perhaps it makes sense to use notification, but only you can decided.

I always tell our project team's... Always do what's necessary and not always what is possible...

Bookmark and Share

Recording Measuring Docs. Against Work Orders

Has anyone recorded measuring documents (for an object/measuring point) against a work order. We can do it through notifications, but I was interested to see if someone has used work orders to capture measuring docs. if so then how did you do it. Measurement documents can be created during the order completion confirmation process (IW41/42). You don't need a notification.

You are right - we can recording measuring doc via IW42 - click in the Meaurement/counter readings button and the pop up windows appear.

You can also directly create measurement documents via your measurement points.
Identify your measurement points first and use IK11

Thanks Shirley, I forgot about the profile set up for completion confirmation config. You have to set the profile to show the meausring doc button. Thanks for the refresher, I had forgotten about it... :))

Bookmark and Share

Stop Complete Confirmation (IW41) before (IW32)

Any way we can stop the complete confirmation (IW41) being done with out doing (IW32)?

This will help you on your way forward:

In the SAP standard business model, if the user technically completes the works order, the following consequences occur:
1. Any reservations for which goods issues have physically been completed, but which have not applied in the SAP system, are deleted. There is then no way of recording the consumption of spares against the appropriate works order.
2. Any purchase requisitions that have not been converted into purchase orders are deleted.

The system does not provide any warning that these deletions have taken place. Furthermore, since the system permits simultaneous completion of multiple works orders (via IW38) there is a tendency to blindly close these works orders without adequate reviewing.

Because of these issues, I suggest the following method:

Block technical completion where there is any work planned and this has not been progressed to a point of final confirmation completeness; this process can be further enhanced by checking that key details on the related Breakdown/Unplanned Notification are complete.

This can be achieved by user exit "exit_saplcoih_004" when trying to do the TECO via IW38, which broadly proceeds as follows.
1. Evaluate the works order plan against actual confirmations, and determine if the activity is complete in quantity or by explicit completed flag.
2. Check the required fields on the breakdown/unplanned or call-out/after hours notification.
3. Confirm that no part of the tests in 1 and 2 failed. Where the works order and notification have failed, a report can then be generated explicitly defining all activity and information that must be completed in order to achieve technical completion.
4. If the user is allowed to override this block block, and elects to do so, then the order is closed according to the SAP standard method. This method clears open reservations and any purchase requisitions which have not been converted to purchase orders. I suggest a separate authorisation for the override so that you can still achieve control via segregation of duties.

The following Business rules need to be met for successful technical completion and should to be coded into the user-exit via your ABAP developers:

For the Works order:
- Internal operations: All final confirmations are required, or, if the operation is not to be completed then it is to be deleted.
- External operations and spares procurement: All purchase requisitions must be turned into purchase orders, which must be goods receipted. Alternatively, if the external spare or item of labour is no longer required then the PR, together with any follow on PO must be deleted.
- Internal spares: All reservations must either have the final goods issue completed or those items not required for the completion of the works order must be deleted.

For the Notification:
- Only applies to breakdown/unplanned and call-out/after hours notifications.
- Check that each of these fields is complete: the Breakdown flag, malfunction start and end date and time. For related Catalogs details for the Notification (if you are using them):
- For notification item number 0010: Check that the following fields have been completed: object part, failure code or text.
- For each of the notification causes: Check for a cause that is not deleted. Check that the code or text field is complete.
- For each of the notification activities. Check that each activity is complete.

To help your developers, the following tables will need to be accessed while processing the user-exit:






AFKO PP order header
T430 Operation/Activity control key
AFKO PP order header
AFVC Operation within an order
AFRU Operation confirmations
VIAUFKS PM Order Selection View
MSEG Document Segment: Material
RESB Reservations
AFVV Operation times.
AUFM Material movements for order.
EBAN Requisition items
EBKN Requisition items Account Assi
EKPO Purchase order
EKBE Purchase order history
EKKN Purchase order Account assign
JEST Object status
QMMA Quality notification activities
QMEL Quality notification
QMFE Quality notification items
QMUR Quality notification causes
QMIH Quality message maintenance data excerpt
IFLOT Functional Location
EQKT Equipment short texts
Bookmark and Share

Difference Between TECO & Business Completion

TECO, mean from PM point of view the order is closed. You cannot change anything , say time or dates in the order. But you can book a invoice say, the order contains a externally procured items.. So you might have done a GR and your PM order work is over.. you can do a Tech and still you can do a MIRO( ie invoice posting )

But if you do a Business Closing , you will not be able to do a MIRO..

Business closing means all the costs are posted and you dont expect any more cost posting. This business closing is a requirment of CO. If you don't do business closing and leave the order at TECH , the cost will recide in the order itself. As per the settlement rule , the cost should get transfer to the cost centre you have defined. But in TECH stage the cost is still in Order. Once you do a KO88 and then a business closing, the cost get transferred to a cost centre..

You need to make sure that all financial postings hav ben completed before doing a business completion.

You can use transaction CO99 to Business Complete your orders. Using this transaction allows you to select the number of days an order has been TECO'd before you business complete it. E.g if you are confident that all financial postings will be complete within 60 days, you cal select 60 days as the retention period. This means that orders have to be TECO'd for a period of 60 days before the system will select them for completion.

Batch completion PM orders is done with transaction CO99.
As a consequence, orders are completed if:
- Not yet administrative completed
- Technical completed longer than “a number of days” ago
- No open liabilities (open purchase orders – not yet invoiced purchase orders)

In our company we do Order closing in the following way:

1. IW41 - Complete confirmation
2. IW32 - Technical completion & Business completion
3. KO88 - Cost Settlement

Bookmark and Share

SAP Settlement Rule In Maintenance Order

In Maintenance Order, in settlement rule screen, there comes two lines with same cost center that it picks from Equipment Master. In one, it is FULL and other Periodic. What does it means or if there is any discrepancy?

If work is compleated 100% in one instant we will do the settlement rule in full, other wise if work is compleated half we will go for PER and remaining activity may be settelment rule other PER.

Maintenance Order settlement rule having 2 lines that is Per & Ful. Peroidic Settlement- in this settlement rule system settle whatever cost occurs upto today & suppose in future if you want to charge some more cost on the same Maint. Order then system will accept it. And when ful or Final settlement runs the rest of the cost will settle to the cost receiver.

But if you run final settlement then in future you will not able to chargeany cost to the same maint. order.

Does this means everytime when we are completing the Order we have deleted one of these two lines.

You need not to delete any line whether this is PER or FUL.

Its depends upon the settlement job which is done manually or schedule batch job. Suppose you has created schedule batch job for PER and FUL both. And the schedule frequency of PER is weekly and schedule frequency of FUL is monthly.

Just think that you have created one planned maint order on 2nd of December. And this job will start on 12th of December to 13th December and you have mentioned spares, internal manpower & contract in the maint order.

Now stores deliver the required spares on 10th of December and its cost is 10 lacks. Your internal manpower cost is 10,000/= INR and it is booked through IW41 on 13th of December. External / contractor cost is nearly 1 lacks and for this S. E. Sheet created on 20th December and accepted on 23rd of December.

Suppose the PER settlement job runs on 8th of December. So next PER settlement job will run on 16th December. This settlement job will settle the spares & internal manpower cost to cost receiver. Now next PER settlement job will run on 24th December. But this job never settle the remaining cost of the maint order because the PER settlement already finished.

So the remaining cost of the maint order will settle when FUL settlement job will start. When FUL settlement jobs runs system checks all the Maint. Order which is created in this month and carry any cost which is not settled then this cost will settle through FUL settlement.

Bookmark and Share

Integration Between PM, QM and PP

What is the integration between PM and QM in SAP?

There are many interwoven activities.

Let us consider one practical issue of Spare Parts purchase.

We prefer to inspect incoming material for compliance of our requirement.

1.While creation of material master, tick the 'Post to insp. stock' box in the Purchasing Tab.

2. If we do not want a task list / Result recording oriented inspection, in Quality tab, choose appropriate selections,

3.When that Spare is received, it will go to Quality Stock.

4. Maint. person can check it and transfer the stock to "Unrestricted Stock" through MB1B via 261 movement, giving a reason as Accepted after Inspection or Rejected.

5. Above procedure is a practical example of PM QM integration.

Tips by : Jamez Prabahran

Real SAP PM Ticket Raise :

When I schedule an equipment for preventive maintenance for a particular day say after 3-months, for that particular day, PP people will also schedule for their production, which should not happen. In equipment master data, if I put the PP work centre, it should solve the problem but I do not how is it going to solve? Another problem is PP people wants to create work centre as group of equipment but I will schedule only one equipment for preventive maintenance. So, if I put the group of equipment as work centre but I will schedule only for one equipment and when PP people will schedule for their production, machine availability of all the machines will be shown as zero?

In the equipment Master, under the location tab, mention the PP work center, and in the task list under the Header give the system condition "0" ie M/C not in operation, before doing this in the custimosation under Maintenace and service order---general data---- "Create System Conditions or Operating Conditions" check the box for PM reservation.so when ever a maintenance order is raised against that equipment, it will block the prod.

One doubt still remains that if PP people takes work centre as group of machine (say there are 4 lathe machines, now they want to take work centre as lathe for the whole group). So, if I enter this work centre in the location tab pages of the equipment master (in one lathe machine), whenever maintenace order is raised for only one lathe, will it block the production for the whole 4 nos of lathe machines or only for one lathe machine.

Since the order is raised against only one equipment, the work center for that particular equipment will be blocked.

Tips by : Giri

The linking is like this (my understanding)

PP work center is recorded in the PM equip master and PM order is created/rel for that particular PM equip.

a. If 4 m/cs together are defined as one PP work center and each of these 4 m/cs are individually defined as PM equipment and this PP w/c is recorded in each of the 4 PM equip master then a PM order for any or all of these PM equip will affect the PP w/c

b. If 4 m/cs have one to one relation as PP w/c and PM equip and have been respectively entered in the each equip master then whenever a PM order is created for a particualr equip only that particualr PP w/c will get affected.

Define the relation between the PP w/c and the PM equip based on how it is required for the business.

Tips by : Hari

How to configure the integration of PP and PM, where it is being done in SPRO, what are the pre-requisite and what are the steps.

By Bala:

In SPRO - Under Maintenanace and Service order ---> general data ----> "Create System Conditions or Operating Conditions" --> check the box for PM Reservation.

In the equipment Master,

Under the Location tab, mention the PP work center and

In the Order Header data,

Give the system condition as "0" ie M/C not in operation.

Bookmark and Share

PM Integration With Other Modules

MM-PM Integration

Tell me the integration of MM-PM , and generallyin what type of scenarios, and in which industries .

The integration aspects of MM-PM are:
1) for non stock materials requirement, purchase requsition can be created from the plant maintenance order. PR is converted to the Purchase order. when ever goods receipt is done , the cost is directly booked to the plant maintenace order.
2) for stock materials requirement,,reservation can be created from the plant maintenance order and the material can be issued to the order against the reservation.
3) Like materials , for services also PRs can be created from the plant maintenace order.

Another integration is BOM - Bill Of Material.
With Equipment BOM, you can create a list of material through which equipment is created or in othre words you can mention the spares that you may require during the maintenance of the equipment.

FICO-MM-PM Integration

Explain the integration points between PM and MM/FICO during the PM configuration.

Below are some integration aspects:

Integration with MM:
1.Material master record for Batch Managed material as Equipment
2.Reservations and Goods Issue for Maintenance Order
3.Material valuation class/types for refurbishment materials as equipment
4.Triggering PR from Maintenance Order

Integration with FICO:
1.Asset/Sub-Asset numbering in Equipment Master Data
2.Activity based costing for Operations performed through Maintenance Order
3.Settlement of accrued costs in Maintenance Order to G/L Account,Cost Center, Asset etc.,
Bookmark and Share

Control Maintenance Budget in SAP PM

The way to control maintenance budget in PM.

by : Santosh Satapathy

Maintenance budget

1) Hi, I just see some desperate attempt to know about maintenace budget and control but I hope can clear you all. Budget and control of order can be done to all the order type of sap pm orders functional background

As we know when creating equipment in maintenance master data we are using two work centeres one is location work center and the other one is responsibile work center. The location work center describes the line or area or section of production the equipment belongs and in the order the work center we maintain it maintains the cost per activity we define.
Suppose our maintenance team goes and do some work, say for two hours, so for this activity type what is defined in the controlling will be debited from the production line or section or area as it is maintained in pp. Of cousre when we settle the order and at the same time from the budget that much of fund deducted

Integration Part
a) actually this is done by co people
b) go to trans koab
c) tick the commit management in control indicators
maintain co-partner as semi active
you can maintain other things as maintaenance status and settlement profile
d) you should maintain object class as overhead costs orif you have service module you can do profitably analysis
e) you must maintain collective order without automatic goods movement
f) you can maintain status profile as your wish
g) for residence time i amintaied one month

2) then you have to maintain budget profile
for maintaining budget profile you have to goto trs ok0b
crate a budhet profile these are co people job

3) go to oioa here you assign budget profile to order type

4) in mantain budget profile
time frame -past means how many years past you can plan here start year is the referenace point
same with future
you must tick total values
annual values
exchange rate should be m-standard translation at average rate
activation type should be 1-automaticactivated when budget allocation done
budgeting currency-i choose controlling currency

5) then go to ko22 and assign the budget profile to order or group of order

This is the way I maintain budget for pm orders.

Bookmark and Share

Thursday, July 9, 2009

Before customizing the Master Data in SAP Plant Maintenance and Customer Service

You must have defined the plant maintenance organizational structure in your system before you proceed with customizing.

This involves maintaining the planning plants and maintenance plants as organizational units.

A distinction is made in Plant Maintenance between planning plants and maintenance plants.

The Maintenance plant is a plant where you can manage technical objects and the work centers responsible for carrying out the work in a maintenance plant.

The planning plant is a plant where you define maintenance task lists, carry out materials planning on the basis of the BOMs in task lists and perform maintenance orders, manage and schedule maintenance plans, enter maintenance notifications and process maintenance orders for the associated maintenance plants.

The recommendation is that yo should always use planning plants when maintenance planning is to be carried out centrally in one plant for several plants. If each plant is independent from a maintenance point of view, each plant is then also a planning plant.

Please note that there are many areas that will overlap with the implementation of components 'MM' (Materials Management) and 'PP' (Production Planning) when you are customizing the system for Plant Maintenance.

If you discover settings that are not relevant to Plant Maintenance, you should only change or delete these after consultation with the appropriate project groups.
Bookmark and Share

SAP PM - Material Master Vs. Equipment Master

If maintenance activities are to be carried out for an equipment and at the same time if an identical replacement is to be
maintained for it in inventory then is it better to create it from the material master rather than from
PM -> Technical Objects -> Create -> Equipment.

What is the significance of maintaining Functional Location BOM.

I would do both create a material number for consistency and the replenishment of equipment in the future and also assign it a unique equipment master record number.

In the equipment master record (I believe PM DATA screen), there is a construction type field which is by default an IBAU material. Link the material number to the equipment master. If you want to get real slick, create the equipment master record with reference to the material number. This way the description (short text) of the equipment is automatically populated by the Construction Type (IBAU material) as well as populating the Construction Type field.

The Functional Location BOM further enhances the hierarchy of the equipment master BOM via Component lists. Lets say you have several equipment (large assemblies) BOM's made up of smaller components (material). You could then create several large assemblies in the material master which would be the equivalent to the equipment (large assemblies) which have BOM's of smaller components (material) . Next, create a Functional Location BOM made up of several of these larger assemblies (material) . This will provide you with a nice hierarchy when running List Edit Display (multi level).

This is a rather complex situation because if the equipment is an asset then the repair costs should reflect the asset value too in some cases. Also the replacing equipment has its own cost record and I think you want to know which equipment number has the most costs collected.

There are a few other ways to control this situations:

1. Creating a sub work order linked to the main work order with the repaired material. So this sub work order should
collect the repair cost. This has the advantage that the main work order cannot be closed unless the repair has been
closed. (or a disadvantage in some cases)

2. You can also use the serialization utility, meaning creating a material number and link it to the equipment and activate
this utility in the material master record. For every movement in MM , it will ask for the related serial number and
accordingly to the proper equipment. So if you send this to the vendor I think this is an advantage to see how much
time this particular equipment has been send out for repair.

But as I said before, the whole process can be very complex if you want to follow it up properly.

In SAP, On what basis we decide to create either material master record or Equipment master record.
And what is the basic difference between Material Master record and Equipment master record.

In SAP a material is a representation of an object that can be procured, produced, assembled, sold, and replaced (among a couple other things). A material can exist as a physical object as stock and it can also exist as a virtual representation of a structure or process. Usually materials are handled as groups of objects (like 100 fenders or a dozen cookies of batch A or 4 panels in restricted stock).

An equipment is a representation of a single physical object that is handled at a much more granular level than materials. An equipment is typically installed somewhere and can have extra information (like warranty or measurement data) and can have maintenance done on it. Usually it's the individualization and maintenance aspect that determines if an object is an equipment or a material (a single entity for which you want to track data like maintenance work, history, or costs).

An equipment can also be linked to a material by indicating that the equipment is made of the material (as a generalization - construction type) and/or indicating that the equipment is actually an instance of a material (material plus serial number in the serial data tab).
Bookmark and Share

SAP PM Equipment FAQ

Q1: How do you distinguish, in a simple manner, between Equipment that is being charged and not charged for service?

A1: Define different equipment categories. Standard equipment reference categories for 'Internal Machines' and 'Customer Equipment' exist.

Q2: How do you distinguish between company and customer owned equipment? Equipment on land owned by the company and land leased by the company?

A2: Same as Q1. Explore combinations of equip. category and equipment types to achieve the design objective.

Q3: How do you define equipment/material loaned/leased to a customer?

A3: Read documentation on 'Structuring Technical Systems' in 'Plant Maintenance / Service management' modules. You need to define sales area (sales org/dist channel/division) for an equipment with equipment category being one for which the equipment reference category is 'Customer Equipment'.

Q4: How can we block service to a customer? It has to be done through the FL, since most of the Equipment belongs to the company and is loaned to the customer.

A4: Deactivate the FL. This allows no further creation of transaction data (service orders, etc.). However, the existing
orders can be processed and closed. The deactivation can be reversed at a later date.

Q5: Where is a Service Contract assigned to a piece of equipment?

A5: Service contract is assigned to a material. Material is assigned to the equipment in the equipment master. This functionality is not intended for managing equipment bought from vendors (where we are getting service rather than providing service).

Q6: Is purchasing information (Vendor, date of purchase, etc.) copied from MM to the equipment when it is being created?

A6: Not in the standard system. But it can be done with ABAP batch jobs.

Q7: When you maintain an assembly in a piece of equipment, is it possible to get maintenance history of the assembly? Do you have to create it as a piece of equipment?

A7: As maintenance orders are created for FL/equipment only, maintenance history can only be tracked at that level, not at assembly level. Assemblies are mere structuring devices to have spare parts linked to an equipment in a structured manner. However, in PM orders, you can mention the assembly along with the FL/Eq. Depending on your reporting needs, an
ABAPer could use the 'PM Assembly' field in PM orders.

Q8: What is the use of the field "Standing order"? What kind of order is it?

A8: Standing orders are used to carry out on-going maintenance jobs and settle them at month end rather than creating a fresh PM order every time. Using order hierarchies, you could attach sub-orders to the standing order and settle them to the standing order to provide you with more precise recording of maint costs at sub-order level as well as a budget monitoring at the standing order level.

Q9: Is it possible to accumulate maintenance history for an assembly (not part of an equipment) for which no equipment record exists?

A9: No. But, if the assembly is included in a FL BOM, then PM orders at the FL can be used to carry maint at assembly level (no equipment is required).
Bookmark and Share

Show Equipments Characteristics in a List

SAP PM Question:

How can I show equipments characteristics in a list?
I need to list one characteristics of all equipaments.
How can I do this? How is the simple way to do this?

Try this.

Go to IH08

In CLASS on the selection screen, select the class desired.

In Valuation, select the Characteristic value desired.

Execute

This will list all Equipments of a particular class having a particular Characteristic value.

or

You may also try this.

Go to Object List (CL6B)

Mention the Class and Class Type.

Tick on "Select Characteristics" and "With assigned values"

Execute.

This takes you to another screen wherein all characteristics of the class selected on the first screen are listed.

Select the Characteristic you want and "Copy"

This lists all Equipments of a particular Class with a particular characteristic.

Bookmark and Share

Component Allocation in Task List

Whenever I am attaching components in task list, item category is coming "L" i,e stockable by default & it is greyed out. I want to change it to non stockable.

In standard SAP in a task list the item cat is taken from the Material Master . That is the reason its greyed . To solve your issue you can create the BOM and have the non stock spare added as a BOM. In the task list you can select material from BOM.

Equipment BOM

Equipment Task List Component Tab

Bookmark and Share

Scenario of Rotating Equipment

How to configure the scenario of rotating equipment , i.e a Sub assembly which can be used on line 1, line 2 and can also be kept in store . History of the equipment should move along with it to each line.

Create the item as an equipment (IE01) this will fit into your scenario. Then you can install and dismantle the equipment as it moves around functional locations.

My Scenario is to move as well as store the equipment in stores as an material but with its history.
A Equipment X is used in line 1, and removed and provided in line 2 and after some repairs kept in stores .from where it can be issued against W/O for line 3/1/2
I feel equipment serial number management can help , but don't know how to configure and use it .

Yes, you are right the serialisation process will help track where your equipment is and has been. You will need assistance for the MM people to have the serialisation activated in the material master (a special material type may have to be created).
It is hard to explain how it works but I will give you an indication of the process I used at a previous business.

They had Material types "ROTO" & REPA" which could be both serialised for Rotable equipment. The serial number used in the material master was the equipment number of the Rotable equipment.

  1. Work Order created to replace equipment X on line 1.
  2. Equipment Y book out of the store which changed the status to "AVLB"(the serial number must be added before the equipment can be issued).
  3. Equipment X physically replaced with equipment Y.
  4. Equipment X position changed to "DISM" to show it is not currently in that position.
  5. Equipment Y is installed to the Functional Location and the position is "INST" (including the correct date of installation).
  6. Equipment X is repaired using the same Work Order (total costing reasons).
  7. Equipment X is repaired and is ready to be booked back into the store.
  8. The Work Order is Technically completed. (this must be done before dismantling the equipment otherwise the link to the Functional location costing is lost A serialised equipment carries no costing detail in the master data because it gets it from the Functional Location it is installed on). Once TECOed the data is locked.
  9. Equipment X is dismantled from the Functional Location.
  10. Equipment X is booked into the store which changes the status to "ESTO"
  11. M3 Activity report detailing the repairs is created to equipment X.
I know it looks messy but the main thing is the planners have to manage it otherwise equipment will get lost or end up in the wrong location. Start small and expand don't implement until you understand how it works.
Bookmark and Share

Attach a Drawing To Equipment Master Data

How to attach a drawing to equipment master data (IE01)?

By: Yasser

To attach a drawing to equipment, follow these steps in IE02 :-

Select this icon at bottom : Attach Drawing Icon

Attach Drawing - Change Equipment Organization

Then select Create - Create Attachment

Attach Drawing - Menu Path

Well done.
Bookmark and Share

Plant Maintenance Reservations

When creating a material reservation or requisition via the PM order, the G/L account is defaulted by the automatic account assignment in the material master.

The default G/L can be changed for a material requisition on the purchasing data screen.

How / where do you change the default G/L for a reservation?

A manual update is not allowed to a reservation that has been created via a PM order.

Other companies are having the same problem.

Currently, the only way to do it is doing a manual goods issue, without using the reservation.

In this way you can, of course, change the default G/L account.
Bookmark and Share

SAP Deletion and control of materials Reservations (PM order)

How can we delete PM materials Reservations in the MM module?

Without using the PM order, can we limit the no. of days to permit the GOODS ISSUE of the PM materials Reservations.

As I'm sure you've found, SAP does not allow manual change to reservations created automatically (e.g.. by PM).

This is to ensure that all the work done by the planners is not simply ignored by the people in the stores. If they want a reservation to be canceled they should call the PM planners who can change the PM order.

You can usually limit the validity period of the reservation in configuration to, for example, 5 days of planned GI date.

In this case, if 5 days have gone by past the planned issue date the deletion flag is automatically set on the reservation. This applies to reservations created by PM.

The transaction in IMG for this is OMBN.

Note that when the PM order is set TECO that the reservations will automatically be deleted.

This is the normal way to control this.
Bookmark and Share

SAP PM - SM notifications

In 3.1f Notifications, there is option to create special Notification or Activity or Request.

The screen fields of Notification and request are different.

Request displays all Catalogs codes, Sales Organization, DC, Division, Maintenance Plant etc. whereas Notification does not ask for these details.

So in general which is preferred to use and why?

Assuming you have 15 regions which will create Notification for customer calls. So will Request help in doing analysis of outstanding, completed Notifications region-wise etc.

Let me put it this way;

What will I not get if I use Notification?

What will I not get if I use Request as default?

This is not from 3.0f client, it is from 4.5A but the concept is still the same.

There are 3 generic Notification types.

1. Reporting defects
2. Reporting previously carried out work
3. Requesting work.

In 4.5A these are called Problem Notification, Activity Report and Service Request.

They are all Notification "Types".

You can create your own types and mix and match the initial screens and defaulted catalog types, but these three are the ones from the menu path you quoted. Also, the initial screens and defaulted catalogs for these 3 types are also configurable.
If you don't use Notifications (in general) then you miss out on catalog reporting, breakdown reporting, downtime and most of the functionality in the SMIS.

Recommendation, use Notifications.

The type to use? That depends on the industry and your company's needs.

In SAP the order is the planning tool and the collector and distributor of costs.

SAP has created the functionality for Notification Tasks for the planning of work, but there is no cost planning or allocations.

Problem Notifications are just what they suggest. Reporting problems.

Depending upon the size of the job depends whether an order is created to plan the work and/or capture the costs.

Activity Reports are normally created to save the administration of an Order. i.e. No significant costs, but you wish to record some technical history after the event. They can also be created from a Preventive type maintenance Order (created automatically from a Maintenance Plan) for technical reporting.

Service request. Typically a Service is required, not a defect or problem.

Typical examples are upgrade or improvements.

Recommendation: Use which is right for you, but you can report across all the Notification types.
Bookmark and Share

PM (Service Management) Geographical Work Centres

Subject: PM (Service Management) Geographical Work Centres
From: Mike Kennedy

Hi all,

My question relates to the creation of tasklists for a common planning plant (across the entire organization). These general tasklists also need to be common to the entire organization, however it would be desirable to have different Main Work Centers representing different geographical regions for the purposes of capacity analysis. Here lies the problem;

The task lists must have a work center assigned to each operation.

If a common work center is used in the task lists this defaults into the operation overview for the Scheduled orders when in fact it is desirable for this work center to be the same as the Main Work Center of the technical object that the work is being performed on ( which corresponds to it's geogrpahical location ).

We do not want to have to change the work centres on the order manually but alas, we require the work centre to represent the geographical region so that the impact of the order can be analysed in the capacity evaluation.

Any Suggestions?

Thanks in advance,

Mike K

-----Reply Message-----
Subject: Re: (Service Management) Geographical Work Centres
From: Barry Dickau

Mike,

Could you not group your tasklists by geographical locations which would mean duplicating the same tasklists but then each would have their own specific workcenters by location. Or create them as equipment or FL tasklists? I'm assuming your Plant structure is based on centralized planning, 1 Planning Plant to many Maint Plants?

-----Reply Message-----
Subject: Re: PM (Service Management) Geographical Work Centres
From: Siminski, Tom TM

Mike,

You may create General Task Lists to be used as reference and then create object related (functional location and/or equipment) task lists by copying the general list and changing work centre to "geographically correct" one.

Additional advantage may be that object specific task lists are easier to use when creating a work order. Extras -> Task list -> Object related, will give you list of all task lists for the object and only those.

Hope that is of some help.
Tom

Bookmark and Share

SM Revenue and Non Revenue Combination Orders

Subject: SM Revenue and Non Revenue Combination Orders

My customer has a requirement to have a combination work order.
Which means they would use a non-revenue work order (material and labor
to be charged to the contract) and also have material and labor to be billed
to the customer all on the same order.

Example:

An SM01 order is created and 6 hrs of labor and $200.00 worth of
material was used. Out of the $200.00 worth of material that was used
$100.00 is to be billed to the customer and the remaining 6hrs of labor and
$100.00 worth of material is to be charged to the contract.

Has anyone encountered this situation and have found some resolution
other than creating to work orders for 1 notification.

Any help would be appreciated.

-----Reply Message-----
Subject: RE: SM Revenue and Non Revenue Combination Orders

I don't think you need to create 2 work orders but one way is to create
SM01 (non-revenue) order & define two settlement rules, one of them
would be the sales order using which you want to bill the customer.
Other one could be your absorbing cost center. You have mentioned
charging to the contract, I guess that should also be possible since it is
a different order type only.

Therefore your solution would be to define two settlement rules with
appropriate percentage to the sales orders.

-----Reply Message-----
Subject: RE: SM Revenue and Non Revenue Combination Orders

I forgot to mention in my earlier mail, In order to define the settlement
rule to the sales order or in other words sales order to be the receiver of
the costs, you will have to have proper item category in the sales order
item.

Regards

-----Reply Message-----
Subject: RE: SM Revenue and Non Revenue Combination Orders

This will not work for SM since you can only assign one settlement rule
to the order type. What might work is to change the percentage to each
cost center. However, the problem with this is that they need actual costs.

SM does not work exactly like PP,PM and SD.

Thanks for your input.

-----Reply Message-----
Subject: RE: SM Revenue and Non Revenue Combination Orders

I am not sure about , what do you mean by "assign one settlement rule
to the order type" but my intention was to give percentages to different
receivers in the settlement rule.

If you want to apportion actual costs only & not percentages, another
option is to try condition types in the sales order & use SM02 i.e.
revenue bearing order type. bill the amount which you want to the customer &
charge the balance to whatever account you want through a separate
condition type. Treat something like warranty.

My answer was/is from SM perspective & it has got nothing to do with
PM/PP or SD.

Hope that helps

-----Reply Message-----
Subject: RE: SM Revenue and Non Revenue Combination Orders

Thanks for the information. What I did not want to do is create two
orders, SM01 and SM02.

Please accept my applogies for sounding like I thought you were not
coming from a Service Management Perspective. I have had four or five answer
that related to PP,PM or SD.

-----Reply Message-----
Subject: RE: SM Revenue and Non Revenue Combination Orders

My answer was not to create two orders but still only one order SM02
but you will have to try out what I suggested.

If that also fails (I don't know yet), there is another solution which is
definitely not going to fail & even SAP will give you the same answer &
probably the only solution if none of other works.

SAP has provided user exit in resource related billing & if the procedure
of billing is somewhat different from all the other ways, activate this user
exit & do the billing & bookings the way you want.

Pls try out all the alternatives & do not say that development will not
work!! Believe me user exits are meant to make the system user
friendly,get some automation & IT IS NOT SYSTEM MODIFICATION.

Regards

Bookmark and Share

Open and Close Posting FICO Periods

Define the posting company code variant in SM30 - V_T010O

Assign the company code variant in SM30 - V_001_R

Maintain the open and close posting period with OB52.

You can control period by : -

1. G/L number range.

2. Company code.
3. Company code and G/L range.
Bookmark and Share

SAP SD Output/Email Sending a billing document by e-mail

First, your SAP system must be configure by the basis people in order for you to send an external mail.

Whether it can send pdf or other file format will depends on the Mail Server you are using.

The basis people must also maintain the conversion parameters so that SAP knows how to convert the billing documents to be send as a pdf file or other desired format specified by your company.

Finally, you have define the IMG in Maintain Output Determination for Billing Documents (Output type MAIL)
Bookmark and Share

SAP Output/Email SAP SD Customizing Picking Output

From Release 4.5A, the system does no longer display the actions for SD picking in the implementation guide.

If you want to use the picking list according to the "old" procedure, you can maintain the list as follows:

o Carry out Transaction V/38 to maintain the output types.

o Carry out Transaction OVLT to assign the picking list types to the
shipping points.

o Carry out Transaction V/53 to assign the picking lists to own
forms and programs.
Bookmark and Share

SAP SD Output/Email Program for Sales Order by Customer, Date, Sales

Sales Order by Organisation, Customer - To create the Sales Order by More no of Date's

User's can easily take the Report from this by selecting Different kinds like Customer Specific [And/Or] Sales Organisation Specific [And/Or] duration of date but Here Date is Mandatory Fields user must have to give date as a selection criteria

In Second level this report will interact with user where they can select date to see the full Details of Sales Order
Selection
- Sales Organisation
- Date
- Customer this will be usefull when Selecting the Checkbox
Standard Variants
- Output
- Sales Order

Example
Date SalesOrderNo Material Amount Currency
10.01.2007 8530 732 1000 INR

*&---------------------------------------------------------------------*
*& Report ZCHE_SALES_ORDER
*&--------Done by V.Chellavelu on 11.01.2007
--------------------------*

REPORT zche_sales_order .

****************************Declarations********************************
TABLES: vbkd,vepvg.",vbak,vbap,vbpa,vakpa, vapma.

DATA: BEGIN OF sal OCCURS 0,
ch TYPE checkbox,
vbeln LIKE vbak-vbeln, " sales document
netwr LIKE vbak-netwr, "Net Value of the SalesOrder
matnr LIKE vbap-matnr, "material no.
waerk LIKE vbak-waerk, "curr.
dat LIKE vbak-erdat, "date.
END OF sal.
DATA: newsal LIKE sal OCCURS 0 WITH HEADER LINE.

DATA: amount LIKE vbak-netwr, date2(15),date3(8),date4(1),
date5(2),date6(2).

DATA: lin LIKE sy-curow VALUE 1,"Screens, vertical cursor position at
"PAI available in SYST struc.
checkbox TYPE c ,
dat LIKE vbak-erdat.

*******************Selection**Screen**Design****************************
SELECTION-SCREEN BEGIN OF BLOCK blk1 WITH FRAME TITLE text-001.
PARAMETERS: vkorg LIKE vepvg-vkorg,
vtweg LIKE vepvg-vtweg,
spart LIKE vepvg-spart.
SELECT-OPTIONS date FOR vbkd-bstdk DEFAULT sy-datum TO sy-datum
OBLIGATORY.
SELECTION-SCREEN END OF BLOCK blk1.

SELECTION-SCREEN BEGIN OF BLOCK blk2 WITH FRAME TITLE text-002.
SELECTION-SCREEN BEGIN OF LINE.
SELECTION-SCREEN POSITION 10.
PARAMETERS: chk1 AS CHECKBOX.
SELECTION-SCREEN POSITION 20.
PARAMETERS: kunnr1 LIKE vbpa-kunnr.
SELECTION-SCREEN END OF LINE.
SELECTION-SCREEN END OF BLOCK blk2.

********************First**Level**Operation*****************************
IF chk1 <> 'X'.
IF vkorg <> ''.
PERFORM organisation.
ELSE.
PERFORM organisation_else.
ENDIF.

ELSE.
IF vkorg <> ''.
PERFORM cus_orga.
ELSE.
PERFORM cus_orga_else.
ENDIF.
ENDIF.


* Displaying the contents which is selected from table by
* -selection conditions
SORT sal BY dat.

LOOP AT sal.
ON CHANGE OF sal-dat.
* FORMAT HOTSPOT ON.
IF sy-tabix = 1.
WRITE: sy-vline, sal-ch AS CHECKBOX,sal-dat .
CLEAR amount.
ELSE.
WRITE:sy-vline, amount,/ sy-vline, sal-ch AS CHECKBOX,sal-dat.
CLEAR amount.
ENDIF.
ENDON.
amount = amount + sal-netwr.
AT LAST.
WRITE:sy-vline, amount.
ULINE.
SUM.
* FORMAT HOTSPOT OFF.
FORMAT COLOR = 3.
WRITE:/ ' Total Amount:', sal-netwr UNDER amount.
ENDAT.
ENDLOOP.

**********************Interaction with report**************************

SET PF-STATUS 'BANU'. " To create Application ToolBar for Display
Button
* To verify Double click on BANU

AT USER-COMMAND. " This will execute after pressing Display Button
CASE sy-ucomm.
WHEN 'DISP'.
free newsal.
DO.
READ LINE lin FIELD VALUE sal-ch INTO checkbox.
IF sy-subrc NE 0. EXIT. ENDIF.
IF checkbox = 'X'.
PERFORM datecon.
PERFORM process.
ENDIF.
lin = lin + 1.
ENDDO.
PERFORM selection.
ENDCASE.

************************ SUB ROUTINE Area
******************************
*This Process SubRoutine will assign the values from current
* -InternalTable (sal) into other IT(newsal), by date which is
* - selected by CheckBox
FORM process.
LOOP AT sal WHERE dat = dat.
newsal-ch = 'X'.
newsal-vbeln = sal-vbeln.
newsal-netwr = sal-netwr.
newsal-matnr = sal-matnr.
newsal-waerk = sal-waerk.
newsal-dat = sal-dat.
APPEND newsal.
ENDLOOP.
ENDFORM. "process

*&---------This will display the values for selected dates from new --*
*---------------------internal Table (newsal)-------------------------*
*& Form SELECTION
*&--------------------------------------------------------------------*
*---------------------------------------------------------------------*
FORM selection.
ULINE.
FORMAT COLOR = 1.
WRITE:sy-vline,'Date',AT 14 sy-vline, 'Order NO', AT 27 sy-vline,
'Order Material', AT 48 sy-vline,'Order Value(AMT) Currency '.
FORMAT COLOR OFF.
ULINE.
LOOP AT newsal.
ON CHANGE OF newsal-dat.
IF sy-tabix <> 1.
WRITE:/ sy-vline, AT 14 sy-vline,AT 27 sy-vline,AT 48 sy-vline.
WRITE:/ sy-vline,newsal-dat,sy-vline,AT 27 sy-vline,AT 48 sy-vline.
ELSE.
WRITE: sy-vline,newsal-dat,sy-vline,AT 27 sy-vline,AT 48 sy-vline.
ENDIF.
ENDON.
WRITE:/ sy-vline, AT 14 sy-vline,newsal-vbeln,sy-vline,
newsal-matnr, sy-vline, newsal-netwr, newsal-waerk.

AT LAST.
SUM.
ULINE. FORMAT COLOR = 3.
WRITE:/ sy-vline, AT 15 'Total Amount for selected month:',
newsal-netwr UNDER newsal-netwr.
FORMAT COLOR OFF.
ULINE.
ENDAT.
ENDLOOP.
lin = 1.
FREE newsal.
ENDFORM. "SELECTION

* This Date convertion is must for pick the particular Date from the
* -displayed line, and here we are reversing the Date like
YYYY/MM/DD
* -because to Check or assign the date we need to give in reverse
order

*&--------------------------------------------------------------------*
*& Form DATECON
*&--------------------------------------------------------------------*
* text
*---------------------------------------------------------------------*
FORM datecon.
date2 = sy-lisel(17).
SHIFT date2 LEFT BY 4 PLACES.
WHILE date2 <> ''.
SHIFT date2 RIGHT.
date4 = date2+11.
IF date4 <> '.'.
CONCATENATE date4 date3 INTO date3.
ENDIF.
ENDWHILE.
date5 = date3(2).
date6 = date3+2.
date3 = date3+4.
CONCATENATE date3 date6 date5 INTO date3.
dat = date3.
* SORT dat BY dat.
* DELETE ADJACENT DUPLICATES FROM dat COMPARING dat.
ENDFORM. "DATECON


* Here we are doing different kinds of selections by the EndUser's
needs

*&---------When user selectiong an Sales Organisation-----------------*
*& Form ORGANISATION
*&--------------------------------------------------------------------*
* text
*---------------------------------------------------------------------*
FORM organisation.
SELECT f~vbeln p~matnr c~netwr c~waerk p~audat INTO (sal-vbeln,
sal-matnr, sal-netwr,sal-waerk, sal-dat) FROM ( vakpa AS f INNER JOIN
vbak AS c ON f~vbeln = c~vbeln ) INNER JOIN vapma AS p ON
f~vbeln = p~vbeln WHERE p~audat IN date AND p~vkorg = vkorg.
APPEND sal.
ENDSELECT.
ENDFORM. "ORGANISATION


*&---------Without Sales Organisation i.e All Organisation------------*
*& Form ORGANISATION_ELSE
*&--------------------------------------------------------------------*
* text
*---------------------------------------------------------------------*
FORM organisation_else.
SELECT f~vbeln p~matnr c~netwr c~waerk p~audat INTO (sal-vbeln,
sal-matnr, sal-netwr,sal-waerk, sal-dat) FROM ( vakpa AS f INNER JOIN
vbak AS c ON f~vbeln = c~vbeln ) INNER JOIN vapma AS p ON
f~vbeln = p~vbeln WHERE p~audat IN date.

APPEND sal.
ENDSELECT.
ENDFORM. "ORGANISATION_ELSE

*&------------When Selecting Customer by choosing CheckBox------------*
*& Form CUS_ORGA
*&--------------------------------------------------------------------*
* text
*---------------------------------------------------------------------*
FORM cus_orga.
SELECT f~vbeln p~matnr c~netwr c~waerk p~audat INTO (sal-vbeln,
sal-matnr, sal-netwr,sal-waerk, sal-dat) FROM ( vakpa AS f INNER JOIN
vbak AS c ON f~vbeln = c~vbeln ) INNER JOIN vapma AS p ON
f~vbeln = p~vbeln WHERE p~audat IN date AND p~vkorg = vkorg AND
p~kunnr = kunnr1.

APPEND sal.
ENDSELECT.
ENDFORM. "CUS_ORGA

*&------------Without Customer by without choosing CheckBox-----------*
*& Form CUS_ORGA_ELSE
*&--------------------------------------------------------------------*
* text
*---------------------------------------------------------------------*
FORM cus_orga_else.
SELECT f~vbeln p~matnr c~netwr c~waerk p~audat INTO (sal-vbeln,
sal-matnr, sal-netwr,sal-waerk, sal-dat) FROM ( vakpa AS f INNER JOIN
vbak AS c ON f~vbeln = c~vbeln ) INNER JOIN vapma AS p ON
f~vbeln = p~vbeln WHERE p~audat IN date AND p~kunnr = kunnr1.

APPEND sal.
ENDSELECT.
Bookmark and Share

Purchase Order and Sales Order Workflow

Purchase Order workflow ( Transaction : ME23N) determines the approval path for the buying organization . It first goes to the buyer, buyer's manager & thereafter based on the cost center & the associated amount, it goes for approval through the Cost Center organization .

i.e,

Buyer ( Requestor in the procurement deptt. of the buying organization)

|
|
v
Procurement Manager
|
|
v
Cost Center org. approval ( based on amount & Sign.Authority level)

Regarding , Sales Order( Transaction: VA01); it is created in the Sales Org of the company & basically governs the pricing structure of the order .The routing of an SO is

Sales Org. ( based on the cost center of the sold item)

|
|
v
Distribution Channel
|
|
v
Division
|
|
v
Reg. Sales office
|
|
v
Sales Group
|
|
v
Sales Person

Bookmark and Share

Workflow of Purchase Requisition Release Strategy

Configuration of Purchase Order Release Strategy

Following is the procedure for workflow enabling of “Purchase Requisition Release Strategy”:

1. The standard workflow template provided by SAP for PR Release is WS00000038. This information could be retrieved from the SAP help.

2. It is assumed that the release procedure has been setup in the system by the functional consultant, as shown below:
PR Workflow : Change View Release Strategies Classification

3. The customization of the PR Release Strategy could be verified at the following location:
SPRO à SAP Reference IMG à Material Management à Purchasing à Purchase Requisition à Release Procedure à Procedure with classification à Setup procedure with classification

4. Click on workflow in the above screen (screenshot shown below):
PR Workflow : Release Procedure Purchase Requisitions

5. Now define the recipients of the PR Release work item as per the release group (refer to screenshot below). For testing purposes, the recipient type is taken as “US”, instead this can also be taken as Position, Organization Unit and others.
PR Workflow : Change View Assignment of Role to Release Code

6. Now go back to the previous screen and click on “Release Codes”. Here enter the value “1” in the workflow column for the release groups the workflow has to be configured.
PR Workflow : Change View Release Codes Overview

7. Activate the event linkage of the workflow either in SWDD or PFTC.
PR Workflow : Workflow Builder Display wf_req_rel Active Saved

8. Mark all the tasks (unless background tasks) as “General Task” in the agent assignment and generate.
Bookmark and Share

Monday, July 6, 2009

Changing Vendor on Purchase Order

Is it possible to use different vendors for different items in the same PO?

Can the Vendor be changed after saving the PO?

One PO can not have different vendors. Its logical as one PO goes to one vendor with address.

You cannot change the Vendor once you have saved the Purchase Order. SAP treats the Purchase Order as a legal document. Therefore, once the Purchase Order is saved, it will not let you change the vendor.

You have to delete all the line items and then create another Purchase Order. However, if you are using Enjoy Purchase Order, you can "Hold" the Purchase Order rather than save it after you have create it, then you can change the vendor.

Of course, this means that you don't have any output yet. Therefore, you are not bounds by a legal document as you have not given it to a specific supplier yet.

Logically, you cannot change an important field after creating a document. It defeats the RDBMS principle, but you can change vendor while doing Invoice Verification.

No, you cannot change vendor in released PO, because vendor registration carries some vital configuration information which decides pricing procedure for the items of the PO, logically due to this reasons system doen't allow to change vendor name once PO is released.

Normal practise to come out for this routine problem in purchasing is solved by, simply delete this PO (By changing delivery as completed in PO) and make a new PO for these items.

Eventually, you have only two options:

1. You can do the entire transaction with that wrong vendor number and after MIRO you can transfer post the vendor liability to correct vendor through FI route. BUT THIS IS A WRONG PRACTICE.

2. You need to cancel the PO which has wrong vendor number and create it again with correct vendor code.

Bookmark and Share

One Time Vendors SAP MM

What is the process for using one time vendors?

One time vendors can only be used for specific vendor account groups. Their is a flag for each account group in configuation for this. If one does not exist you will have to create a new vendor account group.

To create a One Time Vendor use XK01 and select the OTV account group.

When creating say a PO use your OTV account the transaction will prompt you for name, address etc (unlike a normal vendor).

You experienced a problem with OTV's whereby users couldn't be bothered to create permanent vendors and just used the OTV account, so beware of that.

Bookmark and Share

Vendor Evaluation for Purchasing

Define the weighting keys in SM30 - V_T147J.

Weighting keys 01 and 02 are defined in the standard system. You combine the following
weighting shares for the standard main criteria:

Main criterion Key 01 Key 02
Price 1 5
Quality 1 5
Delivery 1 2
Gen. service/support 1 1
Ext. service provision 1 2


Define the criteria in SM30 - V_T147G - Double click on the line items

In this step, you define the criteria by which the system computes scores for vendors and
specify whether the scores for the subcriteria are computed manually, semi-automatically, or
automatically.

You can also store your own methods of computation for the scores for subcriteria in the
form of user exits. The enhancement MM06L001 is available for this purpose.


Define the scope of list in SM30 - V_T147M - Double click on the line items

Define Purchasing Organization data for vendor evaluations in transaction OMGL.


An example :-

How the system calculates the score for the automatic subcriteria
"On-Time Delivery Performance"?

The system uses the statistics-relevant delivery date in the purchase order
(Items -> Delivery Schedule) and the goods receipt date to calculate date variances.

You use the statistics-relevant delivery date, for example, if you know that the vendor
will not deliver the material as scheduled on September 15 but on September 30. Enter the
delivery date as September 30, but enter the statistics-relevant delivery date as
September 15.

In calculating the score for on-time delivery performance, the system will then not use
the actual delivery date, but the statistics-relevant delivery date. This has a negative
effect on the score for this goods receipt.
However, materials planning and control uses the realistic delivery date (September 30)
which the vendor will actually adhere to.

The system considers only goods receipts against purchase orders and scheduling agreements
into stores and the release of GR blocked stock into stores. In the standard system, these
are the movement types 101 and 105.


Minimum Delivery Percentage - OMGL in the On-time delivery section

If you do not want a vendor to receive a very good score if he delivered the goods on time,
but did not deliver the required quantity, you can maintain a minimum delivery percentage
in Customizing.

Assume you set the Min. del. perc. parameter to 60% and the vendor delivers the goods on
time, but only 55% of the ordered quantity. Although the goods receipt is punctual, it is
not included in the calculation of the vendor’s score for on-time delivery performance. So
that the non-scoring of the on-time delivery performance criterion in this case does not
bring an unfair advantage in comparison with a poor score, the vendor is awarded a low score
for quantity reliability. On-time delivery performance is thus always to be seen in
conjunction with quantity reliability.


Standardizing Delivery Date Variance - OMGL in the On-time delivery section

To rate delivery date variances in days, maintain the Std.del.time var. parameter.

If you assign a lower standard value, this means that relatively low date variances produce
high percentage variances. If you set a higher standard value, this results in a relatively
low percentage variance:

The Std.del.time var. parameter has the value 20. The goods receipt took place on Nov. 27;
the statistical delivery date was Nov. 15. There is thus a difference of 12 days.

The system calculates the percentage variance as follows:
12 / 20 x 100 = 60

If the Std.del.time var. parameter had the value 60, the variance would be 20%
(12 / 60 x 100 = 20).

If you do not maintain this parameter, the system calculates the delivery time variance via
the firm zone in the case of scheduling agreements, and via the order date and the
statistics-relevant delivery date in the case of purchase orders.
Bookmark and Share

Process of Subcontract in SAP MM

Sub-contract business process:
You want to buy material from the supplier (processed material/ assembled item) , but for some reason (quality of certain item / price ) you will give some component to vendor .
Vendor shall process the item / use the item provided & supply the final item.

SAP process:
1.Create the finished goods material code.
2.Maintain the BOM for the material.
3.Create PO with item category as "L" .
4.Issue material to vendor with movement type 541
5.Receive the material against the PO with movement type 101.
6.MIRO to account for vendor's invoice for the service charge& material used by him.

Can anybody tell me how a process has to be given to subcontracting?
Suppose, I have 3 operations 1)weaving 2)dyeing 3)cutting & packing
if no 2 process (i.e Dyeing) has to be given to subcontracting, what process should i follow ?

Vijay

The following process to be followed for subcontracting.
1. Item code(material master) to be created at the stage of before dyeing.
2. Item code(material master) to be created after Dyeing as subcontracted item.(F30)
3. Bill of material to becreated for the material(2) calling for material(1)
4. Inforecord and source list to be created for material(2) with the corresponding vendor
5. PO to be released for material (2)
6.Along with PO the material(1) to be issued to vendor
7.On receipt of material when GR is made the stock with vendor will get updated.

Bookmark and Share

Subcontracting - Key Points

Special Procurement Process.

Item category: L
Order type: NB

In info record vendor should be maintained as subcontractor.

Vendor (Subcontractor) receives the components used to manufacture a finished product directly from your company or through third party.

Your company should place a purchase order for the finished product. In this manually you can enter the required individual components or it can be determined via the explosion of BOM (if exists).

Stock check at vendor level: ME2O

Company stock check: MMBE

GR for individual components through movement type: 501 or 561 (if with out PO or without reference).

GI to subcontracting vendor: through movement type 541.

GR from sub contracting vendor: through movement type: 101
Movement type 543 is displayed to cancel the material cost account.

If the subcontracting order has to be generated through materials planning,the special procurement key has to be set in MRP 2 screen.


Editor Note:
- To create the Subcon Info Record : Tcode ME11 - Info Category - Click Subcontracting

- To create Material BOM : Tcode CS01

- With the Info and Material Setup, you can then create the Purchase Order in Tcode ME21N

Bookmark and Share

Procedure for Setting Partner Functions

The procedure for setting partner functions:

Step 1
Vendor Account Group
IMG->LOGISTICS GENERAL->BUSINESS PARTNER->VENDOR->CONTROL ->DEFINE
ACCOUNT GROUPS AND FIELD SELECTION

Step 2
Defining Partner Schemas
IMG->MATERIALS MANAGEMENT->PURCHASING->PARTNER -> DETERMINATION -
>PARNER SETTINGS IN VENDOR MASTER RECORD
->DEFINE PARTNER SCHEMAS

Step 3
Assign Partner Schema
IMG->MATERIAL MANAGEMENT->PURCHASING->PARTNER DETERMINATION->PARTNER
SETTINGS IN VENDOR MASTER RECORD->DEFINE PARTNER SCHEMA
„« THEN ASSIGN PARTNER SCHEMA

Step 4
Define Permissible Partner Role Per Account Group
IMG->MATERIAL MANAGEMENT->PURCHASING->PARTNER DETERMINATION -
>PARTNER ROLES ->DEFINE PERMISSION PARTNER ROLES

If you want a partner schema for your own document type then define your partner schema and assign to document type using the below mentioned path.

IMG->MATERIAL MANAGEMENT->PURCHASING->PARTNER ->DETERMINATION -
>PARTNER SETTINGS IN PURCHASING DOCUMENTS ->DEFINE PERMISSION
PARTNER SCHEMAS

And then
ASSIGN PARTNER SCHEMAS TO DOCUMENT TYPE

Once you have this configuration then you change your vendor in easy access menu (XK02-select partner function) define the partner roles.

Bookmark and Share

What Is Outline and Scheduling Agreement

Please give the difference between Purchase Order, Outline Agreement and Scheduling Agreement.

PO is normal where you issue the PO to a vendor and expect the delivery. The PO is termed completed when the vendor has delivered the PO quantity or when you have preclosed the PO when the vendor has delivered partial quantity and he has agreed not to send anymore with ref to the PO.

Outline Agreement can be of 2 types:- Contract and SA.

Contract is where you have a contract with the vendor,may be a for a predetermined quantity or predefined value. So everytime you need the matl, you need to make PO ref the contract asking for the delivery of the matl. In such instance when PO is ref with contract its called contract release orders or call off orders.

Scheduling agreement is a long term purchase agreement, where you will keep issuing the delivery schedules whenever there is a change in requirement or at predetermined time intervals. The delivery schedule can be on hour/daily/weekly/monthly basis. But it will contain different zones viz. firm/tradeoff/Forecast. Firm zone schedules are confirmed requirement and need to be taken by ordered party. Tradeoff zone requirement is to purchase the raw materails and ordering party is liable to pay raw material cost, in case of requirement cancellation. Forecast zone requirement is to help the vendor to plan his requirements.

SA is also an agreement with the vendor for the supply of matl, may be a quanity or value. The delivery dates will be maintained in ME38 ref the SA which are called delivery schedules.So you can maintain the delivery schedule and communicate the vendor on Forecase basis or JIT basis. And when you need some more matl then will only create SA deliveries using ME38. SA could be of 2 types:- without release documentation-system will transmit the delivery info to the vendor once you save the document.

With release documentation- after creating the delivery schedules you need to create SA release using ME84.

The main difference between contract and SA is volume of docs generated would be higher in contract since everytime you need to make a PO ref the contract and its time consuming, whereas SA can be integrated with MRP such that it automatically creates delivery schedules during MRP run provided if there is a requirement to the matl.

Bookmark and Share

What is Vendor Consignment?

Consignment is a functionality in MM-PUR wherein you purchase materials from the vendor on a consignment-basis. When the delivery comes, the materials, though will be stored in your warehouse, are still legally owned by the vendor until they are consumed, i.e. GI posting (this is the only time you will be liable to the vendor).

You just have to make sure, you set up the following to run this function perfectly:

1. Maintain account determination

KNO G/L acct: GR/IR Clearing
AKO G/L acct: Inventory account

2. Check field status compatibility at G/L account, posting keys in the IMG or run SE38/RM07CUFA to display fields compatibilities.

3. Set up output condition type KONS.

4. On the material master record, set special procurement indicator to 10 (consignment) at MRP2 view.

5. Create Info record for the consigned material and vendor-consignor. Be sure the info category is Consignment.

Bookmark and Share

Multiple Currency Quotation or Invoice From Vendor

The common Issue of Multiple Currency quotation or Invoice from a Vendor can be solved using Vendor Subrange.

This scnerios can be used specially in Purchase Order, where you can define/select the currencies for a Vendor.

Scnerio:
The Vendor currency is maitained (say) USD and you want to attach EURO, GBP to the existing vendor without creating same Vendor in Data Base

Solution:
Step:1 Use of SAP Standard Functionality of Vendor Sub-Range
Step:2 Activate the Sub-Range Field in PO and make it Mandatory

How to Use vendor Sub-Range

A. T-code XK02 – Select Vendor and then Select Purchasing Data

In Purchasing Data View go to MENU BAR -> Extras -> ADDITIONAL PURCHASING DATA
In the Screen Select check the box for
1. DATA RETENTION AT VSR LEVEL ALLOWED
2. DATA RETENTION AT PLANT LEVEL ALLOWED

B. SAVE

C. T-code XK02 – Select Vendor and then Select Purchasing Data

In the PURCHASING DATA VIEW, a Button appears in Sub-Menu Bar which Says “SUB-RANGE”

D. Click on it and put in the Currency Code and Currency Description
e.g.
USD US DOLLAR
GBP Great Britain Pound
INR India Rupee

E. SAVE

F. T-code XK02 – Select Vendor and then Select Purchasing Data

In the PURCHASING DATA VIEW, a Button appears in Sub-Menu Bar which Says “ALTERNATIVE DATA”

G. Click YES in the Pop-up

H. Select one Currency in SUB RANGE Field (say USD)

I. Select the check box for PURCHAING DATA and PARTNER FUNCTION

J. Click OK

K. In the Currency Field of PURCHASING DATA VIEW select USD
(This is to Match the VSR code to the currency Field)

L. SAVE

M. T-code XK02 – Select Vendor and then Select Purchasing Data
In the PURCHASING DATA VIEW, select “ALTERNATIVE DATA”

N. A new Screen is Displayed, PRESS F5, and repeat the steps H to L

Multiple Currencies are now Defined / attached to the Vendor.

STEP 2

Activate the Sub-Range Field in PO and make it Mandatory

A. GO TO IMG -> MATERIAL MANAGEMENT -> PURCHASING -> PURCHASE ORDER -> DEFINE
SCREEN LAYOUT AT DOCUMENT LEVEL

B. Make the VENDOR SUB RANGE field as REQUIRED in Quantity and Price Field Selection Group of Document Type

The Job is done

The Purchase Order now will ask you to select the Sub-range and the defined currency for a Vendor can be Used.

Bookmark and Share

User Exits In MM Area

The following SAP enhancements are available for the Purchasing area:


AMPL0001 - User subscreen for additional AMPL data (manufacturer part number)

LMELA002 - Adoption of batch number from shipping notification at time of posting of a goods receipt

LMELA010 - Incoming shipping notification: adoption of item data from IDoc

LMEQR001 - User exit for source determination

M06B0001 - Role determination for release of requisitions

M06B0001 - Changes to communication structure for release of requisitions

M06B0003 - Number range and document number

M06B0004 - Number range and document number

M06B0005 - Changes to communication structure for overall release of purchase requisitions

M06E0004 - Changes to communication structure for release of purchasing document

M06E0005 - Role determination for release of purchasing documents

ME590001 - Grouping of requisitions for PO split in transaction ME59

MEETA001 - Determination of schedule line type (backlog, immediate requirement, forecast)

MEFLD004 - Determination of earliest delivery date for checking at time of goods receipt (PO only)

MELAB001 - Generation of forecast delivery schedule: realization via creation profile

MEQUERY1 - Enhancement for document overview ME21N / ME51N

MEVME001 - Calculation of default GR quantity and over/underdelivery tolerances

MM06E001 - User exits for inbound EDI messages and outbound purchasing documents

MM06E003 - Number range and document number

MM06E004 - Control of import data screens in purchase orders

MM06E005 - Customer fields in purchasing documents

MEREQ001 - Customer's own data in purchase requisitions

MM06E007 - Change document for requisitions when converting into POs

MM06E008 - Monitoring of contract target value in case of release orders

MM06E009 - Relevant texts for "Texts exist" indicator

MM06E010 - Field selection for vendor address

MM06E011 - Activation of requisition block

MM06L001 - Exits for determination of ratings in vendor evaluation

MMAL0001 - ALE source list distribution: outbound processing

MMAL0002 - ALE source list distribution: inbound processing

MMAL0003 - ALE purchasing info record distribution: outbound processing

MMAL0004 - ALE purchasing info record distribution: inbound processing

MMDA0001 - Default values for delivery addresses

MMFAB001 - User exit for generation of releases

MRFLB001 - Control items during release creation

LWBON001 - Enhancement of LIS update through extension of the communication structure MCKONA (business volumes and rebate income)

LWBON003 - Change settlement data for end-of-period rebate settlement before creation of settlement documents

LWSUS001 - Customer-specific source determination in Retail

LMEXF001 - Conditions in purchasing documents without invoice receipt

LMEKO002 - Enhance communication structure KOMP for price determination
Bookmark and Share

IMG MM Transaction Codes Organizational Structures

These are the steps to configure the organization structures in material management:

Define plant (create plant) - Follow below path

SPRO IMG <> <> give your own plant name

Now your created your own plant

Define Storage Location - Follow below path

SPRO IMG <> <>

Now you created your storage location.

Define Purchase Organisation - Follow Below Path

SPRO IMG <>

Now you created your purchase organisation in your own.

Now we see How To Assign This To Your Own Company Code

Follow The Path To Assign

Assign Plant To Company Code

SPRO IMG
Bookmark and Share

SAP MM Transaction codes

List of SAP MM Transaction codes

All transaction are stored in table TSTC.
Transaction for MM module start with M.

IH09 - Display Material
MM01 - Create Material
MM02 - Change Material
MM03 - Display Material
MM50 - List Extendable Materials
MMBE - Stock Overview
MMI1 - Create Operating Supplies
MMN1 - Create Non-Stock Material
MMS1 - Create Service
MMU1 - Create Non-Valuated Material

ME51N - Create Purchase Requisition
ME52N - Change Purchase Requisition
ME53N - Display Purchase Requisition
ME5A - Purchase Requisitions: List Display
ME5J - Purchase Requisitions for Project
ME5K - Requisitions by Account Assignment
MELB - Purch. Transactions by Tracking No.

ME56 - Assign Source to Purch. Requisition
ME57 - Assign and Process Requisitions
ME58 - Ordering: Assigned Requisitions
ME59 - Automatic Generation of POs

ME54 - Release Purchase Requisition
ME55 - Collective Release of Purchase Reqs.
ME5F - Release Reminder: Purch. Requisition

MB21 - Create Reservation
MB22 - Change Reservation
MB23 - Display Reservation
MB24 - Reservations by Material
MB25 - Reservations by Account Assignment

MB1C - Other Goods Receipts
MB90 - Output Processing for Mat. Documents

MB21 - Create Reservation
MB22 - Change Reservation
MB23 - Display Reservation
MB24 - Reservations by Material
MB25 - Reservations by Account Assignment

MBRL - Return Delivery per Mat. Document

MB1C - Other Goods Receipts
MB90 - Output Processing for Mat. Documents

MB1B - Transfer Posting

MIBC - ABC Analysis for Cycle Counting

MI01 - Create Physical Inventory Document
MI02 - Change Physical Inventory Document
MI03 - Display Physical Inventory Document
MI31 - Batch Input: Create Phys. Inv. Doc.
MI32 - Batch Input: Block Material
MI33 - Batch Input: Freeze Book Inv.Balance
MICN - Btch Inpt:Ph.Inv.Docs.for Cycle Ctng
MIK1 - Batch Input: Ph.Inv.Doc.Vendor Cons.
MIQ1 - Batch Input: PhInvDoc. Project Stock

MI01 - Create Physical Inventory Document
MI02 - Change Physical Inventory Document
MI03 - Display Physical Inventory Document
MI31 - Batch Input: Create Phys. Inv. Doc.
MI32 - Batch Input: Block Material
MI33 - Batch Input: Freeze Book Inv.Balance
MICN - Btch Inpt:Ph.Inv.Docs.for Cycle Ctng
MIK1 - Batch Input: Ph.Inv.Doc.Vendor Cons.
MIQ1 - Batch Input: PhInvDoc. Project Stock

MI01 - Create Physical Inventory Document
MI02 - Change Physical Inventory Document
MI03 - Display Physical Inventory Document
MI31 - Batch Input: Create Phys. Inv. Doc.
MI32 - Batch Input: Block Material
MI33 - Batch Input: Freeze Book Inv.Balance
MICN - Btch Inpt:Ph.Inv.Docs.for Cycle Ctng
MIK1 - Batch Input: Ph.Inv.Doc.Vendor Cons.
MIQ1 - Batch Input: PhInvDoc. Project Stock

MI21 - Print physical inventory document

MI04 - Enter Inventory Count with Document
MI05 - Change Inventory Count
MI06 - Display Inventory Count
MI09 - Enter Inventory Count w/o Document
MI34 - Batch Input: Enter Count
MI35 - Batch Input: Post Zero Stock Balance
MI38 - Batch Input: Count and Differences
MI39 - Batch Input: Document and Count
MI40 - Batch Input: Doc., Count and Diff.

MI08 - Create List of Differences with Doc.
MI10 - Create List of Differences w/o Doc.
MI20 - Print List of Differences

MI11 - Physical Inventory Document Recount

MI07 - Process List of Differences
MI37 - Batch Input: Post Differences

CT01 - Create Characteristic
CT02 - Change Characteristic
CT03 - Display Characteristic

CL01 - Create Class
CL02 - Classes
CL03 - Display Class
CL04 - Delete Class
CL2B - Class Types
Bookmark and Share

SAP TCode for Personal Menu Volker Hofmann

ACCR MENUACCR Personal Menu Volker Hofmann
Bookmark and Share

SAP Transaction Code for: Waive Acceptance Order Temporarily

F887
Bookmark and Share

SAP Transaction Code for: New Monthly Returns Report Rule 57A

J2I9
Bookmark and Share

SAP MM Important Tcodes 2

ME91                 Purchasing Docs.: Urging/Reminding             
ME91A Urge Submission of Quotations
ME91E Sch. Agmt. Schedules: Urging/Remind.
ME91F Purchase Orders: Urging/Reminders
ME92 Monitor Order Acknowledgment
ME92F Monitor Order Acknowledgment
ME92K Monitor Order Acknowledgment
ME92L Monitor Order Acknowledgment
ME97 Archive Purchase Requisitions
ME98 Archive Purchasing Documents
ME99 Messages from Purchase Orders
ME9A Message Output: RFQs
ME9E Message Output: Sch. Agmt. Schedules
ME9F Message Output: Purchase Orders
ME9K Message Output: Contracts
ME9L Message Output: Sched. Agreements
MEAN Delivery Addresses
MEB0 Reversal of Settlement Runs
MEB1 Create Reb. Arrangs. (Subseq. Sett.)
MEB2 Change Reb. Arrangs. (Subseq. Sett.)
MEB3 Displ. Reb. Arrangs. (Subseq. Sett.)
MEB4 Settlement re Vendor Rebate Arrs.
MEB5 List of Vendor Rebate Arrangements
MEB6 Busn. Vol. Data, Vendor Rebate Arrs.
MEB7 Extend Vendor Rebate Arrangements
MEB8 Det. Statement, Vendor Rebate Arrs.
MEB9 Stat. Statement, Vendor Rebate Arrs.
MEBA Comp. Suppl. BV, Vendor Rebate Arr.
MEBB Check Open Docs., Vendor Reb. Arrs.
MEBC Check Customizing: Subsequent Sett.
MEBE Workflow Sett. re Vendor Reb. Arrs.
MEBF Updating of External Busn. Volumes
MEBG Chg. Curr. (Euro), Vend. Reb. Arrs.
MEBH Generate Work Items (Man. Extension)
MEBI Message, Subs.Settlem. - Settlem.Run
MEBJ Recompile Income, Vendor Reb. Arrs.
MEBK Message., Subs. Settlem.- Arrangment
MEBM List of settlement runs for arrngmts
MEBR Archive Rebate Arrangements
MEBS Stmnt. Sett. Docs., Vend. Reb. Arrs.
MEBT Test Data: External Business Volumes
MEBV Extend Rebate Arrangements (Dialog)
MECCP_ME2K For Requisition Account Assignment
MEDL Price Change: Contract
MEI1 Automatic Purchasing Document Change
MEI2 Automatic Document Change
MEI3 Recompilation of Document Index
MEI4 Compile Worklist for Document Index
MEI5 Delete Worklist for Document Index
MEI6 Delete purchasing document index
MEI7 Change sales prices in purch. orders
MEI8 Recomp. doc. index settlement req.
MEI9 Recomp. doc. index vendor bill. doc.
MEIA New Structure Doc.Ind. Cust. Sett.
MEIS Data Selection: Arrivals
MEK1 Create Conditions (Purchasing)
MEK2 Change Conditions (Purchasing)
MEK3 Display Conditions (Purchasing)
MEK31 Condition Maintenance: Change
MEK32 Condition Maintenance: Change
MEK33 Condition Maintenance: Change
MEK4 Create Conditions (Purchasing)
MEKA Conditions: General Overview
MEKB Conditions by Contract
MEKC Conditions by Info Record
MEKD Conditions for Material Group
MEKE Conditions for Vendor
MEKF Conditions for Material Type
MEKG Conditions for Condition Group
MEKH Market Price
MEKI Conditions for Incoterms
MEKJ Conditions for Invoicing Party
MEKK Conditions for Vendor Sub-Range
MEKL Price Change: Scheduling Agreements
MEKLE Currency Change: Sched. Agreements
MEKP Price Change: Info Records
MEKPE Currency Change: Info Records
MEKR Price Change: Contracts
MEKRE Currency Change: Contracts
MEKX Transport Condition Types Purchasing
MEKY Trnsp. Calc. Schema: Mkt. Pr. (Pur.)
MEKZ Trnsp. Calculation Schemas (Purch.)
MELB Purch. Transactions by Tracking No.
MEMASSIN Mass-Changing of Purch. Info Records
MEMASSPO Mass Change of Purchase Orders
MEMASSRQ Mass-Changing of Purch. Requisitions
MENU_MIGRATION Menu Migration into New Hierarchy
MEPA Order Price Simulation/Price Info
MEPB Price Info/Vendor Negotiations
MEPO Purchase Order
MEQ1 Maintain Quota Arrangement
MEQ3 Display Quota Arrangement
MEQ4 Changes to Quota Arrangement
MEQ6 Analyze Quota Arrangement
MEQ7 Reorganize Quota Arrangement
MEQ8 Monitor Quota Arrangements
MEQB Revise Quota Arrangement
MEQM Quota Arrangement for Material
MER4 Settlement re Customer Rebate Arrs.
MER5 List of Customer Rebate Arrangements
MER6 Busn. Vols., Cust. Reb. Arrangements
MER7 Extension of Cust. Reb. Arrangements
MER8 Det. Statement: Cust. Rebate Arrs.
MER9 Statement: Customer Reb. Arr. Stats.
MERA Comp. Suppl. BV, Cust. Rebate Arrs.
MERB Check re Open Docs. Cust. Reb. Arr.
MERE Workflow: Sett. Cust. Rebate Arrs.
MEREP_EX_REPLIC SAP Mobile: Execute Replicator
MEREP_GROUP SAP Mobile: Mobile Group
MEREP_LOG SAP Mobile: Activity Log
MEREP_MIG SAP Mobile: Migration
MEREP_MON SAP Mobile: Mobile Monitor
MEREP_PD SAP Mobile: Profile Dialog
MEREP_PURGE SAP Mobile: Purge Tool
MEREP_SBUILDER SAP Mobile: SyncBO Builder
MEREP_SCENGEN SAP Mobile: SyncBO Generator
MERF Updating of External Busn. Volumes
MERG Change Curr. (Euro) Cust. Reb. Arrs.
MERH Generate Work Items (Man. Extension)
MERJ Recomp. of Income, Cust. Reb. Arrs.
MERS Stmnt. Sett. Docs. Cust. Reb. Arrs.
MEU0 Assign User to User Group
MEU2 Perform Busn. Volume Comp.: Rebate
MEU3 Display Busn. Volume Comp.: Rebate
MEU4 Display Busn. Volume Comp.: Rebate
MEU5 Display Busn. Volume Comp.: Rebate
MEW0 Procurement Transaction
MEW1 Create Requirement Request
MEW10 Service Entry in Web
MEW2 Status Display: Requirement Requests
MEW3 Collective Release of Purchase Reqs.
MEW5 Collective Release of Purchase Order
MEW6 Assign Purchase Orders WEB
MEW7 Release of Service Entry Sheets
MEW8 Release of Service Entry Sheet
MEW9 mew9
MEWP Web based PO
MEWS Service Entry (Component)
ME_SWP_ALERT Display MRP Alerts (Web)
ME_SWP_CO Display Purchasing Pricing (Web)
ME_SWP_IV Display Settlement Status (Web)
ME_SWP_PDI Display Purchase Document Info (Web)
ME_SWP_PH Display Purchasing History (Web)
ME_SWP_SRI Display Schedule Releases (Web)
ME_WIZARD ME: Registration and Generation
Bookmark and Share

Saturday, July 4, 2009

IMG Change Logs and can ACCT Tables be Deleted

Problem One :
Does anyone knows where I can track who has made any changes in the configuration?

Problem Two :
Also, recently I was asked if those data can be deleted from ACCT* tables. Also, he commented there was a high increase in usage for these ACCT* tables that are related to MM. We have set up 2 phases in my company but this sudden increase in usage only happens in phase 2. Does anybody know what do these tables contain? Are there some settings that were made by the consultant in the configurations?

For :
1. - go to spro- then select any configuration tcode then menu-utilities-change log (provided the Change Log Tables is turn on by your Basis team. Usually this is turn off. To turn it on, you can refer to IMG - Basis Components - System Administration - Tables Changes Recording).

2. Please refer to OSS Note: 48009 - Tables ACCTHD, ACCTIT, ACCTCR: Questions and answers for the complete detail of ACCT* tables, when you post goods movement and invoice receipt, the FI/CO interface is documented in the forms of document in the tables ACCT*.

Bookmark and Share

Common Tables used by SAP MM

Below are few important Common Tables used in Materials Management Modules:

EINA Purchasing Info Record- General Data
EINE Purchasing Info Record- Purchasing Organization Data
MAKT Material Descriptions
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 materials
RKPF Document Header- Reservation
T023 Mat. groups
T024 Purchasing Groups
T156 Movement Type
T157H Help Texts for Movement Types
MOFF Lists what views have not been created
A501 Plant/Material
EBAN Purchase Requisition
EBKN Purchase Requisition Account Assignment
EKAB Release Documentation
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 section)
LFB1 Vendor Master (Company Code)
NRIV Number range intervals
RESB Reservation/dependent requirements
T161T Texts for Purchasing Document Types


SAP MM Tips by : Bahadur
Following are the list of Important MM tables. Please check if its useful.

Inventory Management:
|-------------------------+--------+-----------------------------------------|
| | Table | Description |
|-------------------------+--------+-----------------------------------------|
| Material | MSEG | Material document / transaction details |
| Document/Movements | MKPF | Material document header information |
|-------------------------+--------+-----------------------------------------|
| Material Stock Balances | MARD | Material stock |
| | MBEW | Material stock with valuation |
|-------------------------+--------+-----------------------------------------|
| Sales Order Stock | MSKA | Stock balance with associated sales |
| | | order data |
|-------------------------+--------+-----------------------------------------|
| Stock Transport | EKUB | Index for Stock Transport Orders for |
| | MDUB | Material |
| | | Reading View of Stock Transport Ord. for|
| | | Release Ord. |
|-------------------------+--------+-----------------------------------------|
| Special Stocks | MKOL | Consignment, material provided to |
| | | vendor, etc. |
|-------------------------+--------+-----------------------------------------|

Material Master Data:
|-------------------------+---------+--------------------------------------|
| |Table | Description |
|-------------------------+---------+--------------------------------------|
| Materials | MARA | General Data, material type, group, |
| | | configurable & batch ind. |
| | MAKT | Short Texts, descriptions |
| | MARM | Conversion Factors |
| | MVKE | Sales Org, distribution channel |
| | MLAN | Sales data, tax indicator, tax |
| | MARC | classification |
| | MBEW | Plant Planning Data |
| | MLGN | Valuation Data |
| | MLGT | Warehouse Management Inventory Data |
| | MVER | Warehouse Management Storage Type |
| | MAPR | Data |
| | MARD | Consumption Data |
| | MCHA | Pointer for Forecast Data |
| | MCHB | Storage location data with stock |
| | | balances |
| | | Batches |
| | | Batch Stocks |
|-------------------------+---------+--------------------------------------|
Bookmark and Share

SAP MM All The Tables In SAP MM Purchasing

Please find all tables in MM-PUR (Purchasing) :

EBAN - Purchase Requisition
EBKN - Purchase Requisition Account Assignment
EBUB - Index for Stock Transport Requisitions for Materi
EINA - Purchasing Info Record: General Data
EINE - Purchasing Info Record: Purchasing Organization D
EIPA - Order Price History: Info Record
EKAB - Release Documentation
EKAN - Vendor Address: Purchasing Document
EKBE - History per Purchasing Document
EKBEH - Removed PO History Records
EKBZ - History per Purchasing Document: Delivery Costs
EKBZH - History per Purchasing Document: Delivery Costs
EKEH - Scheduling Agreement Release Documentation
EKEK - Header Data for Scheduling Agreement Releases
EKES - Vendor Confirmations
EKET - Scheduling Agreement Schedule Lines
EKETH - Scheduling Agreement Schedules: History Tables
EKKI - Purchasing Condition Index
EKKN - Account Assignment in Purchasing Document
EKKO - Purchasing Document Header
EKPA - Partner Roles in Purchasing
EKPB - "Material Provided" Item in Purchasing Document
EKPO - Purchasing Document Item
EKPV - Shipping-Specific Data on Stock Tfr. for Purch. D
EKRS - ERS Procedure: Goods (Merchandise) Movements to b
EKUB - Index for Stock Transport Orders for Material
EORD - Purchasing Source List
EQUK - Quota File: Header
EQUP - Quota File: Item
T024 - Purchasing Groups
T024E - Purchasing Organizations
T024W - Valid Purchasing Organizations for Plant
T024Z - Purchasing Organizations
T027A - Shipping Instructions, Purchasing
T027B - Texts: Shipping Instructions
T027C - Codes for Compliance with Shipping Instructions
T027D - Compliance with Shipping Instructions: Texts
T069 - Certificate Categories
T069Q - Control Data for Source Determination and Checkin
T069T - Certificate Categories: Text Description
T160 - SAP Transaction Control, Purchasing
T160B - SAP Transaction Control, List Displays, Purchasin
T160C - SAP Transaction Control for List Displays in CALL
T160D - Function Authorizations: Purchase Order
T160E - Function Authorizations: Purchasing: Descriptions
T160I - Control of Intrastat Reports
T160J - Text Table for Intrastat Reports
T160L - Scope of Purchasing Lists
T160M - Message Control: Purchasing (System Messages)
T160O - Description of Scope of List
T160P - Entities Table Routines
T160Q - Scope of List: Buyer's Negotiation Sheet: Routine
T160R - Routines for Buyer's Negotiation Sheet
T160S - Selection Parameters for Purchasing Lists
T160T - Description of Selection Parameters
T160V - Default Values for Purchasing
T160W - Description for Default Values for Purchasing Ope
T160X - Scope of List: Buyer's Negotiation Sheet
T160Y - Scope of List: Buyer's Negotiation Sheet: Descrip
T161 - Purchasing Document Types
T161A - Linkage of Requisition Doc. Type to Purchasing Do
T161B - Default Business Transaction Type for Import
T161E - Release Codes
T161F - Release Point Assignment for Purchase Requisition
T161G - Release Prerequisite, Purchase Requisition
T161H - Fields for Release Procedure, Purchase Requisitio
T161I - Determination of Release Strategy
T161M - Fine-Tuned Control: Message Types
T161N - Message Determination Schemas: Assignment
T161P - Check of Document Type, Document Category, Item C
T161R - REORG Control, Purchasing
T161S - Release Indicator, Purchase Requisition
T161T - Texts for Purchasing Document Types
T161U - Texts for Release Indicator
T161V - Shipping-Specific Data for Stock Tfr. for Purch.
T161W - Order Types for Stock Transfer
T161Z - Additional Checks for Outline Agreements on Reorg
T162 - Field Selection, Purchasing Document
T162K - Field Selection, Account Assignment Fields, Purch
T162T - Description of Field Selection Reference Key
T162X - Description of Field Groups from T162/T162K
T162Y - Groups: Field Selection
T163 - Item Categories in Purchasing Document
T163A - Check Item Category/Account Assignment Category
T163B - Purchase Order History Categories
T163C - Texts for Purchase Order History Categories
T163D - Assignment Internal/External Confirmation Categor
T163E - Confirmation Categories
T163F - Confirmation Categories: Descriptions
T163G - Confirmation Control
T163I - Texts for Account Assignment Categories
T163K - Account Assignment Categories in Purchasing Docum
T163KS - Assignment of Tax Indicator to Account Assignment
T163L - Confirmation Control Keys
T163M - Confirmation Control Keys: Description
T163P - Release Creation Profile
T163S - Description for Release Creation Profile
T163X - "Zombie" T163X
T163Y - Texts for Item Categories
T165K - Copying Options: Header Texts
T165P - Copying Options: Item texts
T166A - Supplement Text in Purchasing Document Printouts
T166C - Print-Relevant Purchasing Document Changes
T166K - Header Texts in Purchasing Document Printouts
T166P - Item Texts in Purchasing Document Printouts
T166T - Change Texts in Purchasing Document Printouts
T166U - Headings in Purchasing Document Printout
T167 - Number Range Management for Purchasing Master Dat
T167T - Transaction Description
T168 - Screen Control, Purchasing
T168F - Function Codes, Purchasing
T168T - Screen Titles
T16FB - Release Indicators: Purchasing Document
T16FC - Release Codes
T16FD - Description of Release Codes
T16FE - Descriptions of Release Indicators: Purchasing Do
T16FG - Release Groups
T16FH - Descriptions of Release Groups
T16FK - Release Statuses
T16FS - Release Strategies

Bookmark and Share

SAP MM Tables - click to enlarge








Bookmark and Share

Interview Questions on SAP MM

1. What are the types of special stocks available?
Subcontracting, consignement, pipeline, project, sales order, RTP, stock transfer ,third party.

2. What are the types of inforecords?
Standard, consignment,subcontracting & pipeline.

3. What is meant by consignment stock?
The stock supplied by the vendor is in the companies premises with the company having no liability for the same. The liability for the company will only be affected when the goods are issued from the consignment stock for use.

4. What are the steps involved in consignment cycle?
Create consignment info record with proper tax code, create Po with item category K, maintain output condition record for KONS, process GR, no invoice verification done, but settlement is done through MRKO transaction.

5. Tell me about the subcontracting cycle.
The Po is created with item category L , the goods is transferred to subcontractor by 541 movemet. for this movement note no accounting docs take place. When GR is done automatically, 543 movemnt takes place which take care of the consumption of components from stock.

6. How are the byproducts taken care of in subcontracting?
You can add these by products in the BOM for the header matl.

7. What is meant by scales?
Can scales be used in standard purchase order? You can fix a price in the info record for a say qty from 1-100 price RS150 & if the order qty is 101- 500- the prices is 140 . Scales cannot be used directly in PO but can be pulled into the PO from various master data like i