The complete list of SAP Tables in Customer Relationship Management -> Mobile Sales module. The most commonly used Tables are at the top of the list. Click on a sub-module to see the Tables specific to that module.

CRM-MSA General Tables

There are 3357 Tables in Mobile Sales module. View the full list here: SAP CRM-MSA General Tables

Rank Table Description Table Type
1 SMOKNA1 General Data in Customer Master Transparent Table
2 PMNTTRMS CDB Customers: Terms of Payment Transparent Table
3 SMOUSERS Users Transparent Table
4 SMOMITABT Employee Master Transparent Table
5 SMOKVBEZ11 Interlinkage Activity - Employee Transparent Table
6 SMOKNA1SHT Business Partner Short-File Transparent Table
7 SMOMITAREA Employee: Default Sales Area and Field Defaults Transparent Table
8 SMOVBAK Sales Document: Header Data Transparent Table
9 SMOADRC Addresses (central address admin.) Transparent Table
10 SMOREPMA Report: Header File Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-MSA General Tables
Go to top

Employees Tables (CRM-MSA-EMP)

There are 8 Tables in Employees module.

Rank Table Description Table Type
1 SMOUSERS Users Transparent Table
2 SMOMITABT Employee Master Transparent Table
3 SMOOLDPASSWD SMOOLDPASSWD Transparent Table
4 SMOPWDCUST SMOPWDCUST Transparent Table
5 SMOPWDCUSTTXT SMOPWDCUSTTXT Transparent Table
6 SMOCOMMFDS Communication Fields for Mobile Sales/Service Structure
7 SMOADMFLDS Record Modification Fields for Mobile Sales/Service Structure
8 SMO_ADDRES Address Structure for Employees Structure
View the full list of SAP CRM-MSA Employees Tables (CRM-MSA-EMP)
Go to top

Territory Management Tables (CRM-MSA-TER)

There are 17 Tables in Territory Management module. View the full list here: SAP CRM-MSA Territory Management Tables (CRM-MSA-TER)

Rank Table Description Table Type
1 SMOTERR Territories Transparent Table
2 SMORELTER1 Assignments of caps to territories Transparent Table
3 SMORELTER2 Assignments of employees to territories Transparent Table
4 SMOTERHIER Territory Hierachy Transparent Table
5 SMOTERTXT table for maintaining langauge dependent desc. of terr Transparent Table
6 SMOCONEW Structure for new comparing data Structure
7 SMOCOOLD Structure for old comparing data Structure
8 SMOHIST structure for comparing changes on hierachy level Structure
9 SMOHPUB_ACTIVE Generated Table for View SMOHPUB_ACTIVE General View Structure
10 SMONEPA Parameters for territory management Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-MSA Territory Management Tables (CRM-MSA-TER)
Go to top

Adapters Mobile Sales Tables (CRM-MSA-ADP)

There are 673 Tables in Adapters Mobile Sales module. View the full list here: SAP CRM-MSA Adapters Mobile Sales Tables (CRM-MSA-ADP)

Rank Table Description Table Type
1 CRM_SEM_TMP Test opportunities and campaigns for download to mobile Transparent Table
2 CRM_SEM_LAYOUT Layout dependencies Transparent Table
3 SMOPARADP Mobile Adapter parameter Transparent Table
4 CDB_ORD_ARC_OBJ Transactions deleted in deletion job Transparent Table
5 MIG_SAD_UPLOAD Maintain GUIDS and Blocks of SalesDoc Upload from CDB to CRM Transparent Table
6 MIG_OPP_CLASSI Mapping Table for Opportunities Migration: CLASSI (Header) Transparent Table
7 CDBUPG_DBLOG Table to store db changes from 30 to 40 Transparent Table
8 MIG_BPGUID Mapping table for BP/EMP migration Transparent Table
9 MIG_ACT_RELTYP_E Mapping table for SMOKVBEZ11 table migration Transparent Table
10 CDB_ORD_ARC_SEL CDB Order Reorganization: selection data Transparent Table
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-MSA Adapters Mobile Sales Tables (CRM-MSA-ADP)
Go to top

Activity Tables (CRM-MSA-ACT)

There are 81 Tables in Activity module. View the full list here: SAP CRM-MSA Activity Tables (CRM-MSA-ACT)

Rank Table Description Table Type
1 CRMM_PLANOGRAM Planogram Header details Transparent Table
2 PLNSETTYPE Products Attribute for Planogram PPR Transparent Table
3 ACT_PRDHA_MV_DS Struct. for Maintaining Attribute ACT_PR Structure
4 ACT_PRDHA_MV_S Struct. for Maintaining Attribute ACT_PR Structure
5 ACT_SENDSTA_MV_DS Struct. for Maintaining Attribute ACT_SE Structure
6 ACT_SENDSTA_MV_S Struct. for Maintaining Attribute ACT_SE Structure
7 CRMC_PL_XML Planogram -Product Attribute XML Transparent Table
8 CRMT_PLANOGRAM_BU_PARTNER Business Partner for Planogram:messaging Structure Structure
9 CRMT_PLANOGRAM_BU_PARTNER_COM Business Partner for Planogram:messaging Structure Structure
10 CRMT_PLANOGRAM_H_COM Communication Structure for Planogram Header data Structure
.... ......... ........................................................... .........
.... ......... ........................................................... .........
View the full list of SAP CRM-MSA Activity Tables (CRM-MSA-ACT)
Go to top