Tuesday, November 18, 2008

Define Profiles for the Projected Stock in SNC

SIMG/SCA/PRJSTKPRFLV

Define Profiles for the Projected Stock

Use

In this Customizing activity, you define the following:

  • Profiles for calculating the projected stock
    The projected stock is a key figure that indicates the available demand of a location product at the end of a day. It is calculated, application-specific, from actual stock on hand (+), demands (-), and receipts (+). Profiles for the projected stock are relevant for the following applications of SAP Supply Network Collaboration (SAP SNC):
    • Supply Network Inventory (SNI)
    • Replenishment Planning, for example in the SMI scenario or in the Responsive Replenishment scenario
    • Delivery Control Monitor (DCM)
      For the DCM, only the stock on hand is relevant.
  • Profiles for calculating the Demand key figure in SNI
    The Demand key figure specifies the demand of a location product at the end of a day. This profile is only relevant for SNI.

In the standard, the system uses preconfigured formulas to calculate the demand in SNI or the projected stock. Therefore, you only have to configure the Customizing activity in the following situations:

  • You do not want to use the internal SAP default formula, but instead, you want to use your own formula as the default formula.
    Example for the SMI Monitor, in which the supplier plans the product requirements in the customer location: here you can use different formulas for different supplier/customer location product combinations.

Method for Calculating Projected Stock

In the standard, SAP SNC calculates the projected stock of a day using the following formula:

      Projected stock of a day = projected stock of the previous day + receipts with delivery date on that day - demands with demand date on that day

    SAP SNC calculates the projected stock of today, that is, the initial projected stock, using the following formula:

        Projected stock of today = today's stock on hand + receipts with delivery date today - demands with demand date today.

      The demands and receipts that the formula considers depend on the application. For example, the formula in the SMI Monitor considers the planned receipts and the stock in transit from issued ASNs. The stock types that are entered in the stock on hand are also application- dependent.

      Consideration of Historical Values

      For every key figure (receipt or demand), you can determine individually whether the system also considers the aggregated key figure values from the past when calculating the initial projected stock. Example: In Responsive Replenishment, you want to consider historical values of the Demand key figure in replenishment planning for promotions, but not in replenishment planning for baseline demand.

      Default Formulas for Calculating Projected Stock

      In the standard, the system considers the following key figures and stock types to calculate the projected stock:

      • Projected stock for SNI
        The projected stock considers the stock on hand (+) and the following receipts and demands:
        • Stock on hand (+)
        • Planned receipts (+)
        • Firm receipts (+)
        • Demand (-)
        The demand includes the following demand types:
        • Firm receipts
        • Planned receipts
        • Forecast demand
        Stock on hand includes the following stock types:
        • Unrestricted stock
        The stock on hand is the same as the unrestricted stock.
      • Projected stock for (baseline) replenishment in SMI and Responsive Replenishment
        The projected stock considers the stock on hand (+) and the following receipts and demands:
        • Planned receipts (+)
        • In-transit quantity (+)
        • Demand (+)
        Stock on hand includes the following stock types:
        • Unrestricted-use stock
        • Unrestricted-use consignment stock
        • Stock in quality inspection
        • Consignment stock in quality inspection
        The DCM also considers these stock types for the stock on hand.
      • Projected stock for promotion replenishment in Responsive Replenishment
        The projected stock considers the stock on hand (+) and the following receipts and demands:
        • Planned receipts (+)
        • In-transit quantity (+)
        • Demand (+)
        Stock on hand includes the following stock types:
        • Unrestricted-use stock
        • Unrestricted-use promotion stock
        • Stock in quality inspection
        • Promotion stock in quality inspection

      Stock on Hand

      In the standard, the following stock types exist:

      • Unrestricted-use stock
      • Stock in quality inspection
      • Locked stock
      • The following consignment stock types:
        • Unrestricted-use consignment stock
        • Locked consignment stock
        • Consignment stock in quality inspection
        • The stock type that is considered by the internal default formulas for the stock on hand depends on the application. For more information, see the Default Formulas for Calculating Projected Stock section (see above). The stock on hand is calculated by the default implementation of the BAdI /SCA/ICH_STOCKONHAND. If required, you can use the BAdI to implement your own procedure for calculating the stock on hand.

      Calculation of the Demand Key Figure for SNI

      In the standard, the Demand key figure in SNI includes the following demands:

      • Firm receipts (for example, from sales orders or production orders)
      • Planned receipts (for example, from planned orders)
      • Forecast demand

      You can define your own formula. In addition, you specify the start and end of the horizon for which a formula is valid. In this way, you can define multiple subsequent horizons, in which the system uses a separate formula in each to calculate the demand. Example: in the short-term horizon, you only consider firm receipts, in the medium-term horizon you consider firm and planned receipts, and in the long-term horizon you only consider forecast demands.

      Definition of Own Formulas

      In your own profile, you can consider your own formula with any stock types and key figure. Beware of the following:

      • Terms of the key figure type can be entered in the formula with either a positive or a negative sign.
      • Terms of the stock type type must always have a positive sign.

      Activities

        1. If you want to work with your own formulas for the Demand key figure in SNI or for the projected stock, create a profile. To do so, define the following for each term that you want to include in the formula: an entry consisting of the profile name and the name of the term.
        2. Define the sign for the term and the term type.
        3. Select the profile as the standard profile for a specific application, if required. If you do not select any profile as the standard profile, SAP SNC uses the SAP standard formula (see above).

      If you want to use different formulas for different business partner/ /location product combinations, create a profile for each required formula. In the Customizing activity Assign Settings for Replenishment Planning and SNI, you then assign the profiles to the required characteristics combinations.

      Example

      3 comments:

      ChillyWilly said...

      We are bringing in demand from an external (non-SAP) system. Our problem is the past due demand. Each week we send more information so past due demand keeps building up and the 'initial' column in SMI gets bigger and bigger as time goes on, because we aren’t ‘clearing out’ the old demand.

      2 Questions:
      1) We do want to show some past demand, but summarize all the past demand to only show in the last period. Is there a way when generating the XML we can flag it so when it's processed inbound to SNC it clears all the old demand? Or clear ALL demand and just refresh with the values in the XML.

      2) Is there a way to control the SMI so it only shows one previous period of demand?

      Thanks,
      Will

      Hai Zeng said...

      Hi Will,

      It's all possible for your two requests. But it all requires custom coding. I don't think they are standard feature just yet.

      We had a SNC developer who helped us rolling past demand to the current week. Applying the same logic to manipulate the demand to show in different bucket should not be a big issue.

      Thank you,
      Hai

      ChillyWilly said...

      Hai,

      What approached did they take in the development?

      1) In the PI layer when the XML is read they also read into SNC to get any past due demand, then send signal to delete that information. Then process the XML with the new demand stream?

      2)Our legacy (non-sap) system keeps track of past due demand they have sent, so when they send a new signal they also send a 'zero' over for the timeframe in the past

      Any guidance would be great

      Thanks,
      Will