SAP ABAP Table MCFPLTB (Reference Structure of MCFPLT for Function Module)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCV (Package) R/3 application development: Sales Information System
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ MCV (Package) R/3 application development: Sales Information System
Basic Data
Table Category | INTTAB | Structure |
Structure | MCFPLTB | Table Relationship Diagram |
Short Description | Reference Structure of MCFPLT for Function Module |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
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 | .INCLUDE | 0 | 0 | Update Indicator for Statistics Updating | |||||
2 | SUPKZ | SUPKZ | SUPKZ | CHAR | 1 | 0 | Statistics update indicator (post in/post out) | ||
3 | .INCLUDE | 0 | 0 | Sales document: Billing plan dates ; | |||||
4 | .INCLUDE | 0 | 0 | Billing Plan: Dates | |||||
5 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
6 | FPLNR | FPLNR | FPLNR | CHAR | 10 | 0 | Billing plan number / invoicing plan number | * | |
7 | FPLTR | FPLTR | FPLTR | NUMC | 6 | 0 | Item for billing plan/invoice plan/payment cards | * | |
8 | FPTTP | FPTTP | FPTTP | CHAR | 2 | 0 | Date Category | TFPLT | |
9 | TETXT | TETXT_FP | TETXT | CHAR | 4 | 0 | Date description | TVTB | |
10 | FKDAT | BFDAT | DATUM | DATS | 8 | 0 | Settlement Date for Deadline | ||
11 | FPFIX | FPFIX | FPFIX | CHAR | 1 | 0 | ID for adopting billing/invoice date | ||
12 | FAREG | FAREG | FAREG | CHAR | 1 | 0 | Rule in billing plan/invoice plan | ||
13 | FPROZ | FPROZ | PRZ32 | DEC | 5 | 2 | Percentage of value to be billed | ||
14 | WAERS | WAERS_CP | WAERS | CUKY | 5 | 0 | Currency Key of Credit Control Area | TCURC | |
15 | KURFP | KURFP | KURRF | DEC | 9 | 5 | Exchange rate for date in billing plan | ||
16 | FAKWR | FAKWR | WERTV8 | CURR | 15 | 2 | Value to be billed/calc. on date in billing/invoice plan | ||
17 | FAKSP | FAKSP_FP | FAKSP | CHAR | 2 | 0 | Billing block for billing plan/invoice plan dates | TVFS | |
18 | FKARV | FKARA | FKART | CHAR | 4 | 0 | Proposed billing type for an order-related billing document | TVFK | |
19 | FKSAF | FKSAF | STATV | CHAR | 1 | 0 | Billing status for the billing plan/invoice plan date | ||
20 | PERIO | PERIO_FP | VDREG_VEDA | CHAR | 2 | 0 | Rule for determining the next billing/invoice date | TVRG | |
21 | FPLAE | FPLAE | NUM3 | NUMC | 3 | 0 | Length of a standard period in the billing plan | ||
22 | MLSTN | MLST_ZAEHL | NUM12 | NUMC | 12 | 0 | Number of milestone | ||
23 | MLBEZ | MILESTONE | MILESTONE | CHAR | 5 | 0 | Usage | T433 | |
24 | ZTERM | DZTERM | ZTERM | CHAR | 4 | 0 | Terms of payment key | * | |
25 | KUNRG | KUNRG | KUNNR | CHAR | 10 | 0 | Payer | KNA1 | |
26 | TAXK1 | TAXK1 | TAXKD | CHAR | 1 | 0 | Tax classification 1 for customer | * | |
27 | TAXK2 | TAXK2 | TAXKD | CHAR | 1 | 0 | Tax classification 2 for customer | * | |
28 | TAXK3 | TAXK3 | TAXKD | CHAR | 1 | 0 | Tax classification 3 for customer | * | |
29 | TAXK4 | TAXK4 | TAXKD | CHAR | 1 | 0 | Tax classification 4 for customer | * | |
30 | TAXK5 | TAXK5 | TAXKD | CHAR | 1 | 0 | Tax classification 5 for customer | * | |
31 | TAXK6 | TAXK6 | TAXKD | CHAR | 1 | 0 | Tax classification 6 for customer | * | |
32 | TAXK7 | TAXK7 | TAXKD | CHAR | 1 | 0 | Tax classification 7 for customer | * | |
33 | TAXK8 | TAXK8 | TAXKD | CHAR | 1 | 0 | Tax classification 8 for customer | * | |
34 | TAXK9 | TAXK9 | TAXKD | CHAR | 1 | 0 | Tax classification 9 for customer | * | |
35 | VALTG | VALTG | TAGE2 | NUMC | 2 | 0 | Additional value days | ||
36 | VALDT | VALDT | DATUM | DATS | 8 | 0 | Fixed value date | ||
37 | NFDAT | NFDAT | DATUM | DATS | 8 | 0 | Settlement date for deadline | ||
38 | TEMAN | TEMAN_1 | TEMAN | CHAR | 1 | 0 | Process as for manually entered date | ||
39 | FAKCA | FAKCA | WFCID | CHAR | 2 | 0 | Calendar for defining days relevant for billing/invoicing | TFACD | |
40 | AFDAT | FKDAT | DATUM | DATS | 8 | 0 | Billing date for billing index and printout | ||
41 | NETWR | NETWR_AP | WERTV8 | CURR | 15 | 2 | Net value of the order item in document currency | ||
42 | NETPR | NETPR | WERTV6 | CURR | 11 | 2 | Net price | ||
43 | WAVWR | WAVWR | WERTV7 | CURR | 13 | 2 | Cost in document currency | ||
44 | KZWI1 | KZWI1 | WERTV7 | CURR | 13 | 2 | Subtotal 1 from pricing procedure for condition | ||
45 | KZWI2 | KZWI2 | WERTV7 | CURR | 13 | 2 | Subtotal 2 from pricing procedure for condition | ||
46 | KZWI3 | KZWI3 | WERTV7 | CURR | 13 | 2 | Subtotal 3 from pricing procedure for condition | ||
47 | KZWI4 | KZWI4 | WERTV7 | CURR | 13 | 2 | Subtotal 4 from pricing procedure for condition | ||
48 | KZWI5 | KZWI5 | WERTV7 | CURR | 13 | 2 | Subtotal 5 from pricing procedure for condition | ||
49 | KZWI6 | KZWI6 | WERTV7 | CURR | 13 | 2 | Subtotal 6 from pricing procedure for condition | ||
50 | CMPRE | CMPRE | WERTV6 | CURR | 11 | 2 | Item credit price | ||
51 | SKFBP | SKFBT | WERT7 | CURR | 13 | 2 | Amount Eligible for Cash Discount in Document Currency | ||
52 | BONBA | BONBA | WERTV7 | CURR | 13 | 2 | Rebate basis 1 | ||
53 | PRSOK | PRSOK | XFELD | CHAR | 1 | 0 | Pricing is OK | ||
54 | TYPZM | TYPZM | TYPZM | CHAR | 1 | 0 | Means of payment for classifying payment card plan lines | ||
55 | CMPRE_FLT | CMPRE_FLT | FLTP | FLTP | 16 | 16 | Item credit price | ||
56 | UELNR | UELNR | FPLNR | CHAR | 10 | 0 | Higher-level payment card plan number for billing | FPLA | |
57 | UELTR | UELTR | FPLTR | NUMC | 6 | 0 | Higher-level item in billing plan | FPLT | |
58 | KURRF | KURRF | KURRF | DEC | 9 | 5 | Exchange rate for FI postings | ||
59 | CCACT | CCACT | SAKNR | CHAR | 10 | 0 | G/L Account Number for Payment Card Receivables | SKA1 | |
60 | KORTE | KORTE | KORTE | CHAR | 1 | 0 | Indicator for correction date in billing plan | ||
61 | OFKDAT | OFKDAT | DATUM | DATS | 8 | 0 | Baseline date for determining AFDAT | ||
62 | .INCLU--AP | 0 | 0 | Period of Performance | |||||
63 | PEROP_BEG | FM_PEROP_SD_LOW | DATUM | DATS | 8 | 0 | Period of Performance Start Date | ||
64 | PEROP_END | FM_PEROP_SD_HIGH | DATUM | DATS | 8 | 0 | Period of Performance End Date | ||
65 | .INCLUDE | 0 | 0 | Sales doc. : Add. Bill. Plan ; | |||||
66 | FPART | FPART | FPART | CHAR | 2 | 0 | Billing plan/invoice plan type | * | |
67 | BEDAT | BEDAT_FP | DATUM | DATS | 8 | 0 | Start date for billing plan/invoice plan | ||
68 | ENDAT | ENDAT_FP | DATUM | DATS | 8 | 0 | End date billing plan/invoice plan | ||
69 | LODAT | TADAT | DATUM | DATS | 8 | 0 | Dates from | ||
70 | TNDAT | TBDAT | DATUM | DATS | 8 | 0 | Dates To | ||
71 | .INCLUDE | 0 | 0 | User structure: VKBg: dates; | |||||
72 | DUMMY | DUMMY | DUMMY | CHAR | 1 | 0 | Dummy function in length 1 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | MCFPLTB | CCACT | SKA1 | SAKNR | 1 | CN | |
2 | MCFPLTB | FAKCA | TFACD | IDENT | |||
3 | MCFPLTB | FAKSP | TVFS | FAKSP | REF | C | CN |
4 | MCFPLTB | FKARV | TVFK | FKART | REF | C | CN |
5 | MCFPLTB | FPTTP | TFPLT | FPTTP | REF | 1 | CN |
6 | MCFPLTB | KUNRG | KNA1 | KUNNR | REF | C | CN |
7 | MCFPLTB | MANDT | T000 | MANDT | KEY | 1 | CN |
8 | MCFPLTB | MLBEZ | T433 | MLSTN | REF | C | CN |
9 | MCFPLTB | PERIO | TVRG | REGEL | REF | C | CN |
10 | MCFPLTB | TETXT | TVTB | TETBE | REF | 1 | CN |
11 | MCFPLTB | UELNR | FPLA | FPLNR | REF | 1 | CN |
12 | MCFPLTB | UELTR | FPLT | FPLTR | REF | 1 | CN |
13 | MCFPLTB | WAERS | TCURC | WAERS | REF | C | CN |
History
Last changed by/on | SAP | 20100310 |
SAP Release Created in | 470 |