topic Re: FI-ABAP : how to calculate payment date using a module function ? in Application Development and Automation Discussions

FI-ABAP : how to calculate payment date using a module function ?

Former Member — Mon, 07 Aug 2006 07:24:39 GMT

Hello,

I would like to calculate the payment date using the document date (BLDAT) and the payment terms (ZALDT).

I think there is one standard module function which do it but I do not know which one.

Could you please help me ?

Regards,

Francis

Re: FI-ABAP : how to calculate payment date using a module function ?

Former Member — Mon, 07 Aug 2006 07:38:54 GMT

check fm...

<b>FM_RECERTIFIED_PAYMENT_DATE</b>

Re: FI-ABAP : how to calculate payment date using a module function ?

Former Member — Mon, 07 Aug 2006 07:43:57 GMT

Hi,

Chk the link below

http://help.sap.com/printdocu/core/Print46c/en/data/pdf/BCBMTWFMFI/BCBMTWFMFI.pdf

Reward points if helpful.

Regards,

Harini.S

Re: FI-ABAP : how to calculate payment date using a module function ?

andreas_mann3 — Mon, 07 Aug 2006 08:12:31 GMT

hi,

use fm DETERMINE_DUE_DATE

(look example in abap RFITEMAP)

Andreas

Re: FI-ABAP : how to calculate payment date using a module function ?

Former Member — Mon, 07 Aug 2006 08:55:49 GMT

Hi Andreas,

I have tried to look for DETERMINE_DUE_DATE and I cannot find it, even in the RFITEMAP Abap program.

Are you sure of the name of the function ?

Regards,

Francis

Re: FI-ABAP : how to calculate payment date using a module function ?

Former Member — Wed, 09 Aug 2006 11:17:14 GMT

Hi Francis

Check the FM,

J_1A_SD_CI_DUEDATE_GET

It takes the

Invoice Number(IV_VBELN),

Payment Term(IV_ZTERM)

Regards,

Samson

Re: FI-ABAP : how to calculate payment date using a module function ?

andreas_mann3 — Wed, 09 Aug 2006 13:38:00 GMT

sorry Francis,

this will run:

REPORT zforum101 .

TABLES: faede, bsid, bsega, t052.

PARAMETERS : p_zterm LIKE t052-zterm DEFAULT '1400'.
PARAMETERS : bldat TYPE sy-datum DEFAULT '20060801'.

SELECT SINGLE * FROM  t052
       WHERE  zterm  = p_zterm.

CLEAR faede.
MOVE-CORRESPONDING t052 TO faede.
MOVE: t052-ztag1 TO faede-zbd1t,
      t052-ztag2 TO faede-zbd2t,
      t052-ztag3 TO faede-zbd3t.

MOVE bldat TO faede-bldat.
faede-koart = 'D'.

CALL FUNCTION 'DETERMINE_DUE_DATE'
     EXPORTING
          i_faede = faede
     IMPORTING
          e_faede = faede
     EXCEPTIONS
          OTHERS  = 1.

bsega-netdt = faede-netdt.

WRITE bsega-netdt.

pls reward useful answers

Message was edited by: Andreas Mann

Re: FI-ABAP : how to calculate payment date using a module function ?

Former Member — Thu, 10 Aug 2006 08:54:03 GMT

Hello,

Thanks a lot for your example. but it only works for one condition term... For the others, it returns the same date.

I will check deeply to see why.

Regards,

Francis

Re: FI-ABAP : how to calculate payment date using a module function ?

Former Member — Thu, 10 Aug 2006 09:26:05 GMT

Andreas,

I have check and it does not work, the date I get is not the correct one.

I think your affectations to "faede" are not correct.

Regards,

Francis

Re: FI-ABAP : how to calculate payment date using a module function ?

Former Member — Thu, 10 Aug 2006 09:37:46 GMT

Andreas,

Here is not sufficient :

"MOVE: t052-ztag1 TO faede-zbd1t,

t052-ztag2 TO faede-zbd2t,

t052-ztag3 TO faede-zbd3t."

You also have to put the correct data for faede-zfbdt.

I think there is another function that uses directly T052-ZTERM... but I do not know which one.

Regards,

Francis

Re: FI-ABAP : how to calculate payment date using a module function ?

Former Member — Thu, 10 Aug 2006 10:44:30 GMT

I have the solution : first use FI_FIND_PAYMENT_CONDITIONS to get "zfbdt" value (if you do not have it) and then, you can use "DETERMINE_DUE_DATE".

Regards.

Francis