SAP VSFPLA_CN Version: Billing schedule Table
Overview
VSFPLA_CN is a standard SAP S/4HANA table that stores Version: Billing schedule data. There are total 36 fields in the VSFPLA_CN table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VSFPLA_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 VSFPLA_CN to other SAP tables and standard CDS views available based on VSFPLA_CN table in S/4HANA 2020.
Techincal Settings of VSFPLA_CN
Below are technical details of the table VSFPLA_CN
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VSFPLA_CN Fields
The following table gives you an overview of the fields available in VSFPLA_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 |
| FPTYP | Billing plan category | FPTYP_FP | CHAR | 1 | |
| FPART | Billing/Invoicing Plan Type | FPART | * | CHAR | 2 |
| SORTL | Sort field | SORTL | CHAR | 10 | |
| BEDAT | Start date for billing plan/invoice plan | BEDAT_FP | DATS | 8 | |
| ENDAT | End date billing plan/invoice plan | ENDAT_FP | DATS | 8 | |
| HORIZ | Rule for Determining Horizon in Billing/Invoicing Plan | HORIZ_FP | * | CHAR | 2 |
| VBELN | Sales and Distribution Document Number | VBELN | * | CHAR | 10 |
| BEDAR | Rule for Origin of Start Date of Billing/Invoicing Plan | BEDAT_FPK | * | CHAR | 2 |
| ENDAR | Rule for Origin of End Date for Billing/Invoicing Plan | ENDAT_FPK | * | CHAR | 2 |
| 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 | |
| RFPLN | Standard Billing/Invoicing Plan Number | RFPLN_D | * | CHAR | 10 |
| LODAT | Dates from | TADAT | DATS | 8 | |
| AUTTE | Billing/Invoice Creation in Advance | AUTTE | CHAR | 1 | |
| LODAR | Rule for Origin of Start Dates | LODAR | * | CHAR | 2 |
| PERAF | Rule for Determination of a Deviating Billing/Invoice Date | PERAF_FP | * | CHAR | 2 |
| FAKCA | Calendar for Defining Days Relevant to Billing/Invoicing | FAKCA | * | CHAR | 2 |
| TNDAT | Dates to | TBDAT | DATS | 8 | |
| TNDAR | Rule for Origin of End Dates | TBDAR | * | CHAR | 2 |
| AUFPL | Routing number of operations in the order | CO_AUFPL | NUMC | 10 | |
| APLZL | General counter for order | CO_APLZL | * | NUMC | 8 |
| RSNUM | Number of reservation/dependent requirements | RSNUM | * | NUMC | 10 |
| RSPOS | Item Number of Reservation / Dependent Requirements | RSPOS | NUMC | 4 | |
| EBELN | Purchasing Document Number | EBELN | * | CHAR | 10 |
| FPLTU | Item unlimited in value | FPLTU | * | NUMC | 6 |
| AUST1 | Payment Cards: Status Regarding Requirements | AUST1_CC | CHAR | 1 | |
| AUST2 | Payment Cards: Totals Status - Call External System | AUST2_CC | CHAR | 1 | |
| AUST3 | Payment cards: Overall status - Responses from ext. system | AUST3_CC | CHAR | 1 | |
| AUST4 | Payment cards: Reserve | AUST4_CC | CHAR | 1 | |
| AUST5 | Payment Cards: Authorization Block | AUST5_CC | CHAR | 1 | |
| BASISWRT | Target value | BASISWRT | CURR | 15 | |
| PSPNR | WBS Element | PS_POSNR | * | NUMC | 8 |
| AUTKOR | Automatic creation of correction dates in billing plan | AUTKOR | 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 VSFPLA_CN