TCACS_ASSGN2 SAP table for – Assignment Table – Contract Type <-> Activity Filter

Here we would like to draw your attention to TCACS_ASSGN2 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). TCACS_ASSGN2 is a SAP standard transp table used for storing Assignment Table – Contract Type <-> Activity Filter related data in SAP. It comes under the package CACS2D.

SAP TCACS_ASSGN2 table

Table TCACS_ASSGN2 technical data

TableTCACS_ASSGN2
Data storingAssignment Table – Contract Type <-> Activity Filter
ModuleICM
Sub ModuleICM
SAP PackageCACS2D
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentEA-APPL
Table CategoryTRANSP

SAP TCACS_ASSGN2 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 TCACS_ASSGN2 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
  • CTRT_TYPE : Commission Contract Type
    Its a key field. Its data type is CHAR (Character String) with field length 3
  • FILTERID : Filter Identification
    Its a key field. Its data type is CHAR (Character String) with field length 8
  • 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
  • .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