Overview
VSFPLT_CN is a standard SAP S/4HANA table that stores Version: Billing schedule: Dates data. There are total 59 fields in the VSFPLT_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSFPLT_CN belongs to Simulation (PS-SIM) module and is located in the package R/3 Application development: Version Management (CNVS).
In addition, following links provide an overview of foreign key relationships, if any, that link VSFPLT_CN to other SAP tables and standard CDS views available based on VSFPLT_CN table in S/4HANA 2020.
Techincal Settings of VSFPLT_CN
Below are technical details of the table VSFPLT_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSFPLT_CN Fields
The following table gives you an overview of the fields available in VSFPLT_CN
| Field | Description | Data Element | Check Table | Data Type | Length |
|---|
| MANDT | Client | MANDT | | CLNT | 3 |
| VSNMR | Number or description of a version | VSNMR | | CHAR | 12 |
| 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 | | CHAR | 2 |
| TETXT | Date Description | TETXT_FP | | CHAR | 4 |
| FKDAT | Billing Date | FKDAT | | 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 | | 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 | | CHAR | 2 |
| FKARV | Proposed billing type for a delivery-related billing doc. | FKARV | | 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 | | 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 | | CHAR | 5 |
| ZTERM | Terms of payment key | DZTERM | | CHAR | 4 |
| KUNRG | Payer | KUNRG | | 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 | Manual date | TEMAN | | CHAR | 1 |
| FAKCA | Calendar for Defining Days Relevant to Billing/Invoicing | FAKCA | | 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 | | CHAR | 10 |
| UELTR | Higher-level item in billing plan | UELTR | | NUMC | 6 |
| KURRF | Exchange rate for FI postings | KURRF | | DEC | 9 |
| CCACT | G/L Account Number for Payment Card Receivables | CCACT | | CHAR | 10 |
| KORTE | Indicator for correction date in billing plan | KORTE | | CHAR | 1 |
| OFKDAT | Baseline date for determining AFDAT | OFKDAT | | DATS | 8 |
| AD04FAREG | Rule for billing | AD04FAREG | | 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 VSFPLT_CN
Other References