How to Add Entry to Matrix PP

To add an entry to a Matrix Pricing Parameter:

def pp = api.findLookupTable("MarginBySegment")
def entry = [:]
entry.lookupTableId = pp.id
entry.key1 = segment.Mfr
entry.key2 = segment.PBG
entry.key3 = segment.PBU
entry.key4 = segment.PRC
entry.key5 = segment.ProductDesignEligible
entry.attribute1 = pvs.low
entry.attribute2 = pvs.target
entry.attribute3 = pvs.high
api.addOrUpdate("MLTV5", entry)

It is important here to have the lookupTableId in the values map.


Alternatively, you can skip the findLookupTable call and specify the PP name directly in the values map:

def entry = [:]
entry.lookupTableName = "MarginBySegment"
entry.key1 = segment.Mfr
...
api.addOrUpdate("MLTV5", entry)