/MAP/TS_ADASORT SAP table for – Help Table for Search Help Assortments by Type and Dimension

Here we would like to draw your attention to /MAP/TS_ADASORT 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). /MAP/TS_ADASORT is a SAP standard transp table used for storing Help Table for Search Help Assortments by Type and Dimension related data in SAP. It comes under the package /MAP/P04.

SAP /MAP/TS_ADASORT table

Table /MAP/TS_ADASORT technical data

Table/MAP/TS_ADASORT
Data storingHelp Table for Search Help Assortments by Type and Dimension
ModuleBW
Sub ModuleBW-BCT-PLA-RAP
SAP Package/MAP/P04
Delivery ClassA – Application table (master and transaction data)
ComponentBI_CONT
Table CategoryTRANSP

SAP /MAP/TS_ADASORT 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 /MAP/TS_ADASORT table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • .INCLUDE : Screen Fields When Creating an Assortment
  • RT_ASORT : Assortment
    Its data type is CHAR (Character String) with field length 10
  • RT_ASORTT : Description
    Its data type is CHAR (Character String) with field length 40
  • DISTR_CHAN : Distribution Channel
    Its data type is CHAR (Character String) with field length 2
  • DISTR_CHANTXT : Description
    Its data type is CHAR (Character String) with field length 40
  • SALESORG : Sales Organization
    Its data type is CHAR (Character String) with field length 4
  • SALESORGTXT : Description
    Its data type is CHAR (Character String) with field length 40
  • CM_CDTND : Hierarchy Node
    Its data type is CHAR (Character String) with field length 18
  • CM_CDTNDTXT : Description
    Its data type is CHAR (Character String) with field length 40
  • RF_ASTYP : Assortment Type
    Its data type is CHAR (Character String) with field length 4
  • RF_ASTYPT : Description
    Its data type is CHAR (Character String) with field length 40
  • RF_DIM1S : Description
    Its data type is CHAR (Character String) with field length 40
  • RF_DIM2S : Description
    Its data type is CHAR (Character String) with field length 40
  • RF_DIM3S : Description
    Its data type is CHAR (Character String) with field length 40
  • RF_DIM1 : Dimension
    Its data type is CHAR (Character String) with field length 4
  • RF_DIM2 : Dimension
    Its data type is CHAR (Character String) with field length 4
  • RF_DIM3 : Dimension
    Its data type is CHAR (Character String) with field length 4
  • RF_DIM1TXT : Description
    Its data type is CHAR (Character String) with field length 40
  • RF_DIM2TXT : Description
    Its data type is CHAR (Character String) with field length 40
  • RF_DIM3TXT : Description
    Its data type is CHAR (Character String) with field length 40
  • CM_HIEID : Hierarchy
    Its data type is CHAR (Character String) with field length 2
  • CM_HIEIDTXT : Description
    Its data type is CHAR (Character String) with field length 40
  • RT_MDRELST : Release Status
    Its data type is CHAR (Character String) with field length 1
  • CM_CDT1 : Hierarchy Node
    Its data type is CHAR (Character String) with field length 18
  • CM_CDT2 : Hierarchy Node
    Its data type is CHAR (Character String) with field length 18
  • CM_CDT3 : Hierarchy Node
    Its data type is CHAR (Character String) with field length 18