Yearly Archives: 2007

Set Material Master Price of a material as sales price

The first method – Do not set the pricing condition VPRS as a statistical condition type. Simply remove PR00 and it will work fine if you always use VPRS as your pricing base inside the pricing procedure. VPRS will read both prices based on the price control in the material master. 

Price control S for standard price. 
Price control V for moving average price.   

However, if you are using one pricing procedure where for some items you price using VPRS and some others using PR00, then you should use requirement routines to enable the correct price condition type at the right time. 

The second method involves more work as you need to write a formula ( VOFM) to get that information. 

This is how it goes :- 

1. Set VPRS to be the first step in the pricing procedure and to be subtotal B (as standard). 

2. Set PR00 with alt. calc. type formula, which sets the value of PR00 to be equal to the subtotal B. 
    The routine (created with transaction VOFM) is: 

RV64A901
FORM FRM_KONDI_WERT_600. 
    XKWERT = KOMP-WAVWR.
ENDFORM.

The pricing procedure than looks like that: 

Step 1 VPRS statistical, subtotal B, reqt 4 
Step 2 PR00 Altcty 600 

Pricing Reports

You may use V/LD – Execute Pricing Report to check the prices entered into the Pricing Master.

Normally Pricing Report – “07 Cust.-specific Prices with Scale Display” will do.

Other Pricing Reports you may try are as follows:
|LR|Report title                                                         

|01|Comparison of Price Lists Without Scale Display                      
|02|Comparison of Price Groups Without Scale Display                     
|03|Incoterms with Scale Display                                         
|04|Incoterms Without Scale Display                                      
|05|Price List Types Without Scale Display                               
|06|Price List Types with Scale Display                                  
|07|Cust.-specific Prices with Scale Display                           
|08|Cust.-specific Prices W/out Scale Display               

|09|Material List/Material Pricing Group with Scale Display              
|10|List Mat./Mat.Pricing Groups Without Scale Display                   
|11|Price Groups With Scale Display                                      
|14|Taxes                                                                
|15|Material Price                                                       
|16|Individual Prices                                                    
|17|Discounts and Surcharges by Customer                                 
|18|Discounts and Surcharges by Material                                 
|19|Discounts and Surcharges by Price Group                              
|20|Discounts and Surcharges by Material Group                           
|21|Discounts and Surcharges by Customer/Material                        
|22|Discounts and Surcharges by Customer/Material Group                  
|23|Discounts and Surcharges by Price Group/Material                     
|24|Discounts and Surcharges by Price Group/Material Group               
|25|VAT/ATX1                                                             
|26|Canada/USA                                                           
|27|I.E.P.S Mexico                                                       
|28|Conditions by Customer                                               
|30|Conditions by Customer Hierarchy                                     
|31|Price List with Release Status                                       
|AC|                                                                     
|AD|                                                                     

Difference between Condition Type Ek01 ( Actual Cost) and EK02 Calculated Cost

These are the condition type that will display the results of the unit costing for certain  type of sales document. 

EK01 : 
If you use this condition type, the result of unit costing is issued to the first position on the conditions screen for the item. The value can be used as a basis for price determination. 

EK02: 
If you use this condition type, the result of unit costing is simply a statistical value which you can compare with the price. 

Please note the following points  :

1) The condition type must have condition category ‘Q’ (costing). 

2) The condition type must agree with the condition type defined for unit costing in the pricing procedure. 

Billing quantity

You can make the settings for the billing quantity in the copy control. You have the options of keeping the billing quantity equal to order quantity or delivery quantity or delivered quantity minus the quantity already invoiced. The billing quantity indicator specifies which quantity the system copies from the source document (a sales order, for example) into the target billing document (an invoice, for example).

Make sure that control of the amount to be billed is directly related to the item category billing relevance. (e.g. K – delivery related invoice for partial quantity, G – Order related billing of the delivery quantity etc.)

Suppressing Fields in Sales Order

The fields in a sales order can be made optional / mandatory by following this menu path – IMG – S&D-> Basic > Functions-> Log of incomplete Procedures =>  select the fields > from the tables and the system will check for them (OVA2/VUA2)

To make a filed entry enabled or grey (non-entry allowed):

User exits in the program MV45AFZZ-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.

Actually suppressing fielding sales orders userwise is quite easy. We are doing it in our company. For this we use userexit FORM USEREXIT_FIELD_MODIFICATION in MV45AFZZ.

Below is the sample code

IF SCREEN-NAME = ‘VBKD-ABSSC’.

AUTHORITY-CHECK OBJECT ‘ZMV45AFZZ’ ID ‘SCRFNAME’ FIELD SCREEN-NAME.

  IF sy-subrc = 0.
    SCREEN-INPUT = 1.
  else.
    SCREEN-INPUT = 0.
  ENDIF.
endif.

You place the authority check object in authorization profile in the role of the users, who should have access to the field (in this case it is VBKD-ABSSC), and there assign the corresponding fields that are to be accessed via this userexit.

Finding User Exits

Need to find user exits module-wise? Suppose we want to see the available sales module user exits. Go to transaction SE81. Click on SD, then click “edit” on the menu bar and choose select subtree. Click on “information system,” Open Environment node, customer exits, and enhancements. Press F8 to get all the user exits for that module. In brief: SE81->SD->Select subtree->Information System->Envir->Exit Techniques->Customers exits->enhancements->Execute(F8)

Product Hierarchy

Tcodes – OVSV, V/76  

Define Product Hierarchies

In this step, you define product hierarchies which you can use for statistical analysis or pricing, for example, or you can change their structure. The product hierarchy groups materials by combining different characteristics. Each characteristic is represented by a specific product hierarchy level.

Example

A product hierarchy can be structured as follows:

  •  
      Level Example Description
  •  
      1 00001 Electrical appliances
  •  
      2 00002 Household appliances
  •  
      3 00000003 Wet appliances

In this example, a dishwasher belongs to product hierarchy 000010000200000003.

Standard settings

In the standard system, the product hierarchy consists of up to 3 levels. The first and second levels have 5 digits and the third level has 8. The maximum number of digits is 18 and the maximum number of levels is 9.

You can define hierarchy nodes at the individual levels of the product hierarchy.

From the initial screen you can branch to the following steps:

  • Product hierarchy structure
    In the Data Dictionary, you can change the structure of the product hierarchy (e.g. the number of levels).
  • Data entry/display
    Here you define the display of the product hierarchy and the format of the accompanying text.
  • Product hierarchy
    Here you define your product hierarchies.
  • Field catalog for pricing
    Here you make fields of the product hierarchy structure available for use in pricing.
  • Field catalog for the Logistics Information System
    Here you make fields of the product hierarchy structure available for use in the Logistics Information System.

Actions concerning the product hierarchy structure

Structuring the product hierarchy

The product hierarchy can be structured via DDIC structure PRODHS. In the standard system, a product hierarchy can be created with up to three levels. The individual levels can contain the following number of digits:

Level number of allowed digits

1 5

2 5

3 8

This can be changed as of Release 3.0, where it is possible to extend the maximum number of levels to 9.

If you want to change the standard setting of PRODHS, e.g. you want to change the number of levels, proceed as follows:

    1. Create an appropriate domain in the Data Dictionary (type CHAR with the required length).
    2. Assign these domains to the standard data elements PRODH1, PRODH2, …, PRODH9.
    Please note that you should use these standard data elements.
    3. Change the structure PRODHS by creating or deleting fields with reference to the data elements.
    Choose ZZPRODHN as field name, where n is the position of the field in the structure PRODHS.

Example

You want to change the structure of the product hierarchy from 5/5/8 digits to 5/5/5/3. Proceed as follows:

Create the following domains:

ZPRODH3 with length 5, category CHAR,

ZPRODH4 with length 3, category CHAR,

Change structure PRODHS:

  •  
    • Strucutre PRODHS in the standard system:
  •  
      Structure Fields Data element Category Length
  •  
      PRODHS ->
  •  
      PRODH1 PRODH1 CHAR 5
  •  
      PRODH2 PRODH2 CHAR 5
  •  
      PRODH3 PRODH3 CHAR 8
  •  
    • Changes according to example:
  •  
      Structure Fields Data element Category Length
  •  
      PRODHS ->
  •  
      PRODH1 PRODH1 CHAR 5
  •  
      PRODH2 PRODH2 CHAR 5
  •  
      PRODH3 PRODH3 CHAR 5
  •  
      ZZPRODH4 PRODH4 CHAR 3

Note

The structure PRODHS and the data elements PRODH1, …, PRODH9 are only provided by SAP with Release 3.0 and can be changed by the customer from this point onwards.

Conversion routines for INPUT/OUTPUT

The product hierarchy can be assigned to a conversion routine. The name of the conversion routine is PRODH. The output template can be defined in Customizing (see below).

The separators used in the template are not allowed for maintaining the product hierarchy nodes.

Example:

If the template is _____/_____/__________

The symbol “/” cannot be used when maintaining the product hierarchy nodes. In this case, the following entry would not be allowed: 123456/79012345678

Text concatenation

The description of a product hierarchy can be determined via concatenation, if required.

Proceed as follows:

    1. Determine the node preceding the current node
    2. Concatenate the description of the subsequent node with the description from the preceding node.

The text concatenation is valid for the entire product hierarchy, the concatenated text has a length of 20. Text concatenation can be activated/deactivated in Customizing (see below).

Note

Make sure during text concatenation that the text of the product hierarchy does not come from table T179T. In this case function module RV_PRODUKTHIERARCHIE_TEXT_GET is available.

Allowed symbols for product hierarchy nodes

If you have stored a template for the conversion routine, the separators in the template are not allowed.

Actions concerning data entry/display

You can make two settings regarding the layout of the product hierarchy and the format of the product hierarchy text:

    1. Enter a template for displaying the product hierarchy. This template defines the length of the individual levels and the separators.
    Note that the character used to separate the levels in the template cannot be used in the product hierarchy nodes.
    2. The description of a product hierarchy node can be determined by concatenation if required.
    If you activate text concatenation, the text for one level is added to the description of the higher level and then output. The text of the first level appears at the beginning followed by the text of the second and third levels. Text concatenation applies to the complete product hierarchy. The concatenated text can have a maximum of 20 characters.
    Do not activate text concatenation if you only want to issue the description of the hierarchy levels created for these levels when the product hierarchy was defined.

Actions concerning the product hierarchy

The product hierarchy can be freely defined and include up to three levels. The SAP System checks the entry in the field product hierarchy during master data maintenance and copies it to the SD document. The separators used in the template cannot be used in the product hierarchy.

Note

Via a matchcode you can search specifically for material master records with a product hierarchy.

Analyze the product hierarchies in your organization and define their representation in the SAP System.

    1. Assign a characteristic value to the individual levels of your product hierarchy: a 5-character value to levels 1 and 2, and an 8-character value to level 3. The level number is determined automatically.
    A product hierarchy node encompasses a characteristic value of a maximum of 18 characters.
    2. Enter a description for the product hierarchy.

Actions concerning the field catalog for pricing

The product hierarchy can be used for functions in pricing. Then the fields of the product hierarchy structure must be entered into the field catalog for pricing.

Enter the fields of the product hierarchy in the field catalog.

Actions concerning the field catalog for Logistics Controlling

The product hierarchy can be used for statistical analyses in the Logistics Information System. The fields of the product hierarchy structure must then be entered in a field catalog for the Logistics Information System.

Enter the product hierarchy in a field catalog. You can refer to field catalog ‘VPHI’, which displays the standard settings.

*Courtsey – SAP help