SAP Table CRMD_FINPROD_I stores Transaction Item - Financing Productdata

  

In this post, I will try and describe everything you need to know about the SAP crmd_finprod_i table. What it is, including what type of data it stores.

A list of fields which make up the table structure and on an S/4Hana System for CRMD_FINPROD_I what does this table look like.

And what relationships it has with other SAP tables.

Also see here for example ABAP code to select data from CRMD_FINPROD_I....Right lets get started!


SAP CRMD_FINPROD_I dictionary attributes

Object Name: CRMD_FINPROD_I
Dictionary Type: Transparent table
Description: Transaction Item - Financing Product


CRMD_FINPROD_I field list

Field Data Element Data Type length (Dec) Check table Description Conversion Routine Domain Name MemoryID AppClass SHLP SHLP Field ConvExit
CLIENTMANDTCLNT3(0) *ClientMANDTTESTCRM
GUIDCRMT_OBJECT_GUIDRAW16(0) GUID of a CRM Order ObjectSYSUUIDCRM
RESID_VALUE_FLAGCRMT_RESID_VALUE_FCHAR1(0) Residual RiskCRMT_RESID_VALUE_FCRM
RESID_VALUE_GRPCRMT_RESID_VALUE_GRPCHAR3(0) CRMC_RESIDVLGRResidual Value CurveCRMT_RESID_VALUE_GRPCRM
PURCHASE_OPTIONCRMT_PURCHASE_OPTIONCHAR1(0) End of Lease Purchase OptionCRMT_PURCHASE_OPTIONCRM
CLASSIFICATIONCRMT_CLASSIFICATIONNUMC2(0) Contract ClassCRMT_CLASSIFICATIONCRM
CLASSIF_LOCALCRMT_CLASSIF_LOCALCHAR2(0) CRMC_TFILA_FINLocal Classification Type (Tax)CRMT_FILA_CLASSCRM
CLASSIF_LOCAL_BKCRMT_CLASSIF_LOCAL_BOOKCHAR2(0) CRMC_TFILA_FINLocal Classification Type (Book)CRMT_FILA_CLASSCRM
CLASSIF_GROUPCRMT_CLASSIF_GROUPCHAR2(0) CRMC_TFILA_FINGroup Classification TypeCRMT_FILA_CLASSCRM
CLASSIF_GROUP_BKCRMT_CLASSIF_GROUP_BOOKCHAR2(0) CRMC_TFILA_FINGroup Classification Type (Book)CRMT_FILA_CLASSCRM
CLAS_CUSTOMERCRMT_CLAS_CUSTOMERCHAR2(0) CRMC_TFILA_FINCustomer Classification Type (Tax)CRMT_FILA_CLASSCRM
CLAS_GROUP_FLAGCRMT_CLAS_GROUP_FLAGCHAR1(0) Default Group Classification (Tax)XFELDCRM
CLAS_GROUPBK_FLGCRMT_CLAS_GROUP_BOOK_FLGCHAR1(0) Default Group Classification (Book)XFELDCRM
CLASSIFI_FLAGCRMT_CLASSIFI_FLAGCHAR1(0) Default Local Classification (Tax)XFELDCRM
CLAS_LOCALBK_FLGCRMT_CLAS_LOCAL_BOOK_FLGCHAR1(0) Default Local Classification (Book)XFELDCRM
LEAS_CLASSCRMT_LEAS_CLASSCHAR1(0) Tax Pricing StrategyCRMT_LEAS_CLASSCRM
USED_FLAGCRMT_USED_FLAGCHAR1(0) Leased Object Is UsedXFELDCRM
TAX_FINANC_FLAGCRMT_TAX_FINANC_FLAGCHAR1(0) Financing of Taxes AllowedXFELDCRM
CHARGE_FIN_FLAGCRMT_CHARGE_FIN_FLAGCHAR1(0) Financing of Fees AllowedXFELDCRM
COSTS_FIN_FLAGCRMT_COSTS_FIN_FLAGCHAR1(0) Inclusion of Costs AllowedXFELDCRM
SERV_FIN_FLAGCRMT_SERV_FIN_FLAGCHAR1(0) Financing of Services AllowedXFELDCRM
TAX_FIN_USE_FLGCRMT_TAX_FINANC_USE_FLAGCHAR1(0) Financing of TaxesXFELDCRM
CHRG_FIN_USE_FLGCRMT_CHARGE_FIN_USE_FLAGCHAR1(0) Financing of FeesXFELDCRM
COST_FIN_USE_FLGCRMT_COSTS_FIN_USE_FLAGCHAR1(0) Inclusion of CostsXFELDCRM
SERV_FIN_USE_FLGCRMT_SERV_FIN_USE_FLAGCHAR1(0) Financing of ServicesXFELDCRM
FMV_CURVECRMT_FMV_CURVECHAR2(0) CRMC_FMV_CURVEFair Market Value CurveCRMT_FMV_CURVECRM
PRICING_FIMACRMT_PROCESS_FIMACHAR4(0) CRMC_PROCESS_FMInstallment Calculation ProcedureCRMT_PRICING_PROCESS_FIMACRM
SERVICE_FLAGCRMT_FIN_SERV_FLAGCHAR1(0) Financing of ServicesCRMT_FIN_SERV_FLAGCRM
CHARGE_FLAGCRMT_FIN_CHARGE_FLAGCHAR1(0) Financing of FeesCRMT_FIN_CHARGE_FLAGCRM
COSTS_FLAGCRMT_FIN_COSTS_FLAGCHAR1(0) Inclusion of CostsCRMT_FIN_COSTS_FLAGCRM
RATEBLEND_FLAGCRMT_FIN_RATEBLENDCHAR1(0) Payment Blending in Overall ViewCRMT_FIN_RATEBLENDCRM
PTWACC_ROECRMT_PTWACC_ROEDEC11(7) Return on Equity before TaxesCRMT_LEAS_INTERESTCRM
ATWACC_ROECRMT_ATWACC_ROEDEC11(7) After Tax Return on EquityCRMT_LEAS_INTERESTCRM
LESSOR_IRRCRMT_LESSOR_IRRDEC11(7) Lessor Internal Rate of ReturnCRMT_LEAS_INTERESTCRM
ACCOUNT_IRRCRMT_ACCOUNT_IRRDEC11(7) Internal Rate of Return for AccountingCRMT_LEAS_INTERESTCRM
CUSTOMER_IRRCRMT_CUSTOMER_IRRDEC11(7) Lessee Internal Rate of ReturnCRMT_LEAS_INTERESTCRM
FIN_TRANSACTIONCRMT_FIN_TRANSACTIONCHAR3(0) *Financing Transactions (no longer active!)CRMT_FIN_TRANCRM
BUSINESS_PROCESSJ_VORGANGCHAR4(0) *Business TransactionJ_VORGANGBSVCRM
CHNG_PROCESSCRMT_LEAS_CHNGCHAR4(0) CRMC_LEAS_PROCESChange ProcessCRMT_LEAS_CHNG_PROCCRM
CHNG_PROCESS1CRMT_LEAS_CHNG_SUB1CHAR4(0) CRMC_LEAS_PROCESChange of Lease: Sub-Change ProcessCRMT_LEAS_CHNG_PROCCRM
KEEP_RATEPERXCRMT_KEEP_RATEPERXCHAR1(0) Keep Rate per x - Y/NXFELDCRM
LINK_TO_TCCRMT_LINK_TO_TCCHAR10(0) CRMC_FIN_TCTechnical Name for General Terms and ConditionsCRMT_LINK_TO_TCCRM
LOOKUP_FOR_INTERCRMT_LOOKUP_FOR_INTNUMC2(0) Interest DeterminationCRMT_LOOKUP_FOR_INTCRM
STEP_PAYMENT_FCRMT_STEP_PAYMENT_FCHAR1(0) Step Payments AllowedCRMT_STEP_PAYMENT_FCRM
STEP_STRUCTURECRMT_FIMAN_STEPSTRCHAR1(0) Step PaymentsXFELDCRM
DOWN_PAYMENT_FCRMT_DOWN_PAYMENT_FCHAR1(0) Down Payment RequiredCRMT_DOWN_PAYMENT_FCRM
REFERENCE_INTERCRMT_REFERENCE_INTNUMC2(0) Reference Interest RateCRMT_REFERENCE_INTCRM
REFERENCE_INTE_DCRMT_REFERENCE_INT_DCHAR10(0) T056RInterest Reference IDZIREFKUCRM
FLUCTUATION_CAPCRMT_FIN_INTEREST_CLIP_LEVELDEC10(7) Clip LevelCRMT_FIN_INTEREST_CLIP_LEVELCRM
AVERAGE_DAYSCRMT_FIN_INTEREST_AVERAGE_DAYSNUMC4(0) Number of Days for Calculation of Average Interest RateCRMT_FIN_INTEREST_AVERAGE_DAYSCRM
INTERIM_PERIODCRMT_INTERIM_PERIODNUMC2(0) Interim Period (No Longer Active)CRMT_INTERIM_PERIODCRM
INTERIMDAYSCRMT_INTERIMDAYSINT410(0) Number of Interim DaysT_GSTAGECRM
INTDAYSUSECRMT_FIMAN_INTDAYSUSECHAR1(0) Use Interim DaysXFELDCRM
ROUND_PROFILECRMT_ROUND_PROFILECHAR12(0) CRMC_ROUND_PROFRRounding ProfileCRMT_ROUND_PROFILECRM
CFTYPE_PROFILECRMT_CFTYPE_PROFILECHAR12(0) CRMC_CFTYPE_PR_RFlow Category ProfileCRMT_CFTYPE_PROFILECRM
RATE_PER_K_USECRMT_RATE_PER_K_USECHAR1(0) Apply Rate per XCRMT_RATE_PER_K_USECRM
FLAT_RATE_PERXCRMT_FIMA_FLATRATEPERXDEC17(10) Flat Rate per xCRMT_FIMA_DECV7_10CRM
FINOPT_EXECRMT_FINOPT_EXECHAR1(0) Originated from OptionXFELDCRM
PRED_HEADER_GUIDCRMT_PRED_HEADER_GUIDRAW16(0) Header GUID of Preceding CRM DocumentSYSUUIDCRM
PRED_ITEM_GUIDCRMT_PRED_ITEM_GUIDRAW16(0) Guid from a Preceding ItemSYSUUIDCRM
TAX_IRRCRMT_TAX_IRRDEC11(7) Internal Rate of Return - TaxCRMT_LEAS_INTERESTCRM
FLATRATE_LESSORCRMT_FLATRATE_LESSORCURR19(2) Flat Rate - LessorCRMT_FIMAN_FLATRATECRM
FLATRATE_CUSTOMCRMT_FLATRATE_CUSTOMCURR19(2) Flat Rate - CustomerCRMT_FIMAN_FLATRATECRM
FLATRATE_CUSTALLCRMT_FLATRATE_CUSTALLCURR19(2) Flate Rate - Customer CompleteCRMT_FIMAN_FLATRATECRM
FLATRATE_TAXCRMT_FLATRATE_TAXCURR19(2) Flat Rate - TaxCRMT_FIMAN_FLATRATECRM
FLATRATE_FEESCRMT_FLATRATE_FEESCURR19(2) Flat Rate - FeesCRMT_FIMAN_FLATRATECRM
FLATRATE_CSTINCLCRMT_FLATRATE_COSTINCLCURR19(2) Flate Rate - Costs InclusionCRMT_FIMAN_FLATRATECRM
FLATRATE_SERVICECRMT_FLATRATE_SERVICECURR19(2) Flat Rate - ServiceCRMT_FIMAN_FLATRATECRM
KEYDAYCRMT_FIMAN_KEYDAYNUMC2(0) Key Date for Date UpdateTFM_SKEYDAYCRM
ONE_VIEW_FLAGCRMT_ONE_VIEW_FLAGCHAR1(0) Manage Only One ViewCRMT_ONE_VIEW_FLAGCRM
VIEW_DISTR_METHCRMT_DISTR_METHODNUMC1(0) Distribution of Default Amounts in Financing ViewsCRMT_DISTR_METHODCRM
CUSTOM_COMPL_IRRCRMT_CUSTOMER_COMPL_IRRDEC11(7) Cust.Compl.View -Internal Rate of Return(Effective Int.Rate)CRMT_LEAS_INTERESTCRM
FEES_IRRCRMT_FEES_IRRDEC11(7) Fees View - Internal Rate of Return (Effective Int. Rate)CRMT_LEAS_INTERESTCRM
SERVICE_IRRCRMT_SERVICE_IRRDEC11(7) Service Internal Rate of Return (Effective Interest Rate)CRMT_LEAS_INTERESTCRM
CSTINCL_IRRCRMT_CSTINCL_IRRDEC11(7) Cost Inclusion -Internal Rate of Return(Effective Int. Rate)CRMT_LEAS_INTERESTCRM
TAX_UPFRONT_FLAGCRMT_TAX_UPFRONT_FLAGCHAR1(0) Upfront TaxXFELDCRM
TAX_NO_FLAGCRMT_TAX_NO_FLAGCHAR1(0) No Tax CalculationXFELDCRM
TAX_FINANC_GUIDCRMT_TAX_FINANC_GUIDRAW16(0) GUID for Virtual Tax Financing ItemSYSUUIDCRM
UPG_TYPECRMT_UPG_TYPECHAR1(0) Upgrade CategoryCRM_UPG_TYPECRM
UPG_BASE_GUIDCRMT_UPG_BASE_GUIDRAW16(0) Base GUID for UpgradesSYSUUIDCRM
OPTION_TYPECRMT_OPTION_ART_01CHAR4(0) CRMC_PR_FINOP1Option TypeCRMT_OPTION_ART_01CRM
VALUATIONCRMT_VALUATION_FLAGCHAR1(0) Valuation Only on Exercise DateCRMT_VALUATION_FLAGCRM
PRESTATEDCRMT_PRESTATED_FLAGCHAR1(0) Option Was Agreed to by CustomerCRMT_PRESTATED_FLAGCRM
BARGAINCRMT_BARGAINCHAR1(0) Bargain Option IndicatorCRMT_BARGAINCRM
PRICING_PROCESSCRMT_PRICING_PROCESS_OPTCHAR4(0) CRMC_PROCESS_OPPricing ProcessCRMT_PRICING_PROCESSCRM
PRICING_PROCESS1CRMT_PRICING_PROCESS_OPT_SUB1CHAR4(0) CRMC_PROCESS_O1Sub-Pricing ProcessCRMT_PRICING_PROCESS1CRM
FINOPT_DEFCRMT_FINOPT_DEF_EXECHAR1(0) Standard at Contract EndXFELDCRM
OPTION_CRE_MODECRMT_OPTION_CREATE_MODECHAR1(0) Create Mode for Option (Manual, Copied, Generated)CHAR1CRM
INTCALC_METHODCRMT_SZBMETHCHAR1(0) Interest Calculation MethodSZBMETHCRM
IRR_METHODCRMT_SEFFMETHNUMC1(0) Effective Interest MethodSEFFMETHCRM
INTCALC_M_EXTCRMT_SZBMETH_EXTCHAR1(0) Interest Calculation Method (Effective Interest)SZBMETHFVVCRM
IRR_M_EXTCRMT_SEFFMETH_EXTNUMC1(0) Effective Interest Method (External)SEFFMETHFVVCRM
RATE_FACTORCRMT_RATE_FACTORINT410(0) Rate FactorCRMT_RATE_FACTORCRM
ADGSDAYSCRMT_ADGSDAYSINT410(0) Number of Days for Payment Date AdjustmentT_GSTAGECRM
COMPEXPOCRMT_FIMA_COMPEXPOCHAR1(0) Exponential Interest CalculationXFELDCRM
INTSETTLFREQCRMT_FIMA_INTSETTLFREQNUMC2(0) Frequency for Exponential Interest CalculationTFM_AMMRHYZVCRM
INTSETTLFREQ_IRRCRMT_FIMA_INTSETTLFREQ_IRRNUMC2(0) Exponential Frequency for Interest Calculation (Effect.Int.)TFM_AMMRHYZVCRM
CALC_FLATRATECRMT_FIMA_FLATRATE_CALCCHAR1(0) Calculate Flat RateCRMT_FIMA_FLATRATE_CALCCRM
PAYMSCHED_CREATECRMT_FIMAN_PAYMSCHED_CREATECHAR4(0) CRMC_PAYMSCHEDPayment Schedule Generation MethodCRMT_FIMAN_PAYMSCHED_CREATECRM
PROCESS_PROFILECRMT_FIMAN_PROCPRCHAR12(0) Installment Calculation ProfileCRMT_FIMAN_CALCPRCRM
BACKSOLVE_METHODCRMT_FIMAN_BACKSOLVE_METHCHAR20(0) CRMC_BACKSOLV_MESolution MethodCRMT_FIMAN_BACKSOLVE_METHCRM
BACKSOLVE_MET_PRCRMT_FIMAN_BACKSOLVE_METH_PRECHAR20(0) CRMC_BACKSOLV_MEPresolving MethodCRMT_FIMAN_BACKSOLVE_METHCRM
CALC_PROFILECRMT_FIMAN_CALCPRCHAR12(0) Calculation Method ProfileCRMT_FIMAN_CALCPRCRM
INTP_CHARGECRMT_FIMAN_INTPCHCHAR1(0) Show Interim Period as FeeXFELDCRM
IRR_PROFILECRMT_FIMAN_IRRPRCHAR12(0) Effective Interest ProfileCRMT_FIMAN_IRRPRCRM
IRR_METHOD_BADICRMT_FIMAN_IRRMETHCHAR4(0) CRMC_IRRMETHEffective Interest ProcedureCRMT_FIMAN_IRRMETHCRM
BALSETTL_METHCRMT_FIMAN_BALSETTLCHAR1(0) Balance Settlement MethodCRMT_FIMAN_BALSETTLCRM
CFTYPE_BALSETTLCRMT_FIMAN_CFTYPE_BSCHAR4(0) Flow Category Balance SettlementCRMT_CASHFLOW_TYPECRM
FINV_PROFILECRMT_FIMAN_FINVPRCHAR12(0) Financing View ProfileCRMT_FIMAN_CALCPRCRM
INTCALC_M_INTPCRMT_FIMAN_SZBMINTPCHAR1(0) Interest Calculation Method for Interim PeriodSZBMETHCRM
USE_ACTDAYSCRMT_FIMAN_ACTDAYSCHAR1(0) Calendar Days in Interim PeriodXFELDCRM
FIMA_ALGTYPECRMT_FIMAN_TYPECHAR10(0) Financial-Mathematical Algorithm TypeCRMT_FIMAN_TYPECRM
RATINGBP_RATINGCHAR3(0) *RatingBP_RATINGCRM
BILPRBLIT_BILPRCHAR6(0) Billing ProcedureBLI_BILPRBLI_BILPR_SHBILPRCRM