SAP Table TFPLA
Billing Plan Type
TFPLA (Billing Plan Type) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.
Additionally we provide an overview of foreign key relationships, if any, that link TFPLA to other SAP tables.
TFPLA table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | Possible values | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
MANDT
Client
|
MANDT |
CLNT
|
3 | 0 | ||||||||||||||||||
|
FPART
Billing/Invoicing Plan Type
|
FPART |
CHAR
|
2 | 0 | ||||||||||||||||||
|
FPTYP
Billing plan category
|
FPTYP_FP |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
BEDAR
Rule for Origin of Start Date of Billing/Invoicing Plan
|
BEDAT_FPK | TVRG |
CHAR
|
2 | 0 | |||||||||||||||||
|
ENDAR
Rule for Origin of End Date for Billing/Invoicing Plan
|
ENDAT_FPK | TVRG |
CHAR
|
2 | 0 | |||||||||||||||||
|
HORIZ
Rule for Determining Horizon in Billing/Invoicing Plan
|
HORIZ_FP | TVRG |
CHAR
|
2 | 0 | |||||||||||||||||
|
AUTTD
Autom. Date Creation in Billing/Invoicing Plan Maintenance
|
AUTTD |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
AUTTE
Billing/Invoice Creation in Advance
|
AUTTE |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
PERIO
Rule for Origin of Next Billing/Invoice Date
|
PERIO_FP | TVRG |
CHAR
|
2 | 0 | |||||||||||||||||
|
FPLAE
Length of a standard period in the billing plan
|
FPLAE |
NUMC
|
3 | 0 | ||||||||||||||||||
|
FAREG
Rule in billing plan/invoice plan
|
FAREG |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
UEVOR
Default FCODE for overview screen of billing plan
|
UEVOR_FP |
CHAR
|
4 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
|
RFPLN
Standard Billing/Invoicing Plan Number
|
RFPLN_D |
CHAR
|
10 | 0 | ||||||||||||||||||
|
FAKCA
Calendar for Defining Days Relevant to Billing/Invoicing
|
FAKCA | TFACD |
CHAR
|
2 | 0 | |||||||||||||||||
|
VFPTT
Default Date Category
|
VFPTT | TFPLT |
CHAR
|
2 | 0 | |||||||||||||||||
|
LODAR
Rule for Origin of Start Dates
|
LODAR | TVRG |
CHAR
|
2 | 0 | |||||||||||||||||
|
PERAF
Rule for Determination of a Deviating Billing/Invoice Date
|
PERAF_FP | TVRG |
CHAR
|
2 | 0 | |||||||||||||||||
|
TBDAR
Rule for Origin of End Dates
|
TBDAR | TVRG |
CHAR
|
2 | 0 | |||||||||||||||||
|
ANZTM
Number of Days in the Month
|
ANZTM |
NUMC
|
3 | 0 | ||||||||||||||||||
|
ANZTJ
Number of Days in the Year
|
ANZTJ |
NUMC
|
3 | 0 | ||||||||||||||||||
|
AUTKOR
Automatic creation of correction dates in billing plan
|
AUTKOR |
CHAR
|
1 | 0 | ||||||||||||||||||
|
||||||||||||||||||||||
TFPLA foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field |
|---|---|---|---|---|---|
| TFPLA | BEDAR | TFPLA | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| TFPLA | BEDAR | TFPLA | BEDAR |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| TFPLA | ENDAR | TFPLA | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| TFPLA | ENDAR | TFPLA | ENDAR |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| TFPLA | FAKCA | TFPLA | FAKCA |
TFACD
Factory calendar definition
|
IDENT |
| TFPLA | HORIZ | TFPLA | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| TFPLA | HORIZ | TFPLA | HORIZ |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| TFPLA | LODAR | TFPLA | LODAR |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| TFPLA | LODAR | TFPLA | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| TFPLA | PERAF | TFPLA | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| TFPLA | PERAF | TFPLA | PERAF |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| TFPLA | PERIO | TFPLA | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| TFPLA | PERIO | TFPLA | PERIO |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| TFPLA | TBDAR | TFPLA | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| TFPLA | TBDAR | TFPLA | TBDAR |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| TFPLA | VFPTT | TFPLA | MANDT |
TFPLT
Date Type for Billing Plan Type
|
MANDT |
| TFPLA | VFPTT | TFPLA | FPART |
TFPLT
Date Type for Billing Plan Type
|
FPART |
| TFPLA | VFPTT | TFPLA | VFPTT |
TFPLT
Date Type for Billing Plan Type
|
FPTTP |