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 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
| AUST2 | Payment cards: Totals status - Call external system | AUST2_CC | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| AUST3 | Payment cards: Overall status - Responses from ext. system | AUST3_CC | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| AUST4 | Payment cards: Reserve | AUST4_CC | CHAR | 1 | 0 | |||||||||||||
| AUST5 | Payment cards: Authorization block | AUST5_CC | CHAR | 1 | 0 |
Possible values
|
||||||||||||
| 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 |
Possible values
|
||||||||||||
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 |
