CMSKU SAP table for – Table for CDT-SKU Assignments

Here we would like to draw your attention to CMSKU table in SAP. As we know it is being mainly used with the SAP BW-BCT (Business Content and Extractors in BW) component which is coming under BW module (Business Warehouse). CMSKU is a SAP standard transp table used for storing Table for CDT-SKU Assignments related data in SAP. It comes under the package RS_AA_CM.

SAP CMSKU table

Table CMSKU technical data

TableCMSKU
Data storingTable for CDT-SKU Assignments
ModuleBW
Sub ModuleBW-BCT-CPG-CMC
SAP PackageRS_AA_CM
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

SAP CMSKU Table Fields

Here is the details of each fields in this SAP table. You can find the discription, data type and assigned lenth of each of the fields in CMSKU table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • MATERIAL : Material Number
    Its a key field. Its data type is CHAR (Character String) with field length 18
  • HIER_ID : Hierarchy ID
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • STRATEGY : Node Strategy
    Its data type is CHAR (Character String) with field length 20
  • CDT1 : Category
    Its data type is CHAR (Character String) with field length 18
  • CDT2 : Subcategory
    Its data type is CHAR (Character String) with field length 18
  • CDT3 : Segment
    Its data type is CHAR (Character String) with field length 18
  • CDT4 : Subsegment
    Its data type is CHAR (Character String) with field length 18
  • CDT5 : Sub-Subsegment
    Its data type is CHAR (Character String) with field length 18
  • CDT6 : Product Group
    Its data type is CHAR (Character String) with field length 18
  • CDT7 : Brand
    Its data type is CHAR (Character String) with field length 18
  • VKORG : Sales Organization
    Its data type is CHAR (Character String) with field length 4
  • VTWEG : Distribution Channel
    Its data type is CHAR (Character String) with field length 2
  • SHLFSPC : CM: Shelf Space
    Its data type is QUAN (Quantity field) with field length 9
  • LINSPC : CM: Contact Area
    Its data type is QUAN (Quantity field) with field length 9
  • SPACEUNIT : CM: Shelf Space Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • LINUNIT : CM: Contact Area Unit
    Its data type is UNIT (Unit key for a Quantity field) with field length 3
  • CHKDATE : CM: Key Date for Space Analyses
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8