| Column | Field | Description | SQL Type | Length | Decimals | SAP Type | Default Value | Null Allowed | CheckTable | Rollname | SQL Create Statement |
|---|
| 1 | MANDT | Client | nvarchar | 3 | 0 | CLNT | (N'000') | No | * | MANDT | Allow NULL? |
| 2 | APPL | Commission Application (ICM) | nvarchar | 6 | 0 | CHAR | (N' ') | No | TCACS_APPLDEF | CACSAPPL | Allow NULL? |
| 3 | CTGTTYPE | Target Agreements: Complex Target Type | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CACS_TGTTYPE | Allow NULL? |
| 4 | VERSION | Version of Master Data or Customizing Object | nvarchar | 6 | 0 | NUMC | (N'000000') | No | | CACSVERSION | Allow NULL? |
| 5 | CATEG | Target Agreement: Target Category | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCACS_TGC | CACS_TGTCATEGORY | Allow NULL? |
| 6 | TRGCAS_TYPE | Reason for Additional Commission Case Being Triggered | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | V_TCACS_TRCASESS | CACS_TRGCAS_TYPE | Allow NULL? |
| 7 | OBJTYPE | Triggering Subobject Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | TCACS_OBJTYPES | CACSTRIOBJ | Allow NULL? |
| 8 | PERRULE | Period Rule | nvarchar | 7 | 0 | CHAR | (N' ') | Yes | | CACSPRDRULE | Allow NULL? |
| 9 | TGTTYPLOCK | Target Agreements: Lock Indicator | char | 1 | 0 | CHAR | (N' ') | Yes | | CACS_TGTLOCKIND | Allow NULL? |
| 10 | GENTGTIND | Tgt Agrmts: Indicator for Generic Classification of Targets | char | 1 | 0 | CHAR | (N' ') | Yes | | CACS_TGTGENTGTIND | Allow NULL? |
| 11 | TEMPLATE_ID | Appraisal Template | nvarchar | 8 | 0 | NUMC | (N'00000000') | Yes | | HAP_TEMPLATE_ID | Allow NULL? |
| 12 | BUSI_BEGIN | Effective from | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACS_BUSITIME_B | Allow NULL? |
| 13 | BUSI_END | Effective Until (Time Stamp: YYYY.MM.DD hh:mm:ss) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACS_BUSITIME_E | Allow NULL? |
| 14 | TECH_BEGIN | Technically Valid From | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACS_TECHTIME_B | Allow NULL? |
| 15 | TECH_END | Technically Valid To (Time Stamp: JJJJ.MM.TT hh:mm:ss) | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACS_TECHTIME_E | Allow NULL? |
| 16 | FLG_CANCEL_OBJ | Indicator: Object is Invalid | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSCANCOBJ | Allow NULL? |
| 17 | FLG_CANCEL_VERS | Indicator: Version is Invalid | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSCANCVERS | Allow NULL? |
| 18 | CHG_TCODE | Transaction in Which the Change Was Made | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | * | CACSCDTC | Allow NULL? |
| 19 | CHG_USR | Last user to change object | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACSCHUSR | Allow NULL? |
| 20 | TRI_METH_TYP | Triggering Method | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSTRIMETHTYP | Allow NULL? |
| 21 | TRI_METH_TARGET | Processing Target of Triggering Method | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSTRIMETHTAR | Allow NULL? |
| 22 | STATUS_VERSION | Object Version Status | char | 1 | 0 | CHAR | (N' ') | Yes | TCACS_VALSTAT1 | CACSSTATUSVERS | Allow NULL? |
| 23 | STATUS_WORK | Object Version Processing Status | char | 1 | 0 | CHAR | (N' ') | Yes | TCACS_VALSTAT1 | CACSSTATUSWORK | Allow NULL? |
