SAP VSFPLTB Versions: Doc. table structure for VSFPLT_CN Table data and field list

VSFPLTB is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Versions: Doc. table structure for VSFPLT_CN" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_VSFPLTB TYPE VSFPLTB.

The VSFPLTB table consists of various fields, each holding specific information or linking keys about Versions: Doc. table structure for VSFPLT_CN data available in SAP. These include MANDT (Client), VSNMR (Number or description of a version), FPLNR (Billing plan number / invoicing plan number), FPLTR (Item for billing plan/invoice plan/payment cards)... See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

VSFPLTB structure Technical Details:

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified

SAP VSFPLTB structure fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the VSFPLTB table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.

Field	Description	Data Element	Data Type	length (Dec)	Check table	Conversion Routine	Domain Name	MemoryID	SHLP
MANDT	Client	MANDT	CLNT	3	Assigned to domain		MANDT
VSNMR	Number or description of a version	VSNMR	CHAR	12			VSNMR	VS2
FPLNR	Billing plan number / invoicing plan number	FPLNR	CHAR	10	Assigned to domain		FPLNR
FPLTR	Item for billing plan/invoice plan/payment cards	FPLTR	NUMC	6	Assigned to domain		FPLTR
FPTTP	Date category	FPTTP	CHAR	2	Assigned to domain		FPTTP
TETXT	Date description	TETXT_FP	CHAR	4	Assigned to domain		TETXT
FKDAT	Billing date for billing index and printout	FKDAT	DATS	8			DATUM
FPFIX	ID for adopting billing/invoice date	FPFIX	CHAR	1			FPFIX
FAREG	Rule in billing plan/invoice plan	FAREG	CHAR	1			FAREG
FPROZ	Percentage of value to be invoiced	FPROZ	DEC	5(2)			PRZ32
WAERS	Currency Key of Credit Control Area	WAERS_CP	CUKY	5	Assigned to domain		WAERS
KURFP	Exchange rate for date in billing plan	KURFP	DEC	9(5)			KURRF
FAKWR	Value to be billed/calc. on date in billing/invoice plan	FAKWR	CURR	15(2)			WERTV8
FAKSP	Billing block for billing plan/invoice plan dates	FAKSP_FP	CHAR	2	Assigned to domain		FAKSP
FKARV	Proposed billing type for a delivery-related billing doc.	FKARV	CHAR	4	Assigned to domain		FKART
FKSAF	Billing status for the billing plan/invoice plan date	FKSAF	CHAR	1			STATV
PERIO	Rule for Origin of Next Billing/Invoice Date	PERIO_FP	CHAR	2	Assigned to domain		VDREG_VEDA
FPLAE	Length of a standard period in the billing plan	FPLAE	NUMC	3			NUM3
MLSTN	Milestone number	MLST_ZAEHL	NUMC	12			NUM12
MLBEZ	Usage	MILESTONE	CHAR	5	Assigned to domain		MILESTONE
ZTERM	Terms of Payment Key	DZTERM	CHAR	4			ZTERM
KUNRG	Payer	KUNRG	CHAR	10	Assigned to domain	ALPHA	KUNNR
TAXK1	Tax classification 1 for customer	TAXK1	CHAR	1	Assigned to domain		TAXKD
TAXK2	Tax classification 2 for customer	TAXK2	CHAR	1	Assigned to domain		TAXKD
TAXK3	Tax classification 3 for customer	TAXK3	CHAR	1	Assigned to domain		TAXKD
TAXK4	Tax Classification 4 Customer	TAXK4	CHAR	1	Assigned to domain		TAXKD
TAXK5	Tax classification 5 for customer	TAXK5	CHAR	1	Assigned to domain		TAXKD
TAXK6	Tax classification 6 for customer	TAXK6	CHAR	1	Assigned to domain		TAXKD
TAXK7	Tax classification 7 for customer	TAXK7	CHAR	1	Assigned to domain		TAXKD
TAXK8	Tax classification 8 for customer	TAXK8	CHAR	1	Assigned to domain		TAXKD
TAXK9	Tax classification 9 for customer	TAXK9	CHAR	1	Assigned to domain		TAXKD
VALTG	Additional value days	VALTG	NUMC	2			TAGE2
VALDT	Fixed value date	VALDT	DATS	8			DATUM
NFDAT	Settlement date for deadline	NFDAT	DATS	8			DATUM
TEMAN	Manual date	TEMAN	CHAR	1			XFELD
FAKCA	Calendar for Defining Days Relevant to Billing/Invoicing	FAKCA	CHAR	2	Assigned to domain		WFCID
AFDAT	Billing date for billing index and printout	FKDAT	DATS	8			DATUM
NETWR	Net value of the order item in document currency	NETWR_AP	CURR	15(2)			WERTV8
NETPR	Net price	NETPR	CURR	11(2)			WERTV6
WAVWR	Cost in document currency	WAVWR	CURR	13(2)			WERTV7
KZWI1	Subtotal 1 from pricing procedure for condition	KZWI1	CURR	13(2)			WERTV7
KZWI2	Subtotal 2 from pricing procedure for condition	KZWI2	CURR	13(2)			WERTV7
KZWI3	Subtotal 3 from pricing procedure for condition	KZWI3	CURR	13(2)			WERTV7
KZWI4	Subtotal 4 from pricing procedure for condition	KZWI4	CURR	13(2)			WERTV7
KZWI5	Subtotal 5 from pricing procedure for condition	KZWI5	CURR	13(2)			WERTV7
KZWI6	Subtotal 6 from pricing procedure for condition	KZWI6	CURR	13(2)			WERTV7
CMPRE	Item credit price	CMPRE	CURR	11(2)			WERTV6
SKFBP	Amount Eligible for Cash Discount in Document Currency	SKFBT	CURR	13(2)			WERT7
BONBA	Rebate basis 1	BONBA	CURR	13(2)			WERTV7
PRSOK	Pricing is OK	PRSOK	CHAR	1			XFELD
TYPZM	Means of payment for classifying payment card plan lines	TYPZM	CHAR	1			TYPZM
CMPRE_FLT	Item credit price	CMPRE_FLT	FLTP	16(16)			FLTP
UELNR	Higher-level payment card plan number for billing	UELNR	CHAR	10	Assigned to domain		FPLNR
UELTR	Higher-level item in billing plan	UELTR	NUMC	6	Assigned to domain		FPLTR
KURRF	Exchange rate for FI postings	KURRF	DEC	9(5)			KURRF
CCACT	G/L Account Number for Payment Card Receivables	CCACT	CHAR	10	Assigned to domain	ALPHA	SAKNR
KORTE	Indicator for correction date in billing plan	KORTE	CHAR	1			KORTE
OFKDAT	Baseline date for determining AFDAT	OFKDAT	DATS	8			DATUM
.INCLU--AP				0
AD04FAREG	Rule for billing	AD04FAREG	CHAR	1			AD04FAREG
VBUKZ	Update indicator	VBKZ	CHAR	1			VERBUCHER

Key field

Non-key field

< VSFPLA_CN - Version: Billing schedule VSFPLT_CN - Version: Billing schedule: Dates >

How do I retrieve data from SAP structure VSFPLTB using ABAP code?

As VSFPLTB is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on VSFPLTB as there is no data to select.

How to access SAP table VSFPLTB

Within an ECC or HANA version of SAP you can also view further information about VSFPLTB and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).