SAP FPLT Billing Plan: Dates Table data and field list

FPLT is a standard SAP Table which is used to store Billing Plan: Dates data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The FPLT table consists of various fields, each holding specific information or linking keys about Billing Plan: Dates data available in SAP. These include FPLNR (Billing plan number / invoicing plan number), FPLTR (Item for billing plan/invoice plan/payment cards), FPTTP (Date category), TETXT (Date description)... 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. .

FPLT table Technical Details:

Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)

SAP FPLT table 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 FPLT 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	T000		MANDT
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			FPLTR
FPTTP	Date category	FPTTP	CHAR	2	TFPLT		FPTTP
TETXT	Date description	TETXT_FP	CHAR	4	TVTB		TETXT
FKDAT	Settlement date for deadline	BFDAT	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	TCURC		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	TVFS		FAKSP
FKARV	Proposed billing type for an order-related billing document	FKARA	CHAR	4	TVFK		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	TVRG		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	T433		MILESTONE
ZTERM	Terms of Payment Key	DZTERM	CHAR	4			ZTERM
KUNRG	Payer	KUNRG	CHAR	10	KNA1	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	Process as for manually entered date	TEMAN_1	CHAR	1			TEMAN
FAKCA	Calendar for Defining Days Relevant to Billing/Invoicing	FAKCA	CHAR	2	TFACD		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	FPLA		FPLNR
UELTR	Higher-level item in billing plan	UELTR	NUMC	6	FPLT		FPLTR
KURRF	Exchange rate for FI postings	KURRF	DEC	9(5)			KURRF
CCACT	G/L Account Number for Payment Card Receivables	CCACT	CHAR	10	SKA1	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
TEFOL	Billing plan: Date indicator through Subsequent Doc.	TEFOL	CHAR	1			XFELD
SHKZG	Returns Item	SHKZG_VA	CHAR	1			XFELD
.INCLU--AP				0
AD04FAREG	Rule for billing	AD04FAREG	CHAR	1			AD04FAREG
.INCLU--AP				0
PEROP_BEG	Period of Performance Start Date	FM_PEROP_SD_LOW	DATS	8			DATUM
PEROP_END	Period of Performance End Date	FM_PEROP_SD_HIGH	DATS	8			DATUM

Key field

Non-key field

< FPLOGMEM - Form Processing: LOG Structure for SHARED MEMORY FPLTC - Payment cards: Transaction data - SD >

How do I retrieve data from SAP table FPLT using ABAP code

The following ABAP code Example will allow you to do a basic selection on FPLT to SELECT all data from the table
DATA: WA_FPLT TYPE FPLT.

SELECT SINGLE *
FROM FPLT
INTO CORRESPONDING FIELDS OF WA_FPLT
WHERE...

How to access SAP table FPLT

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

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

Related SAP tables and the relationships to FPLT

    ARKOPF - Archiving run header data
        VSKOPF - Version: Header - general data for a
    VBUP - Sales Document: Item Status
    CKIP1 - Periodic Values for Unit Costing Item
    COSP1 - CO Object: Cost Totals for External Postings
        COVP11 - CO object: Line items with doc. header (by period)
            COEPD11 - CO object: Unvaluated ln. item settlement w/status
                COEPBR11 - CO Object: Valuated Line Item Settlement
        COVJ11 - CO object: Line items with doc header (by year)
        COVO1 - CO Object: Open Items for Line Items (w/o doc.Hdr)
    COSPD1 - CO object: External cost totals - calculated
    COSPP - Transfer of Order in the COSP Table to the Project
    COKS1 - CO Object: Control Data for Secondary Planning
    VBKDPO - Sales document: Business item data (POSNR > 0)
    HEAD13 - SAPscript: Text Header
        LINE13 - SAPscript: Text Lines
    COSS1 - CO Object: Cost Totals for Internal Postings
        COVP12 - CO object: Line items with doc. header (by period)
            COEPD12 - CO object: Unvaluated ln. item settlement w/status
                COEPBR12 - CO Object: Valuated Line Item Settlement
        COVJ12 - CO object: Line items with doc header (by year)
        COVO12 - CO object: Fxd price agreement commitment ln items
    COSSD1 - CO object: Internal cost totals - calculated
    COSSP - Transfer of the Order COSS Table to the Project
    FPLA - Billing plan
    COKR1 - CO Object: Control Data for Statistical Key Figs
        HEAD14 - SAPscript: Text Header
            LINE14 - SAPscript: Text Lines
    COSR1 - CO Object: Statistical Key Figure Totals
        COVPR1 - CO object: Stat. key figure line items by period
        COVJR1 - CO object: Line items stat. key figures (by year)
    COSL1 - CO Object: Activity Type Totals
        COVPL1 - CO object: Activity type line items by period
        COVJL1 - CO object: Line items for acty types (by year)
    COSLD - CO object: Activity type sums - calculated
    FPLT - Billing Plan: Dates
    COSB1 - CO Object: Total Variances/Results Analyses
        COVPB1 - CO object: Variance/accrual line items by period
    COSBD1 - CO object: Sums of variance/accrual - calculated
    ANIA1 - Depr. simulation for invest. projects
        ANIB1 - Invest. projects: Depr. simulation analysis report
    ANLI1 - Link table for capital investment measure -> AuC
    FMSU1 - FM totals records for financial data
        COVFP1 - CO object: Financial data line items with doc. hdr
    TPI031 - CO Objects: Date of Last Interest Run
    EKKO - Purchasing Document Header
    PSDYVB - LDB PSJ: Dummy structure under VBAP
    EKPO - Purchasing Document Item
        EKET - Scheduling Agreement Schedule Lines
        EKKN - Account Assignment in Purchasing Document
        EKBE - Purchasing Document History
    EBAN - Purchase requisition
        EBKN - Purchase Requisition Account Assignment
    FPLAPS - Billing plan for PSP network plan
        FPLTPS - Billing plan for PSP/network (dates)
    LIKP - SD Document: Delivery Header Data
        LIPS - SD document: Delivery: Item data
    PSDYVK - LDB PSJ: Dummy structure under VBAK
    PSMERK - Characteristics for summarization wo.classificatn
    DRAD - Document-object link
    PRPS_R - Project Hierarchy Reporting Structure
        PRTE - Scheduling Data for Project Item
        PSMLST - Milestone I/O Table
        PSTX - PS Texts (Header)
    RSTHIE - BRST structure of the hierarchy table
        PLAF - Planned order
        PSMERK_PRPS - Characteristics for Summarization for WBS Elements
    KBED04 - Capacity Requirement Recs for Planned Orders (LDB)
    RESB04 - Reservation/dependent reqs for plan order (LDB)
        PSDYPR - LDB PSJ: Dummy structure under PRPS_R
    AUFK - Order master data
        AFKO - Order Header Data PP Orders
            AFPO - Order Item
            AFFL - Work order sequence
                ACT01 - Activity for LDB 01
    PSDYRH - LDB PSJ: Dummy structure under RSTHIE
    AFAB01 - Network Relationship (for LDB) - 01
    MLSTD - Milestone I/O Table
    PSTX1 - PS Texts (Header) for Activity (1)
    AFFH01 - Order PRT Data (for LDB) - 01
    KBED01 - Capacity Requirement Records (for LDB) - 01
        KBEZ - Additional data for table KBED (for ind.req/split)
            KPER - Additional data for KBEZ (person split in days)
        AFRU02 - Order Confirmations (for LDB) -02
    RESB01 - Reservation/Dependent Requirement for LDB-01
        PSDYOK - LDB PSJ: Dummy structure under RESB01
    PROJ - Project definition
    AFRU01 - Order Confirmations (for LDB) - 01
    PSMERK_ACT - Charactersitics for Summarization for Activity
    PSDYNV - LDB PSJ: Dummy structure under ACT01
        AFIH - Maintenance order header
        PSDYNP - LDB PSJ: Dummy structure under AUFK
    IMTP - Investment programs
        IMPR - Investment Program Positions
            PSDYIP - LDB PSJ: Dummy structure under IMPR
        PSDYPG - LDB PSJ: Dummy structure under IMTP
    PEGOB - Peg (master data of the CO object)
    PSDYPD - LDB PSJ: Dummy structure under PROJ
    PEGQTY - Assigned pegging object quantities
    PSDYPEG - LDB PSJ: Dummy Structure Under PEGOB
    ELM_PS - Additional data for hierarchy nodes (LDB PSJ)
        JSTO - Status object information
            PSTAT - Condensed status display
            JCDO - Change Documents for Status Object (Table JSTO)
            JEST - Individual Status per Object
                JCDS - Change docs. for system/user status (table JEST)
        ONR00 - General Object Number
            RPSCO1 - Summarization Table for Project Reporting
    VBAK - Sales Document: Header Data
            RPSQT - Summarization table for project reporting (quants)
            EV_PARAM - Object parameters for earned value analysis
            EV_POC - Earned value analysis: percentage of completion
            EV_VAL - Earned value analysis: earned value
            COBRA - Settlement Rule for Order Settlement
                COBRB - Distribution rules for sett. rule for order sett.
            BPHI1 - Cross-hierarchy data Control
            BPTR1 - Object Data Control
                BPGE1 - Totals record total value Control
                    BPVG1 - Table Generated for View BPVG1
    VBUK - Sales Doc.: Header Status and Administrative Data
                    BKHS1 - Header - Unit Costing (Control + Totals)
                        HEAD10 - SAPscript: Text Header
                            LINE10 - SAPscript: Text Lines
                        BKHT1 - Texts for CKHS
                        BKIS1 - Individual calculation/verification item gen.
                            BKIT1 - Texts for CKIS
                        BKIP1 - Periodic Values for Unit Costing Item
                BPJA1 - Totals record for total year value Control
                    BPVJ1 - Table Generated for View BPVJ1
                    BKHS2 - Header - Unit Costing (Control + Totals)
    VBKD - Sales Document: Business Data
    HEAD20 - SAPscript: Text Header
        LINE20 - SAPscript: Text Lines
    BKHT2 - Texts for CKHS
    BKIS2 - Individual calculation/verification item gen.
        BKIT2 - Texts for CKIS
    BKIP2 - Periodic Values for Unit Costing Item
                BPPE1 - Totals Record for Period Values Control
                    BPVP1 - Table Generated for View BPVP1
                BPIG1 - Budget Object Index (Overall Budget)
                BPIJ1 - Budget Object Index (Annual Budget)
    VBAP - Sales Document: Item Data
            COKA1 - CO Object: Cost Element Control Data
            COKP1 - CO Object: Primary Planning Control Data
                HEAD11 - SAPscript: Text Header
                    LINE11 - SAPscript: Text Lines
                CKHS1 - Header - Unit Costing (Control + Totals)
                    CKHT1 - Texts for CKHS
                    HEAD12 - SAPscript: Text Header
                        LINE12 - SAPscript: Text Lines
                    CKIS1 - Individual calculation/verification item gen.
                        CKIT1 - Texts for CKIS

    VAKPA - vakpa
        VBAK - Sales Document: Header Data
    VBFAVG - Sales document: Cumulative records,followed by doc
    KONV - Conditions (Transaction Data)
    FPLT - SD document: Billing plan item
    VBUP - Sales Document: Item Status
    VEDAPO - SD document: Contract data item
        VBUK - SD document: Header status and administration
        VBKD - Sales Document: Business Data
        VEDA - SD document: Contract data header
        VFPLA - SD document: Billing plan header
            VFPLT - SD document: Billing plan item
    VBUV - SD document: Incompletion log
    VBPA - Sales Document: Partner
        VBADR - Address work area
    VBAP - Sales Document: Item Data
        VBKDPO - SD document: Business item data
        VBPAPO - Item partner for SD document
        VBEP - Sales Document: Schedule Line Data
        VBFA - Sales Document Flow

    VAKPA - SD document: Indices
        VBUK - SD document: Header status and administration
    VFPLA - SD document: Billing plan payment cards
        VFPLT - SD document: Billing plan payment cards
    VBUP - Sales Document: Item Status
        VBAP - Sales Document: Item Data
            VBKDPO - SD document: Business item data
                FPLAPO - SD document: Billing plan
                    FPLTPO - SD document: Billing plan dates
            VBPAPO - Item partner for SD document
                VBADRPO - Address work area
            VEDAPO - SD document: Contract data item
    VBAK - Sales Document: Header Data
            VBEP - Sales Document: Schedule Line Data
            VBFA - Sales Document Flow
            VBFAVG - Sales document: Cumulative records,followed by doc
            KONV - Conditions (Transaction Data)
    VBKD - Sales Document: Business Data
        FPLA - SD document: Billing plan
            FPLT - SD document: Billing plan dates
    VBUV - SD document: Incompletion log
    VBPA - SD document: Partner
        VBADR - Address work area
    VEDA - SD document: Contract data header