| # 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 Validate If you run the specific command Validate and at least one of the following pricing fields: MANMAN Item Code, Product Type, Customer Customer Type is filled, all pricing records are checked. Generate Pricing Keys If you run the specific command Generate Pricing Keys the Item Code, Product Type, Customer, Customer Type and Currency will be filled. |