1. SAP Tutorial
  2. HR Module

CACS_RETAGR SAP table for – Individual Retention Agreement in Commission Contract

Here we would like to draw your attention to CACS_RETAGR 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_RETAGR is a SAP standard transp table used for storing Individual Retention Agreement in Commission Contract related data in SAP. It comes under the package CACSR5.

SAP CACS_RETAGR table

Table CACS_RETAGR technical data

TableCACS_RETAGR
Data storingIndividual Retention Agreement in Commission Contract
ModuleICM
Sub ModuleICM
SAP PackageCACSR5
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

SAP CACS_RETAGR 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_RETAGR 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
  • CTRTBU_ID : Commission Contract Number
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • RETAGR_ID : Number of Retention Agreement
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 12
  • 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
  • RETRU_ID : Identification of Retention Rule
    Its data type is CHAR (Character String) with field length 4
  • 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
  • .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

    • CACS_RETAGR related tables

    • CACS_RETAGR : Individual Retention Agreement in Commission Contract
    • TCACS_RETRUT : Name of Retention Rule
    • TCACS_RETRU : Retention Rule
    • TCACS_RETREM : Assignment of Remun.Type to Retention Rule Characteristics
    • TCACS_STRETRU : Characteristic Attributes of Retention Rule
    • TCACS_STRETRUT : Name of Characteristic Attributes of Retention Rule
    • CACS_RET_ATIME : Retention: Last access time-spot in process

    Related References

    Related Tutorials

    CACS_PRAGR SAP table for – Indiv. Payment Release Agreement for Commission Contract

    CACS_PRAGR table in SAP HR ICM (Incentive and Commission Management) module. This table is used for storing data of Indiv....

    CACS_STCAGR SAP table for – Standard agreement for commission contract

    CACS_STCAGR table in SAP HR ICM (Incentive and Commission Management) module. This table is used for storing data of Standard...

    TCACS_ARCH_CAS SAP table for – Commission Case Archiving: Min. Retention Period in System

    TCACS_ARCH_CAS table in SAP HR ICM (Incentive and Commission Management) module. This table is used for storing data of Commission...

    TCACS_ARCH_DOC SAP table for – Commission Doc Archiving: Min. Retention Period in System

    TCACS_ARCH_DOC table in SAP HR ICM (Incentive and Commission Management) module. This table is used for storing data of Commission...

    CACS_STCAGR_B SAP table for – Standard Agreement for Commission Contract – Backup

    CACS_STCAGR_B table in SAP HR ICM (Incentive and Commission Management) module. This table is used for storing data of Standard...

    TCACS_RETRU SAP table for – Retention Rule

    TCACS_RETRU table in SAP HR ICM (Incentive and Commission Management) module. This table is used for storing data of Retention...

    TCACS_RETREM SAP table for – Assignment of Remun.Type to Retention Rule Characteristics

    TCACS_RETREM table in SAP HR ICM (Incentive and Commission Management) module. This table is used for storing data of Assignment...

    «
    »