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

FPLA SAP Billing Plan Table and data







FPLA is a standard SAP Table which is used to store Billing Plan data and 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 SAP FPLA Table and the data within it using relevant 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)
See here for more information about this and other SAP enhancement categories

==>View Table relationships


SAP FPLA Table fields within data Dictionary





FieldData ElementData Typelength (Decimals)Check tableDescriptionConversion Routine
MANDTMANDTCLNT3 T000Client
FPLNRFPLNRCHAR10 Billing plan number / invoicing plan number
FPTYPFPTYP_FPCHAR1 Billing plan category
FPARTFPARTCHAR2 TFPLABilling/Invoicing Plan Type
SORTLSORTLCHAR10 Sort field
BEDATBEDAT_FPDATS8 Start date for billing plan/invoice plan
ENDATENDAT_FPDATS8 End date billing plan/invoice plan
HORIZHORIZ_FPCHAR2 TVRGRule for Determining Horizon in Billing/Invoicing Plan
VBELNVBELNCHAR10 VBUKSales and Distribution Document NumberALPHA
BEDARBEDAT_FPKCHAR2 TVRGRule for Origin of Start Date of Billing/Invoicing Plan
ENDARENDAT_FPKCHAR2 TVRGRule for Origin of End Date for Billing/Invoicing Plan
PERIOPERIO_FPCHAR2 TVRGRule for Origin of Next Billing/Invoice Date
FPLAEFPLAENUMC3 Length of a standard period in the billing plan
RFPLNRFPLN_DCHAR10 FPLAStandard Billing/Invoicing Plan Number
LODATTADATDATS8 Dates from
AUTTEAUTTECHAR1 Billing/Invoice Creation in Advance
LODARLODARCHAR2 TVRGRule for Origin of Start Dates
PERAFPERAF_FPCHAR2 TVRGRule for Determination of a Deviating Billing/Invoice Date
FAKCAFAKCACHAR2 TFACDCalendar for Defining Days Relevant to Billing/Invoicing
TNDATTBDATDATS8 Dates to
TNDARTBDARCHAR2 TVRGRule for Origin of End Dates
AUFPLCO_AUFPLNUMC10 Routing number of operations in the order
APLZLCO_APLZLNUMC8
*
General counter for order
RSNUMRSNUMNUMC10
*
Number of Reservation/Dependent Requirement
RSPOSRSPOSNUMC4 Item Number of Reservation/Dependent Requirement
EBELNEBELNCHAR10 EKKOPurchasing Document NumberALPHA
FPLTUFPLTUNUMC6
*
Item unlimited in value
AUST1AUST1_CCCHAR1 Payment cards: Status regarding requirements
AUST2AUST2_CCCHAR1 Payment cards: Totals status - Call external system
AUST3AUST3_CCCHAR1 Payment cards: Overall status - Responses from ext. system
AUST4AUST4_CCCHAR1 Payment cards: Reserve
AUST5AUST5_CCCHAR1 Payment cards: Authorization block
BASISWRTBASISWRTCURR15(2) Target value
PSPNRPS_POSNRNUMC8
*
WBS ElementABPSP
AUTKORAUTKORCHAR1 Automatic creation of correction dates in billing plan
.APPEND/SAPHT/SW_FPLA_SD 高技术扩展 FPLA
SUPLN/SAPHT/SW_SUPLNCHAR10
*
Subsequent billing plan number
SYNCH/SAPHT/SW_SYNCHCHAR1 Billing plan automatic synchronization indicator
KUDAT/SAPHT/SW_KUDAT_FPDATS8 Cancellation date billing plan


KUDAR/SAPHT/SW_KUDAT_FPKCHAR2 TVRGRule for origin of billing plan cancellation date



Key field
Non-key field

FPLA relationships with 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-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)