The CDB_CL_SALES table in SAP ERP or S/4HANA stores CDB Table for Sales Attributes to MSA data. There are total 16 fields in CDB_CL_SALES table. The CDB Table for Sales Attributes to MSA table is available in all major SAP S/4HANA versions, is implemented as a Column Store table within the SAP HANA database. Additionally we provide an overview of the structure and fields of CDB_CL_SALES table. It is in CBD Tables and Structures for Download OrgStructure to MSA (CDB_CLIENT_OM) ABAP package and is part of the Organizational Management (CRM-MD-ORG) module.
SAP CDB_CL_SALES Table Fields
Following is the list of fields that are available in SAP CDB_CL_SALES table. The primary key fields of CDB Table for Sales Attributes to MSA table in SAP are CLIENT (Client), GUID (GUID for Sales Attribute Record).
| Field | Description | Data Element | Check Table | Data Type |
|---|---|---|---|---|
| CLIENT | Client | MANDT | CLNT (3) | |
| GUID | GUID for Sales Attribute Record | CDB_CL_OM_GUID_SALES | RAW (16) | |
| GUID_ORGUNIT | Object GUID | CDB_CL_OM_GUID_ORGOBJ | CRMD_CL_OM | RAW (16) |
| OTYPE | Object Type | OTYPE | * | CHAR (2) |
| OBJID | Object ID | OBJEKTID | NUMC (8) | |
| BEGDA | Start Date | BEGDATUM | DATS (8) | |
| ENDDA | End Date | ENDDATUM | DATS (8) | |
| SALES_ORG | Sales Organization ID | CRMT_SALES_ORG | CHAR (14) | |
| SALES_OFFICE | Sales Office | CRMT_SALES_OFFICE | CHAR (14) | |
| SALES_GROUP | Sales Group | CRMT_SALES_GROUP | CHAR (14) | |
| VKORG | Sales Organization | VKORG | CHAR (4) | |
| IS_VKORG | Indicator: Sales Organization | CDB_CL_OM_SALES_IS_VKORG | CHAR (1) | |
| VKBUR | Sales office | VKBUR | * | CHAR (4) |
| VKGRP | Sales group | VKGRP | * | CHAR (3) |
| SALES_CURRENCY | Currency | CRMT_CURRENCY | * | CUKY (5) |
| COUNTRY | Country | KLAND | * | CHAR (3) |
