SAP table FPLT (Billing Plan: Dates)

SAP table FPLT 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 CUKY 5 0 TCURC WAERS
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 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 +/-
OFKDAT Baseline date for determining AFDAT DATS 8 0 OFKDAT
DESCR Billing Plan Item Description CHAR 255 0 SDBP_ITEM_DESCR
POSTPR Reason for Postponement CHAR 255 0 SDBP_REASON_POSTPNMT
REFDOC SD Billing Plan Reference Document CHAR 1 0 SDBP_REFDOC
No reference exists
A Cancellation Invoice
SET_BY_FINAL Billing plan set to final CHAR 1 0 SDBP_SET_TO_FINAL_INDICATOR
ITEM_USAGE Billing Plan Item Usage CHAR 2 0 SDBP_ITEM_USAGE
Standard
1 Payment on Account
2 Periodic Service
3 Usage-based Billing
4 Down Payment Request
DB_KEY NodeID RAW 16 0 /BOBF/CONF_KEY
PARENT_KEY NodeID RAW 16 0 /BOBF/CONF_KEY
_DATAAGING Data Filter Value for Data Aging DATS 8 0 DATA_TEMPERATURE
AD04FAREG Rule for billing CHAR 1 0 AD04FAREG
PEROP_BEG Period of Performance Start Date DATS 8 0 FM_PEROP_SD_LOW
PEROP_END Period of Performance End Date DATS 8 0 FM_PEROP_SD_HIGH

FPLT foreign key relationships

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