A197 SAP table for – Anwendung/CACS_COM_C/Ind. Sekt./Version/Status

Here we would like to draw your attention to A197 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). A197 is a SAP standard transp table used for storing Anwendung/CACS_COM_C/Ind. Sekt./Version/Status related data in SAP. It comes under the package CRM001.

SAP A197 table

Table A197 technical data

TableA197
Data storingAnwendung/CACS_COM_C/Ind. Sekt./Version/Status
ModuleICM
Sub ModuleICM
SAP PackageCRM001
Delivery ClassA – Application table (master and transaction data)
ComponentEA-APPL
Table CategoryTRANSP

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

  • MANDT : Client
    Its a key field. Its data type is CLNT (Character with length 3) with field length 3
  • KAPPL : Application
    Its a key field. Its data type is CHAR (Character String) with field length 2
  • KSCHL : Condition Type
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • P_CACSAPPL : Commission Application (ICM)
    Its a key field. Its data type is CHAR (Character String) with field length 6
  • CATEGORY_ID : Category ID
    Its a key field. Its data type is CHAR (Character String) with field length 20
  • INDUSTRY : Industry Sector
    Its a key field. Its data type is CHAR (Character String) with field length 4
  • P_VERSION : Version Date as Timestamp
    Its a key field. Its data type is NUMC (Character String with Digits Only) with field length 14
  • DATBI : Validity end date of the condition record
    Its a key field. Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • DATAB : Validity start date of the condition record
    Its data type is DATS (Date (Date: YYYYMMDD)) with field length 8
  • P_STATE : Condition Record Status
    Its data type is CHAR (Character String) with field length 1
  • KNUMH : Condition record number
    Its data type is CHAR (Character String) with field length 10