FPLT SAP (Billing Plan: Dates) Table details

Dictionary Type: Table
Description: Billing Plan: Dates




ABAP Code to SELECT data from FPLT
Related tables to FPLT
Access table FPLT




Table field list including key, data, relationships and ABAP select examples

FPLT is a standard SAP Table which is used to store Billing Plan: Dates data and is available within R/3 SAP systems 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. .

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

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
FPLNRBilling plan number / invoicing plan number FPLNRCHAR10Assigned to domainFPLNR
FPLTRItem for billing plan/invoice plan/payment cards FPLTRNUMC6FPLTR
FPTTPDate category FPTTPCHAR2TFPLTFPTTP
TETXTDate description TETXT_FPCHAR4TVTBTETXT
FKDATSettlement date for deadline BFDATDATS8DATUM
FPFIXID for adopting billing/invoice date FPFIXCHAR1FPFIX
FAREGRule in billing plan/invoice plan FAREGCHAR1FAREG
FPROZPercentage of value to be invoiced FPROZDEC5(2) PRZ32
WAERSCurrency Key of Credit Control Area WAERS_CPCUKY5TCURCWAERS
KURFPExchange rate for date in billing plan KURFPDEC9(5) KURRF
FAKWRValue to be billed/calc. on date in billing/invoice plan FAKWRCURR15(2) WERTV8
FAKSPBilling block for billing plan/invoice plan dates FAKSP_FPCHAR2TVFSFAKSP
FKARVProposed billing type for an order-related billing document FKARACHAR4TVFKFKART
FKSAFBilling status for the billing plan/invoice plan date FKSAFCHAR1STATV
PERIORule for Origin of Next Billing/Invoice Date PERIO_FPCHAR2TVRGVDREG_VEDA
FPLAELength of a standard period in the billing plan FPLAENUMC3NUM3
MLSTNMilestone number MLST_ZAEHLNUMC12NUM12
MLBEZUsage MILESTONECHAR5T433MILESTONE
ZTERMTerms of Payment Key DZTERMCHAR4ZTERM
KUNRGPayer KUNRGCHAR10KNA1ALPHAKUNNR
TAXK1Tax classification 1 for customer TAXK1CHAR1Assigned to domainTAXKD
TAXK2Tax classification 2 for customer TAXK2CHAR1Assigned to domainTAXKD
TAXK3Tax classification 3 for customer TAXK3CHAR1Assigned to domainTAXKD
TAXK4Tax Classification 4 Customer TAXK4CHAR1Assigned to domainTAXKD
TAXK5Tax classification 5 for customer TAXK5CHAR1Assigned to domainTAXKD
TAXK6Tax classification 6 for customer TAXK6CHAR1Assigned to domainTAXKD
TAXK7Tax classification 7 for customer TAXK7CHAR1Assigned to domainTAXKD
TAXK8Tax classification 8 for customer TAXK8CHAR1Assigned to domainTAXKD
TAXK9Tax classification 9 for customer TAXK9CHAR1Assigned to domainTAXKD
VALTGAdditional value days VALTGNUMC2TAGE2
VALDTFixed value date VALDTDATS8DATUM
NFDATSettlement date for deadline NFDATDATS8DATUM
TEMANProcess as for manually entered date TEMAN_1CHAR1TEMAN
FAKCACalendar for Defining Days Relevant to Billing/Invoicing FAKCACHAR2TFACDWFCID
AFDATBilling date for billing index and printout FKDATDATS8DATUM
NETWRNet value of the order item in document currency NETWR_APCURR15(2) WERTV8
NETPRNet price NETPRCURR11(2) WERTV6
WAVWRCost in document currency WAVWRCURR13(2) WERTV7
KZWI1Subtotal 1 from pricing procedure for condition KZWI1CURR13(2) WERTV7
KZWI2Subtotal 2 from pricing procedure for condition KZWI2CURR13(2) WERTV7
KZWI3Subtotal 3 from pricing procedure for condition KZWI3CURR13(2) WERTV7
KZWI4Subtotal 4 from pricing procedure for condition KZWI4CURR13(2) WERTV7
KZWI5Subtotal 5 from pricing procedure for condition KZWI5CURR13(2) WERTV7
KZWI6Subtotal 6 from pricing procedure for condition KZWI6CURR13(2) WERTV7
CMPREItem credit price CMPRECURR11(2) WERTV6
SKFBPAmount Eligible for Cash Discount in Document Currency SKFBTCURR13(2) WERT7
BONBARebate basis 1 BONBACURR13(2) WERTV7
PRSOKPricing is OK PRSOKCHAR1XFELD
TYPZMMeans of payment for classifying payment card plan lines TYPZMCHAR1TYPZM
CMPRE_FLTItem credit price CMPRE_FLTFLTP16(16) FLTP
UELNRHigher-level payment card plan number for billing UELNRCHAR10FPLAFPLNR
UELTRHigher-level item in billing plan UELTRNUMC6FPLTFPLTR
KURRFExchange rate for FI postings KURRFDEC9(5) KURRF
CCACTG/L Account Number for Payment Card Receivables CCACTCHAR10SKA1ALPHASAKNR
KORTEIndicator for correction date in billing plan KORTECHAR1KORTE
OFKDATBaseline date for determining AFDAT OFKDATDATS8DATUM
.INCLU--AP 0
TEFOLBilling plan: Date indicator through Subsequent Doc. TEFOLCHAR1XFELD
SHKZGReturns Item SHKZG_VACHAR1XFELD
.INCLU--AP 0
AD04FAREGRule for billing AD04FAREGCHAR1AD04FAREG
.INCLU--AP 0
PEROP_BEGPeriod of Performance Start Date FM_PEROP_SD_LOWDATS8DATUM
PEROP_ENDPeriod of Performance End Date FM_PEROP_SD_HIGHDATS8DATUM

Key field Non-key field



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).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!