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
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