determine due date

[eyal_alsheikh]

Hello,

I need to calculate the "Net due date" of a document.

We can see the net due date at FBL5N report, but we have not found how it was calculated there.

We found the function DETERMINE_DUE_DATE but we did not succeed to operate it.

Is there a FM that calcaulates it?

Thank from advanced,

Eyal.

[Former Member · Accepted solution]

From the help on 'baseline date' in FB03: "If the cash discount rates (and days) have not been entered, the baseline date for payment is the same as the due date." If dicounts and days have been entered, it is the "Date on which payment of an open item is due net, that is with no cash discount deduction."

Look at FM NET_DUE_DATE_GET.

Rob

Message was edited by: Rob Burbank

[Former Member · Accepted solution]

Function module ITEM_DERIVE_FIELDS is used in FBL5N program RFITEMAR. Keep a break point in debug mode. It will help you in terms of passing parameters.

[Former Member]

due_date = <b>bseg-zfbdt</b> + <b>t052-ztag1</b>.

Here ztag1 is obtained from table <b>t052</b> using <b>bseg-zterm</b>.

[Former Member]

Use the following code, gtb_bsid_bsad is the data selection for open items.

MOVE: gtb_bsid_bsad-shkzg TO ls_faede_e-shkzg,

'D' TO ls_faede_e-koart,

gtb_bsid_bsad-zfbdt TO ls_faede_e-zfbdt,

gtb_bsid_bsad-zbd1t TO ls_faede_e-zbd1t,

gtb_bsid_bsad-zbd2t TO ls_faede_e-zbd2t,

gtb_bsid_bsad-zbd3t TO ls_faede_e-zbd3t,

gtb_bsid_bsad-rebzg TO ls_faede_e-rebzg,

gtb_bsid_bsad-rebzt TO ls_faede_e-rebzt,

gtb_bsid_bsad-bldat TO ls_faede_e-bldat.

CALL FUNCTION 'DETERMINE_DUE_DATE'

EXPORTING

i_faede = ls_faede_e

IMPORTING

e_faede = ls_faede_i

EXCEPTIONS

account_type_not_supported = 1

OTHERS = 2.

ls_faede_i-netdt gives you the netduedate for the document.

I hope this helps you

[Former Member]

Hi,

Refer this code:

Data : ipf type intipf,
       wa_intit type INTIT_EXTF

.

Select single *  from T056U
       into wa_t056u
       where vzskz = ipf-vzskz.

data:faede type faede.

Select single * from BSAD
                into wa_bsad
                where belnr = wa_intit-belnr.

move-corresponding wa_bsad to faede.
faede-koart = C_D.

CALL FUNCTION 'DETERMINE_DUE_DATE'
  EXPORTING
    I_FAEDE                          = faede
 IMPORTING
   E_FAEDE                          =  faede
 EXCEPTIONS
   ACCOUNT_TYPE_NOT_SUPPORTED       = 1
   OTHERS                           = 2
          .
IF SY-SUBRC <> 0.
* MESSAGE ID SY-MSGID TYPE SY-MSGTY NUMBER SY-MSGNO
*         WITH SY-MSGV1 SY-MSGV2 SY-MSGV3 SY-MSGV4.
ENDIF.

move faede-netdt to gv_netdt.

Regards,

Gayathri