SAP FPLAPO Billing Plan Table data and field list

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

The FPLAPO table consists of various fields, each holding specific information or linking keys about Billing Plan data available in SAP. These include FPLNR (Billing plan number / invoicing plan number), FPTYP (Billing plan category), FPART (Billing/Invoicing Plan Type), SORTL (Sort field)... 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. .

FPLAPO 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: Not classified

SAP FPLAPO 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 FPLAPO 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
FPTYP	Billing plan category	FPTYP_FP	CHAR	1			FPTYP
FPART	Billing/Invoicing Plan Type	FPART	CHAR	2	TFPLA		FPART
SORTL	Sort field	SORTL	CHAR	10			CHAR10
BEDAT	Start date for billing plan/invoice plan	BEDAT_FP	DATS	8			DATUM
ENDAT	End date billing plan/invoice plan	ENDAT_FP	DATS	8			DATUM
HORIZ	Rule for Determining Horizon in Billing/Invoicing Plan	HORIZ_FP	CHAR	2	TVRG		VDREG_VEDA
VBELN	Sales and Distribution Document Number	VBELN	CHAR	10	VBUK	ALPHA	VBELN	AUN
BEDAR	Rule for Origin of Start Date of Billing/Invoicing Plan	BEDAT_FPK	CHAR	2	TVRG		VDREG_VEDA
ENDAR	Rule for Origin of End Date for Billing/Invoicing Plan	ENDAT_FPK	CHAR	2	TVRG		VDREG_VEDA
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
RFPLN	Standard Billing/Invoicing Plan Number	RFPLN_D	CHAR	10	FPLA		FPLNR
LODAT	Dates from	TADAT	DATS	8			DATUM
AUTTE	Billing/Invoice Creation in Advance	AUTTE	CHAR	1			XFELD
LODAR	Rule for Origin of Start Dates	LODAR	CHAR	2	TVRG		VDREG_VEDA
PERAF	Rule for Determination of a Deviating Billing/Invoice Date	PERAF_FP	CHAR	2	TVRG		VDREG_VEDA
FAKCA	Calendar for Defining Days Relevant to Billing/Invoicing	FAKCA	CHAR	2	TFACD		WFCID
TNDAT	Dates to	TBDAT	DATS	8			DATUM
TNDAR	Rule for Origin of End Dates	TBDAR	CHAR	2	TVRG		VDREG_VEDA
AUFPL	Routing number of operations in the order	CO_AUFPL	NUMC	10			AUFPL
APLZL	General counter for order	CO_APLZL	NUMC	8	Assigned to domain		CO_APLZL
RSNUM	Number of Reservation/Dependent Requirement	RSNUM	NUMC	10	Assigned to domain		RSNUM	RES
RSPOS	Item Number of Reservation/Dependent Requirement	RSPOS	NUMC	4			RSPOS	RPO
EBELN	Purchasing Document Number	EBELN	CHAR	10	EKKO	ALPHA	EBELN	BES	MEKK_C
FPLTU	Item unlimited in value	FPLTU	NUMC	6	Assigned to domain		FPLTR
AUST1	Payment cards: Status regarding requirements	AUST1_CC	CHAR	1			AUST1_CC
AUST2	Payment cards: Totals status - Call external system	AUST2_CC	CHAR	1			CCALL
AUST3	Payment cards: Overall status - Responses from ext. system	AUST3_CC	CHAR	1			REACT_SD
AUST4	Payment cards: Reserve	AUST4_CC	CHAR	1			CHAR1
AUST5	Payment cards: Authorization block	AUST5_CC	CHAR	1			XFELD
PSPNR	WBS Element	PS_POSNR	NUMC	8	Assigned to domain	ABPSP	PS_POSNR
AUTKOR	Automatic creation of correction dates in billing plan	AUTKOR	CHAR	1			XFELD

Key field

Non-key field

< FPLAD - Dynamic Part of the Billing Plan FPLAVB - Reference Structure for XFPLA/YFPLA >

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

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

SELECT SINGLE *
FROM FPLAPO
INTO CORRESPONDING FIELDS OF WA_FPLAPO
WHERE...

How to access SAP table FPLAPO

Within an ECC or HANA version of SAP you can also view further information about FPLAPO 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 FPLAPO

    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