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.
- 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