Using Field Groups in dspMigrate

Answered

Michael Mowbray

• October 15, 2019 00:18

I have a zSAPPOType field set up in ttEKPO and I've defined Field Groups to use that (pic below). I've assigned the Field Groups to the Object in design and have split the target field (EKPO-MENGE) for mapping across the Field Groups (pic below). Automation is generating the SQL correctly (pic below) _except_ that I am sure it is meant to add an additional element to the WHERE clause to filter on the Field Group, something like

...
WHERE ...
AND (zSAPPOType = 'Material')

I'm positive I've had this working at a past project in DSP 6.x but it's been a while and I am probably missing a step somewhere. Any ideas how to get the result I expect?

Thanks in advance, screen shots follow ...

Field Groups:

Mapping:

Generated SQL:

1

• Best answer

  

  Michael Mowbray

  • October 16, 2019 22:48

  Just got a reply from Support and the initial configuration of the Filter Table needs to be the Source table, not Target. Compare pic below to the top one in the initial post.

  

  0
• 

  Andrew Lund

  • October 16, 2019 08:59

  Hello Michael - does the zSAPPOType field exist on the Source Table (stEKPO_EllipseEE_MSF221)? If you added it in target design as zSAPPOType, it's likely appended to the Source Table as zzSAPPOType. If this is the case, try changing the filter to zzSAPPOType.

  0
• 

  Michael Mowbray

  • October 16, 2019 22:33

  Thanks for the thought ... the field is defined in stEKPO_EllipseEE_MSF221 as zSAPPOType Varchar(50) with just the one 'z'.

  0

Please sign in to leave a comment.