SAP ABAP Table VFPLT (Billing Plan: Dates)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
     ⤷ VZ (Package) Application development R/3 RV central functions

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	VFPLT	Table Relationship Diagram
Short Description	Billing Plan: Dates

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	FPLNR	☑	FPLNR	FPLNR	CHAR	10	0	Billing plan number / invoicing plan number	*
3	FPLTR	☑	FPLTR	FPLTR	NUMC	6	0	Item for billing plan/invoice plan/payment cards	*
4	FPTTP	☐	FPTTP	FPTTP	CHAR	2	0	Date Category	TFPLT
5	TETXT	☐	TETXT_FP	TETXT	CHAR	4	0	Date description	TVTB
6	FKDAT	☐	BFDAT	DATUM	DATS	8	0	Settlement Date for Deadline
7	FPFIX	☐	FPFIX	FPFIX	CHAR	1	0	ID for adopting billing/invoice date
8	FAREG	☐	FAREG	FAREG	CHAR	1	0	Rule in billing plan/invoice plan
9	FPROZ	☐	FPROZ	PRZ32	DEC	5	2	Percentage of value to be billed
10	WAERS	☐	WAERS_CP	WAERS	CUKY	5	0	Currency Key of Credit Control Area	TCURC
11	KURFP	☐	KURFP	KURRF	DEC	9	5	Exchange rate for date in billing plan
12	FAKWR	☐	FAKWR	WERTV8	CURR	15	2	Value to be billed/calc. on date in billing/invoice plan
13	FAKSP	☐	FAKSP_FP	FAKSP	CHAR	2	0	Billing block for billing plan/invoice plan dates	TVFS
14	FKARV	☐	FKARA	FKART	CHAR	4	0	Proposed billing type for an order-related billing document	TVFK
15	FKSAF	☐	FKSAF	STATV	CHAR	1	0	Billing status for the billing plan/invoice plan date
16	PERIO	☐	PERIO_FP	VDREG_VEDA	CHAR	2	0	Rule for determining the next billing/invoice date	TVRG
17	FPLAE	☐	FPLAE	NUM3	NUMC	3	0	Length of a standard period in the billing plan
18	MLSTN	☐	MLST_ZAEHL	NUM12	NUMC	12	0	Number of milestone
19	MLBEZ	☐	MILESTONE	MILESTONE	CHAR	5	0	Usage	T433
20	ZTERM	☐	DZTERM	ZTERM	CHAR	4	0	Terms of payment key	TVZBT
21	KUNRG	☐	KUNRG	KUNNR	CHAR	10	0	Payer	KNA1
22	TAXK1	☐	TAXK1	TAXKD	CHAR	1	0	Tax classification 1 for customer	*
23	TAXK2	☐	TAXK2	TAXKD	CHAR	1	0	Tax classification 2 for customer	*
24	TAXK3	☐	TAXK3	TAXKD	CHAR	1	0	Tax classification 3 for customer	*
25	TAXK4	☐	TAXK4	TAXKD	CHAR	1	0	Tax classification 4 for customer	*
26	TAXK5	☐	TAXK5	TAXKD	CHAR	1	0	Tax classification 5 for customer	*
27	TAXK6	☐	TAXK6	TAXKD	CHAR	1	0	Tax classification 6 for customer	*
28	TAXK7	☐	TAXK7	TAXKD	CHAR	1	0	Tax classification 7 for customer	*
29	TAXK8	☐	TAXK8	TAXKD	CHAR	1	0	Tax classification 8 for customer	*
30	TAXK9	☐	TAXK9	TAXKD	CHAR	1	0	Tax classification 9 for customer	*
31	VALTG	☐	VALTG	TAGE2	NUMC	2	0	Additional value days
32	VALDT	☐	VALDT	DATUM	DATS	8	0	Fixed value date
33	NFDAT	☐	NFDAT	DATUM	DATS	8	0	Settlement date for deadline
34	TEMAN	☐	TEMAN_1	TEMAN	CHAR	1	0	Process as for manually entered date
35	FAKCA	☐	FAKCA	WFCID	CHAR	2	0	Calendar for defining days relevant for billing/invoicing	TFACD
36	AFDAT	☐	FKDAT	DATUM	DATS	8	0	Billing date for billing index and printout
37	NETWR	☐	NETWR_AP	WERTV8	CURR	15	2	Net value of the order item in document currency
38	NETPR	☐	NETPR	WERTV6	CURR	11	2	Net price
39	WAVWR	☐	WAVWR	WERTV7	CURR	13	2	Cost in document currency
40	KZWI1	☐	KZWI1	WERTV7	CURR	13	2	Subtotal 1 from pricing procedure for condition
41	KZWI2	☐	KZWI2	WERTV7	CURR	13	2	Subtotal 2 from pricing procedure for condition
42	KZWI3	☐	KZWI3	WERTV7	CURR	13	2	Subtotal 3 from pricing procedure for condition
43	KZWI4	☐	KZWI4	WERTV7	CURR	13	2	Subtotal 4 from pricing procedure for condition
44	KZWI5	☐	KZWI5	WERTV7	CURR	13	2	Subtotal 5 from pricing procedure for condition
45	KZWI6	☐	KZWI6	WERTV7	CURR	13	2	Subtotal 6 from pricing procedure for condition
46	CMPRE	☐	CMPRE	WERTV6	CURR	11	2	Item credit price
47	SKFBP	☐	SKFBT	WERT7	CURR	13	2	Amount Eligible for Cash Discount in Document Currency
48	BONBA	☐	BONBA	WERTV7	CURR	13	2	Rebate basis 1
49	PRSOK	☐	PRSOK	XFELD	CHAR	1	0	Pricing is OK
50	TYPZM	☐	TYPZM	TYPZM	CHAR	1	0	Means of payment for classifying payment card plan lines
51	CMPRE_FLT	☐	CMPRE_FLT	FLTP	FLTP	16	16	Item credit price
52	UELNR	☐	UELNR	FPLNR	CHAR	10	0	Higher-level payment card plan number for billing	FPLA
53	UELTR	☐	UELTR	FPLTR	NUMC	6	0	Higher-level item in billing plan	FPLT
54	KURRF	☐	KURRF	KURRF	DEC	9	5	Exchange rate for FI postings
55	CCACT	☐	CCACT	SAKNR	CHAR	10	0	G/L Account Number for Payment Card Receivables	SKA1
56	KORTE	☐	KORTE	KORTE	CHAR	1	0	Indicator for correction date in billing plan

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	VFPLT	CCACT	SKA1	SAKNR		1	CN
2	VFPLT	FAKCA	TFACD	IDENT
3	VFPLT	FAKSP	TVFS	FAKSP	REF	C	CN
4	VFPLT	FKARV	TVFK	FKART	REF	C	CN
5	VFPLT	FPTTP	TFPLT	FPTTP	REF	1	CN
6	VFPLT	KUNRG	KNA1	KUNNR	REF	C	CN
7	VFPLT	MANDT	T000	MANDT	KEY	1	CN
8	VFPLT	MLBEZ	T433	MLSTN	REF	C	CN
9	VFPLT	PERIO	TVRG	REGEL	REF	C	CN
10	VFPLT	TETXT	TVTB	TETBE	REF	1	CN
11	VFPLT	UELNR	FPLA	FPLNR	REF	1	CN
12	VFPLT	UELTR	FPLT	FPLTR	REF	1	CN
13	VFPLT	WAERS	TCURC	WAERS	REF	C	CN
14	VFPLT	ZTERM	TVZBT	ZTERM	REF	C	CN

History

Last changed by/on	SAP	20040210
SAP Release Created in