SAP Tables | Sales and Distribution | Basic Functions(SD-BF) SAP SD

FPLT SAP Billing Plan: Dates Table







FPLT is a standard SAP Table which is used to store Billing Plan: Dates information. This is available within R/3 SAP systems depending on the version and release level.

Below is the standard documentation available and a few details of the fields which make up this Table. You can view further information about Table FPLT and the data within it using relevant SAP transactions such as SE11, SE80 or SE16. Also check out the Comments section below to view or add related contributions and example screen shots.

Delivery Class: A - Application table containing master and transaction data

Display/Maintenance via SM30: Yes but with Restrictions

Enhancement category i: Can be enhanced (character-type or numeric)

==>View Table relationships


Dictionary fields for SAP Table FPLT

FieldData ElementData Typelength (Decimals)ChecktableDescription
MANDTMANDTCLNT3 T000Client
FPLNRFPLNRCHAR10
*
Billing plan number / invoicing plan number
FPLTRFPLTRNUMC6 Item for billing plan/invoice plan/payment cards
FPTTPFPTTPCHAR2 TFPLTDate category
TETXTTETXT_FPCHAR4 TVTBDate description
FKDATBFDATDATS8 Settlement date for deadline
FPFIXFPFIXCHAR1 ID for adopting billing/invoice date
FAREGFAREGCHAR1 Rule in billing plan/invoice plan
FPROZFPROZDEC5(2) Percentage of value to be invoiced
WAERSWAERS_CPCUKY5 TCURCCurrency Key of Credit Control Area
KURFPKURFPDEC9(5) Exchange rate for date in billing plan
FAKWRFAKWRCURR15(2) Value to be billed/calc. on date in billing/invoice plan
FAKSPFAKSP_FPCHAR2 TVFSBilling block for billing plan/invoice plan dates
FKARVFKARACHAR4 TVFKProposed billing type for an order-related billing document
FKSAFFKSAFCHAR1 Billing status for the billing plan/invoice plan date
PERIOPERIO_FPCHAR2 TVRGRule for Origin of Next Billing/Invoice Date
FPLAEFPLAENUMC3 Length of a standard period in the billing plan
MLSTNMLST_ZAEHLNUMC12 Milestone number
MLBEZMILESTONECHAR5 T433Usage
ZTERMDZTERMCHAR4 Terms of Payment Key
KUNRGKUNRGCHAR10 KNA1Payer
TAXK1TAXK1CHAR1
*
Tax classification 1 for customer
TAXK2TAXK2CHAR1
*
Tax classification 2 for customer
TAXK3TAXK3CHAR1
*
Tax classification 3 for customer
TAXK4TAXK4CHAR1
*
Tax Classification 4 Customer
TAXK5TAXK5CHAR1
*
Tax classification 5 for customer
TAXK6TAXK6CHAR1
*
Tax classification 6 for customer
TAXK7TAXK7CHAR1
*
Tax classification 7 for customer
TAXK8TAXK8CHAR1
*
Tax classification 8 for customer
TAXK9TAXK9CHAR1
*
Tax classification 9 for customer
VALTGVALTGNUMC2 Additional value days
VALDTVALDTDATS8 Fixed value date
NFDATNFDATDATS8 Settlement date for deadline
TEMANTEMAN_1CHAR1 Process as for manually entered date
FAKCAFAKCACHAR2 TFACDCalendar for Defining Days Relevant to Billing/Invoicing
AFDATFKDATDATS8 Billing date for billing index and printout
NETWRNETWR_APCURR15(2) Net value of the order item in document currency
NETPRNETPRCURR11(2) Net price
WAVWRWAVWRCURR13(2) Cost in document currency
KZWI1KZWI1CURR13(2) Subtotal 1 from pricing procedure for condition
KZWI2KZWI2CURR13(2) Subtotal 2 from pricing procedure for condition
KZWI3KZWI3CURR13(2) Subtotal 3 from pricing procedure for condition
KZWI4KZWI4CURR13(2) Subtotal 4 from pricing procedure for condition
KZWI5KZWI5CURR13(2) Subtotal 5 from pricing procedure for condition
KZWI6KZWI6CURR13(2) Subtotal 6 from pricing procedure for condition
CMPRECMPRECURR11(2) Item credit price
SKFBPSKFBTCURR13(2) Amount Eligible for Cash Discount in Document Currency
BONBABONBACURR13(2) Rebate basis 1
PRSOKPRSOKCHAR1 Pricing is OK
TYPZMTYPZMCHAR1 Means of payment for classifying payment card plan lines
CMPRE_FLTCMPRE_FLTFLTP16(16) Item credit price
UELNRUELNRCHAR10 FPLAHigher-level payment card plan number for billing
UELTRUELTRNUMC6 FPLTHigher-level item in billing plan
KURRFKURRFDEC9(5) Exchange rate for FI postings
CCACTCCACTCHAR10 SKA1G/L Account Number for Payment Card Receivables
KORTEKORTECHAR1 Indicator for correction date in billing plan
OFKDATOFKDATDATS8 Baseline date for determining AFDAT
TEFOLTEFOLCHAR1 Billing plan: Date indicator through Subsequent Doc.
SHKZGSHKZG_VACHAR1 Returns Item
.APPENDAD04FPLT ########
AD04FAREGAD04FAREGCHAR1 Rule for billing
.APPENDAFM_PEROP_SD_FPLT Period of Performance
PEROP_BEGFM_PEROP_SD_LOWDATS8 Period of Performance Start Date
PEROP_ENDFM_PEROP_SD_HIGHDATS8 Period of Performance End Date


Key field
Non-key field


Relations between FPLT and other tables


EKKO-Purchasing Document Header
      EKPO-Purchasing Document Item
            EKBE-History per Purchasing Document
            EKBZ-History per Purchasing Document: Delivery Costs
            EKAB-Release (Order) Documentation
      EKKN-Account Assignment in Purchasing Document
      EKET-Scheduling Agreement Schedule Lines
      ESSR-Service Entry Sheet Header Data
      ESKN-Account Assignment in Service Package
      A019-Contract Header
      A016-Contract Item
      A068-Outline Agreement Item: Plant-Dependent
      KONM-Conditions (1-Dimensional Quantity Scale)
      KONW-Conditions (1-Dimensional Value Scale)
      KONP-Conditions (Item)
      KONH-Conditions (Header)
      KONV-Conditions (Transaction Data)
      STXH-STXD SAPscript Text File Header
            STXL-STXD SAPscript Text File Lines
      CDHDR-Change Document Header
            CDPOS-Change Document Items
      EIKP-Foreign Trade: Export/Import: Header Data
            EIPO-Foreign Trade: Export/Import: Item Data
      NAST-Message Status
      EKUB-Index for Stock Transport Orders for Material
      EKPV-SD-Specific Data f. Stock Transfer for Purch. Doc.
      RESB-Reservation/Dependent Requirements
      EKES-Vendor Confirmations
      EKPA-Partner Roles in Purchasing
      EKBEH-Order History, Scheduling Agreement (Reorganized)
      EKBZH-Delivery Costs History, Sched. Agreement (Reorg)
      EKETH-Scheduling Agreement Schedule Lines (Reorganized)
      EKEK-Scheduling Agreement Release History, Header
      EKEH-Scheduling Agreement Release History, Sched. Lines


ARKOPF-Archiving run header data
      VSKOPF-Version: Header - general data for a
            RSTHIE-BRST structure of the hierarchy table
                  PSDYRH-LDB PSJ: Dummy structure under RSTHIE
            PROJ-Project definition
                  PSDYPD-LDB PSJ: Dummy structure under PROJ
            VBAK-Sales Document: Header Data
                  VBUK-Sales Doc.: Header Status and Administrative Data
                  VBKD-Sales Document: Business Data
                  VBAP-Sales Document: Item Data
                        VBUP-Sales Document: Item Status
                        VBKDPO-Sales document: Business item data (POSNR > 0)
                              FPLA-Billing plan
                                    FPLT-Billing Plan: Dates
                        PSDYVB-LDB PSJ: Dummy structure under VBAP
                  PSDYVK-LDB PSJ: Dummy structure under VBAK
            PRPS_R-Project Hierarchy Reporting Structure
                  PRTE-Scheduling Data for Project Item
                  PSMLST-Milestone I/O Table
                  PSTX-PS Texts (Header)
                  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
                                    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
                                    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)
                  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
                        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
                                    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)
                                          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)
                        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
                                    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
                              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
                        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
                        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
                        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
                  PSMERK-Characteristics for summarization wo.classificatn
                  DRAD-Document-object link


VAKPA-vakpa
      VBAK-Sales Document: Header Data
            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
                  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


VAKPA-SD document: Indices
      VBUK-SD document: Header status and administration
            VBAK-Sales Document: Header 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
                  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
                              VBEP-Sales Document: Schedule Line Data
                              VBFA-Sales Document Flow
                              VBFAVG-Sales document: Cumulative records,followed by doc
                              KONV-Conditions (Transaction Data)