TCACS_STRETRU SAP table for – Characteristic Attributes of Retention Rule

Here we would like to draw your attention to TCACS_STRETRU 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_STRETRU is a SAP standard transp table used for storing Characteristic Attributes of Retention Rule related data in SAP. It comes under the package CACSR5.

SAP TCACS_STRETRU table

Table TCACS_STRETRU technical data

TableTCACS_STRETRU
Data storingCharacteristic Attributes of Retention Rule
ModuleICM
Sub ModuleICM
SAP PackageCACSR5
Delivery ClassE – System table whose data is transported with its own transport objects
ComponentEA-APPL
Table CategoryTRANSP

SAP TCACS_STRETRU 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_STRETRU 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
  • AGR_TYP : Agreement Type
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • STCAGR_ID : Standard Agreement Number
    Its a key field. Its data type is CHAR (Character String) with field length 12
  • RETRU_ID : Identification of Retention Rule
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • 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
  • MAX_AMNT : Maximum Retention Amount
    Its data type is CURR (Currency Field) with field length 15
  • PERCENT : Percentage of Retention
    Its data type is DEC (Packed number (number with fixed number of decimal places)) with field length 8
  • THRESHOLD : Threshold Value for Retention
    Its data type is CURR (Currency Field) with field length 15
  • RULE_ID : Period Rule
    Its data type is CHAR (Character String) with field length 7
  • FLG_OFFSET : Indicator for Offsetting Recalls
    Its data type is CHAR (Character String) with field length 1
  • FLG_ADVANCE : Indicator for Advances Allowed (Not Used)
    Its data type is CHAR (Character String) with field length 1
  • .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