1. Home
  2. Resources
  3. SAP Tables
  4. VFPLT - Billing Plan: Dates

SAP Table VFPLT

Billing Plan: Dates

VFPLT (Billing Plan: Dates) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link VFPLT to other SAP tables.

VFPLT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FPLNR Billing plan number / invoicing plan number FPLNR CHAR 10 0
FPLTR Item for billing plan/invoice plan/payment cards FPLTR NUMC 6 0
FPTTP Date category FPTTP TFPLT CHAR 2 0
TETXT Date description TETXT_FP TVTB CHAR 4 0
FKDAT Settlement date for deadline BFDAT DATS 8 0
FPFIX ID for adopting billing/invoice date FPFIX CHAR 1 0
NULL Assignment to milestones not possible
0 Fixed date, date not copied from milestone
1 Planned/actual date from milestone
2 Planned/actual date from milestone if before billing date
3 Planned/actual date from milestone if after billing date
FAREG Rule in billing plan/invoice plan FAREG CHAR 1 0
1 Milestone billing on a percentage basis
2 Milestone billing on a value basis
3 Closing invoice in milestone billing
4 Down payment in milestone billing on percentage basis
5 Down payment in milestone billing on a value basis
6 Periodic billing (rent)
FPROZ Percentage of value to be invoiced FPROZ DEC 5 2
WAERS Currency Key of Credit Control Area WAERS_CP TCURC CUKY 5 0
KURFP Exchange rate for date in billing plan KURFP DEC 9 5
FAKWR Value to be billed/calc. on date in billing/invoice plan FAKWR CURR 15 2
FAKSP Billing block for billing plan/invoice plan dates FAKSP_FP TVFS CHAR 2 0
FKARV Proposed billing type for an order-related billing document FKARA TVFK CHAR 4 0
FKSAF Billing status for the billing plan/invoice plan date FKSAF CHAR 1 0
NULL Not Relevant
A Not yet processed
B Partially processed
C Completely processed
PERIO Rule for Origin of Next Billing/Invoice Date PERIO_FP TVRG CHAR 2 0
FPLAE Length of a standard period in the billing plan FPLAE NUMC 3 0
MLSTN Milestone number MLST_ZAEHL NUMC 12 0
MLBEZ Usage MILESTONE T433 CHAR 5 0
ZTERM Terms of Payment Key DZTERM TVZBT CHAR 4 0
KUNRG Payer KUNRG KNA1 CHAR 10 0
TAXK1 Tax classification 1 for customer TAXK1 CHAR 1 0
TAXK2 Tax classification 2 for customer TAXK2 CHAR 1 0
TAXK3 Tax classification 3 for customer TAXK3 CHAR 1 0
TAXK4 Tax Classification 4 Customer TAXK4 CHAR 1 0
TAXK5 Tax classification 5 for customer TAXK5 CHAR 1 0
TAXK6 Tax classification 6 for customer TAXK6 CHAR 1 0
TAXK7 Tax classification 7 for customer TAXK7 CHAR 1 0
TAXK8 Tax classification 8 for customer TAXK8 CHAR 1 0
TAXK9 Tax classification 9 for customer TAXK9 CHAR 1 0
VALTG Additional value days VALTG NUMC 2 0
VALDT Fixed value date VALDT DATS 8 0
NFDAT Settlement date for deadline NFDAT DATS 8 0
TEMAN Process as for manually entered date TEMAN_1 CHAR 1 0
NULL no manual schedule
X manual schedule
Y Process as for manually entered date
FAKCA Calendar for Defining Days Relevant to Billing/Invoicing FAKCA TFACD CHAR 2 0
AFDAT Billing date for billing index and printout FKDAT DATS 8 0
NETWR Net value of the order item in document currency NETWR_AP CURR 15 2
NETPR Net price NETPR CURR 11 2
WAVWR Cost in document currency WAVWR CURR 13 2
KZWI1 Subtotal 1 from pricing procedure for condition KZWI1 CURR 13 2
KZWI2 Subtotal 2 from pricing procedure for condition KZWI2 CURR 13 2
KZWI3 Subtotal 3 from pricing procedure for condition KZWI3 CURR 13 2
KZWI4 Subtotal 4 from pricing procedure for condition KZWI4 CURR 13 2
KZWI5 Subtotal 5 from pricing procedure for condition KZWI5 CURR 13 2
KZWI6 Subtotal 6 from pricing procedure for condition KZWI6 CURR 13 2
CMPRE Item credit price CMPRE CURR 11 2
SKFBP Amount Eligible for Cash Discount in Document Currency SKFBT CURR 13 2
BONBA Rebate basis 1 BONBA CURR 13 2
PRSOK Pricing is OK PRSOK CHAR 1 0
X Yes
NULL No
TYPZM Means of payment for classifying payment card plan lines TYPZM CHAR 1 0
0 Payment card
CMPRE_FLT Item credit price CMPRE_FLT FLTP 16 16
UELNR Higher-level payment card plan number for billing UELNR FPLA CHAR 10 0
UELTR Higher-level item in billing plan UELTR FPLT NUMC 6 0
KURRF Exchange rate for FI postings KURRF DEC 9 5
CCACT G/L Account Number for Payment Card Receivables CCACT SKA1 CHAR 10 0
KORTE Indicator for correction date in billing plan KORTE CHAR 1 0
NULL No correction date
A Correction date with inverted +/-

VFPLT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
VFPLT CCACT VFPLT CCACT SKA1 G/L Account Master (Chart of Accounts) SAKNR
VFPLT CCACT VFPLT MANDT SKA1 G/L Account Master (Chart of Accounts) MANDT
VFPLT CCACT * SKA1 G/L Account Master (Chart of Accounts) KTOPL
VFPLT FAKCA VFPLT FAKCA TFACD Factory calendar definition IDENT
VFPLT FAKSP VFPLT MANDT TVFS Billing: Reasons for Blocking MANDT
VFPLT FAKSP VFPLT FAKSP TVFS Billing: Reasons for Blocking FAKSP
VFPLT FKARV VFPLT FKARV TVFK Billing: Document Types FKART
VFPLT FKARV VFPLT MANDT TVFK Billing: Document Types MANDT
VFPLT FPTTP VFPLT MANDT TFPLT Date Type for Billing Plan Type MANDT
VFPLT FPTTP FPLA FPART TFPLT Date Type for Billing Plan Type FPART
VFPLT FPTTP VFPLT FPTTP TFPLT Date Type for Billing Plan Type FPTTP
VFPLT KUNRG VFPLT MANDT KNA1 General Data in Customer Master MANDT
VFPLT KUNRG VFPLT KUNRG KNA1 General Data in Customer Master KUNNR
VFPLT MANDT VFPLT MANDT T000 Clients MANDT
VFPLT MLBEZ VFPLT MANDT T433 Milestone Indicator MANDT
VFPLT MLBEZ VFPLT MLBEZ T433 Milestone Indicator MLSTN
VFPLT PERIO VFPLT MANDT TVRG Rule table for indirect date determination for contracts MANDT
VFPLT PERIO VFPLT PERIO TVRG Rule table for indirect date determination for contracts REGEL
VFPLT TETXT VFPLT MANDT TVTB Billing Plan: Date Description MANDT
VFPLT TETXT VFPLT TETXT TVTB Billing Plan: Date Description TETBE
VFPLT UELNR VFPLT MANDT FPLA Billing Plan MANDT
VFPLT UELNR VFPLT UELNR FPLA Billing Plan FPLNR
VFPLT UELTR VFPLT UELTR FPLT Billing Plan: Dates FPLTR
VFPLT UELTR VFPLT MANDT FPLT Billing Plan: Dates MANDT
VFPLT UELTR VFPLT FPLNR FPLT Billing Plan: Dates FPLNR
VFPLT WAERS VFPLT WAERS TCURC Currency Codes WAERS
VFPLT WAERS VFPLT MANDT TCURC Currency Codes MANDT
VFPLT ZTERM VFPLT MANDT TVZBT Customers: Terms of Payment Texts MANDT
VFPLT ZTERM SYST LANGU TVZBT Customers: Terms of Payment Texts SPRAS
VFPLT ZTERM VFPLT ZTERM TVZBT Customers: Terms of Payment Texts ZTERM