Archives de l’auteur : Pierre

Frequent Issues on MD04

From https://archive.sap.com/documents/docs/DOC-49467

Frequent issues on MD04

The most used transaction in PP-MRP is the stock/requirements list.

Issues from many different application areas are reflected in transaction MD04, since this transactio reads data from many different tables.

On this document you will find the most frequent issues observed on transaction MD04.

1 – An MRP element is displayed on transaction MD04, however, it does not affect the available quantity, that means, it is not MRP relevant.

This issue can happen for many different planning elements, from sales orders to dependent requirements and there are many different causes for this issue.

On the following note you will find a detailed explanation for the possible causes for each different planning element:

1825187 – MD04/MD05: Incorrect quantity for an MRP element

2 – Database inconsistencies

A planning element that is already completed is still displayed on MD04 or a planning element is incorrectly displayed on MD04. It generally happens for sales orders or for subcontracting requirements but it can also happen for another planning elements, such as dependent requirements. The following WIKI describes each inconsistency and how to correct it:

http://wiki.scn.sap.com/wiki/display/ERPMan/Inconsistencies+for+planning+elements+and+display+problems+on+transaction+MD04

3 – Exception messages

There are usually several questions related to exception messages, for example, why an exception message appears on MD05 but not on MD04. The answer to this and another questions can be found on the following note:

550441      FAQ: Exception messages in material requirements planning

From all the exception messages, those related to the rescheduling check are the most frequent cause of issues. There is a lot of documentation about rescheduling and the following WIKIs and notes should be useful:

550302      FAQ: Rescheduling check

1745312   MRP creates redundant proposals though there are fixed future receipts which can cover the requirements.

http://wiki.scn.sap.com/wiki/display/ERPMan/What+is+rescheduling+and+how+does+it+work

http://wiki.scn.sap.com/wiki/display/ERPMan/The+causes+of+exception+message+30+in+transactions+MD04+and+MD05

4 – Why a planning element is displayed on MD04?

The following WIKI explains how to analyze MD04 in debug and find out where a planning element is comming from and why it is displayed on MD04:

http://wiki.scn.sap.com/wiki/display/ERPMan/How+to+analyze+the+MRP+elements+by+debugging

5 – Issues related to sales orders:

See the following document:

MD04: Problems with sales orders

 Tags: md04mrp_listsap_erp_logistics_materials_managementmaterial_planningppmrpsap_erp_manufacturing_production_planningerpproductionorderplannedproduction_schedulingplanned_ordersproduction_orderplanningstock_requirements_listenterprise_resource_planningmaterial_managementmd05

Planning area to Backup infocube

Source : https://blogs.sap.com/2015/01/02/data-extraction-from-planning-area-to-backup-info-cube/

Introduction

A planning area as we know is one of the most important areas in both Demand (DP) and Supply Network Planning (SNP). It basically defines the area where most of the planning activities take place grouping together both characteristics and key figures under a single domain.

In order to maintain the data consistency and to avoid loss of data, it is generally a good practice to take backup of the data in planning area to Info cube.

In this document, we will see how data can be backed up from Planning Area in step wise manner. For illustration purpose, have taken SNP Planning Area however process remains same for both DP and SNP – only major difference being in SNP, export DataSources can be generated for the SNP aggregates and not for MPOS like in Demand Planning. We would see the same further ahead in the document.

1. Create Planning Area

Planning area is created – TESTSNP. Here we have copied the standard planning area 9ASNP02 and created our own custom planning area. Configuration Steps for SNP Planning Area is discussed in detail in the following document –

SNP Configuration Steps for Planning Area and Planning Book/Data View

A.jpg

Creation of Backup Cube

Navigate to the Created Planning Area in the above step and from menu Select Extras – Data Extraction Tools as shown below –

A1.jpg

Same can be achieved by the below transaction also –

Transaction – /SAPAPO/SDP_EXTR

Here, we need to select Data backup and then Generate Infocube from Planning Area in next screen. After that we need to provide the name of Infocube and Infoarea as shown below –

/wp-content/uploads/2015/01/2_617554.jpg

Above step will create Infocube with name SNPBACKUP. After creation of backup Infocube, we can see the same in transaction RSA1 – here we can edit/create new dimensions (basically to partition the data) and remove unwanted characteristics/key-figures which we do not want to save in cube.

/wp-content/uploads/2015/01/3_617555.jpg

3. Create Data Source

In order to create the Data Source, we need to again the same path as described in step 2.

Transaction – /SAPAPO/SDP_EXTR

Here, we need to select Generate Data Source and then provide the name of the data Source. 9A is prefixed to the name given by us for Data Source by the system automatically.

In the next screen, we need to select the Aggregate on which we want to base the Data Source. In case of DP Planning Area, we can base the Data Source on the MPOS while this is not the case with SNP. This also means that only the characteristics or characteristics combination contained in these aggregates can be used in the InfoSource, transfer structure and transfer rules. Also For an SNP aggregate, only the key figures assigned to it can be extracted. So, it is an important decision to select the Aggregate on which one wants to base the Data Source as per business requirement. Here, we have selected the aggregate 9AMALA (9AMATNR, 9ATRNAME).

/wp-content/uploads/2015/01/4_617556.jpg

Also while creation of Data Source, there is this indicator as highlighted above which gives one the flexibility to avoid the system from transferring data records cube if all key figures in the data record have the value zero. This can drastically reduce the volume of information that the system transfers, and as a result improve performance.

Once the Data Source is generated, we can replicate the Data Source and then it will appear in transaction RSA1. Then we need to activate the Data Source as shown below

/wp-content/uploads/2015/01/41_617557.jpg

4. Create Transformation

In the above steps, we have created the backup cube for planning area to store the data and also Data Source for Planning Area. Now, we need to link the both and this is achieved by Transformation. It connects the objects in Source to corresponding objects in target.

Transaction – RSA1

Select the Infocube – Right click create transformation. In next screen, we need to provide source and target for this transformation to link. After validation of all linkages, we then activate the transformation as shown below –

/wp-content/uploads/2015/01/5_617558.jpg

In Transformation one also has option to define various Formulas, Rules etc. basically to define how the data needs to be mapped to the target field.

5. Create Data Transfer Package(DTP)

Transaction – RSA1

In Transformation, we defined the mapping between source and target objects; however extraction and update are defined using DTP.

Within DTP, there is option of defining the type of Extraction – Full/Delta, package size, filter criteria, Update Mode, Processing Mode and Error Handling Mechanism. All these options can be defined as per business requirement.

/wp-content/uploads/2015/01/6_617559.jpg

6. Create Infopackage

Transaction – RSA1

Infopackage would help in extracting the data from source and loads it to PSA. Data from PSA to the target is taken by DTP as described above.

/wp-content/uploads/2015/01/7_617560.jpg

Once Infopackage is created, we have defined all the objects which would be needed to extract the data from SNP Planning Area and store it into Backup cube. Final structure in RSA1 would look like below –

/wp-content/uploads/2015/01/8_617561.jpg

Summary –

In this document, we saw how data from planning area can be stored in Infocube via data Source, Transformation, DTP and Infopackage. Also, one can automate these steps via process chain and have it scheduled on Daily/Weekly basis as per requirement.

Créer un planning book

  • – RSA1 – Créer les key figures dans un catalogue d’info objects
  • RSA1 – Créer les charactéristiques et attributs
  • – /SAPAPO/MSDP_ADMIN – Créer la Planning object structure regroupant charactéristiques et attributs
  • /SAPAPO/MSDP_ADMIN – Créer (ou copier) la planning area en référence à la POS, et lui attribuer les Key figures
  • /SAPAPO/SDP94 – Créer un planning book/dataview affichant les key figures

Pull List and Stock Determination in Production

Pull List and Stock Determination in Production – MF60

https://blogs.sap.com/2015/02/25/pull-list-and-stock-determination-in-production/

1. Pull List

The pull list controls the in-house flow of material for supplying production with materials. The system assumes that the components required for production have already been produced in-house or procured externally and are now available to be transferred from their current storage location or bin to the production storage location.

The pull list checks the stock situation at the production storage location and calculates the quantities of missing parts. Replenishment elements can be created for these missing parts.

2. Master Data

Here we are going to review the key master data needed to use the Pull List.

2.1. Production Storage Location

Issue location for production order
Number of the issue location from which the material is issued during the production process. Backflush is posted to this issue location if required.

Use
In production, this is the access sequence in which the determination of the production storage location occurs:

  1. First, the issue storage location of the material to be issued (MARC-LGPRO) is transferred to the material master from the MRP data if it is
    filled.
  2. The system overwrites this value with the issue storage location from the bill of material (RC29P-LGORT, STPO-LGORT) if it is filled.
  3. If the operation to which the component is assigned in production order contains a work center with supply area, the storage location is transferred
    from this supply area (PVBE-LGORT). However, this transfer is only carried out if storage location data (MARD) is maintained for this storage location for the material.

Ref.: OSS Note: 137225 – Prod. order: Issuing storage location for component

Depending on if your component is used in more than one production storage location, you could asisgn this in the material master or in the BOM or through a Supply Area. Let’s supose in this example that we assign this at BOM item level.

This is maintained using t-code CS02. The production storage location is assigned at item level. Once you are in the BOM, click twice on each BOM item and go to Status/Lng Text tab:

PLIST 1.jpg

2.2. Stock determination

The pull list controls the in-house flow of material for supplying production with materials. The system assumes that the components required for production have already been produced in-house or procured externally and are now available to be transferred from their current storage location or bin to the production storage location.

This automatic transfer between the current storage location to the production storage location is performed based on the stock determination strategy.

Strategies for Stock Determination
You make all the settings you require for a stock determination strategy.

You determine a strategy at plant level using the stock determination group and the stock determination rule (The terms ‘rule’ and ‘group’ correspond to the checking group and the checking rule logic in the availability check).

The customizing point for the Strategies for Stock Determination is:

SPRO –> Materials Management –> Inventory Management and Physical Inventory –> Stock Determination –> Define Strategies for Stock Determination

PLIST 2.jpg

The stock determination group is assigned to the material in the material master record.

PLIST 3.jpg

3. Pull List Execution

Suppose your business is running the following process:

  • Create and Schedule process orders: the planner creates the process orders and the production scheduler schedules all the process orders.
  • Material staging: warehouse responsible will receive the list of process orders and will move components to the shop floor based on: which is the material that will be produced and which is the production line capacity.
  • Production execution: production responsible executes the production of the corresponding process order.
  • Goods receipt & confirmation: finished good production quantity is received and the confirmation is done. At this moment components are consumed from the production storage location using Backflush.

3.1. Create and Schedule process orders

Let’s create a process order and ensure the Production Storage Location is determined as expected.

PLIST 4.jpg

Take a look of the component list. All the components have an assigned production storage location:

PLIST 5.jpg

3.2. Material staging (MF60: Pull List)

The warehouse responsible will move components to the shop floor (production storage location). This can be done based on process order number or entering the material and quantity to be produced (this is commonly used when the order takes several days and we only want to supply components on a daily basis for the corresponding production of the day)

In this example suppose that the first process order is: 304472 and its duration is 5 days. The corresponding finished good is: 403403 (production version: 0001) and the production line maximum capacity is 5000CS/day.

Material Staging is executed thru transaction: MF60.

PLIST 6.jpg

PLIST 7.jpg

The pull list checks the stock situation at the production storage location and calculates the quantities of missing parts. Replenishment elements can be created for these missing parts (this is the section at the bottom of the screen).

Let’s see what is each column:

  • Issue stor. location = production storage location. This was entered in the bill of material.
  • NetReqQty = component quantity based on maximum production line capacity. In case the Pull list is executed agains an order, here you will see the quantity of the component determined in the order.
  • Available stock = this is the available stock in the issue storage location (production storage location). This can be the available remaining quantity of the before production day or shift or order.
  • Quantity staged = NetReqQty – Avail.Stock = This is the remaining quantity to be moved to the shop floor (production storage location).
  • RepLoc = is the warehouse storage location. It is the location found by the stock determination strategy.

Finally.. you press Save and the components will be moved from the main warehouse to the production storage location

PLIST 7.jpg

4. Pull List Global Settings

If necessary, limit your selection using the Global settings . Here, you have the choice between:

PLIST 1.jpg

  • General settings

For example, you may choose to display components with missing quantities only in the pull list or, using the indicator Take all requirements into account , you may define that the system is to include the requirements of all orders that influence the missing parts situation. If this field is not selected, the system only includes requirements for the specific order that you entered in the missing parts calculation. Here, you can also define whether your components are staged at storage location level via direct stock transfer, or using stock transfer reservation.

PLIST 8.jpg

  • Settings for dialog control
    Here, you define which procedures are to be carried out automatically in the pull list and which are to be carried out in dialog mode.

You also define whether the system is to save a complete log of all the messages and whether this log is to be displayed automatically.

PLIST 9.jpg

  • Printing settings

Here, you make the settings for the print list.

PLIST 91.jpg

References:

Pull List – Repetitive Manufacturing (PP-REM) – SAP Library

Accessing the Pull List – Repetitive Manufacturing (PP-REM) – SAP Library

OSS Note: 137225 – Prod. order: Issuing storage location for component