Net Due Date Calculation

[Former Member]

HI All,

In the document system calculate the net due date as Sep 15, 2010, payment term is P001.

Where can I see the info in database tables for Net Due date as I need to use that in my report creation?

Cheers,

MRSMCA

[Former Member · Accepted solution]

Hi,

The net due date is not stored in the tables. It is calculated dynamically in all reports and transactions in SAP.

You can see the below fields in BSEG which are used to calculate the net due date for the document:-

ZTERM DZTERM CHAR 4 0 Terms of payment key

ZBD1T DZBD1T DEC 3 0 Cash discount days 1

ZBD2T DZBD2T DEC 3 0 Cash discount days 2

ZBD3T DZBD3T DEC 3 0 Net Payment Terms Period

ZBD1P DZBD1P DEC 5 3 Cash discount percentage 1

ZBD2P DZBD2P DEC 5 3 Cash Discount Percentage 2

SKFBT SKFBT CURR 13 2 Amount Eligible for Cash Discount in Document Currency

SKNTO SKNTO CURR 13 2 Cash discount amount in local currency

WSKTO WSKTO CURR 13 2 Cash discount amount in document currency

So better you also calculate the net due date dynamically in you report defination.

Regards,

Gaurav

[Former Member]

Also the function module used to determine the net due date is DETERMINE_DUE_DATE (You can see it in transaction SE37).

Regards,

Gaurav

[Former Member]

Thanks, it was a fast answer.

If there is no option, I will use the function module specified for the net due date calculation.

Thanks again.