SAP ABAP Table CRMT_BSP_LAM_OD1_FINPROD (Finance Contract ODC2 - Finprod)
Hierarchy
BBPCRM (Software Component) BBPCRM
   CRM-BTX-BF-FIN (Application Component) Financing
     CRM_BSP_MODEL_IL_LEASING (Package) Model Implementation: Leasing
Basic Data
Table Category INTTAB    Structure 
Structure CRMT_BSP_LAM_OD1_FINPROD   Table Relationship Diagram
Short Description Finance Contract ODC2 - Finprod    
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 OBJECT_KEY CRMT_BSP_OBJECTKEY   CHAR 100   0   Object Key  
2 .INCLUDE       0   0   Financing Data  
3 .INCLUDE       0   0   Management of Interface Structures  
4 GUID CRMT_OBJECT_GUID SYSUUID RAW 16   0   GUID of a CRM Order Object  
5 HANDLE CRMT_HANDLE   NUMC 10   0   Handle  
6 .INCLUDE       0   0   Financing Product Item Data - Structure w/ External Fields  
7 RESID_VALUE_FLAG CRMT_RESID_VALUE_F CRMT_RESID_VALUE_F CHAR 1   0   Residual Risk  
8 RESID_VALUE_GRP CRMT_RESID_VALUE_GRP CRMT_RESID_VALUE_GRP CHAR 3   0   Residual Value Curve CRMC_RESIDVLGR
9 PURCHASE_OPTION CRMT_PURCHASE_OPTION CRMT_PURCHASE_OPTION CHAR 1   0   End of Lease Purchase Option  
10 CLASSIFICATION CRMT_CLASSIFICATION CRMT_CLASSIFICATION NUMC 2   0   Contract Class  
11 CLASSIF_LOCAL CRMT_CLASSIF_LOCAL CRMT_FILA_CLASS CHAR 2   0   Local Classification Type (Tax) CRMC_TFILA_FIN
12 CLASSIF_LOCAL_BK CRMT_CLASSIF_LOCAL_BOOK CRMT_FILA_CLASS CHAR 2   0   Local Classification Type (Book) CRMC_TFILA_FIN
13 CLASSIF_GROUP CRMT_CLASSIF_GROUP CRMT_FILA_CLASS CHAR 2   0   Group Classification Type CRMC_TFILA_FIN
14 CLASSIF_GROUP_BK CRMT_CLASSIF_GROUP_BOOK CRMT_FILA_CLASS CHAR 2   0   Group Classification Type (Book) CRMC_TFILA_FIN
15 CLAS_CUSTOMER CRMT_CLAS_CUSTOMER CRMT_FILA_CLASS CHAR 2   0   Customer Classification Type (Tax) CRMC_TFILA_FIN
16 CLAS_GROUP_FLAG CRMT_CLAS_GROUP_FLAG XFELD CHAR 1   0   Default Group Classification (Tax)  
17 CLAS_GROUPBK_FLG CRMT_CLAS_GROUP_BOOK_FLG XFELD CHAR 1   0   Default Group Classification (Book)  
18 CLASSIFI_FLAG CRMT_CLASSIFI_FLAG XFELD CHAR 1   0   Default Local Classification (Tax)  
19 CLAS_LOCALBK_FLG CRMT_CLAS_LOCAL_BOOK_FLG XFELD CHAR 1   0   Default Local Classification (Book)  
20 LEAS_CLASS CRMT_LEAS_CLASS CRMT_LEAS_CLASS CHAR 1   0   Tax Pricing Strategy  
21 USED_FLAG CRMT_USED_FLAG XFELD CHAR 1   0   Leased Object Is Used  
22 TAX_FINANC_FLAG CRMT_TAX_FINANC_FLAG XFELD CHAR 1   0   Financing of Taxes Allowed  
23 CHARGE_FIN_FLAG CRMT_CHARGE_FIN_FLAG XFELD CHAR 1   0   Financing of Fees Allowed  
24 COSTS_FIN_FLAG CRMT_COSTS_FIN_FLAG XFELD CHAR 1   0   Inclusion of Costs Allowed  
25 SERV_FIN_FLAG CRMT_SERV_FIN_FLAG XFELD CHAR 1   0   Financing of Services Allowed  
26 TAX_FIN_USE_FLG CRMT_TAX_FINANC_USE_FLAG XFELD CHAR 1   0   Financing of Taxes  
27 CHRG_FIN_USE_FLG CRMT_CHARGE_FIN_USE_FLAG XFELD CHAR 1   0   Financing of Fees  
28 COST_FIN_USE_FLG CRMT_COSTS_FIN_USE_FLAG XFELD CHAR 1   0   Inclusion of Costs  
29 SERV_FIN_USE_FLG CRMT_SERV_FIN_USE_FLAG XFELD CHAR 1   0   Financing of Services  
30 FMV_CURVE CRMT_FMV_CURVE CRMT_FMV_CURVE CHAR 2   0   Fair Market Value Curve CRMC_FMV_CURVE
31 PRICING_FIMA CRMT_PROCESS_FIMA CRMT_PRICING_PROCESS_FIMA CHAR 4   0   Installment Calculation Procedure CRMC_PROCESS_FM
32 SERVICE_FLAG CRMT_FIN_SERV_FLAG CRMT_FIN_SERV_FLAG CHAR 1   0   Financing of Services  
33 CHARGE_FLAG CRMT_FIN_CHARGE_FLAG CRMT_FIN_CHARGE_FLAG CHAR 1   0   Financing of Fees  
34 COSTS_FLAG CRMT_FIN_COSTS_FLAG CRMT_FIN_COSTS_FLAG CHAR 1   0   Inclusion of Costs  
35 RATEBLEND_FLAG CRMT_FIN_RATEBLEND CRMT_FIN_RATEBLEND CHAR 1   0   Payment Blending in Overall View  
36 PTWACC_ROE CRMT_PTWACC_ROE CRMT_LEAS_INTEREST DEC 11   7   Return on Equity before Taxes  
37 ATWACC_ROE CRMT_ATWACC_ROE CRMT_LEAS_INTEREST DEC 11   7   After Tax Return on Equity  
38 LESSOR_IRR CRMT_LESSOR_IRR CRMT_LEAS_INTEREST DEC 11   7   Lessor Internal Rate of Return  
39 ACCOUNT_IRR CRMT_ACCOUNT_IRR CRMT_LEAS_INTEREST DEC 11   7   Internal Rate of Return for Accounting  
40 CUSTOMER_IRR CRMT_CUSTOMER_IRR CRMT_LEAS_INTEREST DEC 11   7   Lessee Internal Rate of Return  
41 FIN_TRANSACTION CRMT_FIN_TRANSACTION CRMT_FIN_TRAN CHAR 3   0   Financing Transactions (no longer active!)  
42 BUSINESS_PROCESS J_VORGANG J_VORGANG CHAR 4   0   Business Transaction *
43 CHNG_PROCESS CRMT_LEAS_CHNG CRMT_LEAS_CHNG_PROC CHAR 4   0   Change Process CRMC_LEAS_PROCES
44 CHNG_PROCESS1 CRMT_LEAS_CHNG_SUB1 CRMT_LEAS_CHNG_PROC CHAR 4   0   Change of Lease: Sub-Change Process CRMC_LEAS_PROCES
45 KEEP_RATEPERX CRMT_KEEP_RATEPERX XFELD CHAR 1   0   Keep Rate per x - Y/N  
46 LINK_TO_TC CRMT_LINK_TO_TC CRMT_LINK_TO_TC CHAR 10   0   Technical Name for General Terms and Conditions CRMC_FIN_TC
47 LOOKUP_FOR_INTER CRMT_LOOKUP_FOR_INT CRMT_LOOKUP_FOR_INT NUMC 2   0   Interest Determination  
48 STEP_PAYMENT_F CRMT_STEP_PAYMENT_F CRMT_STEP_PAYMENT_F CHAR 1   0   Step Payments Allowed  
49 STEP_STRUCTURE CRMT_FIMAN_STEPSTR XFELD CHAR 1   0   Step Payments  
50 DOWN_PAYMENT_F CRMT_DOWN_PAYMENT_F CRMT_DOWN_PAYMENT_F CHAR 1   0   Down Payment Required  
51 REFERENCE_INTER CRMT_REFERENCE_INT CRMT_REFERENCE_INT NUMC 2   0   Reference Interest Rate  
52 REFERENCE_INTE_D CRMT_REFERENCE_INT_D ZIREFKU CHAR 10   0   Interest Reference ID T056R
53 FLUCTUATION_CAP CRMT_FIN_INTEREST_CLIP_LEVEL CRMT_FIN_INTEREST_CLIP_LEVEL DEC 10   7   Clip Level  
54 AVERAGE_DAYS CRMT_FIN_INTEREST_AVERAGE_DAYS CRMT_FIN_INTEREST_AVERAGE_DAYS NUMC 4   0   Number of Days for Calculation of Average Interest Rate  
55 INTERIM_PERIOD CRMT_INTERIM_PERIOD CRMT_INTERIM_PERIOD NUMC 2   0   Interim Period (No Longer Active)  
56 INTERIMDAYS CRMT_INTERIMDAYS T_GSTAGE INT4 10   0   Number of Interim Days  
57 INTDAYSUSE CRMT_FIMAN_INTDAYSUSE XFELD CHAR 1   0   Use Interim Days  
58 ROUND_PROFILE CRMT_ROUND_PROFILE CRMT_ROUND_PROFILE CHAR 12   0   Rounding Profile CRMC_ROUND_PROFR
59 CFTYPE_PROFILE CRMT_CFTYPE_PROFILE CRMT_CFTYPE_PROFILE CHAR 12   0   Flow Category Profile CRMC_CFTYPE_PR_R
60 RATE_PER_K_USE CRMT_RATE_PER_K_USE CRMT_RATE_PER_K_USE CHAR 1   0   Apply Rate per X  
61 FLAT_RATE_PERX CRMT_FIMA_FLATRATEPERX CRMT_FIMA_DECV7_10 DEC 17   10   Flat Rate per x  
62 FINOPT_EXE CRMT_FINOPT_EXE XFELD CHAR 1   0   Originated from Option  
63 PRED_HEADER_GUID CRMT_PRED_HEADER_GUID SYSUUID RAW 16   0   Header GUID of Preceding CRM Document  
64 PRED_ITEM_GUID CRMT_PRED_ITEM_GUID SYSUUID RAW 16   0   Guid from a Preceding Item  
65 TAX_IRR CRMT_TAX_IRR CRMT_LEAS_INTEREST DEC 11   7   Internal Rate of Return - Tax  
66 FLATRATE_LESSOR CRMT_FLATRATE_LESSOR CRMT_FIMAN_FLATRATE CURR 19   2   Flat Rate - Lessor  
67 FLATRATE_CUSTOM CRMT_FLATRATE_CUSTOM CRMT_FIMAN_FLATRATE CURR 19   2   Flat Rate - Customer  
68 FLATRATE_CUSTALL CRMT_FLATRATE_CUSTALL CRMT_FIMAN_FLATRATE CURR 19   2   Flate Rate - Customer Complete  
69 FLATRATE_TAX CRMT_FLATRATE_TAX CRMT_FIMAN_FLATRATE CURR 19   2   Flat Rate - Tax  
70 FLATRATE_FEES CRMT_FLATRATE_FEES CRMT_FIMAN_FLATRATE CURR 19   2   Flat Rate - Fees  
71 FLATRATE_CSTINCL CRMT_FLATRATE_COSTINCL CRMT_FIMAN_FLATRATE CURR 19   2   Flate Rate - Costs Inclusion  
72 FLATRATE_SERVICE CRMT_FLATRATE_SERVICE CRMT_FIMAN_FLATRATE CURR 19   2   Flat Rate - Service  
73 KEYDAY CRMT_FIMAN_KEYDAY TFM_SKEYDAY NUMC 2   0   Key Date for Date Update  
74 ONE_VIEW_FLAG CRMT_ONE_VIEW_FLAG CRMT_ONE_VIEW_FLAG CHAR 1   0   Manage Only One View  
75 VIEW_DISTR_METH CRMT_DISTR_METHOD CRMT_DISTR_METHOD NUMC 1   0   Distribution of Default Amounts in Financing Views  
76 CUSTOM_COMPL_IRR CRMT_CUSTOMER_COMPL_IRR CRMT_LEAS_INTEREST DEC 11   7   Cust.Compl.View -Internal Rate of Return(Effective Int.Rate)  
77 FEES_IRR CRMT_FEES_IRR CRMT_LEAS_INTEREST DEC 11   7   Fees View - Internal Rate of Return (Effective Int. Rate)  
78 SERVICE_IRR CRMT_SERVICE_IRR CRMT_LEAS_INTEREST DEC 11   7   Service Internal Rate of Return (Effective Interest Rate)  
79 CSTINCL_IRR CRMT_CSTINCL_IRR CRMT_LEAS_INTEREST DEC 11   7   Cost Inclusion -Internal Rate of Return(Effective Int. Rate)  
80 TAX_UPFRONT_FLAG CRMT_TAX_UPFRONT_FLAG XFELD CHAR 1   0   Upfront Tax  
81 TAX_NO_FLAG CRMT_TAX_NO_FLAG XFELD CHAR 1   0   No Tax Calculation  
82 TAX_FINANC_GUID CRMT_TAX_FINANC_GUID SYSUUID RAW 16   0   GUID for Virtual Tax Financing Item  
83 UPG_TYPE CRMT_UPG_TYPE CRM_UPG_TYPE CHAR 1   0   Upgrade Category  
84 UPG_BASE_GUID CRMT_UPG_BASE_GUID SYSUUID RAW 16   0   Base GUID for Upgrades  
85 .INCLUDE       0   0    
86 .INCLUDE       0   0   Item Data of Financing Product Options - External Fields  
87 OPTION_TYPE CRMT_OPTION_ART_01 CRMT_OPTION_ART_01 CHAR 4   0   Option Type CRMC_PR_FINOP1
88 VALUATION CRMT_VALUATION_FLAG CRMT_VALUATION_FLAG CHAR 1   0   Valuation Only on Exercise Date  
89 PRESTATED CRMT_PRESTATED_FLAG CRMT_PRESTATED_FLAG CHAR 1   0   Option Was Agreed to by Customer  
90 BARGAIN CRMT_BARGAIN CRMT_BARGAIN CHAR 1   0   Bargain Option Indicator  
91 PRICING_PROCESS CRMT_PRICING_PROCESS_OPT CRMT_PRICING_PROCESS CHAR 4   0   Pricing Process CRMC_PROCESS_OP
92 PRICING_PROCESS1 CRMT_PRICING_PROCESS_OPT_SUB1 CRMT_PRICING_PROCESS1 CHAR 4   0   Sub-Pricing Process CRMC_PROCESS_O1
93 FINOPT_DEF CRMT_FINOPT_DEF_EXE XFELD CHAR 1   0   Standard at Contract End  
94 OPTION_CRE_MODE CRMT_OPTION_CREATE_MODE CHAR1 CHAR 1   0   Create Mode for Option (Manual, Copied, Generated)  
95 .INCLUDE       0   0   Financing Product Item Data - Structure w/ Internal Fields  
96 INTCALC_METHOD CRMT_SZBMETH SZBMETH CHAR 1   0   Interest Calculation Method  
97 IRR_METHOD CRMT_SEFFMETH SEFFMETH NUMC 1   0   Effective Interest Method  
98 INTCALC_M_EXT CRMT_SZBMETH_EXT SZBMETH CHAR 1   0   Interest Calculation Method (Effective Interest)  
99 IRR_M_EXT CRMT_SEFFMETH_EXT SEFFMETH NUMC 1   0   Effective Interest Method (External)  
100 RATE_FACTOR CRMT_RATE_FACTOR CRMT_RATE_FACTOR INT4 10   0   Rate Factor  
101 ADGSDAYS CRMT_ADGSDAYS T_GSTAGE INT4 10   0   Number of Days for Payment Date Adjustment  
102 COMPEXPO CRMT_FIMA_COMPEXPO XFELD CHAR 1   0   Exponential Interest Calculation  
103 INTSETTLFREQ CRMT_FIMA_INTSETTLFREQ TFM_AMMRHYZV NUMC 2   0   Frequency for Exponential Interest Calculation  
104 INTSETTLFREQ_IRR CRMT_FIMA_INTSETTLFREQ_IRR TFM_AMMRHYZV NUMC 2   0   Exponential Frequency for Interest Calculation (Effect.Int.)  
105 CALC_FLATRATE CRMT_FIMA_FLATRATE_CALC CRMT_FIMA_FLATRATE_CALC CHAR 1   0   Calculate Flat Rate  
106 PAYMSCHED_CREATE CRMT_FIMAN_PAYMSCHED_CREATE CRMT_FIMAN_PAYMSCHED_CREATE CHAR 4   0   Payment Schedule Generation Method CRMC_PAYMSCHED
107 PROCESS_PROFILE CRMT_FIMAN_PROCPR CRMT_FIMAN_CALCPR CHAR 12   0   Installment Calculation Profile  
108 BACKSOLVE_METHOD CRMT_FIMAN_BACKSOLVE_METH CRMT_FIMAN_BACKSOLVE_METH CHAR 20   0   Solution Method CRMC_BACKSOLV_ME
109 BACKSOLVE_MET_PR CRMT_FIMAN_BACKSOLVE_METH_PRE CRMT_FIMAN_BACKSOLVE_METH CHAR 20   0   External Solution Method CRMC_BACKSOLV_ME
110 CALC_PROFILE CRMT_FIMAN_CALCPR CRMT_FIMAN_CALCPR CHAR 12   0   Calculation Method Profile  
111 INTP_CHARGE CRMT_FIMAN_INTPCH XFELD CHAR 1   0   Show Interim Period as Fee  
112 IRR_PROFILE CRMT_FIMAN_IRRPR CRMT_FIMAN_IRRPR CHAR 12   0   Effective Interest Profile  
113 IRR_METHOD_BADI CRMT_FIMAN_IRRMETH CRMT_FIMAN_IRRMETH CHAR 4   0   Effective Interest Procedure CRMC_IRRMETH
114 BALSETTL_METH CRMT_FIMAN_BALSETTL CRMT_FIMAN_BALSETTL CHAR 1   0   Balance Settlement Method  
115 CFTYPE_BALSETTL CRMT_FIMAN_CFTYPE_BS CRMT_CASHFLOW_TYPE CHAR 4   0   Flow Category Balance Settlement  
116 FINV_PROFILE CRMT_FIMAN_FINVPR CRMT_FIMAN_CALCPR CHAR 12   0   Financing View Profile  
117 INTCALC_M_INTP CRMT_FIMAN_SZBMINTP SZBMETH CHAR 1   0   Interest Calculation Method for Interim Period  
118 USE_ACTDAYS CRMT_FIMAN_ACTDAYS XFELD CHAR 1   0   Calendar Days in Interim Period  
119 FIMA_ALGTYPE CRMT_FIMAN_TYPE CRMT_FIMAN_TYPE CHAR 10   0   Financial-Mathematical Algorithm Type  
120 .INCLUDE       0   0   Extended Financing Terms  
121 RATING BP_RATING BP_RATING CHAR 3   0   Rating *
122 BILPR BLIT_BILPR BLI_BILPR CHAR 6   0   Billing Procedure  
123 CURRENCY CRMT_CURRENCY WAERS CUKY 5   0   Currency *
124 IRR CRMT_IRR CRMT_LEAS_INTEREST DEC 11   7   Effective Interest Rate  
125 FLATRATE CRMT_FLATRATE CRMT_FIMAN_FLATRATE CURR 19   2   Flat Rate  
126 FIN_VIEW CRMT_FINANCING_VIEW CRMT_FINANCING_VIEW NUMC 2   0   Financing View *
127 LIST_TYPE CRMT_BILLPLAN_LIST_TYPE CRMT_BILLPLAN_LIST_TYPE NUMC 2   0   List Type  
128 CATEGORY_ID COMT_CATEGORY_ID COM_CATEGORY_ID CHAR 20   0   Category ID  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 CRMT_BSP_LAM_OD1_FINPROD BACKSOLVE_METHOD CRMC_BACKSOLV_ME BACKSOLVE_METHOD    
2 CRMT_BSP_LAM_OD1_FINPROD BACKSOLVE_MET_PR CRMC_BACKSOLV_ME BACKSOLVE_METHOD    
3 CRMT_BSP_LAM_OD1_FINPROD CFTYPE_PROFILE CRMC_CFTYPE_PR_R CFTYPE_PROFIL KEY 1 CN
4 CRMT_BSP_LAM_OD1_FINPROD CHNG_PROCESS CRMC_LEAS_PROCES CHNG_PROC    
5 CRMT_BSP_LAM_OD1_FINPROD CHNG_PROCESS1 CRMC_LEAS_PROCES CHNG_PROC    
6 CRMT_BSP_LAM_OD1_FINPROD CLASSIF_GROUP CRMC_TFILA_FIN CLASS    
7 CRMT_BSP_LAM_OD1_FINPROD CLASSIF_GROUP_BK CRMC_TFILA_FIN CLASS    
8 CRMT_BSP_LAM_OD1_FINPROD CLASSIF_LOCAL CRMC_TFILA_FIN CLASS    
9 CRMT_BSP_LAM_OD1_FINPROD CLASSIF_LOCAL_BK CRMC_TFILA_FIN CLASS    
10 CRMT_BSP_LAM_OD1_FINPROD CLAS_CUSTOMER CRMC_TFILA_FIN CLASS KEY 1 CN
11 CRMT_BSP_LAM_OD1_FINPROD FMV_CURVE CRMC_FMV_CURVE FMV_CURVE    
12 CRMT_BSP_LAM_OD1_FINPROD IRR_METHOD_BADI CRMC_IRRMETH IRR_METHOD    
13 CRMT_BSP_LAM_OD1_FINPROD LINK_TO_TC CRMC_FIN_TC LINK_TO_TC KEY 1 CN
14 CRMT_BSP_LAM_OD1_FINPROD OPTION_TYPE CRMC_PR_FINOP1 OPTION_ART    
15 CRMT_BSP_LAM_OD1_FINPROD PAYMSCHED_CREATE CRMC_PAYMSCHED PAYMSCHED_CREATE    
16 CRMT_BSP_LAM_OD1_FINPROD PRICING_FIMA CRMC_PROCESS_FM PRICING_PROCESS    
17 CRMT_BSP_LAM_OD1_FINPROD PRICING_PROCESS CRMC_PROCESS_OP PRICING_PROCESS    
18 CRMT_BSP_LAM_OD1_FINPROD PRICING_PROCESS1 CRMC_PROCESS_O1 PRICING_PROCESS1    
19 CRMT_BSP_LAM_OD1_FINPROD REFERENCE_INTE_D T056R REFERENZ KEY 1 CN
20 CRMT_BSP_LAM_OD1_FINPROD RESID_VALUE_GRP CRMC_RESIDVLGR RESID_VALUE_GRP KEY 1 CN
21 CRMT_BSP_LAM_OD1_FINPROD ROUND_PROFILE CRMC_ROUND_PROFR ROUND_PROFILE KEY 1 CN
History
Last changed by/on SAP  20130604 
SAP Release Created in 400