SAP Products Tables

Are you looking for the right table related to SAP Products 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 Products (CRM-MD-PRO) module.

Top 10 tables in Products

TableDescription
CRM_PR_REST_INHandling Indicator
COMM_IL_PCKI_HHistory Table for COMM_IL_PCKI
COMM_IL_NEWPR_HOriginal Parts of Remanufactured Parts History Table
CRMM_PR_SRVENTHEntitlement
CRM_TR_CONTROLTransaction Control Parameter
COMM_IL_ENSUB_HObsolete (Substitute Entitlement History Table)
COMM_IL_CORE_HUsed Parts History Table
COMM_PR_FRG_RODProduct Sales Set - Product - Assignment
CRMC_PRD_OBJTYPEDefine Object Type Determination
CRMC_PRD_OBJSTYPDefine Object Subtype Determination

List of tables in Products

TableDescription
CRM_PR_REST_INHandling Indicator
COMM_IL_PCKI_HHistory Table for COMM_IL_PCKI
COMM_IL_NEWPR_HOriginal Parts of Remanufactured Parts History Table
CRMM_PR_SRVENTHEntitlement
CRM_TR_CONTROLTransaction Control Parameter
COMM_IL_ENSUB_HObsolete (Substitute Entitlement History Table)
COMM_IL_CORE_HUsed Parts History Table
COMM_PR_FRG_RODProduct Sales Set - Product - Assignment
CRMC_PRD_OBJTYPEDefine Object Type Determination
CRMC_PRD_OBJSTYPDefine Object Subtype Determination
CRMC_PRD_CHANGEProduct Data Changeability Dependent on Log. System via BAdI
COMM_IL_ENSUBObsolete (Substitute Entitlement Products)
CRMC_PRIL_OBJRELObject Model with Dynamic Object Relationships
BDSCONT22BDS: Table for Document Contents (Import/Export)
BDSPHIO22BDS: Instances of Physical Information Objects
CRMS_PRIL_OKTXTDescription of Object Types
CRMM_PRREFOBJProduct - Subject - Set
COMC_OLTP_DATACluster database for CRM-OLTP download (import/export data)
COMM_IL_EXGRP_HHistorical Data of Relationship Type Exchange Group
COMM_IL_STRDISRelationship "Display Products"
BDSPHPR22BDS: Attributes of Physical Information Objects
COMM_PRMATHProduct - Material Set History
COMM_PR_FRG_REOProduct - Organization Set - Assignment
COMM_PR_FRG_RODHProduct Sales Set - Product - Assignment History
COMM_IL_REMAN_HRemanufactured Parts History Table
CRMC_PRIL_ILCustomizing Table for Relationship Type Interface
CRM_SERIALNUMSerial number processing in Service
CRMC_HNDLCODEHandling Indicator
BDSCHKO22BDS: Check-Out Data for a Physical Information Object
CRMM_PR_SRVENTEntitlement
CRM_EXT_OBJProduct Extensibility - OBJECT
CRMC_PLSRVRelationship Types for Product Proposal Service
CRMM_PR_SUCCESSHSuccess Rate History
CRMM_PR_SUCCESSSuccess Rate
CRMC_PRIL_UIUOverview Pages Assign. for Objects (Settype / Relation)
COMM_IL_EXGRPMaster Data of Relationship Type Exchange Group
CRMC_HNDLCODE_THandling Indicator Description
CRMC_PRIL_STORELDefinition of Static Object Relations
COMM_IL_STRPRPRelationship "Prepack Products"
COMM_IL_COREUsed Parts
BDSLOIO22BDS: Instances of Logical Information Objects
CRMM_PR_SRVRRHService Product - Resource Requirement Set History
CRMC_PRDXI_TRIGGTrigger XI outbound for product/product relations
COMM_PRMATProduct Material Data
CRMM_PRSALESAssignment, Which Distrib.Chains Are Maintained for Products
COMM_IL_REMANRemanufactured Parts
CRMC_ITEM_INSPItem Inspection
CRMM_PR_SALESGHProduct - Sales Pricing Set - History
COMM_PR_BOMProduct-BOM Assignment
CRMM_PR_BTRService Product - Business Transaction Parameter Set
CRMS_PR_SUBSETDefinition of settypes with substractive function enabled
CRMM_R3_VARIANTTemporary Data on Variant Filtering
COMM_PRSRVProduct-Service-Set
CRMM_PR_SRVDURService Product - Duration of Execution Set
CRM_EXT_SRVProduct Extensibility - SERVICE
CRM_EXCH_BUSHEntitlements
BDSPHF22BDS: Files of Physical Information Objects
CRM_SERIALNUMHSerial number processing in Service
COMM_IL_NEWPROriginal Parts of Remanufactured Parts
CRMT_IL_SRVPRCCustomizing Table for Service Processes
BDSLORE22BDS: Outgoing Relationships of Logical Information Objects
CRMC_MINITP_RODWrapping of Several Mini-Templates by a Sales Chain (ROD)
BDSLOIOT22BDS: Descriptions of Logical Information Objects
COMM_IL_STRDIS_HHistory of Relationship "Display Products"
CRMC_ITEM_INSP_TItem Inspection Description
BDSPHNM22BDS: Use of Target Anchors in Physical Objects
CRM_PR_REST_INHHandling Indicator
CRM_EXT_SRVHProduct Extensibility - SERVICE
COMM_PRSRVHProduct-Service-Set-History
BDSLOPR22BDS: Attribute Values of Logical Information Objects
CRMC_TAX_ALLOCR/3 to CRM Assignment Table for Taxes
CRMS_PRIL_OBJORGDefinition of Object Organization Type Assignment
CRM_EXT_CMPProduct Extensibility - COMPETITOR
BDSRE22BDS: Relationship Instances
COMM_PR_FRG_REOHProduct - Organization Set - Assignment History
CRMS_PR_BDOCFixed Values for Product Types During Product Download
CRMC_PRIL_OBCLASAssigning Handling Class to Object
COMC_PR_TEXT_MProduct Master Key Conversion to CRM
CRMS_PRIL_OBKINDDefinition of Object Types
BATCHESHBatches
CRMM_PR_SRVRRService Product - Resource Requirement Set
COMC_PR_COND_GRTText Table for Group for Condition Maintenance
COMM_IL_STRSETRelationship "Set Products"
CRMM_PR_SRVDURHService Product - Duration of Execution Set History
CRMM_PR_SALESAHProduct - Sales Order Set - History
COMC_R3MAPCPCharacteristic profile mapping table
BDSPHHR22BDS: Outgoing Hyperlinks from Physical Objects
CRM_EXT_OBJHProduct Extensibility - OBJECT
COMC_PR_TEXT_P_OObject Family, Text Object -> Text Determ. Proc
COMC_PRTYP_CUSTCustomizing Settings for Product Types - Content Management
CRMS_PRIL_OKSETHandling Class for Set Types
BDSLORI22BDS: Incoming Relationships of Logical Information Objects
BDSCHKF22BDS: File Name for Last Check-Out
BATCHESBatches
BDSREPR22BDS: Relationship Attributes
CRM_EXCH_BUSEntitlements
CRMC_PRIL_METHODMethods for Objects of Product Interaction Layer
COMM_IL_PCKIProduct - Business Partner Relationship (PCKI)
CRM_TR_CONTROLHTransaction Control Parameter
CRM_EXT_MATProduct Extensibility - MATERIAL
CRMC_PRSEA_ATTRExtension of Product/Object Search
COMC_PR_TEXT_PProduct Master Text Types Allowed for Product Type
CRMM_PR_BTRHService Product - Bus. Transaction Parameter Set History
CRMC_PRIL_COMPComponents assigned to product type
COMC_PR_COND_GRPGroup for Condition Maintenance
BDSPHRE22BDS: Outgoing Relationships of Physical Information Objects
CRMC_PRIL_OBJTXTObject Relations Description
COMM_IL_STRSET_HHistory of Relationship "Set Products"
CRMC_TVMSInterpretation of Sales Status
BDS_CON022BDS: Link Table
CRM_CR_CONTROLHControl Parameters: Complaints/Returns
CRM_CR_CONTROLControl Parameters: Complaints/Returns
CRMC_MINITP_RODHWrapping of Several Mini-Templates by a Sales Chain (ROD)
CRM_EXT_MATHProduct Extensibility - MATERIAL
CRM_EXT_CMPHProduct Extensibility - COMPETITOR
CRMM_PR_FRGKEY01CRM: Product - Differentiation Key (Type 01)
COMM_PR_BATCHBatches
CRMC_PR_SUBTRACConfiguration table to control subtraction in request load
COMM_PR_BATCHHBatches
COMM_IL_STRPRP_HHistory of Relationship "Prepack Products"
CRMM_PRREFOBJHProduct - Subject - Set - History
CRMC_PRODUCT_UICustomizing for Product UI
CRMM_PR_SALESAProduct - Sales Order Set
CRMM_PR_SALESGProduct - Sales Pricing Set
CRMM_PRSALESHHistory: Assignment of Distribution Chains to Products
CRMM_PRICE_PRODTemporary Data for Determining Pricing Reference Products
CRMC_PRIL_OBJAssignment of Interaction Layer Objects to CRM Objects
BDSPHRI22BDS: Incoming Relationships of Physical Information Objects