09-17-2009 11:00 AM
hello SAP gurus,
the issue is that we select payment terms when we create sales and order , and we want it to be printed under , 1st installment date and amount , 2nd installement date and amout , 3rd installemnt date and amount.
we have defined the payment terms while creating a sales order . now we want to see on the system itself when is the next date due for the installment and the total amount ....similarly 2nd date and amount due and so on ............is there any database table from where these installment dates and amounts are picked ...........if yes what are they......
Any suggestions or help plzzzzzzzzzzz
Honey
09-17-2009 11:02 AM
Tables FPLA & FPLT hold the billing plan data which separates the total amount into individual lines and dates.
09-17-2009 11:07 AM
Hi Honey,
May be these FMs will help you...
SD_PRINT_TERMS_OF_PAYMENT
FI_TERMS_OF_PAYMENT_CHECK
FI_TERMS_OF_PAYMENT_PROPOSE
Check out below Tables for Payment Term Days
T052 T052U T05* Tables...
Also look at VBAK VBRK tables for amount and other info.. ZTERM is the Field for Payment Terms.. based on that you can write logic for it..
Hope it will solve your problem..
Thanks & Regards
ilesh 24x7
ilesh Nandaniya