VFPLA SAP (Billing Plan) Table details

Dictionary Type: Table
Description: Billing Plan




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




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

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

The VFPLA 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. .

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 VFPLA 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
FPTYPBilling plan category FPTYP_FPCHAR1FPTYP
FPARTBilling/Invoicing Plan Type FPARTCHAR2TFPLAFPART
SORTLSort field SORTLCHAR10CHAR10
BEDATStart date for billing plan/invoice plan BEDAT_FPDATS8DATUM
ENDATEnd date billing plan/invoice plan ENDAT_FPDATS8DATUM
HORIZRule for Determining Horizon in Billing/Invoicing Plan HORIZ_FPCHAR2TVRGVDREG_VEDA
VBELNSales and Distribution Document Number VBELNCHAR10VBUKALPHAVBELNAUN
BEDARRule for Origin of Start Date of Billing/Invoicing Plan BEDAT_FPKCHAR2TVRGVDREG_VEDA
ENDARRule for Origin of End Date for Billing/Invoicing Plan ENDAT_FPKCHAR2TVRGVDREG_VEDA
PERIORule for Origin of Next Billing/Invoice Date PERIO_FPCHAR2TVRGVDREG_VEDA
FPLAELength of a standard period in the billing plan FPLAENUMC3NUM3
RFPLNStandard Billing/Invoicing Plan Number RFPLN_DCHAR10FPLAFPLNR
LODATDates from TADATDATS8DATUM
AUTTEBilling/Invoice Creation in Advance AUTTECHAR1XFELD
LODARRule for Origin of Start Dates LODARCHAR2TVRGVDREG_VEDA
PERAFRule for Determination of a Deviating Billing/Invoice Date PERAF_FPCHAR2TVRGVDREG_VEDA
FAKCACalendar for Defining Days Relevant to Billing/Invoicing FAKCACHAR2TFACDWFCID
TNDATDates to TBDATDATS8DATUM
TNDARRule for Origin of End Dates TBDARCHAR2TVRGVDREG_VEDA
AUFPLRouting number of operations in the order CO_AUFPLNUMC10AUFPL
APLZLGeneral counter for order CO_APLZLNUMC8Assigned to domainCO_APLZL
RSNUMNumber of Reservation/Dependent Requirement RSNUMNUMC10Assigned to domainRSNUMRES
RSPOSItem Number of Reservation/Dependent Requirement RSPOSNUMC4RSPOSRPO
EBELNPurchasing Document Number EBELNCHAR10EKKOALPHAEBELNBESMEKK_C
FPLTUItem unlimited in value FPLTUNUMC6Assigned to domainFPLTR
AUST1Payment cards: Status regarding requirements AUST1_CCCHAR1AUST1_CC
AUST2Payment cards: Totals status - Call external system AUST2_CCCHAR1CCALL
AUST3Payment cards: Overall status - Responses from ext. system AUST3_CCCHAR1REACT_SD
AUST4Payment cards: Reserve AUST4_CCCHAR1CHAR1
AUST5Payment cards: Authorization block AUST5_CCCHAR1XFELD
BASISWRTTarget value BASISWRTCURR15(2) WERTV8
PSPNRWBS Element PS_POSNRNUMC8Assigned to domainABPSPPS_POSNR
AUTKORAutomatic creation of correction dates in billing plan AUTKORCHAR1XFELD

Key field Non-key field



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

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

SELECT SINGLE *
FROM VFPLA
INTO CORRESPONDING FIELDS OF WA_VFPLA
WHERE...

How to access SAP table VFPLA

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