1. Home
  2. Resources
  3. SAP Tables
  4. TFPLA - Billing Plan Type

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
MANDT Client MANDT CLNT 3 0
FPART Billing/Invoicing Plan Type FPART CHAR 2 0
FPTYP Billing plan category FPTYP_FP CHAR 1 0
0 Billing plan in SD
1 Installment plan (payment by installments, payment cards)
2 Billing plan in PS
A Invoice plan PS
B Invoice plan in Purchasing
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
NULL Deadlines not created automatically
X Deadlines created automatically
Y Created automatically w/o dialog box for manual milestones
AUTTE Billing/Invoice Creation in Advance AUTTE CHAR 1 0
X Yes
NULL No
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
1 Milestone billing on a percentage basis
2 Milestone billing on a value basis
3 Closing invoice in milestone billing
4 Down payment in milestone billing on percentage basis
5 Down payment in milestone billing on a value basis
6 Periodic billing (rent)
UEVOR Default FCODE for overview screen of billing plan UEVOR_FP CHAR 4 0
0001 Advance periodic billing
0002 Retrospective periodic billing
0003 Milestone billing
0004 Payment card (installment plan)
0010 Invoice plan PS
0030 Invoice plan for purchase item
0040 Billing plan PS
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
X Yes
NULL No

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 MANDT TVRG Rule table for indirect date determination for contracts MANDT
TFPLA LODAR TFPLA LODAR TVRG Rule table for indirect date determination for contracts REGEL
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 PERIO 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 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