SAP Organizational Management Tables

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

Top 10 tables in Organizational Management

TableDescription
CRMC_SEORG_R3MNPMapping: CM Service Org. and SAP S/4HANA Maint. Plan. Plant
CRMC_OMIL_MODELComplete Business Transaction Object Model
CRMC_SORG_R3ORGMapping: Sales Organization and SAP S/4HANA Organization
CRMC_ORGPROFTService ORGMAN: Description of Organizational Data Profile
CRMC_SGRP_R3GRPMapping CM Sales Group and SAP S/4HANA Sales Group
CDB_CL_SALESCDB Table for Sales Attributes to MSA
CRMD_CL_PRODCATTable for Category Transfer to MSA
CDB_CL_SERVICECDB Table for Service Attributes to MSA
CRMD_ORGMANOrganizational Unit Set
CRMC_DIVISIONService ORGMAN: Division

List of tables in Organizational Management

TableDescription
CRMC_SEORG_R3MNPMapping: CM Service Org. and SAP S/4HANA Maint. Plan. Plant
CRMC_OMIL_MODELComplete Business Transaction Object Model
CRMC_SORG_R3ORGMapping: Sales Organization and SAP S/4HANA Organization
CRMC_ORGPROFTService ORGMAN: Description of Organizational Data Profile
CRMC_SGRP_R3GRPMapping CM Sales Group and SAP S/4HANA Sales Group
CDB_CL_SALESCDB Table for Sales Attributes to MSA
CRMD_CL_PRODCATTable for Category Transfer to MSA
CDB_CL_SERVICECDB Table for Service Attributes to MSA
CRMD_ORGMANOrganizational Unit Set
CRMC_DIVISIONService ORGMAN: Division
CRMD_CL_MRKTNGTable for Marketing Attributes to MSA
CRMC_SOFF_R3OFFMapping CM Sales Office and SAP S/4HANA Sales Office
CRMC_SAREA_PROCTAssignment of sales areas to transaction types
CRMC_OMIL_OBJOrganizational Management - Objects
CRMD_CL_SALESTable for Sales Attributes to MSA
CRMC_DISTCHANService ORGMAN: Customizing Distribution Channel
CDB_CL_OMCDB Table for Org. Structure to MSA
CRMD_CL_CHAN_DIVTable for Transfer Distribution Channel/Division to MSA
CRMC_DISTRICT_TCR ORGMAN: Sales Districts: Texts
CRMD_CL_SERVICETable for Service Attributes to MSA
COMC_ORGMANCross Settings for Divisions
CRMC_ORG_BUFFEROrganisational management buffer customizing table
CRMC_DISTRICTService ORGMAN: Sales Districts
CRMD_CL_RELATRelations
CRMD_CL_OMTable for Org. Structure to MSA
CRMC_OMIL_EMPMODComplete Business Transaction Object Model
CRMD_ORGMAN_TEMPTemp. table for storing the org. model Sales area data
CRMC_ORGPROFService ORGMAN: Organizational Data Profile
CRMC_R3_TVAKZSD Sales Area: Valid Assignments for Transaction Types
CRMC_DIVISION_TService ORGMAN: Text Table for CRMC_DIVISION
CRMD_CL_COUNT_MKTable for Category Transfer to MSA
HRT5551Table Section Infotype 5551
CRMC_OMIL_EMPOBJOrganizational Management - Objects
CRMC_DIVICHANService ORGMAN: Combination Distribution Channel and Div.
HRP5551DB Table for Infotype 5551
CRMD_CL_TERRTerritories
CRMC_DISTCHAN_TService ORGMAN: Text Table for CRMC_DISTCHAN
CRMD_CL_TEXTTable for Org. Structure to MSA
CRMD_CL_COUNTRYTable for Transfer Distribution Channel/Division to MSA
CDB_CL_CHAN_DIVCDB Table for Transferring Dist. Channel/Division to MSA