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 | Possible values | ||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
|
AUST2
Payment cards: Totals status - Call external system
|
AUST2_CC |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
AUST3
Payment cards: Overall status - Responses from ext. system
|
AUST3_CC |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
AUST4
Payment cards: Reserve
|
AUST4_CC |
CHAR
|
1 | 0 | ||||||||||||||
|
AUST5
Payment cards: Authorization block
|
AUST5_CC |
CHAR
|
1 | 0 | ||||||||||||||
|
||||||||||||||||||
|
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 | ||||||||||||||
|
||||||||||||||||||
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 | ENDAR |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| FPLA | ENDAR | FPLA | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| 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 | MANDT |
TVRG
Rule table for indirect date determination for contracts
|
MANDT |
| FPLA | PERIO | FPLA | PERIO |
TVRG
Rule table for indirect date determination for contracts
|
REGEL |
| FPLA | RFPLN | FPLA | MANDT |
FPLA
Billing Plan
|
MANDT |
| FPLA | RFPLN | FPLA | RFPLN |
FPLA
Billing Plan
|
FPLNR |
| 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 |