SAP VFPLA Billing Plan Table
Overview
VFPLA is a standard SAP S/4HANA table that stores Billing Plan data. There are total 36 fields in the VFPLA table. The following is a list of the fields that make up this table. Key fields are marked in blue.
The table VFPLA 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 VFPLA to other SAP tables and standard CDS views available based on VFPLA table in S/4HANA 2020.
Techincal Settings of VFPLA
Below are technical details of the table VFPLA
- Buffering not allowed
- No buffering
- Storage type is Column Store
List of VFPLA Fields
The following table gives you an overview of the fields available in VFPLA
| 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 |
| FPTYP | Billing plan category | FPTYP_FP | CHAR | 1 | |
| BPCAT | Billing Plan Usage Category | SDBP_BPCAT | CHAR | 2 | |
| FPART | Billing/Invoicing Plan Type | FPART | TFPLA | 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 | TVRG | CHAR | 2 |
| VBELN | Sales and Distribution Document Number | VBELN | * | CHAR | 10 |
| BEDAR | Rule for Origin of Start Date of Billing/Invoicing Plan | BEDAT_FPK | TVRG | CHAR | 2 |
| ENDAR | Rule for Origin of End Date for Billing/Invoicing Plan | ENDAT_FPK | TVRG | CHAR | 2 |
| 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 | |
| RFPLN | Standard Billing/Invoicing Plan Number | RFPLN_D | FPLA | 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 | TVRG | CHAR | 2 |
| PERAF | Rule for Determination of a Deviating Billing/Invoice Date | PERAF_FP | TVRG | CHAR | 2 |
| FAKCA | Calendar for Defining Days Relevant to Billing/Invoicing | FAKCA | TFACD | CHAR | 2 |
| TNDAT | Dates to | TBDAT | DATS | 8 | |
| TNDAR | Rule for Origin of End Dates | TBDAR | TVRG | 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 | EKKO | 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 VFPLA
| Table Name | Field | Cardinality | Check Table |
|---|---|---|---|
| VFPLA | BEDAR | : | TVRG |
| VFPLA | EBELN | 1: CN | EKKO |
| VFPLA | ENDAR | : | TVRG |
| VFPLA | FAKCA | C: CN | TFACD |
| VFPLA | FPART | 1: CN | TFPLA |
| VFPLA | HORIZ | C: CN | TVRG |
| VFPLA | LODAR | C: CN | TVRG |
| VFPLA | MANDT | 1: CN | T000 |
| VFPLA | PERAF | C: CN | TVRG |
| VFPLA | PERIO | : | TVRG |
| VFPLA | RFPLN | : | FPLA |
| VFPLA | TNDAR | C: CN | TVRG |