Saturday 23 July 2016

Structure of Group Key in priceing routine

A structure of group key formula can be used to influence the basis the system uses when reading the scale of a group condition. Group conditions are used to cumulate quantities from more than one sales document line item to read pricing scales. For example, when pricing a particular sales document line item, the user would like the system to not just consider the quantity of the current line item, but the sum of the quantities of all line items that share the same material pricing group as the current line item. The formula is assigned to a group condition type in customizing. When looking at the code for the standard delivered structure of group key formulas or when writing your own, XVAKEY is the field name that the structure of the group key should be assigned to. Following is a description of the structure of group key formulas delivered in the standard system.

STRUCTURE OF GROUP KEY FORMULA 1: OVERALL DOCUMENT

Formula '1' adds up the quantities / values of all of the line items in the sales document that have the same condition type as the group condition currently being processed.

Example:
A company defines a particular discount (condition type Z001) with scales based on weight. When a sales order line item is priced that is eligible for the Z001 discount, the user would like the system to read the scale with not just the weight of the current line item, but the combined weight of all items in the sales documenwhere the Z001 discount applies. To accomplish this, the user defines condition type Z001 as a group condition and assigns structure of group key formula '1' to it in customizing.

STRUCTURE OF GROUP KEY FORMULA 2: ACROSS ALL CONDITION TYPES

Formula '2' adds up the quantities / values of all of the line items in the sales document independent of which condition types have been applied.

Example: A company defines their prices with scales based on weight. When a sales order line item is priced, the user would like the system to read the scale with not just the weight of the current line item, but the combined weight of all items in the sales document. To accomplish this, the user defines their price condition types as group conditions and assigns structure of group key formula '2' to them in customizing.

STRUCTURE OF GROUP KEY FORMULA 3: MATERIAL PRICING GROUP

Formula '3' adds up the quantities / values of all of the line items in the sales document that have the same material pricing group (field KONDM) as the current sales document line item.

Example:A company defines a particular discount (condition type Z001) with scales based on weight. When a sales order line item is priced that is eligible for the Z001 discount, the user would like the system to read the scale with not just the weight of the current line item, but the combined weight of all items in the sales document that have the same material pricing group as the current line item. To accomplish this, the user defines condition type Z001 as a group condition and assigns structure of group key formula '3' to it in customizing.

STRUCTURE OF GROUP KEY FORMULA 10: SHIPPING MATERIAL

Formula '10' is only relevant for shipment costing in the shipment cost document. Formula '10' adds up the quantities / values of all of the sub-items in a shipment cost document item that have the same shipping material as the sub-item currently being processed.