DMEE - Sort Fields

[aidaj_hilton]

I know this is a common issue and the question has been asked numerous times but never answered.  I'm hopeful that somebody will be able to assist me.  I have used the PMW several times and am familiar with the various DME configuration documents which have been very useful so please don't just respond with links to existing posts as I have already read them 🙂

In DMEE I have defined my sort field as FPAYHX-REF01 (Level 1).  Unfortunately this sort is only taken into account after the payment proposal sort which seems to be by vendor number.

The result is that my dataset looks like this:

Vendor          REF01

1                    E

2                    V

3                    V

4                    E

5                    V

Required result:  2 files get generated as follows:

1                    E

4                    E

2                    V

3                    V

5                    V

Actual result:  4 file are being generated as follows

1                    E

2                    V

3                    V 

4                    E

5                    V

I understand from reading previous posts on the subject that the sort depends on the value in FPAYH-SORTF1.  I'm not clear on when this field is populated and how I can impact this field to give me the result I require.  Greatful for any assistance and of course points will be awarded for helpful responses

[aidaj_hilton]

A response from a previous post regarding a similar issue suggested that the field REGUH-SRTF1 (from which the sorting is determined) was filled from the SAPFPAYM program the first time it runs a new dataset.  This is still not clear to me how this field is impacted by the sort fields I select in my DMEE.