SAP table TFPLA (Billing Plan Type)

SAP table TFPLA has 2 primary key fields being MANDT,FPART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
FPART Billing/Invoicing Plan Type CHAR 2 0 FPART
FPTYP Billing plan category CHAR 1 0 FPTYP_FP
BPCAT Billing Plan Usage Category CHAR 2 0 SDBP_BPCAT
Legacy
1 Fixed Price
2 Time and Expenses
3 Periodic Service
4 Usage-Based Billing
BEDAR Rule for Origin of Start Date of Billing/Invoicing Plan CHAR 2 0 TVRG BEDAT_FPK
ENDAR Rule for Origin of End Date for Billing/Invoicing Plan CHAR 2 0 TVRG ENDAT_FPK
HORIZ Rule for Determining Horizon in Billing/Invoicing Plan CHAR 2 0 TVRG HORIZ_FP
AUTTD Autom. Date Creation in Billing/Invoicing Plan Maintenance CHAR 1 0 AUTTD
Deadlines not created automatically
X Deadlines created automatically
Y Created automatically w/o dialog box for manual milestones
AUTTE Billing/Invoice Creation in Advance CHAR 1 0 AUTTE
PERIO Rule for Origin of Next Billing/Invoice Date CHAR 2 0 TVRG PERIO_FP
FPLAE Length of a standard period in the billing plan NUMC 3 0 FPLAE
FAREG Rule in billing plan/invoice plan CHAR 1 0 FAREG
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 CHAR 4 0 UEVOR_FP
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 CHAR 10 0 RFPLN_D
FAKCA Calendar for Defining Days Relevant to Billing/Invoicing CHAR 2 0 TFACD FAKCA
VFPTT Default Date Category CHAR 2 0 TFPLT VFPTT
LODAR Rule for Origin of Start Dates CHAR 2 0 TVRG LODAR
PERAF Rule for Determination of a Deviating Billing/Invoice Date CHAR 2 0 TVRG PERAF_FP
TBDAR Rule for Origin of End Dates CHAR 2 0 TVRG TBDAR
ANZTM Number of Days in the Month NUMC 3 0 ANZTM
ANZTJ Number of Days in the Year NUMC 3 0 ANZTJ
AUTKOR Automatic creation of correction dates in billing plan CHAR 1 0 AUTKOR
DP_RLVT Down Payment Relevance CHAR 1 0 DP_RLVT
Not Relevant for Down Payment Processing
X Relevant for Down Payment Processing

TFPLA foreign key relationships

Table Field Check Table Check Field
0 TFPLA BEDAR TVRG Rule table for indirect date determination for contracts MANDT
0 TFPLA BEDAR TVRG Rule table for indirect date determination for contracts REGEL
1 TFPLA ENDAR TVRG Rule table for indirect date determination for contracts MANDT
1 TFPLA ENDAR TVRG Rule table for indirect date determination for contracts REGEL
0 TFPLA HORIZ TVRG Rule table for indirect date determination for contracts MANDT
0 TFPLA HORIZ TVRG Rule table for indirect date determination for contracts REGEL
1 TFPLA LODAR TVRG Rule table for indirect date determination for contracts MANDT
1 TFPLA LODAR TVRG Rule table for indirect date determination for contracts REGEL
0 TFPLA PERAF TVRG Rule table for indirect date determination for contracts MANDT
0 TFPLA PERAF TVRG Rule table for indirect date determination for contracts REGEL
1 TFPLA PERIO TVRG Rule table for indirect date determination for contracts MANDT
1 TFPLA PERIO TVRG Rule table for indirect date determination for contracts REGEL
0 TFPLA TBDAR TVRG Rule table for indirect date determination for contracts MANDT
0 TFPLA TBDAR TVRG Rule table for indirect date determination for contracts REGEL
1 TFPLA VFPTT TFPLT Date Type for Billing Plan Type MANDT
1 TFPLA VFPTT TFPLT Date Type for Billing Plan Type FPART
1 TFPLA VFPTT TFPLT Date Type for Billing Plan Type FPTTP