SAP table TFPLT (Date Type for Billing Plan Type)
SAP table TFPLT has 3 primary key fields being MANDT,FPART,FPTTP.
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
T000
MANDT
FPART
Billing/Invoicing Plan Type
CHAR
2
0
TFPLA
FPART
FPTTP
Date category
CHAR
2
0
FPTTP
TETXT
Date Description
CHAR
4
0
TVTB
TETXT_FP
FPFIX
ID for adopting billing/invoice date
CHAR
1
0
FPFIX
Possible values
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
CHAR
1
0
FAREG
Possible values
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
CHAR
2
0
TVFS
FAKSP_FP
FKARV
Proposed billing type for an order-related billing document
CHAR
4
0
TVFK
FKARA
AUTTD
Autom. Date Creation in Billing/Invoicing Plan Maintenance
CHAR
1
0
AUTTD
Possible values
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
KSTEU
Pricing Type
CHAR
1
0
KNPRS
Possible values
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
A
Copy price elements and redetermine scales
B
Carry out new pricing
C
Copy manual price elements and redetermine the others
D
Copy price elements unchanged
E
Copy price elements and fix values
F
Copy price elements, turn value and fix
G
Copy price elements unchanged and redetermine taxes
H
Redetermine freight conditions
I
Redetermine rebate conditions
J
Redetermine confirmed purch. net price / value (KNTYP=d)
K
Copy price elements and cost. Redetermine taxes.
M
Copy price elements, turn value
N
Copy price elements unchanged, new cost
O
Redetermine variant conditions (KNTYP=O)
Q
Redetermine calculation conditions (KNTYP=Q)
R
Copy price elements and rebate conditions. Redetermine taxes
S
Ship & Debit (IBU HiTec)
U
Redetermine precious metal conditions (KNTYP=U)
X
Customer reserve X
Y
Customer reserve Y
Z
Customer reserve Z
TYPZM
Means of payment for classifying payment card plan lines
CHAR
1
0
TYPZM
Possible values
FAKSK
Block for correction date of billing plan/invoice plan
CHAR
2
0
TVFS
FAKSP_FPK
FKARK
Billing type for correction date of billing/invoice plan
CHAR
4
0
TVFK
FKARA_FPK
LIFSP
Default Delivery Block
CHAR
2
0
TVLS
LIFSP
BOMDLVGRP
Apply Delivery Blocks to BOMs
CHAR
1
0
BOMDLVGRP
Possible values
Not apply to BOMs
X
Apply to BOMs
TFPLT foreign key relationships
Table
Field
Check Table
Check Field
0 TFPLT
FAKSK
TVFS
Billing: Reasons for Blocking
FAKSP
1 TFPLT
FAKSP
TVFS
Billing: Reasons for Blocking
FAKSP
0 TFPLT
FKARK
TVFK
Billing: Document Types
MANDT
0 TFPLT
FKARK
TVFK
Billing: Document Types
FKART
1 TFPLT
FKARV
TVFK
Billing: Document Types
MANDT
1 TFPLT
FKARV
TVFK
Billing: Document Types
FKART
0 TFPLT
FPART
TFPLA
Billing Plan Type
FPART
1 TFPLT
LIFSP
TVLS
Deliveries: Blocking Reasons/Criteria
MANDT
1 TFPLT
LIFSP
TVLS
Deliveries: Blocking Reasons/Criteria
LIFSP
0 TFPLT
PERIO
TVRG
Rule table for indirect date determination for contracts
MANDT
0 TFPLT
PERIO
TVRG
Rule table for indirect date determination for contracts
REGEL
1 TFPLT
TETXT
TVTB
Billing Plan: Date Description
TETBE