SAP Quotation and Contract Tables

Are you looking for the right table related to SAP Quotation and Contract Tables to query in an ABAP Program, Class, Function Module and OData API?

There are number of standard tables in SAP S/4HANA system. The data of an application is distributed across several database fields. Finding the right table is important, in this post we'll look at list of all the tables in Quotation and Contract (CRM-LAM-BTX-CTR) module.

Top 10 tables in Quotation and Contract

TableDescription
CRMC_LEAS_ROE_KIFields Needed for Calculation of Key Figures
CRMC_UNVN_RNT_TSClassifications for Uneven Rent Test
CRMC_LEAS_ROE_TADefinition of Tax Rates
CRMC_LEAS_VAL_TTText Table for Validation Types
CRMC_ORDPPR_LAMCustomizing Object List Screen with Installation
CRMC_LEAS_VAL_CLClasses for Performing General Validations
CRMC_PR_CLTPPricing on Request: Execution Times
CRMC_LEAS_VAL_TYValidation Types
CRMC_LEAS_ROE_TFAssignment of Control Fields to Source Fields
CRMC_PR_CLTPTPricing on Request: Execution Times (Texts)

List of tables in Quotation and Contract

TableDescription
CRMC_LEAS_ROE_KIFields Needed for Calculation of Key Figures
CRMC_UNVN_RNT_TSClassifications for Uneven Rent Test
CRMC_LEAS_ROE_TADefinition of Tax Rates
CRMC_LEAS_VAL_TTText Table for Validation Types
CRMC_ORDPPR_LAMCustomizing Object List Screen with Installation
CRMC_LEAS_VAL_CLClasses for Performing General Validations
CRMC_PR_CLTPPricing on Request: Execution Times
CRMC_LEAS_VAL_TYValidation Types
CRMC_LEAS_ROE_TFAssignment of Control Fields to Source Fields
CRMC_PR_CLTPTPricing on Request: Execution Times (Texts)
CRMC_PR_CLTMPricing on Request
CRMC_LEAS_VAL_OCAssignment of Validation Classes to Organizational Units
CRMC_TAX_STAMP1Transaction Categories for Calculating Stamp Duty
CRMC_TAX_EVENTLAM: Assign TTE Tax Events for FI Transfer
CRMC_OBJ_PROFILECRMC Leasing Object Profile
CRMC_TAX_STAMP2Condition Types for Cap Value and Tax Percentage
CRM_DEL_COMPNTAll Components to Be Deleted
CRMD_FS_MASS_DAMass Change Data
CRMD_FUELCAA7EEW: Generated Object (Do not Process Manually)
CRMC_TAX_EVENT_MLAM: Assign TTE Tax Events via TTE
CRMC_TAX_STAMP5SAustralian Stamp Duty - Rules II. - Status List for Group
CRMC_LEAS_ROE_TPTax Payment Dates
CRMC_LEAS_T009_VAssignment of Fiscal Year to Organizational Unit
CRMC_USEFUL_PERThreshold, Increase for Normal Useful Life
CRMC_TAXTax & Fee Types
CRMC_LEAS_ROE_KTText Table for CRMC_LEAS_ROE_KF
CRMC_LEAS_ROE_TVDefinition of Validity of Taxes
CRMC_TAX_LTFLeasing: Legal Transaction Fee
CRMC_OBJ_DESCRProduct Item Category
CRMC_USEFUL_STRTText Table for CRMC_USEFUL_STRA
CRMD_LEAS_ACCRLAM: Month-End Accruals Report Log File
CRMC_TAX_PROCESSTax Handling of Business Processes
CRMC_LEAS_ROE_TQAssignment of Tax Payments to Tax Fields
CRMC_USEFUL_STRAStrategies, Determination of Normal Useful Life
CRMC_TAX_STAMP4Status Usage for Billing Request Items
CRMC_OBJ_DESCR_TProduct Item Category - Texts
CRMC_TAX_STAMP5Status Usage for Financing Items
CRMC_UNVN_RNT_PAParameters for Uneven Rent Test
CRM_LEAS_ORDPPRAssignment: Product Family and Layout to Product Category
CRMC_TAX_STAMP6Basic Settings for Stamp Duty
CRMC_PROC_LFRQTransaction Types in Simplified Quotation Entry
CRMD_STAMPTAX_L2Stamp Duty for Australia - Calculation Log Table
CRMD_TIRESEALEEW: Generated Object (Do not Process Manually)
CRM_FSL_FUELHFuel Card Service
CRMD_FS_MASS_ADMAdministrative Data for a Mass Run
CRMC_LEAS_WO_PRDetermine Pricing Procedure for Write-Offs
CRM_FSL_FUEL2HFuel Card Administrative Data
CRMC_TAX_PURPCondition Function for Taxes
CRMC_TAX_TTax and Fee Types
CRMD_STAMPTAX_LGStamp Duty for Australia - Calculation Log Table
CRM_FSL_FUEL2Fuel Card Administrative Data
CRMC_TFILA_LC_CLeasing: Tax Calculation Rule per Classification
CRMC_TAXNO_LC_CLeasing: Non-Tax-Relevant Processes
LEAS_ITEM_LISTItem List for Dropdown
CRM_LEAS_COND_UICustomizing Table: Condition Entry in Default
CRMC_LEASING_FCCRM Leasing: Control of Whether Field Is Ready for Input
CRMC_LEAS_AFA_ASAssignment of Depreciation Key to Asset Category
CRMC_GRP_CFTYPEGrouping of Flow Categories for Net Present Value Calculat.
CRMC_CAI_VALIDCAI: Value Table of Value IDs
CRMC_CAI_LC_003CAI Tool: Determination of Value IDs
CRMC_LEAS_ASSETDefinition of Asset Category
CRMC_CAI_VALID_2Target Condition Types for Value Transfer
CRMC_LEAS_AFA_MDepreciation Methods
CRMC_BRF_CONIN_RSelection Parameters for Controlled Input Fields
CRMC_GRP_R_CFTAssignment of Flow Categories to Groups
CRMC_LEAS_AFA_RAssignment of Methods to Depreciation Keys
CRMC_DEVTYPE_TIMUseful Lives for Device Classes
CRMC_LC_COND_TSTAllowed Interval for Conditions
CRMC_LEAS_CHECKCheck Control
CRMC_CHGLEVEL_TChange Level Texts
CRMC_CAI_LC_007Assignment of Condition Type to Value ID
CRMC_LEAS_DAT_CKDate Check for Financial Items (Leasing)
CRMC_CHGLEVELBusiness Transaction - Field Input Authorization Group
CRMC_LEAS_AFA_PTPeriod Control for Depreciation Text Table
CRMC_LEAS_DUR_LCClassification Type to Use for Duration Checks
CRMC_ITEM_IOITFChecks for Individual Objects
CRMC_BRF_CONINBRF Expression for Controlled Input Fields (Header Data)
CRMC_DOCTYPEContract Classification
CRMC_LEAS_ROE_CSDefinition of Calculation Schemas for ROE Calculation
CRMC_CAI_LC_003RReferenced Value IDs for Function Modules
CRMC_DOCTYPE_TDocument Type Texts
CRMC_LEAS_CH_OL2Object List Processing: Permitted Actions
CRMC_LEAS_AFA_PPeriod Control for Depreciation
CRMC_LEAS_ICPROCAssign Item Category Group to a Business Process
CRMC_CAI_LC_003TText Table for CRMC_CAI_LC_003F
CRMC_CP_BRF_APPLAssign BRF Application Classes to Business Types
CRMC_LEAS_ROE_KFKey Figures, To Be Determined from Payment Flow
CRMC_LEAS_AFA_GYear-Dependent Percentages
CRMC_CREDIT_TESTCredit Test
CRMC_LEAS_CHNG_TLeasing: Texts for Change Processes
CRMC_LEAS_ROE_CKClasses for Determination of Key Figures
CRMC_LEAS_ROE_DFFormulas for Determining Field Values
CRMC_FINP_OP_NCPFinancial Product Data: Fields Not to Be Copied
CRMC_LEAS_ROE_CTText Table for CRMC_LEAS_ROE_CS
CRMC_LEAS_ROE_DMAssignment of Classes for Determining Field Values
CRMC_LEAS_CH_OL1Leasing Change Processes: Object List Processing
CRMC_LEAS_COCH_TCheck Automatic Price Conditions for Manual Entry
CRMC_CAI_LC_003FInterface of Function Modules
CRMC_CP_OBJ_TYPEPossible Business Transaction Types in Change Processes
CRMC_CAI_VD_ACTActive Condition Type for Value ID Determ. for CAI Tool
CRMC_CAI_VALID_TText Table for CRMC_CAI_VALID_T
CRMC_FIN_PROFILETransaction Item Object Category - Financing Profile
CRMC_LEASING_P_CLeasing Process Control
CRMC_GRP_CFTYPETText Table for CRMC_GRP_CFTYPE
CRMC_LEAS_CH_OL3Lease Change Process: Control of Dynamic Subscreen Calling
CRMC_GROUPING_TTexts for Product Grouping
CRMC_LEAS_ROE_CCDetermination of Relevant Classification Type
CRMC_GROUPINGProduct Grouping
CRMC_LEAS_ROE_DTHeaders for Fields
CRMC_LEAS_AFA_MTText Table for Depreciation Methods
CRMC_LEAS_ROE_INInput Values from Condition Functions
CRMC_LEAS_IOCHCheck Transition from Product to Individual Object
CRMC_LEAS_ROE_FPField Properties
CRMC_LEAS_ROE_CODetermination of Calculation Schema for Key Figures
CRMC_LEAS_IOCH_TCheck Transition from Product to Individual Object
CRMC_LEAS_COCHCheck Automatic Price Conditions for Manual Entry
CRMC_LEAS_ASSETTText Table for Asset Category
CRMC_LEAS_AFA_TText Table for Depreciation Keys
CRMC_LEAS_ROE_BAFields that Display a Balance (No Payment)
CRMD_FS_MASSMass-Run Objects
CRM_FSL_TIREHTire Service
CRMC_TAX_STAMP3Rules for Calculating Stamp Duty
CRMD_FUELCAAFEEW: Generated Object (Do not Process Manually)
CRMT_CP_KEY_TText Table for Key Table of Change Processes
CRMC_MLR_TESTLimits for Minimum Lease Rate Test
CRMC_LEAS_SO_CPRLeasing Change Processes - Distribution Chain-Specific
CRMC_USEFUL_CTRLFilter for BADI for Normal Useful Life
CRMC_LEAS_DSTRPDAutomatic Product Assignment
CRMC_LEAS_DUR_VLCheck of Lease Term
CRMC_LEAS_AFADepreciation Key
CRM_FSL_FUELFuel Card Service
CRMC_LEAS_ROE_CMClasses for Determination of Payment Flows
CRM_FSL_TIRETire Service