SAP VFPLT Billing Plan: Dates Table
Overview
VFPLT is a standard SAP S/4HANA table that stores Billing Plan: Dates data. There are total 56 fields in the VFPLT table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VFPLT belongs to Basic Functions (SD-BF) module and is located in the package Application development R/3 RV central functions (VZ).
In addition, following links provide an overview of foreign key relationships, if any, that link VFPLT to other SAP tables and standard CDS views available based on VFPLT table in S/4HANA 2020.
Techincal Settings of VFPLT
Below are technical details of the table VFPLT
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VFPLT Fields
The following table gives you an overview of the fields available in VFPLT
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 |
| FPLNR | Billing plan number / invoicing plan number | FPLNR | CHAR | 10 | |
| FPLTR | Item for billing plan/invoice plan/payment cards | FPLTR | NUMC | 6 | |
| FPTTP | Date category | FPTTP | TFPLT | CHAR | 2 |
| TETXT | Date Description | TETXT_FP | TVTB | CHAR | 4 |
| FKDAT | Settlement date for deadline | BFDAT | DATS | 8 | |
| FPFIX | ID for adopting billing/invoice date | FPFIX | CHAR | 1 | |
| FAREG | Rule in billing plan/invoice plan | FAREG | CHAR | 1 | |
| FPROZ | Percentage of value to be invoiced | FPROZ | DEC | 5 | |
| WAERS | Currency Key of Credit Control Area | WAERS_CP | TCURC | CUKY | 5 |
| KURFP | Exchange rate for date in billing plan | KURFP | DEC | 9 | |
| FAKWR | Value to be billed/calc. on date in billing/invoice plan | FAKWR | CURR | 15 | |
| FAKSP | Billing block for billing plan/invoice plan dates | FAKSP_FP | TVFS | CHAR | 2 |
| FKARV | Proposed billing type for an order-related billing document | FKARA | TVFK | CHAR | 4 |
| FKSAF | Billing status for the billing plan/invoice plan date | FKSAF | CHAR | 1 | |
| PERIO | Rule for Origin of Next Billing/Invoice Date | PERIO_FP | TVRG | CHAR | 2 |
| FPLAE | Length of a standard period in the billing plan | FPLAE | NUMC | 3 | |
| MLSTN | Milestone number | MLST_ZAEHL | NUMC | 12 | |
| MLBEZ | Usage | MILESTONE | T433 | CHAR | 5 |
| ZTERM | Terms of payment key | DZTERM | TVZBT | CHAR | 4 |
| KUNRG | Payer | KUNRG | KNA1 | CHAR | 10 |
| TAXK1 | Tax Classification 1 for Customer | TAXK1 | CHAR | 1 | |
| TAXK2 | Tax Classification 2 for Customer | TAXK2 | CHAR | 1 | |
| TAXK3 | Tax classification 3 for customer | TAXK3 | CHAR | 1 | |
| TAXK4 | Tax Classification 4 Customer | TAXK4 | CHAR | 1 | |
| TAXK5 | Tax Classification 5 for Customer | TAXK5 | CHAR | 1 | |
| TAXK6 | Tax Classification 6 for Customer | TAXK6 | CHAR | 1 | |
| TAXK7 | Tax Classification 7 for Customer | TAXK7 | CHAR | 1 | |
| TAXK8 | Tax Classification 8 for Customer | TAXK8 | CHAR | 1 | |
| TAXK9 | Tax Classification 9 for Customer | TAXK9 | CHAR | 1 | |
| VALTG | Additional Value Days | VALTG | NUMC | 2 | |
| VALDT | Fixed Value Date | VALDT | DATS | 8 | |
| NFDAT | Settlement date for deadline | NFDAT | DATS | 8 | |
| TEMAN | Process as for manually entered date | TEMAN_1 | CHAR | 1 | |
| FAKCA | Calendar for Defining Days Relevant to Billing/Invoicing | FAKCA | TFACD | CHAR | 2 |
| AFDAT | Billing Date | FKDAT | DATS | 8 | |
| NETWR | Net Value of the Order Item in Document Currency | NETWR_AP | CURR | 15 | |
| NETPR | Net Price | NETPR | CURR | 11 | |
| WAVWR | Cost in document currency | WAVWR | CURR | 13 | |
| KZWI1 | Subtotal 1 from pricing procedure for condition | KZWI1 | CURR | 13 | |
| KZWI2 | Subtotal 2 from pricing procedure for condition | KZWI2 | CURR | 13 | |
| KZWI3 | Subtotal 3 from pricing procedure for condition | KZWI3 | CURR | 13 | |
| KZWI4 | Subtotal 4 from pricing procedure for condition | KZWI4 | CURR | 13 | |
| KZWI5 | Subtotal 5 from pricing procedure for condition | KZWI5 | CURR | 13 | |
| KZWI6 | Subtotal 6 from pricing procedure for condition | KZWI6 | CURR | 13 | |
| CMPRE | Item credit price | CMPRE | CURR | 11 | |
| SKFBP | Amount Eligible for Cash Discount in Document Currency | SKFBT_CS | CURR | 13 | |
| BONBA | Rebate basis 1 | BONBA | CURR | 13 | |
| PRSOK | Pricing is OK | PRSOK | CHAR | 1 | |
| TYPZM | Means of payment for classifying payment card plan lines | TYPZM | CHAR | 1 | |
| CMPRE_FLT | Item Credit Price | CMPRE_FLT | FLTP | 16 | |
| UELNR | Higher-level payment card plan number for billing | UELNR | FPLA | CHAR | 10 |
| UELTR | Higher-level item in billing plan | UELTR | FPLT | NUMC | 6 |
| KURRF | Exchange rate for FI postings | KURRF | DEC | 9 | |
| CCACT | G/L Account Number for Payment Card Receivables | CCACT | SKA1 | CHAR | 10 |
| KORTE | Indicator for correction date in billing plan | KORTE | CHAR | 1 |
Foreign Key Relationships
A foreign key field is a table field that is allocated to a check table and becomes part of the table's foreign key. The following table gives you an overview of the foreign keys for VFPLT
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VFPLT | CCACT | 1: CN | SKA1 |
| VFPLT | FAKCA | : | TFACD |
| VFPLT | FAKSP | C: CN | TVFS |
| VFPLT | FKARV | C: CN | TVFK |
| VFPLT | FPTTP | 1: CN | TFPLT |
| VFPLT | KUNRG | C: CN | KNA1 |
| VFPLT | MANDT | 1: CN | T000 |
| VFPLT | MLBEZ | C: CN | T433 |
| VFPLT | PERIO | C: CN | TVRG |
| VFPLT | TETXT | 1: CN | TVTB |
| VFPLT | UELNR | 1: CN | FPLA |
| VFPLT | UELTR | 1: CN | FPLT |
| VFPLT | WAERS | C: CN | TCURC |
| VFPLT | ZTERM | C: CN | TVZBT |