TFPLA SAP (Billing Plan Type) Table details
Dictionary Type: Table
Description: Billing Plan Type
Description: Billing Plan Type
Table field list including key, data, relationships and ABAP select examples
TFPLA is a standard SAP Table which is used to store Billing Plan Type data and is available within R/3 SAP systems depending on the version and release level.
The TFPLA table consists of various fields, each holding specific information or linking keys about Billing Plan Type data available in SAP. These include FPART (Billing/Invoicing Plan Type), FPTYP (Billing plan category), BEDAR (Rule for Origin of Start Date of Billing/Invoicing Plan), ENDAR (Rule for Origin of End Date for Billing/Invoicing Plan).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: G - Customising table which is protected against SAP UpdateDisplay/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type)
Text table = TFPLB
SAP TFPLA table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | Assigned to domain | MANDT | |||
| FPART | Billing/Invoicing Plan Type | FPART | CHAR | 2 | FPART | ||||
| FPTYP | Billing plan category | FPTYP_FP | CHAR | 1 | FPTYP | ||||
| BEDAR | Rule for Origin of Start Date of Billing/Invoicing Plan | BEDAT_FPK | CHAR | 2 | TVRG | VDREG_VEDA | |||
| ENDAR | Rule for Origin of End Date for Billing/Invoicing Plan | ENDAT_FPK | CHAR | 2 | TVRG | VDREG_VEDA | |||
| HORIZ | Rule for Determining Horizon in Billing/Invoicing Plan | HORIZ_FP | CHAR | 2 | TVRG | VDREG_VEDA | |||
| AUTTD | Autom. Date Creation in Billing/Invoicing Plan Maintenance | AUTTD | CHAR | 1 | AUTTD | ||||
| AUTTE | Billing/Invoice Creation in Advance | AUTTE | CHAR | 1 | XFELD | ||||
| PERIO | Rule for Origin of Next Billing/Invoice Date | PERIO_FP | CHAR | 2 | TVRG | VDREG_VEDA | |||
| FPLAE | Length of a standard period in the billing plan | FPLAE | NUMC | 3 | NUM3 | ||||
| FAREG | Rule in billing plan/invoice plan | FAREG | CHAR | 1 | FAREG | ||||
| UEVOR | Default FCODE for overview screen of billing plan | UEVOR_FP | CHAR | 4 | UEVOR_FP | ||||
| RFPLN | Standard Billing/Invoicing Plan Number | RFPLN_D | CHAR | 10 | Assigned to domain | FPLNR | |||
| FAKCA | Calendar for Defining Days Relevant to Billing/Invoicing | FAKCA | CHAR | 2 | TFACD | WFCID | |||
| VFPTT | Default Date Category | VFPTT | CHAR | 2 | TFPLT | FPTTP | |||
| LODAR | Rule for Origin of Start Dates | LODAR | CHAR | 2 | TVRG | VDREG_VEDA | |||
| PERAF | Rule for Determination of a Deviating Billing/Invoice Date | PERAF_FP | CHAR | 2 | TVRG | VDREG_VEDA | |||
| TBDAR | Rule for Origin of End Dates | TBDAR | CHAR | 2 | TVRG | VDREG_VEDA | |||
| ANZTM | Number of Days in the Month | ANZTM | NUMC | 3 | NUM03 | ||||
| ANZTJ | Number of Days in the Year | ANZTJ | NUMC | 3 | NUM03 | ||||
| AUTKOR | Automatic creation of correction dates in billing plan | AUTKOR | CHAR | 1 | XFELD |
| Key field | Non-key field |
How do I retrieve data from SAP table TFPLA using ABAP code
The following ABAP code Example will allow you to do a basic selection on TFPLA to SELECT all data from the tableDATA: WA_TFPLA TYPE TFPLA.
SELECT SINGLE *
FROM TFPLA
INTO CORRESPONDING FIELDS OF WA_TFPLA
WHERE...
How to access SAP table TFPLA
Within an ECC or HANA version of SAP you can also view further information about TFPLA and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects