CACS_PS_SP SAP table for – Assignment of Distribution Rates to Partnership

Here we would like to draw your attention to CACS_PS_SP table in SAP. As we know it is being mainly used with the SAP ICM (Incentive and Commission Management) component which is coming under HR (HCM) ICM module (Incentive and Commission Management). CACS_PS_SP is a SAP standard transp table used for storing Assignment of Distribution Rates to Partnership related data in SAP. It comes under the package CACSP1.

SAP CACS_PS_SP table

Table CACS_PS_SP technical data

TableCACS_PS_SP
Data storingAssignment of Distribution Rates to Partnership
ModuleICM
Sub ModuleICM
SAP PackageCACSP1
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CACS_PS_SP 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 CACS_PS_SP table.

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • APPL : Commission Application (ICM)
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • CTRTBDL_ID : Contract Bundle Number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • SPLIT_ID : Number of Distribution Ratio
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • PS_LEAD : Commission Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • PS_MEMBER : Commission Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • VERSION : Version of Master Data or Customizing Object
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 6
  • SPLIT_VALUE : Share: Percentage or Ratio
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 10
  • .INCLUDE : Version Management for Master Data
  • .INCLUDE : Version Management for Customizing Data
  • BUSI_BEGIN : Effective from
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • BUSI_END : Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss)
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • TECH_BEGIN : Technically Valid From
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • TECH_END : Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss)
    Its data type is NUMC (Character String with Digits Only) with field length 14
  • FLG_CANCEL_OBJ : Indicator: Object is Invalid
    Its data type is CHAR (Character String) with field length 1
  • FLG_CANCEL_VERS : Indicator: Version is Invalid
    Its data type is CHAR (Character String) with field length 1
  • .INCLUDE : Comn: Process Administration/Version Management
  • .INCLUDE : Change Log for Object
  • CHG_TCODE : Transaction in Which the Change Was Made
    Its data type is CHAR (Character String) with field length 20
  • CHG_USR : Last user to change object
    Its data type is CHAR (Character String) with field length 12
  • TRI_METH_TYP : Triggering Method
    Its data type is CHAR (Character String) with field length 1
  • TRI_METH_TARGET : Processing Target of Triggering Method
    Its data type is CHAR (Character String) with field length 1
  • STATUS_VERSION : Object Version Status
    Its data type is CHAR (Character String) with field length 1
  • STATUS_WORK : Object Version Processing Status
    Its data type is CHAR (Character String) with field length 1