SAP table MCFPLT (Sales document: Billing plan dates ;)

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
FPART Billing/Invoicing Plan Type CHAR 2 0 * FPART
BEDAT Start date for billing plan/invoice plan DATS 8 0 BEDAT_FP
ENDAT End date billing plan/invoice plan DATS 8 0 ENDAT_FP
LODAT Dates from DATS 8 0 TADAT
TNDAT Dates to DATS 8 0 TBDAT
DUMMY Dummy function in length 1 CHAR 1 0 DUMMY

MCFPLT foreign key relationships

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