Category Archives: Technical Stuff

Technical Reading and Writing

Availability Check in Delivery Settings

<b>Availability check</b>

1. Availability check is an integral part of the business process that determines if the required delivery quantity can be met on a required delivery date. For this purpose the system takes into account pre-delivery activities such as scheduling for picking or packing times and the time taken to produce or obtain the material. It also performs several background functions such as Backorder processing, rescheduling and ATP quantities.

2. Backorder processing: processing of a sales order that has not been fully confirmed or not confirmed at a certain delivery date.

3. Rescheduling: is a proposal of how – confirmed quantities already assigned to a sales order can be reassigned to other sales orders that have a higher priority.

4. Available to promise (ATP): is a process of checking the available quantities of a material. The ATP quantity consists of warehouse stock + planned receipts (incoming stock) – planned issues (outgoing stock). to examine stock on hand (CO09) proceed to logistics – sales & distribution – sales – environment – availability overview.

5. Replenishment lead time (RLT): is the time taken for the material to become available either internally (in house production) or externally (from a vendor). The most important things to consider during an external procurement are purchasing and MRP2 (procurement) views of MMR where the processing time for purchasing, planned delivery time and goods receipt processing time are taken into account. On the other hand internal procurement is based on in house production time (MRP 2 view) goods receipt processing time or alternatively RLT time, which is found on MRP 3 view.

6. RLT (Replenishment Lead Time) is the time taken for the material to become available. RLT is only used when doing an ATP check (Available To Promise). The value of RLT for a material is specified on material master record.

7. There are three types of availability checks –

o Check on basis of ATP quantities.

o Check against product allocation.

o Check against planning.

 

 

<b>Configuring Availability check through Checking Groups</b>

1. The checking group + checking rule determine how the availability check is to be performed.

2. The checking group determines whether and how the system checks the stock availability and generates requirements for material planning. The checking group defines what type of requirements will be passed on i.e. summarized requirements (daily/weekly) or individual requirements for each sales order.

3. The checking rule applies to how the availability check is to be carried out at the transaction level. Note that you must define checking rules for each individual application such as for production orders for example. In Sales and Distribution, the checking rule is specified internally within the system and cannot be changed.

4. The checking rule, in conjunction with the checking group, determines the scope of the availability check for every business operation; that is, which stocks, receipts and issues are to be included in the availability check and whether the check is to be carried out with or without the replenishment lead time.

5. Briefly explaining the above – checking group determines which type of requirement to be passed on to MRP whether it be individual or summarized and checking rule which is at the transaction level and can be configured independently for each application module, determines which stocks, receipts and issues to be taken into account. For performing an availability check checking group has to work in conjunction with checking rule.

6. Advantages of individual processing over summarized processing –

Backorder processing is possible.

You can access (MD04) order, line and schedule line individually which gives a greater control on available stock and requirements placed on stock.

The system automatically uses individual requirements in case of special stock items.

7. Required data for the Availability check to be carried out –

The Availability check must be switched on at the requirement class level.

The Availability check must be set at the schedule line level.

A requirements type must exist by which the requirements class can be found.

A plant must be defined in the sales order for each schedule line item (in other words plant must be defined for every material in MMR).

A checking group must be defined in the material master record in the MRP3 screen in the availability check field.

8. Configuring Availability check and defining Checking Groups –

Checking groups are introduced into the sales order based on the setting in the material master record.

SAP standard checking groups are 01 – summarized requirements and 02 – individual requirements or you can create your own by copying the standard ones.

Total sales and total deliveries columns are there to configure a checking rule to sum up requirements to post to MRP either individually or by day or week.

Block quantity required can be set if you want several users to be able to process the material simultaneously in different transactions without blocking each other.

The no check indicator is CHECKED when you DO NOT want the system to carry out ATP check.

9. Defining material block for other users – the block check box is an indicator that enables you to block material master records of a particular material during the availability check and restrict other users from accessing same master record and reserve the material. If the block is not set, two users can confirm the same material at the same time for two different orders, not knowing if the stock is available or not. If you select this field, the material is blocked during the availability check and other users cannot: a) Make changes in the material master record. b) Create purchase orders for the material. C) Create orders for the material.

10. Defining default values for checking groups – Checking groups are introduced into the sales order based on the setting in the material master record.

However if there is no entry present in the material master record for the checking group, a default value can be set here, depending on material type and plant.

This default value will be used by the system depending on the material type mentioned in MMR and plant in sales order.

If an entry exists, this default value is over written by MMR.

11. Controlling Availability Check – in this section, you tell the system what stock on hand and what inward and outward movements of stock it must take into account when performing the availability check in addition to whether or not to consider the replenishment lead time.

12. These settings are based on the checking group that is assigned to the material master record and the checking rule that is predefined and assigned to the sales and distribution transaction.

13. These settings carry out control both for sales order and delivery as well. This is due to the fact that you may want to include specific stock or incoming stock for the sales order, yet at the time of the delivery only include physical stock on hand waiting to be shipped.

14. It is possible to indicate to the system that you would like the availability check NOT TO CHECK the stock at the storage location level. This indicator is used to set the scope of the availability check.

15. It is used to switch off the check at storage location level. You create a reservation for a particular storage location. However, the scope of the availability check is set in such a way as to exclude the storage location. In this case, the system carries out the check at plant level only and does not take the storage location into account that is specified in the reservation.

16. Should you not want the system to automatically check RLT, you may indicate so here. RLT is the time taken for a material to become available. It is only used when doing an ATP check and is taken from MMR.

17. defining the elements in the availability check entirely depends on the business needs, but a few tips are given under –

When controlling the Availability check at the time of the sales order, a purchase requisition does not necessarily indicate by it is going to come into the plant.

A shipping notification on the other hand – a confirmed purchase order – is a good indicator of receiving stock on a specified date.

It is always recommended not to select the shipping notifications for the delivery requirements type as you may not actually receive the stock into plant or warehouse for which you are creating a delivery.

Transportation lead, pick/pack & Transit time

Transit time and Transportation lead time is taken from or maintained in Route

Loading time and pick/pack time comes from shipping point

 

You need to have clarity on backward scheduling and forward scheduling

 

For example you are creating a sales order today 15.02.2009 and the requested delivery date is 25.02.2009 from the customer side

 

Transit time is 2 Days

Transportaion planning time is 2 days

Loading time is 1 day

Pick/pack time is 1 day

 

Consider these settings

Now backward calculation System does a backward calculation first

 

25.02.2009 (requested delivery date) — 2 days (transit days) — 1 day (loading time) — 2 days (transportation planning time) = that is on 20.02.2009 there should be enough stocks in the unrestricted stocks and system checks stocks for this day or date ,that is 20.02.2009 ,whether the stock is available enough

 

This date 20.02.2009 becomes the material available date

 

Note Transportaion planning time and Pick/pack time will run parallely and the higest of these two is considered for delivery scheduling so in our case Transportaion planning time is 2 days that is the highest and hence it is taken for calculation and not pick /pack time

 

If the system finds enough stocks on 20.02.2009 (that means it performs a availability check for 20.02.2009 depending on OVZ9 settings) that is material available date then it confirms schedule lines for that order this is backward

 

Same example order is registered today 15.02.2009 and if the customer wants stocks on 17.02.2009

This means 17.02.2009-2 days (transit days)-1 day(loading time)-2 days (transportation planning time) = 12.02.2009

 

The order registered date is 15.02.2009and the material availablity date is past 12.02.2009 or material available date goes to past.

This is illogical

 

This means backward is failing here and now forward calculation takes place

 

Forward calculation

 

If you have enough stocks today 15.02.2009 + 2 days transportation planning time+ 1 day loading time+2 days transit time = 20.02.2009

 

This means that is on 20.02.2009 the stocks can be confirmed for this order as against a requested delivery date of 17.02.2009

 

In forward the system will give 2 schedule lines first that is requested delivery date that is 17.02.2009(in our case) with ZERO qty and the second date as 20.02.2009 with full qty

 

In backward you will find only one date in the schedule lines which is the same as requeted delivery date that is 25.02.2009 in our case

Hope i made things little bit clear to you

 

 

Transit and transporatation planning will come from route if route is maintained otherewise it is taken as 0 days

Loading and pick pack time will be maintained in shipping pt if not maintained also then it is taken as 0 days (in enterprise structure logistice execution and your shipping point details it is maintained)

Transportation lead, pick/pack & Transit time

Transit time and Transportation lead time is taken from or maintained in Route

Loading time and pick/pack time comes from shipping point

You need to have clarity on backward scheduling and forward scheduling

For example you are creating a sales order today 15.02.2009 and the requested delivery date is 25.02.2009 from the customer side

Transit time is 2 Days

Transportation planning time is 2 days

Loading time is 1 day

Pick/pack time is 1 day

 

Consider these settings

Now backward calculation System does a backward calculation first

 

25.02.2009 (requested delivery date) — 2 days (transit days) — 1 day (loading time) — 2 days (transportation planning time) = that is on 20.02.2009 there should be enough stocks in the unrestricted stocks and system checks stocks for this day or date ,that is 20.02.2009 ,whether the stock is available enough

 

This date 20.02.2009 becomes the material available date

 

Note Transportation planning time and Pick/pack time will run parallely and the highest of these two is considered for delivery scheduling so in our case Transportation planning time is 2 days that is the highest and hence it is taken for calculation and not pick /pack time

 

If the system finds enough stocks on 20.02.2009 (that means it performs a availability check for 20.02.2009 depending on OVZ9 settings) that is material available date then it confirms schedule lines for that order this is backward

 

Same example order is registered today 15.02.2009 and if the customer wants stocks on 17.02.2009

This means 17.02.2009-2 days (transit days)-1 day(loading time)-2 days (transportation planning time) = 12.02.2009

 

The order registered date is 15.02.2009and the material availablity date is past 12.02.2009 or material available date goes to past.

This is illogical

 

This means backward is failing here and now forward calculation takes place

 

Forward calculation

 

If you have enough stocks today 15.02.2009 + 2 days transportation planning time+ 1 day loading time+2 days transit time = 20.02.2009

 

This means that is on 20.02.2009 the stocks can be confirmed for this order as against a requested delivery date of 17.02.2009

 

In forward the system will give 2 schedule lines first that is requested delivery date that is 17.02.2009(in our case) with ZERO qty and the second date as 20.02.2009 with full qty

 

In backward you will find only one date in the schedule lines which is the same as requested delivery date that is 25.02.2009 in our case

Hope i made things little bit clear to you

 

 

Transit and transportation planning will come from route if route is maintained other wise it is taken as 0 days

Loading and pick pack time will be maintained in shipping point if not maintained also then it is taken as 0 days (in enterprise structure logistic execution and your shipping point details it is maintained)

SAP CMOD – Customer modifications

SAP CMOD – Customer modifications

How are they implemented ?

User Exits are implemented in such a way that unlike changes to SAP standard code, they will survive across upgrades and hot pack applications. They are also User Objects and can therefore be implemented without the need of requesting an SSCR from SAP.

Within the standard SAP programs at key points are calls to function modules starting with ‘EXIT_’. These function modules generally accept as input parameters structures containing for example the entire Order Header (VBAK) of the sales order just entered, or perhaps a table of the Order Items. These function calls are placed at points such as just before the Order is saved or just before it is printed and so on.

These function modules contain a single include statement. The name of this include is in the User domain and starts with Z. This enables it to be edited without the need for an SSCR and also prevents it being overwritten during upgrades.

Once this include has been created and activated, and the user exit is activated the User exit becomes functional.

Implementing a User Exit.

User Exits are implemented using the transaction code ‘CMOD’. Enter this in the command line and press the Enter key. This will then show the CMOD parameter screen:

User Exits are assigned a project name which begins with Z. Having entered the relevant name in the ‘Project’ field, click the Create (or Change) button as applicable.

When you are creating a new project, the projects attribute screen will be displayed. This allows you to enter a title for the project and allows access to the Enhancements (User Exits) that you want to assign to the project and the components that you wish to use within those enhancements.

This screen allows you to enter a description of the project. Once you have done this, click the save button. You will be asked as usual to assign a development class and create a transport.

Once the transport has been created you can then go on to assign the enhancements that you wish to use to the project.

Locating The Enhancements For A Project.

Unfortunately I have access to a 4.6C system only so therefore this description is based around that.

To find enhancements for a particular program locate the Development Class for the relevant program. Run the transaction and on the first input screen click on the Status button. This provides the program name. Another method of finding the program name is to use transaction SE93 which is the Create/Modify Transaction transaction. Enter the transaction code and click display.

In either case, cut the program name and then enter it into transaction SE38 ? the ABAP program editor. Select the ?Attributes? radio button and click display. Note the Development Class.

In 46C, go back to the CMOD main screen, enter the project name and select the ?Enhancement Assignment? radio button.

Click the change button. This will display the enhancement assignment screen. Position the cursor in the first field and press the <F4> key. This will display the Input Help personal list window, a standard window that you should be familiar with. Click the ?Information System? button and enter the development class located above into the development class field. Click the green tick.

This will display a list of enhancements for that particular development category with a short description of what they do.

Select relevant description which will be transferred back to the Enhancement Assignment screen.

For versions other than 46C, use transaction SE37 which is the Function Module editor, in the function module name field press the <F4> key and select further options. One of these will be the development class.

Clicking the enhancement button provides information on the enhancement.

The information displayed in this report includes whether the enhancement has been implemented, and is active. (Green things scattered throughout the report). Clicking the Exit name (In this case ?EXIT_SAPLV60A_002? will display the relevant function module:
To create the enhancement, double click the Include name. This then takes you into SE38 where you can edit the include to your hearts content.

Note, however, that when you try and create this include you will get a warning message displayed that the namespace you are trying to use belongs to SAP. Just click on the green tick and sail straight through.

User Exits In SAP FI

User Exits In SAP FI

.

User Exits in SAP FI are implemented again in a different manner to both standard user exits and user exits in SD. The user exits are available for Substitutions, Validations and Rules which are specified either in transaction OB28 (for rules), or OBBH (for substitutions).

There are 3 steps involved in setting up user exits in FI.

These are:

      •  
      • Creating the Module Pool and programming the user exit.
      • Specifying the Module Pool that will hold the user exits.
      • “Activating” the user exit.

 

Creating The Module Pool
    1. .

 

    1. SAP provide two programs that should be used to implement these user exits. These are RGGBS000 and RGGBR000 (for substitutions and rules respectively). The relevant program should be copied to a Z version of the program, ZRGGBR000 for example. The code in this module pool is like so:

 

Code:

PROGRAM RGGBR000 .
*---------------------------------------------------------------------*
*                                                                     *
*   Regeln: EXIT-Formpool for Uxxx-Exits                              *
*                                                                     *
*   This formpool is used by SAP for demonstration purposes only.     *
*                                                                     *
*   Note: If you define a new user exit, you have to enter your       *
*         user exit in the form routine GET_EXIT_TITLES.              *
*                                                                     *
*---------------------------------------------------------------------*
INCLUDE FGBBGD00.               "Data types


*!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!*
*    PLEASE INCLUDE THE FOLLOWING "TYPE-POOL"  AND "TABLES" COMMANDS  *
*        IF THE ACCOUNTING MODULE IS INSTALLED IN YOUR SYSTEM         *
*TYPE-POOLS: GB002. " TO BE INCLUDED IN
*TABLES: BKPF,      " ANY SYSTEM THAT
*        BSEG,      " HAS 'FI' INSTALLED
*        COBL,
*        GLU1.
*!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!*

*----------------------------------------------------------------------*
*       FORM GET_EXIT_TITLES                                           *
*----------------------------------------------------------------------*
*       returns name and title of all available standard-exits         *
*       every exit in this formpool has to be added to this form.      *
*       You have to specify a parameter type in order to enable the    *
*       code generation program to determine correctly how to          *
*       generate the user exit call, i.e. how many and what kind of    *
*       parameter(s) are used in the user exit.                        *
*       The following parameter types exist:                           *
*                                                                      *
*       TYPE                Description              Usage             *
*    ------------------------------------------------------------      *
*       C_EXIT_PARAM_NONE   Use no parameter         Subst. and Valid. *
*                           except B_RESULT                            *
*       C_EXIT_PARAM_CLASS  Use a type as parameter  Subst. and Valid  *
*----------------------------------------------------------------------*
*  -->  EXIT_TAB  table with exit-name and exit-titles                 *
*                 structure: NAME(5), PARAM(1), TITEL(60)
*----------------------------------------------------------------------*
FORM GET_EXIT_TITLES TABLES ETAB.

  DATA: BEGIN OF EXITS OCCURS 50,
          NAME(5)   TYPE C,
          PARAM     LIKE C_EXIT_PARAM_NONE,
          TITLE(60) TYPE C,
        END OF EXITS.
*!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
* PLEASE DELETE THE FIRST '*' FORM THE BEGINING OF THE FOLLOWING LINES *
*        IF THE ACCOUNTING MODULE IS INSTALLED IN YOUR SYSTEM:         *
   EXITS-NAME  = 'U101'.
   EXITS-PARAM = C_EXIT_PARAM_CLASS.
   EXITS-TITLE = TEXT-100.                 "Posting date check
   APPEND EXITS.

   EXITS-NAME  = 'U100'.
   EXITS-PARAM = C_EXIT_PARAM_NONE.        "Complete data used in exit.
   EXITS-TITLE = TEXT-101.                 "Posting date check
   APPEND EXITS.

* forms for SAP_EIS
   EXITS-NAME  = 'US001'.                  "single validation: only one
   EXITS-PARAM = C_EXIT_PARAM_NONE.        "data record used
   EXITS-TITLE = TEXT-102.                 "Example EIS
   APPEND EXITS.

   EXITS-NAME  = 'UM001'.                  "matrix validation:
   EXITS-PARAM = C_EXIT_PARAM_CLASS.       "complete data used in exit.
   EXITS-TITLE = TEXT-103.                 "Example EIS
   APPEND EXITS.

  REFRESH ETAB.
  LOOP AT EXITS.
    ETAB = EXITS.
    APPEND ETAB.
  ENDLOOP.

ENDFORM.

*eject
*----------------------------------------------------------------------*
*       FORM U100                                                      *
*----------------------------------------------------------------------*
*       Example of an exit for a boolean rule                          *
*       This exit can be used in FI for callup points 1,2 or 3.        *
*----------------------------------------------------------------------*
*  <--  B_RESULT    T = True  F = False                                *
*----------------------------------------------------------------------*
FORM U100  USING B_RESULT.
*!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
* PLEASE DELETE THE FIRST '*' FORM THE BEGINING OF THE FOLLOWING LINES *
*        IF THE ACCOUNTING MODULE IS INSTALLED IN YOUR SYSTEM:         *
*
*   IF SY-DATUM = BKPF-BUDAT.
*     B_RESULT  = B_TRUE.
*  ELSE.
*    B_RESULT  = B_FALSE.
*  ENDIF.

ENDFORM.

*eject
*----------------------------------------------------------------------*
*       FORM U101                                                      *
*----------------------------------------------------------------------*
*       Example of an exit using the complete data from one            *
*       multi-line rule.                                               *
*       This exit is intended for use from callup point 3, in FI.      *
*                                                                      *
*       If account 400000 is used, then account 399999 must be posted  *
*       to in another posting line.                                    *
*----------------------------------------------------------------------*
*  -->  BOOL_DATA   The complete posting data.                         *
*  <--  B_RESULT    T = True  F = False                                *
*----------------------------------------------------------------------*

*!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!
* PLEASE DELETE THE FIRST '*' FORM THE BEGINING OF THE FOLLOWING LINES *
*        IF THE ACCOUNTING MODULE IS INSTALLED IN YOUR SYSTEM:         *
*FORM u101 USING    bool_data TYPE gb002_015
*          CHANGING B_RESULT.
*  DATA: B_ACC_400000_USED LIKE D_BOOL VALUE 'F'.
*
*  B_RESULT = B_TRUE.
** Has account 400000 has been used?
*  LOOP AT BOOL_DATA-BSEG INTO BSEG
*                 WHERE HKONT  = '0000400000'.
*     B_ACC_400000_USED = B_TRUE.
*     EXIT.
*  ENDLOOP.
*
** Check that account 400000 has been used.
*  CHECK B_ACC_400000_USED = B_TRUE.
*
*  B_RESULT = B_FALSE.
*  LOOP AT BOOL_DATA-BSEG INTO BSEG
*                 WHERE HKONT  = '0000399999'.
*     B_RESULT = B_TRUE.
*     EXIT.
* ENDLOOP.
*
*ENDFORM.

*eject
*----------------------------------------------------------------------*
*       FORM US001
*----------------------------------------------------------------------*
*       Example of an exit for a boolean rule in SAP-EIS
*       for aspect 001 (single validation).
*       one data record is transfered in structure CF<asspect>
*----------------------------------------------------------------------
*       Attention: for any FORM one has to make an entry in the
*       form GET_EXIT_TITLES at the beginning of this include
*----------------------------------------------------------------------*
*  <--  B_RESULT    T = True  F = False                                *
*----------------------------------------------------------------------*
FORM US001 USING B_RESULT.

*TABLES CF001.                                 "table name aspect 001
*
*  IF ( CF001-SPART = '00000001' OR
*       CF001-GEBIE = '00000001' ) AND
*       CF001-ERLOS >= '1000000'.
*
**   further checks ...
*
*    B_RESULT  = B_TRUE.
*  ELSE.
*
**   further checks ...
*
*    B_RESULT  = B_FALSE.
*  ENDIF.

ENDFORM.                                   "US001

*eject
*----------------------------------------------------------------------*
*       FORM UM001
*----------------------------------------------------------------------*
*       Example of an exit for a boolean rule in SAP-EIS
*       for aspect 001 (matrix validation).
*       Data is transfered in BOOL_DATA:
*       BOOL_DATA-CF<aspect> is intern table of structure CF<asspect>
*----------------------------------------------------------------------
*       Attention: for any FORM one has to make an entry in the
*       form GET_EXIT_TITLES at the beginning of this include
*----------------------------------------------------------------------*
*  <--  B_RESULT    T = True  F = False                                *
*----------------------------------------------------------------------*
FORM UM001 USING BOOL_DATA    "TYPE GB002_<boolean class of aspect 001>
           CHANGING B_RESULT.

*DATA: LC_CF001 LIKE CF001.
*DATA: LC_COUNT TYPE I.

*  B_RESULT = B_TRUE.
*  CLEAR LC_COUNT.
*  process data records in BOOL_DATA
*  LOOP AT BOOL_DATA-CF001 INTO LC_CF001.
*    IF LC_CF001-SPART = '00000001'.
*      ADD 1 TO LC_COUNT.
*      IF LC_COUNT >= 2.
**       division '00000001' may only occur once !
*        B_RESULT = B_FALSE.
*        EXIT.
*      ENDIF.
*    ENDIF.
*
**   further checks ....
*
*  ENDLOOP.
ENDFORM.                                      "UM001

 

    1. The first thing to do is to insert code that notifies the calling programs of the availability of the user exits. This is achieved in the form GET_EXIT_TITLES.

 

    1. Decide on the name for your user exit, which should start with ‘U’ (for a user defined user exit) and then a 3 digit unique number. Above the line ‘REFRESH ETAB’, make the following entries:

 

Code:

   EXITS-NAME  = 'U100'.
   EXITS-PARAM = C_EXIT_PARAM_NONE.        "Complete data used in exit.
   EXITS-TITLE = TEXT-101.                 "Posting date check
   APPEND EXITS.

 

    1. The NAME field should contain the user exit name that you will be using.

 

    1. The field PARAM defines the parameter type.

 

    1. There are three values for this parameter, and are defined as constants:

C_EXIT_PARAM_NONE:

    1. This constant means that no parameters are defined for this user exit. In truth, there is one parameter defined and that is a boolean flag that is used to specify whether there is an error in the data or not. A value of false for this parameter means that the data is valid(!) and a value of true means that there is an error.

 

    1. This parameter is valid for rules, validations and substitutions.

C_EXIT_PARAM_FIELD:

    1. This constant is valid for substitutions only and means that one parameter can be defined for the user exit which is the field to be sustituted.

C_EXIT_PARAM_CLASS

    1. valid for Rules, Validations and Substitutions, this parameter signifies that all the data (BKPF and BSEG data) will be passed as one parameter to the user exit. You will be passed a table containing all the relevant information. Have a look at the routine U101 to see how to access this data.

 

    1. The last thing to include before the append is a text sting which is used to display the title of the user exit in an upcoming transaction.

Creating your user exit

    1. Once you’ve entered the above code into the right place in the form GET_EXIT_TITLES, it’s time to write the user exit code itself. Base the form delcaration on the examples above, remembering to return b_true or b_false dependant on the result of your user exit. If you wish to display any messages in the user exit, make them informational ones. Any other types can cause problems with the correcting of fields otherwise. Don’t forget to activate the changes.

 

Specifying the module pool that holds the user exits.

 

    1. Having written the user exit code, you must now activate that code. This is not the same as activating a program. What you are doing here is telling SAP that there is code available and this is where it lives.

 

    1. Start transaction GCX2. This will then display a screen similar to the one shown here:

    1. Change the screen into change mode by clicking this pencil as normal, and then enter the module pool name that you created in the steps above into the Ex. Prog Field.

 

    1. Save the changes and exit.

 

“Activating” the User Exit.

 

    1. The next thing to do is to incorporate your user exit code into a validation rule. Start transaction OB28.

    1. Select ‘New Entries’, and complete the input fields. (How to define the validation name is forth coming).

 

    1. Select the rule that you wish the user exit to be activated for (Note that these activations are company dependant).

    1. Your user exit will appear essentially as a boolean variable in the rule that you have selected (or created). In the relevant step enter the user exit name either as part of a condition statement or on it’s own. In the example below the user exit is called U102.

Types of Testing

Unit Testing : This is done in Development System, Unit testing should be taken care of by the developer at the developer side by executing the test scripts which are provided by functional peoples to trace the errors like if its not meeting the reqs or any bugs is there.

Integration Testing : This is done in QA System, Integration testing is being done by functional folks after deliverable by the developer to test whether its working up to the point and after integrating this module with any other module, what are the errors. generating.

Regression Testing : The term “regression testing” can be applied two ways. First, when a code problem has been fixed, a regression test runs tests to verify that the defect is in fact fixed; “Imagine finding an error, fixing it, and repeating the test that exposed the problem in the first place. This is a regression test” (Kaner in Testing Computer Software). Second, regression testing is the counterpart of integration testing: when new code is added to existing code, regression testing verifies that the existing code continues to work correctly, whereas integration testing verifies that the new code works as expected. regression testing can describes the process of testing new code to verify that this new code hasn’t broken any old code.

SAP SD Enhancements in sales order

User exit available

EXIT_SAPMV45A_910IS-OIL/TAS: Exit Change-Flag Output determination
EXIT_SAPMV45A_911TAS – Customer exit after creation of calloff
EXIT_SAPMV45A_920User Exit: TAS data Incompletion Log on Doc.-header-level
EXIT_SAPMV45A_930Userexit to allow overdelivery in Quantity schedule
EXIT_SAPMV45A_001User Exit for Determining the Billing Plan Type
EXIT_SAPMV45A_002Preassignment of Sold-to Party in Sales Documents
EXIT_SAPMV45A_003Rev.Rec.: Copy Requirements An Header Level
EXIT_SAPMV45A_004Rev.Rec.: Field Modification Sales
EXIT_SAPMV45A_005Copyy Packing Proposal Into Outobund Delivery Orders

Screen exit

43094.0: Subscreen: Header – Additional data A
43124.0: Subscreen: Header – Additional data B
8309Sales Document Header User Exit Header
8310Sales Document Header User Exit Header
8459Sales doc. Item User exit item (Additional data A)
8460Sales Document Item User Exit Item (Additional data B)

USEREXIT_AVAIL_CHECK_CREDIT
USEREXIT_CHECK_VBAK
USEREXIT_CHECK_VBAP
USEREXIT_CHECK_VBEP
USEREXIT_CHECK_VBKD
USEREXIT_CUST_MATERIAL_READ
USEREXIT_NEW_PRICING_VBAP
USEREXIT_NEW_PRICING_VBKD
USEREXIT_NUMBER_RANGE
USEREXIT_READ_DOCUMENT
USEREXIT_REFRESH_DOCUMENT
USEREXIT_SAVE_DOCUMENT
USEREXIT_SAVE_DOCUMENT_PREPARE

Tables related with sales order processing

VBAK Sales Document: Header Data
VBAP Sales Document: Item Data
VBEP Sales Document: Schedule Line Data
VBPA Sales Document: Partner
VBUK Sales Document: Header Status and Administrative Data
VBUP Sales Document: Header Status and Administrative Data
VBFA Sales Document Flow
VBKD Sales Document: Business Data
VBKFZ Cumulative Quantity Corrections
VBSN Change status relating to scheduling agreements

An Example Step by Step to Create Enhancement in User Exit SD

 

User exits in the program MV45AFZZ

The user exits which you can use for modifications in sales document processing are listed below.

  • USEREXIT_DELETE_DOCUMENT
This user exit can be used for deleting data which was stored in a separate table during sales document creation, for example, if the sales document is deleted.
For example, if an additional table is filled with the name of the person in charge (ERNAM) during order entry, this data can also be deleted after the sales order has been deleted.
The user exit is called up at the end of the FORM routine BELEG_LOESCHEN shortly before the routine BELEG_SICHERN.
  • USEREXIT_FIELD_MODIFICATION
This user exit can be used to modify the attributes of the screen fields.
To do this, the screen fields are allocated to so-called modification groups 1 – 4 and can be edited together during a modification in ABAP. If a field has no field name, it cannot be allocated to a group.
The usage of the field groups (modification group 1-4) is as follows:
  • Modification group 1: Automatic modification with transaction MFAW
  • Modification group 2: It contains ‘LOO’ for step loop fields
  • Modification group 3: For modifications which depend on check tables or on other fixed information
  • Modification group 4: is not used
The FORM routine is called up for every field of a screen. If you require changes to be made, you must make them in this user exit.
This FORM routine is called up by the module FELDAUSWAHL.
See the Screen Painter manual for further information on structuring the interface.
  • USEREXIT_MOVE_FIELD_TO_VBAK
Use this user exit to assign values to new fields at sales document header level. It is described in the section “Transfer of the customer master fields into the sales document”.
The user exit is called up at the end of the FORM routine VBAK_FUELLEN.
  • USEREXIT_MOVE_FIELD_TO_VBAP
Use this user exit to assign values to new fields at sales document item level. It is described in the section “Copy customer master fields into the sales document”.
The user exit is called up at the end of the FORM routine VBAP_FUELLEN.
  • USEREXIT_MOVE_FIELD_TO_VBEP
Use this user exit to assign values to new fields at the level of the sales document schedule lines.
The user exit is called up at the end of the FORM routine VBEP_FUELLEN.
  • USEREXIT_MOVE_FIELD_TO_VBKD
Use this user exit to assign values to new fields for business data of the sales document. It is described in the section “Copy customer master fields into sales document” .
The user exit is called up at the end of the FORM routine VBKD_FUELLEN.
  • USEREXIT_NUMBER_RANGE
Use this user exit to define the number ranges for internal document number assignment depending on the required fields. For example, if you want to define the number range depending on the sales organization (VKORG) or on the selling company (VKBUR), use this user exit.
The user exit is called up in the FORM routine BELEG_SICHERN.
  • USEREXIT_PRICING_PREPARE_TKOMK
Use this user exit if you want to include and assign a value to an additional header field in the communication structure KOMK taken as a basis for pricing.
  • USEREXIT_PRICING_PREPARE_TKOMP
Use this user exit if you want to include or assign a value to an additional item field in the communication structure KOMP taken as a basis for pricing.
  • USEREXIT_READ_DOCUMENT
You use this user exit if further additional tables are to be read when importing TA01 or TA02.
The user exit is called up at the end of the FORM routine BELEG_LESEN.
  • USEREXIT_SAVE_DOCUMENT
Use this user exit to fill user-specific statistics update tables.
The user exit is called up by the FORM routine BELEG-SICHERN before the COMMIT command.
Note
If a standard field is changed, the field r185d-dataloss is set to X. The system queries this indicator at the beginning of the safety routine. This is why this indicator must also be set during the maintenance of user-specific tables that are also to be saved.
  • USEREXIT_SAVE_DOCUMENT_PREPARE
Use this user exit to make certain changes or checks immediately before saving a document. It is the last possibility for changing or checking a document before posting.
The user exit is carried out at the beginning of the FORM routine BELEG_SICHERN.

User exits in the program MV45AFZA

  • USEREXIT_MOVE_FIELD_TO_KOMKD
Use this user exit to include or assign values to additional header fields in the communication structure KOMKD taken as a basis for the material determination. This is described in detail in the section “New fields for material determination” .
  • USEREXIT_MOVE_FIELD_TO_KOMPD
Use this user exit to include or assign values to additional item fields in the communication structure KOMPD taken as a basis for the material determination. This is described in detail in the section “New fields for material determination “.
  • USEREXIT_MOVE_FIELD_TO_KOMKG
Use this user exit to include or assign values to additional fields in the communication structure KOMKG taken as a basis for material determination and material listing. This is described in detail in the section “New fields for listing/exclusion”.
  • USEREXIT_MOVE_FIELD_TO_KOMPG
Use this user exit to include or assign values to additional fields in the communication structure KOMPG taken as a basis for material determination and material listung. This is described in detail in the section “New fields for listing/exclusion”.
  • USEREXIT_REFRESH_DOCUMENT
With this user exit, you can reset certain customer-specific fields as soon as processing of a sales document is finished and before the following document is edited.
For example, if the credit limit of the sold-to party is read during document processing, in each case it must be reset again before processing the next document so that the credit limit is not used for the sold-to party of the following document.
The user exit is executed when a document is saved if you leave the processing of a document with F3 or F15.
The user exit is called up at the end of the FORM routine BELEG_INITIALISIEREN.

User-Exits in program MV45AFZB

  • USEREXIT_CHECK_XVBAP_FOR_DELET
In this user exit, you can enter additional data for deletion of an item. If the criteria are met, the item is not deleted (unlike in the standard system).
  • USEREXIT_CHECK_XVBEP_FOR_DELET
In this user exit, you can enter additional data for deletion of a schedule line. If the criteria are met, the schedule line is not deleted (unlike in the standard system).
  • USEREXIT_CHECK_VBAK
This user exit can be used to carry out additional checks (e.g. for completion) in the document header. The system could, for example, check whether certain shipping conditions are allowed for a particular customer group.
  • USEREXIT_CHECK_VBAP
This user exit can be used to carry out additional checks (e.g. for completion) at item level.
  • USEREXIT_CHECK_VBKD
The user exit can be used to carry out additional checks (e.g. for completion) on the business data in the order.
  • USEREXIT_CHECK_VBEP
This user exit can be use to carry out additional checks (e.g. for completion) on the schedule line. During BOM explosion, for example, you may want certain fields to be copied from the main item to the sub-items (as for billing block in the standard system).
  • USEREXIT_CHECK_VBSN
You can use this user exit to carry out additional checks (e.g. for completion) on the serial number.
  • USEREXIT_CHECK_XVBSN_FOR_DELET In this user exit, you can enter additional criteria for deletion of the serial number. If the criteria are met, the serial number is not deleted (unlike in the standard system).
  • USEREXIT_FILL_VBAP_FROM_HVBAP
You can use this user exit to fill additional fields in the sub-item with data from the main item.
  • USEREXIT_MOVE_FIELD_TO_TVCOM_H
You can use this user exit to influence text determination for header texts. For example, you can include new fields for text determination or fill fields that already exist with a new value.
  • USEREXIT_MOVE_FIELD_TO_TVCOM_I
You can use this user exit to influence text determination for item texts. For example, you can include new fields for text determination or fill fields that already exist with a new value.
  • User-Exits for product allocation:
The following user exits all apply to structure COBL, in which the data for account determination is copied to item level.
  • USEREXIT_MOVE_FIELD_TO_COBL
Option to include new fields in structure COBL.
  • USEREXIT_COBL_RECEIVE_VBAK
Option to assign values from the document header to the new fields.
  • USEREXIT_COBL_RECEIVE_VBAP
Option to supply values from the item to the new fields.
  • USEREXIT_COBL_SEND_ITEM
A changed field can be copied from the structure into the item. You could use the user exit to display a certain field in the account assignment block (see also MV45AFZB).
  • USEREXIT_COBL_SEND_HEADER
A changed field can be copied from the structure to the header (see source text MV45AFZB)
  • USEREXIT_SOURCE_DETERMINATION
You can use this user exit to determine which plant will be used for the delivery. In the standard system, the delivering plant is copied from the customer master or the customer-material info record. If you want to use a different rule, then you must enter it in this user exit.
  • USEREXIT_MOVE_FIELD_TO_ME_REQ
With this user exit you can include additional fields for the following fields:
  • EBAN (purchase requisition)
  • EBKN (purchase requisition-account assignment)
  • USEREXIT_GET_FIELD_FROM_SDCOM
Option to include new fields for the variant configuration. Fields that are included in structure SDCOM can be processed and then returned to the order.
  • USEREXIT_MOVE_WORKAREA_TO_SDWA
You can use this user exit to format additional work areas for the variant configuration. You will find notes on the user exit in MV45AFZB.
  • User-Exits for first data transfer:
The following user exits can only be used for the first data transfer.
Note
Only use the user exits if the names/fields do NOT have the same name.
  • USEREXIT_MOVE_FIELD_TO_VBAKKOM
Option to include additional fields in structure VBAKKOM (communiction fields for maintaining the sales document header)
  • USEREXIT_MOVE_FIELD_TO_VBAPKOM
Option to include additional fields in structure VBAPKOM (communication fields for maintaining a sales item)
  • USEREXIT_MOVE_FIELD_TO_VBEPKOM
Option to include additional fields in structure VBEPKOM (communication fields for maintaining a sales document schedule line)
  • USEREXIT_MOVE_FIELD_TO_VBSN
You can use this user exit to include fields in structure VBSN (scheduling agreement-related change status).
  • USEREXIT_MOVE_FIELD_TO_KOMKH
You can use this user exit to include new fields for batch determination (document header).
  • USEREXIT_MOVE_FIELD_TO_KOMPH
You can use this user exit to include new fields for batch determination (document item).
  • USEREXIT_CUST_MATERIAL_READ
You can use this user exit to set another customer number in the customer material info record (e.g. with a customer hierarchy)
  • USEREXIT_NEW_PRICING_VBAP
Option for entry of preconditions for carrying out pricing again (e.g. changes made to a certain item field could be used as the precondition for pricing to be carried out again). Further information in MV45AFZB.
  • USEREXIT_NEW_PRICING_VBKD
Option for entry of preconditions for carrying out pricing again (e.g. changes to the customer group or price group could be set as the preconditions for the system to carry out pricing again). Further information in MV45AFZB.
  • User-Exits in Program MV45AFZD
  • USEREXIT_CONFIG_DATE_EXPLOSION
The BOM is exploded in the order with the entry date. You can use this user exit to determine which data should be used to explode the BOM (explosion with required delivery date, for example).

User exits in the program FV45EFZ1

  • USEREXIT_CHANGE_SALES_ORDER
In the standard SAP R/3 System, the quantity and confirmed date of the sales document schedule line is changed automatically if a purchase requisition is allocated, and it or the sales document is changed (for example, quantity, date).
If you want to change this configuration in the standard system, you can define certain requirements in order to protect your sales orders from being changed automatically. Use this user exit for this purpose. Decide at this point whether the schedule lines are to be changed.

User-Exits in Program RV45PFZA

  • USEREXIT_SET_STATUS_VBUK
In this user exit you can you can store a specification for the reserve fields in VBUK (header status). Reserve field UVK01 could, for example, be used for an additional order status (as for rejections status, etc.).
The following workareas are available for this user exit:
  • VBUK (header status)
  • FXVBUP (item status)
  • FXVBUV (Incompletion)
  • USEREXIT_SET_STATUS_VBUP
In this user exit you can you can store a specification for the reserve fields for VBUP (item status).
The following workareas are available for this user exit:
  • FXVBAP (Item data)
  • FXVBAPF (Dynamic part of order item flow)
  • FXVBUV (Incompletion)
  • USEREXIT_STATUS_VBUK_INVOICE
You can use this user exit to influence billing status at header level.

User exits in the screens

Additional header data is on screen SAPMV45A 0309, additional item data on screen SAPMV45A 0459. These screens contain the Include screens SAPMV45A 8309 or SAPMV45A 8459 as user exits.

Fields which are also to be included in the sales document for a specific installation should be included on the Include screens for maintaining. If an application-specific check module is needed for the fields, this can be included in the Include MV45AIZZ. The module is called up in the processing logic of the Include screens.

For field transports, you do not have to make changes or adjustments.

Example

A new field, VBAK-ZZKUN, should be included in table VBAK.

If the check is defined via the Dictionary (fixed values or check table) the field must be included with the fullscreen editor in the Include screen SAPMV45A 8309. In this case, no change has to be made to the processing logic.

User Exits in Program MV45AFZ4

  • USEREXIT_MOVE_FIELD_TO_KOMK
You can use this user exit to add or edit additional header fields in the communication structure – KOMK- for free goods determination. For more information, see the New Fields for Free Goods Determination IMG activity.
  • USEREXIT_MOVE_FIELD_TO_KOMP
You can use this user exit to add or edit additional item fields in the communication structure KOMP for free goods determination. For more information see the New Fields for Free Goods Determination IMG activity.

User Exits in the SAPFV45PF0E and SAPFV45PF0C Programs

  • EXIT_SAPFV45P_001
You can use this user exit to decide whether intercompany billing data is used in the profitability segment for cross-company code sales, or whether the data comes from external billing (external customer, sales data from the selling company code.

Five Strategies for Utilizing Next-Generation Sales & Operation Planning

Five Strategies for Utilizing Next-Generation Sales & Operation Planning

 
Retailers are being hard hit by an unprecedented confluence of economic conditions negatively impacting consumer spending. The economy is forcing companies to scrutinize their business strategies and better align their changing demand patterns with their capacities, resources, marketing programs, and budgets to ensure they are investing in those product lines and channels of sales that can deliver the highest profits during these volatile times.

Leading companies, recognizing the need to transition from disparate, decentralized business decisions, are rethinking the role that Sales & Operation Planning (S&OP) can play in managing their business. They are moving beyond simplistic and purely tactical approaches of using S&OP as a means of balancing supply and demand within their supply chain, and instead using it as a way of aligning product launches, marketing and sales programs, production plans, and resource allocations to ensure their investments are being made appropriately to achieve their strategic business objectives.

JDA offers the following five strategies – based on industry best practices – that can help companies develop, implement and maximize the benefits of next-generation approaches to S&OP.

1. Transition S&OP from Tactical to Strategic. The view of S&OP as a means to tactically balance supply and demand within the short-term horizon in the supply chain is restrictive. Leading companies view S&OP more strategically, shifting from a purely tactical implementation to utilizing S&OP as a critical element for more strategic integrated business planning. A strategic S&OP orientation aligns all supply chain plans with the corporate financial objectives and strategy, eliminating internal and external silos and taking a company to the next level of planning.

A solution that provides the information and workflows to support the proven S&OP best-practice processes will enable the synchronization of supply, demand, marketing programs, sales programs, financial goals and the achievement of a strategic business plan. Using S&OP to focus on the medium- to long-term horizon where decisions can have a strategic impact has delivered significant improvements to companies that have truly adopted S&OP as an integrated business process.

2. Cross-Functional People and Process Integration is Key. In an industry best-practices survey conducted by JDA in April 2008, 89 percent of respondents use S&OP or some other process for balancing demand with supply. For 38 percent of the respondents, the supply chain organization was taking the lead to deploy and facilitate the S&OP processes. A majority (60 percent) utilized their S&OP processes as a means of managing the supply side of their businesses.

Next-generation S&OP processes and solutions are bridging gaps between the demand and supply side of manufacturing operations, logistics, purchasing and upstream suppliers; while also integrating profitability analysis and securing senior leadership involvement to drive strategic business decisions. Synchronizing plans upstream and downstream provides the best possible decision making process for demand-side sales, marketing, financial and the supply-side operational plans – for a far faster return on investment.

3. Leverage the Power of an Integrated S&OP Solution. Companies have traditionally employed a range of software applications to support S&OP processes, often requiring time-consuming data extracts and manually transposing data into multiple spreadsheets and reports. However, independent, disconnected software applications can place a company at risk with outdated data lingering on desktops – fostering inconsistencies in terms of analysis assumptions.

It doesn’t take long for downstream users to start questioning data integrity, allowing the opportunity for problems to arise. An integrated solution with built-in, best-practice workflows provides significant benefits by reducing resources spent collecting and analyzing data, building spreadsheets, and transposing the data into presentable formats to support management review.

The right next-generation S&OP solution offers effective capabilities for providing forward-looking views of the business to support the appropriate product, demand, supply, financial and management reviews in a graphical orientation that quickly identifies business impacts, allowing for rapid, informed decision-making.

4. Incorporate Key Corporate Metrics and Long-View Forecasting and Planning. S&OP has the power to impact key corporate metrics, including improvements in customer service, inventory levels, as well as purchasing, production and expediting cost reductions. The process ideally provides continuous improvement in inventory turns, sales, cost metrics and manufacturing efficiencies – with relevant benchmarks linked directly to individuals involved in cross-functional processes and held accountable to a unified S&OP plan.

Industry best practices have evolved from short-term demand and production planning, to a more strategic time horizon that enables a more impactful effect on the attainment of corporate-wide goals and financial commitments. Companies that previously may have had only a cursory understanding of current fiscal year projections are now able to expand their horizon to two to three years or more. Leading S&OP solutions offer unconstrained and constrained views of demand and capacity needs for proactive long-term planning – facilitating optimal responses, as well as shaping future demand to meet business objectives.

5. Formalize Leadership Structure and Accountability for Optimal S&OP Benefits. In JDA’s survey, nearly 75 percent of respondents cited corporate culture issues as barriers to effective S&OP implementation. In particular, there was a lack of leadership and support from executive ranks, with only 16 percent of CEOs regularly involved in the S&OP process. Accountability was low across the board. Additionally, demand and manufacturing plans were most commonly cited as the sole outputs of S&OP.

S&OP offers strategic capabilities to ensure plans in all functions and geographies are aligned and support company strategies. Cross-functional integration optimizes transparency and facilitates better communication from upper management, with clear lines between leadership decisions and their impact on departments and results. The process should be formalized and spearheaded by senior management on a monthly basis, evaluating and making decisions based on accurate time-phased projections that ensure corporate objectives and strategies are attained.

Forward thinking companies are already implementing best-practice S&OP processes and technology to synchronize their supply, demand and execution to achieve the desired financial results. While an ambitious goal, the process can be approached incrementally as resources permit. S&OP integration is applicable to virtually all enterprises, regardless of their capabilities, size and industry. The right strategies can yield dramatic and brisk returns in terms of inventory reductions, improved fill rates to customers, reduced costs and enhanced revenues. Those companies that succeed in planning beyond near-term forecasts and short-term goals will find themselves well positioned to compete despite volatile market forces and future economic conditions.

 
Retrieved from https://risnews.com/five-strategies-utilizing-next-generation-sales-operation-planning

BOP short dump due to large values in Product Allocation Planning Book

There are instances when companies use Product Allocation for sales order confirmation. If the Values of the Key figures in the Allocation Planning Book in any cell on Aggregate level exceeds more than 11 digits then during the BOP it goes into Dump. In order to check if there is a negative value in the key figure or the Value is larger than 11 digits, a very useful report is provide by SAP.

Execute T-Code : SE38

Enter Report /SAPAPO/TS_LCM_QUERY and execute

There will be three options only one can be selected at a time

  1. Fixed Values (this is to find out if the cell has fixed value)
  2. Negative Values (This is to find out if any cell has a negative Value) If this option is executed then it will display all the CVC’s and the Bucket where the Value is Negative, User can then go into the Allocation Book and Adjust the Values in the Cell.
  3. Value Greater Than X (Any Value can be entered here to see the Values in the Cell, Usually any value greater than 11 digits can be checked and can be corrected.