SAP Table FPLA

Billing Plan

FPLA (Billing Plan) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link FPLA to other SAP tables.

FPLA table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
FPLNR Billing plan number / invoicing plan number FPLNR CHAR 10 0
FPTYP Billing plan category FPTYP_FP CHAR 1 0
0 Billing plan in SD
1 Installment plan (payment by installments, payment cards)
2 Billing plan in PS
A Invoice plan PS
B Invoice plan in Purchasing
FPART Billing/Invoicing Plan Type FPART TFPLA CHAR 2 0
SORTL Sort field SORTL CHAR 10 0
BEDAT Start date for billing plan/invoice plan BEDAT_FP DATS 8 0
ENDAT End date billing plan/invoice plan ENDAT_FP DATS 8 0
HORIZ Rule for Determining Horizon in Billing/Invoicing Plan HORIZ_FP TVRG CHAR 2 0
VBELN Sales and Distribution Document Number VBELN VBUK CHAR 10 0
BEDAR Rule for Origin of Start Date of Billing/Invoicing Plan BEDAT_FPK TVRG CHAR 2 0
ENDAR Rule for Origin of End Date for Billing/Invoicing Plan ENDAT_FPK TVRG CHAR 2 0
PERIO Rule for Origin of Next Billing/Invoice Date PERIO_FP TVRG CHAR 2 0
FPLAE Length of a standard period in the billing plan FPLAE NUMC 3 0
RFPLN Standard Billing/Invoicing Plan Number RFPLN_D FPLA CHAR 10 0
LODAT Dates from TADAT DATS 8 0
AUTTE Billing/Invoice Creation in Advance AUTTE CHAR 1 0
X Yes
NULL No
LODAR Rule for Origin of Start Dates LODAR TVRG CHAR 2 0
PERAF Rule for Determination of a Deviating Billing/Invoice Date PERAF_FP TVRG CHAR 2 0
FAKCA Calendar for Defining Days Relevant to Billing/Invoicing FAKCA TFACD CHAR 2 0
TNDAT Dates to TBDAT DATS 8 0
TNDAR Rule for Origin of End Dates TBDAR TVRG CHAR 2 0
AUFPL Routing number of operations in the order CO_AUFPL NUMC 10 0
APLZL General counter for order CO_APLZL NUMC 8 0
RSNUM Number of Reservation/Dependent Requirement RSNUM NUMC 10 0
RSPOS Item Number of Reservation/Dependent Requirement RSPOS NUMC 4 0
EBELN Purchasing Document Number EBELN EKKO CHAR 10 0
FPLTU Item unlimited in value FPLTU NUMC 6 0
AUST1 Payment cards: Status regarding requirements AUST1_CC CHAR 1 0
NULL Not Relevant
A Requirement not met
B Requirement met
AUST2 Payment cards: Totals status - Call external system AUST2_CC CHAR 1 0
NULL Not Relevant
A External system not reached
B External system reached: no response
C External system reached: response received
AUST3 Payment cards: Overall status - Responses from ext. system AUST3_CC CHAR 1 0
NULL Not Relevant
A Checks successful
B Unsuccessful: authorize later
C Unsuccessful: set authorization lock
AUST4 Payment cards: Reserve AUST4_CC CHAR 1 0
AUST5 Payment cards: Authorization block AUST5_CC CHAR 1 0
X Yes
NULL No
BASISWRT Target value BASISWRT CURR 15 2
PSPNR WBS Element PS_POSNR NUMC 8 0
AUTKOR Automatic creation of correction dates in billing plan AUTKOR CHAR 1 0
X Yes
NULL No

FPLA foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
FPLA BEDAR FPLA MANDT TVRG Rule table for indirect date determination for contracts MANDT
FPLA BEDAR FPLA BEDAR TVRG Rule table for indirect date determination for contracts REGEL
FPLA EBELN FPLA MANDT EKKO Purchasing Document Header MANDT
FPLA EBELN FPLA EBELN EKKO Purchasing Document Header EBELN
FPLA ENDAR FPLA MANDT TVRG Rule table for indirect date determination for contracts MANDT
FPLA ENDAR FPLA ENDAR TVRG Rule table for indirect date determination for contracts REGEL
FPLA FAKCA FPLA FAKCA TFACD Factory calendar definition IDENT
FPLA FPART FPLA MANDT TFPLA Billing Plan Type MANDT
FPLA FPART FPLA FPART TFPLA Billing Plan Type FPART
FPLA HORIZ FPLA MANDT TVRG Rule table for indirect date determination for contracts MANDT
FPLA HORIZ FPLA HORIZ TVRG Rule table for indirect date determination for contracts REGEL
FPLA LODAR FPLA MANDT TVRG Rule table for indirect date determination for contracts MANDT
FPLA LODAR FPLA LODAR TVRG Rule table for indirect date determination for contracts REGEL
FPLA MANDT FPLA MANDT T000 Clients MANDT
FPLA PERAF FPLA MANDT TVRG Rule table for indirect date determination for contracts MANDT
FPLA PERAF FPLA PERAF TVRG Rule table for indirect date determination for contracts REGEL
FPLA PERIO FPLA PERIO TVRG Rule table for indirect date determination for contracts REGEL
FPLA PERIO FPLA MANDT TVRG Rule table for indirect date determination for contracts MANDT
FPLA RFPLN FPLA RFPLN FPLA Billing Plan FPLNR
FPLA RFPLN FPLA MANDT FPLA Billing Plan MANDT
FPLA TNDAR FPLA MANDT TVRG Rule table for indirect date determination for contracts MANDT
FPLA TNDAR FPLA TNDAR TVRG Rule table for indirect date determination for contracts REGEL
FPLA VBELN FPLA MANDT VBUK Sales Document: Header Status and Administrative Data MANDT
FPLA VBELN FPLA VBELN VBUK Sales Document: Header Status and Administrative Data VBELN