| 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 | POST_YEAR | Assignment Year of Commission Case/Document | nvarchar | 4 | 0 | NUMC | (N'0000') | No | | CACSPSTYEAR | Allow NULL? |
| 3 | DOC_ID | Document Identification | nvarchar | 10 | 0 | CHAR | (N' ') | No | | CACSDOCID | Allow NULL? |
| 4 | REMUN_POS | ID of Remuneration Row for Referenced Document | nvarchar | 4 | 0 | CHAR | (N' ') | No | | CACSREMUNPOS | Allow NULL? |
| 5 | INCENTIVE_BAS | Bonus Basis Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | INCENTIVE_BASIS_VALUE_CUM | |
| 6 | COMM_BAS_VAL | Commission Basis Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACS_CRM_COMMBAS_VALUE_CUM | |
| 7 | GUID | Transaction GUID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CACS_CRM_PROZESS_GUID_32 | Allow NULL? |
| 8 | ITEM_GUID | Transaction GUID | nvarchar | 32 | 0 | CHAR | (N' ') | Yes | | CACS_CRM_PROZESS_GUID_32 | Allow NULL? |
| 9 | CURRENCY | Currency | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | * | CACS_CRM_CURRENCY | Allow NULL? |
| 10 | COMM_TRI_DATE | Date of Commission Run Start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CACS_CRM_COMMISS_TRIGGER_DATE | Allow NULL? |
| 11 | ZZSALESVALUE | Sales Value | decimal | 15 | 2 | CURR | ((0)) | Yes | | ZZSALESVALUE | |
| 12 | ZZCONTRNR | Contract Number (YTEL05) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ZZCONTRNR | Allow NULL? |
| 13 | ZZCUSTOMER | Customer (YTEL05) | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | ZZCUSTOMER | Allow NULL? |
| 14 | ZZTRAFICMMS | Traffic MMS (YTEL05) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ZZTRAFICMMS | Allow NULL? |
| 15 | ZZTRAFICSMS | Traffic SMS (YTEL05) | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | ZZTRAFICSMS | Allow NULL? |
| 16 | ZZTRAFICKB | Traffic KiloByte (YTEL05) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | ZZTRAFICKB | Allow NULL? |
| 17 | ZZTRAFICMIN | Traffic Minutes (YTEL05) | nvarchar | 6 | 0 | CHAR | (N' ') | Yes | | ZZTRAFICMIN | Allow NULL? |
| 18 | ZZTRAFICTYPE | Traffic Type (YTEL05) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ZZTRAFICTYPE | Allow NULL? |
| 19 | ZZRATEPLAN | Rateplan (YTEL05) | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | ZZRATEPLAN | Allow NULL? |
| 20 | CTRTBU_ID_GRP | Group Contract of Partnership | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACS_CTRTBU_ID_GRP | Allow NULL? |
| 21 | FLG_GROUP_RESP | Responsible Party in Partnership | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSFLGGROUPRESP | Allow NULL? |
| 22 | SHARE_POS | Identification of a Share in a Participation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSSHAREPOS | Allow NULL? |
| 23 | FLG_COMPL | Indicator: Document Part Created by Complete Update | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSFLGCOMPL | Allow NULL? |
| 24 | FLG_REVERSED | Indicator: Row/Object/Subobject is Invalid or Reversed | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSFLGREV | Allow NULL? |
| 25 | STATUS_POS | Status of Object/Subobject | char | 1 | 0 | CHAR | (N' ') | Yes | TCACS_VALSTAT2 | CACSSTATUSPOS | Allow NULL? |
| 26 | STATUS_WORK | Object Processing Status (Replica) | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSSTATUSWORKP | Allow NULL? |
| 27 | PART_POS | Position of Participation in a Commission Case | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSPARTID | Allow NULL? |
| 28 | INV_POS | Participant Position in a Participation | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSINVPOS | Allow NULL? |
| 29 | CTRTBU_ID | Commission Contract Number | nvarchar | 20 | 0 | CHAR | (N' ') | Yes | | CACS_CTRTBU_ID | Allow NULL? |
| 30 | BUCAGR_ID | Agreement Number | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACS_BUCAGR_ID | Allow NULL? |
| 31 | CLAIM_OBJTYPE | Entitlement Object Type | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSCLAIMOBJTYPE | Allow NULL? |
| 32 | CLAIM_OBJID | ID of Entitlement Object Acc. to Entitlement Object Type | nvarchar | 30 | 0 | CHAR | (N' ') | Yes | | CACSCLAIMOBJID | Allow NULL? |
| 33 | REM_IMP_YEAR | Year Commission Case Reported | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CACSIMPYEAR | Allow NULL? |
| 34 | REM_CASE_ID | Identification of a Case Resulting in Remuneration | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CACSREMCASEID | Allow NULL? |
| 35 | REM_CASE_VERS | Commission Case Version | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | CACSCASEVERS | Allow NULL? |
| 36 | POW_OBJ_TYPE | Subobject Type Where Activity Originates | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | CACSPOWOBJ | Allow NULL? |
| 37 | POW_OBJ_ID | Identification of Subobject of Activity Provided | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACSPOWOBJID | Allow NULL? |
| 38 | ACTIVITY | Activity Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CACSACT | Allow NULL? |
| 39 | ACT_POS | Identification of an Activity Line | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSACTPOS | Allow NULL? |
| 40 | ACTGRP | Role | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCACS_ACTGRP | CACSACTGRP | Allow NULL? |
| 41 | REM_OBJ_TYPE | Remunerating Subobject Type | nvarchar | 5 | 0 | CHAR | (N' ') | Yes | * | CACSREMOBJ | Allow NULL? |
| 42 | REM_OBJ_ID | Identification of Subobject Resulting in Remuneration | nvarchar | 12 | 0 | CHAR | (N' ') | Yes | | CACSREMOBJID | Allow NULL? |
| 43 | VALUE | Valuation Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCACS_VAL | CACSVAL | Allow NULL? |
| 44 | VALUE_TYPE | Valuation Result Category | char | 1 | 0 | NUMC | (N'0') | Yes | | CACSVALTYPE | Allow NULL? |
| 45 | VALUE_POS | Valuation Row Identification | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSVALUEPOS | Allow NULL? |
| 46 | REMVAL_LEDAMNT | Remuneration Value in Commission Model Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSREMVALAMNT | |
| 47 | REMVAL_QUAN | Remuneration Value (Volume) | decimal | 11 | 2 | QUAN | ((0)) | Yes | | CACSREMVALQUAN | |
| 48 | VALUE_UNIT | Valuation Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CACSEVALUNIT | Allow NULL? |
| 49 | ROLE | Participant Role | nvarchar | 3 | 0 | CHAR | (N' ') | Yes | TCACS_ROLE | CACSROLE | Allow NULL? |
| 50 | ROLE_REMUSHAR | Share of Remuneration (in Percent) | decimal | 10 | 5 | DEC | ((0)) | Yes | | CACSREMUSHARE | |
| 51 | CONSTELL | Constellation of Participants | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSCONS | Allow NULL? |
| 52 | DIST_TYPE | Remuneration Participation Category | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSDISTTYPE | Allow NULL? |
| 53 | CON_CURR | Contract Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CACSCONCURR | Allow NULL? |
| 54 | LED_CURR | Currency Key | nvarchar | 5 | 0 | CUKY | (N' ') | Yes | TCURC | CACSLEDCURR | Allow NULL? |
| 55 | ALLOCATION | Offsetting Selectn (Excess/Sub-Threshold Earnings, Advances) | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSALLOC | Allow NULL? |
| 56 | REMUNERATION | Remuneration Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCACS_REM | CACSREM | Allow NULL? |
| 57 | REM_VERSION | Version of Master Data or Customizing Object | nvarchar | 6 | 0 | NUMC | (N'000000') | Yes | | CACSVERSION | Allow NULL? |
| 58 | REM_RATE | Remuneration Record (For Example, Percentage) | decimal | 8 | 3 | DEC | ((0)) | Yes | | CACSREMRATE | |
| 59 | REM_CONAMNT | Remuneration Entitlement, Amount in Contract Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSREMUCONAMNT | |
| 60 | DUE_CONAMNT | Remuneration Amount Ready for Disbursement in Contr Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSDUECONAMNT | |
| 61 | REM_LEDAMNT | Remunerat. Entitlement, Amount in Commission Model Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSREMULEDAMNT | |
| 62 | DUE_LEDAMNT | Disbursable Partial Remuner.Amount in Comm. Model Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSDUELEDAMNT | |
| 63 | REM_UNIT | Remuneration Unit | nvarchar | 3 | 0 | UNIT | (N' ') | Yes | * | CACSREMUUNIT | Allow NULL? |
| 64 | REM_QUAN | Remuneration Entitlement as Quantity | decimal | 11 | 2 | QUAN | ((0)) | Yes | | CACSREMUQUAN | |
| 65 | DUE_QUAN | Remuneration Quantity Ready for Disbursement | decimal | 11 | 2 | QUAN | ((0)) | Yes | | CACSDUEQUAN | |
| 66 | OFFSET_END_DATE | End of Offsetting | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CACSOFFSEDAT | Allow NULL? |
| 67 | OFFSET_RULE_ID | Offsetting Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | TCACS_OFFS | CACSOFFSETRULE | Allow NULL? |
| 68 | OFFSET_CONAMNT | Remaining Offset Amount in Contract Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSOFFSCONAMNT | |
| 69 | OFFSET_LEDAMNT | Offsetting/Secondary Liability Amt Remaining in ComModCurr. | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSOFFSLEDAMNT | |
| 70 | OFFSET_QUAN | Offsetting/Remaining Secondary Liability Quantity | decimal | 11 | 2 | QUAN | ((0)) | Yes | | CACSOFFSQUAN | |
| 71 | RESP_BEGIN_DATE | Liability Start | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CACSRESPBDAT | Allow NULL? |
| 72 | RESP_END_DATE | Liability End | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CACSRESPEDAT | Allow NULL? |
| 73 | RESP_RULE_ID | Liability Type | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | * | CACSRESPRULE | Allow NULL? |
| 74 | RESP_CONAMNT | Remaining Liability Amount in Contract Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSRESPCONAMNT | |
| 75 | RESP_LEDAMNT | Remaining Liability Value in Commission Model Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSRESPLEDAMNT | |
| 76 | RESP_QUAN | Remaining liability Quantity | decimal | 11 | 2 | QUAN | ((0)) | Yes | | CACSRESPQUAN | |
| 77 | RESPVAL_LEDAMNT | Remaining Liability Value in Commission Model Currency | decimal | 15 | 2 | CURR | ((0)) | Yes | | CACSRESPVALAMNT | |
| 78 | RESPVAL_QUAN | Remaining Liability Value (Quantity) | decimal | 11 | 2 | QUAN | ((0)) | Yes | | CACSRESPVALQUAN | |
| 79 | STATUS_RESP | Liability Status | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSSTATUSRESP | Allow NULL? |
| 80 | RESP_RUPT_BEGIN | Date of Interruption Start | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACSRUPTDATE_B | Allow NULL? |
| 81 | RESP_RUPT_END | Date of Required End of Interruption | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACSRUPTDATE_E | Allow NULL? |
| 82 | CORRBY_DOC_ID | Document Used to Correct This Row | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CACSCORRBYDOCID | Allow NULL? |
| 83 | CORRBY_PST_YEAR | Assignment Year Document Used for Correcting Row | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CACSCORRBYPSTYEAR | Allow NULL? |
| 84 | CORRBY_PST_DATE | Posting Date in Commission Case/Comm Doc. (Acknowledgement) | nvarchar | 8 | 0 | DATS | (N'00000000') | Yes | | CACSPSTDAT | Allow NULL? |
| 85 | CORRTO_DOC_ID | ID of Corrected Document | nvarchar | 10 | 0 | CHAR | (N' ') | Yes | | CACSCORRTODOCID | Allow NULL? |
| 86 | CORRTO_PST_YEAR | Assignment Year Document That Corrected This Row | nvarchar | 4 | 0 | NUMC | (N'0000') | Yes | | CACSCORRTOPSTYEAR | Allow NULL? |
| 87 | CORRTO_REMUN_POS | ID of Remuneration Row in Corrected Document | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSCORRTOREMUNPOS | Allow NULL? |
| 88 | FLG_CORR | Indicator: Document Part Created by a Correction | char | 1 | 0 | CHAR | (N' ') | Yes | | CACSFLGCORR | Allow NULL? |
| 89 | SETTLE_GROUP | Settlement Item Grouping in Document | nvarchar | 4 | 0 | CHAR | (N' ') | Yes | | CACSSETTLEGROUP | Allow NULL? |
| 90 | UPD_TIMESTAMP | Last Change of Objects | nvarchar | 14 | 0 | NUMC | (N'00000000000000') | Yes | | CACSUPDTSTMP | Allow NULL? |
