SAP Table FPLT
Billing Plan: Dates
FPLT (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 FPLT to other SAP tables.
FPLT table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
FAREG
Rule in billing plan/invoice plan
|
FAREG |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 |
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 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
TYPZM
Means of payment for classifying payment card plan lines
|
TYPZM |
CHAR
|
1 | 0 | ||||||||||||||||
|
||||||||||||||||||||
|
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 | ||||||||||||||||
|
||||||||||||||||||||
|
OFKDAT
Baseline date for determining AFDAT
|
OFKDAT |
DATS
|
8 | 0 | ||||||||||||||||
|
PEROP_BEG
Period of Performance Start Date
|
FM_PEROP_SD_LOW |
DATS
|
8 | 0 | ||||||||||||||||
|
PEROP_END
Period of Performance End Date
|
FM_PEROP_SD_HIGH |
DATS
|
8 | 0 | ||||||||||||||||
FPLT foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| FPLT | CCACT | FPLT | MANDT |
SKA1
G/L Account Master (Chart of Accounts)
|
MANDT |
| FPLT | CCACT | * |
SKA1
G/L Account Master (Chart of Accounts)
|
KTOPL | |
| FPLT | CCACT | FPLT | CCACT |
SKA1
G/L Account Master (Chart of Accounts)
|
SAKNR |
| FPLT | FAKCA | FPLT | FAKCA |
TFACD
Factory calendar definition
|
IDENT |
| FPLT | FAKSP | FPLT | FAKSP |
TVFS
Billing: Reasons for Blocking
|
FAKSP |
| FPLT | FAKSP | FPLT | MANDT |
TVFS
Billing: Reasons for Blocking
|
MANDT |
| FPLT | FKARV | FPLT | MANDT |
TVFK
Billing: Document Types
|
MANDT |
| FPLT | FKARV | FPLT | FKARV |
TVFK
Billing: Document Types
|
FKART |
| FPLT | FPTTP | FPLT | MANDT |
TFPLT
Date Type for Billing Plan Type
|
MANDT |
| FPLT | FPTTP | FPLA | FPART |
TFPLT
Date Type for Billing Plan Type
|
FPART |
| FPLT | FPTTP | FPLT | FPTTP |
TFPLT
Date Type for Billing Plan Type
|
FPTTP |
| FPLT | KUNRG | FPLT | KUNRG |
KNA1
General Data in Customer Master
|
KUNNR |
| FPLT | KUNRG | FPLT | MANDT |
KNA1
General Data in Customer Master
|
MANDT |
| FPLT | MANDT | FPLT | MANDT |
T000
Clients
|
MANDT |
| FPLT | MLBEZ | FPLT | MANDT |
T433
Milestone Indicator
|
MANDT |
| FPLT | MLBEZ | FPLT | MLBEZ |
T433
Milestone Indicator
|
MLSTN |
| FPLT | PERIO | FPLT | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| FPLT | PERIO | FPLT | PERIO |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| FPLT | TETXT | FPLT | MANDT |
TVTB
Billing Plan: Date Description
|
MANDT |
| FPLT | TETXT | FPLT | TETXT |
TVTB
Billing Plan: Date Description
|
TETBE |
| FPLT | UELNR | FPLT | MANDT |
FPLA
Billing Plan
|
MANDT |
| FPLT | UELNR | FPLT | UELNR |
FPLA
Billing Plan
|
FPLNR |
| FPLT | UELTR | FPLT | MANDT |
FPLT
Billing Plan: Dates
|
MANDT |
| FPLT | UELTR | FPLT | FPLNR |
FPLT
Billing Plan: Dates
|
FPLNR |
| FPLT | UELTR | FPLT | UELTR |
FPLT
Billing Plan: Dates
|
FPLTR |
| FPLT | WAERS | FPLT | MANDT |
TCURC
Currency Codes
|
MANDT |
| FPLT | WAERS | FPLT | WAERS |
TCURC
Currency Codes
|
WAERS |