SPP Creating a View for Leading Indicator

Procedure documentation Creating a View in SAP ERP Locate the document in its SAP Library structure

ishot-1471

The ERP system, in the client that contains equipment data, call up transaction SE11 to create a view. To do so, select the View radio button and enter a name for the view.

You create view ZEQ_BOM.

As the view type, choose Database view:

ishot-145

You need a developer key to go any further.

ishot-148

2. On the Table/Join conditions tab page, you link tables EQST and STPO, by entering the two tables in the Tables area and defining join conditions in the Join Conditions area.

You define the following join conditions:

Table

Field Name

=

Table

Field Name

STPO

STLNR

=

EQST

STLNR

STPO

MANDT

=

EQST

MANDT

3. You define the selection conditions on the Selection Criteria tab page.

You define the following selection criteria:

Table

Field Name

Operator

Comp. Value

STPO

STLTY

EQ

’E’

4. You enter the required view fields on the View Flds tab page.

Enter the following view fields:

View Field

DTyp

Length

Short Description

MANDT

CLNT

3

Client

EQUNR

CHAR

18

Equipment number

STLNR

CHAR

8

Bill of material

STLTY

CHAR

1

BOM type

STLKN

NUMC

8

BOM item node number

MEINS

UNIT

3

Component unit of measure

MENGE

QUAN

13

Component quantity

IDNRK

CHAR

18

BOM component

5. Sav


SPP and Plant Maintenance Installed Base

As we discuss in the post..

http://www.scmfocus.com/sapplanning/2008/10/02/spp-leading-indicator-forecast-profile-tab

…there is a tab in the Forecast Profile that allows you to select an Installed Base. An important question would be where that installed base comes from. There is a way to show the installed base. This is not coming from the material master, but rather from the Equipment BOM or E-BOM. This is part of the Plant Maintenance or Customer Service ECC submodule. Therefore, under standing the integration between PM and CS as well as SPP is critical.

This is the path to view..

ECC- Logistics – Plant Maintenance – Management of Technical Objects – Equipment – Installed Base – Display

ishot-140
You can choose by a variety of criteria. One is serial number.

ishot-144
However, you can also select by Installed Base number.

ishot-141
In addition to selecting by equipment and material, you can select by the External ID. The number we found was under quantity. We are curious if this is the installed base for this E-BOM.

ishot-1421
If we select the Material BOM level, we can see the location and material which corresponds to this Installed Base number.


SPP Creating an Equipment BOM for Leading Indicator

material-bom

Equipment BOM

Anything from a production utility, test equipment to production resources/tools and even buildings can be managed as equipment. Equipment has a hierarchy, hence the name of the BOM. If you want to find out more about BOMs see this post.

The equipment master contains the following:

  1. General data
  2. Plant maintenance (time dependent data such as the responsible work center)
  3. Serial number data
  4. Configuration data (such as data that describes the individual components of a standard product make up)
Information that is necessary to know before E-BOMs are created
  1. How are equipment number assigned
  2. Do you have to enter equipment descriptions according to particular company specific method.

Different from M-BOM

You can see how little information is in the M-BOM when compared to the E-BOM.

material-bom-2

This is very simple, just the materials that are part of each item. Now contrast this to what will be seen in the E-BOM.

E-BOM

If you wish to use equipment and equipment BOMs from SAP ERP for leading-indicator-based forecasting, you create the equipment and equipment BOM in the ERP system as described below. (This is the procedure for creating equipment BOMs, not for moving them over to SPP.)

You can also see the Warranty and Partner information on the Equipment BOM on the tab.

Procedure

1. In The ERP system starting with the SAP Easy Access screen choose Logistics – Plant Maintenance – Management of Technical Objects – Equipment – Create (General) and create equipment as follows: a. Specify a name for the equipment and an equipment category and choose Continue. Example Enter equipment LB2-EQUIPMENT-0001 and equipment category M – Machines. b. Specify an object type on the General tab page. Example Specify object type 1380 – Bulldozer. c. On the Location tab page, fill out the fields in the Location data area. Example Enter the following: MaintPlant: SPU1 Location: 0001 Plant section: 010 Work center: SPP_RVB1 ABC indic.: A d. On the Organization tab page, enter a responsible work center for maintenance measures. Example In the Main WorkCtr. field SPP_RVB1 / SPU1. e. Save your entries. 2. In the ERP system starting with the SAP Easy Accessscreen choose Logistics ® Plant Maintenance ® Management of Technical Objects ® Bill of Material ® Equipment BOM ® Create and create equipment BOMs as follows: a. Enter an equipment, a plant and a usage. Example Enter the following: Equipment: LB2-EQUIPMENT-0001 Plant: SPU1 BOM Usage: 4 – Plant Maintenance b. Confirm your entries. c. Enter the individual items of the BOM on the Material tab page. Enter item type L as the item category for all items. Example You create item 0010 as follows: ICt: L Component: HJS_HALB_0012 Quantity: 20 Un: EA You create item 0020 as follows: ICt: L Component: HJS_HALB_0010 Quantity: 1 Un: EA d. Save your entries.

To find out more about leading indicator forecasting in SPP see this link.

http://www.scmfocus.com/sapplanning/2008/11/11/spp-leading-indicator-decision/


SPP Leading Indicator Forecast Profile Tab

This post needs to read in conjunction with this post below.

http://www.scmfocus.com/sapplanning/2008/09/27/leading-indicator-forecasting-in-spp/

This is a connection field. It is connected to the leading indicator groups defined in customization. SPRO – Advanced Planning and Optimization – Supply Chain Planning – Service Parts Planning – Basic Settings

Forecast Profile – Leading Indicator Tab (TOP)


Leading Indicator Group

This is a connection field. It is connected to the leading indicator groups defined in customization. SPRO – Advanced Planning and Optimization – Supply Chain Planning – Service Parts Planning – Forecasting – Define Leading Indicators

This path is not correct and must be changed for 5.1.


As soon as you select anything but on the first second down, and then you navigate to Interactive Forecasting, you receive the following error.


This indicates that the TSDM for (key figure) TSID TSIDFINALHIST_LI must be configured in order to use leading indicator forecasting. The key figure is This is a TDL configuration issue. Another error we received is that the “TDL mapping is not correct.”

An open question we have is how this relates to the 9AIBASKF key figure.


Forecast Profile – Leading Indicator Tab (BOTTOM)

The bottom three fields of this tab deal with how the leading indicator value should be calculated. The first field

  1. Leading Indicator Values (Forecasted, Determined by Installed Base, Uploaded Manually)
  2. Coefficient Values
  3. Coefficient Constant

Leading Indicator Value

This controls how a leading indicator is calculated.

  1. Forecasted - reads the leading indicator history
  2. Determined from Installed Base – also creates a forecast – requires key figure initialization in BI workbench for APO.
  3. Uploaded / Manually EnteredTBD


Coefficient Values

Coefficient Values – (Forecasted, Constant Value, Uploaded / Manually Entered)

  1. Forecasted – means it works off the selected LI. Or SAP can accept a manual entry, or a constant value, which is the field below it.
  2. Constant Value - means an entry in the actual tab in the Coefficient Constant field (If “Constant Value” is not entered then, there is no necessity to enter a Coefficient Constant.)
  3. Uploaded / Manually Entered – means just that – however the true manual entry is entering the Coefficient Constant in this field. So this actually means uploaded. The implications are the need to use a BAPI.

If you select manual entry, the LI can be imported using the BAPI BAPISPP0007FCSTPRF_CHANGE


In this case LFI is not used as you are entering a value. You can enter a constant coefficient directly into the leading indicator tab. (what is to be determined in exactly what the coefficient means, that is how is a .7 different from a .)



The Leading Indicator Values, Coefficient Values and Coefficient Constant can be set per location product combination. However the Leading Indicator Group and Leading Indicator must be the same for all product locations in the BOM.

You can also enter values manually, however these values are not the history, they are a method for calculating the coefficient. However, for prototyping purposes it is easier to simply add in a coefficient.

Coefficient Constant

(Find specific definition of coefficient constant)

Open question is how are the values manually entered?

There are several coefficients in SPP. The Forecast Profile coefficient is just one of them. Another is under……


PSM – Planning Service Manager

What Is It?

Its is a scheduled and flexible way of running preconfigured services. Its basically a batch scheduler.

The Planning Service Manager (PSM) is where the selection must be defined at the product level. The schedule planning services can be used for the following:

  1. Demand history creation
  2. Forecasting
  3. Product interchangeability
  4. Inventory planning

PSM as a Concept

The Planning Services Manager is a completely different concept than in the rest of SCM. The planning services the user to both call and schedule functionality in many parts of SCM. This is structurally a break with the past in terms of how SCM has been managed. At least that is the idea. However, currently, most the services created are for SPP. Although the PSM is not conceptually linked to SPP, but it is the case that of all the modules the development team for SPP has taken the most advantage of it. All planning services are run as background jobs. However, they can be immediately scheduled.

PSM Configuration

SCM ships with a number of standard PSM services. However, they can be defined as well. For this one goes to the IMG and to the following:

Planning Service Manager
How the PSM Works

A planning service profile is necessary for the product to appear in the DRP Matrix.

Lets begin by going and create a selection (a combination of product and location). We can use transaction: /N/SAPAPO/PE_SEL



After we have selected a location product combination and named the selection we can goto the next step, we want to define a planning profile using this selection. We can use the transaction: /N/SAPAPO/48000009


We will click the “New Entries” button. Once on the next screen, we will fill out our header information, give it a description and then move to the next level down.


High Degree of Selection and Configuration Available.

Below the process planning service selections are available. The PSM is highly configurable, you can select from multiple services, as you can see below.

Each of these services can be added to a profile. For instance, the two prominent services in Leading Indicator (SPPLI_Service and SPPFCS_Service) are run through this planning service manager.


Here we are adding an SPPFCSService to a profile and saving it. We can now run this profile when we so choose.