SAP Utilities Industry: Sales Tables

Are you looking for the right table related to SAP Utilities Industry: Sales 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 Utilities Industry: Sales (CRM-IU-S) module.

Top 10 tables in Utilities Industry: Sales

TableDescription
ECRM_ISU_TO_IDXIndex table for service industries technical objects
ECRM_ISU_EUITYPTIS-U Point of Delivery Type Text
ECRM_ISU_CHAVL_QInternal: Mirror Image of Char.Vals. for Quotation Plan Data
ECRM_GRID_X_PRGrid Data from External Source (Product)
ECRM_ISU_ENVDPRTIS-U CIC Locator Profile Definition - Text Table
CRM_ISU_VALRNGHUtilities: Allowed Values for Attributes
ECRM_ISU_CALC01Calculate Variant 1 - Mapping Conditions to Periods
ECRM_ISU_DCOMPDummy Instance for Creating BP for IBase components
ECRM_ISU_ITMTYPEIS-U Item Types
ECRM_GRID_PRCHPrice Determination for Grid Usage

List of tables in Utilities Industry: Sales

TableDescription
ECRM_ISU_TO_IDXIndex table for service industries technical objects
ECRM_ISU_EUITYPTIS-U Point of Delivery Type Text
ECRM_ISU_CHAVL_QInternal: Mirror Image of Char.Vals. for Quotation Plan Data
ECRM_GRID_X_PRGrid Data from External Source (Product)
ECRM_ISU_ENVDPRTIS-U CIC Locator Profile Definition - Text Table
CRM_ISU_VALRNGHUtilities: Allowed Values for Attributes
ECRM_ISU_CALC01Calculate Variant 1 - Mapping Conditions to Periods
ECRM_ISU_DCOMPDummy Instance for Creating BP for IBase components
ECRM_ISU_ITMTYPEIS-U Item Types
ECRM_GRID_PRCHPrice Determination for Grid Usage
ECRM_ISU_CONDAllocate Condition Types to ISU Master Data Gen. Parameters
ECRM_ISU_PPROFPlanning Profile Structure
ISU_SEC_DEPIS-U Security Deposit
ECRM_PROD_TYPEUtilities Product Type
ECRM_ISU_PPROFSElements of a Planning Profile Structur
INDUSTRYSECTORHUtilities: Industry
ECRM_ISU_LOCATTProcessing for Objects in CRM CIC Locator
CRM_ISU_VALCONHUtilities: Conditions for Attributes
A2G_ATTR000003HA2G_ATTR000003H
A2G_ATTR000003A2G_ATTR000003
ECRM_ISU_EUITYPIS-U Point of Delivery Type
CONSUMPTOFFPHUtilities: Consumpt. Off-Peak Rate Meter
CRMC_IU_REL_STATRelevant Status for Display in IC WebClient
BUDGETBILLINGHUtilities: Budget Billing Amount
ECRM_ISU_PPROFTPlanning Profile Structure: Description
ECRM_ISU_LOCPROTIS-U CIC Locator Profile Definition - Text Table
CRM_ISUC_PROFARCArchiving Profiles: Residence Time
CRM_ISUC_PRPROMProfile Determn Procedure
CRM_ISUC_PROFTYPProfile type
CRM_ISUC_PROFTYTProfile Type (Text)
CRM_ISUC_PR_CATPrice Categories in Offer Calculation
CRM_ISUC_PRICATPrice Category
PAYMENTPLANUtilities: Payment Plan
CRM_ISUC_PRFASRTRoles for Profile Allocation (Text)
ISU_SEC_DEPHIS-U Security Deposit
ECRM_GRID_X_PRHGrid Data from External Source (Product)
CONSUMPTONPHUtilities: Consumption Peak Rate Meter
CRM_ISU_PRODProduct Proposal for Utilities
BUDGETBILLINGUtilities: Budget Billing Amount
CRM_ISU_GROUPSHUtilities: Result Groups
CRM_ISUC_EGRIDLTGrid Level Types
ECRM_ISU_LOCPROFIS-U CIC Locator Profile Definition
CONSUMPTONPUtilities: Consumption Peak Rate Meter
ISU_PODHISU Point of Delivery
ECRM_ISU_PPROFSTElements of a Planning Profile Structure: Description
CRM_ISUC_PRFASRRoles for Profile Allocation
ECRM_ISU_CALC0HSelection Type of Price Calculation
CRM_ISUD_EPROFHTProfile Header Data (Text)
ISU_POD_X_GRIDHExternal Grid Data for Point of Delivery
CRM_ISUD_EPROFVMProfile Values (12 Months for a Year)
ECRM_ISU_ENVPROTIS-U CIC Locator Profile Definition - Text Table
PAYMENTPLANHUtilities: Payment Plan
ECRM_ISU_TESPTIS-U Allocation of Division to Division Category
CRM_ISUC_RTPINTRTP Interface (Header Data)
ECRM_ISU_ENVPROFIS-U CIC Locator Profile Definition
CRM_ISUC_TE222Consumption Types
CRM_ISU_PDETHUtilities: Product Details
ECRM_ISU_TSPATIS-U Organizational Unit: Sales Division Texts
ECRM_ISU_ENVDPRFIS-U CIC Locator Profile Definition
ECRM_ISU_GRIDGrid Data
CRM_ISUD_EPROFVYProfile Value (for Example, for a year)
CONSUMPTOFFPUtilities: Consumpt. Off-Peak Rate Meter
CRM_ISU_ATTR2HUtilities: Product Configuration Attributes
ECRM_ISU_TE102TIS-U Premise Types (Texts)
CRM_ISUC_PROPROCProfile Scheme (Item)
ECRM_ISU_PRCPARParameter Names of Prices in ISU Master Data Generator
CRMC_PACK_TYPESUtilities Package Types
ECRM_ISU_PAR_TOSI Specific CRM Paramters for technical objects
ECRM_ISU_OPPTYPActivity Types for IS-U Sales Methodology
ECRM_OUTL_CONTHProduct for Outline Agreement Assignment
CRM_ISUC_SIZEOBJPermitted Classes for Intervals per Repository
CRM_ISU_VALCONUtilities: Conditions for Attributes
CRM_ISUC_EGRDLTTTexts for Grid Level Types
ECRM_OUTL_CONTProduct for Outline Agreement Assignment
CRM_ISU_BRFHUtilities: BRFplus Rules Assignment
CRM_ISUC_STAT_IEConvert Profile Value Status from External to Internal
CRM_AMI_PRODSupport of AMI capabilities in CRM
CONSUMPTUtilities: Consumption Single-Rate Meter
ECRM_ISU_EVBSUtilities industry-> CRM premise
CRM_ISUC_STATVETExternal Status for Profile Values
ISU_POD_X_GRIDExternal Grid Data for Point of Delivery
CRM_ISUC_DAYOFFSDay Offset EDM
CRM_ISU_PDETUtilities: Product Details
ECRM_ISU_GRIDHGrid Data
ECRM_ISU_CALC0Selection Type of Price Calculation
CRM_ISUC_TE222TConsumption Type Texts
CRM_ISUC_PRFVCATProfile Value Category
CRMC_BCONT_CATEGContact Category Mapping
CRM_ISUC_CONSOBJProfile and Consumption Repository
ISU_EXT_POSIS-U Contract Enhancement
CRM_ISU_PRODHProduct Proposal for Utilities
ECRM_PROD_TYPEHUtilities Product Type
ECRM_ISU_DOCACTIS-U WIN-IC Office Integration -> Activity Definition
CRM_ISU_VALRNGUtilities: Allowed Values for Attributes
CRM_ISUC_RTPINTTRTP Interface (Header Data - Text)
CRM_ISU_BRFUtilities: BRFplus Rules Assignment
CRM_ISUC_PRPROMTProfile Scheme Description
CRM_ISUC_PR_CONDMapping Price Categories to Condition Types
ISU_PROFILEProfile Header
ECRM_ISU_TSPAIS-U Organizational Unit: Sales Division
CRMC_ISU_GROUPUtilities: Product Determination Groups
CRM_ISU_VERSUtilities: Product Version
ISU_PODISU Point of Delivery
ECRM_ISU_PRCPARTParameter Names of Prices in ISU Master Data Generator
CRM_ISU_ATTR2Utilities: Product Configuration Attributes
CRM_ISU_GROUPSUtilities: Result Groups
CONSUMPTHUtilities: Consumption Single-Rate Meter
CRM_ISUD_EPROFVDProfile Values (31 Days for a Month)
CRM_ISUC_TE369TDescription of Voltage Level
CRM_ISUC_PROFCTTProfile Categories (Text)
CRM_ISUC_STAT_EIConvert Profile Value Status from Internal to External
CRM_ISUC_PRICATTPrice Category
CRM_ISUD_EPROFHProfile Header Data
CRM_ISUD_EPROFVProfile Values (Unspecified Interval)
CRM_ISU_PACKUtilities: Package Attributes
CRM_ISUC_PROPROTProfile Scheme (Item) - Description
CRM_ISUC_INTSIZEInterval Lengths
CRM_AMI_PRODHSupport of AMI capabilities in CRM
CRM_ISU_CUST_PRODefine Mandatory and Optional Fields for Product Proposal
ECRM_SI_TSPAService Industries: Settings for Service Types
CRM_ISUC_CONSOBTConsumption Object Type: Description
CRM_ISUC_PRFVCTTProfile Value Category (Text)
CRMC_ISU_GROUP_TUtilities: Descriptions of Product Determination Groups
CRM_ISUC_DAYOFFTDay Offset EDM
ECRM_ISU_DOCFBTIS-U Win-IC Office Integration -> Functions for Field Data
CRM_ISU_AMI_CUSTCustomizing for the visibility of the AMI capabilities
CRM_ISUC_TE369Voltage Level
CRM_ISUC_VC_MASSDefine Unit of Measmnt./Places for Prof.Val.Cat.and Division
ECRM_GRID_PRCPrice Determination for Grid Usage
ISU_PROFILEHProfile Header
CRM_ISU_PACKHUtilities: Package Attributes
ECRM_ISU_LOCATProcessing for Objects in CRM CIC Locator
CRM_ISUC_STATVEXExternal Status for Profile Values
CRM_ISUC_PR_CATTDescription of Price Categories in Offer Calculation
CRM_ISUC_INTSIZTInterval Sizes for Profiles (Text)
INDUSTRYSECTORUtilities: Industry
CRM_ISU_VERSHUtilities: Product Version
CRM_ISUC_DIMACustomizing Table for DIMa Checks (On/Off)
ECRM_ISU_PROCTYPIS-U Transaction Type
CRM_ISUC_PRFGRPProfile Groups
ECRM_ISU_TE102IS-U Premise Types
CRM_ISUC_PRFGRPTProfile Groups - Text
CRM_ISUC_GR_DESTRFC Destination for Access to IS-U Grid Management
ISU_EXT_POSHIS-U Contract Enhancement
CRM_ISUC_PROFCATProfile Categories