Conversion Table for Pricing (bcmtd1103m000)

Use this session to decompose the original pricing keys as present in MANMAN/HP source tables Pricing Table Detail File (FINDB.PRIFIL) and Foreign Currency Pricing Table Detail File (FINDB.CURPRFIL) into separate pricing key fields. Using this session implies nothing more then executing the specific command Generate Pricing Keys.

Execution

It is always mandatory to run the specific command if records are visible in this session.

Process logic

All records present in MANMAN/HP source tables Pricing Table Detail File (FINDB.PRIFIL) and Foreign Currency Pricing Table Detail File (FINDB.CURPRFIL) are stored unconditionally into target table bcmtd103.

Via the specific command ‘Generate Pricing Keys’, for all present pricing records the following separate fields:

  • MANMAN Item Code,
  • Product Type,
  • Customer
  • Customer Type

are retrieved from the Pricing Key field.

If the first 18 positions of the Pricing Key field, do occur in the table ‘Conversion table for Items’ (bcmtc119), the pricing record applies to an item. If the 18 positions do not represent a product number and are not empty, the pricing record is (at least) defined for a product type. If the next 10 positions (19-28) do occur in ‘Mapping Table for Business Partners’ (bcmtc113) for origin ‘BILMAS’, the pricing record applies to a product type and a customer. If the selected 10 position do not represent a customer and are not empty, the pricing record applies to a product type and a customer type. For pricing records that originate from FINDB.CURPRFIL the positions 29-32 are stored in the currency field.

Note: For more information refer to the MANMAN/HP migration General Topic To migrate Pricing Data.
MANMAN/HP Origin Table

Indicates the MANMAN/HP source table the pricing record originates from.

Allowed values

The following values are allowed:

  • FINDB.PRIFIL
  • FINDB.CURPRFIL
Pricing Key

Contains the Pricing Key field of the pricing record.

Default value

The Pricing Key is filled with the value stored in FINDB.PRIFIL.PRINUM and FINDB.CURPRFIL.CURPRNUM.

Quantity

Contains the quantity break value of the pricing record.

Default value

Quantity is filled with the value stored in FINDB.PRIFIL.QTY and in FINDB.CURPRFIL.QTY

MANMAN/HP Item Code

The Item Code that is part of the pricing key. The Item Code will only be filled after running the specific command ‘Generate Pricing Keys’.

Default value

The MANMAN/HP Item Code is initially left empty

Product Type

The Product Type that is part of the pricing key. The Product Type is filled after running the specific command ‘Generate Pricing Keys’.

Default value

The MANMAN/HP Product Type is initially left empty

Customer

The Customer that is part of the pricing key. The Customer will be filled after running the specific command ‘Generate Pricing Keys’.

Default value

The MANMAN/HP Customer is initially left empty

Customer Type

The Customer Type that is part of the pricing key. The Customer Type will be filled after running the specific command ‘Generate Pricing Keys’. If no customer code is represented by the last 10 positions of the pricing key, these characters do represent a customer type.

Default value

The MANMAN/HP Customer Type is initially left empty

MANMAN/HP Currency

The Currency that is part of the pricing key. The Currency will be filled after running the specific command ‘Generate Pricing Keys’. The Currency Code is only filled for records that originate from MANMAN/HP source table ‘Foreign Currency Pricing Table Detail File’ (FINDB.CURPRFIL).

Default value

The MANMAN/HP Currency is initially left empty