SAP ABAP Table FPLT (Billing Plan: Dates)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
⤷ VZ (Package) Application development R/3 RV central functions
⤷ CRM-BTX-BF-IF (Application Component) R/3 Interface for Business Transactions
⤷ VZ (Package) Application development R/3 RV central functions
Basic Data
Table Category | TRANSP | Transparent table |
Transparent table | FPLT | Table Relationship Diagram |
Short Description | Billing Plan: Dates |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | FPLNR | FPLNR | FPLNR | CHAR | 10 | 0 | Billing plan number / invoicing plan number | * | |
3 | FPLTR | FPLTR | FPLTR | NUMC | 6 | 0 | Item for billing plan/invoice plan/payment cards | ||
4 | FPTTP | FPTTP | FPTTP | CHAR | 2 | 0 | Date Category | TFPLT | |
5 | TETXT | TETXT_FP | TETXT | CHAR | 4 | 0 | Date description | TVTB | |
6 | FKDAT | BFDAT | DATUM | DATS | 8 | 0 | Settlement Date for Deadline | ||
7 | FPFIX | FPFIX | FPFIX | CHAR | 1 | 0 | ID for adopting billing/invoice date | ||
8 | FAREG | FAREG | FAREG | CHAR | 1 | 0 | Rule in billing plan/invoice plan | ||
9 | FPROZ | FPROZ | PRZ32 | DEC | 5 | 2 | Percentage of value to be billed | ||
10 | WAERS | WAERS_CP | WAERS | CUKY | 5 | 0 | Currency Key of Credit Control Area | TCURC | |
11 | KURFP | KURFP | KURRF | DEC | 9 | 5 | Exchange rate for date in billing plan | ||
12 | FAKWR | FAKWR | WERTV8 | CURR | 15 | 2 | Value to be billed/calc. on date in billing/invoice plan | ||
13 | FAKSP | FAKSP_FP | FAKSP | CHAR | 2 | 0 | Billing block for billing plan/invoice plan dates | TVFS | |
14 | FKARV | FKARA | FKART | CHAR | 4 | 0 | Proposed billing type for an order-related billing document | TVFK | |
15 | FKSAF | FKSAF | STATV | CHAR | 1 | 0 | Billing status for the billing plan/invoice plan date | ||
16 | PERIO | PERIO_FP | VDREG_VEDA | CHAR | 2 | 0 | Rule for determining the next billing/invoice date | TVRG | |
17 | FPLAE | FPLAE | NUM3 | NUMC | 3 | 0 | Length of a standard period in the billing plan | ||
18 | MLSTN | MLST_ZAEHL | NUM12 | NUMC | 12 | 0 | Number of milestone | ||
19 | MLBEZ | MILESTONE | MILESTONE | CHAR | 5 | 0 | Usage | T433 | |
20 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | ||
21 | KUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | KNA1 | |
22 | TAXK1 | TAXK1 | TAXKD | CHAR | 1 | 0 | Tax classification 1 for customer | * | |
23 | TAXK2 | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | * | |
24 | TAXK3 | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | * | |
25 | TAXK4 | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | * | |
26 | TAXK5 | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | * | |
27 | TAXK6 | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | * | |
28 | TAXK7 | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | * | |
29 | TAXK8 | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | * | |
30 | TAXK9 | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | * | |
31 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
32 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
33 | NFDAT | NFDAT | DATUM | DATS | 8 | 0 | Settlement date for deadline | ||
34 | TEMAN | TEMAN_1 | TEMAN | CHAR | 1 | 0 | Process as for manually entered date | ||
35 | FAKCA | FAKCA | WFCID | CHAR | 2 | 0 | Calendar for defining days relevant for billing/invoicing | TFACD | |
36 | AFDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
37 | NETWR | NETWR_AP | WERTV8 | CURR | 15 | 2 | Net value of the order item in document currency | ||
38 | NETPR | NETPR | WERTV6 | CURR | 11 | 2 | Net price | ||
39 | WAVWR | WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
40 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
41 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
42 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
43 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
44 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
45 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
46 | CMPRE | CMPRE | WERTV6 | CURR | 11 | 2 | Item credit price | ||
47 | SKFBP | SKFBT | WERT7 | CURR | 13 | 2 | Amount Eligible for Cash Discount in Document Currency | ||
48 | BONBA | BONBA | WERTV7 | CURR | 13 | 2 | Rebate basis 1 | ||
49 | PRSOK | PRSOK | XFELD | CHAR | 1 | 0 | Pricing is OK | ||
50 | TYPZM | TYPZM | TYPZM | CHAR | 1 | 0 | Means of payment for classifying payment card plan lines | ||
51 | CMPRE_FLT | CMPRE_FLT | FLTP | FLTP | 16 | 16 | Item credit price | ||
52 | UELNR | UELNR | FPLNR | CHAR | 10 | 0 | Higher-level payment card plan number for billing | FPLA | |
53 | UELTR | UELTR | FPLTR | NUMC | 6 | 0 | Higher-level item in billing plan | FPLT | |
54 | KURRF | KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
55 | CCACT | CCACT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Payment Card Receivables | SKA1 | |
56 | KORTE | KORTE | KORTE | CHAR | 1 | 0 | Indicator for correction date in billing plan | ||
57 | OFKDAT | OFKDAT | DATUM | DATS | 8 | 0 | Baseline date for determining AFDAT | ||
58 | .INCLU--AP | 0 | 0 | Period of Performance | |||||
59 | PEROP_BEG | FM_PEROP_SD_LOW | DATUM | DATS | 8 | 0 | Period of Performance Start Date | ||
60 | PEROP_END | FM_PEROP_SD_HIGH | DATUM | DATS | 8 | 0 | Period of Performance End Date |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | FPLT | CCACT | SKA1 | SAKNR | 1 | CN | |
2 | FPLT | FAKCA | TFACD | IDENT | |||
3 | FPLT | FAKSP | TVFS | FAKSP | REF | C | CN |
4 | FPLT | FKARV | TVFK | FKART | REF | C | CN |
5 | FPLT | FPTTP | TFPLT | FPTTP | REF | 1 | CN |
6 | FPLT | KUNRG | KNA1 | KUNNR | REF | C | CN |
7 | FPLT | MANDT | T000 | MANDT | KEY | 1 | CN |
8 | FPLT | MLBEZ | T433 | MLSTN | REF | C | CN |
9 | FPLT | PERIO | TVRG | REGEL | REF | C | CN |
10 | FPLT | TETXT | TVTB | TETBE | REF | 1 | CN |
11 | FPLT | UELNR | FPLA | FPLNR | REF | 1 | CN |
12 | FPLT | UELTR | FPLT | FPLTR | REF | 1 | CN |
13 | FPLT | WAERS | TCURC | WAERS | REF | C | CN |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in |