SEPA Direct Debit sequence

[Former Member]

Hello,

I am implementing SEPA direct debit on ECC 4.7 using DMEE format SEPA_DD

when i create the xml, the sequence type is always RCUR.

even if i create a new mandate and use it for the first time in payment run, the xml has RCUR instead of FRST.

can someone help me please.

Thanks

[Former Member · Accepted solution]

Hello,

Can anyone help please it is a bit urgent.

Thanks

[nico_dewaele · Accepted solution]

Hi,

Do oy

The field is filled from FPAYHX-SEQ_TYPE. Check in debugging (SAPFPAYM ) if the field is correctly populated.

kr

Nico

[Former Member · Accepted solution]

Hi Nico,

How do i debug SAPFPAYM?

[Former Member · Accepted solution]

Tried to debug from se38 but i cannot set the watchpoint for this field.

do i need to debug from F110?

Thanks

[nico_dewaele · Accepted solution]

did you check note 1834535?

otherwise, check function module FI_FILL_FPAYHX

[Former Member · Accepted solution]

Hi Nico,

thank you for the useful information.

in the function module FI_FILL_FPAYHX i can see this code currently

   ASSIGN COMPONENT 'PAY_TYPE'

                         OF STRUCTURE <SEPA_STR_MANDATE> TO <PAY_TYPE>.

      IF SY-SUBRC = 0.

        IF <PAY_TYPE> = '1'.

          ES_FPAYHX-SEQ_TYPE  = 'OOFF'.

        ELSE.

          ES_FPAYHX-SEQ_TYPE  = 'RCUR'.

        ENDIF.

      ENDIF.

this looks like if it is one off mandate the sequence type us OOFF else it is set to RCUR always.

this seems wrong.

can you please let me know from your system how this function module should look like and which note will correct this data?

[nico_dewaele · Accepted solution]

it's a bit lower:

   IF L_MANDATE_INFO-PAY_TYPE = '1'.

      ES_FPAYHX-SEQ_TYPE  = 'OOFF'.

    ELSE.

      ES_FPAYHX-SEQ_TYPE  = 'RCUR'.

*- Heuristik fuer erste Mandatsverwendung

      CALL FUNCTION 'DMEE_SEPA_MANDATE_GET'

        EXPORTING

          I_MGUID        = IS_FPAYH-MGUID

        IMPORTING

          E_MANDATE_DATA = L_CURRENT_MANDATE.



      IF  L_CURRENT_MANDATE-FIRSTUSE_DATE = L_CURRENT_MANDATE-LASTUSE_DATE.

        ES_FPAYHX-SEQ_TYPE  = 'FRST'.

      ENDIF.

    ENDIF.

    ENDIF.                                                  "nte1424561

  ENDIF.

[Former Member · Accepted solution]

Hi Nico,

Now that i have implemented notes

1401975

1424561

1597564

1793204

the sequence type is always FRST if i execute the payment run on the same day for the same customer.

i am not sure what will be the seq type if i generate the file after 4 days but even if it is today i want the second file to have RCUR.

also the following information is missing from the DMEE tree how do i get it (underlined) ?

  <GrpHdr>

   <MsgId>1000102509</MsgId>

   <CreDtTm>2013-09-27T12:38:34</CreDtTm>

   <NbOfTxs>1</NbOfTxs>

   <CtrlSum>922.25</CtrlSum>

   <Grpg>MIXD</Grpg>

   <InitgPty>

    <Nm>Marketing Company</Nm>

      <Id>

            <OrgId>

                  <PrtryId>

                        <Id>SWE021</Id>

            </PrtryId>

        </OrgId>

    </Id>

   </InitgPty>

  </GrpHdr>

and

                  <CdtrAgt>

                        <FinInstnId>

                              <BIC>BKAUATWW</BIC>

                        </FinInstnId>

                        <BrnchId>

                              <Id>6948</Id>

                        </BrnchId>

                  </CdtrAgt>

[nico_dewaele · Accepted solution]

hej,

als the coding looks at first use date & current mandate date, all the files of the first day will be 'FRST'. why would you want to send several files on the same day?

      IF  L_CURRENT_MANDATE-FIRSTUSE_DATE = L_CURRENT_MANDATE-LASTUSE_DATE.

        ES_FPAYHX-SEQ_TYPE  = 'FRST'.

For the other ones, you'll have to adjust the DMEE file and map the new fields with the fields where your missing data appears. You may have to do some additional abap to get them into FPAYHX.

[Former Member · Accepted solution]

Hi Nico,

we have one mandate for a customer but we run the payment run for the same customer for different sales org in a day.

so the same mandate information is picked twice in a day and both the files have FRST isn't that wrong?

e.g the payer is resonsible for  sales area 01 and also for sales are 03. Then it could be that for this customer the payment run will be stared twice a day, but for differnt dunning areas (=1, =3)

Thanks

[nico_dewaele · Accepted solution]

hej,

I still see no need, both invoices can be requested to be paid in one payment run/file.

if you want in differently, you'll have to adjust the coding to first look at first use date and then to see if there's already a run on that day.

kr

Nico

[Former Member · Accepted solution]

Hi Nico,

thanks for your time

where should i do the coding? is there any BADI? user exit?

[nico_dewaele · Accepted solution]

nope, you'll have to manipulate FI_FILL_FPAYHX

[Former Member · Accepted solution]

Hello sap user,

We have the same problem as you. How did you solve it?

Regards,

Óscar