SAP table VFPLT (Billing Plan: Dates)

SAP table VFPLT has 3 primary key fields being MANDT,FPLNR,FPLTR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
FPLNR Billing plan number / invoicing plan number CHAR 10 0 FPLNR
FPLTR Item for billing plan/invoice plan/payment cards NUMC 6 0 FPLTR
FPTTP Date category CHAR 2 0 TFPLT FPTTP
TETXT Date Description CHAR 4 0 TVTB TETXT_FP
FKDAT Settlement date for deadline DATS 8 0 BFDAT
FPFIX ID for adopting billing/invoice date CHAR 1 0 FPFIX
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 CHAR 1 0 FAREG
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 DEC 5 2 FPROZ
WAERS Currency Key of Credit Control Area CUKY 5 0 TCURC WAERS_CP
KURFP Exchange rate for date in billing plan DEC 9 5 KURFP
FAKWR Value to be billed/calc. on date in billing/invoice plan CURR 15 2 FAKWR
FAKSP Billing block for billing plan/invoice plan dates CHAR 2 0 TVFS FAKSP_FP
FKARV Proposed billing type for an order-related billing document CHAR 4 0 TVFK FKARA
FKSAF Billing status for the billing plan/invoice plan date CHAR 1 0 FKSAF
Not Relevant
A Open
B Partially Processed
C Invoiced
D Rejected
E Billing Requested
PERIO Rule for Origin of Next Billing/Invoice Date CHAR 2 0 TVRG PERIO_FP
FPLAE Length of a standard period in the billing plan NUMC 3 0 FPLAE
MLSTN Milestone number NUMC 12 0 MLST_ZAEHL
MLBEZ Usage CHAR 5 0 T433 MILESTONE
ZTERM Terms of payment key CHAR 4 0 TVZBT DZTERM
KUNRG Payer CHAR 10 0 KNA1 KUNRG
TAXK1 Tax Classification 1 for Customer CHAR 1 0 TAXK1
TAXK2 Tax Classification 2 for Customer CHAR 1 0 TAXK2
TAXK3 Tax Classification 3 for Customer CHAR 1 0 TAXK3
TAXK4 Tax Classification 4 for Customer CHAR 1 0 TAXK4
TAXK5 Tax Classification 5 for Customer CHAR 1 0 TAXK5
TAXK6 Tax Classification 6 for Customer CHAR 1 0 TAXK6
TAXK7 Tax Classification 7 for Customer CHAR 1 0 TAXK7
TAXK8 Tax Classification 8 for Customer CHAR 1 0 TAXK8
TAXK9 Tax Classification 9 for Customer CHAR 1 0 TAXK9
VALTG Additional Value Days NUMC 2 0 VALTG
VALDT Fixed Value Date DATS 8 0 VALDT
NFDAT Settlement date for deadline DATS 8 0 NFDAT
TEMAN Process as for manually entered date CHAR 1 0 TEMAN_1
FAKCA Calendar for Defining Days Relevant to Billing/Invoicing CHAR 2 0 TFACD FAKCA
AFDAT Billing Date DATS 8 0 FKDAT
NETWR Net Value of the Order Item in Document Currency CURR 15 2 NETWR_AP
NETPR Net Price CURR 11 2 NETPR
WAVWR Cost in Document Currency CURR 13 2 WAVWR
KZWI1 Subtotal 1 from Pricing Procedure for Price Element CURR 13 2 KZWI1
KZWI2 Subtotal 2 from Pricing Procedure for Price Element CURR 13 2 KZWI2
KZWI3 Subtotal 3 from Pricing Procedure for Price Element CURR 13 2 KZWI3
KZWI4 Subtotal 4 from Pricing Procedure for Price Element CURR 13 2 KZWI4
KZWI5 Subtotal 5 from Pricing Procedure for Price Element CURR 13 2 KZWI5
KZWI6 Subtotal 6 from Pricing Procedure for Price Element CURR 13 2 KZWI6
CMPRE Item credit price CURR 11 2 CMPRE
SKFBP Amount Eligible for Cash Discount in Document Currency CURR 13 2 SKFBT_CS
BONBA Rebate Basis 1 CURR 13 2 BONBA
PRSOK Pricing is OK CHAR 1 0 PRSOK
TYPZM Means of payment for classifying payment card plan lines CHAR 1 0 TYPZM
0 Payment card
CMPRE_FLT Item Credit Price FLTP 16 16 CMPRE_FLT
UELNR Higher-level payment card plan number for billing CHAR 10 0 FPLA UELNR
UELTR Higher-level item in billing plan NUMC 6 0 FPLT UELTR
KURRF Exchange Rate for Postings to Financial Accounting DEC 9 5 KURRF
CCACT G/L Account Number for Payment Card Receivables CHAR 10 0 SKA1 CCACT
KORTE Indicator for correction date in billing plan CHAR 1 0 KORTE
No correction date
A Correction date with inverted +/-

VFPLT foreign key relationships

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