SAP Table TFPLT

Date Type for Billing Plan Type

TFPLT (Date Type for 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 TFPLT to other SAP tables.

TFPLT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FPART Billing/Invoicing Plan Type FPART TFPLA CHAR 2 0
FPTTP Date category FPTTP CHAR 2 0
TETXT Date description TETXT_FP TVTB CHAR 4 0
FPFIX ID for adopting billing/invoice date FPFIX CHAR 1 0
NULL Assignment to milestones not possible
0 Fixed date, date not copied from milestone
1 Planned/actual date from milestone
2 Planned/actual date from milestone if before billing date
3 Planned/actual date from milestone if after billing date
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)
FAKSP Billing block for billing plan/invoice plan dates FAKSP_FP TVFS CHAR 2 0
FKARV Proposed billing type for an order-related billing document FKARA TVFK CHAR 4 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
KSTEU Pricing type KNPRS CHAR 1 0
A Copy price components and redetermine scales
B Carry out new pricing
C Copy manual pricing elements and redetermine the others
D Copy pricing elements unchanged
E Adopt price components and fix values
F Copy pricing elements, turn value and fix
G Copy pricing elements unchanged and redetermine taxes
H Redetermine freight conditions
I Redetermine rebate conditions
J Redetermine confirmed purch. net price / value (KNTYP=d)
K Adopt price components and cose. Redetermine taxes.
M Copy pricing elements, turn value
N Transfer pricing components unchanged, new cost
O Redetermine variant conditions (KNTYP=O)
Q Redetermine calculation conditions (KNTYP=Q)
R Apply Price Parts and Bonus Conditions
U Redetermine precious metal conditions (KNTYP=U)
X Customer reserve X
Y Customer reserve Y
Z Customer reserve Z
1 Customer reserve 1
2 Customer reserve 2
3 Customer reserve 3
4 Customer reserve 4
5 Customer reserve 5
6 Customer reserve 6
7 Customer reserve 7
8 Customer reserve 8
9 Customer reserve 9
S Ship & Debit (IBU HiTec)
TYPZM Means of payment for classifying payment card plan lines TYPZM CHAR 1 0
0 Payment card
FAKSK Block for correction date of billing plan/invoice plan FAKSP_FPK TVFS CHAR 2 0
FKARK Billing type for correction date of billing/invoice plan FKARA_FPK TVFK CHAR 4 0

TFPLT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
TFPLT FAKSK TFPLT FAKSK TVFS Billing: Reasons for Blocking FAKSP
TFPLT FAKSK TFPLT MANDT TVFS Billing: Reasons for Blocking MANDT
TFPLT FAKSP TFPLT MANDT TVFS Billing: Reasons for Blocking MANDT
TFPLT FAKSP TFPLT FAKSP TVFS Billing: Reasons for Blocking FAKSP
TFPLT FKARK TFPLT MANDT TVFK Billing: Document Types MANDT
TFPLT FKARK TFPLT FKARK TVFK Billing: Document Types FKART
TFPLT FKARV TFPLT MANDT TVFK Billing: Document Types MANDT
TFPLT FKARV TFPLT FKARV TVFK Billing: Document Types FKART
TFPLT FPART TFPLT MANDT TFPLA Billing Plan Type MANDT
TFPLT FPART TFPLT FPART TFPLA Billing Plan Type FPART
TFPLT MANDT TFPLT MANDT T000 Clients MANDT
TFPLT PERIO TFPLT MANDT TVRG Rule table for indirect date determination for contracts MANDT
TFPLT PERIO TFPLT PERIO TVRG Rule table for indirect date determination for contracts REGEL
TFPLT TETXT TFPLT TETXT TVTB Billing Plan: Date Description TETBE
TFPLT TETXT TFPLT MANDT TVTB Billing Plan: Date Description MANDT